author | Tero Marttila <terom@fixme.fi> |
Sat, 13 Dec 2008 19:55:50 +0200 | |
branch | new-evsql |
changeset 53 | 0d6e07f4c9a1 |
parent 47 | 8c6c459eacb7 |
permissions | -rw-r--r-- |
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
1 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
2 |
#include "evsql.h" |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
3 |
#include "lib/log.h" |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
4 |
#include "lib/signals.h" |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
5 |
#include "lib/misc.h" |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
6 |
|
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
7 |
#include <event2/event.h> |
46 | 8 |
#include <event2/event_struct.h> |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
9 |
#include <assert.h> |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
10 |
|
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
11 |
#define CONNINFO_DEFAULT "dbname=dbfs port=5433" |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
12 |
|
46 | 13 |
struct evsql_test_ctx { |
14 |
struct evsql *db; |
|
15 |
struct evsql_trans *trans; |
|
16 |
}; |
|
17 |
||
18 |
// forward-declare |
|
19 |
void query_send (struct evsql *db, struct evsql_trans *trans); |
|
20 |
||
21 |
||
22 |
void query_timer (int fd, short what, void *arg) { |
|
23 |
struct evsql *db = arg; |
|
24 |
||
25 |
INFO("[evsql_test.timer] *tick*"); |
|
26 |
||
27 |
query_send(db, NULL); |
|
28 |
} |
|
29 |
||
30 |
void query_start (struct event_base *base, struct evsql *db) { |
|
31 |
static struct event ev; |
|
32 |
struct timeval tv = { 5, 0 }; |
|
33 |
||
34 |
evperiodic_assign(&ev, base, &tv, &query_timer, db); |
|
35 |
event_add(&ev, &tv); |
|
36 |
||
37 |
INFO("[evsql_test.timer_start] started timer"); |
|
38 |
} |
|
39 |
||
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
40 |
void query_results (struct evsql_result *result, void *arg) { |
46 | 41 |
struct evsql *db = arg; |
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
42 |
uint32_t val; |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
43 |
|
46 | 44 |
(void) db; |
45 |
||
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
46 |
static struct evsql_result_info result_info = { |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
47 |
0, { |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
48 |
{ EVSQL_FMT_BINARY, EVSQL_TYPE_UINT32 }, |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
49 |
{ 0, 0 } |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
50 |
} |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
51 |
}; |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
52 |
|
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
53 |
// begin |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
54 |
assert(evsql_result_begin(&result_info, result) == 0); |
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
55 |
|
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
56 |
// one row |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
57 |
assert(evsql_result_next(result, |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
58 |
&val |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
59 |
) > 0); |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
60 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
61 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
62 |
INFO("[evsql_test.results] got result: %p: val=%lu", result, (unsigned long) val); |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
63 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
64 |
// done |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
65 |
evsql_result_end(result); |
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
66 |
} |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
67 |
|
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
68 |
void query_send (struct evsql *db, struct evsql_trans *trans) { |
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
69 |
struct evsql_query *query = NULL; |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
70 |
static int query_id = 0; |
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
71 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
72 |
static struct evsql_query_info query_info = { |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
73 |
.sql = "SELECT $1::int4 + 5", |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
74 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
75 |
.params = { |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
76 |
{ EVSQL_FMT_BINARY, EVSQL_TYPE_UINT32 }, |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
77 |
{ 0, 0 } |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
78 |
} |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
79 |
}; |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
80 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
81 |
// query |
46 | 82 |
if ((query = evsql_query_exec(db, trans, &query_info, query_results, db, |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
83 |
(uint32_t) ++query_id |
46 | 84 |
)) == NULL) |
85 |
WARNING("evsql_query_exec failed"); |
|
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
86 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
87 |
INFO("[evsql_test.query_send] enqueued query, trans=%p: %p: %d", trans, query, query_id); |
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
88 |
} |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
89 |
|
47
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
90 |
void trans_commit (struct evsql_test_ctx *ctx) { |
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
91 |
if (evsql_trans_commit(ctx->trans)) |
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
92 |
FATAL("evsql_trans_commit failed"); |
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
93 |
|
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
94 |
INFO("[evsql_test.trans_commit] commiting transaction"); |
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
95 |
} |
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
96 |
|
46 | 97 |
void trans_insert_result (struct evsql_result *res, void *arg) { |
98 |
struct evsql_test_ctx *ctx = arg; |
|
99 |
err_t err; |
|
100 |
||
101 |
// the result info |
|
102 |
uint32_t id; |
|
103 |
const char *str; |
|
104 |
||
105 |
static struct evsql_result_info result_info = { |
|
106 |
0, { |
|
107 |
{ EVSQL_FMT_BINARY, EVSQL_TYPE_UINT32 }, |
|
108 |
{ EVSQL_FMT_BINARY, EVSQL_TYPE_STRING }, |
|
109 |
{ 0, 0 } |
|
110 |
} |
|
111 |
}; |
|
112 |
||
113 |
// begin |
|
114 |
if ((err = evsql_result_begin(&result_info, res))) |
|
115 |
EFATAL(err, "query failed%s", err == EIO ? evsql_result_error(res) : ""); |
|
116 |
||
117 |
INFO("[evsql_test.insert] got %zu rows:", evsql_result_rows(res)); |
|
118 |
||
119 |
// iterate over rows |
|
120 |
while ((err = evsql_result_next(res, &id, &str)) > 0) { |
|
121 |
INFO("\t%-4lu %s", (unsigned long) id, str); |
|
122 |
} |
|
123 |
||
124 |
if (err) |
|
125 |
EFATAL(err, "evsql_result_next failed"); |
|
126 |
||
127 |
INFO("\t(done)"); |
|
128 |
||
129 |
// done |
|
130 |
evsql_result_end(res); |
|
47
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
131 |
|
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
132 |
// commit the transaction |
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
133 |
trans_commit(ctx); |
46 | 134 |
} |
135 |
||
136 |
void trans_insert (struct evsql_test_ctx *ctx) { |
|
137 |
struct evsql_query *query = NULL; |
|
138 |
||
139 |
// the query info |
|
140 |
static struct evsql_query_info query_info = { |
|
141 |
.sql = "INSERT INTO evsql_test (str) VALUES ($1::varchar), ($2::varchar) RETURNING id, str", |
|
142 |
||
143 |
.params = { |
|
144 |
{ EVSQL_FMT_BINARY, EVSQL_TYPE_STRING }, |
|
145 |
{ EVSQL_FMT_BINARY, EVSQL_TYPE_STRING }, |
|
146 |
{ 0, 0 } |
|
147 |
} |
|
148 |
}; |
|
149 |
||
150 |
// run the query |
|
151 |
assert((query = evsql_query_exec(ctx->db, ctx->trans, &query_info, trans_insert_result, ctx, |
|
152 |
(const char *) "row A", |
|
153 |
(const char *) "row B" |
|
154 |
)) != NULL); |
|
155 |
||
156 |
INFO("[evsql_test.insert] enqueued query: %p", query); |
|
157 |
} |
|
158 |
||
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
159 |
void trans_create_result (struct evsql_result *res, void *arg) { |
46 | 160 |
struct evsql_test_ctx *ctx = arg; |
161 |
||
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
162 |
// check |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
163 |
if (evsql_result_check(res)) |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
164 |
FATAL("query failed: %s", evsql_result_error(res)); |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
165 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
166 |
INFO("[evsql_test.create_result] table created succesfully: %p", res); |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
167 |
|
46 | 168 |
// free result |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
169 |
evsql_result_free(res); |
46 | 170 |
|
171 |
// insert |
|
172 |
trans_insert(ctx); |
|
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
173 |
} |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
174 |
|
46 | 175 |
void trans_create_query (struct evsql_test_ctx *ctx) { |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
176 |
struct evsql_query *query = NULL; |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
177 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
178 |
// the query info |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
179 |
static struct evsql_query_info query_info = { |
46 | 180 |
.sql = "CREATE TEMPORARY TABLE evsql_test ( id serial4, str varchar(32) DEFAULT 'foobar' ) ON COMMIT DROP", |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
181 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
182 |
.params = { |
46 | 183 |
// { EVSQL_FMT_BINARY, EVSQL_TYPE_STRING }, |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
184 |
{ 0, 0, } |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
185 |
} |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
186 |
}; |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
187 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
188 |
// run the query |
46 | 189 |
assert((query = evsql_query_exec(ctx->db, ctx->trans, &query_info, trans_create_result, ctx |
190 |
// (const char *) "foobar" |
|
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
191 |
)) != NULL); |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
192 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
193 |
INFO("[evsql_test.trans_create_query] enqueued query: %p", query); |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
194 |
} |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
195 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
196 |
void trans_error (struct evsql_trans *trans, void *arg) { |
46 | 197 |
struct evsql_test_ctx *ctx = arg; |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
198 |
|
47
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
199 |
FATAL("[evsql_test.trans_error] failure: trans=%p: %s", ctx->trans, evsql_trans_error(trans)); |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
200 |
} |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
201 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
202 |
void trans_ready (struct evsql_trans *trans, void *arg) { |
46 | 203 |
struct evsql_test_ctx *ctx = arg; |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
204 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
205 |
INFO("[evsql_test.trans_ready] ready"); |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
206 |
|
46 | 207 |
trans_create_query(ctx); |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
208 |
} |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
209 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
210 |
void trans_done (struct evsql_trans *trans, void *arg) { |
46 | 211 |
struct evsql_test_ctx *ctx = arg; |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
212 |
|
47
8c6c459eacb7
fix evsql_trans_commit (null arg)
Tero Marttila <terom@fixme.fi>
parents:
46
diff
changeset
|
213 |
INFO("[evsql_test.trans_done] done: trans=%p", ctx->trans); |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
214 |
} |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
215 |
|
46 | 216 |
void begin_transaction (struct evsql_test_ctx *ctx) { |
217 |
assert((ctx->trans = evsql_trans(ctx->db, EVSQL_TRANS_DEFAULT, |
|
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
218 |
&trans_error, &trans_ready, &trans_done, |
46 | 219 |
ctx |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
220 |
)) != NULL); |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
221 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
222 |
INFO("[evsql_test.begin_trans] created transaction"); |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
223 |
} |
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
224 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
225 |
int main (int argc, char **argv) { |
46 | 226 |
struct evsql_test_ctx ctx; |
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
227 |
struct event_base *ev_base = NULL; |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
228 |
struct signals *signals = NULL; |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
229 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
230 |
const char *db_conninfo; |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
231 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
232 |
// parse args |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
233 |
db_conninfo = CONNINFO_DEFAULT; |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
234 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
235 |
// init libevent |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
236 |
if ((ev_base = event_base_new()) == NULL) |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
237 |
ERROR("event_base_new"); |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
238 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
239 |
// setup signals |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
240 |
if ((signals = signals_default(ev_base)) == NULL) |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
241 |
ERROR("signals_default"); |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
242 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
243 |
// setup evsql |
46 | 244 |
if ((ctx.db = evsql_new_pq(ev_base, db_conninfo, NULL, NULL)) == NULL) |
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
245 |
ERROR("evsql_new_pq"); |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
246 |
|
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
247 |
// send query |
46 | 248 |
query_send(ctx.db, NULL); |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
249 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
250 |
// being transaction |
46 | 251 |
begin_transaction(&ctx); |
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
252 |
|
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
253 |
// send query |
46 | 254 |
query_send(ctx.db, NULL); |
255 |
||
256 |
// start query timer |
|
257 |
query_start(ev_base, ctx.db); |
|
45
424ce5ab82fd
compiles + some basic evsql_test
Tero Marttila <terom@fixme.fi>
parents:
44
diff
changeset
|
258 |
|
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
259 |
// run libevent |
46 | 260 |
INFO("[evsql_test.main] running libevent loop"); |
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
261 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
262 |
if (event_base_dispatch(ev_base)) |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
263 |
PERROR("event_base_dispatch"); |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
264 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
265 |
// clean shutdown |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
266 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
267 |
error : |
46 | 268 |
if (ctx.db) { |
44
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
269 |
/* evsql_close(db); */ |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
270 |
} |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
271 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
272 |
if (signals) |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
273 |
signals_free(signals); |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
274 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
275 |
if (ev_base) |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
276 |
event_base_free(ev_base); |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
277 |
|
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
278 |
} |
9e76ee9729b6
more work on the new evsql interface
Tero Marttila <terom@fixme.fi>
parents:
diff
changeset
|
279 |