From b1179386b5155aece5632f7b16fdbb0d3bec1010 Mon Sep 17 00:00:00 2001 From: onefang Date: Thu, 7 May 2020 11:10:04 +1000 Subject: Comment out database debugging stuff for now. --- src/sledjchisl/sledjchisl.c | 64 +++++++++++++++++++++++---------------------- 1 file changed, 33 insertions(+), 31 deletions(-) diff --git a/src/sledjchisl/sledjchisl.c b/src/sledjchisl/sledjchisl.c index 00575c0..95724df 100644 --- a/src/sledjchisl/sledjchisl.c +++ b/src/sledjchisl/sledjchisl.c @@ -1179,7 +1179,7 @@ d("New SQL statement - %s", req->sql); goto freeIt; } req->inBind = xzalloc(i * sizeof(MYSQL_BIND)); -W("Allocated %d %d inBinds for %s", i, req->inCount, req->sql); +//W("Allocated %d %d inBinds for %s", i, req->inCount, req->sql); for (i = 0; i < req->inCount; i++) { dbField *fld = req->flds->get(req->flds, req->inParams[i], NULL, false); @@ -1201,53 +1201,53 @@ W("Allocated %d %d inBinds for %s", i, req->inCount, req->sql); { case MYSQL_TYPE_TINY: { -d("TINY %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("TINY %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } case MYSQL_TYPE_SHORT: { req->inBind[i].is_unsigned = FALSE; -d("SHORT %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("SHORT %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } case MYSQL_TYPE_INT24: { req->inBind[i].is_unsigned = FALSE; -d("INT24 %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("INT24 %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } case MYSQL_TYPE_LONG: { req->inBind[i].is_unsigned = FALSE; -d("LONG %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("LONG %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } case MYSQL_TYPE_LONGLONG: { req->inBind[i].is_unsigned = FALSE; -d("LONGLONG %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("LONGLONG %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } case MYSQL_TYPE_FLOAT: { -d("FLOAT %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("FLOAT %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } case MYSQL_TYPE_DOUBLE: { -d("DOUBLE %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("DOUBLE %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } case MYSQL_TYPE_NEWDECIMAL: { -d("NEWDECIMAL %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("NEWDECIMAL %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } @@ -1256,14 +1256,14 @@ d("NEWDECIMAL %d %s %d", i, fld->name, req->inBind[i].buffer_length); case MYSQL_TYPE_DATETIME: case MYSQL_TYPE_TIMESTAMP: { -d("DATE / TIME ish %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("DATE / TIME ish %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } case MYSQL_TYPE_STRING: case MYSQL_TYPE_VAR_STRING: { -d("STRING / VARSTRING %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("STRING / VARSTRING %d %s %d", i, fld->name, req->inBind[i].buffer_length); req->inBind[i].is_null = xzalloc(sizeof(my_bool)); req->inBind[i].length = xzalloc(sizeof(unsigned long)); break; @@ -1274,7 +1274,7 @@ d("STRING / VARSTRING %d %s %d", i, fld->name, req->inBind[i].buffer_length); case MYSQL_TYPE_MEDIUM_BLOB: case MYSQL_TYPE_LONG_BLOB: { -d("BLOBs %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("BLOBs %d %s %d", i, fld->name, req->inBind[i].buffer_length); req->inBind[i].is_null = xzalloc(sizeof(my_bool)); break; } @@ -1282,13 +1282,13 @@ d("BLOBs %d %s %d", i, fld->name, req->inBind[i].buffer_length); case MYSQL_TYPE_BIT: { req->inBind[i].is_null = xzalloc(sizeof(my_bool)); -d("BIT %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("BIT %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } case MYSQL_TYPE_NULL: { -d("NULL %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//d("NULL %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } } @@ -1340,7 +1340,7 @@ I("count!!!!!!!!!!!!!!!!"); goto freeIt; } req->outBind = xzalloc(i * sizeof(MYSQL_BIND)); -W("Allocated %d %d outBinds for %s", i, req->outCount, req->sql); +//W("Allocated %d %d outBinds for %s", i, req->outCount, req->sql); for (i = 0; i < req->outCount; i++) { dbField *fld = req->flds->get(req->flds, req->outParams[i], NULL, false); @@ -1464,7 +1464,7 @@ W("Allocated %d %d outBinds for %s", i, req->outCount, req->sql); } -d("input bind for %s", req->sql); +//d("input bind for %s", req->sql); for (i = 0; i < req->inCount; i++) { dbField *fld = req->flds->get(req->flds, req->inParams[i], NULL, false); @@ -1485,7 +1485,7 @@ d("input bind for %s", req->sql); signed char d = (signed char) c; memcpy(req->inBind[i].buffer, &d, (size_t) fld->length); -T("TINY %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//T("TINY %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } @@ -1495,7 +1495,7 @@ T("TINY %d %s %d", i, fld->name, req->inBind[i].buffer_length); short int d = (short int) c; memcpy(req->inBind[i].buffer, &d, (size_t) fld->length); -T("SHORT %d %s %d = %d", i, fld->name, req->inBind[i].buffer_length, c); +//T("SHORT %d %s %d = %d", i, fld->name, req->inBind[i].buffer_length, c); break; } @@ -1504,7 +1504,7 @@ T("SHORT %d %s %d = %d", i, fld->name, req->inBind[i].buffer_length, c); int d = va_arg(ap, int); memcpy(req->inBind[i].buffer, &d, (size_t) fld->length); -T("INT24 %d %s %d - %d", i, fld->name, req->inBind[i].buffer_length, d); +//T("INT24 %d %s %d - %d", i, fld->name, req->inBind[i].buffer_length, d); break; } @@ -1513,7 +1513,7 @@ T("INT24 %d %s %d - %d", i, fld->name, req->inBind[i].buffer_length, d); long d = va_arg(ap, long); memcpy(req->inBind[i].buffer, &d, (size_t) fld->length); -T("LONG %d %s %d = %ld", i, fld->name, req->inBind[i].buffer_length, d); +//T("LONG %d %s %d = %ld", i, fld->name, req->inBind[i].buffer_length, d); break; } @@ -1522,7 +1522,7 @@ T("LONG %d %s %d = %ld", i, fld->name, req->inBind[i].buffer_length, d); long long int d = va_arg(ap, long long int); memcpy(req->inBind[i].buffer, &d, (size_t) fld->length); -T("LONGLONG %d %s %d = %lld", i, fld->name, req->inBind[i].buffer_length, d); +//T("LONGLONG %d %s %d = %lld", i, fld->name, req->inBind[i].buffer_length, d); break; } @@ -1532,7 +1532,7 @@ T("LONGLONG %d %s %d = %lld", i, fld->name, req->inBind[i].buffer_length, d); float d = (float) c; memcpy(req->inBind[i].buffer, &d, (size_t) fld->length); -T("FLOAT %d %s %d = %f", i, fld->name, req->inBind[i].buffer_length, d); +//T("FLOAT %d %s %d = %f", i, fld->name, req->inBind[i].buffer_length, d); break; } @@ -1541,13 +1541,13 @@ T("FLOAT %d %s %d = %f", i, fld->name, req->inBind[i].buffer_length, d); double d = va_arg(ap, double); memcpy(req->inBind[i].buffer, &d, (size_t) fld->length); -T("DOUBLE %d %s %d = %f", i, fld->name, req->inBind[i].buffer_length, d); +//T("DOUBLE %d %s %d = %f", i, fld->name, req->inBind[i].buffer_length, d); break; } case MYSQL_TYPE_NEWDECIMAL: { -T("NEWDECIMAL %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//T("NEWDECIMAL %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } @@ -1559,7 +1559,7 @@ T("NEWDECIMAL %d %s %d", i, fld->name, req->inBind[i].buffer_length); MYSQL_TIME d = va_arg(ap, MYSQL_TIME); memcpy(req->inBind[i].buffer, &d, (size_t) fld->length); -T("DATE / TIME ish %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//T("DATE / TIME ish %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } @@ -1574,7 +1574,7 @@ T("DATE / TIME ish %d %s %d", i, fld->name, req->inBind[i].buffer_length); *(req->inBind[i].length) = l; strncpy(req->inBind[i].buffer, d, (size_t) l); ((char *) req->inBind[i].buffer)[l] = '\0'; -T("STRING / VARSTRING %d %s %d = %s", i, fld->name, req->inBind[i].buffer_length, d); +//T("STRING / VARSTRING %d %s %d = %s", i, fld->name, req->inBind[i].buffer_length, d); break; } @@ -1583,20 +1583,20 @@ T("STRING / VARSTRING %d %s %d = %s", i, fld->name, req->inBind[i].buffer_length case MYSQL_TYPE_MEDIUM_BLOB: case MYSQL_TYPE_LONG_BLOB: { -// TODO - should write this, we will likely need it. Main problem is - how long is this blob? Probably should add alongth param before the blob. -T("BLOBs %d %s %d", i, fld->name, req->inBind[i].buffer_length); +// TODO - should write this, we will likely need it. Main problem is - how long is this blob? Probably should add a length param before the blob. +//T("BLOBs %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } case MYSQL_TYPE_BIT: { -T("BIT %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//T("BIT %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } case MYSQL_TYPE_NULL: { -T("NULL %d %s %d", i, fld->name, req->inBind[i].buffer_length); +//T("NULL %d %s %d", i, fld->name, req->inBind[i].buffer_length); break; } } @@ -1610,7 +1610,7 @@ T("NULL %d %s %d", i, fld->name, req->inBind[i].buffer_length); } -d("Execute %s", req->sql); +//d("Execute %s", req->sql); // do the prepared statement req->prep. if (mysql_stmt_execute(req->prep)) @@ -1772,6 +1772,7 @@ end: double n = (now.tv_sec * 1000000000.0) + now.tv_nsec; double t = (then.tv_sec * 1000000000.0) + then.tv_nsec; T("dbDoSomething(%s) took %lf seconds", req->sql, (n - t) / 1000000000.0); +/* if (NULL != req->prep) I("The prepared statement itself is NOT NULL."); else @@ -1781,6 +1782,7 @@ end: I("The prepared0 statement itself is NOT NULL."); else W("The prepared0 statement itself is NULL!"); +*/ return ret; } -- cgit v1.1