From 03eafcbb94df67484e80480f30660022e7142608 Mon Sep 17 00:00:00 2001 From: Michael McVady Date: Mon, 2 Jan 2023 20:11:22 -0600 Subject: Clean up query logic --- src/queries.h | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 src/queries.h (limited to 'src/queries.h') 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;"; -- cgit v1.2.3