-- 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;