Remove JSON API

1 files changed, 2 insertions, 15 deletions

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 "