diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-12 16:23:41 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-12 23:38:12 +0900 |
commit | 1a838c115140bdf0f35054351153fb21f2a228da (patch) | |
tree | 598cae31e6b2cbeab53a84dd46a1e62ca7f0b9df /verify/insert_transaction.sql | |
parent | cd23d52c0c5c3d3264c5a8706c2c6fe2b1649640 (diff) |
Add function to create new transaction.
Diffstat (limited to 'verify/insert_transaction.sql')
-rw-r--r-- | verify/insert_transaction.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/verify/insert_transaction.sql b/verify/insert_transaction.sql new file mode 100644 index 0000000..7f6893c --- /dev/null +++ b/verify/insert_transaction.sql @@ -0,0 +1,26 @@ +-- Verify kakeibo:insert_transaction on pg + +BEGIN; + +SELECT has_function_privilege('kakeibo.insert_transaction(INTEGER, DATE, TEXT)', 'EXECUTE'); + +SET search_path = kakeibo; + +DO $$ + DECLARE + v_id INTEGER; + BEGIN + SELECT insert_transaction(0, '2023-03-15', 'テスト') INTO v_id; + PERFORM * + FROM transactions + WHERE id = v_id + AND type_code = 0 + AND date = '2023-03-15' + AND note = 'テスト'; + IF NOT FOUND THEN + RAISE EXCEPTION 'Inserted data is not found.'; + END IF; + END +$$; + +ROLLBACK; |