Just keep hacking

1 files changed, 24 insertions, 29 deletions

diff --git a/src/queries.h b/src/queries.h
index c0bd1dc..3956129 100644
--- a/src/queries.h
+++ b/src/queries.h
@@ -1,40 +1,35 @@
 const char *q_select_entry =
-"SELECT id, title, created_at::DATE, body "
+"SELECT id, title, created_at::DATE, updated_at::DATE, body "
 "FROM entries "
 "WHERE id = $1;";
 
 const char *q_select_entries =
-"SELECT id, title, created_at::DATE, body "
+"SELECT id, title, created_at::DATE, updated_at::DATE, body "
 "FROM entries "
 "ORDER BY updated_at DESC;";
 
-const char *q_select_index =
-"SELECT id, title, created_at::DATE, updated_at::DATE "
-"FROM entries "
-"ORDER BY updated_at DESC;";
+// const char *q_insert_entry =
+// "INSERT INTO entries "
+// "(title, body) "
+// "VALUES "
+// "($1, $2) "
+// "RETURNING id;";
 
-const char *q_insert_entry =
-"INSERT INTO entries "
-"(title, body) "
-"VALUES "
-"($1, $2) "
-"RETURNING id;";
+// const char *q_insert_entry_with_id =
+// "INSERT INTO entries "
+// "(id, title, body) "
+// "VALUES "
+// "($1, $2, $3) "
+// "RETURNING id;";
 
-const char *q_insert_entry_with_id =
-"INSERT INTO entries "
-"(id, title, body) "
-"VALUES "
-"($1, $2, $3) "
-"RETURNING id;";
+// const char *q_update_entry =
+// "UPDATE entries "
+// "SET title = $1, body = $2, updated_at = NOW() "
+// "WHERE id = $3 "
+// "RETURNING id;";
 
-const char *q_update_entry =
-"UPDATE entries "
-"SET title = $1, body = $2, updated_at = NOW() "
-"WHERE id = $3 "
-"RETURNING id;";
-
-const char *q_delete_entry =
-"DELETE "
-"FROM entries "
-"WHERE id = $1 "
-"RETURNING id;";
+// const char *q_delete_entry =
+// "DELETE "
+// "FROM entries "
+// "WHERE id = $1 "
+// "RETURNING id;";