diff options
Diffstat (limited to 'db/rest/post/api_post_insert.sql')
-rw-r--r-- | db/rest/post/api_post_insert.sql | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/db/rest/post/api_post_insert.sql b/db/rest/post/api_post_insert.sql new file mode 100644 index 0000000..9eb200c --- /dev/null +++ b/db/rest/post/api_post_insert.sql @@ -0,0 +1,40 @@ +CREATE FUNCTION _api.post_insert() +RETURNS TRIGGER +LANGUAGE plpgsql VOLATILE +AS $BODY$ +DECLARE + _user_id INTEGER; +BEGIN + _user_id = _api.get_user_id(); + + PERFORM _api.validate_text( + _text => NEW.content, + _column => 'content', + _min => 1, + _max => 4096 + ); + + INSERT INTO admin.post ( + user_id, + content + ) VALUES ( + _user_id, + NEW.content + ); + + RETURN NEW; +END +$BODY$; + +GRANT EXECUTE ON FUNCTION _api.post_insert() + TO rest_user; +GRANT INSERT ON TABLE api.post + TO rest_user; +GRANT INSERT ON TABLE admin.post + TO rest_user; + +CREATE TRIGGER api_post_insert_trgr + INSTEAD OF INSERT + ON api.post + FOR EACH ROW + EXECUTE PROCEDURE _api.post_insert(); |