Configuring application provider and API gateway environments

DEV, TEST, PROD

-- Insert Environments
INSERT INTO as_environment (environmentid, "name", is_lowest_env, is_prod, entity) VALUES
    ('6855dcfe-49a2-4db2-8127-2ae4f4d76865', 'DEV', true, false, 'APP'),
    ('85b91cd8-1f10-4d7f-8954-909c2f4ba6f1', 'TEST', false, false, 'APP'),
    ('55ec8100-c3f1-4bf7-9352-c47b4317468f', 'PROD', false, true, 'APP')
ON CONFLICT (environmentid) DO UPDATE
SET "name" = EXCLUDED."name",
	is_lowest_env = EXCLUDED.is_lowest_env,
	is_prod = EXCLUDED.is_prod,
	entity = EXCLUDED.entity;

-- Insert Environments
INSERT INTO as_environment (environmentid, "name", is_lowest_env, is_prod, entity) VALUES
     ('9c64453b-2028-40dd-aec2-db12583614ae', 'DEV', true, false, 'API'),
    ('25bd7aed-f4a0-4f4d-a0b3-0a6570eb73c9', 'TEST', false, false, 'API'),
    ('2d68ccc1-792e-46b1-8c91-a8f8a3312651', 'PROD', false, true, 'API')
ON CONFLICT (environmentid) DO UPDATE
SET "name" = EXCLUDED."name",
	is_lowest_env = EXCLUDED.is_lowest_env,
	is_prod = EXCLUDED.is_prod,
	entity = EXCLUDED.entity;
-- Set the hierarchy for the API environments (e.g., DEV → TEST → PROD)	
INSERT INTO as_hierarchy_environment ("source", destination, entity)
VALUES
    ('9c64453b-2028-40dd-aec2-db12583614ae', '25bd7aed-f4a0-4f4d-a0b3-0a6570eb73c9', 'API'),
    ('25bd7aed-f4a0-4f4d-a0b3-0a6570eb73c9', '2d68ccc1-792e-46b1-8c91-a8f8a3312651', 'API')
ON CONFLICT ("source",destination) DO UPDATE
SET "source" = EXCLUDED."source",
	destination = EXCLUDED.destination,
	entity = EXCLUDED.entity;	
-- Set Roles Permissions - Available Operations :["publication","subscription","republication"]	
INSERT INTO as_role_environment (roleid, environmentid, operation)
VALUES
    ('<roleId>', '25bd7aed-f4a0-4f4d-a0b3-0a6570eb73c9', 'publication'),
    ('<roleId>', '2d68ccc1-792e-46b1-8c91-a8f8a3312651', 'subscription'),
    ('<roleId>', '9c64453b-2028-40dd-aec2-db12583614ae', 'republication')
ON CONFLICT (roleid,environmentid,operation) DO UPDATE
SET roleid = EXCLUDED.roleid,
	environmentid = EXCLUDED.environmentid,
	operation = EXCLUDED.operation;