Something went wrong. Try again.
Something went wrong. Try again.
2.6 kB · 77 lines
SQL
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778BEGIN;SELECT plan(16);
SELECT ok( (SELECT count(*) >= 0 FROM pg_firstAid() WHERE check_name = 'Missing FK Index'), 'Function executes Missing FK Index check');SELECT ok( (SELECT count(*) >= 0 FROM v_pgfirstaid WHERE check_name = 'Missing FK Index'), 'View executes Missing FK Index check');
SELECT ok( (SELECT count(*) >= 0 FROM pg_firstAid() WHERE check_name = 'Idle Connections Over 1 Hour'), 'Function executes Idle Connections Over 1 Hour check');SELECT ok( (SELECT count(*) >= 0 FROM v_pgfirstaid WHERE check_name = 'Idle Connections Over 1 Hour'), 'View executes Idle Connections Over 1 Hour check');
SELECT ok( (SELECT count(*) >= 0 FROM pg_firstAid() WHERE check_name = 'Table With Single Or No Columns'), 'Function executes Table With Single Or No Columns check');SELECT ok( (SELECT count(*) >= 0 FROM v_pgfirstaid WHERE check_name = 'Table With Single Or No Columns'), 'View executes Table With Single Or No Columns check');
SELECT ok( (SELECT count(*) >= 0 FROM pg_firstAid() 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 v_pgfirstaid 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 pg_firstAid() WHERE check_name = 'Role Never Logged In'), 'Function executes Role Never Logged In check');SELECT ok( (SELECT count(*) >= 0 FROM v_pgfirstaid WHERE check_name = 'Role Never Logged In'), 'View executes Role Never Logged In check');
SELECT ok( (SELECT count(*) >= 0 FROM pg_firstAid() WHERE check_name = 'Index With Very Low Usage'), 'Function executes Index With Very Low Usage check');SELECT ok( (SELECT count(*) >= 0 FROM v_pgfirstaid WHERE check_name = 'Index With Very Low Usage'), 'View executes Index With Very Low Usage check');
SELECT ok( (SELECT count(*) >= 0 FROM pg_firstAid() WHERE check_name = 'Empty Table'), 'Function executes Empty Table check');SELECT ok( (SELECT count(*) >= 0 FROM v_pgfirstaid WHERE check_name = 'Empty Table'), 'View executes Empty Table check');
SELECT ok( (SELECT count(*) >= 0 FROM pg_firstAid() WHERE check_name = 'work_mem At Default'), 'Function executes work_mem At Default check');SELECT ok( (SELECT count(*) >= 0 FROM v_pgfirstaid WHERE check_name = 'work_mem At Default'), 'View executes work_mem At Default check');
SELECT * FROM finish();ROLLBACK;