ory-am/hydra

View on GitHub
persistence/sql/migrations/20220513000001000002_string_slice_json.postgres.up.sql

Summary

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

UPDATE hydra_client SET redirect_uris_json = cast('["' || REPLACE(redirect_uris,'|','","') || '"]' as jsonb) WHERE redirect_uris <> '[]';
UPDATE hydra_client SET grant_types_json = cast('["' || REPLACE(grant_types,'|','","') || '"]' as jsonb) WHERE grant_types <> '[]';
UPDATE hydra_client SET response_types_json = cast('["' || REPLACE(response_types,'|','","') || '"]' as jsonb) WHERE response_types <> '[]';
UPDATE hydra_client SET audience_json = cast('["' || REPLACE(audience,'|','","') || '"]' as jsonb) WHERE audience <> '[]';
UPDATE hydra_client SET allowed_cors_origins_json = cast('["' || REPLACE(allowed_cors_origins,'|','","') || '"]' as jsonb) WHERE allowed_cors_origins <> '[]';
UPDATE hydra_client SET contacts_json = cast('["' || REPLACE(contacts,'|','","') || '"]' as jsonb) WHERE contacts <> '[]';
UPDATE hydra_client SET request_uris_json = cast('["' || REPLACE(request_uris,'|','","') || '"]' as jsonb) WHERE request_uris <> '[]';
UPDATE hydra_client SET post_logout_redirect_uris_json = cast('["' || REPLACE(post_logout_redirect_uris,'|','","') || '"]' as jsonb) WHERE post_logout_redirect_uris <> '[]';