Initial release

[websub-hub] / src / db / postgres / sql / topic-get-content-by-id.sql

diff --git a/src/db/postgres/sql/topic-get-content-by-id.sql b/src/db/postgres/sql/topic-get-content-by-id.sql
new file mode 100644 (file)
index 0000000..f603991
--- /dev/null
+++ b/src/db/postgres/sql/topic-get-content-by-id.sql
@@ -0,0 +1,7 @@
+-- topic including content
+SELECT *,
+       extract(epoch FROM lease_seconds_preferred) AS lease_seconds_preferred,
+       extract(epoch FROM lease_seconds_min) AS lease_seconds_min,
+       extract(epoch FROM lease_seconds_max) AS lease_seconds_max
+FROM topic
+WHERE id = $(topicId)