Something went wrong. Try again.
Something went wrong. Try again.
3.3 kB · 89 lines
SQL
at main
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990BEGIN;-- Cache results once; querying inline per-assertion multiplies execution cost by N.CREATE TEMP TABLE _pgfa_func_results AS SELECT * FROM pg_firstAid();CREATE TEMP TABLE _pgfa_view_results AS SELECT * FROM v_pgfirstaid;SELECT plan(18);
SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_func_results WHERE check_name = 'Missing FK Index'), 'Function executes Missing FK Index check');SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_view_results WHERE check_name = 'Missing FK Index'), 'View executes Missing FK Index check');
SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_func_results WHERE check_name = 'Idle Connections Over 1 Hour'), 'Function executes Idle Connections Over 1 Hour check');SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_view_results WHERE check_name = 'Idle Connections Over 1 Hour'), 'View executes Idle Connections Over 1 Hour check');
SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_func_results WHERE check_name = 'Table With Single Or No Columns'), 'Function executes Table With Single Or No Columns check');SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_view_results WHERE check_name = 'Table With Single Or No Columns'), 'View executes Table With Single Or No Columns check');
SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_func_results WHERE check_name = 'Table With No Activity Since Stats Reset'), 'Function executes Table With No Activity Since Stats Reset check');SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_view_results WHERE check_name = 'Table With No Activity Since Stats Reset'), 'View executes Table With No Activity Since Stats Reset check');
SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_func_results WHERE check_name = 'Role Never Logged In'), 'Function executes Role Never Logged In check');SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_view_results WHERE check_name = 'Role Never Logged In'), 'View executes Role Never Logged In check');
SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_func_results WHERE check_name = 'Index With Very Low Usage'), 'Function executes Index With Very Low Usage check');SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_view_results WHERE check_name = 'Index With Very Low Usage'), 'View executes Index With Very Low Usage check');
SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_func_results WHERE check_name = 'Empty Table'), 'Function executes Empty Table check');SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_view_results WHERE check_name = 'Empty Table'), 'View executes Empty Table check');
SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_func_results WHERE check_name = 'work_mem At Default'), 'Function executes work_mem At Default check');SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_view_results WHERE check_name = 'work_mem At Default'), 'View executes work_mem At Default check');
SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_func_results WHERE check_name = 'Query Duration Logging Disabled'), 'Function executes Query Duration Logging Disabled check');SELECT ok( (SELECT count(*) >= 0 FROM _pgfa_view_results WHERE check_name = 'Query Duration Logging Disabled'), 'View executes Query Duration Logging Disabled check');
SELECT * FROM finish();ROLLBACK;