]>
Commit | Line | Data |
---|---|---|
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 | 15 | static DBAPI2_HANDLE *dbapi2_adapter_new(const DBAPIConn *); |
39c33a3d CP |
16 | static void dbapi2_adapter_close(DBAPIConn *); |
17 | ||
24e1aba8 CP |
18 | static void dbapi2_adapter_query(const DBAPIConn *, DBAPIQueryCallback, DBAPIUserData, const char *); |
19 | static void dbapi2_adapter_createtable(const DBAPIConn *, DBAPIQueryCallback, DBAPIUserData, const char *); | |
4a532778 | 20 | static void dbapi2_adapter_loadtable(const DBAPIConn *, DBAPIQueryCallback, DBAPIQueryCallback, DBAPIQueryCallback, DBAPIUserData data, const char *); |
39c33a3d | 21 | |
4a532778 CP |
22 | static void dbapi2_adapter_escapestring(const DBAPIConn *, char *, const char *, size_t); |
23 | static int dbapi2_adapter_quotestring(const DBAPIConn *, char *, size_t, const char *, size_t); | |
39c33a3d | 24 | |
4a532778 | 25 | static char *dbapi2_adapter_tablename(const DBAPIConn *, const char *); |
4277aef7 | 26 | |
4d47ff97 CP |
27 | static void dbapi2_adapter_call(const DBAPIConn *, DBAPIQueryCallback, DBAPIUserData, const char *, const char *); |
28 | ||
39c33a3d CP |
29 | static 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 | ||
45 | struct DBAPI2AdapterQueryCallback { | |
4a532778 | 46 | const DBAPIConn *db; |
39c33a3d CP |
47 | DBAPIUserData data; |
48 | DBAPIQueryCallback callback; | |
49 | }; | |
50 | ||
51 | struct DBAPI2AdapterLoadTableCallback { | |
4a532778 | 52 | const DBAPIConn *db; |
39c33a3d CP |
53 | DBAPIUserData data; |
54 | DBAPIQueryCallback init, callback, fini; | |
55 | }; | |
56 | ||
57 | static int adapterhandle; | |
58 | ||
59 | static void registeradapterprovider(void) { | |
60 | adapterhandle = registerdbprovider(DBAPI2_ADAPTER_NAME, &adapterprovider); | |
61 | } | |
62 | ||
63 | static void deregisteradapterprovider(void) { | |
64 | deregisterdbprovider(adapterhandle); | |
65 | } | |
66 | ||
4a532778 | 67 | static 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 | ||
75 | static void dbapi2_adapter_close(DBAPIConn *db) { | |
76 | dbfreeid((int)(long)db->handle); | |
77 | dbdetach(db->name); | |
78 | } | |
79 | ||
4a532778 | 80 | static char *dbapi2_adapter_result_get(const DBAPIResult *r, unsigned int column) { |
39c33a3d CP |
81 | return dbgetvalue(r->handle, column); |
82 | } | |
83 | ||
4a532778 | 84 | static int dbapi2_adapter_result_next(const DBAPIResult *r) { |
39c33a3d CP |
85 | return dbfetchrow(r->handle); |
86 | } | |
87 | ||
4a532778 | 88 | static void dbapi2_adapter_result_clear(const DBAPIResult *r) { |
39c33a3d CP |
89 | if(!r) |
90 | return; | |
91 | ||
92 | dbclear(r->handle); | |
93 | } | |
94 | ||
95 | static 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 | ||
120 | static 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 | 129 | static 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 |
145 | static 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 |
149 | static 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 | ||
153 | static 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 | ||
159 | static 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 | ||
166 | static 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 | 175 | static 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 | 188 | static 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 | 193 | static 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 | 213 | static 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 | |
222 | static 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 |