const char *q_select_entry =
"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, updated_at::DATE, body "
"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_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(), search_vector = TO_TSVECTOR('english', $3) "
"WHERE id = $4 "
"RETURNING id;";

// const char *q_delete_entry =
// "DELETE "
// "FROM entries "
// "WHERE id = $1 "
// "RETURNING id;";