9 extern IISQLCA sqlca; /* SQL Communications Area */
15 #define INGRES_DEBUG 0
16 #define DEBB(x) if (INGRES_DEBUG >= x) {
19 /* ---Implementations--- */
23 if (sqlca.sqlcode < 0)
25 /* # line 23 "myingres.sc" */ /* inquire_ingres */
27 IILQisInqSqlio((short *)0,1,32,255,errbuf,63);
29 /* # line 24 "myingres.sc" */ /* host code */
30 printf("Ingres-DBMS-Fehler: %s\n", errbuf);
36 short INGgetCols(const char *stmt)
40 sqlda = (IISQLDA *)calloc(1,IISQDA_HEAD_SIZE + (number * IISQDA_VAR_SIZE));
41 if (sqlda == (IISQLDA *)0)
42 { printf("Failure allocating %d SQLDA elements\n",number); }
44 char stmt_buffer[2000];
45 strcpy(stmt_buffer,stmt);
46 /* # line 46 "myingres.sc" */ /* prepare */
49 IIsqPrepare(0,(char *)"s1",(char *)0,0,stmt_buffer);
51 /* # line 47 "myingres.sc" */ /* describe */
54 IIsqDescribe(0,(char *)"s1",sqlda,0);
56 /* # line 49 "myingres.sc" */ /* host code */
61 IISQLDA *INGgetDescriptor(short numCols, const char *stmt)
64 sqlda = (IISQLDA *)calloc(1,IISQDA_HEAD_SIZE + (numCols * IISQDA_VAR_SIZE));
65 if (sqlda == (IISQLDA *)0)
66 { printf("Failure allocating %d SQLDA elements\n",numCols); }
67 sqlda->sqln = numCols;
68 char stmt_buffer[2000];
69 strcpy(stmt_buffer,stmt);
70 /* # line 69 "myingres.sc" */ /* prepare */
73 IIsqPrepare(0,(char *)"s2",sqlda,0,stmt_buffer);
75 /* # line 71 "myingres.sc" */ /* host code */
77 for (i=0;i<sqlda->sqld;++i)
79 sqlda->sqlvar[i].sqldata =
80 (char *)malloc(sqlda->sqlvar[i].sqllen);
81 if (sqlda->sqlvar[i].sqldata == (char *)0)
82 { printf("Failure allocating %d bytes for SQLVAR data\n",sqlda->sqlvar[i].sqllen); }
83 sqlda->sqlvar[i].sqlind = (short *)malloc(sizeof(short));
84 if (sqlda->sqlvar[i].sqlind == (short *)0)
85 { printf("Failure allocating sqlind\n"); }
89 void INGfreeDescriptor(IISQLDA *sqlda)
92 for ( i = 0 ; i < sqlda->sqld ; ++i )
94 free(sqlda->sqlvar[i].sqldata);
95 free(sqlda->sqlvar[i].sqlind);
100 int INGgetTypeSize(IISQLVAR *ingvar)
103 switch (ingvar->sqltype)
112 inglength = ingvar->sqllen;
116 INGresult *INGgetINGresult(IISQLDA *sqlda)
118 INGresult *result = NULL;
119 result = (INGresult *)calloc(1, sizeof(INGresult));
120 if (result == (INGresult *)0)
121 { printf("Failure allocating INGresult\n"); }
122 result->sqlda = sqlda;
123 result->num_fields = sqlda->sqld;
124 result->num_rows = 0;
125 result->first_row = NULL;
126 result->status = ING_EMPTY_RESULT;
127 result->act_row = NULL;
128 strcpy(result->numrowstring,"");
129 result->fields = (INGRES_FIELD *)calloc(1, sizeof(INGRES_FIELD) * result->num_fields);
130 if (result->fields == (INGRES_FIELD *)0)
131 { printf("Failure allocating %d INGRES_FIELD elements\n",result->num_fields); }
133 printf("INGgetINGresult, before loop over %d fields\n", result->num_fields);
136 for (i=0;i<result->num_fields;++i)
138 memset(result->fields[i].name,'\0',34);
139 strncpy(result->fields[i].name,
140 sqlda->sqlvar[i].sqlname.sqlnamec,
141 sqlda->sqlvar[i].sqlname.sqlnamel);
142 result->fields[i].max_length = INGgetTypeSize(&sqlda->sqlvar[i]);
143 result->fields[i].type = abs(sqlda->sqlvar[i].sqltype);
144 result->fields[i].flags = (abs(sqlda->sqlvar[i].sqltype)<0) ? 1 : 0;
148 void INGfreeINGresult(INGresult *ing_res)
150 /* TODO: free all rows and fields, then res, not descriptor! */
151 if( ing_res != NULL )
153 /* use of rows is a nasty workaround til I find the reason,
154 why aggregates like max() don't work
156 int rows = ing_res->num_rows;
158 ing_res->act_row = ing_res->first_row;
159 while (ing_res->act_row != NULL && rows > 0)
161 rowtemp = ing_res->act_row->next;
162 INGfreeRowSpace(ing_res->act_row, ing_res->sqlda);
163 ing_res->act_row = rowtemp;
166 free(ing_res->fields);
171 ING_ROW *INGgetRowSpace(INGresult *ing_res)
173 IISQLDA *sqlda = ing_res->sqlda;
175 IISQLVAR *vars = NULL;
176 row = (ING_ROW *)calloc(1,sizeof(ING_ROW));
177 if (row == (ING_ROW *)0)
178 { printf("Failure allocating ING_ROW\n"); }
179 vars = (IISQLVAR *)calloc(1,sizeof(IISQLVAR) * sqlda->sqld);
180 if (vars == (IISQLVAR *)0)
181 { printf("Failure allocating %d SQLVAR elements\n",sqlda->sqld); }
185 unsigned short len; /* used for VARCHAR type length */
186 for (i=0;i<sqlda->sqld;++i)
188 /* make strings out of the data, then the space and assign
189 (why string? at least it seems that way, looking into the sources)
191 switch (abs(ing_res->fields[i].type))
194 len = ((ING_VARCHAR *)sqlda->sqlvar[i].sqldata)->len;
196 printf("length of varchar: %d\n", len);
198 vars[i].sqldata = (char *)malloc(len+1);
199 if (vars[i].sqldata == (char *)0)
200 { printf("Failure allocating %d bytes for SQLVAR data\n",len+1); }
201 memcpy(vars[i].sqldata,sqlda->sqlvar[i].sqldata+2,len);
202 vars[i].sqldata[len] = '\0';
205 vars[i].sqldata = (char *)malloc(ing_res->fields[i].max_length+1);
206 if (vars[i].sqldata == (char *)0)
207 { printf("Failure allocating %d bytes for SQLVAR data\n",ing_res->fields[i].max_length); }
208 memcpy(vars[i].sqldata,sqlda->sqlvar[i].sqldata,sqlda->sqlvar[i].sqllen);
209 vars[i].sqldata[ing_res->fields[i].max_length] = '\0';
212 vars[i].sqldata = (char *)malloc(20);
213 memset(vars[i].sqldata,'\0',20);
214 sprintf(vars[i].sqldata,"%d",*(int*)sqlda->sqlvar[i].sqldata);
217 vars[i].sqlind = (short *)malloc(sizeof(short));
218 if (sqlda->sqlvar[i].sqlind == (short *)0)
219 { printf("Failure allocating sqlind\n"); }
220 memcpy(vars[i].sqlind,sqlda->sqlvar[i].sqlind,sizeof(short));
222 printf("INGgetRowSpace, Field %d, type %d, length %d, name %s\n",
223 i, sqlda->sqlvar[i].sqltype, sqlda->sqlvar[i].sqllen, ing_res->fields[i].name);
228 void INGfreeRowSpace(ING_ROW *row, IISQLDA *sqlda)
231 if (row == NULL || sqlda == NULL)
235 for ( i = 0 ; i < sqlda->sqld ; ++i )
237 free(row->sqlvar[i].sqldata);
238 free(row->sqlvar[i].sqlind);
243 int INGfetchAll(const char *stmt, INGresult *ing_res)
248 char stmt_buffer[2000];
249 strcpy(stmt_buffer,stmt);
250 desc = ing_res->sqlda;
251 /* # line 275 "myingres.sc" */ /* host code */
253 /* # line 277 "myingres.sc" */ /* open */
256 IIcsOpen((char *)"c2",19215,16475);
257 IIwritio(0,(short *)0,1,32,0,(char *)"s2");
258 IIcsQuery((char *)"c2",19215,16475);
260 /* # line 278 "myingres.sc" */ /* host code */
262 /* for (linecount=0;sqlca.sqlcode==0;++linecount) */
263 while(sqlca.sqlcode==0)
265 /* # line 283 "myingres.sc" */ /* fetch */
268 if (IIcsRetScroll((char *)"c2",19215,16475,-1,-1) != 0) {
273 /* # line 284 "myingres.sc" */ /* host code */
275 if (sqlca.sqlcode == 0)
277 row = INGgetRowSpace(ing_res); /* alloc space for fetched row */
278 /* initialize list when encountered first time */
279 if (ing_res->first_row == 0)
281 ing_res->first_row = row; /* head of the list */
282 ing_res->first_row->next = NULL;
283 ing_res->act_row = ing_res->first_row;
285 ing_res->act_row->next = row; /* append row to old act_row */
286 ing_res->act_row = row; /* set row as act_row */
287 row->row_number = linecount;
291 printf("Row %d ", linecount);
292 for (i=0;i<ing_res->num_fields;++i)
293 { printf("F%d:%s ",i,row->sqlvar[i].sqldata); }
298 /* # line 313 "myingres.sc" */ /* close */
301 IIcsClose((char *)"c2",19215,16475);
303 /* # line 315 "myingres.sc" */ /* host code */
304 ing_res->status = ING_COMMAND_OK;
305 ing_res->num_rows = linecount;
308 ING_STATUS INGresultStatus(INGresult *res)
310 if (res == NULL) {return ING_NO_RESULT;}
313 void INGrowSeek(INGresult *res, int row_number)
315 if (res->act_row->row_number == row_number) { return; }
316 /* TODO: real error handling */
317 if (row_number<0 || row_number>res->num_rows) { return;}
318 ING_ROW *trow = res->first_row;
319 while ( trow->row_number != row_number )
320 { trow = trow->next; }
322 /* note - can be null - if row_number not found, right? */
324 char *INGgetvalue(INGresult *res, int row_number, int column_number)
326 if (row_number != res->act_row->row_number)
327 { INGrowSeek(res, row_number); }
328 return res->act_row->sqlvar[column_number].sqldata;
330 int INGgetisnull(INGresult *res, int row_number, int column_number)
332 if (row_number != res->act_row->row_number)
333 { INGrowSeek(res, row_number); }
334 return (short)*res->act_row->sqlvar[column_number].sqlind;
336 int INGntuples(const INGresult *res)
338 return res->num_rows;
340 int INGnfields(const INGresult *res)
342 return res->num_fields;
344 char *INGfname(const INGresult *res, int column_number)
346 if ( (column_number > res->num_fields) || (column_number < 0) )
349 { return res->fields[column_number].name; }
351 short INGftype(const INGresult *res, int column_number)
353 return res->fields[column_number].type;
355 INGresult *INGexec(INGconn *conn, const char *query)
357 /* TODO: error handling -> res->status? */
358 IISQLDA *desc = NULL;
359 INGresult *res = NULL;
362 strncpy(stmt,query,strlen(query));
363 stmt[strlen(query)]='\0';
365 printf("INGexec: query is >>%s<<\n",stmt);
367 if ((cols = INGgetCols(query)) == 0)
370 printf("INGexec: non-select\n");
372 /* non-select statement - TODO: EXECUTE IMMEDIATE */
373 /* # line 400 "myingres.sc" */ /* execute */
377 IIsyncup((char *)0,0);
379 /* # line 401 "myingres.sc" */ /* host code */
384 printf("INGexec: select\n");
386 /* select statement */
387 desc = INGgetDescriptor(cols, query);
388 res = INGgetINGresult(desc);
389 INGfetchAll(query, res);
393 void INGclear(INGresult *res)
395 if (res == NULL) { return; }
396 IISQLDA *desc = res->sqlda;
397 INGfreeINGresult(res);
398 INGfreeDescriptor(desc);
400 INGconn *INGconnectDB(char *dbname, char *user, char *passwd)
402 if (dbname == NULL || strlen(dbname) == 0)
404 INGconn *dbconn = (INGconn *)calloc(1,sizeof(INGconn));
405 if (dbconn == (INGconn *)0)
406 { printf("Failure allocating INGconn\n"); }
412 strcpy(ingdbname,dbname);
416 printf("Connection: with user/passwd\n");
418 strcpy(ingdbuser,user);
420 { strcpy(ingdbpasw,passwd); }
422 { strcpy(ingdbpasw, ""); }
423 /* # line 452 "myingres.sc" */ /* connect */
427 IIsqConnect(0,ingdbname,(char *)"-dbms_password",ingdbpasw,(char *)0,
428 (char *)0, (char *)0, (char *)0, (char *)0, (char *)0, (char *)0,
429 (char *)0, (char *)0, (char *)0, (char *)0);
431 /* # line 456 "myingres.sc" */ /* host code */
436 printf("Connection: w/ user/passwd\n");
438 /* # line 462 "myingres.sc" */ /* connect */
441 IIsqConnect(0,ingdbname,(char *)0, (char *)0, (char *)0, (char *)0,
442 (char *)0, (char *)0, (char *)0, (char *)0, (char *)0, (char *)0,
443 (char *)0, (char *)0, (char *)0);
445 /* # line 463 "myingres.sc" */ /* host code */
447 /* # line 465 "myingres.sc" */ /* inquire_sql */
449 IILQisInqSqlio((short *)0,1,32,31,conn_name,13);
451 /* # line 466 "myingres.sc" */ /* inquire_sql */
453 IILQisInqSqlio((short *)0,1,30,sizeof(sess_id),&sess_id,11);
455 /* # line 468 "myingres.sc" */ /* host code */
456 strcpy(dbconn->dbname,ingdbname);
457 strcpy(dbconn->user,ingdbuser);
458 strcpy(dbconn->password,ingdbpasw);
459 strcpy(dbconn->connection_name,conn_name);
460 dbconn->session_id = sess_id;
462 printf("Connected to '%s' with user/passwd %s/%s, sessID/name %i/%s\n",
467 dbconn->connection_name
472 void INGdisconnectDB(INGconn *dbconn)
474 /* TODO: use of dbconn */
475 /* # line 490 "myingres.sc" */ /* disconnect */
480 /* # line 491 "myingres.sc" */ /* host code */
483 char *INGerrorMessage(const INGconn *conn)
487 char *INGcmdTuples(INGresult *res)
489 return res->numrowstring;
492 char *INGerrorMessage(const INGconn *conn);
493 int INGputCopyEnd(INGconn *conn, const char *errormsg);
494 int INGputCopyData(INGconn *conn, const char *buffer, int nbytes);