aboutsummaryrefslogtreecommitdiff
path: root/src/queries.h
diff options
context:
space:
mode:
Diffstat (limited to 'src/queries.h')
-rw-r--r--src/queries.h7
1 files changed, 6 insertions, 1 deletions
diff --git a/src/queries.h b/src/queries.h
index 809d259..6230f41 100644
--- a/src/queries.h
+++ b/src/queries.h
@@ -36,9 +36,14 @@ const char *q_insert_posts_with_id = \
"($1, $2, $3) "
"RETURNING id;";
+const char *q_update_posts = \
+"UPDATE posts "
+"SET title = $1, body = $2, updated_at = NOW() "
+"WHERE id = $3 "
+"RETURNING id;";
+
const char *q_delete_posts = \
"DELETE "
"FROM posts "
"WHERE id = $1 "
"RETURNING id;";
-