persistence/sql/migrations/20220513000001000007_string_slice_json.postgres.up.sql from ory-am/hydra

persistence/sql/migrations/20220513000001000007_string_slice_json.postgres.up.sql

Summary

Maintainability

Test Coverage

Issues
Source
Stats

Issues

-- Migration generated by the command below; DO NOT EDIT.
-- hydra:generate hydra migrate gen


UPDATE hydra_oauth2_flow SET requested_scope_json = cast('["' || REPLACE(requested_scope,'|','","') || '"]' as jsonb) WHERE requested_scope <> '[]';
UPDATE hydra_oauth2_flow SET requested_at_audience_json = cast('["' || REPLACE(requested_at_audience,'|','","') || '"]' as jsonb) WHERE requested_at_audience <> '[]';
UPDATE hydra_oauth2_flow SET amr_json = cast('["' || REPLACE(amr,'|','","') || '"]' as jsonb) WHERE amr <> '[]';
UPDATE hydra_oauth2_flow SET granted_scope_json = cast('["' || REPLACE(granted_scope,'|','","') || '"]' as jsonb) WHERE granted_scope <> '[]';
UPDATE hydra_oauth2_flow SET granted_at_audience_json = cast('["' || REPLACE(granted_at_audience,'|','","') || '"]' as jsonb) WHERE granted_at_audience <> '[]';