summaryrefslogtreecommitdiff
path: root/db/rest/post/api_post_insert.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/rest/post/api_post_insert.sql')
-rw-r--r--db/rest/post/api_post_insert.sql40
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();