Mustafa Sencer Özcan
4c5d9cb95f
* fix: add type * feat: register step * feat: add playlist support * test: add test case * fix: gen mock * fix: go gen * fix: lint * fix: lint * fix: tests * fix: add resource * fix: readd * fix: address comments * fix: independent playlist query for migrations * fix: remove lock logic for sqlite * fix: handle creation and update datetimes * fix: query templating * fix: simply resources and address comments
18 lines
383 B
SQL
18 lines
383 B
SQL
SELECT
|
|
p.id,
|
|
p.org_id,
|
|
p.uid,
|
|
p.name,
|
|
p.interval,
|
|
p.created_at,
|
|
p.updated_at,
|
|
pi.type as item_type,
|
|
pi.value as item_value
|
|
FROM
|
|
{{ .Ident .PlaylistTable }} as p
|
|
LEFT OUTER JOIN {{ .Ident .PlaylistItemTable }} as pi ON p.id = pi.playlist_id
|
|
WHERE
|
|
p.org_id = {{ .Arg .Query.OrgID }}
|
|
ORDER BY
|
|
p.id ASC,
|
|
pi.{{ .Ident "order" }} ASC |