1.10. 요약 프로세스 수동 실행

oc exec -it multicluster-global-hub-postgres-0 -n multicluster-global-hub -- psql -d hoh

oc exec -it multicluster-global-hub-postgres-0 -n multicluster-global-hub -- psql -d hoh

select * from history.local_compliance_view_2023_07_06;

select * from history.local_compliance_view_2023_07_06;

-- exec the insert func for that day '2023_07_06'
SELECT history.insert_local_compliance_job('2023_07_06');

-- exec the insert func for that day '2023_07_06'
SELECT history.insert_local_compliance_job('2023_07_06');

-- call the func to generate the data of '2023_07_06' by inheriting '2023_07_05'
CALL history.inherit_local_compliance_job('2023_07_05', '2023_07_06');

-- call the func to generate the data of '2023_07_06' by inheriting '2023_07_05'
CALL history.inherit_local_compliance_job('2023_07_05', '2023_07_06');

-- call the func to update records start with '2023-07-06', end with '2023-07-07'
SELECT history.update_local_compliance_job('2023_07_06', '2023_07_07');

-- call the func to update records start with '2023-07-06', end with '2023-07-07'
SELECT history.update_local_compliance_job('2023_07_06', '2023_07_07');

DROP MATERIALIZED VIEW IF EXISTS history.local_compliance_view_2023_07_06;

DROP MATERIALIZED VIEW IF EXISTS history.local_compliance_view_2023_07_06;