blob: 7f6893c57bdebd4ab989a01edef117bd90d71c88 (
about) (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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;
|