select_booking: year, month, day

1 files changed, 18 insertions, 6 deletions

diff --git a/select_booking.c b/select_booking.c
index 4eaadcb..19547d8 100644
--- a/select_booking.c
+++ b/select_booking.c
@@ -14,12 +14,15 @@ main(void)
 		errx(1, "sqlite3_open: %s", sqlite3_errmsg(db));
 
 	const char *sql = "SELECT "
-			  "datetime(start, 'unixepoch'), "
-			  "datetime(end, 'unixepoch'), "
-			  "(end-start)/60/60, "
+			  "CAST(strftime('%Y', start) as INT), "
+			  "CAST(strftime('%m', start) as INT), "
+			  "CAST(strftime('%d', start) as INT), "
+			  "(start), "
+			  "unixepoch(end), "
+			  "timediff(end, start), "
 			  "summary "
 			  "FROM event "
-			  "WHERE unixepoch()-6*3600 < start "
+			  "WHERE datetime('now', 'start of day') < start "
 			  "AND summary IS NOT NULL "
 			  "ORDER BY start";
 	sqlite3_stmt *stmt = NULL;
@@ -33,9 +36,18 @@ main(void)
 		if (SQLITE_ROW != step)
 			errx(1, "sqlite3_step: %s", sqlite3_errmsg(db));
 
-		const unsigned char *summary = sqlite3_column_text(stmt, 3);
+		int sy = sqlite3_column_int(stmt, 0);
+		int sm = sqlite3_column_int(stmt, 1);
+		int sd = sqlite3_column_int(stmt, 2);
+		const unsigned char *start = sqlite3_column_text(stmt, 3);
+		const unsigned char *end = sqlite3_column_text(stmt, 4);
+		const unsigned char *td = sqlite3_column_text(stmt, 5);
+		const unsigned char *summary = sqlite3_column_text(stmt, 6);
+		assert(start);
+		assert(end);
+		assert(td);
 		assert(summary);
-		printf("%s\n", summary);
+		printf("%04d %02d %02d %s %s\n", sy, sm, sd, start, summary);
 	}
 
 	sqlite3_close(db);