PgTap Schema test

pgtapschematest.sql

BEGIN;
SELECT plan(15);

SELECT columns_are( 'flock_payments', 'payments', ARRAY[
  'id',
  'policy_id'
]);

SELECT triggers_are( 'flock_payments', 'payments', ARRAY[]::text[]);
SELECT indexes_are( 'flock_payments', 'payments', ARRAY['payments_pkey']);
SELECT index_is_primary('flock_payments', 'payments', 'policies_pkey');
SELECT has_index('flock_payments', 'payments', 'policies_pkey', ARRAY['id']);

SELECT col_is_pk('flock_payments', 'payments', 'id');
SELECT col_isnt_pk('flock_payments', 'payments', 'policy_id');

SELECT col_isnt_fk('flock_payments', 'payments', 'id');

SELECT fk_ok('flock_payments', 'payments', 'policy_id', 'flock_policies', 'policies', 'id');

SELECT col_type_is('flock_payments', 'payments', 'id', 'bigint');
SELECT col_type_is('flock_payments', 'payments', 'policy_id', 'bigint');
--
SELECT col_hasnt_default('flock_payments', 'payments', 'id');
SELECT col_hasnt_default('flock_payments', 'payments', 'policy_id');

SELECT col_not_null('flock_payments', 'payments', 'id');
SELECT col_not_null('flock_payments', 'payments', 'policy_id');

SELECT * FROM finish();
ROLLBACK;