src/db/rest/comment/api_comment.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
27
28
29

CREATE VIEW api.comment AS
	SELECT
		c.id,
		c.user_id,
		c.post_id,
		c.content,
		c.created,
		c.modified
	FROM
		xssbook.comment c
	LEFT JOIN
		xssbook.post p
	ON
		p.id = c.post_id
	LEFT JOIN
		xssbook.user u
	ON
		u.id = c.user_id
	WHERE
		c.deleted <> TRUE AND
		p.deleted <> TRUE AND
		u.deleted <> TRUE
	ORDER BY
		id ASC;

GRANT SELECT ON TABLE api.comment
	TO rest_anon, rest_user;
GRANT SELECT ON TABLE xssbook.comment
	TO rest_anon, rest_user;