1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
-- Deploy node_status_insert
-- requires: node_statuses
BEGIN;
CREATE OR REPLACE FUNCTION goiardi.insert_node_status(m_name text, m_status goiardi.status_node) RETURNS VOID AS
$$
DECLARE
n BIGINT;
BEGIN
SELECT id INTO n FROM goiardi.nodes WHERE name = m_name;
IF NOT FOUND THEN
RAISE EXCEPTION 'aiiie, the node % was deleted while we were doing something else trying to insert a status', m_name;
END IF;
INSERT INTO goiardi.node_statuses (node_id, status, updated_at) VALUES (n, m_status, NOW());
RETURN;
END;
$$
LANGUAGE plpgsql;
COMMIT;
|
