\c assertion-manager
-- --select value,variable from app_configuration where value like '%http%';
-- update app_configuration set value = 'https://cts-acceptance.ihe-europe.net/gazelle/rest/' where variable = 'gazelle_test-management-url';
-- update app_configuration set value = 'https://cts-acceptance.ihe-europe.net/AssertionManagerGui' where variable = 'application_url';
-- update app_configuration set value = 'https://cts-acceptance.ihe-europe.net/AssertionManagerGui/rest' where variable = 'assertion_manager_rest_url';
-- update app_configuration set value = 'https://cts-acceptance.ihe-europe.net/docs/user_guides/UserGuide-AssertionManager.pdf' where variable = 'documentation_url';

UPDATE am_assertions_applies_to set linked_entity_provider='https://cts-acceptance.ihe-europe.net/gazelle';
UPDATE am_assertions_applies_to set linked_entity_permalink=replace(linked_entity_permalink,'https://ehealthsuisse.ihe-europe.net/','https://cts-acceptance.ihe-europe.net/');
UPDATE am_assertions_links set linked_entity_permalink=replace(linked_entity_permalink,'https://ehealthsuisse.ihe-europe.net/','https://cts-acceptance.ihe-europe.net/');
update am_oasis_ref_source_item set uri=replace(uri,'https://ehealthsuisse.ihe-europe.net/','https://cts-acceptance.ihe-europe.net/')  where uri like 'https://ehealthsuisse.ihe-europe.net/%';
UPDATE am_mbv_service set url=replace(url,'https://ehealthsuisse.ihe-europe.net/','https://cts-acceptance.ihe-europe.net/');

\c pam-simulator
--select value,variable from app_configuration where value like '%http%';
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
update system_configuration set url = replace(url, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

-- \c gazelle-hl7-validator
-- --select value,variable from app_configuration where value like '%http%';
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

-- \c svs-simulator
-- --select value,variable from app_configuration where value like '%http%';
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
--
-- \c gss
-- --select value,variable from app_configuration where value like '%http%';
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

\c gazelle
--select preference_value,preference_name from cmn_application_preference where preference_value like '%http%';
-- update cmn_application_preference set preference_value = replace(preference_value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

-- select url from tm_test_roles where url is not null and url != '';
update tm_test_roles set url = replace(url, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net') where url != '';

-- select url_doc from tm_test_roles where url_doc is not null and url_doc != '';
update tm_test_roles set url_doc = 'https://cts-acceptance.ihe-europe.net/gazelle-documentation' where url_doc is not null and url_doc != '';

-- update URL which are set in test description
update tm_test_description set description = replace(description, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
update tm_test_description_aud set description = replace(description, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

-- \c demographic-data-server
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

\c gazelle-webservice-tester
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
update gwt_custom_property set default_value = replace(default_value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

\c evs-client-prod
-- update cmn_application_preference set preference_value = replace(preference_value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
update evsc_validation_service set wsdl = replace(wsdl, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
update evsc_calling_tool set url = replace(url, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
update evsc_validation_service set xsl_location = replace(xsl_location, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

-- \c gazelle-fhir-validator
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
--
-- \c cda-generator
-- update cmn_application_preference set preference_value = replace(preference_value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

\c hpd-simulator
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
update system_configuration set url = replace(url, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

\c svs-simulator
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
update system_configuration set url = replace(url, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

\c xdstar-client
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
update system_configuration set url = replace(url, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

-- \c schematron-validator-prod
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');

-- \c authentication-simulator
-- update app_configuration set value = replace(value, 'https://ehealthsuisse.ihe-europe.net', 'https://cts-acceptance.ihe-europe.net');
-- update app_configuration set value = replace(value, 'ehealthsuisse.ihe-europe.net', 'cts-acceptance.ihe-europe.net') where variable = 'idp_adapter_wsdl_endpoint';

