From 88b7a0784e0c9e66dad26e0d85ee06ce9f7c59b9 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Sat, 4 Mar 2023 18:40:37 +0900 Subject: Make transaction type integer. --- verify/transaction_type_to_integer.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 verify/transaction_type_to_integer.sql (limited to 'verify') diff --git a/verify/transaction_type_to_integer.sql b/verify/transaction_type_to_integer.sql new file mode 100644 index 0000000..808d5df --- /dev/null +++ b/verify/transaction_type_to_integer.sql @@ -0,0 +1,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; -- cgit v1.2.3