From 4bfab86f636f2392f92037058c783c2634ac2060 Mon Sep 17 00:00:00 2001 From: Michael McVady Date: Sun, 15 Jan 2023 14:01:59 -0600 Subject: Hack in DELETE method without testing --- src/queries.h | 22 ++++++++++++++++++---- 1 file changed, 18 insertions(+), 4 deletions(-) (limited to 'src/queries.h') diff --git a/src/queries.h b/src/queries.h index cae7d59..108b249 100644 --- a/src/queries.h +++ b/src/queries.h @@ -1,23 +1,37 @@ -const char *query_html_post = \ +const char *q_select_html_post = \ "SELECT id, title, created_at::DATE, body " "FROM posts " "WHERE id = $1;"; -const char *query_html_posts = \ +const char *q_select_html_posts = \ "SELECT id, title, created_at::DATE, body " "FROM posts " "ORDER BY updated_at DESC;"; -const char *query_json_post = \ +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 *query_json_posts = \ +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 " +"(id, title, body) " +"VALUES " +"($1, $2, $3) " +"RETURNING id;"; + +const char *q_delete_posts = \ +"DELETE " +"FROM posts " +"WHERE id = $1 " +"RETURNING id;"; + -- cgit v1.2.3