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
|
#include <stdio.h>
#include <zdb.h>
/*
This example demonstrate most of the functionality of libzdb and can be compiled with a C, OBJ-C(++) or a C++ compiler.
Compile: [gcc -std=c99|g++|clang|clang++] -o select select.c -L/<libzdb>/lib -lzdb -I/<libzdb>/include/zdb
*/
int main(void) {
URL_T url = URL_new("sqlite:///tmp/test.db");
ConnectionPool_T pool = ConnectionPool_new(url);
ConnectionPool_start(pool);
Connection_T con = ConnectionPool_getConnection(pool);
TRY
{
Connection_execute(con, "create table if not exists bleach(name varchar(255), created_at timestamp)");
PreparedStatement_T p = Connection_prepareStatement(con, "insert into bleach values (?, ?)");
const char *bleach[] = {
"Ichigo Kurosaki", "Rukia Kuchiki", "Orihime Inoue", "Yasutora \"Chad\" Sado",
"Kisuke Urahara", "Ury\u016b Ishida", "Renji Abarai", 0
};
for (time_t i = 0, t = time(0); bleach[i]; i++) {
PreparedStatement_setString(p, 1, bleach[i]);
PreparedStatement_setTimestamp(p, 2, t + i);
PreparedStatement_execute(p);
}
ResultSet_T r = Connection_executeQuery(con,
"select name, datetime(created_at, 'unixepoch', 'localtime') from bleach");
while (ResultSet_next(r))
printf("%-22s\t %s\n", ResultSet_getString(r, 1), ResultSet_getString(r, 2));
Connection_execute(con, "drop table bleach;");
}
CATCH(SQLException)
{
printf("SQLException -- %s\n", Exception_frame.message);
}
FINALLY
{
Connection_close(con);
}
END_TRY;
ConnectionPool_free(&pool);
URL_free(&url);
}
|
