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() " // "WHERE id = $3 " // "RETURNING id;"; // const char *q_delete_entry = // "DELETE " // "FROM entries " // "WHERE id = $1 " // "RETURNING id;";