verify/transaction_type_to_integer.sql


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

-- Verify kakeibo:transaction_type_to_integer on pg

BEGIN;

DO $$
  BEGIN
    ASSERT(SELECT 1
             FROM information_schema.columns 
            WHERE table_name = 'transactions'
              AND table_schema = 'kakeibo'
              AND column_name = 'type'
              AND data_type = 'integer');
  END
$$;

ROLLBACK;