1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
#include <assert.h>
#include <err.h>
#include <stdio.h>
#include "sqlite/sqlite3.h"
int
main(int argc, const char *argv[static argc])
{
if (2 != argc)
errx(1, "usage: %s dbfile", argv[0]);
sqlite3 *db;
if (sqlite3_open(argv[1], &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);
}
|
