1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
SET client_min_messages TO warning;
--This is for testing functionality of timezone-specific timestamps
SET TIMEZONE TO 'America/Chicago';
-- These 2 calls replace legacy tests for background worker launches (functionality now removed)
SELECT fact_loader.worker();
SELECT fact_loader.worker();
INSERT INTO test.orders (order_id, customer_id, order_date, total)
VALUES ((SELECT MAX(order_id)+1 FROM test.orders) ,5, '2018-07-27', 2500.00);
SELECT test.tick();
-- For some reason queue_table_id seems indeterminate so don't show it
DO $$
BEGIN
IF NOT (SELECT COUNT(1) FROM fact_loader.raw_queued_changes(1)) = 24
OR NOT (SELECT COUNT(1) FROM fact_loader.gathered_queued_changes(1)) = 1 THEN
RAISE EXCEPTION '%', 'No worky';
END IF;
END$$;
--Count could be different if we are doing FROMVERSION=1.2 or lower but should be at least 50 (actually should be 66 for 1.2 and 76 for 1.3)
SELECT COUNT(1) > 50 AS got_enough_logs FROM fact_loader.fact_table_refresh_logs;
--Test the auto-pruning
BEGIN;
UPDATE fact_loader.fact_table_refresh_logs SET refresh_attempted_at = refresh_attempted_at - interval '1 year' WHERE messages IS NULL;
INSERT INTO fact_loader.fact_table_refresh_logs (fact_table_refresh_log_id)
VALUES (1000);
SELECT COUNT(1) FROM fact_loader.fact_table_refresh_logs;
ROLLBACK;
--Test support for extension without deps (older tests for version 1.2 are removed as no longer relevant)
BEGIN;
DROP EXTENSION pg_fact_loader CASCADE;
DROP EXTENSION IF EXISTS pglogical_ticker CASCADE;
DROP EXTENSION IF EXISTS pglogical CASCADE;
CREATE EXTENSION pg_fact_loader;
DROP EXTENSION pg_fact_loader;
ROLLBACK;
|
