verify/transaction_type.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

-- Verify kakeibo:transaction_type on pg

BEGIN;

DO $$
  DECLARE
    type_count INTEGER;
  BEGIN
    SELECT COUNT(*) INTO type_count FROM pg_type where typname = 'transaction_type';
    ASSERT type_count = 0;
  END
$$;

ROLLBACK;