diff options
| author | Freya Murphy <freya@freyacat.org> | 2024-05-20 17:11:38 -0400 |
|---|---|---|
| committer | Freya Murphy <freya@freyacat.org> | 2024-05-20 17:11:38 -0400 |
| commit | 708594d32ffe779cf547c816fa7cdd19d095be2e (patch) | |
| tree | 30d28553316db02bc027664e17b76d58f2e352ff /src/db/rest/media/api_delete_user_media.sql | |
| parent | add en_CAT makefile and use ucfirst/ucwords (diff) | |
| download | xssbook2-708594d32ffe779cf547c816fa7cdd19d095be2e.tar.gz xssbook2-708594d32ffe779cf547c816fa7cdd19d095be2e.tar.bz2 xssbook2-708594d32ffe779cf547c816fa7cdd19d095be2e.zip | |
v2 done
Diffstat (limited to 'src/db/rest/media/api_delete_user_media.sql')
| -rw-r--r-- | src/db/rest/media/api_delete_user_media.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/src/db/rest/media/api_delete_user_media.sql b/src/db/rest/media/api_delete_user_media.sql new file mode 100644 index 0000000..d9a4529 --- /dev/null +++ b/src/db/rest/media/api_delete_user_media.sql @@ -0,0 +1,26 @@ +CREATE FUNCTION api.delete_user_media( + media_type admin.user_media_type +) +RETURNS void +LANGUAGE plpgsql VOLATILE +AS $BODY$ +DECLARE + _user_id INTEGER; + _data BYTEA; +BEGIN + _user_id = _api.get_user_id(); + + DELETE FROM + admin.user_media + WHERE + "type" = media_type AND + "user_id" = _user_id; +END +$BODY$; + +GRANT EXECUTE ON FUNCTION api.delete_user_media(admin.user_media_type) + TO rest_user; +GRANT DELETE ON TABLE admin.user_media + TO rest_user; +GRANT UPDATE ON TABLE sys.user_media_id_seq + TO rest_user; |