ory-am/hydra

View on GitHub
persistence/sql/migrations/20220513000001000001_string_slice_json.mysql.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(concat('["' ,  REPLACE(redirect_uris,'|','","') ,  '"]') as json) WHERE redirect_uris <> '';
UPDATE hydra_client SET grant_types_json =  cast(concat('["' ,  REPLACE(grant_types,'|','","') ,  '"]') as json) WHERE grant_types <> '';
UPDATE hydra_client SET response_types_json =  cast(concat('["' ,  REPLACE(response_types,'|','","') ,  '"]') as json) WHERE response_types <> '';
UPDATE hydra_client SET audience_json =  cast(concat('["' ,  REPLACE(audience,'|','","') ,  '"]') as json) WHERE audience <> '';
UPDATE hydra_client SET allowed_cors_origins_json =  cast(concat('["' ,  REPLACE(allowed_cors_origins,'|','","') ,  '"]') as json) WHERE allowed_cors_origins <> '';
UPDATE hydra_client SET contacts_json =  cast(concat('["' ,  REPLACE(contacts,'|','","') ,  '"]') as json) WHERE contacts <> '';
UPDATE hydra_client SET request_uris_json =  cast(concat('["' ,  REPLACE(request_uris,'|','","') ,  '"]') as json) WHERE request_uris <> '';
UPDATE hydra_client SET post_logout_redirect_uris_json =  cast(concat('["' ,  REPLACE(post_logout_redirect_uris,'|','","') ,  '"]') as json) WHERE post_logout_redirect_uris <> '';