Clean up query logic

1 files changed, 23 insertions, 0 deletions

diff --git a/src/queries.h b/src/queries.h
new file mode 100644
index 0000000..cae7d59
--- /dev/null
+++ b/src/queries.h
@@ -0,0 +1,23 @@
+const char *query_html_post = \
+"SELECT id, title, created_at::DATE, body "
+"FROM posts "
+"WHERE id = $1;";
+
+const char *query_html_posts = \
+"SELECT id, title, created_at::DATE, body "
+"FROM posts "
+"ORDER BY updated_at DESC;";
+
+const char *query_json_post = \
+"SELECT JSON_AGG(ROW_TO_JSON(row)) FROM ("
+	"SELECT id, title, body, created_at, updated_at "
+	"FROM posts "
+	"WHERE id = $1"
+") row;";
+
+const char *query_json_posts = \
+"SELECT JSON_AGG(ROW_TO_JSON(row)) FROM ("
+	"SELECT id, title, body, created_at, updated_at "
+	"FROM posts "
+	"ORDER BY updated_at DESC"
+") row;";