1 | /* glpsql.c */ |
---|
2 | |
---|
3 | /*********************************************************************** |
---|
4 | * This code is part of GLPK (GNU Linear Programming Kit). |
---|
5 | * |
---|
6 | * Author: Heinrich Schuchardt <xypron.glpk@gmx.de>. |
---|
7 | * |
---|
8 | * Copyright (C) 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, |
---|
9 | * 2009, 2010 Andrew Makhorin, Department for Applied Informatics, |
---|
10 | * Moscow Aviation Institute, Moscow, Russia. All rights reserved. |
---|
11 | * E-mail: <mao@gnu.org>. |
---|
12 | * |
---|
13 | * GLPK is free software: you can redistribute it and/or modify it |
---|
14 | * under the terms of the GNU General Public License as published by |
---|
15 | * the Free Software Foundation, either version 3 of the License, or |
---|
16 | * (at your option) any later version. |
---|
17 | * |
---|
18 | * GLPK is distributed in the hope that it will be useful, but WITHOUT |
---|
19 | * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY |
---|
20 | * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public |
---|
21 | * License for more details. |
---|
22 | * |
---|
23 | * You should have received a copy of the GNU General Public License |
---|
24 | * along with GLPK. If not, see <http://www.gnu.org/licenses/>. |
---|
25 | ***********************************************************************/ |
---|
26 | |
---|
27 | #ifdef HAVE_CONFIG_H |
---|
28 | #include <config.h> |
---|
29 | #endif |
---|
30 | |
---|
31 | #include "glpmpl.h" |
---|
32 | #include "glpsql.h" |
---|
33 | |
---|
34 | #ifdef ODBC_DLNAME |
---|
35 | #define HAVE_ODBC |
---|
36 | #define libodbc ODBC_DLNAME |
---|
37 | #define h_odbc (get_env_ptr()->h_odbc) |
---|
38 | #endif |
---|
39 | |
---|
40 | #ifdef MYSQL_DLNAME |
---|
41 | #define HAVE_MYSQL |
---|
42 | #define libmysql MYSQL_DLNAME |
---|
43 | #define h_mysql (get_env_ptr()->h_mysql) |
---|
44 | #endif |
---|
45 | |
---|
46 | static void *db_iodbc_open_int(TABDCA *dca, int mode, const char |
---|
47 | **sqllines); |
---|
48 | static void *db_mysql_open_int(TABDCA *dca, int mode, const char |
---|
49 | **sqllines); |
---|
50 | |
---|
51 | /**********************************************************************/ |
---|
52 | |
---|
53 | #if defined(HAVE_ODBC) || defined(HAVE_MYSQL) |
---|
54 | |
---|
55 | #define SQL_FIELD_MAX 100 |
---|
56 | /* maximal field count */ |
---|
57 | |
---|
58 | #define SQL_FDLEN_MAX 255 |
---|
59 | /* maximal field length */ |
---|
60 | |
---|
61 | /*********************************************************************** |
---|
62 | * NAME |
---|
63 | * |
---|
64 | * args_concat - concatenate arguments |
---|
65 | * |
---|
66 | * SYNOPSIS |
---|
67 | * |
---|
68 | * static char **args_concat(TABDCA *dca); |
---|
69 | * |
---|
70 | * DESCRIPTION |
---|
71 | * |
---|
72 | * The arguments passed in dca are SQL statements. A SQL statement may |
---|
73 | * be split over multiple arguments. The last argument of a SQL |
---|
74 | * statement will be terminated with a semilocon. Each SQL statement is |
---|
75 | * merged into a single zero terminated string. Boundaries between |
---|
76 | * arguments are replaced by space. |
---|
77 | * |
---|
78 | * RETURNS |
---|
79 | * |
---|
80 | * Buffer with SQL statements */ |
---|
81 | |
---|
82 | static char **args_concat(TABDCA *dca) |
---|
83 | { |
---|
84 | const char *arg; |
---|
85 | int i; |
---|
86 | int j; |
---|
87 | int j0; |
---|
88 | int j1; |
---|
89 | int len; |
---|
90 | int lentot; |
---|
91 | int narg; |
---|
92 | int nline = 0; |
---|
93 | void *ret; |
---|
94 | char **sqllines = NULL; |
---|
95 | |
---|
96 | narg = mpl_tab_num_args(dca); |
---|
97 | /* The SQL statements start with argument 3. */ |
---|
98 | if (narg < 3) |
---|
99 | return NULL; |
---|
100 | /* Count the SQL statements */ |
---|
101 | for (j = 3; j <= narg; j++) |
---|
102 | { |
---|
103 | arg = mpl_tab_get_arg(dca, j); |
---|
104 | len = strlen(arg); |
---|
105 | if (arg[len-1] == ';' || j == narg) |
---|
106 | nline ++; |
---|
107 | } |
---|
108 | /* Allocate string buffer. */ |
---|
109 | sqllines = (char **) xmalloc((nline+1) * sizeof(char **)); |
---|
110 | /* Join arguments */ |
---|
111 | sqllines[0] = NULL; |
---|
112 | j0 = 3; |
---|
113 | i = 0; |
---|
114 | lentot = 0; |
---|
115 | for (j = 3; j <= narg; j++) |
---|
116 | { |
---|
117 | arg = mpl_tab_get_arg(dca, j); |
---|
118 | len = strlen(arg); |
---|
119 | /* add length of part */ |
---|
120 | lentot += len; |
---|
121 | /* add length of space separating parts or 0x00 at end of SQL |
---|
122 | statement */ |
---|
123 | lentot++; |
---|
124 | if (arg[len-1] == ';' || j == narg) |
---|
125 | { /* Join arguments for a single SQL statement */ |
---|
126 | sqllines[i] = xmalloc(lentot); |
---|
127 | sqllines[i+1] = NULL; |
---|
128 | sqllines[i][0] = 0x00; |
---|
129 | for (j1 = j0; j1 <= j; j1++) |
---|
130 | { if(j1>j0) |
---|
131 | strcat(sqllines[i], " "); |
---|
132 | strcat(sqllines[i], mpl_tab_get_arg(dca, j1)); |
---|
133 | } |
---|
134 | len = strlen(sqllines[i]); |
---|
135 | if (sqllines[i][len-1] == ';') |
---|
136 | sqllines[i][len-1] = 0x00; |
---|
137 | j0 = j+1; |
---|
138 | i++; |
---|
139 | lentot = 0; |
---|
140 | } |
---|
141 | } |
---|
142 | return sqllines; |
---|
143 | } |
---|
144 | |
---|
145 | /*********************************************************************** |
---|
146 | * NAME |
---|
147 | * |
---|
148 | * free_buffer - free multiline string buffer |
---|
149 | * |
---|
150 | * SYNOPSIS |
---|
151 | * |
---|
152 | * static void free_buffer(char **buf); |
---|
153 | * |
---|
154 | * DESCRIPTION |
---|
155 | * |
---|
156 | * buf is a list of strings terminated by NULL. |
---|
157 | * The memory for the strings and for the list is released. */ |
---|
158 | |
---|
159 | static void free_buffer(char **buf) |
---|
160 | { int i; |
---|
161 | |
---|
162 | for(i = 0; buf[i] != NULL; i++) |
---|
163 | xfree(buf[i]); |
---|
164 | xfree(buf); |
---|
165 | } |
---|
166 | |
---|
167 | static int db_escaped_string_length(const char* from) |
---|
168 | /* length of escaped string */ |
---|
169 | { |
---|
170 | int count; |
---|
171 | const char *pointer; |
---|
172 | |
---|
173 | for (pointer = from, count = 0; *pointer != (char) '\0'; pointer++, |
---|
174 | count++) |
---|
175 | { |
---|
176 | switch (*pointer) |
---|
177 | { |
---|
178 | case '\'': |
---|
179 | count++; |
---|
180 | break; |
---|
181 | } |
---|
182 | } |
---|
183 | |
---|
184 | return count; |
---|
185 | } |
---|
186 | |
---|
187 | static int db_escape_string (char *to, const char *from) |
---|
188 | /* escape string*/ |
---|
189 | { |
---|
190 | const char *source = from; |
---|
191 | char *target = to; |
---|
192 | unsigned int remaining; |
---|
193 | |
---|
194 | remaining = strlen(from); |
---|
195 | |
---|
196 | if (to == NULL) |
---|
197 | to = (char *) (from + remaining); |
---|
198 | |
---|
199 | while (remaining > 0) |
---|
200 | { |
---|
201 | switch (*source) |
---|
202 | { |
---|
203 | case '\'': |
---|
204 | *target = '\''; |
---|
205 | target++; |
---|
206 | *target = '\''; |
---|
207 | break; |
---|
208 | |
---|
209 | default: |
---|
210 | *target = *source; |
---|
211 | } |
---|
212 | source++; |
---|
213 | target++; |
---|
214 | remaining--; |
---|
215 | } |
---|
216 | |
---|
217 | /* Write the terminating NUL character. */ |
---|
218 | *target = '\0'; |
---|
219 | |
---|
220 | return target - to; |
---|
221 | } |
---|
222 | |
---|
223 | static char *db_generate_select_stmt(TABDCA *dca) |
---|
224 | /* generate select statement */ |
---|
225 | { |
---|
226 | char *arg; |
---|
227 | char const *field; |
---|
228 | char *query; |
---|
229 | int j; |
---|
230 | int narg; |
---|
231 | int nf; |
---|
232 | int total; |
---|
233 | |
---|
234 | total = 50; |
---|
235 | nf = mpl_tab_num_flds(dca); |
---|
236 | narg = mpl_tab_num_args(dca); |
---|
237 | for (j=1; j <= nf && j <= SQL_FIELD_MAX; j++) |
---|
238 | { |
---|
239 | field = mpl_tab_get_name(dca, j); |
---|
240 | total += strlen(field); |
---|
241 | total += 2; |
---|
242 | } |
---|
243 | arg = (char *) mpl_tab_get_arg(dca, narg); |
---|
244 | total += strlen(arg); |
---|
245 | query = xmalloc( total * sizeof(char)); |
---|
246 | strcpy (query, "SELECT "); |
---|
247 | for (j=1; j <= nf && j <= SQL_FIELD_MAX; j++) |
---|
248 | { |
---|
249 | field = mpl_tab_get_name(dca, j); |
---|
250 | strcat(query, field); |
---|
251 | if ( j < nf ) |
---|
252 | strcat(query, ", "); |
---|
253 | } |
---|
254 | strcat(query, " FROM "); |
---|
255 | strcat(query, arg); |
---|
256 | return query; |
---|
257 | } |
---|
258 | |
---|
259 | static char *db_generate_insert_stmt(TABDCA *dca) |
---|
260 | /* generate insert statement */ |
---|
261 | { |
---|
262 | char *arg; |
---|
263 | char const *field; |
---|
264 | char *query; |
---|
265 | int j; |
---|
266 | int narg; |
---|
267 | int nf; |
---|
268 | int total; |
---|
269 | |
---|
270 | total = 50; |
---|
271 | nf = mpl_tab_num_flds(dca); |
---|
272 | narg = mpl_tab_num_args(dca); |
---|
273 | for (j=1; j <= nf && j <= SQL_FIELD_MAX; j++) |
---|
274 | { |
---|
275 | field = mpl_tab_get_name(dca, j); |
---|
276 | total += strlen(field); |
---|
277 | total += 5; |
---|
278 | } |
---|
279 | arg = (char *) mpl_tab_get_arg(dca, narg); |
---|
280 | total += strlen(arg); |
---|
281 | query = xmalloc( (total+1) * sizeof(char)); |
---|
282 | strcpy (query, "INSERT INTO "); |
---|
283 | strcat(query, arg); |
---|
284 | strcat(query, " ( "); |
---|
285 | for (j=1; j <= nf && j <= SQL_FIELD_MAX; j++) |
---|
286 | { |
---|
287 | field = mpl_tab_get_name(dca, j); |
---|
288 | strcat(query, field); |
---|
289 | if ( j < nf ) |
---|
290 | strcat(query, ", "); |
---|
291 | } |
---|
292 | strcat(query, " ) VALUES ( "); |
---|
293 | for (j=1; j <= nf && j <= SQL_FIELD_MAX; j++) |
---|
294 | { |
---|
295 | strcat(query, "?"); |
---|
296 | if ( j < nf ) |
---|
297 | strcat(query, ", "); |
---|
298 | } |
---|
299 | strcat(query, " )"); |
---|
300 | return query; |
---|
301 | } |
---|
302 | |
---|
303 | #endif |
---|
304 | |
---|
305 | /**********************************************************************/ |
---|
306 | |
---|
307 | #ifndef HAVE_ODBC |
---|
308 | |
---|
309 | void *db_iodbc_open(TABDCA *dca, int mode) |
---|
310 | { xassert(dca == dca); |
---|
311 | xassert(mode == mode); |
---|
312 | xprintf("iODBC table driver not supported\n"); |
---|
313 | return NULL; |
---|
314 | } |
---|
315 | |
---|
316 | int db_iodbc_read(TABDCA *dca, void *link) |
---|
317 | { xassert(dca != dca); |
---|
318 | xassert(link != link); |
---|
319 | return 0; |
---|
320 | } |
---|
321 | |
---|
322 | int db_iodbc_write(TABDCA *dca, void *link) |
---|
323 | { xassert(dca != dca); |
---|
324 | xassert(link != link); |
---|
325 | return 0; |
---|
326 | } |
---|
327 | |
---|
328 | int db_iodbc_close(TABDCA *dca, void *link) |
---|
329 | { xassert(dca != dca); |
---|
330 | xassert(link != link); |
---|
331 | return 0; |
---|
332 | } |
---|
333 | |
---|
334 | #else |
---|
335 | |
---|
336 | #if defined(__CYGWIN__) || defined(__MINGW32__) || defined(__WOE__) |
---|
337 | #include <windows.h> |
---|
338 | #endif |
---|
339 | |
---|
340 | #include <sql.h> |
---|
341 | #include <sqlext.h> |
---|
342 | |
---|
343 | struct db_odbc |
---|
344 | { |
---|
345 | int mode; /*'R' = Read, 'W' = Write*/ |
---|
346 | SQLHDBC hdbc; /*connection handle*/ |
---|
347 | SQLHENV henv; /*environment handle*/ |
---|
348 | SQLHSTMT hstmt; /*statement handle*/ |
---|
349 | SQLSMALLINT nresultcols; /* columns in result*/ |
---|
350 | SQLULEN collen[SQL_FIELD_MAX+1]; |
---|
351 | SQLLEN outlen[SQL_FIELD_MAX+1]; |
---|
352 | SQLSMALLINT coltype[SQL_FIELD_MAX+1]; |
---|
353 | SQLCHAR data[SQL_FIELD_MAX+1][SQL_FDLEN_MAX+1]; |
---|
354 | SQLCHAR colname[SQL_FIELD_MAX+1][SQL_FDLEN_MAX+1]; |
---|
355 | int isnumeric[SQL_FIELD_MAX+1]; |
---|
356 | int nf; |
---|
357 | /* number of fields in the csv file */ |
---|
358 | int ref[1+SQL_FIELD_MAX]; |
---|
359 | /* ref[k] = k', if k-th field of the csv file corresponds to |
---|
360 | k'-th field in the table statement; if ref[k] = 0, k-th field |
---|
361 | of the csv file is ignored */ |
---|
362 | SQLCHAR *query; |
---|
363 | /* query generated by db_iodbc_open */ |
---|
364 | }; |
---|
365 | |
---|
366 | SQLRETURN SQL_API dl_SQLAllocHandle ( |
---|
367 | SQLSMALLINT HandleType, |
---|
368 | SQLHANDLE InputHandle, |
---|
369 | SQLHANDLE *OutputHandle) |
---|
370 | { |
---|
371 | typedef SQLRETURN SQL_API ep_SQLAllocHandle( |
---|
372 | SQLSMALLINT HandleType, |
---|
373 | SQLHANDLE InputHandle, |
---|
374 | SQLHANDLE *OutputHandle); |
---|
375 | |
---|
376 | ep_SQLAllocHandle *fn; |
---|
377 | fn = (ep_SQLAllocHandle *) xdlsym(h_odbc, "SQLAllocHandle"); |
---|
378 | xassert(fn != NULL); |
---|
379 | return (*fn)(HandleType, InputHandle, OutputHandle); |
---|
380 | } |
---|
381 | |
---|
382 | SQLRETURN SQL_API dl_SQLBindCol ( |
---|
383 | SQLHSTMT StatementHandle, |
---|
384 | SQLUSMALLINT ColumnNumber, |
---|
385 | SQLSMALLINT TargetType, |
---|
386 | SQLPOINTER TargetValue, |
---|
387 | SQLLEN BufferLength, |
---|
388 | SQLLEN *StrLen_or_Ind) |
---|
389 | { |
---|
390 | typedef SQLRETURN SQL_API ep_SQLBindCol( |
---|
391 | SQLHSTMT StatementHandle, |
---|
392 | SQLUSMALLINT ColumnNumber, |
---|
393 | SQLSMALLINT TargetType, |
---|
394 | SQLPOINTER TargetValue, |
---|
395 | SQLLEN BufferLength, |
---|
396 | SQLLEN *StrLen_or_Ind); |
---|
397 | ep_SQLBindCol *fn; |
---|
398 | fn = (ep_SQLBindCol *) xdlsym(h_odbc, "SQLBindCol"); |
---|
399 | xassert(fn != NULL); |
---|
400 | return (*fn)(StatementHandle, ColumnNumber, TargetType, |
---|
401 | TargetValue, BufferLength, StrLen_or_Ind); |
---|
402 | } |
---|
403 | |
---|
404 | SQLRETURN SQL_API dl_SQLCloseCursor ( |
---|
405 | SQLHSTMT StatementHandle) |
---|
406 | { |
---|
407 | typedef SQLRETURN SQL_API ep_SQLCloseCursor ( |
---|
408 | SQLHSTMT StatementHandle); |
---|
409 | |
---|
410 | ep_SQLCloseCursor *fn; |
---|
411 | fn = (ep_SQLCloseCursor *) xdlsym(h_odbc, "SQLCloseCursor"); |
---|
412 | xassert(fn != NULL); |
---|
413 | return (*fn)(StatementHandle); |
---|
414 | } |
---|
415 | |
---|
416 | |
---|
417 | SQLRETURN SQL_API dl_SQLDisconnect ( |
---|
418 | SQLHDBC ConnectionHandle) |
---|
419 | { |
---|
420 | typedef SQLRETURN SQL_API ep_SQLDisconnect( |
---|
421 | SQLHDBC ConnectionHandle); |
---|
422 | |
---|
423 | ep_SQLDisconnect *fn; |
---|
424 | fn = (ep_SQLDisconnect *) xdlsym(h_odbc, "SQLDisconnect"); |
---|
425 | xassert(fn != NULL); |
---|
426 | return (*fn)(ConnectionHandle); |
---|
427 | } |
---|
428 | |
---|
429 | SQLRETURN SQL_API dl_SQLDriverConnect ( |
---|
430 | SQLHDBC hdbc, |
---|
431 | SQLHWND hwnd, |
---|
432 | SQLCHAR *szConnStrIn, |
---|
433 | SQLSMALLINT cbConnStrIn, |
---|
434 | SQLCHAR *szConnStrOut, |
---|
435 | SQLSMALLINT cbConnStrOutMax, |
---|
436 | SQLSMALLINT *pcbConnStrOut, |
---|
437 | SQLUSMALLINT fDriverCompletion) |
---|
438 | { |
---|
439 | typedef SQLRETURN SQL_API ep_SQLDriverConnect( |
---|
440 | SQLHDBC hdbc, |
---|
441 | SQLHWND hwnd, |
---|
442 | SQLCHAR * szConnStrIn, |
---|
443 | SQLSMALLINT cbConnStrIn, |
---|
444 | SQLCHAR * szConnStrOut, |
---|
445 | SQLSMALLINT cbConnStrOutMax, |
---|
446 | SQLSMALLINT * pcbConnStrOut, |
---|
447 | SQLUSMALLINT fDriverCompletion); |
---|
448 | |
---|
449 | ep_SQLDriverConnect *fn; |
---|
450 | fn = (ep_SQLDriverConnect *) xdlsym(h_odbc, "SQLDriverConnect"); |
---|
451 | xassert(fn != NULL); |
---|
452 | return (*fn)(hdbc, hwnd, szConnStrIn, cbConnStrIn, szConnStrOut, |
---|
453 | cbConnStrOutMax, pcbConnStrOut, fDriverCompletion); |
---|
454 | } |
---|
455 | |
---|
456 | SQLRETURN SQL_API dl_SQLEndTran ( |
---|
457 | SQLSMALLINT HandleType, |
---|
458 | SQLHANDLE Handle, |
---|
459 | SQLSMALLINT CompletionType) |
---|
460 | { |
---|
461 | typedef SQLRETURN SQL_API ep_SQLEndTran ( |
---|
462 | SQLSMALLINT HandleType, |
---|
463 | SQLHANDLE Handle, |
---|
464 | SQLSMALLINT CompletionType); |
---|
465 | |
---|
466 | ep_SQLEndTran *fn; |
---|
467 | fn = (ep_SQLEndTran *) xdlsym(h_odbc, "SQLEndTran"); |
---|
468 | xassert(fn != NULL); |
---|
469 | return (*fn)(HandleType, Handle, CompletionType); |
---|
470 | } |
---|
471 | |
---|
472 | SQLRETURN SQL_API dl_SQLExecDirect ( |
---|
473 | SQLHSTMT StatementHandle, |
---|
474 | SQLCHAR * StatementText, |
---|
475 | SQLINTEGER TextLength) |
---|
476 | { |
---|
477 | typedef SQLRETURN SQL_API ep_SQLExecDirect ( |
---|
478 | SQLHSTMT StatementHandle, |
---|
479 | SQLCHAR * StatementText, |
---|
480 | SQLINTEGER TextLength); |
---|
481 | |
---|
482 | ep_SQLExecDirect *fn; |
---|
483 | fn = (ep_SQLExecDirect *) xdlsym(h_odbc, "SQLExecDirect"); |
---|
484 | xassert(fn != NULL); |
---|
485 | return (*fn)(StatementHandle, StatementText, TextLength); |
---|
486 | } |
---|
487 | |
---|
488 | SQLRETURN SQL_API dl_SQLFetch ( |
---|
489 | SQLHSTMT StatementHandle) |
---|
490 | { |
---|
491 | typedef SQLRETURN SQL_API ep_SQLFetch ( |
---|
492 | SQLHSTMT StatementHandle); |
---|
493 | |
---|
494 | ep_SQLFetch *fn; |
---|
495 | fn = (ep_SQLFetch*) xdlsym(h_odbc, "SQLFetch"); |
---|
496 | xassert(fn != NULL); |
---|
497 | return (*fn)(StatementHandle); |
---|
498 | } |
---|
499 | |
---|
500 | SQLRETURN SQL_API dl_SQLFreeHandle ( |
---|
501 | SQLSMALLINT HandleType, |
---|
502 | SQLHANDLE Handle) |
---|
503 | { |
---|
504 | typedef SQLRETURN SQL_API ep_SQLFreeHandle ( |
---|
505 | SQLSMALLINT HandleType, |
---|
506 | SQLHANDLE Handle); |
---|
507 | |
---|
508 | ep_SQLFreeHandle *fn; |
---|
509 | fn = (ep_SQLFreeHandle *) xdlsym(h_odbc, "SQLFreeHandle"); |
---|
510 | xassert(fn != NULL); |
---|
511 | return (*fn)(HandleType, Handle); |
---|
512 | } |
---|
513 | |
---|
514 | SQLRETURN SQL_API dl_SQLDescribeCol ( |
---|
515 | SQLHSTMT StatementHandle, |
---|
516 | SQLUSMALLINT ColumnNumber, |
---|
517 | SQLCHAR * ColumnName, |
---|
518 | SQLSMALLINT BufferLength, |
---|
519 | SQLSMALLINT * NameLength, |
---|
520 | SQLSMALLINT * DataType, |
---|
521 | SQLULEN * ColumnSize, |
---|
522 | SQLSMALLINT * DecimalDigits, |
---|
523 | SQLSMALLINT * Nullable) |
---|
524 | { |
---|
525 | typedef SQLRETURN SQL_API ep_SQLDescribeCol ( |
---|
526 | SQLHSTMT StatementHandle, |
---|
527 | SQLUSMALLINT ColumnNumber, |
---|
528 | SQLCHAR *ColumnName, |
---|
529 | SQLSMALLINT BufferLength, |
---|
530 | SQLSMALLINT *NameLength, |
---|
531 | SQLSMALLINT *DataType, |
---|
532 | SQLULEN *ColumnSize, |
---|
533 | SQLSMALLINT *DecimalDigits, |
---|
534 | SQLSMALLINT *Nullable); |
---|
535 | |
---|
536 | ep_SQLDescribeCol *fn; |
---|
537 | fn = (ep_SQLDescribeCol *) xdlsym(h_odbc, "SQLDescribeCol"); |
---|
538 | xassert(fn != NULL); |
---|
539 | return (*fn)(StatementHandle, ColumnNumber, ColumnName, |
---|
540 | BufferLength, NameLength, |
---|
541 | DataType, ColumnSize, DecimalDigits, Nullable); |
---|
542 | } |
---|
543 | |
---|
544 | SQLRETURN SQL_API dl_SQLGetDiagRec ( |
---|
545 | SQLSMALLINT HandleType, |
---|
546 | SQLHANDLE Handle, |
---|
547 | SQLSMALLINT RecNumber, |
---|
548 | SQLCHAR *Sqlstate, |
---|
549 | SQLINTEGER *NativeError, |
---|
550 | SQLCHAR *MessageText, |
---|
551 | SQLSMALLINT BufferLength, |
---|
552 | SQLSMALLINT *TextLength) |
---|
553 | { |
---|
554 | typedef SQLRETURN SQL_API ep_SQLGetDiagRec ( |
---|
555 | SQLSMALLINT HandleType, |
---|
556 | SQLHANDLE Handle, |
---|
557 | SQLSMALLINT RecNumber, |
---|
558 | SQLCHAR *Sqlstate, |
---|
559 | SQLINTEGER *NativeError, |
---|
560 | SQLCHAR *MessageText, |
---|
561 | SQLSMALLINT BufferLength, |
---|
562 | SQLSMALLINT *TextLength); |
---|
563 | |
---|
564 | ep_SQLGetDiagRec *fn; |
---|
565 | fn = (ep_SQLGetDiagRec *) xdlsym(h_odbc, "SQLGetDiagRec"); |
---|
566 | xassert(fn != NULL); |
---|
567 | return (*fn)(HandleType, Handle, RecNumber, Sqlstate, |
---|
568 | NativeError, MessageText, BufferLength, TextLength); |
---|
569 | } |
---|
570 | |
---|
571 | SQLRETURN SQL_API dl_SQLGetInfo ( |
---|
572 | SQLHDBC ConnectionHandle, |
---|
573 | SQLUSMALLINT InfoType, |
---|
574 | SQLPOINTER InfoValue, |
---|
575 | SQLSMALLINT BufferLength, |
---|
576 | SQLSMALLINT *StringLength) |
---|
577 | { |
---|
578 | typedef SQLRETURN SQL_API ep_SQLGetInfo ( |
---|
579 | SQLHDBC ConnectionHandle, |
---|
580 | SQLUSMALLINT InfoType, |
---|
581 | SQLPOINTER InfoValue, |
---|
582 | SQLSMALLINT BufferLength, |
---|
583 | SQLSMALLINT *StringLength); |
---|
584 | |
---|
585 | ep_SQLGetInfo *fn; |
---|
586 | fn = (ep_SQLGetInfo *) xdlsym(h_odbc, "SQLGetInfo"); |
---|
587 | xassert(fn != NULL); |
---|
588 | return (*fn)(ConnectionHandle, InfoType, InfoValue, BufferLength, |
---|
589 | StringLength); |
---|
590 | } |
---|
591 | |
---|
592 | SQLRETURN SQL_API dl_SQLNumResultCols ( |
---|
593 | SQLHSTMT StatementHandle, |
---|
594 | SQLSMALLINT *ColumnCount) |
---|
595 | { |
---|
596 | typedef SQLRETURN SQL_API ep_SQLNumResultCols ( |
---|
597 | SQLHSTMT StatementHandle, |
---|
598 | SQLSMALLINT *ColumnCount); |
---|
599 | |
---|
600 | ep_SQLNumResultCols *fn; |
---|
601 | fn = (ep_SQLNumResultCols *) xdlsym(h_odbc, "SQLNumResultCols"); |
---|
602 | xassert(fn != NULL); |
---|
603 | return (*fn)(StatementHandle, ColumnCount); |
---|
604 | } |
---|
605 | |
---|
606 | SQLRETURN SQL_API dl_SQLSetConnectAttr ( |
---|
607 | SQLHDBC ConnectionHandle, |
---|
608 | SQLINTEGER Attribute, |
---|
609 | SQLPOINTER Value, |
---|
610 | SQLINTEGER StringLength) |
---|
611 | { |
---|
612 | typedef SQLRETURN SQL_API ep_SQLSetConnectAttr ( |
---|
613 | SQLHDBC ConnectionHandle, |
---|
614 | SQLINTEGER Attribute, |
---|
615 | SQLPOINTER Value, |
---|
616 | SQLINTEGER StringLength); |
---|
617 | |
---|
618 | ep_SQLSetConnectAttr *fn; |
---|
619 | fn = (ep_SQLSetConnectAttr *) xdlsym(h_odbc, "SQLSetConnectAttr"); |
---|
620 | xassert(fn != NULL); |
---|
621 | return (*fn)(ConnectionHandle, Attribute, Value, StringLength); |
---|
622 | } |
---|
623 | |
---|
624 | SQLRETURN SQL_API dl_SQLSetEnvAttr ( |
---|
625 | SQLHENV EnvironmentHandle, |
---|
626 | SQLINTEGER Attribute, |
---|
627 | SQLPOINTER Value, |
---|
628 | SQLINTEGER StringLength) |
---|
629 | { |
---|
630 | typedef SQLRETURN SQL_API ep_SQLSetEnvAttr ( |
---|
631 | SQLHENV EnvironmentHandle, |
---|
632 | SQLINTEGER Attribute, |
---|
633 | SQLPOINTER Value, |
---|
634 | SQLINTEGER StringLength); |
---|
635 | |
---|
636 | ep_SQLSetEnvAttr *fn; |
---|
637 | fn = (ep_SQLSetEnvAttr *) xdlsym(h_odbc, "SQLSetEnvAttr"); |
---|
638 | xassert(fn != NULL); |
---|
639 | return (*fn)(EnvironmentHandle, Attribute, Value, StringLength); |
---|
640 | } |
---|
641 | |
---|
642 | static void extract_error( |
---|
643 | char *fn, |
---|
644 | SQLHANDLE handle, |
---|
645 | SQLSMALLINT type); |
---|
646 | |
---|
647 | static int is_numeric( |
---|
648 | SQLSMALLINT coltype); |
---|
649 | |
---|
650 | /*********************************************************************** |
---|
651 | * NAME |
---|
652 | * |
---|
653 | * db_iodbc_open - open connection to ODBC data base |
---|
654 | * |
---|
655 | * SYNOPSIS |
---|
656 | * |
---|
657 | * #include "glpsql.h" |
---|
658 | * void *db_iodbc_open(TABDCA *dca, int mode); |
---|
659 | * |
---|
660 | * DESCRIPTION |
---|
661 | * |
---|
662 | * The routine db_iodbc_open opens a connection to an ODBC data base. |
---|
663 | * It then executes the sql statements passed. |
---|
664 | * |
---|
665 | * In the case of table read the SELECT statement is executed. |
---|
666 | * |
---|
667 | * In the case of table write the INSERT statement is prepared. |
---|
668 | * RETURNS |
---|
669 | * |
---|
670 | * The routine returns a pointer to data storage area created. */ |
---|
671 | void *db_iodbc_open(TABDCA *dca, int mode) |
---|
672 | { void *ret; |
---|
673 | char **sqllines; |
---|
674 | |
---|
675 | sqllines = args_concat(dca); |
---|
676 | if (sqllines == NULL) |
---|
677 | { xprintf("Missing arguments in table statement.\n" |
---|
678 | "Please, supply table driver, dsn, and query.\n"); |
---|
679 | return NULL; |
---|
680 | } |
---|
681 | ret = db_iodbc_open_int(dca, mode, (const char **) sqllines); |
---|
682 | free_buffer(sqllines); |
---|
683 | return ret; |
---|
684 | } |
---|
685 | |
---|
686 | static void *db_iodbc_open_int(TABDCA *dca, int mode, const char |
---|
687 | **sqllines) |
---|
688 | { |
---|
689 | struct db_odbc *sql; |
---|
690 | SQLRETURN ret; |
---|
691 | SQLCHAR FAR *dsn; |
---|
692 | SQLCHAR info[256]; |
---|
693 | SQLSMALLINT colnamelen; |
---|
694 | SQLSMALLINT nullable; |
---|
695 | SQLSMALLINT scale; |
---|
696 | const char *arg; |
---|
697 | int narg; |
---|
698 | int i, j; |
---|
699 | int total; |
---|
700 | |
---|
701 | if (libodbc == NULL) |
---|
702 | { |
---|
703 | xprintf("No loader for shared ODBC library available\n"); |
---|
704 | return NULL; |
---|
705 | } |
---|
706 | |
---|
707 | if (h_odbc == NULL) |
---|
708 | { |
---|
709 | h_odbc = xdlopen(libodbc); |
---|
710 | if (h_odbc == NULL) |
---|
711 | { xprintf("unable to open library %s\n", libodbc); |
---|
712 | xprintf("%s\n", xerrmsg()); |
---|
713 | return NULL; |
---|
714 | } |
---|
715 | } |
---|
716 | |
---|
717 | sql = (struct db_odbc *) xmalloc(sizeof(struct db_odbc)); |
---|
718 | if (sql == NULL) |
---|
719 | return NULL; |
---|
720 | |
---|
721 | sql->mode = mode; |
---|
722 | sql->hdbc = NULL; |
---|
723 | sql->henv = NULL; |
---|
724 | sql->hstmt = NULL; |
---|
725 | sql->query = NULL; |
---|
726 | narg = mpl_tab_num_args(dca); |
---|
727 | |
---|
728 | dsn = (SQLCHAR FAR *) mpl_tab_get_arg(dca, 2); |
---|
729 | /* allocate an environment handle */ |
---|
730 | ret = dl_SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, |
---|
731 | &(sql->henv)); |
---|
732 | /* set attribute to enable application to run as ODBC 3.0 |
---|
733 | application */ |
---|
734 | ret = dl_SQLSetEnvAttr(sql->henv, SQL_ATTR_ODBC_VERSION, |
---|
735 | (void *) SQL_OV_ODBC3, 0); |
---|
736 | /* allocate a connection handle */ |
---|
737 | ret = dl_SQLAllocHandle(SQL_HANDLE_DBC, sql->henv, &(sql->hdbc)); |
---|
738 | /* connect */ |
---|
739 | ret = dl_SQLDriverConnect(sql->hdbc, NULL, dsn, SQL_NTS, NULL, 0, |
---|
740 | NULL, SQL_DRIVER_COMPLETE); |
---|
741 | if (SQL_SUCCEEDED(ret)) |
---|
742 | { /* output information about data base connection */ |
---|
743 | xprintf("Connected to "); |
---|
744 | dl_SQLGetInfo(sql->hdbc, SQL_DBMS_NAME, (SQLPOINTER)info, |
---|
745 | sizeof(info), NULL); |
---|
746 | xprintf("%s ", info); |
---|
747 | dl_SQLGetInfo(sql->hdbc, SQL_DBMS_VER, (SQLPOINTER)info, |
---|
748 | sizeof(info), NULL); |
---|
749 | xprintf("%s - ", info); |
---|
750 | dl_SQLGetInfo(sql->hdbc, SQL_DATABASE_NAME, (SQLPOINTER)info, |
---|
751 | sizeof(info), NULL); |
---|
752 | xprintf("%s\n", info); |
---|
753 | } |
---|
754 | else |
---|
755 | { /* describe error */ |
---|
756 | xprintf("Failed to connect\n"); |
---|
757 | extract_error("SQLDriverConnect", sql->hdbc, SQL_HANDLE_DBC); |
---|
758 | dl_SQLFreeHandle(SQL_HANDLE_DBC, sql->hdbc); |
---|
759 | dl_SQLFreeHandle(SQL_HANDLE_ENV, sql->henv); |
---|
760 | xfree(sql); |
---|
761 | return NULL; |
---|
762 | } |
---|
763 | /* set AUTOCOMMIT on*/ |
---|
764 | ret = dl_SQLSetConnectAttr(sql->hdbc, SQL_ATTR_AUTOCOMMIT, |
---|
765 | (SQLPOINTER)SQL_AUTOCOMMIT_ON, 0); |
---|
766 | /* allocate a statement handle */ |
---|
767 | ret = dl_SQLAllocHandle(SQL_HANDLE_STMT, sql->hdbc, &(sql->hstmt)); |
---|
768 | |
---|
769 | /* initialization queries */ |
---|
770 | for(j = 0; sqllines[j+1] != NULL; j++) |
---|
771 | { |
---|
772 | sql->query = (SQLCHAR *) sqllines[j]; |
---|
773 | xprintf("%s\n", sql->query); |
---|
774 | ret = dl_SQLExecDirect(sql->hstmt, sql->query, SQL_NTS); |
---|
775 | switch (ret) |
---|
776 | { |
---|
777 | case SQL_SUCCESS: |
---|
778 | case SQL_SUCCESS_WITH_INFO: |
---|
779 | case SQL_NO_DATA_FOUND: |
---|
780 | break; |
---|
781 | default: |
---|
782 | xprintf("db_iodbc_open: Query\n\"%s\"\nfailed.\n", |
---|
783 | sql->query); |
---|
784 | extract_error("SQLExecDirect", sql->hstmt, SQL_HANDLE_STMT); |
---|
785 | dl_SQLFreeHandle(SQL_HANDLE_STMT, sql->hstmt); |
---|
786 | dl_SQLDisconnect(sql->hdbc); |
---|
787 | dl_SQLFreeHandle(SQL_HANDLE_DBC, sql->hdbc); |
---|
788 | dl_SQLFreeHandle(SQL_HANDLE_ENV, sql->henv); |
---|
789 | xfree(sql); |
---|
790 | return NULL; |
---|
791 | } |
---|
792 | /* commit statement */ |
---|
793 | dl_SQLEndTran(SQL_HANDLE_ENV, sql->henv, SQL_COMMIT); |
---|
794 | } |
---|
795 | |
---|
796 | if ( sql->mode == 'R' ) |
---|
797 | { sql->nf = mpl_tab_num_flds(dca); |
---|
798 | for(j = 0; sqllines[j] != NULL; j++) |
---|
799 | arg = sqllines[j]; |
---|
800 | total = strlen(arg); |
---|
801 | if (total > 7 && 0 == strncmp(arg, "SELECT ", 7)) |
---|
802 | { |
---|
803 | total = strlen(arg); |
---|
804 | sql->query = xmalloc( (total+1) * sizeof(char)); |
---|
805 | strcpy (sql->query, arg); |
---|
806 | } |
---|
807 | else |
---|
808 | { |
---|
809 | sql->query = db_generate_select_stmt(dca); |
---|
810 | } |
---|
811 | xprintf("%s\n", sql->query); |
---|
812 | if (dl_SQLExecDirect(sql->hstmt, sql->query, SQL_NTS) != |
---|
813 | SQL_SUCCESS) |
---|
814 | { |
---|
815 | xprintf("db_iodbc_open: Query\n\"%s\"\nfailed.\n", sql->query); |
---|
816 | extract_error("SQLExecDirect", sql->hstmt, SQL_HANDLE_STMT); |
---|
817 | dl_SQLFreeHandle(SQL_HANDLE_STMT, sql->hstmt); |
---|
818 | dl_SQLDisconnect(sql->hdbc); |
---|
819 | dl_SQLFreeHandle(SQL_HANDLE_DBC, sql->hdbc); |
---|
820 | dl_SQLFreeHandle(SQL_HANDLE_ENV, sql->henv); |
---|
821 | xfree(sql->query); |
---|
822 | xfree(sql); |
---|
823 | return NULL; |
---|
824 | } |
---|
825 | xfree(sql->query); |
---|
826 | /* determine number of result columns */ |
---|
827 | ret = dl_SQLNumResultCols(sql->hstmt, &sql->nresultcols); |
---|
828 | total = sql->nresultcols; |
---|
829 | if (total > SQL_FIELD_MAX) |
---|
830 | { xprintf("db_iodbc_open: Too many fields (> %d) in query.\n" |
---|
831 | "\"%s\"\n", SQL_FIELD_MAX, sql->query); |
---|
832 | dl_SQLFreeHandle(SQL_HANDLE_STMT, sql->hstmt); |
---|
833 | dl_SQLDisconnect(sql->hdbc); |
---|
834 | dl_SQLFreeHandle(SQL_HANDLE_DBC, sql->hdbc); |
---|
835 | dl_SQLFreeHandle(SQL_HANDLE_ENV, sql->henv); |
---|
836 | xfree(sql->query); |
---|
837 | return NULL; |
---|
838 | } |
---|
839 | for (i = 1; i <= total; i++) |
---|
840 | { /* return a set of attributes for a column */ |
---|
841 | ret = dl_SQLDescribeCol(sql->hstmt, (SQLSMALLINT) i, |
---|
842 | sql->colname[i], SQL_FDLEN_MAX, |
---|
843 | &colnamelen, &(sql->coltype[i]), &(sql->collen[i]), &scale, |
---|
844 | &nullable); |
---|
845 | sql->isnumeric[i] = is_numeric(sql->coltype[i]); |
---|
846 | /* bind columns to program vars, converting all types to CHAR*/ |
---|
847 | if (sql->isnumeric[i]) |
---|
848 | { dl_SQLBindCol(sql->hstmt, i, SQL_DOUBLE, sql->data[i], |
---|
849 | SQL_FDLEN_MAX, &(sql->outlen[i])); |
---|
850 | } else |
---|
851 | { dl_SQLBindCol(sql->hstmt, i, SQL_CHAR, sql->data[i], |
---|
852 | SQL_FDLEN_MAX, &(sql->outlen[i])); |
---|
853 | } |
---|
854 | for (j = sql->nf; j >= 1; j--) |
---|
855 | { if (strcmp(mpl_tab_get_name(dca, j), sql->colname[i]) == 0) |
---|
856 | break; |
---|
857 | } |
---|
858 | sql->ref[i] = j; |
---|
859 | } |
---|
860 | } |
---|
861 | else if ( sql->mode == 'W' ) |
---|
862 | { for(j = 0; sqllines[j] != NULL; j++) |
---|
863 | arg = sqllines[j]; |
---|
864 | if ( NULL != strchr(arg, '?') ) |
---|
865 | { |
---|
866 | total = strlen(arg); |
---|
867 | sql->query = xmalloc( (total+1) * sizeof(char)); |
---|
868 | strcpy (sql->query, arg); |
---|
869 | } |
---|
870 | else |
---|
871 | { |
---|
872 | sql->query = db_generate_insert_stmt(dca); |
---|
873 | } |
---|
874 | xprintf("%s\n", sql->query); |
---|
875 | } |
---|
876 | return sql; |
---|
877 | } |
---|
878 | |
---|
879 | int db_iodbc_read(TABDCA *dca, void *link) |
---|
880 | { |
---|
881 | struct db_odbc *sql; |
---|
882 | SQLRETURN ret; |
---|
883 | char buf[SQL_FDLEN_MAX+1]; |
---|
884 | int i; |
---|
885 | int len; |
---|
886 | double num; |
---|
887 | |
---|
888 | sql = (struct db_odbc *) link; |
---|
889 | |
---|
890 | xassert(sql != NULL); |
---|
891 | xassert(sql->mode == 'R'); |
---|
892 | |
---|
893 | ret=dl_SQLFetch(sql->hstmt); |
---|
894 | if (ret== SQL_ERROR) |
---|
895 | return -1; |
---|
896 | if (ret== SQL_NO_DATA_FOUND) |
---|
897 | return -1; /*EOF*/ |
---|
898 | for (i=1; i <= sql->nresultcols; i++) |
---|
899 | { |
---|
900 | if (sql->ref[i] > 0) |
---|
901 | { |
---|
902 | len = sql->outlen[i]; |
---|
903 | if (len != SQL_NULL_DATA) |
---|
904 | { |
---|
905 | if (sql->isnumeric[i]) |
---|
906 | { mpl_tab_set_num(dca, sql->ref[i], |
---|
907 | *((const double *) sql->data[i])); |
---|
908 | } |
---|
909 | else |
---|
910 | { if (len > SQL_FDLEN_MAX) |
---|
911 | len = SQL_FDLEN_MAX; |
---|
912 | else if (len < 0) |
---|
913 | len = 0; |
---|
914 | strncpy(buf, (const char *) sql->data[i], len); |
---|
915 | buf[len] = 0x00; |
---|
916 | mpl_tab_set_str(dca, sql->ref[i], strtrim(buf)); |
---|
917 | } |
---|
918 | } |
---|
919 | } |
---|
920 | } |
---|
921 | return 0; |
---|
922 | } |
---|
923 | |
---|
924 | int db_iodbc_write(TABDCA *dca, void *link) |
---|
925 | { |
---|
926 | struct db_odbc *sql; |
---|
927 | char *part; |
---|
928 | char *query; |
---|
929 | char *template; |
---|
930 | char num[50]; |
---|
931 | int k; |
---|
932 | int len; |
---|
933 | int nf; |
---|
934 | |
---|
935 | sql = (struct db_odbc *) link; |
---|
936 | xassert(sql != NULL); |
---|
937 | xassert(sql->mode == 'W'); |
---|
938 | |
---|
939 | len = strlen(sql->query); |
---|
940 | template = (char *) xmalloc( (len + 1) * sizeof(char) ); |
---|
941 | strcpy(template, sql->query); |
---|
942 | |
---|
943 | nf = mpl_tab_num_flds(dca); |
---|
944 | for (k = 1; k <= nf; k++) |
---|
945 | { switch (mpl_tab_get_type(dca, k)) |
---|
946 | { case 'N': |
---|
947 | len += 20; |
---|
948 | break; |
---|
949 | case 'S': |
---|
950 | len += db_escaped_string_length(mpl_tab_get_str(dca, k)); |
---|
951 | len += 2; |
---|
952 | break; |
---|
953 | default: |
---|
954 | xassert(dca != dca); |
---|
955 | } |
---|
956 | } |
---|
957 | query = xmalloc( (len + 1 ) * sizeof(char) ); |
---|
958 | query[0] = 0x00; |
---|
959 | for (k = 1, part = strtok (template, "?"); (part != NULL); |
---|
960 | part = strtok (NULL, "?"), k++) |
---|
961 | { |
---|
962 | if (k > nf) break; |
---|
963 | strcat( query, part ); |
---|
964 | switch (mpl_tab_get_type(dca, k)) |
---|
965 | { case 'N': |
---|
966 | #if 0 /* 02/XI-2010 by xypron */ |
---|
967 | sprintf(num, "%-18g",mpl_tab_get_num(dca, k)); |
---|
968 | #else |
---|
969 | sprintf(num, "%.*g", DBL_DIG, mpl_tab_get_num(dca, k)); |
---|
970 | #endif |
---|
971 | strcat( query, num ); |
---|
972 | break; |
---|
973 | case 'S': |
---|
974 | strcat( query, "'"); |
---|
975 | db_escape_string( query + strlen(query), |
---|
976 | mpl_tab_get_str(dca, k) ); |
---|
977 | strcat( query, "'"); |
---|
978 | break; |
---|
979 | default: |
---|
980 | xassert(dca != dca); |
---|
981 | } |
---|
982 | } |
---|
983 | if (part != NULL) |
---|
984 | strcat(query, part); |
---|
985 | if (dl_SQLExecDirect(sql->hstmt, (SQLCHAR *) query, SQL_NTS) |
---|
986 | != SQL_SUCCESS) |
---|
987 | { |
---|
988 | xprintf("db_iodbc_write: Query\n\"%s\"\nfailed.\n", query); |
---|
989 | extract_error("SQLExecDirect", sql->hdbc, SQL_HANDLE_DBC); |
---|
990 | xfree(query); |
---|
991 | xfree(template); |
---|
992 | return 1; |
---|
993 | } |
---|
994 | |
---|
995 | xfree(query); |
---|
996 | xfree(template); |
---|
997 | return 0; |
---|
998 | } |
---|
999 | |
---|
1000 | int db_iodbc_close(TABDCA *dca, void *link) |
---|
1001 | { |
---|
1002 | struct db_odbc *sql; |
---|
1003 | |
---|
1004 | sql = (struct db_odbc *) link; |
---|
1005 | xassert(sql != NULL); |
---|
1006 | /* Commit */ |
---|
1007 | if ( sql->mode == 'W' ) |
---|
1008 | dl_SQLEndTran(SQL_HANDLE_ENV, sql->henv, SQL_COMMIT); |
---|
1009 | if ( sql->mode == 'R' ) |
---|
1010 | dl_SQLCloseCursor(sql->hstmt); |
---|
1011 | |
---|
1012 | dl_SQLFreeHandle(SQL_HANDLE_STMT, sql->hstmt); |
---|
1013 | dl_SQLDisconnect(sql->hdbc); |
---|
1014 | dl_SQLFreeHandle(SQL_HANDLE_DBC, sql->hdbc); |
---|
1015 | dl_SQLFreeHandle(SQL_HANDLE_ENV, sql->henv); |
---|
1016 | if ( sql->mode == 'W' ) |
---|
1017 | xfree(sql->query); |
---|
1018 | xfree(sql); |
---|
1019 | dca->link = NULL; |
---|
1020 | return 0; |
---|
1021 | } |
---|
1022 | |
---|
1023 | static void extract_error( |
---|
1024 | char *fn, |
---|
1025 | SQLHANDLE handle, |
---|
1026 | SQLSMALLINT type) |
---|
1027 | { |
---|
1028 | SQLINTEGER i = 0; |
---|
1029 | SQLINTEGER native; |
---|
1030 | SQLCHAR state[ 7 ]; |
---|
1031 | SQLCHAR text[256]; |
---|
1032 | SQLSMALLINT len; |
---|
1033 | SQLRETURN ret; |
---|
1034 | |
---|
1035 | xprintf("\nThe driver reported the following diagnostics whilst " |
---|
1036 | "running %s\n", fn); |
---|
1037 | |
---|
1038 | do |
---|
1039 | { |
---|
1040 | ret = dl_SQLGetDiagRec(type, handle, ++i, state, &native, text, |
---|
1041 | sizeof(text), &len ); |
---|
1042 | if (SQL_SUCCEEDED(ret)) |
---|
1043 | xprintf("%s:%ld:%ld:%s\n", state, i, native, text); |
---|
1044 | } |
---|
1045 | while( ret == SQL_SUCCESS ); |
---|
1046 | } |
---|
1047 | |
---|
1048 | static int is_numeric(SQLSMALLINT coltype) |
---|
1049 | { |
---|
1050 | int ret = 0; |
---|
1051 | switch (coltype) |
---|
1052 | { |
---|
1053 | case SQL_DECIMAL: |
---|
1054 | case SQL_NUMERIC: |
---|
1055 | case SQL_SMALLINT: |
---|
1056 | case SQL_INTEGER: |
---|
1057 | case SQL_REAL: |
---|
1058 | case SQL_FLOAT: |
---|
1059 | case SQL_DOUBLE: |
---|
1060 | case SQL_TINYINT: |
---|
1061 | case SQL_BIGINT: |
---|
1062 | ret = 1; |
---|
1063 | break; |
---|
1064 | } |
---|
1065 | return ret; |
---|
1066 | } |
---|
1067 | |
---|
1068 | #endif |
---|
1069 | |
---|
1070 | /**********************************************************************/ |
---|
1071 | |
---|
1072 | #ifndef HAVE_MYSQL |
---|
1073 | |
---|
1074 | void *db_mysql_open(TABDCA *dca, int mode) |
---|
1075 | { xassert(dca == dca); |
---|
1076 | xassert(mode == mode); |
---|
1077 | xprintf("MySQL table driver not supported\n"); |
---|
1078 | return NULL; |
---|
1079 | } |
---|
1080 | |
---|
1081 | int db_mysql_read(TABDCA *dca, void *link) |
---|
1082 | { xassert(dca != dca); |
---|
1083 | xassert(link != link); |
---|
1084 | return 0; |
---|
1085 | } |
---|
1086 | |
---|
1087 | int db_mysql_write(TABDCA *dca, void *link) |
---|
1088 | { xassert(dca != dca); |
---|
1089 | xassert(link != link); |
---|
1090 | return 0; |
---|
1091 | } |
---|
1092 | |
---|
1093 | int db_mysql_close(TABDCA *dca, void *link) |
---|
1094 | { xassert(dca != dca); |
---|
1095 | xassert(link != link); |
---|
1096 | return 0; |
---|
1097 | } |
---|
1098 | |
---|
1099 | #else |
---|
1100 | |
---|
1101 | #if defined(__CYGWIN__) || defined(__MINGW32__) || defined(__WOE__) |
---|
1102 | #include <windows.h> |
---|
1103 | #endif |
---|
1104 | |
---|
1105 | #ifdef __CYGWIN__ |
---|
1106 | #define byte_defined 1 |
---|
1107 | #endif |
---|
1108 | |
---|
1109 | #include <my_global.h> |
---|
1110 | #include <my_sys.h> |
---|
1111 | #include <mysql.h> |
---|
1112 | |
---|
1113 | struct db_mysql |
---|
1114 | { |
---|
1115 | int mode; /*'R' = Read, 'W' = Write*/ |
---|
1116 | MYSQL *con; /*connection*/ |
---|
1117 | MYSQL_RES *res; /*result*/ |
---|
1118 | int nf; |
---|
1119 | /* number of fields in the csv file */ |
---|
1120 | int ref[1+SQL_FIELD_MAX]; |
---|
1121 | /* ref[k] = k', if k-th field of the csv file corresponds to |
---|
1122 | k'-th field in the table statement; if ref[k] = 0, k-th field |
---|
1123 | of the csv file is ignored */ |
---|
1124 | char *query; |
---|
1125 | /* query generated by db_mysql_open */ |
---|
1126 | }; |
---|
1127 | |
---|
1128 | void STDCALL dl_mysql_close(MYSQL *sock) |
---|
1129 | { |
---|
1130 | typedef void STDCALL ep_mysql_close(MYSQL *sock); |
---|
1131 | |
---|
1132 | ep_mysql_close *fn; |
---|
1133 | fn = (ep_mysql_close *) xdlsym(h_mysql, "mysql_close"); |
---|
1134 | xassert(fn != NULL); |
---|
1135 | return (*fn)(sock); |
---|
1136 | } |
---|
1137 | |
---|
1138 | const char * STDCALL dl_mysql_error(MYSQL *mysql) |
---|
1139 | { |
---|
1140 | typedef const char * STDCALL ep_mysql_error(MYSQL *mysql); |
---|
1141 | |
---|
1142 | ep_mysql_error *fn; |
---|
1143 | fn = (ep_mysql_error *) xdlsym(h_mysql, "mysql_error"); |
---|
1144 | xassert(fn != NULL); |
---|
1145 | return (*fn)(mysql); |
---|
1146 | } |
---|
1147 | |
---|
1148 | MYSQL_FIELD * STDCALL dl_mysql_fetch_fields(MYSQL_RES *res) |
---|
1149 | { |
---|
1150 | typedef MYSQL_FIELD * STDCALL |
---|
1151 | ep_mysql_fetch_fields(MYSQL_RES *res); |
---|
1152 | |
---|
1153 | ep_mysql_fetch_fields *fn; |
---|
1154 | fn = (ep_mysql_fetch_fields *) xdlsym(h_mysql, "mysql_fetch_fields"); |
---|
1155 | xassert(fn != NULL); |
---|
1156 | return (*fn)(res); |
---|
1157 | } |
---|
1158 | |
---|
1159 | unsigned long * STDCALL dl_mysql_fetch_lengths(MYSQL_RES *result) |
---|
1160 | { |
---|
1161 | typedef unsigned long * STDCALL |
---|
1162 | ep_mysql_fetch_lengths(MYSQL_RES *result); |
---|
1163 | |
---|
1164 | ep_mysql_fetch_lengths *fn; |
---|
1165 | fn = (ep_mysql_fetch_lengths *) xdlsym(h_mysql, |
---|
1166 | "mysql_fetch_lengths"); |
---|
1167 | xassert(fn != NULL); |
---|
1168 | return (*fn)(result); |
---|
1169 | } |
---|
1170 | |
---|
1171 | MYSQL_ROW STDCALL dl_mysql_fetch_row(MYSQL_RES *result) |
---|
1172 | { |
---|
1173 | typedef MYSQL_ROW STDCALL ep_mysql_fetch_row(MYSQL_RES *result); |
---|
1174 | |
---|
1175 | ep_mysql_fetch_row *fn; |
---|
1176 | fn = (ep_mysql_fetch_row *) xdlsym(h_mysql, "mysql_fetch_row"); |
---|
1177 | xassert(fn != NULL); |
---|
1178 | return (*fn)(result); |
---|
1179 | } |
---|
1180 | |
---|
1181 | unsigned int STDCALL dl_mysql_field_count(MYSQL *mysql) |
---|
1182 | { |
---|
1183 | typedef unsigned int STDCALL ep_mysql_field_count(MYSQL *mysql); |
---|
1184 | |
---|
1185 | ep_mysql_field_count *fn; |
---|
1186 | fn = (ep_mysql_field_count *) xdlsym(h_mysql, "mysql_field_count"); |
---|
1187 | xassert(fn != NULL); |
---|
1188 | return (*fn)(mysql); |
---|
1189 | } |
---|
1190 | |
---|
1191 | MYSQL * STDCALL dl_mysql_init(MYSQL *mysql) |
---|
1192 | { |
---|
1193 | typedef MYSQL * STDCALL ep_mysql_init(MYSQL *mysql); |
---|
1194 | |
---|
1195 | ep_mysql_init *fn; |
---|
1196 | fn = (ep_mysql_init *) xdlsym(h_mysql, "mysql_init"); |
---|
1197 | xassert(fn != NULL); |
---|
1198 | return (*fn)(mysql); |
---|
1199 | } |
---|
1200 | |
---|
1201 | unsigned int STDCALL dl_mysql_num_fields(MYSQL_RES *res) |
---|
1202 | { |
---|
1203 | typedef unsigned int STDCALL ep_mysql_num_fields(MYSQL_RES *res); |
---|
1204 | |
---|
1205 | ep_mysql_num_fields *fn; |
---|
1206 | fn = (ep_mysql_num_fields *) xdlsym(h_mysql, "mysql_num_fields"); |
---|
1207 | xassert(fn != NULL); |
---|
1208 | return (*fn)(res); |
---|
1209 | } |
---|
1210 | |
---|
1211 | int STDCALL dl_mysql_query(MYSQL *mysql, const char *q) |
---|
1212 | { |
---|
1213 | typedef int STDCALL ep_mysql_query(MYSQL *mysql, const char *q); |
---|
1214 | |
---|
1215 | ep_mysql_query *fn; |
---|
1216 | fn = (ep_mysql_query *) xdlsym(h_mysql, "mysql_query"); |
---|
1217 | xassert(fn != NULL); |
---|
1218 | return (*fn)(mysql, q); |
---|
1219 | } |
---|
1220 | |
---|
1221 | MYSQL * STDCALL dl_mysql_real_connect(MYSQL *mysql, const char *host, |
---|
1222 | const char *user, |
---|
1223 | const char *passwd, |
---|
1224 | const char *db, |
---|
1225 | unsigned int port, |
---|
1226 | const char *unix_socket, |
---|
1227 | unsigned long clientflag) |
---|
1228 | { |
---|
1229 | typedef MYSQL * STDCALL ep_mysql_real_connect(MYSQL *mysql, |
---|
1230 | const char *host, |
---|
1231 | const char *user, |
---|
1232 | const char *passwd, |
---|
1233 | const char *db, |
---|
1234 | unsigned int port, |
---|
1235 | const char *unix_socket, |
---|
1236 | unsigned long clientflag); |
---|
1237 | |
---|
1238 | ep_mysql_real_connect *fn; |
---|
1239 | fn = (ep_mysql_real_connect *) xdlsym(h_mysql, |
---|
1240 | "mysql_real_connect"); |
---|
1241 | xassert(fn != NULL); |
---|
1242 | return (*fn)(mysql, host, user, passwd, db, port, unix_socket, |
---|
1243 | clientflag); |
---|
1244 | } |
---|
1245 | |
---|
1246 | MYSQL_RES * STDCALL dl_mysql_use_result(MYSQL *mysql) |
---|
1247 | { |
---|
1248 | typedef MYSQL_RES * STDCALL ep_mysql_use_result(MYSQL *mysql); |
---|
1249 | ep_mysql_use_result *fn; |
---|
1250 | fn = (ep_mysql_use_result *) xdlsym(h_mysql, "mysql_use_result"); |
---|
1251 | xassert(fn != NULL); |
---|
1252 | return (*fn)(mysql); |
---|
1253 | } |
---|
1254 | |
---|
1255 | /*********************************************************************** |
---|
1256 | * NAME |
---|
1257 | * |
---|
1258 | * db_mysql_open - open connection to ODBC data base |
---|
1259 | * |
---|
1260 | * SYNOPSIS |
---|
1261 | * |
---|
1262 | * #include "glpsql.h" |
---|
1263 | * void *db_mysql_open(TABDCA *dca, int mode); |
---|
1264 | * |
---|
1265 | * DESCRIPTION |
---|
1266 | * |
---|
1267 | * The routine db_mysql_open opens a connection to a MySQL data base. |
---|
1268 | * It then executes the sql statements passed. |
---|
1269 | * |
---|
1270 | * In the case of table read the SELECT statement is executed. |
---|
1271 | * |
---|
1272 | * In the case of table write the INSERT statement is prepared. |
---|
1273 | * RETURNS |
---|
1274 | * |
---|
1275 | * The routine returns a pointer to data storage area created. */ |
---|
1276 | |
---|
1277 | void *db_mysql_open(TABDCA *dca, int mode) |
---|
1278 | { void *ret; |
---|
1279 | char **sqllines; |
---|
1280 | |
---|
1281 | sqllines = args_concat(dca); |
---|
1282 | if (sqllines == NULL) |
---|
1283 | { xprintf("Missing arguments in table statement.\n" |
---|
1284 | "Please, supply table driver, dsn, and query.\n"); |
---|
1285 | return NULL; |
---|
1286 | } |
---|
1287 | ret = db_mysql_open_int(dca, mode, (const char **) sqllines); |
---|
1288 | free_buffer(sqllines); |
---|
1289 | return ret; |
---|
1290 | } |
---|
1291 | |
---|
1292 | static void *db_mysql_open_int(TABDCA *dca, int mode, const char |
---|
1293 | **sqllines) |
---|
1294 | { |
---|
1295 | struct db_mysql *sql = NULL; |
---|
1296 | char *arg = NULL; |
---|
1297 | const char *field; |
---|
1298 | MYSQL_FIELD *fields; |
---|
1299 | char *keyword; |
---|
1300 | char *value; |
---|
1301 | char *query; |
---|
1302 | char *dsn; |
---|
1303 | /* "Server=[server_name];Database=[database_name];UID=[username];*/ |
---|
1304 | /* PWD=[password];Port=[port]"*/ |
---|
1305 | char *server = NULL; /* Server */ |
---|
1306 | char *user = NULL; /* UID */ |
---|
1307 | char *password = NULL; /* PWD */ |
---|
1308 | char *database = NULL; /* Database */ |
---|
1309 | unsigned int port = 0; /* Port */ |
---|
1310 | int narg; |
---|
1311 | int i, j, total; |
---|
1312 | |
---|
1313 | if (libmysql == NULL) |
---|
1314 | { |
---|
1315 | xprintf("No loader for shared MySQL library available\n"); |
---|
1316 | return NULL; |
---|
1317 | } |
---|
1318 | |
---|
1319 | if (h_mysql == NULL) |
---|
1320 | { |
---|
1321 | h_mysql = xdlopen(libmysql); |
---|
1322 | if (h_mysql == NULL) |
---|
1323 | { xprintf("unable to open library %s\n", libmysql); |
---|
1324 | xprintf("%s\n", xerrmsg()); |
---|
1325 | return NULL; |
---|
1326 | } |
---|
1327 | } |
---|
1328 | |
---|
1329 | sql = (struct db_mysql *) xmalloc(sizeof(struct db_mysql)); |
---|
1330 | if (sql == NULL) |
---|
1331 | return NULL; |
---|
1332 | sql->mode = mode; |
---|
1333 | sql->res = NULL; |
---|
1334 | sql->query = NULL; |
---|
1335 | sql->nf = mpl_tab_num_flds(dca); |
---|
1336 | |
---|
1337 | narg = mpl_tab_num_args(dca); |
---|
1338 | if (narg < 3 ) |
---|
1339 | xprintf("MySQL driver: string list too short \n"); |
---|
1340 | |
---|
1341 | /* get connection string*/ |
---|
1342 | dsn = (char *) mpl_tab_get_arg(dca, 2); |
---|
1343 | /* copy connection string*/ |
---|
1344 | i = strlen(dsn); |
---|
1345 | i++; |
---|
1346 | arg = xmalloc(i * sizeof(char)); |
---|
1347 | strcpy(arg, dsn); |
---|
1348 | /*tokenize connection string*/ |
---|
1349 | for (i = 1, keyword = strtok (arg, "="); (keyword != NULL); |
---|
1350 | keyword = strtok (NULL, "="), i++) |
---|
1351 | { |
---|
1352 | value = strtok (NULL, ";"); |
---|
1353 | if (value==NULL) |
---|
1354 | { |
---|
1355 | xprintf("db_mysql_open: Missing value for keyword %s\n", |
---|
1356 | keyword); |
---|
1357 | xfree(arg); |
---|
1358 | xfree(sql); |
---|
1359 | return NULL; |
---|
1360 | } |
---|
1361 | if (0 == strcmp(keyword, "Server")) |
---|
1362 | server = value; |
---|
1363 | else if (0 == strcmp(keyword, "Database")) |
---|
1364 | database = value; |
---|
1365 | else if (0 == strcmp(keyword, "UID")) |
---|
1366 | user = value; |
---|
1367 | else if (0 == strcmp(keyword, "PWD")) |
---|
1368 | password = value; |
---|
1369 | else if (0 == strcmp(keyword, "Port")) |
---|
1370 | port = (unsigned int) atol(value); |
---|
1371 | } |
---|
1372 | /* Connect to database */ |
---|
1373 | sql->con = dl_mysql_init(NULL); |
---|
1374 | if (!dl_mysql_real_connect(sql->con, server, user, password, database, |
---|
1375 | port, NULL, 0)) |
---|
1376 | { |
---|
1377 | xprintf("db_mysql_open: Connect failed\n"); |
---|
1378 | xprintf("%s\n", dl_mysql_error(sql->con)); |
---|
1379 | xfree(arg); |
---|
1380 | xfree(sql); |
---|
1381 | return NULL; |
---|
1382 | } |
---|
1383 | xfree(arg); |
---|
1384 | |
---|
1385 | for(j = 0; sqllines[j+1] != NULL; j++) |
---|
1386 | { query = (char *) sqllines[j]; |
---|
1387 | xprintf("%s\n", query); |
---|
1388 | if (dl_mysql_query(sql->con, query)) |
---|
1389 | { |
---|
1390 | xprintf("db_mysql_open: Query\n\"%s\"\nfailed.\n", query); |
---|
1391 | xprintf("%s\n",dl_mysql_error(sql->con)); |
---|
1392 | dl_mysql_close(sql->con); |
---|
1393 | xfree(sql); |
---|
1394 | return NULL; |
---|
1395 | } |
---|
1396 | } |
---|
1397 | |
---|
1398 | if ( sql->mode == 'R' ) |
---|
1399 | { sql->nf = mpl_tab_num_flds(dca); |
---|
1400 | for(j = 0; sqllines[j] != NULL; j++) |
---|
1401 | arg = (char *) sqllines[j]; |
---|
1402 | total = strlen(arg); |
---|
1403 | if (total > 7 && 0 == strncmp(arg, "SELECT ", 7)) |
---|
1404 | { |
---|
1405 | total = strlen(arg); |
---|
1406 | query = xmalloc( (total+1) * sizeof(char)); |
---|
1407 | strcpy (query, arg); |
---|
1408 | } |
---|
1409 | else |
---|
1410 | { |
---|
1411 | query = db_generate_select_stmt(dca); |
---|
1412 | } |
---|
1413 | xprintf("%s\n", query); |
---|
1414 | if (dl_mysql_query(sql->con, query)) |
---|
1415 | { |
---|
1416 | xprintf("db_mysql_open: Query\n\"%s\"\nfailed.\n", query); |
---|
1417 | xprintf("%s\n",dl_mysql_error(sql->con)); |
---|
1418 | dl_mysql_close(sql->con); |
---|
1419 | xfree(query); |
---|
1420 | xfree(sql); |
---|
1421 | return NULL; |
---|
1422 | } |
---|
1423 | xfree(query); |
---|
1424 | sql->res = dl_mysql_use_result(sql->con); |
---|
1425 | if (sql->res) |
---|
1426 | { |
---|
1427 | /* create references between query results and table fields*/ |
---|
1428 | total = dl_mysql_num_fields(sql->res); |
---|
1429 | if (total > SQL_FIELD_MAX) |
---|
1430 | { xprintf("db_mysql_open: Too many fields (> %d) in query.\n" |
---|
1431 | "\"%s\"\n", SQL_FIELD_MAX, query); |
---|
1432 | xprintf("%s\n",dl_mysql_error(sql->con)); |
---|
1433 | dl_mysql_close(sql->con); |
---|
1434 | xfree(query); |
---|
1435 | xfree(sql); |
---|
1436 | return NULL; |
---|
1437 | } |
---|
1438 | fields = dl_mysql_fetch_fields(sql->res); |
---|
1439 | for (i = 1; i <= total; i++) |
---|
1440 | { |
---|
1441 | for (j = sql->nf; j >= 1; j--) |
---|
1442 | { |
---|
1443 | if (strcmp(mpl_tab_get_name(dca, j), fields[i-1].name) |
---|
1444 | == 0) |
---|
1445 | break; |
---|
1446 | } |
---|
1447 | sql->ref[i] = j; |
---|
1448 | } |
---|
1449 | } |
---|
1450 | else |
---|
1451 | { |
---|
1452 | if(dl_mysql_field_count(sql->con) == 0) |
---|
1453 | { |
---|
1454 | xprintf("db_mysql_open: Query was not a SELECT\n\"%s\"\n", |
---|
1455 | query); |
---|
1456 | xprintf("%s\n",dl_mysql_error(sql->con)); |
---|
1457 | xfree(query); |
---|
1458 | xfree(sql); |
---|
1459 | return NULL; |
---|
1460 | } |
---|
1461 | else |
---|
1462 | { |
---|
1463 | xprintf("db_mysql_open: Query\n\"%s\"\nfailed.\n", query); |
---|
1464 | xprintf("%s\n",dl_mysql_error(sql->con)); |
---|
1465 | xfree(query); |
---|
1466 | xfree(sql); |
---|
1467 | return NULL; |
---|
1468 | } |
---|
1469 | } |
---|
1470 | } |
---|
1471 | else if ( sql->mode == 'W' ) |
---|
1472 | { for(j = 0; sqllines[j] != NULL; j++) |
---|
1473 | arg = (char *) sqllines[j]; |
---|
1474 | if ( NULL != strchr(arg, '?') ) |
---|
1475 | { |
---|
1476 | total = strlen(arg); |
---|
1477 | query = xmalloc( (total+1) * sizeof(char)); |
---|
1478 | strcpy (query, arg); |
---|
1479 | } |
---|
1480 | else |
---|
1481 | query = db_generate_insert_stmt(dca); |
---|
1482 | sql->query = query; |
---|
1483 | xprintf("%s\n", query); |
---|
1484 | } |
---|
1485 | return sql; |
---|
1486 | } |
---|
1487 | |
---|
1488 | int db_mysql_read(TABDCA *dca, void *link) |
---|
1489 | { struct db_mysql *sql; |
---|
1490 | char buf[255+1]; |
---|
1491 | char **row; |
---|
1492 | unsigned long *lengths; |
---|
1493 | MYSQL_FIELD *fields; |
---|
1494 | double num; |
---|
1495 | int len; |
---|
1496 | unsigned long num_fields; |
---|
1497 | int i; |
---|
1498 | |
---|
1499 | sql = (struct db_mysql *) link; |
---|
1500 | |
---|
1501 | xassert(sql != NULL); |
---|
1502 | xassert(sql->mode == 'R'); |
---|
1503 | if (NULL == sql->res) |
---|
1504 | { |
---|
1505 | xprintf("db_mysql_read: no result set available"); |
---|
1506 | return 1; |
---|
1507 | } |
---|
1508 | if (NULL==(row = (char **)dl_mysql_fetch_row(sql->res))) { |
---|
1509 | return -1; /*EOF*/ |
---|
1510 | } |
---|
1511 | lengths = dl_mysql_fetch_lengths(sql->res); |
---|
1512 | fields = dl_mysql_fetch_fields(sql->res); |
---|
1513 | num_fields = dl_mysql_num_fields(sql->res); |
---|
1514 | for (i=1; i <= num_fields; i++) |
---|
1515 | { |
---|
1516 | if (row[i-1] != NULL) |
---|
1517 | { len = (size_t) lengths[i-1]; |
---|
1518 | if (len > 255) |
---|
1519 | len = 255; |
---|
1520 | strncpy(buf, (const char *) row[i-1], len); |
---|
1521 | buf[len] = 0x00; |
---|
1522 | if (0 != (fields[i-1].flags & NUM_FLAG)) |
---|
1523 | { strspx(buf); /* remove spaces*/ |
---|
1524 | if (str2num(buf, &num) != 0) |
---|
1525 | { xprintf("'%s' cannot be converted to a number.\n", buf); |
---|
1526 | return 1; |
---|
1527 | } |
---|
1528 | if (sql->ref[i] > 0) |
---|
1529 | mpl_tab_set_num(dca, sql->ref[i], num); |
---|
1530 | } |
---|
1531 | else |
---|
1532 | { if (sql->ref[i] > 0) |
---|
1533 | mpl_tab_set_str(dca, sql->ref[i], strtrim(buf)); |
---|
1534 | } |
---|
1535 | } |
---|
1536 | } |
---|
1537 | return 0; |
---|
1538 | } |
---|
1539 | |
---|
1540 | int db_mysql_write(TABDCA *dca, void *link) |
---|
1541 | { |
---|
1542 | struct db_mysql *sql; |
---|
1543 | char *part; |
---|
1544 | char *query; |
---|
1545 | char *template; |
---|
1546 | char num[50]; |
---|
1547 | int k; |
---|
1548 | int len; |
---|
1549 | int nf; |
---|
1550 | |
---|
1551 | sql = (struct db_mysql *) link; |
---|
1552 | xassert(sql != NULL); |
---|
1553 | xassert(sql->mode == 'W'); |
---|
1554 | |
---|
1555 | len = strlen(sql->query); |
---|
1556 | template = (char *) xmalloc( (len + 1) * sizeof(char) ); |
---|
1557 | strcpy(template, sql->query); |
---|
1558 | |
---|
1559 | nf = mpl_tab_num_flds(dca); |
---|
1560 | for (k = 1; k <= nf; k++) |
---|
1561 | { switch (mpl_tab_get_type(dca, k)) |
---|
1562 | { case 'N': |
---|
1563 | len += 20; |
---|
1564 | break; |
---|
1565 | case 'S': |
---|
1566 | len += db_escaped_string_length(mpl_tab_get_str(dca, k)); |
---|
1567 | len += 2; |
---|
1568 | break; |
---|
1569 | default: |
---|
1570 | xassert(dca != dca); |
---|
1571 | } |
---|
1572 | } |
---|
1573 | query = xmalloc( (len + 1 ) * sizeof(char) ); |
---|
1574 | query[0] = 0x00; |
---|
1575 | for (k = 1, part = strtok (template, "?"); (part != NULL); |
---|
1576 | part = strtok (NULL, "?"), k++) |
---|
1577 | { |
---|
1578 | if (k > nf) break; |
---|
1579 | strcat( query, part ); |
---|
1580 | switch (mpl_tab_get_type(dca, k)) |
---|
1581 | { case 'N': |
---|
1582 | #if 0 /* 02/XI-2010 by xypron */ |
---|
1583 | sprintf(num, "%-18g",mpl_tab_get_num(dca, k)); |
---|
1584 | #else |
---|
1585 | sprintf(num, "%.*g", DBL_DIG, mpl_tab_get_num(dca, k)); |
---|
1586 | #endif |
---|
1587 | strcat( query, num ); |
---|
1588 | break; |
---|
1589 | case 'S': |
---|
1590 | strcat( query, "'"); |
---|
1591 | db_escape_string( query + strlen(query), |
---|
1592 | mpl_tab_get_str(dca, k) ); |
---|
1593 | strcat( query, "'"); |
---|
1594 | break; |
---|
1595 | default: |
---|
1596 | xassert(dca != dca); |
---|
1597 | } |
---|
1598 | } |
---|
1599 | if (part != NULL) |
---|
1600 | strcat(query, part); |
---|
1601 | if (dl_mysql_query(sql->con, query)) |
---|
1602 | { |
---|
1603 | xprintf("db_mysql_write: Query\n\"%s\"\nfailed.\n", query); |
---|
1604 | xprintf("%s\n",dl_mysql_error(sql->con)); |
---|
1605 | xfree(query); |
---|
1606 | xfree(template); |
---|
1607 | return 1; |
---|
1608 | } |
---|
1609 | |
---|
1610 | xfree(query); |
---|
1611 | xfree(template); |
---|
1612 | return 0; |
---|
1613 | } |
---|
1614 | |
---|
1615 | int db_mysql_close(TABDCA *dca, void *link) |
---|
1616 | { |
---|
1617 | struct db_mysql *sql; |
---|
1618 | |
---|
1619 | sql = (struct db_mysql *) link; |
---|
1620 | xassert(sql != NULL); |
---|
1621 | dl_mysql_close(sql->con); |
---|
1622 | if ( sql->mode == 'W' ) |
---|
1623 | xfree(sql->query); |
---|
1624 | xfree(sql); |
---|
1625 | dca->link = NULL; |
---|
1626 | return 0; |
---|
1627 | } |
---|
1628 | |
---|
1629 | #endif |
---|
1630 | |
---|
1631 | /* eof */ |
---|