From a997ec6727b467fd72510a56bfe7a67eb04dbcf9 Mon Sep 17 00:00:00 2001 From: Michael McVady Date: Thu, 26 Oct 2023 23:29:11 -0500 Subject: Remove JSON API --- src/queries.h | 17 ++--------------- 1 file changed, 2 insertions(+), 15 deletions(-) (limited to 'src/queries.h') diff --git a/src/queries.h b/src/queries.h index 2334874..ffc9c7b 100644 --- a/src/queries.h +++ b/src/queries.h @@ -1,26 +1,13 @@ -const char *q_select_html_post = +const char *q_select_post = "SELECT id, title, created_at::DATE, body " "FROM posts " "WHERE id = $1;"; -const char *q_select_html_posts = +const char *q_select_posts = "SELECT id, title, created_at::DATE, body " "FROM posts " "ORDER BY updated_at DESC;"; -const char *q_select_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 *q_select_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;"; const char *q_insert_posts = "INSERT INTO posts " -- cgit v1.2.3