generic select_booking -> select

1 files changed, 0 insertions, 54 deletions

diff --git a/select_booking.c b/select_booking.c
deleted file mode 100644
index f8cf595..0000000
--- a/select_booking.c
+++ /dev/null
@@ -1,54 +0,0 @@
-#include <assert.h>
-#include <err.h>
-#include <stdio.h>
-
-#include "sqlite/sqlite3.h"
-
-static const char *DATABASE = "booking.db";
-
-int
-main(void)
-{
-	sqlite3 *db;
-	if (sqlite3_open(DATABASE, &db))
-		errx(1, "sqlite3_open: %s", sqlite3_errmsg(db));
-
-	const char *sql = "SELECT "
-			  "CAST(strftime('%Y', start, 'localtime') as INT), "
-			  "CAST(strftime('%m', start, 'localtime') as INT), "
-			  "CAST(strftime('%d', start, 'localtime') as INT), "
-			  "(start), "
-			  "unixepoch(end), "
-			  "timediff(end, start), "
-			  "summary "
-			  "FROM event "
-			  "WHERE datetime('now', 'start of day') < start "
-			  "AND summary IS NOT NULL "
-			  "ORDER BY start";
-	sqlite3_stmt *stmt = NULL;
-	if (sqlite3_prepare_v2(db, sql, -1, &stmt, NULL))
-		errx(1, "sqlite3_prepare_v2: %s", sqlite3_errmsg(db));
-
-	for (;;) {
-		int step = sqlite3_step(stmt);
-		if (SQLITE_DONE == step)
-			break;
-		if (SQLITE_ROW != step)
-			errx(1, "sqlite3_step: %s", sqlite3_errmsg(db));
-
-		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("%04d %02d %02d %s %s\n", sy, sm, sd, start, summary);
-	}
-
-	sqlite3_close(db);
-}