]> jfr.im git - irc/quakenet/newserv.git/blame - dbapi2/dbapi2-adapter.inc
DBAPI2: fix initialisation bug (thanks to anders for crash logs)
[irc/quakenet/newserv.git] / dbapi2 / dbapi2-adapter.inc
CommitLineData
39c33a3d 1#include <stdarg.h>
4277aef7 2#include <stdio.h>
39c33a3d
CP
3
4#define DBAPI2_ADAPTER
5#include "../dbapi/dbapi.h"
6
7#define DBAPI2_RESULT_HANDLE DBResult
8
9#include "../dbapi2/dbapi2.h"
39c33a3d 10#include "../lib/stringbuf.h"
8f072e42 11#include "../lib/version.h"
39c33a3d 12
3a7332dd
CP
13#include <string.h>
14
4a532778 15static DBAPI2_HANDLE *dbapi2_adapter_new(const DBAPIConn *);
39c33a3d
CP
16static void dbapi2_adapter_close(DBAPIConn *);
17
24e1aba8
CP
18static void dbapi2_adapter_query(const DBAPIConn *, DBAPIQueryCallback, DBAPIUserData, const char *);
19static void dbapi2_adapter_createtable(const DBAPIConn *, DBAPIQueryCallback, DBAPIUserData, const char *);
4a532778 20static void dbapi2_adapter_loadtable(const DBAPIConn *, DBAPIQueryCallback, DBAPIQueryCallback, DBAPIQueryCallback, DBAPIUserData data, const char *);
39c33a3d 21
4a532778
CP
22static void dbapi2_adapter_escapestring(const DBAPIConn *, char *, const char *, size_t);
23static int dbapi2_adapter_quotestring(const DBAPIConn *, char *, size_t, const char *, size_t);
39c33a3d 24
4a532778 25static char *dbapi2_adapter_tablename(const DBAPIConn *, const char *);
4277aef7 26
4d47ff97
CP
27static void dbapi2_adapter_call(const DBAPIConn *, DBAPIQueryCallback, DBAPIUserData, const char *, const char *);
28
39c33a3d
CP
29static DBAPIProvider adapterprovider = {
30 .new = dbapi2_adapter_new,
31 .close = dbapi2_adapter_close,
32
33 .query = dbapi2_adapter_query,
34 .createtable = dbapi2_adapter_createtable,
35 .loadtable = dbapi2_adapter_loadtable,
36
37 .escapestring = dbapi2_adapter_escapestring,
4277aef7
CP
38 .quotestring = dbapi2_adapter_quotestring,
39
40 .tablename = dbapi2_adapter_tablename,
4d47ff97
CP
41
42 .call = dbapi2_adapter_call,
39c33a3d
CP
43};
44
45struct DBAPI2AdapterQueryCallback {
4a532778 46 const DBAPIConn *db;
39c33a3d
CP
47 DBAPIUserData data;
48 DBAPIQueryCallback callback;
49};
50
51struct DBAPI2AdapterLoadTableCallback {
4a532778 52 const DBAPIConn *db;
39c33a3d
CP
53 DBAPIUserData data;
54 DBAPIQueryCallback init, callback, fini;
55};
56
57static int adapterhandle;
58
59static void registeradapterprovider(void) {
60 adapterhandle = registerdbprovider(DBAPI2_ADAPTER_NAME, &adapterprovider);
61}
62
63static void deregisteradapterprovider(void) {
64 deregisterdbprovider(adapterhandle);
65}
66
4a532778 67static DBAPI2_HANDLE *dbapi2_adapter_new(const DBAPIConn *db) {
39c33a3d
CP
68 long id = dbgetid();
69
4a532778 70 dbattach(((DBAPIConn *)db)->name);
39c33a3d
CP
71
72 return (void *)id;
73}
74
75static void dbapi2_adapter_close(DBAPIConn *db) {
76 dbfreeid((int)(long)db->handle);
77 dbdetach(db->name);
78}
79
4a532778 80static char *dbapi2_adapter_result_get(const DBAPIResult *r, unsigned int column) {
39c33a3d
CP
81 return dbgetvalue(r->handle, column);
82}
83
4a532778 84static int dbapi2_adapter_result_next(const DBAPIResult *r) {
39c33a3d
CP
85 return dbfetchrow(r->handle);
86}
87
4a532778 88static void dbapi2_adapter_result_clear(const DBAPIResult *r) {
39c33a3d
CP
89 if(!r)
90 return;
91
92 dbclear(r->handle);
93}
94
95static DBAPIResult *wrapresult(DBAPIResult *r, DBConn *c) {
96 if(!c)
97 return NULL;
98
3a7332dd 99 if(!r) {
39c33a3d 100 r = calloc(1, sizeof(DBAPIResult));
3a7332dd
CP
101 } else {
102 memset(r, 0, sizeof(DBAPIResult));
103 }
39c33a3d
CP
104
105 r->clear = dbapi2_adapter_result_clear;
106 r->handle = dbgetresult(c);
107
108 if(!dbquerysuccessful(r->handle))
109 return r;
110
111 r->success = 1;
112 r->fields = dbnumfields(r->handle);
113
114 r->get = dbapi2_adapter_result_get;
115 r->next = dbapi2_adapter_result_next;
116
117 return r;
118}
119
120static void dbapi2_adapter_querywrapper(DBConn *c, void *data) {
121 struct DBAPI2AdapterQueryCallback *a = data;
76286174 122 DBAPIResult r;
39c33a3d 123
76286174 124 a->callback(wrapresult(&r, c), a->data);
39c33a3d
CP
125
126 free(a);
127}
128
24e1aba8 129static void sqquery(const DBAPIConn *db, DBAPIQueryCallback cb, DBAPIUserData data, int flags, const char *query) {
39c33a3d
CP
130 struct DBAPI2AdapterQueryCallback *a;
131
132 if(cb) {
133 a = malloc(sizeof(struct DBAPI2AdapterQueryCallback));
134
135 a->db = db;
136 a->data = data;
137 a->callback = cb;
138 } else {
139 a = NULL;
140 }
141
24e1aba8 142 dbasyncqueryf((int)(long)db->handle, cb?dbapi2_adapter_querywrapper:NULL, a, flags, "%s", query);
39c33a3d
CP
143}
144
24e1aba8
CP
145static void dbapi2_adapter_query(const DBAPIConn *db, DBAPIQueryCallback cb, DBAPIUserData data, const char *query) {
146 sqquery(db, cb, data, 0, query);
39c33a3d
CP
147}
148
24e1aba8
CP
149static void dbapi2_adapter_createtable(const DBAPIConn *db, DBAPIQueryCallback cb, DBAPIUserData data, const char *query) {
150 sqquery(db, cb, data, DB_CREATE, query);
39c33a3d
CP
151}
152
153static void dbapi2_adapter_loadtablewrapper_init(DBConn *c, void *data) {
154 struct DBAPI2AdapterLoadTableCallback *a = data;
155
c73fb0ab 156 a->init(NULL, a->data);
39c33a3d
CP
157}
158
159static void dbapi2_adapter_loadtablewrapper_data(DBConn *c, void *data) {
160 struct DBAPI2AdapterLoadTableCallback *a = data;
76286174 161 DBAPIResult r;
39c33a3d 162
76286174 163 a->callback(wrapresult(&r, c), a->data);
39c33a3d
CP
164}
165
166static void dbapi2_adapter_loadtablewrapper_fini(DBConn *c, void *data) {
167 struct DBAPI2AdapterLoadTableCallback *a = data;
168
169 if(a->fini)
c73fb0ab 170 a->fini(NULL, a->data);
39c33a3d
CP
171
172 free(a);
173}
174
4a532778 175static void dbapi2_adapter_loadtable(const DBAPIConn *db, DBAPIQueryCallback init, DBAPIQueryCallback cb, DBAPIQueryCallback final, DBAPIUserData data, const char *table) {
39c33a3d
CP
176 struct DBAPI2AdapterLoadTableCallback *a = malloc(sizeof(struct DBAPI2AdapterLoadTableCallback));
177
178 a->db = db;
179 a->data = data;
180
181 a->init = init;
182 a->callback = cb;
183 a->fini = final;
184
185 dbloadtable_tag((char *)table, init?dbapi2_adapter_loadtablewrapper_init:NULL, cb?dbapi2_adapter_loadtablewrapper_data:NULL, dbapi2_adapter_loadtablewrapper_fini, a);
186}
187
4a532778 188static void dbapi2_adapter_escapestring(const DBAPIConn *db, char *buf, const char *data, size_t len) {
39c33a3d
CP
189 dbescapestring(buf, (char *)data, len);
190}
191
192#ifndef DBAPI2_CUSTOM_QUOTESTRING
4a532778 193static int dbapi2_adapter_quotestring(const DBAPIConn *db, char *buf, size_t buflen, const char *data, size_t len) {
39c33a3d 194 StringBuf b;
39c33a3d
CP
195 char xbuf[len * 2 + 5];
196 size_t esclen;
197
2667bceb 198 sbinit(&b, buf, buflen);
39c33a3d
CP
199 esclen = dbescapestring(xbuf, (char *)data, len);
200
201 sbaddchar(&b, '\'');
202 sbaddstrlen(&b, xbuf, esclen);
203 sbaddchar(&b, '\'');
204
2667bceb 205 if(!sbterminate(&b))
39c33a3d
CP
206 return 0;
207
208 return 1;
209}
210#endif
4277aef7
CP
211
212#ifndef DBAPI2_CUSTOM_TABLENAME
4a532778 213static char *dbapi2_adapter_tablename(const DBAPIConn *db, const char *tablename) {
4277aef7
CP
214 static char buf[1024];
215
216 snprintf(buf, sizeof(buf), "%s.%s", db->name, tablename);
217
218 return buf;
219}
220#endif
4d47ff97
CP
221
222static void dbapi2_adapter_call(const DBAPIConn *db, DBAPIQueryCallback cb, DBAPIUserData data, const char *function, const char *query) {
223 struct DBAPI2AdapterQueryCallback *a;
224 char buf[512];
225
226 if(cb) {
227 a = malloc(sizeof(struct DBAPI2AdapterQueryCallback));
228
229 a->db = db;
230 a->data = data;
231 a->callback = cb;
232 } else {
233 a = NULL;
234 }
235
236 snprintf(buf, sizeof(buf), "%s", db->tablename(db, function));
237 dbcall((int)(long)db->handle, cb?dbapi2_adapter_querywrapper:NULL, a, buf, query);
238}
239