deploy/insert_transaction.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

-- Deploy kakeibo:insert_transaction to pg
-- requires: appschema
-- requires: transactions

BEGIN;

CREATE OR REPLACE FUNCTION kakeibo.insert_transaction(
  p_type INTEGER,
  p_date DATE,
  p_note TEXT
) RETURNS INTEGER AS $$
DECLARE
  inserted_id INTEGER;
BEGIN
  INSERT INTO kakeibo.transactions (
    type_code, date, note
  ) VALUES (
    p_type, p_date, p_note
  ) RETURNING id INTO inserted_id;
  RETURN inserted_id;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;

COMMIT;