-- Deploy jmp:invite_per_15 to pg
-- requires: transactions
-- requires: invites
BEGIN;
CREATE OR REPLACE FUNCTION insert_invites_per() RETURNS TRIGGER AS
$insert_invites_per$
BEGIN
FOR i IN 1..(NEW.amount::int / TG_ARGV[0]::int) LOOP
INSERT INTO invites (creator_id) VALUES (NEW.customer_id);
END LOOP;
RETURN NEW;
END;
$insert_invites_per$ LANGUAGE plpgsql;
CREATE TRIGGER invite_per_15
AFTER INSERT ON transactions
FOR EACH ROW
WHEN (NEW.amount >= 15)
EXECUTE PROCEDURE insert_invites_per(15);
COMMIT;