src/db/rest/media/api_delete_user_media.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

CREATE FUNCTION api.delete_user_media(
	media_type xssbook.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
		xssbook.user_media
	WHERE
		"type" = media_type AND
		"user_id" = _user_id;
END
$BODY$;

GRANT EXECUTE ON FUNCTION api.delete_user_media(xssbook.user_media_type)
	TO rest_user;
GRANT DELETE ON TABLE xssbook.user_media
	TO rest_user;
GRANT UPDATE ON TABLE sys.user_media_id_seq
	TO rest_user;