1 /* 2 ** 2001 September 15 3 ** 4 ** The author disclaims copyright to this source code. In place of 5 ** a legal notice, here is a blessing: 6 ** 7 ** May you do good and not evil. 8 ** May you find forgiveness for yourself and forgive others. 9 ** May you share freely, never taking more than you give. 10 ** 11 ************************************************************************* 12 ** Code for testing all sorts of SQLite interfaces. This code 13 ** is not included in the SQLite library. It is used for automated 14 ** testing of the SQLite library. 15 */ 16 #include "sqliteInt.h" 17 #include "tcl.h" 18 #include <stdlib.h> 19 #include <string.h> 20 21 /* 22 ** This is a copy of the first part of the SqliteDb structure in 23 ** tclsqlite.c. We need it here so that the get_sqlite_pointer routine 24 ** can extract the sqlite3* pointer from an existing Tcl SQLite 25 ** connection. 26 */ 27 struct SqliteDb { 28 sqlite3 *db; 29 }; 30 31 /* 32 ** Convert text generated by the "%p" conversion format back into 33 ** a pointer. 34 */ 35 static int testHexToInt(int h){ 36 if( h>='0' && h<='9' ){ 37 return h - '0'; 38 }else if( h>='a' && h<='f' ){ 39 return h - 'a' + 10; 40 }else{ 41 assert( h>='A' && h<='F' ); 42 return h - 'A' + 10; 43 } 44 } 45 void *sqlite3TestTextToPtr(const char *z){ 46 void *p; 47 u64 v; 48 u32 v2; 49 if( z[0]=='0' && z[1]=='x' ){ 50 z += 2; 51 } 52 v = 0; 53 while( *z ){ 54 v = (v<<4) + testHexToInt(*z); 55 z++; 56 } 57 if( sizeof(p)==sizeof(v) ){ 58 memcpy(&p, &v, sizeof(p)); 59 }else{ 60 assert( sizeof(p)==sizeof(v2) ); 61 v2 = (u32)v; 62 memcpy(&p, &v2, sizeof(p)); 63 } 64 return p; 65 } 66 67 68 /* 69 ** A TCL command that returns the address of the sqlite* pointer 70 ** for an sqlite connection instance. Bad things happen if the 71 ** input is not an sqlite connection. 72 */ 73 static int get_sqlite_pointer( 74 void * clientData, 75 Tcl_Interp *interp, 76 int objc, 77 Tcl_Obj *CONST objv[] 78 ){ 79 struct SqliteDb *p; 80 Tcl_CmdInfo cmdInfo; 81 char zBuf[100]; 82 if( objc!=2 ){ 83 Tcl_WrongNumArgs(interp, 1, objv, "SQLITE-CONNECTION"); 84 return TCL_ERROR; 85 } 86 if( !Tcl_GetCommandInfo(interp, Tcl_GetString(objv[1]), &cmdInfo) ){ 87 Tcl_AppendResult(interp, "command not found: ", 88 Tcl_GetString(objv[1]), (char*)0); 89 return TCL_ERROR; 90 } 91 p = (struct SqliteDb*)cmdInfo.objClientData; 92 sprintf(zBuf, "%p", p->db); 93 if( strncmp(zBuf,"0x",2) ){ 94 sprintf(zBuf, "0x%p", p->db); 95 } 96 Tcl_AppendResult(interp, zBuf, 0); 97 return TCL_OK; 98 } 99 100 /* 101 ** Decode a pointer to an sqlite3 object. 102 */ 103 int getDbPointer(Tcl_Interp *interp, const char *zA, sqlite3 **ppDb){ 104 struct SqliteDb *p; 105 Tcl_CmdInfo cmdInfo; 106 if( Tcl_GetCommandInfo(interp, zA, &cmdInfo) ){ 107 p = (struct SqliteDb*)cmdInfo.objClientData; 108 *ppDb = p->db; 109 }else{ 110 *ppDb = (sqlite3*)sqlite3TestTextToPtr(zA); 111 } 112 return TCL_OK; 113 } 114 115 116 const char *sqlite3TestErrorName(int rc){ 117 const char *zName = 0; 118 switch( rc ){ 119 case SQLITE_OK: zName = "SQLITE_OK"; break; 120 case SQLITE_ERROR: zName = "SQLITE_ERROR"; break; 121 case SQLITE_INTERNAL: zName = "SQLITE_INTERNAL"; break; 122 case SQLITE_PERM: zName = "SQLITE_PERM"; break; 123 case SQLITE_ABORT: zName = "SQLITE_ABORT"; break; 124 case SQLITE_BUSY: zName = "SQLITE_BUSY"; break; 125 case SQLITE_LOCKED: zName = "SQLITE_LOCKED"; break; 126 case SQLITE_LOCKED_SHAREDCACHE: zName = "SQLITE_LOCKED_SHAREDCACHE";break; 127 case SQLITE_NOMEM: zName = "SQLITE_NOMEM"; break; 128 case SQLITE_READONLY: zName = "SQLITE_READONLY"; break; 129 case SQLITE_INTERRUPT: zName = "SQLITE_INTERRUPT"; break; 130 case SQLITE_IOERR: zName = "SQLITE_IOERR"; break; 131 case SQLITE_CORRUPT: zName = "SQLITE_CORRUPT"; break; 132 case SQLITE_NOTFOUND: zName = "SQLITE_NOTFOUND"; break; 133 case SQLITE_FULL: zName = "SQLITE_FULL"; break; 134 case SQLITE_CANTOPEN: zName = "SQLITE_CANTOPEN"; break; 135 case SQLITE_PROTOCOL: zName = "SQLITE_PROTOCOL"; break; 136 case SQLITE_EMPTY: zName = "SQLITE_EMPTY"; break; 137 case SQLITE_SCHEMA: zName = "SQLITE_SCHEMA"; break; 138 case SQLITE_TOOBIG: zName = "SQLITE_TOOBIG"; break; 139 case SQLITE_CONSTRAINT: zName = "SQLITE_CONSTRAINT"; break; 140 case SQLITE_MISMATCH: zName = "SQLITE_MISMATCH"; break; 141 case SQLITE_MISUSE: zName = "SQLITE_MISUSE"; break; 142 case SQLITE_NOLFS: zName = "SQLITE_NOLFS"; break; 143 case SQLITE_AUTH: zName = "SQLITE_AUTH"; break; 144 case SQLITE_FORMAT: zName = "SQLITE_FORMAT"; break; 145 case SQLITE_RANGE: zName = "SQLITE_RANGE"; break; 146 case SQLITE_NOTADB: zName = "SQLITE_NOTADB"; break; 147 case SQLITE_ROW: zName = "SQLITE_ROW"; break; 148 case SQLITE_DONE: zName = "SQLITE_DONE"; break; 149 case SQLITE_IOERR_READ: zName = "SQLITE_IOERR_READ"; break; 150 case SQLITE_IOERR_SHORT_READ: zName = "SQLITE_IOERR_SHORT_READ"; break; 151 case SQLITE_IOERR_WRITE: zName = "SQLITE_IOERR_WRITE"; break; 152 case SQLITE_IOERR_FSYNC: zName = "SQLITE_IOERR_FSYNC"; break; 153 case SQLITE_IOERR_DIR_FSYNC: zName = "SQLITE_IOERR_DIR_FSYNC"; break; 154 case SQLITE_IOERR_TRUNCATE: zName = "SQLITE_IOERR_TRUNCATE"; break; 155 case SQLITE_IOERR_FSTAT: zName = "SQLITE_IOERR_FSTAT"; break; 156 case SQLITE_IOERR_UNLOCK: zName = "SQLITE_IOERR_UNLOCK"; break; 157 case SQLITE_IOERR_RDLOCK: zName = "SQLITE_IOERR_RDLOCK"; break; 158 case SQLITE_IOERR_DELETE: zName = "SQLITE_IOERR_DELETE"; break; 159 case SQLITE_IOERR_BLOCKED: zName = "SQLITE_IOERR_BLOCKED"; break; 160 case SQLITE_IOERR_NOMEM: zName = "SQLITE_IOERR_NOMEM"; break; 161 case SQLITE_IOERR_ACCESS: zName = "SQLITE_IOERR_ACCESS"; break; 162 case SQLITE_IOERR_CHECKRESERVEDLOCK: 163 zName = "SQLITE_IOERR_CHECKRESERVEDLOCK"; break; 164 case SQLITE_IOERR_LOCK: zName = "SQLITE_IOERR_LOCK"; break; 165 default: zName = "SQLITE_Unknown"; break; 166 } 167 return zName; 168 } 169 #define t1ErrorName sqlite3TestErrorName 170 171 /* 172 ** Convert an sqlite3_stmt* into an sqlite3*. This depends on the 173 ** fact that the sqlite3* is the first field in the Vdbe structure. 174 */ 175 #define StmtToDb(X) sqlite3_db_handle(X) 176 177 /* 178 ** Check a return value to make sure it agrees with the results 179 ** from sqlite3_errcode. 180 */ 181 int sqlite3TestErrCode(Tcl_Interp *interp, sqlite3 *db, int rc){ 182 if( sqlite3_threadsafe()==0 && rc!=SQLITE_MISUSE && rc!=SQLITE_OK 183 && sqlite3_errcode(db)!=rc ){ 184 char zBuf[200]; 185 int r2 = sqlite3_errcode(db); 186 sprintf(zBuf, "error code %s (%d) does not match sqlite3_errcode %s (%d)", 187 t1ErrorName(rc), rc, t1ErrorName(r2), r2); 188 Tcl_ResetResult(interp); 189 Tcl_AppendResult(interp, zBuf, 0); 190 return 1; 191 } 192 return 0; 193 } 194 195 /* 196 ** Decode a pointer to an sqlite3_stmt object. 197 */ 198 static int getStmtPointer( 199 Tcl_Interp *interp, 200 const char *zArg, 201 sqlite3_stmt **ppStmt 202 ){ 203 *ppStmt = (sqlite3_stmt*)sqlite3TestTextToPtr(zArg); 204 return TCL_OK; 205 } 206 207 /* 208 ** Generate a text representation of a pointer that can be understood 209 ** by the getDbPointer and getVmPointer routines above. 210 ** 211 ** The problem is, on some machines (Solaris) if you do a printf with 212 ** "%p" you cannot turn around and do a scanf with the same "%p" and 213 ** get your pointer back. You have to prepend a "0x" before it will 214 ** work. Or at least that is what is reported to me (drh). But this 215 ** behavior varies from machine to machine. The solution used her is 216 ** to test the string right after it is generated to see if it can be 217 ** understood by scanf, and if not, try prepending an "0x" to see if 218 ** that helps. If nothing works, a fatal error is generated. 219 */ 220 int sqlite3TestMakePointerStr(Tcl_Interp *interp, char *zPtr, void *p){ 221 sqlite3_snprintf(100, zPtr, "%p", p); 222 return TCL_OK; 223 } 224 225 /* 226 ** The callback routine for sqlite3_exec_printf(). 227 */ 228 static int exec_printf_cb(void *pArg, int argc, char **argv, char **name){ 229 Tcl_DString *str = (Tcl_DString*)pArg; 230 int i; 231 232 if( Tcl_DStringLength(str)==0 ){ 233 for(i=0; i<argc; i++){ 234 Tcl_DStringAppendElement(str, name[i] ? name[i] : "NULL"); 235 } 236 } 237 for(i=0; i<argc; i++){ 238 Tcl_DStringAppendElement(str, argv[i] ? argv[i] : "NULL"); 239 } 240 return 0; 241 } 242 243 /* 244 ** The I/O tracing callback. 245 */ 246 #if !defined(SQLITE_OMIT_TRACE) && defined(SQLITE_ENABLE_IOTRACE) 247 static FILE *iotrace_file = 0; 248 static void io_trace_callback(const char *zFormat, ...){ 249 va_list ap; 250 va_start(ap, zFormat); 251 vfprintf(iotrace_file, zFormat, ap); 252 va_end(ap); 253 fflush(iotrace_file); 254 } 255 #endif 256 257 /* 258 ** Usage: io_trace FILENAME 259 ** 260 ** Turn I/O tracing on or off. If FILENAME is not an empty string, 261 ** I/O tracing begins going into FILENAME. If FILENAME is an empty 262 ** string, I/O tracing is turned off. 263 */ 264 static int test_io_trace( 265 void *NotUsed, 266 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 267 int argc, /* Number of arguments */ 268 char **argv /* Text of each argument */ 269 ){ 270 #if !defined(SQLITE_OMIT_TRACE) && defined(SQLITE_ENABLE_IOTRACE) 271 if( argc!=2 ){ 272 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 273 " FILENAME\"", 0); 274 return TCL_ERROR; 275 } 276 if( iotrace_file ){ 277 if( iotrace_file!=stdout && iotrace_file!=stderr ){ 278 fclose(iotrace_file); 279 } 280 iotrace_file = 0; 281 sqlite3IoTrace = 0; 282 } 283 if( argv[1][0] ){ 284 if( strcmp(argv[1],"stdout")==0 ){ 285 iotrace_file = stdout; 286 }else if( strcmp(argv[1],"stderr")==0 ){ 287 iotrace_file = stderr; 288 }else{ 289 iotrace_file = fopen(argv[1], "w"); 290 } 291 sqlite3IoTrace = io_trace_callback; 292 } 293 #endif 294 return TCL_OK; 295 } 296 297 298 /* 299 ** Usage: sqlite3_exec_printf DB FORMAT STRING 300 ** 301 ** Invoke the sqlite3_exec_printf() interface using the open database 302 ** DB. The SQL is the string FORMAT. The format string should contain 303 ** one %s or %q. STRING is the value inserted into %s or %q. 304 */ 305 static int test_exec_printf( 306 void *NotUsed, 307 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 308 int argc, /* Number of arguments */ 309 char **argv /* Text of each argument */ 310 ){ 311 sqlite3 *db; 312 Tcl_DString str; 313 int rc; 314 char *zErr = 0; 315 char *zSql; 316 char zBuf[30]; 317 if( argc!=4 ){ 318 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 319 " DB FORMAT STRING", 0); 320 return TCL_ERROR; 321 } 322 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 323 Tcl_DStringInit(&str); 324 zSql = sqlite3_mprintf(argv[2], argv[3]); 325 rc = sqlite3_exec(db, zSql, exec_printf_cb, &str, &zErr); 326 sqlite3_free(zSql); 327 sprintf(zBuf, "%d", rc); 328 Tcl_AppendElement(interp, zBuf); 329 Tcl_AppendElement(interp, rc==SQLITE_OK ? Tcl_DStringValue(&str) : zErr); 330 Tcl_DStringFree(&str); 331 if( zErr ) sqlite3_free(zErr); 332 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 333 return TCL_OK; 334 } 335 336 /* 337 ** Usage: sqlite3_exec_hex DB HEX 338 ** 339 ** Invoke the sqlite3_exec() on a string that is obtained by translating 340 ** HEX into ASCII. Most characters are translated as is. %HH becomes 341 ** a hex character. 342 */ 343 static int test_exec_hex( 344 void *NotUsed, 345 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 346 int argc, /* Number of arguments */ 347 char **argv /* Text of each argument */ 348 ){ 349 sqlite3 *db; 350 Tcl_DString str; 351 int rc, i, j; 352 char *zErr = 0; 353 char *zHex; 354 char zSql[500]; 355 char zBuf[30]; 356 if( argc!=3 ){ 357 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 358 " DB HEX", 0); 359 return TCL_ERROR; 360 } 361 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 362 zHex = argv[2]; 363 for(i=j=0; i<sizeof(zSql) && zHex[j]; i++, j++){ 364 if( zHex[j]=='%' && zHex[j+2] && zHex[j+2] ){ 365 zSql[i] = (testHexToInt(zHex[j+1])<<4) + testHexToInt(zHex[j+2]); 366 j += 2; 367 }else{ 368 zSql[i] = zHex[j]; 369 } 370 } 371 zSql[i] = 0; 372 Tcl_DStringInit(&str); 373 rc = sqlite3_exec(db, zSql, exec_printf_cb, &str, &zErr); 374 sprintf(zBuf, "%d", rc); 375 Tcl_AppendElement(interp, zBuf); 376 Tcl_AppendElement(interp, rc==SQLITE_OK ? Tcl_DStringValue(&str) : zErr); 377 Tcl_DStringFree(&str); 378 if( zErr ) sqlite3_free(zErr); 379 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 380 return TCL_OK; 381 } 382 383 /* 384 ** Usage: db_enter DB 385 ** db_leave DB 386 ** 387 ** Enter or leave the mutex on a database connection. 388 */ 389 static int db_enter( 390 void *NotUsed, 391 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 392 int argc, /* Number of arguments */ 393 char **argv /* Text of each argument */ 394 ){ 395 sqlite3 *db; 396 if( argc!=2 ){ 397 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 398 " DB", 0); 399 return TCL_ERROR; 400 } 401 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 402 sqlite3_mutex_enter(db->mutex); 403 return TCL_OK; 404 } 405 static int db_leave( 406 void *NotUsed, 407 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 408 int argc, /* Number of arguments */ 409 char **argv /* Text of each argument */ 410 ){ 411 sqlite3 *db; 412 if( argc!=2 ){ 413 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 414 " DB", 0); 415 return TCL_ERROR; 416 } 417 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 418 sqlite3_mutex_leave(db->mutex); 419 return TCL_OK; 420 } 421 422 /* 423 ** Usage: sqlite3_exec DB SQL 424 ** 425 ** Invoke the sqlite3_exec interface using the open database DB 426 */ 427 static int test_exec( 428 void *NotUsed, 429 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 430 int argc, /* Number of arguments */ 431 char **argv /* Text of each argument */ 432 ){ 433 sqlite3 *db; 434 Tcl_DString str; 435 int rc; 436 char *zErr = 0; 437 char *zSql; 438 int i, j; 439 char zBuf[30]; 440 if( argc!=3 ){ 441 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 442 " DB SQL", 0); 443 return TCL_ERROR; 444 } 445 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 446 Tcl_DStringInit(&str); 447 zSql = sqlite3_mprintf("%s", argv[2]); 448 for(i=j=0; zSql[i];){ 449 if( zSql[i]=='%' ){ 450 zSql[j++] = (testHexToInt(zSql[i+1])<<4) + testHexToInt(zSql[i+2]); 451 i += 3; 452 }else{ 453 zSql[j++] = zSql[i++]; 454 } 455 } 456 zSql[j] = 0; 457 rc = sqlite3_exec(db, zSql, exec_printf_cb, &str, &zErr); 458 sqlite3_free(zSql); 459 sprintf(zBuf, "%d", rc); 460 Tcl_AppendElement(interp, zBuf); 461 Tcl_AppendElement(interp, rc==SQLITE_OK ? Tcl_DStringValue(&str) : zErr); 462 Tcl_DStringFree(&str); 463 if( zErr ) sqlite3_free(zErr); 464 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 465 return TCL_OK; 466 } 467 468 /* 469 ** Usage: sqlite3_exec_nr DB SQL 470 ** 471 ** Invoke the sqlite3_exec interface using the open database DB. Discard 472 ** all results 473 */ 474 static int test_exec_nr( 475 void *NotUsed, 476 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 477 int argc, /* Number of arguments */ 478 char **argv /* Text of each argument */ 479 ){ 480 sqlite3 *db; 481 int rc; 482 char *zErr = 0; 483 if( argc!=3 ){ 484 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 485 " DB SQL", 0); 486 return TCL_ERROR; 487 } 488 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 489 rc = sqlite3_exec(db, argv[2], 0, 0, &zErr); 490 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 491 return TCL_OK; 492 } 493 494 /* 495 ** Usage: sqlite3_mprintf_z_test SEPARATOR ARG0 ARG1 ... 496 ** 497 ** Test the %z format of sqlite_mprintf(). Use multiple mprintf() calls to 498 ** concatenate arg0 through argn using separator as the separator. 499 ** Return the result. 500 */ 501 static int test_mprintf_z( 502 void *NotUsed, 503 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 504 int argc, /* Number of arguments */ 505 char **argv /* Text of each argument */ 506 ){ 507 char *zResult = 0; 508 int i; 509 510 for(i=2; i<argc && (i==2 || zResult); i++){ 511 zResult = sqlite3_mprintf("%z%s%s", zResult, argv[1], argv[i]); 512 } 513 Tcl_AppendResult(interp, zResult, 0); 514 sqlite3_free(zResult); 515 return TCL_OK; 516 } 517 518 /* 519 ** Usage: sqlite3_mprintf_n_test STRING 520 ** 521 ** Test the %n format of sqlite_mprintf(). Return the length of the 522 ** input string. 523 */ 524 static int test_mprintf_n( 525 void *NotUsed, 526 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 527 int argc, /* Number of arguments */ 528 char **argv /* Text of each argument */ 529 ){ 530 char *zStr; 531 int n = 0; 532 zStr = sqlite3_mprintf("%s%n", argv[1], &n); 533 sqlite3_free(zStr); 534 Tcl_SetObjResult(interp, Tcl_NewIntObj(n)); 535 return TCL_OK; 536 } 537 538 /* 539 ** Usage: sqlite3_snprintf_int SIZE FORMAT INT 540 ** 541 ** Test the of sqlite3_snprintf() routine. SIZE is the size of the 542 ** output buffer in bytes. The maximum size is 100. FORMAT is the 543 ** format string. INT is a single integer argument. The FORMAT 544 ** string must require no more than this one integer argument. If 545 ** You pass in a format string that requires more than one argument, 546 ** bad things will happen. 547 */ 548 static int test_snprintf_int( 549 void *NotUsed, 550 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 551 int argc, /* Number of arguments */ 552 char **argv /* Text of each argument */ 553 ){ 554 char zStr[100]; 555 int n = atoi(argv[1]); 556 const char *zFormat = argv[2]; 557 int a1 = atoi(argv[3]); 558 if( n>sizeof(zStr) ) n = sizeof(zStr); 559 sqlite3_snprintf(sizeof(zStr), zStr, "abcdefghijklmnopqrstuvwxyz"); 560 sqlite3_snprintf(n, zStr, zFormat, a1); 561 Tcl_AppendResult(interp, zStr, 0); 562 return TCL_OK; 563 } 564 565 #ifndef SQLITE_OMIT_GET_TABLE 566 567 /* 568 ** Usage: sqlite3_get_table_printf DB FORMAT STRING ?--no-counts? 569 ** 570 ** Invoke the sqlite3_get_table_printf() interface using the open database 571 ** DB. The SQL is the string FORMAT. The format string should contain 572 ** one %s or %q. STRING is the value inserted into %s or %q. 573 */ 574 static int test_get_table_printf( 575 void *NotUsed, 576 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 577 int argc, /* Number of arguments */ 578 char **argv /* Text of each argument */ 579 ){ 580 sqlite3 *db; 581 Tcl_DString str; 582 int rc; 583 char *zErr = 0; 584 int nRow, nCol; 585 char **aResult; 586 int i; 587 char zBuf[30]; 588 char *zSql; 589 int resCount = -1; 590 if( argc==5 ){ 591 if( Tcl_GetInt(interp, argv[4], &resCount) ) return TCL_ERROR; 592 } 593 if( argc!=4 && argc!=5 ){ 594 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 595 " DB FORMAT STRING ?COUNT?", 0); 596 return TCL_ERROR; 597 } 598 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 599 Tcl_DStringInit(&str); 600 zSql = sqlite3_mprintf(argv[2],argv[3]); 601 if( argc==5 ){ 602 rc = sqlite3_get_table(db, zSql, &aResult, 0, 0, &zErr); 603 }else{ 604 rc = sqlite3_get_table(db, zSql, &aResult, &nRow, &nCol, &zErr); 605 resCount = (nRow+1)*nCol; 606 } 607 sqlite3_free(zSql); 608 sprintf(zBuf, "%d", rc); 609 Tcl_AppendElement(interp, zBuf); 610 if( rc==SQLITE_OK ){ 611 if( argc==4 ){ 612 sprintf(zBuf, "%d", nRow); 613 Tcl_AppendElement(interp, zBuf); 614 sprintf(zBuf, "%d", nCol); 615 Tcl_AppendElement(interp, zBuf); 616 } 617 for(i=0; i<resCount; i++){ 618 Tcl_AppendElement(interp, aResult[i] ? aResult[i] : "NULL"); 619 } 620 }else{ 621 Tcl_AppendElement(interp, zErr); 622 } 623 sqlite3_free_table(aResult); 624 if( zErr ) sqlite3_free(zErr); 625 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 626 return TCL_OK; 627 } 628 629 #endif /* SQLITE_OMIT_GET_TABLE */ 630 631 632 /* 633 ** Usage: sqlite3_last_insert_rowid DB 634 ** 635 ** Returns the integer ROWID of the most recent insert. 636 */ 637 static int test_last_rowid( 638 void *NotUsed, 639 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 640 int argc, /* Number of arguments */ 641 char **argv /* Text of each argument */ 642 ){ 643 sqlite3 *db; 644 char zBuf[30]; 645 646 if( argc!=2 ){ 647 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], " DB\"", 0); 648 return TCL_ERROR; 649 } 650 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 651 sprintf(zBuf, "%lld", sqlite3_last_insert_rowid(db)); 652 Tcl_AppendResult(interp, zBuf, 0); 653 return SQLITE_OK; 654 } 655 656 /* 657 ** Usage: sqlite3_key DB KEY 658 ** 659 ** Set the codec key. 660 */ 661 static int test_key( 662 void *NotUsed, 663 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 664 int argc, /* Number of arguments */ 665 char **argv /* Text of each argument */ 666 ){ 667 sqlite3 *db; 668 const char *zKey; 669 int nKey; 670 if( argc!=3 ){ 671 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 672 " FILENAME\"", 0); 673 return TCL_ERROR; 674 } 675 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 676 zKey = argv[2]; 677 nKey = strlen(zKey); 678 #ifdef SQLITE_HAS_CODEC 679 sqlite3_key(db, zKey, nKey); 680 #endif 681 return TCL_OK; 682 } 683 684 /* 685 ** Usage: sqlite3_rekey DB KEY 686 ** 687 ** Change the codec key. 688 */ 689 static int test_rekey( 690 void *NotUsed, 691 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 692 int argc, /* Number of arguments */ 693 char **argv /* Text of each argument */ 694 ){ 695 sqlite3 *db; 696 const char *zKey; 697 int nKey; 698 if( argc!=3 ){ 699 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 700 " FILENAME\"", 0); 701 return TCL_ERROR; 702 } 703 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 704 zKey = argv[2]; 705 nKey = strlen(zKey); 706 #ifdef SQLITE_HAS_CODEC 707 sqlite3_rekey(db, zKey, nKey); 708 #endif 709 return TCL_OK; 710 } 711 712 /* 713 ** Usage: sqlite3_close DB 714 ** 715 ** Closes the database opened by sqlite3_open. 716 */ 717 static int sqlite_test_close( 718 void *NotUsed, 719 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 720 int argc, /* Number of arguments */ 721 char **argv /* Text of each argument */ 722 ){ 723 sqlite3 *db; 724 int rc; 725 if( argc!=2 ){ 726 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 727 " FILENAME\"", 0); 728 return TCL_ERROR; 729 } 730 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 731 rc = sqlite3_close(db); 732 Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); 733 return TCL_OK; 734 } 735 736 /* 737 ** Implementation of the x_coalesce() function. 738 ** Return the first argument non-NULL argument. 739 */ 740 static void t1_ifnullFunc( 741 sqlite3_context *context, 742 int argc, 743 sqlite3_value **argv 744 ){ 745 int i; 746 for(i=0; i<argc; i++){ 747 if( SQLITE_NULL!=sqlite3_value_type(argv[i]) ){ 748 int n = sqlite3_value_bytes(argv[i]); 749 sqlite3_result_text(context, (char*)sqlite3_value_text(argv[i]), 750 n, SQLITE_TRANSIENT); 751 break; 752 } 753 } 754 } 755 756 /* 757 ** These are test functions. hex8() interprets its argument as 758 ** UTF8 and returns a hex encoding. hex16le() interprets its argument 759 ** as UTF16le and returns a hex encoding. 760 */ 761 static void hex8Func(sqlite3_context *p, int argc, sqlite3_value **argv){ 762 const unsigned char *z; 763 int i; 764 char zBuf[200]; 765 z = sqlite3_value_text(argv[0]); 766 for(i=0; i<sizeof(zBuf)/2 - 2 && z[i]; i++){ 767 sprintf(&zBuf[i*2], "%02x", z[i]&0xff); 768 } 769 zBuf[i*2] = 0; 770 sqlite3_result_text(p, (char*)zBuf, -1, SQLITE_TRANSIENT); 771 } 772 #ifndef SQLITE_OMIT_UTF16 773 static void hex16Func(sqlite3_context *p, int argc, sqlite3_value **argv){ 774 const unsigned short int *z; 775 int i; 776 char zBuf[400]; 777 z = sqlite3_value_text16(argv[0]); 778 for(i=0; i<sizeof(zBuf)/4 - 4 && z[i]; i++){ 779 sprintf(&zBuf[i*4], "%04x", z[i]&0xff); 780 } 781 zBuf[i*4] = 0; 782 sqlite3_result_text(p, (char*)zBuf, -1, SQLITE_TRANSIENT); 783 } 784 #endif 785 786 /* 787 ** A structure into which to accumulate text. 788 */ 789 struct dstr { 790 int nAlloc; /* Space allocated */ 791 int nUsed; /* Space used */ 792 char *z; /* The space */ 793 }; 794 795 /* 796 ** Append text to a dstr 797 */ 798 static void dstrAppend(struct dstr *p, const char *z, int divider){ 799 int n = strlen(z); 800 if( p->nUsed + n + 2 > p->nAlloc ){ 801 char *zNew; 802 p->nAlloc = p->nAlloc*2 + n + 200; 803 zNew = sqlite3_realloc(p->z, p->nAlloc); 804 if( zNew==0 ){ 805 sqlite3_free(p->z); 806 memset(p, 0, sizeof(*p)); 807 return; 808 } 809 p->z = zNew; 810 } 811 if( divider && p->nUsed>0 ){ 812 p->z[p->nUsed++] = divider; 813 } 814 memcpy(&p->z[p->nUsed], z, n+1); 815 p->nUsed += n; 816 } 817 818 /* 819 ** Invoked for each callback from sqlite3ExecFunc 820 */ 821 static int execFuncCallback(void *pData, int argc, char **argv, char **NotUsed){ 822 struct dstr *p = (struct dstr*)pData; 823 int i; 824 for(i=0; i<argc; i++){ 825 if( argv[i]==0 ){ 826 dstrAppend(p, "NULL", ' '); 827 }else{ 828 dstrAppend(p, argv[i], ' '); 829 } 830 } 831 return 0; 832 } 833 834 /* 835 ** Implementation of the x_sqlite_exec() function. This function takes 836 ** a single argument and attempts to execute that argument as SQL code. 837 ** This is illegal and should set the SQLITE_MISUSE flag on the database. 838 ** 839 ** 2004-Jan-07: We have changed this to make it legal to call sqlite3_exec() 840 ** from within a function call. 841 ** 842 ** This routine simulates the effect of having two threads attempt to 843 ** use the same database at the same time. 844 */ 845 static void sqlite3ExecFunc( 846 sqlite3_context *context, 847 int argc, 848 sqlite3_value **argv 849 ){ 850 struct dstr x; 851 memset(&x, 0, sizeof(x)); 852 (void)sqlite3_exec((sqlite3*)sqlite3_user_data(context), 853 (char*)sqlite3_value_text(argv[0]), 854 execFuncCallback, &x, 0); 855 sqlite3_result_text(context, x.z, x.nUsed, SQLITE_TRANSIENT); 856 sqlite3_free(x.z); 857 } 858 859 /* 860 ** Implementation of tkt2213func(), a scalar function that takes exactly 861 ** one argument. It has two interesting features: 862 ** 863 ** * It calls sqlite3_value_text() 3 times on the argument sqlite3_value*. 864 ** If the three pointers returned are not the same an SQL error is raised. 865 ** 866 ** * Otherwise it returns a copy of the text representation of its 867 ** argument in such a way as the VDBE representation is a Mem* cell 868 ** with the MEM_Term flag clear. 869 ** 870 ** Ticket #2213 can therefore be tested by evaluating the following 871 ** SQL expression: 872 ** 873 ** tkt2213func(tkt2213func('a string')); 874 */ 875 static void tkt2213Function( 876 sqlite3_context *context, 877 int argc, 878 sqlite3_value **argv 879 ){ 880 int nText; 881 unsigned char const *zText1; 882 unsigned char const *zText2; 883 unsigned char const *zText3; 884 885 nText = sqlite3_value_bytes(argv[0]); 886 zText1 = sqlite3_value_text(argv[0]); 887 zText2 = sqlite3_value_text(argv[0]); 888 zText3 = sqlite3_value_text(argv[0]); 889 890 if( zText1!=zText2 || zText2!=zText3 ){ 891 sqlite3_result_error(context, "tkt2213 is not fixed", -1); 892 }else{ 893 char *zCopy = (char *)sqlite3_malloc(nText); 894 memcpy(zCopy, zText1, nText); 895 sqlite3_result_text(context, zCopy, nText, sqlite3_free); 896 } 897 } 898 899 /* 900 ** The following SQL function takes 4 arguments. The 2nd and 901 ** 4th argument must be one of these strings: 'text', 'text16', 902 ** or 'blob' corresponding to API functions 903 ** 904 ** sqlite3_value_text() 905 ** sqlite3_value_text16() 906 ** sqlite3_value_blob() 907 ** 908 ** The third argument is a string, either 'bytes' or 'bytes16' or 'noop', 909 ** corresponding to APIs: 910 ** 911 ** sqlite3_value_bytes() 912 ** sqlite3_value_bytes16() 913 ** noop 914 ** 915 ** The APIs designated by the 2nd through 4th arguments are applied 916 ** to the first argument in order. If the pointers returned by the 917 ** second and fourth are different, this routine returns 1. Otherwise, 918 ** this routine returns 0. 919 ** 920 ** This function is used to test to see when returned pointers from 921 ** the _text(), _text16() and _blob() APIs become invalidated. 922 */ 923 static void ptrChngFunction( 924 sqlite3_context *context, 925 int argc, 926 sqlite3_value **argv 927 ){ 928 const void *p1, *p2; 929 const char *zCmd; 930 if( argc!=4 ) return; 931 zCmd = (const char*)sqlite3_value_text(argv[1]); 932 if( zCmd==0 ) return; 933 if( strcmp(zCmd,"text")==0 ){ 934 p1 = (const void*)sqlite3_value_text(argv[0]); 935 #ifndef SQLITE_OMIT_UTF16 936 }else if( strcmp(zCmd, "text16")==0 ){ 937 p1 = (const void*)sqlite3_value_text16(argv[0]); 938 #endif 939 }else if( strcmp(zCmd, "blob")==0 ){ 940 p1 = (const void*)sqlite3_value_blob(argv[0]); 941 }else{ 942 return; 943 } 944 zCmd = (const char*)sqlite3_value_text(argv[2]); 945 if( zCmd==0 ) return; 946 if( strcmp(zCmd,"bytes")==0 ){ 947 sqlite3_value_bytes(argv[0]); 948 #ifndef SQLITE_OMIT_UTF16 949 }else if( strcmp(zCmd, "bytes16")==0 ){ 950 sqlite3_value_bytes16(argv[0]); 951 #endif 952 }else if( strcmp(zCmd, "noop")==0 ){ 953 /* do nothing */ 954 }else{ 955 return; 956 } 957 zCmd = (const char*)sqlite3_value_text(argv[3]); 958 if( zCmd==0 ) return; 959 if( strcmp(zCmd,"text")==0 ){ 960 p2 = (const void*)sqlite3_value_text(argv[0]); 961 #ifndef SQLITE_OMIT_UTF16 962 }else if( strcmp(zCmd, "text16")==0 ){ 963 p2 = (const void*)sqlite3_value_text16(argv[0]); 964 #endif 965 }else if( strcmp(zCmd, "blob")==0 ){ 966 p2 = (const void*)sqlite3_value_blob(argv[0]); 967 }else{ 968 return; 969 } 970 sqlite3_result_int(context, p1!=p2); 971 } 972 973 974 /* 975 ** Usage: sqlite_test_create_function DB 976 ** 977 ** Call the sqlite3_create_function API on the given database in order 978 ** to create a function named "x_coalesce". This function does the same thing 979 ** as the "coalesce" function. This function also registers an SQL function 980 ** named "x_sqlite_exec" that invokes sqlite3_exec(). Invoking sqlite3_exec() 981 ** in this way is illegal recursion and should raise an SQLITE_MISUSE error. 982 ** The effect is similar to trying to use the same database connection from 983 ** two threads at the same time. 984 ** 985 ** The original motivation for this routine was to be able to call the 986 ** sqlite3_create_function function while a query is in progress in order 987 ** to test the SQLITE_MISUSE detection logic. 988 */ 989 static int test_create_function( 990 void *NotUsed, 991 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 992 int argc, /* Number of arguments */ 993 char **argv /* Text of each argument */ 994 ){ 995 int rc; 996 sqlite3 *db; 997 998 if( argc!=2 ){ 999 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1000 " DB\"", 0); 1001 return TCL_ERROR; 1002 } 1003 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 1004 rc = sqlite3_create_function(db, "x_coalesce", -1, SQLITE_ANY, 0, 1005 t1_ifnullFunc, 0, 0); 1006 if( rc==SQLITE_OK ){ 1007 rc = sqlite3_create_function(db, "hex8", 1, SQLITE_ANY, 0, 1008 hex8Func, 0, 0); 1009 } 1010 #ifndef SQLITE_OMIT_UTF16 1011 if( rc==SQLITE_OK ){ 1012 rc = sqlite3_create_function(db, "hex16", 1, SQLITE_ANY, 0, 1013 hex16Func, 0, 0); 1014 } 1015 #endif 1016 if( rc==SQLITE_OK ){ 1017 rc = sqlite3_create_function(db, "tkt2213func", 1, SQLITE_ANY, 0, 1018 tkt2213Function, 0, 0); 1019 } 1020 if( rc==SQLITE_OK ){ 1021 rc = sqlite3_create_function(db, "pointer_change", 4, SQLITE_ANY, 0, 1022 ptrChngFunction, 0, 0); 1023 } 1024 1025 #ifndef SQLITE_OMIT_UTF16 1026 /* Use the sqlite3_create_function16() API here. Mainly for fun, but also 1027 ** because it is not tested anywhere else. */ 1028 if( rc==SQLITE_OK ){ 1029 const void *zUtf16; 1030 sqlite3_value *pVal; 1031 sqlite3_mutex_enter(db->mutex); 1032 pVal = sqlite3ValueNew(db); 1033 sqlite3ValueSetStr(pVal, -1, "x_sqlite_exec", SQLITE_UTF8, SQLITE_STATIC); 1034 zUtf16 = sqlite3ValueText(pVal, SQLITE_UTF16NATIVE); 1035 if( db->mallocFailed ){ 1036 rc = SQLITE_NOMEM; 1037 }else{ 1038 rc = sqlite3_create_function16(db, zUtf16, 1039 1, SQLITE_UTF16, db, sqlite3ExecFunc, 0, 0); 1040 } 1041 sqlite3ValueFree(pVal); 1042 sqlite3_mutex_leave(db->mutex); 1043 } 1044 #endif 1045 1046 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 1047 Tcl_SetResult(interp, (char *)t1ErrorName(rc), 0); 1048 return TCL_OK; 1049 } 1050 1051 /* 1052 ** Routines to implement the x_count() aggregate function. 1053 ** 1054 ** x_count() counts the number of non-null arguments. But there are 1055 ** some twists for testing purposes. 1056 ** 1057 ** If the argument to x_count() is 40 then a UTF-8 error is reported 1058 ** on the step function. If x_count(41) is seen, then a UTF-16 error 1059 ** is reported on the step function. If the total count is 42, then 1060 ** a UTF-8 error is reported on the finalize function. 1061 */ 1062 typedef struct t1CountCtx t1CountCtx; 1063 struct t1CountCtx { 1064 int n; 1065 }; 1066 static void t1CountStep( 1067 sqlite3_context *context, 1068 int argc, 1069 sqlite3_value **argv 1070 ){ 1071 t1CountCtx *p; 1072 p = sqlite3_aggregate_context(context, sizeof(*p)); 1073 if( (argc==0 || SQLITE_NULL!=sqlite3_value_type(argv[0]) ) && p ){ 1074 p->n++; 1075 } 1076 if( argc>0 ){ 1077 int v = sqlite3_value_int(argv[0]); 1078 if( v==40 ){ 1079 sqlite3_result_error(context, "value of 40 handed to x_count", -1); 1080 #ifndef SQLITE_OMIT_UTF16 1081 }else if( v==41 ){ 1082 const char zUtf16ErrMsg[] = { 0, 0x61, 0, 0x62, 0, 0x63, 0, 0, 0}; 1083 sqlite3_result_error16(context, &zUtf16ErrMsg[1-SQLITE_BIGENDIAN], -1); 1084 #endif 1085 } 1086 } 1087 } 1088 static void t1CountFinalize(sqlite3_context *context){ 1089 t1CountCtx *p; 1090 p = sqlite3_aggregate_context(context, sizeof(*p)); 1091 if( p ){ 1092 if( p->n==42 ){ 1093 sqlite3_result_error(context, "x_count totals to 42", -1); 1094 }else{ 1095 sqlite3_result_int(context, p ? p->n : 0); 1096 } 1097 } 1098 } 1099 1100 #ifndef SQLITE_OMIT_DEPRECATED 1101 static void legacyCountStep( 1102 sqlite3_context *context, 1103 int argc, 1104 sqlite3_value **argv 1105 ){ 1106 /* no-op */ 1107 } 1108 1109 static void legacyCountFinalize(sqlite3_context *context){ 1110 sqlite3_result_int(context, sqlite3_aggregate_count(context)); 1111 } 1112 #endif 1113 1114 /* 1115 ** Usage: sqlite3_create_aggregate DB 1116 ** 1117 ** Call the sqlite3_create_function API on the given database in order 1118 ** to create a function named "x_count". This function is similar 1119 ** to the built-in count() function, with a few special quirks 1120 ** for testing the sqlite3_result_error() APIs. 1121 ** 1122 ** The original motivation for this routine was to be able to call the 1123 ** sqlite3_create_aggregate function while a query is in progress in order 1124 ** to test the SQLITE_MISUSE detection logic. See misuse.test. 1125 ** 1126 ** This routine was later extended to test the use of sqlite3_result_error() 1127 ** within aggregate functions. 1128 ** 1129 ** Later: It is now also extended to register the aggregate function 1130 ** "legacy_count()" with the supplied database handle. This is used 1131 ** to test the deprecated sqlite3_aggregate_count() API. 1132 */ 1133 static int test_create_aggregate( 1134 void *NotUsed, 1135 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1136 int argc, /* Number of arguments */ 1137 char **argv /* Text of each argument */ 1138 ){ 1139 sqlite3 *db; 1140 int rc; 1141 if( argc!=2 ){ 1142 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1143 " FILENAME\"", 0); 1144 return TCL_ERROR; 1145 } 1146 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 1147 rc = sqlite3_create_function(db, "x_count", 0, SQLITE_UTF8, 0, 0, 1148 t1CountStep,t1CountFinalize); 1149 if( rc==SQLITE_OK ){ 1150 rc = sqlite3_create_function(db, "x_count", 1, SQLITE_UTF8, 0, 0, 1151 t1CountStep,t1CountFinalize); 1152 } 1153 #ifndef SQLITE_OMIT_DEPRECATED 1154 if( rc==SQLITE_OK ){ 1155 rc = sqlite3_create_function(db, "legacy_count", 0, SQLITE_ANY, 0, 0, 1156 legacyCountStep, legacyCountFinalize 1157 ); 1158 } 1159 #endif 1160 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 1161 Tcl_SetResult(interp, (char *)t1ErrorName(rc), 0); 1162 return TCL_OK; 1163 } 1164 1165 1166 /* 1167 ** Usage: printf TEXT 1168 ** 1169 ** Send output to printf. Use this rather than puts to merge the output 1170 ** in the correct sequence with debugging printfs inserted into C code. 1171 ** Puts uses a separate buffer and debugging statements will be out of 1172 ** sequence if it is used. 1173 */ 1174 static int test_printf( 1175 void *NotUsed, 1176 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1177 int argc, /* Number of arguments */ 1178 char **argv /* Text of each argument */ 1179 ){ 1180 if( argc!=2 ){ 1181 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1182 " TEXT\"", 0); 1183 return TCL_ERROR; 1184 } 1185 printf("%s\n", argv[1]); 1186 return TCL_OK; 1187 } 1188 1189 1190 1191 /* 1192 ** Usage: sqlite3_mprintf_int FORMAT INTEGER INTEGER INTEGER 1193 ** 1194 ** Call mprintf with three integer arguments 1195 */ 1196 static int sqlite3_mprintf_int( 1197 void *NotUsed, 1198 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1199 int argc, /* Number of arguments */ 1200 char **argv /* Text of each argument */ 1201 ){ 1202 int a[3], i; 1203 char *z; 1204 if( argc!=5 ){ 1205 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1206 " FORMAT INT INT INT\"", 0); 1207 return TCL_ERROR; 1208 } 1209 for(i=2; i<5; i++){ 1210 if( Tcl_GetInt(interp, argv[i], &a[i-2]) ) return TCL_ERROR; 1211 } 1212 z = sqlite3_mprintf(argv[1], a[0], a[1], a[2]); 1213 Tcl_AppendResult(interp, z, 0); 1214 sqlite3_free(z); 1215 return TCL_OK; 1216 } 1217 1218 /* 1219 ** Usage: sqlite3_mprintf_int64 FORMAT INTEGER INTEGER INTEGER 1220 ** 1221 ** Call mprintf with three 64-bit integer arguments 1222 */ 1223 static int sqlite3_mprintf_int64( 1224 void *NotUsed, 1225 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1226 int argc, /* Number of arguments */ 1227 char **argv /* Text of each argument */ 1228 ){ 1229 int i; 1230 sqlite_int64 a[3]; 1231 char *z; 1232 if( argc!=5 ){ 1233 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1234 " FORMAT INT INT INT\"", 0); 1235 return TCL_ERROR; 1236 } 1237 for(i=2; i<5; i++){ 1238 if( !sqlite3Atoi64(argv[i], &a[i-2]) ){ 1239 Tcl_AppendResult(interp, "argument is not a valid 64-bit integer", 0); 1240 return TCL_ERROR; 1241 } 1242 } 1243 z = sqlite3_mprintf(argv[1], a[0], a[1], a[2]); 1244 Tcl_AppendResult(interp, z, 0); 1245 sqlite3_free(z); 1246 return TCL_OK; 1247 } 1248 1249 /* 1250 ** Usage: sqlite3_mprintf_long FORMAT INTEGER INTEGER INTEGER 1251 ** 1252 ** Call mprintf with three long integer arguments. This might be the 1253 ** same as sqlite3_mprintf_int or sqlite3_mprintf_int64, depending on 1254 ** platform. 1255 */ 1256 static int sqlite3_mprintf_long( 1257 void *NotUsed, 1258 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1259 int argc, /* Number of arguments */ 1260 char **argv /* Text of each argument */ 1261 ){ 1262 int i; 1263 long int a[3]; 1264 int b[3]; 1265 char *z; 1266 if( argc!=5 ){ 1267 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1268 " FORMAT INT INT INT\"", 0); 1269 return TCL_ERROR; 1270 } 1271 for(i=2; i<5; i++){ 1272 if( Tcl_GetInt(interp, argv[i], &b[i-2]) ) return TCL_ERROR; 1273 a[i-2] = (long int)b[i-2]; 1274 a[i-2] &= (((u64)1)<<(sizeof(int)*8))-1; 1275 } 1276 z = sqlite3_mprintf(argv[1], a[0], a[1], a[2]); 1277 Tcl_AppendResult(interp, z, 0); 1278 sqlite3_free(z); 1279 return TCL_OK; 1280 } 1281 1282 /* 1283 ** Usage: sqlite3_mprintf_str FORMAT INTEGER INTEGER STRING 1284 ** 1285 ** Call mprintf with two integer arguments and one string argument 1286 */ 1287 static int sqlite3_mprintf_str( 1288 void *NotUsed, 1289 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1290 int argc, /* Number of arguments */ 1291 char **argv /* Text of each argument */ 1292 ){ 1293 int a[3], i; 1294 char *z; 1295 if( argc<4 || argc>5 ){ 1296 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1297 " FORMAT INT INT ?STRING?\"", 0); 1298 return TCL_ERROR; 1299 } 1300 for(i=2; i<4; i++){ 1301 if( Tcl_GetInt(interp, argv[i], &a[i-2]) ) return TCL_ERROR; 1302 } 1303 z = sqlite3_mprintf(argv[1], a[0], a[1], argc>4 ? argv[4] : NULL); 1304 Tcl_AppendResult(interp, z, 0); 1305 sqlite3_free(z); 1306 return TCL_OK; 1307 } 1308 1309 /* 1310 ** Usage: sqlite3_snprintf_str INTEGER FORMAT INTEGER INTEGER STRING 1311 ** 1312 ** Call mprintf with two integer arguments and one string argument 1313 */ 1314 static int sqlite3_snprintf_str( 1315 void *NotUsed, 1316 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1317 int argc, /* Number of arguments */ 1318 char **argv /* Text of each argument */ 1319 ){ 1320 int a[3], i; 1321 int n; 1322 char *z; 1323 if( argc<5 || argc>6 ){ 1324 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1325 " INT FORMAT INT INT ?STRING?\"", 0); 1326 return TCL_ERROR; 1327 } 1328 if( Tcl_GetInt(interp, argv[1], &n) ) return TCL_ERROR; 1329 if( n<0 ){ 1330 Tcl_AppendResult(interp, "N must be non-negative", 0); 1331 return TCL_ERROR; 1332 } 1333 for(i=3; i<5; i++){ 1334 if( Tcl_GetInt(interp, argv[i], &a[i-3]) ) return TCL_ERROR; 1335 } 1336 z = sqlite3_malloc( n+1 ); 1337 sqlite3_snprintf(n, z, argv[2], a[0], a[1], argc>4 ? argv[5] : NULL); 1338 Tcl_AppendResult(interp, z, 0); 1339 sqlite3_free(z); 1340 return TCL_OK; 1341 } 1342 1343 /* 1344 ** Usage: sqlite3_mprintf_double FORMAT INTEGER INTEGER DOUBLE 1345 ** 1346 ** Call mprintf with two integer arguments and one double argument 1347 */ 1348 static int sqlite3_mprintf_double( 1349 void *NotUsed, 1350 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1351 int argc, /* Number of arguments */ 1352 char **argv /* Text of each argument */ 1353 ){ 1354 int a[3], i; 1355 double r; 1356 char *z; 1357 if( argc!=5 ){ 1358 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1359 " FORMAT INT INT DOUBLE\"", 0); 1360 return TCL_ERROR; 1361 } 1362 for(i=2; i<4; i++){ 1363 if( Tcl_GetInt(interp, argv[i], &a[i-2]) ) return TCL_ERROR; 1364 } 1365 if( Tcl_GetDouble(interp, argv[4], &r) ) return TCL_ERROR; 1366 z = sqlite3_mprintf(argv[1], a[0], a[1], r); 1367 Tcl_AppendResult(interp, z, 0); 1368 sqlite3_free(z); 1369 return TCL_OK; 1370 } 1371 1372 /* 1373 ** Usage: sqlite3_mprintf_scaled FORMAT DOUBLE DOUBLE 1374 ** 1375 ** Call mprintf with a single double argument which is the product of the 1376 ** two arguments given above. This is used to generate overflow and underflow 1377 ** doubles to test that they are converted properly. 1378 */ 1379 static int sqlite3_mprintf_scaled( 1380 void *NotUsed, 1381 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1382 int argc, /* Number of arguments */ 1383 char **argv /* Text of each argument */ 1384 ){ 1385 int i; 1386 double r[2]; 1387 char *z; 1388 if( argc!=4 ){ 1389 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1390 " FORMAT DOUBLE DOUBLE\"", 0); 1391 return TCL_ERROR; 1392 } 1393 for(i=2; i<4; i++){ 1394 if( Tcl_GetDouble(interp, argv[i], &r[i-2]) ) return TCL_ERROR; 1395 } 1396 z = sqlite3_mprintf(argv[1], r[0]*r[1]); 1397 Tcl_AppendResult(interp, z, 0); 1398 sqlite3_free(z); 1399 return TCL_OK; 1400 } 1401 1402 /* 1403 ** Usage: sqlite3_mprintf_stronly FORMAT STRING 1404 ** 1405 ** Call mprintf with a single double argument which is the product of the 1406 ** two arguments given above. This is used to generate overflow and underflow 1407 ** doubles to test that they are converted properly. 1408 */ 1409 static int sqlite3_mprintf_stronly( 1410 void *NotUsed, 1411 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1412 int argc, /* Number of arguments */ 1413 char **argv /* Text of each argument */ 1414 ){ 1415 char *z; 1416 if( argc!=3 ){ 1417 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1418 " FORMAT STRING\"", 0); 1419 return TCL_ERROR; 1420 } 1421 z = sqlite3_mprintf(argv[1], argv[2]); 1422 Tcl_AppendResult(interp, z, 0); 1423 sqlite3_free(z); 1424 return TCL_OK; 1425 } 1426 1427 /* 1428 ** Usage: sqlite3_mprintf_hexdouble FORMAT HEX 1429 ** 1430 ** Call mprintf with a single double argument which is derived from the 1431 ** hexadecimal encoding of an IEEE double. 1432 */ 1433 static int sqlite3_mprintf_hexdouble( 1434 void *NotUsed, 1435 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1436 int argc, /* Number of arguments */ 1437 char **argv /* Text of each argument */ 1438 ){ 1439 char *z; 1440 double r; 1441 unsigned int x1, x2; 1442 sqlite_uint64 d; 1443 if( argc!=3 ){ 1444 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1445 " FORMAT STRING\"", 0); 1446 return TCL_ERROR; 1447 } 1448 if( sscanf(argv[2], "%08x%08x", &x2, &x1)!=2 ){ 1449 Tcl_AppendResult(interp, "2nd argument should be 16-characters of hex", 0); 1450 return TCL_ERROR; 1451 } 1452 d = x2; 1453 d = (d<<32) + x1; 1454 memcpy(&r, &d, sizeof(r)); 1455 z = sqlite3_mprintf(argv[1], r); 1456 Tcl_AppendResult(interp, z, 0); 1457 sqlite3_free(z); 1458 return TCL_OK; 1459 } 1460 1461 /* 1462 ** Usage: sqlite3_enable_shared_cache ?BOOLEAN? 1463 ** 1464 */ 1465 #if !defined(SQLITE_OMIT_SHARED_CACHE) 1466 static int test_enable_shared( 1467 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 1468 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1469 int objc, /* Number of arguments */ 1470 Tcl_Obj *CONST objv[] /* Command arguments */ 1471 ){ 1472 int rc; 1473 int enable; 1474 int ret = 0; 1475 1476 if( objc!=2 && objc!=1 ){ 1477 Tcl_WrongNumArgs(interp, 1, objv, "?BOOLEAN?"); 1478 return TCL_ERROR; 1479 } 1480 ret = sqlite3GlobalConfig.sharedCacheEnabled; 1481 1482 if( objc==2 ){ 1483 if( Tcl_GetBooleanFromObj(interp, objv[1], &enable) ){ 1484 return TCL_ERROR; 1485 } 1486 rc = sqlite3_enable_shared_cache(enable); 1487 if( rc!=SQLITE_OK ){ 1488 Tcl_SetResult(interp, (char *)sqlite3ErrStr(rc), TCL_STATIC); 1489 return TCL_ERROR; 1490 } 1491 } 1492 Tcl_SetObjResult(interp, Tcl_NewBooleanObj(ret)); 1493 return TCL_OK; 1494 } 1495 #endif 1496 1497 1498 1499 /* 1500 ** Usage: sqlite3_extended_result_codes DB BOOLEAN 1501 ** 1502 */ 1503 static int test_extended_result_codes( 1504 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 1505 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1506 int objc, /* Number of arguments */ 1507 Tcl_Obj *CONST objv[] /* Command arguments */ 1508 ){ 1509 int enable; 1510 sqlite3 *db; 1511 1512 if( objc!=3 ){ 1513 Tcl_WrongNumArgs(interp, 1, objv, "DB BOOLEAN"); 1514 return TCL_ERROR; 1515 } 1516 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 1517 if( Tcl_GetBooleanFromObj(interp, objv[2], &enable) ) return TCL_ERROR; 1518 sqlite3_extended_result_codes(db, enable); 1519 return TCL_OK; 1520 } 1521 1522 /* 1523 ** Usage: sqlite3_libversion_number 1524 ** 1525 */ 1526 static int test_libversion_number( 1527 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 1528 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1529 int objc, /* Number of arguments */ 1530 Tcl_Obj *CONST objv[] /* Command arguments */ 1531 ){ 1532 Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_libversion_number())); 1533 return TCL_OK; 1534 } 1535 1536 /* 1537 ** Usage: sqlite3_table_column_metadata DB dbname tblname colname 1538 ** 1539 */ 1540 #ifdef SQLITE_ENABLE_COLUMN_METADATA 1541 static int test_table_column_metadata( 1542 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 1543 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1544 int objc, /* Number of arguments */ 1545 Tcl_Obj *CONST objv[] /* Command arguments */ 1546 ){ 1547 sqlite3 *db; 1548 const char *zDb; 1549 const char *zTbl; 1550 const char *zCol; 1551 int rc; 1552 Tcl_Obj *pRet; 1553 1554 const char *zDatatype; 1555 const char *zCollseq; 1556 int notnull; 1557 int primarykey; 1558 int autoincrement; 1559 1560 if( objc!=5 ){ 1561 Tcl_WrongNumArgs(interp, 1, objv, "DB dbname tblname colname"); 1562 return TCL_ERROR; 1563 } 1564 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 1565 zDb = Tcl_GetString(objv[2]); 1566 zTbl = Tcl_GetString(objv[3]); 1567 zCol = Tcl_GetString(objv[4]); 1568 1569 if( strlen(zDb)==0 ) zDb = 0; 1570 1571 rc = sqlite3_table_column_metadata(db, zDb, zTbl, zCol, 1572 &zDatatype, &zCollseq, ¬null, &primarykey, &autoincrement); 1573 1574 if( rc!=SQLITE_OK ){ 1575 Tcl_AppendResult(interp, sqlite3_errmsg(db), 0); 1576 return TCL_ERROR; 1577 } 1578 1579 pRet = Tcl_NewObj(); 1580 Tcl_ListObjAppendElement(0, pRet, Tcl_NewStringObj(zDatatype, -1)); 1581 Tcl_ListObjAppendElement(0, pRet, Tcl_NewStringObj(zCollseq, -1)); 1582 Tcl_ListObjAppendElement(0, pRet, Tcl_NewIntObj(notnull)); 1583 Tcl_ListObjAppendElement(0, pRet, Tcl_NewIntObj(primarykey)); 1584 Tcl_ListObjAppendElement(0, pRet, Tcl_NewIntObj(autoincrement)); 1585 Tcl_SetObjResult(interp, pRet); 1586 1587 return TCL_OK; 1588 } 1589 #endif 1590 1591 #ifndef SQLITE_OMIT_INCRBLOB 1592 1593 /* 1594 ** sqlite3_blob_read CHANNEL OFFSET N 1595 ** 1596 ** This command is used to test the sqlite3_blob_read() in ways that 1597 ** the Tcl channel interface does not. The first argument should 1598 ** be the name of a valid channel created by the [incrblob] method 1599 ** of a database handle. This function calls sqlite3_blob_read() 1600 ** to read N bytes from offset OFFSET from the underlying SQLite 1601 ** blob handle. 1602 ** 1603 ** On success, a byte-array object containing the read data is 1604 ** returned. On failure, the interpreter result is set to the 1605 ** text representation of the returned error code (i.e. "SQLITE_NOMEM") 1606 ** and a Tcl exception is thrown. 1607 */ 1608 static int test_blob_read( 1609 ClientData clientData, /* Not used */ 1610 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1611 int objc, /* Number of arguments */ 1612 Tcl_Obj *CONST objv[] /* Command arguments */ 1613 ){ 1614 Tcl_Channel channel; 1615 ClientData instanceData; 1616 sqlite3_blob *pBlob; 1617 int notUsed; 1618 int nByte; 1619 int iOffset; 1620 unsigned char *zBuf; 1621 int rc; 1622 1623 if( objc!=4 ){ 1624 Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL OFFSET N"); 1625 return TCL_ERROR; 1626 } 1627 1628 channel = Tcl_GetChannel(interp, Tcl_GetString(objv[1]), ¬Used); 1629 if( !channel 1630 || TCL_OK!=Tcl_GetIntFromObj(interp, objv[2], &iOffset) 1631 || TCL_OK!=Tcl_GetIntFromObj(interp, objv[3], &nByte) 1632 || nByte<0 || iOffset<0 1633 ){ 1634 return TCL_ERROR; 1635 } 1636 1637 instanceData = Tcl_GetChannelInstanceData(channel); 1638 pBlob = *((sqlite3_blob **)instanceData); 1639 1640 zBuf = (unsigned char *)Tcl_Alloc(nByte); 1641 rc = sqlite3_blob_read(pBlob, zBuf, nByte, iOffset); 1642 if( rc==SQLITE_OK ){ 1643 Tcl_SetObjResult(interp, Tcl_NewByteArrayObj(zBuf, nByte)); 1644 }else{ 1645 Tcl_SetResult(interp, (char *)sqlite3TestErrorName(rc), TCL_VOLATILE); 1646 } 1647 Tcl_Free((char *)zBuf); 1648 1649 return (rc==SQLITE_OK ? TCL_OK : TCL_ERROR); 1650 } 1651 1652 /* 1653 ** sqlite3_blob_write CHANNEL OFFSET DATA ?NDATA? 1654 ** 1655 ** This command is used to test the sqlite3_blob_write() in ways that 1656 ** the Tcl channel interface does not. The first argument should 1657 ** be the name of a valid channel created by the [incrblob] method 1658 ** of a database handle. This function calls sqlite3_blob_write() 1659 ** to write the DATA byte-array to the underlying SQLite blob handle. 1660 ** at offset OFFSET. 1661 ** 1662 ** On success, an empty string is returned. On failure, the interpreter 1663 ** result is set to the text representation of the returned error code 1664 ** (i.e. "SQLITE_NOMEM") and a Tcl exception is thrown. 1665 */ 1666 static int test_blob_write( 1667 ClientData clientData, /* Not used */ 1668 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1669 int objc, /* Number of arguments */ 1670 Tcl_Obj *CONST objv[] /* Command arguments */ 1671 ){ 1672 Tcl_Channel channel; 1673 ClientData instanceData; 1674 sqlite3_blob *pBlob; 1675 int notUsed; 1676 int iOffset; 1677 int rc; 1678 1679 unsigned char *zBuf; 1680 int nBuf; 1681 1682 if( objc!=4 && objc!=5 ){ 1683 Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL OFFSET DATA ?NDATA?"); 1684 return TCL_ERROR; 1685 } 1686 1687 channel = Tcl_GetChannel(interp, Tcl_GetString(objv[1]), ¬Used); 1688 if( !channel || TCL_OK!=Tcl_GetIntFromObj(interp, objv[2], &iOffset) ){ 1689 return TCL_ERROR; 1690 } 1691 1692 instanceData = Tcl_GetChannelInstanceData(channel); 1693 pBlob = *((sqlite3_blob **)instanceData); 1694 1695 zBuf = Tcl_GetByteArrayFromObj(objv[3], &nBuf); 1696 if( objc==5 && Tcl_GetIntFromObj(interp, objv[4], &nBuf) ){ 1697 return TCL_ERROR; 1698 } 1699 rc = sqlite3_blob_write(pBlob, zBuf, nBuf, iOffset); 1700 if( rc!=SQLITE_OK ){ 1701 Tcl_SetResult(interp, (char *)sqlite3TestErrorName(rc), TCL_VOLATILE); 1702 } 1703 1704 return (rc==SQLITE_OK ? TCL_OK : TCL_ERROR); 1705 } 1706 #endif 1707 1708 /* 1709 ** Usage: sqlite3_create_collation_v2 DB-HANDLE NAME CMP-PROC DEL-PROC 1710 ** 1711 ** This Tcl proc is used for testing the experimental 1712 ** sqlite3_create_collation_v2() interface. 1713 */ 1714 struct TestCollationX { 1715 Tcl_Interp *interp; 1716 Tcl_Obj *pCmp; 1717 Tcl_Obj *pDel; 1718 }; 1719 typedef struct TestCollationX TestCollationX; 1720 static void testCreateCollationDel(void *pCtx){ 1721 TestCollationX *p = (TestCollationX *)pCtx; 1722 1723 int rc = Tcl_EvalObjEx(p->interp, p->pDel, TCL_EVAL_DIRECT|TCL_EVAL_GLOBAL); 1724 if( rc!=TCL_OK ){ 1725 Tcl_BackgroundError(p->interp); 1726 } 1727 1728 Tcl_DecrRefCount(p->pCmp); 1729 Tcl_DecrRefCount(p->pDel); 1730 sqlite3_free((void *)p); 1731 } 1732 static int testCreateCollationCmp( 1733 void *pCtx, 1734 int nLeft, 1735 const void *zLeft, 1736 int nRight, 1737 const void *zRight 1738 ){ 1739 TestCollationX *p = (TestCollationX *)pCtx; 1740 Tcl_Obj *pScript = Tcl_DuplicateObj(p->pCmp); 1741 int iRes = 0; 1742 1743 Tcl_IncrRefCount(pScript); 1744 Tcl_ListObjAppendElement(0, pScript, Tcl_NewStringObj((char *)zLeft, nLeft)); 1745 Tcl_ListObjAppendElement(0, pScript, Tcl_NewStringObj((char *)zRight,nRight)); 1746 1747 if( TCL_OK!=Tcl_EvalObjEx(p->interp, pScript, TCL_EVAL_DIRECT|TCL_EVAL_GLOBAL) 1748 || TCL_OK!=Tcl_GetIntFromObj(p->interp, Tcl_GetObjResult(p->interp), &iRes) 1749 ){ 1750 Tcl_BackgroundError(p->interp); 1751 } 1752 Tcl_DecrRefCount(pScript); 1753 1754 return iRes; 1755 } 1756 static int test_create_collation_v2( 1757 ClientData clientData, /* Not used */ 1758 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1759 int objc, /* Number of arguments */ 1760 Tcl_Obj *CONST objv[] /* Command arguments */ 1761 ){ 1762 TestCollationX *p; 1763 sqlite3 *db; 1764 int rc; 1765 1766 if( objc!=5 ){ 1767 Tcl_WrongNumArgs(interp, 1, objv, "DB-HANDLE NAME CMP-PROC DEL-PROC"); 1768 return TCL_ERROR; 1769 } 1770 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 1771 1772 p = (TestCollationX *)sqlite3_malloc(sizeof(TestCollationX)); 1773 p->pCmp = objv[3]; 1774 p->pDel = objv[4]; 1775 p->interp = interp; 1776 Tcl_IncrRefCount(p->pCmp); 1777 Tcl_IncrRefCount(p->pDel); 1778 1779 rc = sqlite3_create_collation_v2(db, Tcl_GetString(objv[2]), 16, 1780 (void *)p, testCreateCollationCmp, testCreateCollationDel 1781 ); 1782 if( rc!=SQLITE_MISUSE ){ 1783 Tcl_AppendResult(interp, "sqlite3_create_collate_v2() failed to detect " 1784 "an invalid encoding", (char*)0); 1785 return TCL_ERROR; 1786 } 1787 rc = sqlite3_create_collation_v2(db, Tcl_GetString(objv[2]), SQLITE_UTF8, 1788 (void *)p, testCreateCollationCmp, testCreateCollationDel 1789 ); 1790 return TCL_OK; 1791 } 1792 1793 /* 1794 ** Usage: sqlite3_load_extension DB-HANDLE FILE ?PROC? 1795 */ 1796 static int test_load_extension( 1797 ClientData clientData, /* Not used */ 1798 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1799 int objc, /* Number of arguments */ 1800 Tcl_Obj *CONST objv[] /* Command arguments */ 1801 ){ 1802 Tcl_CmdInfo cmdInfo; 1803 sqlite3 *db; 1804 int rc; 1805 char *zDb; 1806 char *zFile; 1807 char *zProc = 0; 1808 char *zErr = 0; 1809 1810 if( objc!=4 && objc!=3 ){ 1811 Tcl_WrongNumArgs(interp, 1, objv, "DB-HANDLE FILE ?PROC?"); 1812 return TCL_ERROR; 1813 } 1814 zDb = Tcl_GetString(objv[1]); 1815 zFile = Tcl_GetString(objv[2]); 1816 if( objc==4 ){ 1817 zProc = Tcl_GetString(objv[3]); 1818 } 1819 1820 /* Extract the C database handle from the Tcl command name */ 1821 if( !Tcl_GetCommandInfo(interp, zDb, &cmdInfo) ){ 1822 Tcl_AppendResult(interp, "command not found: ", zDb, (char*)0); 1823 return TCL_ERROR; 1824 } 1825 db = ((struct SqliteDb*)cmdInfo.objClientData)->db; 1826 assert(db); 1827 1828 /* Call the underlying C function. If an error occurs, set rc to 1829 ** TCL_ERROR and load any error string into the interpreter. If no 1830 ** error occurs, set rc to TCL_OK. 1831 */ 1832 #ifdef SQLITE_OMIT_LOAD_EXTENSION 1833 rc = SQLITE_ERROR; 1834 zErr = sqlite3_mprintf("this build omits sqlite3_load_extension()"); 1835 #else 1836 rc = sqlite3_load_extension(db, zFile, zProc, &zErr); 1837 #endif 1838 if( rc!=SQLITE_OK ){ 1839 Tcl_SetResult(interp, zErr ? zErr : "", TCL_VOLATILE); 1840 rc = TCL_ERROR; 1841 }else{ 1842 rc = TCL_OK; 1843 } 1844 sqlite3_free(zErr); 1845 1846 return rc; 1847 } 1848 1849 /* 1850 ** Usage: sqlite3_enable_load_extension DB-HANDLE ONOFF 1851 */ 1852 static int test_enable_load( 1853 ClientData clientData, /* Not used */ 1854 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1855 int objc, /* Number of arguments */ 1856 Tcl_Obj *CONST objv[] /* Command arguments */ 1857 ){ 1858 Tcl_CmdInfo cmdInfo; 1859 sqlite3 *db; 1860 char *zDb; 1861 int onoff; 1862 1863 if( objc!=3 ){ 1864 Tcl_WrongNumArgs(interp, 1, objv, "DB-HANDLE ONOFF"); 1865 return TCL_ERROR; 1866 } 1867 zDb = Tcl_GetString(objv[1]); 1868 1869 /* Extract the C database handle from the Tcl command name */ 1870 if( !Tcl_GetCommandInfo(interp, zDb, &cmdInfo) ){ 1871 Tcl_AppendResult(interp, "command not found: ", zDb, (char*)0); 1872 return TCL_ERROR; 1873 } 1874 db = ((struct SqliteDb*)cmdInfo.objClientData)->db; 1875 assert(db); 1876 1877 /* Get the onoff parameter */ 1878 if( Tcl_GetBooleanFromObj(interp, objv[2], &onoff) ){ 1879 return TCL_ERROR; 1880 } 1881 1882 #ifdef SQLITE_OMIT_LOAD_EXTENSION 1883 Tcl_AppendResult(interp, "this build omits sqlite3_load_extension()"); 1884 return TCL_ERROR; 1885 #else 1886 sqlite3_enable_load_extension(db, onoff); 1887 return TCL_OK; 1888 #endif 1889 } 1890 1891 /* 1892 ** Usage: sqlite_abort 1893 ** 1894 ** Shutdown the process immediately. This is not a clean shutdown. 1895 ** This command is used to test the recoverability of a database in 1896 ** the event of a program crash. 1897 */ 1898 static int sqlite_abort( 1899 void *NotUsed, 1900 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1901 int argc, /* Number of arguments */ 1902 char **argv /* Text of each argument */ 1903 ){ 1904 #if defined(_MSC_VER) 1905 /* We do this, otherwise the test will halt with a popup message 1906 * that we have to click away before the test will continue. 1907 */ 1908 _set_abort_behavior( 0, _CALL_REPORTFAULT ); 1909 #endif 1910 exit(255); 1911 assert( interp==0 ); /* This will always fail */ 1912 return TCL_OK; 1913 } 1914 1915 /* 1916 ** The following routine is a user-defined SQL function whose purpose 1917 ** is to test the sqlite_set_result() API. 1918 */ 1919 static void testFunc(sqlite3_context *context, int argc, sqlite3_value **argv){ 1920 while( argc>=2 ){ 1921 const char *zArg0 = (char*)sqlite3_value_text(argv[0]); 1922 if( zArg0 ){ 1923 if( 0==sqlite3StrICmp(zArg0, "int") ){ 1924 sqlite3_result_int(context, sqlite3_value_int(argv[1])); 1925 }else if( sqlite3StrICmp(zArg0,"int64")==0 ){ 1926 sqlite3_result_int64(context, sqlite3_value_int64(argv[1])); 1927 }else if( sqlite3StrICmp(zArg0,"string")==0 ){ 1928 sqlite3_result_text(context, (char*)sqlite3_value_text(argv[1]), -1, 1929 SQLITE_TRANSIENT); 1930 }else if( sqlite3StrICmp(zArg0,"double")==0 ){ 1931 sqlite3_result_double(context, sqlite3_value_double(argv[1])); 1932 }else if( sqlite3StrICmp(zArg0,"null")==0 ){ 1933 sqlite3_result_null(context); 1934 }else if( sqlite3StrICmp(zArg0,"value")==0 ){ 1935 sqlite3_result_value(context, argv[sqlite3_value_int(argv[1])]); 1936 }else{ 1937 goto error_out; 1938 } 1939 }else{ 1940 goto error_out; 1941 } 1942 argc -= 2; 1943 argv += 2; 1944 } 1945 return; 1946 1947 error_out: 1948 sqlite3_result_error(context,"first argument should be one of: " 1949 "int int64 string double null value", -1); 1950 } 1951 1952 /* 1953 ** Usage: sqlite_register_test_function DB NAME 1954 ** 1955 ** Register the test SQL function on the database DB under the name NAME. 1956 */ 1957 static int test_register_func( 1958 void *NotUsed, 1959 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 1960 int argc, /* Number of arguments */ 1961 char **argv /* Text of each argument */ 1962 ){ 1963 sqlite3 *db; 1964 int rc; 1965 if( argc!=3 ){ 1966 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 1967 " DB FUNCTION-NAME", 0); 1968 return TCL_ERROR; 1969 } 1970 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 1971 rc = sqlite3_create_function(db, argv[2], -1, SQLITE_UTF8, 0, 1972 testFunc, 0, 0); 1973 if( rc!=0 ){ 1974 Tcl_AppendResult(interp, sqlite3ErrStr(rc), 0); 1975 return TCL_ERROR; 1976 } 1977 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 1978 return TCL_OK; 1979 } 1980 1981 /* 1982 ** Usage: sqlite3_finalize STMT 1983 ** 1984 ** Finalize a statement handle. 1985 */ 1986 static int test_finalize( 1987 void * clientData, 1988 Tcl_Interp *interp, 1989 int objc, 1990 Tcl_Obj *CONST objv[] 1991 ){ 1992 sqlite3_stmt *pStmt; 1993 int rc; 1994 sqlite3 *db = 0; 1995 1996 if( objc!=2 ){ 1997 Tcl_AppendResult(interp, "wrong # args: should be \"", 1998 Tcl_GetStringFromObj(objv[0], 0), " <STMT>", 0); 1999 return TCL_ERROR; 2000 } 2001 2002 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 2003 2004 if( pStmt ){ 2005 db = StmtToDb(pStmt); 2006 } 2007 rc = sqlite3_finalize(pStmt); 2008 Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); 2009 if( db && sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 2010 return TCL_OK; 2011 } 2012 2013 /* 2014 ** Usage: sqlite3_stmt_status STMT CODE RESETFLAG 2015 ** 2016 ** Get the value of a status counter from a statement. 2017 */ 2018 static int test_stmt_status( 2019 void * clientData, 2020 Tcl_Interp *interp, 2021 int objc, 2022 Tcl_Obj *CONST objv[] 2023 ){ 2024 int iValue; 2025 int i, op, resetFlag; 2026 const char *zOpName; 2027 sqlite3_stmt *pStmt; 2028 2029 static const struct { 2030 const char *zName; 2031 int op; 2032 } aOp[] = { 2033 { "SQLITE_STMTSTATUS_FULLSCAN_STEP", SQLITE_STMTSTATUS_FULLSCAN_STEP }, 2034 { "SQLITE_STMTSTATUS_SORT", SQLITE_STMTSTATUS_SORT }, 2035 { "SQLITE_STMTSTATUS_AUTOINDEX", SQLITE_STMTSTATUS_AUTOINDEX }, 2036 }; 2037 if( objc!=4 ){ 2038 Tcl_WrongNumArgs(interp, 1, objv, "STMT PARAMETER RESETFLAG"); 2039 return TCL_ERROR; 2040 } 2041 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 2042 zOpName = Tcl_GetString(objv[2]); 2043 for(i=0; i<ArraySize(aOp); i++){ 2044 if( strcmp(aOp[i].zName, zOpName)==0 ){ 2045 op = aOp[i].op; 2046 break; 2047 } 2048 } 2049 if( i>=ArraySize(aOp) ){ 2050 if( Tcl_GetIntFromObj(interp, objv[2], &op) ) return TCL_ERROR; 2051 } 2052 if( Tcl_GetBooleanFromObj(interp, objv[3], &resetFlag) ) return TCL_ERROR; 2053 iValue = sqlite3_stmt_status(pStmt, op, resetFlag); 2054 Tcl_SetObjResult(interp, Tcl_NewIntObj(iValue)); 2055 return TCL_OK; 2056 } 2057 2058 /* 2059 ** Usage: sqlite3_next_stmt DB STMT 2060 ** 2061 ** Return the next statment in sequence after STMT. 2062 */ 2063 static int test_next_stmt( 2064 void * clientData, 2065 Tcl_Interp *interp, 2066 int objc, 2067 Tcl_Obj *CONST objv[] 2068 ){ 2069 sqlite3_stmt *pStmt; 2070 sqlite3 *db = 0; 2071 char zBuf[50]; 2072 2073 if( objc!=3 ){ 2074 Tcl_AppendResult(interp, "wrong # args: should be \"", 2075 Tcl_GetStringFromObj(objv[0], 0), " DB STMT", 0); 2076 return TCL_ERROR; 2077 } 2078 2079 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 2080 if( getStmtPointer(interp, Tcl_GetString(objv[2]), &pStmt) ) return TCL_ERROR; 2081 pStmt = sqlite3_next_stmt(db, pStmt); 2082 if( pStmt ){ 2083 if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; 2084 Tcl_AppendResult(interp, zBuf, 0); 2085 } 2086 return TCL_OK; 2087 } 2088 2089 2090 /* 2091 ** Usage: sqlite3_reset STMT 2092 ** 2093 ** Reset a statement handle. 2094 */ 2095 static int test_reset( 2096 void * clientData, 2097 Tcl_Interp *interp, 2098 int objc, 2099 Tcl_Obj *CONST objv[] 2100 ){ 2101 sqlite3_stmt *pStmt; 2102 int rc; 2103 2104 if( objc!=2 ){ 2105 Tcl_AppendResult(interp, "wrong # args: should be \"", 2106 Tcl_GetStringFromObj(objv[0], 0), " <STMT>", 0); 2107 return TCL_ERROR; 2108 } 2109 2110 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 2111 2112 rc = sqlite3_reset(pStmt); 2113 if( pStmt && sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ){ 2114 return TCL_ERROR; 2115 } 2116 Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); 2117 /* 2118 if( rc ){ 2119 return TCL_ERROR; 2120 } 2121 */ 2122 return TCL_OK; 2123 } 2124 2125 /* 2126 ** Usage: sqlite3_expired STMT 2127 ** 2128 ** Return TRUE if a recompilation of the statement is recommended. 2129 */ 2130 static int test_expired( 2131 void * clientData, 2132 Tcl_Interp *interp, 2133 int objc, 2134 Tcl_Obj *CONST objv[] 2135 ){ 2136 #ifndef SQLITE_OMIT_DEPRECATED 2137 sqlite3_stmt *pStmt; 2138 if( objc!=2 ){ 2139 Tcl_AppendResult(interp, "wrong # args: should be \"", 2140 Tcl_GetStringFromObj(objv[0], 0), " <STMT>", 0); 2141 return TCL_ERROR; 2142 } 2143 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 2144 Tcl_SetObjResult(interp, Tcl_NewBooleanObj(sqlite3_expired(pStmt))); 2145 #endif 2146 return TCL_OK; 2147 } 2148 2149 /* 2150 ** Usage: sqlite3_transfer_bindings FROMSTMT TOSTMT 2151 ** 2152 ** Transfer all bindings from FROMSTMT over to TOSTMT 2153 */ 2154 static int test_transfer_bind( 2155 void * clientData, 2156 Tcl_Interp *interp, 2157 int objc, 2158 Tcl_Obj *CONST objv[] 2159 ){ 2160 #ifndef SQLITE_OMIT_DEPRECATED 2161 sqlite3_stmt *pStmt1, *pStmt2; 2162 if( objc!=3 ){ 2163 Tcl_AppendResult(interp, "wrong # args: should be \"", 2164 Tcl_GetStringFromObj(objv[0], 0), " FROM-STMT TO-STMT", 0); 2165 return TCL_ERROR; 2166 } 2167 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt1)) return TCL_ERROR; 2168 if( getStmtPointer(interp, Tcl_GetString(objv[2]), &pStmt2)) return TCL_ERROR; 2169 Tcl_SetObjResult(interp, 2170 Tcl_NewIntObj(sqlite3_transfer_bindings(pStmt1,pStmt2))); 2171 #endif 2172 return TCL_OK; 2173 } 2174 2175 /* 2176 ** Usage: sqlite3_changes DB 2177 ** 2178 ** Return the number of changes made to the database by the last SQL 2179 ** execution. 2180 */ 2181 static int test_changes( 2182 void * clientData, 2183 Tcl_Interp *interp, 2184 int objc, 2185 Tcl_Obj *CONST objv[] 2186 ){ 2187 sqlite3 *db; 2188 if( objc!=2 ){ 2189 Tcl_AppendResult(interp, "wrong # args: should be \"", 2190 Tcl_GetString(objv[0]), " DB", 0); 2191 return TCL_ERROR; 2192 } 2193 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 2194 Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_changes(db))); 2195 return TCL_OK; 2196 } 2197 2198 /* 2199 ** This is the "static_bind_value" that variables are bound to when 2200 ** the FLAG option of sqlite3_bind is "static" 2201 */ 2202 static char *sqlite_static_bind_value = 0; 2203 static int sqlite_static_bind_nbyte = 0; 2204 2205 /* 2206 ** Usage: sqlite3_bind VM IDX VALUE FLAGS 2207 ** 2208 ** Sets the value of the IDX-th occurance of "?" in the original SQL 2209 ** string. VALUE is the new value. If FLAGS=="null" then VALUE is 2210 ** ignored and the value is set to NULL. If FLAGS=="static" then 2211 ** the value is set to the value of a static variable named 2212 ** "sqlite_static_bind_value". If FLAGS=="normal" then a copy 2213 ** of the VALUE is made. If FLAGS=="blob10" then a VALUE is ignored 2214 ** an a 10-byte blob "abc\000xyz\000pq" is inserted. 2215 */ 2216 static int test_bind( 2217 void *NotUsed, 2218 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 2219 int argc, /* Number of arguments */ 2220 char **argv /* Text of each argument */ 2221 ){ 2222 sqlite3_stmt *pStmt; 2223 int rc; 2224 int idx; 2225 if( argc!=5 ){ 2226 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 2227 " VM IDX VALUE (null|static|normal)\"", 0); 2228 return TCL_ERROR; 2229 } 2230 if( getStmtPointer(interp, argv[1], &pStmt) ) return TCL_ERROR; 2231 if( Tcl_GetInt(interp, argv[2], &idx) ) return TCL_ERROR; 2232 if( strcmp(argv[4],"null")==0 ){ 2233 rc = sqlite3_bind_null(pStmt, idx); 2234 }else if( strcmp(argv[4],"static")==0 ){ 2235 rc = sqlite3_bind_text(pStmt, idx, sqlite_static_bind_value, -1, 0); 2236 }else if( strcmp(argv[4],"static-nbytes")==0 ){ 2237 rc = sqlite3_bind_text(pStmt, idx, sqlite_static_bind_value, 2238 sqlite_static_bind_nbyte, 0); 2239 }else if( strcmp(argv[4],"normal")==0 ){ 2240 rc = sqlite3_bind_text(pStmt, idx, argv[3], -1, SQLITE_TRANSIENT); 2241 }else if( strcmp(argv[4],"blob10")==0 ){ 2242 rc = sqlite3_bind_text(pStmt, idx, "abc\000xyz\000pq", 10, SQLITE_STATIC); 2243 }else{ 2244 Tcl_AppendResult(interp, "4th argument should be " 2245 "\"null\" or \"static\" or \"normal\"", 0); 2246 return TCL_ERROR; 2247 } 2248 if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; 2249 if( rc ){ 2250 char zBuf[50]; 2251 sprintf(zBuf, "(%d) ", rc); 2252 Tcl_AppendResult(interp, zBuf, sqlite3ErrStr(rc), 0); 2253 return TCL_ERROR; 2254 } 2255 return TCL_OK; 2256 } 2257 2258 #ifndef SQLITE_OMIT_UTF16 2259 /* 2260 ** Usage: add_test_collate <db ptr> <utf8> <utf16le> <utf16be> 2261 ** 2262 ** This function is used to test that SQLite selects the correct collation 2263 ** sequence callback when multiple versions (for different text encodings) 2264 ** are available. 2265 ** 2266 ** Calling this routine registers the collation sequence "test_collate" 2267 ** with database handle <db>. The second argument must be a list of three 2268 ** boolean values. If the first is true, then a version of test_collate is 2269 ** registered for UTF-8, if the second is true, a version is registered for 2270 ** UTF-16le, if the third is true, a UTF-16be version is available. 2271 ** Previous versions of test_collate are deleted. 2272 ** 2273 ** The collation sequence test_collate is implemented by calling the 2274 ** following TCL script: 2275 ** 2276 ** "test_collate <enc> <lhs> <rhs>" 2277 ** 2278 ** The <lhs> and <rhs> are the two values being compared, encoded in UTF-8. 2279 ** The <enc> parameter is the encoding of the collation function that 2280 ** SQLite selected to call. The TCL test script implements the 2281 ** "test_collate" proc. 2282 ** 2283 ** Note that this will only work with one intepreter at a time, as the 2284 ** interp pointer to use when evaluating the TCL script is stored in 2285 ** pTestCollateInterp. 2286 */ 2287 static Tcl_Interp* pTestCollateInterp; 2288 static int test_collate_func( 2289 void *pCtx, 2290 int nA, const void *zA, 2291 int nB, const void *zB 2292 ){ 2293 Tcl_Interp *i = pTestCollateInterp; 2294 int encin = (int)pCtx; 2295 int res; 2296 int n; 2297 2298 sqlite3_value *pVal; 2299 Tcl_Obj *pX; 2300 2301 pX = Tcl_NewStringObj("test_collate", -1); 2302 Tcl_IncrRefCount(pX); 2303 2304 switch( encin ){ 2305 case SQLITE_UTF8: 2306 Tcl_ListObjAppendElement(i,pX,Tcl_NewStringObj("UTF-8",-1)); 2307 break; 2308 case SQLITE_UTF16LE: 2309 Tcl_ListObjAppendElement(i,pX,Tcl_NewStringObj("UTF-16LE",-1)); 2310 break; 2311 case SQLITE_UTF16BE: 2312 Tcl_ListObjAppendElement(i,pX,Tcl_NewStringObj("UTF-16BE",-1)); 2313 break; 2314 default: 2315 assert(0); 2316 } 2317 2318 sqlite3BeginBenignMalloc(); 2319 pVal = sqlite3ValueNew(0); 2320 if( pVal ){ 2321 sqlite3ValueSetStr(pVal, nA, zA, encin, SQLITE_STATIC); 2322 n = sqlite3_value_bytes(pVal); 2323 Tcl_ListObjAppendElement(i,pX, 2324 Tcl_NewStringObj((char*)sqlite3_value_text(pVal),n)); 2325 sqlite3ValueSetStr(pVal, nB, zB, encin, SQLITE_STATIC); 2326 n = sqlite3_value_bytes(pVal); 2327 Tcl_ListObjAppendElement(i,pX, 2328 Tcl_NewStringObj((char*)sqlite3_value_text(pVal),n)); 2329 sqlite3ValueFree(pVal); 2330 } 2331 sqlite3EndBenignMalloc(); 2332 2333 Tcl_EvalObjEx(i, pX, 0); 2334 Tcl_DecrRefCount(pX); 2335 Tcl_GetIntFromObj(i, Tcl_GetObjResult(i), &res); 2336 return res; 2337 } 2338 static int test_collate( 2339 void * clientData, 2340 Tcl_Interp *interp, 2341 int objc, 2342 Tcl_Obj *CONST objv[] 2343 ){ 2344 sqlite3 *db; 2345 int val; 2346 sqlite3_value *pVal; 2347 int rc; 2348 2349 if( objc!=5 ) goto bad_args; 2350 pTestCollateInterp = interp; 2351 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 2352 2353 if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[2], &val) ) return TCL_ERROR; 2354 rc = sqlite3_create_collation(db, "test_collate", SQLITE_UTF8, 2355 (void *)SQLITE_UTF8, val?test_collate_func:0); 2356 if( rc==SQLITE_OK ){ 2357 const void *zUtf16; 2358 if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[3], &val) ) return TCL_ERROR; 2359 rc = sqlite3_create_collation(db, "test_collate", SQLITE_UTF16LE, 2360 (void *)SQLITE_UTF16LE, val?test_collate_func:0); 2361 if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[4], &val) ) return TCL_ERROR; 2362 2363 #if 0 2364 if( sqlite3_iMallocFail>0 ){ 2365 sqlite3_iMallocFail++; 2366 } 2367 #endif 2368 sqlite3_mutex_enter(db->mutex); 2369 pVal = sqlite3ValueNew(db); 2370 sqlite3ValueSetStr(pVal, -1, "test_collate", SQLITE_UTF8, SQLITE_STATIC); 2371 zUtf16 = sqlite3ValueText(pVal, SQLITE_UTF16NATIVE); 2372 if( db->mallocFailed ){ 2373 rc = SQLITE_NOMEM; 2374 }else{ 2375 rc = sqlite3_create_collation16(db, zUtf16, SQLITE_UTF16BE, 2376 (void *)SQLITE_UTF16BE, val?test_collate_func:0); 2377 } 2378 sqlite3ValueFree(pVal); 2379 sqlite3_mutex_leave(db->mutex); 2380 } 2381 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 2382 2383 if( rc!=SQLITE_OK ){ 2384 Tcl_AppendResult(interp, sqlite3TestErrorName(rc), 0); 2385 return TCL_ERROR; 2386 } 2387 return TCL_OK; 2388 2389 bad_args: 2390 Tcl_AppendResult(interp, "wrong # args: should be \"", 2391 Tcl_GetStringFromObj(objv[0], 0), " <DB> <utf8> <utf16le> <utf16be>", 0); 2392 return TCL_ERROR; 2393 } 2394 2395 /* 2396 ** When the collation needed callback is invoked, record the name of 2397 ** the requested collating function here. The recorded name is linked 2398 ** to a TCL variable and used to make sure that the requested collation 2399 ** name is correct. 2400 */ 2401 static char zNeededCollation[200]; 2402 static char *pzNeededCollation = zNeededCollation; 2403 2404 2405 /* 2406 ** Called when a collating sequence is needed. Registered using 2407 ** sqlite3_collation_needed16(). 2408 */ 2409 static void test_collate_needed_cb( 2410 void *pCtx, 2411 sqlite3 *db, 2412 int eTextRep, 2413 const void *pName 2414 ){ 2415 int enc = ENC(db); 2416 int i; 2417 char *z; 2418 for(z = (char*)pName, i=0; *z || z[1]; z++){ 2419 if( *z ) zNeededCollation[i++] = *z; 2420 } 2421 zNeededCollation[i] = 0; 2422 sqlite3_create_collation( 2423 db, "test_collate", ENC(db), (void *)enc, test_collate_func); 2424 } 2425 2426 /* 2427 ** Usage: add_test_collate_needed DB 2428 */ 2429 static int test_collate_needed( 2430 void * clientData, 2431 Tcl_Interp *interp, 2432 int objc, 2433 Tcl_Obj *CONST objv[] 2434 ){ 2435 sqlite3 *db; 2436 int rc; 2437 2438 if( objc!=2 ) goto bad_args; 2439 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 2440 rc = sqlite3_collation_needed16(db, 0, test_collate_needed_cb); 2441 zNeededCollation[0] = 0; 2442 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 2443 return TCL_OK; 2444 2445 bad_args: 2446 Tcl_WrongNumArgs(interp, 1, objv, "DB"); 2447 return TCL_ERROR; 2448 } 2449 2450 /* 2451 ** tclcmd: add_alignment_test_collations DB 2452 ** 2453 ** Add two new collating sequences to the database DB 2454 ** 2455 ** utf16_aligned 2456 ** utf16_unaligned 2457 ** 2458 ** Both collating sequences use the same sort order as BINARY. 2459 ** The only difference is that the utf16_aligned collating 2460 ** sequence is declared with the SQLITE_UTF16_ALIGNED flag. 2461 ** Both collating functions increment the unaligned utf16 counter 2462 ** whenever they see a string that begins on an odd byte boundary. 2463 */ 2464 static int unaligned_string_counter = 0; 2465 static int alignmentCollFunc( 2466 void *NotUsed, 2467 int nKey1, const void *pKey1, 2468 int nKey2, const void *pKey2 2469 ){ 2470 int rc, n; 2471 n = nKey1<nKey2 ? nKey1 : nKey2; 2472 if( nKey1>0 && 1==(1&(int)pKey1) ) unaligned_string_counter++; 2473 if( nKey2>0 && 1==(1&(int)pKey2) ) unaligned_string_counter++; 2474 rc = memcmp(pKey1, pKey2, n); 2475 if( rc==0 ){ 2476 rc = nKey1 - nKey2; 2477 } 2478 return rc; 2479 } 2480 static int add_alignment_test_collations( 2481 void * clientData, 2482 Tcl_Interp *interp, 2483 int objc, 2484 Tcl_Obj *CONST objv[] 2485 ){ 2486 sqlite3 *db; 2487 if( objc>=2 ){ 2488 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 2489 sqlite3_create_collation(db, "utf16_unaligned", SQLITE_UTF16, 2490 0, alignmentCollFunc); 2491 sqlite3_create_collation(db, "utf16_aligned", SQLITE_UTF16_ALIGNED, 2492 0, alignmentCollFunc); 2493 } 2494 return SQLITE_OK; 2495 } 2496 #endif /* !defined(SQLITE_OMIT_UTF16) */ 2497 2498 /* 2499 ** Usage: add_test_function <db ptr> <utf8> <utf16le> <utf16be> 2500 ** 2501 ** This function is used to test that SQLite selects the correct user 2502 ** function callback when multiple versions (for different text encodings) 2503 ** are available. 2504 ** 2505 ** Calling this routine registers up to three versions of the user function 2506 ** "test_function" with database handle <db>. If the second argument is 2507 ** true, then a version of test_function is registered for UTF-8, if the 2508 ** third is true, a version is registered for UTF-16le, if the fourth is 2509 ** true, a UTF-16be version is available. Previous versions of 2510 ** test_function are deleted. 2511 ** 2512 ** The user function is implemented by calling the following TCL script: 2513 ** 2514 ** "test_function <enc> <arg>" 2515 ** 2516 ** Where <enc> is one of UTF-8, UTF-16LE or UTF16BE, and <arg> is the 2517 ** single argument passed to the SQL function. The value returned by 2518 ** the TCL script is used as the return value of the SQL function. It 2519 ** is passed to SQLite using UTF-16BE for a UTF-8 test_function(), UTF-8 2520 ** for a UTF-16LE test_function(), and UTF-16LE for an implementation that 2521 ** prefers UTF-16BE. 2522 */ 2523 #ifndef SQLITE_OMIT_UTF16 2524 static void test_function_utf8( 2525 sqlite3_context *pCtx, 2526 int nArg, 2527 sqlite3_value **argv 2528 ){ 2529 Tcl_Interp *interp; 2530 Tcl_Obj *pX; 2531 sqlite3_value *pVal; 2532 interp = (Tcl_Interp *)sqlite3_user_data(pCtx); 2533 pX = Tcl_NewStringObj("test_function", -1); 2534 Tcl_IncrRefCount(pX); 2535 Tcl_ListObjAppendElement(interp, pX, Tcl_NewStringObj("UTF-8", -1)); 2536 Tcl_ListObjAppendElement(interp, pX, 2537 Tcl_NewStringObj((char*)sqlite3_value_text(argv[0]), -1)); 2538 Tcl_EvalObjEx(interp, pX, 0); 2539 Tcl_DecrRefCount(pX); 2540 sqlite3_result_text(pCtx, Tcl_GetStringResult(interp), -1, SQLITE_TRANSIENT); 2541 pVal = sqlite3ValueNew(0); 2542 sqlite3ValueSetStr(pVal, -1, Tcl_GetStringResult(interp), 2543 SQLITE_UTF8, SQLITE_STATIC); 2544 sqlite3_result_text16be(pCtx, sqlite3_value_text16be(pVal), 2545 -1, SQLITE_TRANSIENT); 2546 sqlite3ValueFree(pVal); 2547 } 2548 static void test_function_utf16le( 2549 sqlite3_context *pCtx, 2550 int nArg, 2551 sqlite3_value **argv 2552 ){ 2553 Tcl_Interp *interp; 2554 Tcl_Obj *pX; 2555 sqlite3_value *pVal; 2556 interp = (Tcl_Interp *)sqlite3_user_data(pCtx); 2557 pX = Tcl_NewStringObj("test_function", -1); 2558 Tcl_IncrRefCount(pX); 2559 Tcl_ListObjAppendElement(interp, pX, Tcl_NewStringObj("UTF-16LE", -1)); 2560 Tcl_ListObjAppendElement(interp, pX, 2561 Tcl_NewStringObj((char*)sqlite3_value_text(argv[0]), -1)); 2562 Tcl_EvalObjEx(interp, pX, 0); 2563 Tcl_DecrRefCount(pX); 2564 pVal = sqlite3ValueNew(0); 2565 sqlite3ValueSetStr(pVal, -1, Tcl_GetStringResult(interp), 2566 SQLITE_UTF8, SQLITE_STATIC); 2567 sqlite3_result_text(pCtx,(char*)sqlite3_value_text(pVal),-1,SQLITE_TRANSIENT); 2568 sqlite3ValueFree(pVal); 2569 } 2570 static void test_function_utf16be( 2571 sqlite3_context *pCtx, 2572 int nArg, 2573 sqlite3_value **argv 2574 ){ 2575 Tcl_Interp *interp; 2576 Tcl_Obj *pX; 2577 sqlite3_value *pVal; 2578 interp = (Tcl_Interp *)sqlite3_user_data(pCtx); 2579 pX = Tcl_NewStringObj("test_function", -1); 2580 Tcl_IncrRefCount(pX); 2581 Tcl_ListObjAppendElement(interp, pX, Tcl_NewStringObj("UTF-16BE", -1)); 2582 Tcl_ListObjAppendElement(interp, pX, 2583 Tcl_NewStringObj((char*)sqlite3_value_text(argv[0]), -1)); 2584 Tcl_EvalObjEx(interp, pX, 0); 2585 Tcl_DecrRefCount(pX); 2586 pVal = sqlite3ValueNew(0); 2587 sqlite3ValueSetStr(pVal, -1, Tcl_GetStringResult(interp), 2588 SQLITE_UTF8, SQLITE_STATIC); 2589 sqlite3_result_text16(pCtx, sqlite3_value_text16le(pVal), 2590 -1, SQLITE_TRANSIENT); 2591 sqlite3_result_text16be(pCtx, sqlite3_value_text16le(pVal), 2592 -1, SQLITE_TRANSIENT); 2593 sqlite3_result_text16le(pCtx, sqlite3_value_text16le(pVal), 2594 -1, SQLITE_TRANSIENT); 2595 sqlite3ValueFree(pVal); 2596 } 2597 #endif /* SQLITE_OMIT_UTF16 */ 2598 static int test_function( 2599 void * clientData, 2600 Tcl_Interp *interp, 2601 int objc, 2602 Tcl_Obj *CONST objv[] 2603 ){ 2604 #ifndef SQLITE_OMIT_UTF16 2605 sqlite3 *db; 2606 int val; 2607 2608 if( objc!=5 ) goto bad_args; 2609 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 2610 2611 if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[2], &val) ) return TCL_ERROR; 2612 if( val ){ 2613 sqlite3_create_function(db, "test_function", 1, SQLITE_UTF8, 2614 interp, test_function_utf8, 0, 0); 2615 } 2616 if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[3], &val) ) return TCL_ERROR; 2617 if( val ){ 2618 sqlite3_create_function(db, "test_function", 1, SQLITE_UTF16LE, 2619 interp, test_function_utf16le, 0, 0); 2620 } 2621 if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[4], &val) ) return TCL_ERROR; 2622 if( val ){ 2623 sqlite3_create_function(db, "test_function", 1, SQLITE_UTF16BE, 2624 interp, test_function_utf16be, 0, 0); 2625 } 2626 2627 return TCL_OK; 2628 bad_args: 2629 Tcl_AppendResult(interp, "wrong # args: should be \"", 2630 Tcl_GetStringFromObj(objv[0], 0), " <DB> <utf8> <utf16le> <utf16be>", 0); 2631 #endif /* SQLITE_OMIT_UTF16 */ 2632 return TCL_ERROR; 2633 } 2634 2635 /* 2636 ** Usage: sqlite3_test_errstr <err code> 2637 ** 2638 ** Test that the english language string equivalents for sqlite error codes 2639 ** are sane. The parameter is an integer representing an sqlite error code. 2640 ** The result is a list of two elements, the string representation of the 2641 ** error code and the english language explanation. 2642 */ 2643 static int test_errstr( 2644 void * clientData, 2645 Tcl_Interp *interp, 2646 int objc, 2647 Tcl_Obj *CONST objv[] 2648 ){ 2649 char *zCode; 2650 int i; 2651 if( objc!=1 ){ 2652 Tcl_WrongNumArgs(interp, 1, objv, "<error code>"); 2653 } 2654 2655 zCode = Tcl_GetString(objv[1]); 2656 for(i=0; i<200; i++){ 2657 if( 0==strcmp(t1ErrorName(i), zCode) ) break; 2658 } 2659 Tcl_SetResult(interp, (char *)sqlite3ErrStr(i), 0); 2660 return TCL_OK; 2661 } 2662 2663 /* 2664 ** Usage: breakpoint 2665 ** 2666 ** This routine exists for one purpose - to provide a place to put a 2667 ** breakpoint with GDB that can be triggered using TCL code. The use 2668 ** for this is when a particular test fails on (say) the 1485th iteration. 2669 ** In the TCL test script, we can add code like this: 2670 ** 2671 ** if {$i==1485} breakpoint 2672 ** 2673 ** Then run testfixture in the debugger and wait for the breakpoint to 2674 ** fire. Then additional breakpoints can be set to trace down the bug. 2675 */ 2676 static int test_breakpoint( 2677 void *NotUsed, 2678 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 2679 int argc, /* Number of arguments */ 2680 char **argv /* Text of each argument */ 2681 ){ 2682 return TCL_OK; /* Do nothing */ 2683 } 2684 2685 /* 2686 ** Usage: sqlite3_bind_zeroblob STMT IDX N 2687 ** 2688 ** Test the sqlite3_bind_zeroblob interface. STMT is a prepared statement. 2689 ** IDX is the index of a wildcard in the prepared statement. This command 2690 ** binds a N-byte zero-filled BLOB to the wildcard. 2691 */ 2692 static int test_bind_zeroblob( 2693 void * clientData, 2694 Tcl_Interp *interp, 2695 int objc, 2696 Tcl_Obj *CONST objv[] 2697 ){ 2698 sqlite3_stmt *pStmt; 2699 int idx; 2700 int n; 2701 int rc; 2702 2703 if( objc!=4 ){ 2704 Tcl_WrongNumArgs(interp, 1, objv, "STMT IDX N"); 2705 return TCL_ERROR; 2706 } 2707 2708 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 2709 if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; 2710 if( Tcl_GetIntFromObj(interp, objv[3], &n) ) return TCL_ERROR; 2711 2712 rc = sqlite3_bind_zeroblob(pStmt, idx, n); 2713 if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; 2714 if( rc!=SQLITE_OK ){ 2715 return TCL_ERROR; 2716 } 2717 2718 return TCL_OK; 2719 } 2720 2721 /* 2722 ** Usage: sqlite3_bind_int STMT N VALUE 2723 ** 2724 ** Test the sqlite3_bind_int interface. STMT is a prepared statement. 2725 ** N is the index of a wildcard in the prepared statement. This command 2726 ** binds a 32-bit integer VALUE to that wildcard. 2727 */ 2728 static int test_bind_int( 2729 void * clientData, 2730 Tcl_Interp *interp, 2731 int objc, 2732 Tcl_Obj *CONST objv[] 2733 ){ 2734 sqlite3_stmt *pStmt; 2735 int idx; 2736 int value; 2737 int rc; 2738 2739 if( objc!=4 ){ 2740 Tcl_AppendResult(interp, "wrong # args: should be \"", 2741 Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE", 0); 2742 return TCL_ERROR; 2743 } 2744 2745 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 2746 if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; 2747 if( Tcl_GetIntFromObj(interp, objv[3], &value) ) return TCL_ERROR; 2748 2749 rc = sqlite3_bind_int(pStmt, idx, value); 2750 if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; 2751 if( rc!=SQLITE_OK ){ 2752 return TCL_ERROR; 2753 } 2754 2755 return TCL_OK; 2756 } 2757 2758 2759 /* 2760 ** Usage: sqlite3_bind_int64 STMT N VALUE 2761 ** 2762 ** Test the sqlite3_bind_int64 interface. STMT is a prepared statement. 2763 ** N is the index of a wildcard in the prepared statement. This command 2764 ** binds a 64-bit integer VALUE to that wildcard. 2765 */ 2766 static int test_bind_int64( 2767 void * clientData, 2768 Tcl_Interp *interp, 2769 int objc, 2770 Tcl_Obj *CONST objv[] 2771 ){ 2772 sqlite3_stmt *pStmt; 2773 int idx; 2774 i64 value; 2775 int rc; 2776 2777 if( objc!=4 ){ 2778 Tcl_AppendResult(interp, "wrong # args: should be \"", 2779 Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE", 0); 2780 return TCL_ERROR; 2781 } 2782 2783 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 2784 if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; 2785 if( Tcl_GetWideIntFromObj(interp, objv[3], &value) ) return TCL_ERROR; 2786 2787 rc = sqlite3_bind_int64(pStmt, idx, value); 2788 if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; 2789 if( rc!=SQLITE_OK ){ 2790 return TCL_ERROR; 2791 } 2792 2793 return TCL_OK; 2794 } 2795 2796 2797 /* 2798 ** Usage: sqlite3_bind_double STMT N VALUE 2799 ** 2800 ** Test the sqlite3_bind_double interface. STMT is a prepared statement. 2801 ** N is the index of a wildcard in the prepared statement. This command 2802 ** binds a 64-bit integer VALUE to that wildcard. 2803 */ 2804 static int test_bind_double( 2805 void * clientData, 2806 Tcl_Interp *interp, 2807 int objc, 2808 Tcl_Obj *CONST objv[] 2809 ){ 2810 sqlite3_stmt *pStmt; 2811 int idx; 2812 double value; 2813 int rc; 2814 const char *zVal; 2815 int i; 2816 static const struct { 2817 const char *zName; /* Name of the special floating point value */ 2818 unsigned int iUpper; /* Upper 32 bits */ 2819 unsigned int iLower; /* Lower 32 bits */ 2820 } aSpecialFp[] = { 2821 { "NaN", 0x7fffffff, 0xffffffff }, 2822 { "SNaN", 0x7ff7ffff, 0xffffffff }, 2823 { "-NaN", 0xffffffff, 0xffffffff }, 2824 { "-SNaN", 0xfff7ffff, 0xffffffff }, 2825 { "+Inf", 0x7ff00000, 0x00000000 }, 2826 { "-Inf", 0xfff00000, 0x00000000 }, 2827 { "Epsilon", 0x00000000, 0x00000001 }, 2828 { "-Epsilon", 0x80000000, 0x00000001 }, 2829 { "NaN0", 0x7ff80000, 0x00000000 }, 2830 { "-NaN0", 0xfff80000, 0x00000000 }, 2831 }; 2832 2833 if( objc!=4 ){ 2834 Tcl_AppendResult(interp, "wrong # args: should be \"", 2835 Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE", 0); 2836 return TCL_ERROR; 2837 } 2838 2839 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 2840 if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; 2841 2842 /* Intercept the string "NaN" and generate a NaN value for it. 2843 ** All other strings are passed through to Tcl_GetDoubleFromObj(). 2844 ** Tcl_GetDoubleFromObj() should understand "NaN" but some versions 2845 ** contain a bug. 2846 */ 2847 zVal = Tcl_GetString(objv[3]); 2848 for(i=0; i<sizeof(aSpecialFp)/sizeof(aSpecialFp[0]); i++){ 2849 if( strcmp(aSpecialFp[i].zName, zVal)==0 ){ 2850 sqlite3_uint64 x; 2851 x = aSpecialFp[i].iUpper; 2852 x <<= 32; 2853 x |= aSpecialFp[i].iLower; 2854 assert( sizeof(value)==8 ); 2855 assert( sizeof(x)==8 ); 2856 memcpy(&value, &x, 8); 2857 break; 2858 } 2859 } 2860 if( i>=sizeof(aSpecialFp)/sizeof(aSpecialFp[0]) && 2861 Tcl_GetDoubleFromObj(interp, objv[3], &value) ){ 2862 return TCL_ERROR; 2863 } 2864 rc = sqlite3_bind_double(pStmt, idx, value); 2865 if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; 2866 if( rc!=SQLITE_OK ){ 2867 return TCL_ERROR; 2868 } 2869 2870 return TCL_OK; 2871 } 2872 2873 /* 2874 ** Usage: sqlite3_bind_null STMT N 2875 ** 2876 ** Test the sqlite3_bind_null interface. STMT is a prepared statement. 2877 ** N is the index of a wildcard in the prepared statement. This command 2878 ** binds a NULL to the wildcard. 2879 */ 2880 static int test_bind_null( 2881 void * clientData, 2882 Tcl_Interp *interp, 2883 int objc, 2884 Tcl_Obj *CONST objv[] 2885 ){ 2886 sqlite3_stmt *pStmt; 2887 int idx; 2888 int rc; 2889 2890 if( objc!=3 ){ 2891 Tcl_AppendResult(interp, "wrong # args: should be \"", 2892 Tcl_GetStringFromObj(objv[0], 0), " STMT N", 0); 2893 return TCL_ERROR; 2894 } 2895 2896 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 2897 if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; 2898 2899 rc = sqlite3_bind_null(pStmt, idx); 2900 if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; 2901 if( rc!=SQLITE_OK ){ 2902 return TCL_ERROR; 2903 } 2904 2905 return TCL_OK; 2906 } 2907 2908 /* 2909 ** Usage: sqlite3_bind_text STMT N STRING BYTES 2910 ** 2911 ** Test the sqlite3_bind_text interface. STMT is a prepared statement. 2912 ** N is the index of a wildcard in the prepared statement. This command 2913 ** binds a UTF-8 string STRING to the wildcard. The string is BYTES bytes 2914 ** long. 2915 */ 2916 static int test_bind_text( 2917 void * clientData, 2918 Tcl_Interp *interp, 2919 int objc, 2920 Tcl_Obj *CONST objv[] 2921 ){ 2922 sqlite3_stmt *pStmt; 2923 int idx; 2924 int bytes; 2925 char *value; 2926 int rc; 2927 2928 if( objc!=5 ){ 2929 Tcl_AppendResult(interp, "wrong # args: should be \"", 2930 Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE BYTES", 0); 2931 return TCL_ERROR; 2932 } 2933 2934 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 2935 if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; 2936 value = (char*)Tcl_GetByteArrayFromObj(objv[3], &bytes); 2937 if( Tcl_GetIntFromObj(interp, objv[4], &bytes) ) return TCL_ERROR; 2938 2939 rc = sqlite3_bind_text(pStmt, idx, value, bytes, SQLITE_TRANSIENT); 2940 if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; 2941 if( rc!=SQLITE_OK ){ 2942 Tcl_AppendResult(interp, sqlite3TestErrorName(rc), 0); 2943 return TCL_ERROR; 2944 } 2945 2946 return TCL_OK; 2947 } 2948 2949 /* 2950 ** Usage: sqlite3_bind_text16 ?-static? STMT N STRING BYTES 2951 ** 2952 ** Test the sqlite3_bind_text16 interface. STMT is a prepared statement. 2953 ** N is the index of a wildcard in the prepared statement. This command 2954 ** binds a UTF-16 string STRING to the wildcard. The string is BYTES bytes 2955 ** long. 2956 */ 2957 static int test_bind_text16( 2958 void * clientData, 2959 Tcl_Interp *interp, 2960 int objc, 2961 Tcl_Obj *CONST objv[] 2962 ){ 2963 #ifndef SQLITE_OMIT_UTF16 2964 sqlite3_stmt *pStmt; 2965 int idx; 2966 int bytes; 2967 char *value; 2968 int rc; 2969 2970 void (*xDel)() = (objc==6?SQLITE_STATIC:SQLITE_TRANSIENT); 2971 Tcl_Obj *oStmt = objv[objc-4]; 2972 Tcl_Obj *oN = objv[objc-3]; 2973 Tcl_Obj *oString = objv[objc-2]; 2974 Tcl_Obj *oBytes = objv[objc-1]; 2975 2976 if( objc!=5 && objc!=6){ 2977 Tcl_AppendResult(interp, "wrong # args: should be \"", 2978 Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE BYTES", 0); 2979 return TCL_ERROR; 2980 } 2981 2982 if( getStmtPointer(interp, Tcl_GetString(oStmt), &pStmt) ) return TCL_ERROR; 2983 if( Tcl_GetIntFromObj(interp, oN, &idx) ) return TCL_ERROR; 2984 value = (char*)Tcl_GetByteArrayFromObj(oString, 0); 2985 if( Tcl_GetIntFromObj(interp, oBytes, &bytes) ) return TCL_ERROR; 2986 2987 rc = sqlite3_bind_text16(pStmt, idx, (void *)value, bytes, xDel); 2988 if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; 2989 if( rc!=SQLITE_OK ){ 2990 Tcl_AppendResult(interp, sqlite3TestErrorName(rc), 0); 2991 return TCL_ERROR; 2992 } 2993 2994 #endif /* SQLITE_OMIT_UTF16 */ 2995 return TCL_OK; 2996 } 2997 2998 /* 2999 ** Usage: sqlite3_bind_blob ?-static? STMT N DATA BYTES 3000 ** 3001 ** Test the sqlite3_bind_blob interface. STMT is a prepared statement. 3002 ** N is the index of a wildcard in the prepared statement. This command 3003 ** binds a BLOB to the wildcard. The BLOB is BYTES bytes in size. 3004 */ 3005 static int test_bind_blob( 3006 void * clientData, 3007 Tcl_Interp *interp, 3008 int objc, 3009 Tcl_Obj *CONST objv[] 3010 ){ 3011 sqlite3_stmt *pStmt; 3012 int idx; 3013 int bytes; 3014 char *value; 3015 int rc; 3016 sqlite3_destructor_type xDestructor = SQLITE_TRANSIENT; 3017 3018 if( objc!=5 && objc!=6 ){ 3019 Tcl_AppendResult(interp, "wrong # args: should be \"", 3020 Tcl_GetStringFromObj(objv[0], 0), " STMT N DATA BYTES", 0); 3021 return TCL_ERROR; 3022 } 3023 3024 if( objc==6 ){ 3025 xDestructor = SQLITE_STATIC; 3026 objv++; 3027 } 3028 3029 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3030 if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; 3031 value = Tcl_GetString(objv[3]); 3032 if( Tcl_GetIntFromObj(interp, objv[4], &bytes) ) return TCL_ERROR; 3033 3034 rc = sqlite3_bind_blob(pStmt, idx, value, bytes, xDestructor); 3035 if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; 3036 if( rc!=SQLITE_OK ){ 3037 return TCL_ERROR; 3038 } 3039 3040 return TCL_OK; 3041 } 3042 3043 /* 3044 ** Usage: sqlite3_bind_parameter_count STMT 3045 ** 3046 ** Return the number of wildcards in the given statement. 3047 */ 3048 static int test_bind_parameter_count( 3049 void * clientData, 3050 Tcl_Interp *interp, 3051 int objc, 3052 Tcl_Obj *CONST objv[] 3053 ){ 3054 sqlite3_stmt *pStmt; 3055 3056 if( objc!=2 ){ 3057 Tcl_WrongNumArgs(interp, 1, objv, "STMT"); 3058 return TCL_ERROR; 3059 } 3060 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3061 Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_bind_parameter_count(pStmt))); 3062 return TCL_OK; 3063 } 3064 3065 /* 3066 ** Usage: sqlite3_bind_parameter_name STMT N 3067 ** 3068 ** Return the name of the Nth wildcard. The first wildcard is 1. 3069 ** An empty string is returned if N is out of range or if the wildcard 3070 ** is nameless. 3071 */ 3072 static int test_bind_parameter_name( 3073 void * clientData, 3074 Tcl_Interp *interp, 3075 int objc, 3076 Tcl_Obj *CONST objv[] 3077 ){ 3078 sqlite3_stmt *pStmt; 3079 int i; 3080 3081 if( objc!=3 ){ 3082 Tcl_WrongNumArgs(interp, 1, objv, "STMT N"); 3083 return TCL_ERROR; 3084 } 3085 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3086 if( Tcl_GetIntFromObj(interp, objv[2], &i) ) return TCL_ERROR; 3087 Tcl_SetObjResult(interp, 3088 Tcl_NewStringObj(sqlite3_bind_parameter_name(pStmt,i),-1) 3089 ); 3090 return TCL_OK; 3091 } 3092 3093 /* 3094 ** Usage: sqlite3_bind_parameter_index STMT NAME 3095 ** 3096 ** Return the index of the wildcard called NAME. Return 0 if there is 3097 ** no such wildcard. 3098 */ 3099 static int test_bind_parameter_index( 3100 void * clientData, 3101 Tcl_Interp *interp, 3102 int objc, 3103 Tcl_Obj *CONST objv[] 3104 ){ 3105 sqlite3_stmt *pStmt; 3106 3107 if( objc!=3 ){ 3108 Tcl_WrongNumArgs(interp, 1, objv, "STMT NAME"); 3109 return TCL_ERROR; 3110 } 3111 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3112 Tcl_SetObjResult(interp, 3113 Tcl_NewIntObj( 3114 sqlite3_bind_parameter_index(pStmt,Tcl_GetString(objv[2])) 3115 ) 3116 ); 3117 return TCL_OK; 3118 } 3119 3120 /* 3121 ** Usage: sqlite3_clear_bindings STMT 3122 ** 3123 */ 3124 static int test_clear_bindings( 3125 void * clientData, 3126 Tcl_Interp *interp, 3127 int objc, 3128 Tcl_Obj *CONST objv[] 3129 ){ 3130 sqlite3_stmt *pStmt; 3131 3132 if( objc!=2 ){ 3133 Tcl_WrongNumArgs(interp, 1, objv, "STMT"); 3134 return TCL_ERROR; 3135 } 3136 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3137 Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_clear_bindings(pStmt))); 3138 return TCL_OK; 3139 } 3140 3141 /* 3142 ** Usage: sqlite3_sleep MILLISECONDS 3143 */ 3144 static int test_sleep( 3145 void * clientData, 3146 Tcl_Interp *interp, 3147 int objc, 3148 Tcl_Obj *CONST objv[] 3149 ){ 3150 int ms; 3151 3152 if( objc!=2 ){ 3153 Tcl_WrongNumArgs(interp, 1, objv, "MILLISECONDS"); 3154 return TCL_ERROR; 3155 } 3156 if( Tcl_GetIntFromObj(interp, objv[1], &ms) ){ 3157 return TCL_ERROR; 3158 } 3159 Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_sleep(ms))); 3160 return TCL_OK; 3161 } 3162 3163 /* 3164 ** Usage: sqlite3_extended_errcode DB 3165 ** 3166 ** Return the string representation of the most recent sqlite3_* API 3167 ** error code. e.g. "SQLITE_ERROR". 3168 */ 3169 static int test_ex_errcode( 3170 void * clientData, 3171 Tcl_Interp *interp, 3172 int objc, 3173 Tcl_Obj *CONST objv[] 3174 ){ 3175 sqlite3 *db; 3176 int rc; 3177 3178 if( objc!=2 ){ 3179 Tcl_AppendResult(interp, "wrong # args: should be \"", 3180 Tcl_GetString(objv[0]), " DB", 0); 3181 return TCL_ERROR; 3182 } 3183 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 3184 rc = sqlite3_extended_errcode(db); 3185 Tcl_AppendResult(interp, (char *)t1ErrorName(rc), 0); 3186 return TCL_OK; 3187 } 3188 3189 3190 /* 3191 ** Usage: sqlite3_errcode DB 3192 ** 3193 ** Return the string representation of the most recent sqlite3_* API 3194 ** error code. e.g. "SQLITE_ERROR". 3195 */ 3196 static int test_errcode( 3197 void * clientData, 3198 Tcl_Interp *interp, 3199 int objc, 3200 Tcl_Obj *CONST objv[] 3201 ){ 3202 sqlite3 *db; 3203 int rc; 3204 3205 if( objc!=2 ){ 3206 Tcl_AppendResult(interp, "wrong # args: should be \"", 3207 Tcl_GetString(objv[0]), " DB", 0); 3208 return TCL_ERROR; 3209 } 3210 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 3211 rc = sqlite3_errcode(db); 3212 Tcl_AppendResult(interp, (char *)t1ErrorName(rc), 0); 3213 return TCL_OK; 3214 } 3215 3216 /* 3217 ** Usage: sqlite3_errmsg DB 3218 ** 3219 ** Returns the UTF-8 representation of the error message string for the 3220 ** most recent sqlite3_* API call. 3221 */ 3222 static int test_errmsg( 3223 void * clientData, 3224 Tcl_Interp *interp, 3225 int objc, 3226 Tcl_Obj *CONST objv[] 3227 ){ 3228 sqlite3 *db; 3229 const char *zErr; 3230 3231 if( objc!=2 ){ 3232 Tcl_AppendResult(interp, "wrong # args: should be \"", 3233 Tcl_GetString(objv[0]), " DB", 0); 3234 return TCL_ERROR; 3235 } 3236 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 3237 3238 zErr = sqlite3_errmsg(db); 3239 Tcl_SetObjResult(interp, Tcl_NewStringObj(zErr, -1)); 3240 return TCL_OK; 3241 } 3242 3243 /* 3244 ** Usage: test_errmsg16 DB 3245 ** 3246 ** Returns the UTF-16 representation of the error message string for the 3247 ** most recent sqlite3_* API call. This is a byte array object at the TCL 3248 ** level, and it includes the 0x00 0x00 terminator bytes at the end of the 3249 ** UTF-16 string. 3250 */ 3251 static int test_errmsg16( 3252 void * clientData, 3253 Tcl_Interp *interp, 3254 int objc, 3255 Tcl_Obj *CONST objv[] 3256 ){ 3257 #ifndef SQLITE_OMIT_UTF16 3258 sqlite3 *db; 3259 const void *zErr; 3260 const char *z; 3261 int bytes = 0; 3262 3263 if( objc!=2 ){ 3264 Tcl_AppendResult(interp, "wrong # args: should be \"", 3265 Tcl_GetString(objv[0]), " DB", 0); 3266 return TCL_ERROR; 3267 } 3268 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 3269 3270 zErr = sqlite3_errmsg16(db); 3271 if( zErr ){ 3272 z = zErr; 3273 for(bytes=0; z[bytes] || z[bytes+1]; bytes+=2){} 3274 } 3275 Tcl_SetObjResult(interp, Tcl_NewByteArrayObj(zErr, bytes)); 3276 #endif /* SQLITE_OMIT_UTF16 */ 3277 return TCL_OK; 3278 } 3279 3280 /* 3281 ** Usage: sqlite3_prepare DB sql bytes ?tailvar? 3282 ** 3283 ** Compile up to <bytes> bytes of the supplied SQL string <sql> using 3284 ** database handle <DB>. The parameter <tailval> is the name of a global 3285 ** variable that is set to the unused portion of <sql> (if any). A 3286 ** STMT handle is returned. 3287 */ 3288 static int test_prepare( 3289 void * clientData, 3290 Tcl_Interp *interp, 3291 int objc, 3292 Tcl_Obj *CONST objv[] 3293 ){ 3294 sqlite3 *db; 3295 const char *zSql; 3296 int bytes; 3297 const char *zTail = 0; 3298 sqlite3_stmt *pStmt = 0; 3299 char zBuf[50]; 3300 int rc; 3301 3302 if( objc!=5 && objc!=4 ){ 3303 Tcl_AppendResult(interp, "wrong # args: should be \"", 3304 Tcl_GetString(objv[0]), " DB sql bytes ?tailvar?", 0); 3305 return TCL_ERROR; 3306 } 3307 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 3308 zSql = Tcl_GetString(objv[2]); 3309 if( Tcl_GetIntFromObj(interp, objv[3], &bytes) ) return TCL_ERROR; 3310 3311 rc = sqlite3_prepare(db, zSql, bytes, &pStmt, objc>=5 ? &zTail : 0); 3312 Tcl_ResetResult(interp); 3313 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 3314 if( zTail && objc>=5 ){ 3315 if( bytes>=0 ){ 3316 bytes = bytes - (zTail-zSql); 3317 } 3318 if( strlen(zTail)<bytes ){ 3319 bytes = strlen(zTail); 3320 } 3321 Tcl_ObjSetVar2(interp, objv[4], 0, Tcl_NewStringObj(zTail, bytes), 0); 3322 } 3323 if( rc!=SQLITE_OK ){ 3324 assert( pStmt==0 ); 3325 sprintf(zBuf, "(%d) ", rc); 3326 Tcl_AppendResult(interp, zBuf, sqlite3_errmsg(db), 0); 3327 return TCL_ERROR; 3328 } 3329 3330 if( pStmt ){ 3331 if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; 3332 Tcl_AppendResult(interp, zBuf, 0); 3333 } 3334 return TCL_OK; 3335 } 3336 3337 /* 3338 ** Usage: sqlite3_prepare_v2 DB sql bytes ?tailvar? 3339 ** 3340 ** Compile up to <bytes> bytes of the supplied SQL string <sql> using 3341 ** database handle <DB>. The parameter <tailval> is the name of a global 3342 ** variable that is set to the unused portion of <sql> (if any). A 3343 ** STMT handle is returned. 3344 */ 3345 static int test_prepare_v2( 3346 void * clientData, 3347 Tcl_Interp *interp, 3348 int objc, 3349 Tcl_Obj *CONST objv[] 3350 ){ 3351 sqlite3 *db; 3352 const char *zSql; 3353 int bytes; 3354 const char *zTail = 0; 3355 sqlite3_stmt *pStmt = 0; 3356 char zBuf[50]; 3357 int rc; 3358 3359 if( objc!=5 && objc!=4 ){ 3360 Tcl_AppendResult(interp, "wrong # args: should be \"", 3361 Tcl_GetString(objv[0]), " DB sql bytes tailvar", 0); 3362 return TCL_ERROR; 3363 } 3364 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 3365 zSql = Tcl_GetString(objv[2]); 3366 if( Tcl_GetIntFromObj(interp, objv[3], &bytes) ) return TCL_ERROR; 3367 3368 rc = sqlite3_prepare_v2(db, zSql, bytes, &pStmt, objc>=5 ? &zTail : 0); 3369 assert(rc==SQLITE_OK || pStmt==0); 3370 Tcl_ResetResult(interp); 3371 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 3372 if( zTail && objc>=5 ){ 3373 if( bytes>=0 ){ 3374 bytes = bytes - (zTail-zSql); 3375 } 3376 Tcl_ObjSetVar2(interp, objv[4], 0, Tcl_NewStringObj(zTail, bytes), 0); 3377 } 3378 if( rc!=SQLITE_OK ){ 3379 assert( pStmt==0 ); 3380 sprintf(zBuf, "(%d) ", rc); 3381 Tcl_AppendResult(interp, zBuf, sqlite3_errmsg(db), 0); 3382 return TCL_ERROR; 3383 } 3384 3385 if( pStmt ){ 3386 if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; 3387 Tcl_AppendResult(interp, zBuf, 0); 3388 } 3389 return TCL_OK; 3390 } 3391 3392 /* 3393 ** Usage: sqlite3_prepare_tkt3134 DB 3394 ** 3395 ** Generate a prepared statement for a zero-byte string as a test 3396 ** for ticket #3134. The string should be preceeded by a zero byte. 3397 */ 3398 static int test_prepare_tkt3134( 3399 void * clientData, 3400 Tcl_Interp *interp, 3401 int objc, 3402 Tcl_Obj *CONST objv[] 3403 ){ 3404 sqlite3 *db; 3405 static const char zSql[] = "\000SELECT 1"; 3406 sqlite3_stmt *pStmt = 0; 3407 char zBuf[50]; 3408 int rc; 3409 3410 if( objc!=2 ){ 3411 Tcl_AppendResult(interp, "wrong # args: should be \"", 3412 Tcl_GetString(objv[0]), " DB sql bytes tailvar", 0); 3413 return TCL_ERROR; 3414 } 3415 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 3416 rc = sqlite3_prepare_v2(db, &zSql[1], 0, &pStmt, 0); 3417 assert(rc==SQLITE_OK || pStmt==0); 3418 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 3419 if( rc!=SQLITE_OK ){ 3420 assert( pStmt==0 ); 3421 sprintf(zBuf, "(%d) ", rc); 3422 Tcl_AppendResult(interp, zBuf, sqlite3_errmsg(db), 0); 3423 return TCL_ERROR; 3424 } 3425 3426 if( pStmt ){ 3427 if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; 3428 Tcl_AppendResult(interp, zBuf, 0); 3429 } 3430 return TCL_OK; 3431 } 3432 3433 /* 3434 ** Usage: sqlite3_prepare16 DB sql bytes tailvar 3435 ** 3436 ** Compile up to <bytes> bytes of the supplied SQL string <sql> using 3437 ** database handle <DB>. The parameter <tailval> is the name of a global 3438 ** variable that is set to the unused portion of <sql> (if any). A 3439 ** STMT handle is returned. 3440 */ 3441 static int test_prepare16( 3442 void * clientData, 3443 Tcl_Interp *interp, 3444 int objc, 3445 Tcl_Obj *CONST objv[] 3446 ){ 3447 #ifndef SQLITE_OMIT_UTF16 3448 sqlite3 *db; 3449 const void *zSql; 3450 const void *zTail = 0; 3451 Tcl_Obj *pTail = 0; 3452 sqlite3_stmt *pStmt = 0; 3453 char zBuf[50]; 3454 int rc; 3455 int bytes; /* The integer specified as arg 3 */ 3456 int objlen; /* The byte-array length of arg 2 */ 3457 3458 if( objc!=5 && objc!=4 ){ 3459 Tcl_AppendResult(interp, "wrong # args: should be \"", 3460 Tcl_GetString(objv[0]), " DB sql bytes ?tailvar?", 0); 3461 return TCL_ERROR; 3462 } 3463 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 3464 zSql = Tcl_GetByteArrayFromObj(objv[2], &objlen); 3465 if( Tcl_GetIntFromObj(interp, objv[3], &bytes) ) return TCL_ERROR; 3466 3467 rc = sqlite3_prepare16(db, zSql, bytes, &pStmt, objc>=5 ? &zTail : 0); 3468 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 3469 if( rc ){ 3470 return TCL_ERROR; 3471 } 3472 3473 if( objc>=5 ){ 3474 if( zTail ){ 3475 objlen = objlen - ((u8 *)zTail-(u8 *)zSql); 3476 }else{ 3477 objlen = 0; 3478 } 3479 pTail = Tcl_NewByteArrayObj((u8 *)zTail, objlen); 3480 Tcl_IncrRefCount(pTail); 3481 Tcl_ObjSetVar2(interp, objv[4], 0, pTail, 0); 3482 Tcl_DecrRefCount(pTail); 3483 } 3484 3485 if( pStmt ){ 3486 if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; 3487 } 3488 Tcl_AppendResult(interp, zBuf, 0); 3489 #endif /* SQLITE_OMIT_UTF16 */ 3490 return TCL_OK; 3491 } 3492 3493 /* 3494 ** Usage: sqlite3_prepare16_v2 DB sql bytes ?tailvar? 3495 ** 3496 ** Compile up to <bytes> bytes of the supplied SQL string <sql> using 3497 ** database handle <DB>. The parameter <tailval> is the name of a global 3498 ** variable that is set to the unused portion of <sql> (if any). A 3499 ** STMT handle is returned. 3500 */ 3501 static int test_prepare16_v2( 3502 void * clientData, 3503 Tcl_Interp *interp, 3504 int objc, 3505 Tcl_Obj *CONST objv[] 3506 ){ 3507 #ifndef SQLITE_OMIT_UTF16 3508 sqlite3 *db; 3509 const void *zSql; 3510 const void *zTail = 0; 3511 Tcl_Obj *pTail = 0; 3512 sqlite3_stmt *pStmt = 0; 3513 char zBuf[50]; 3514 int rc; 3515 int bytes; /* The integer specified as arg 3 */ 3516 int objlen; /* The byte-array length of arg 2 */ 3517 3518 if( objc!=5 && objc!=4 ){ 3519 Tcl_AppendResult(interp, "wrong # args: should be \"", 3520 Tcl_GetString(objv[0]), " DB sql bytes ?tailvar?", 0); 3521 return TCL_ERROR; 3522 } 3523 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 3524 zSql = Tcl_GetByteArrayFromObj(objv[2], &objlen); 3525 if( Tcl_GetIntFromObj(interp, objv[3], &bytes) ) return TCL_ERROR; 3526 3527 rc = sqlite3_prepare16_v2(db, zSql, bytes, &pStmt, objc>=5 ? &zTail : 0); 3528 if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; 3529 if( rc ){ 3530 return TCL_ERROR; 3531 } 3532 3533 if( objc>=5 ){ 3534 if( zTail ){ 3535 objlen = objlen - ((u8 *)zTail-(u8 *)zSql); 3536 }else{ 3537 objlen = 0; 3538 } 3539 pTail = Tcl_NewByteArrayObj((u8 *)zTail, objlen); 3540 Tcl_IncrRefCount(pTail); 3541 Tcl_ObjSetVar2(interp, objv[4], 0, pTail, 0); 3542 Tcl_DecrRefCount(pTail); 3543 } 3544 3545 if( pStmt ){ 3546 if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; 3547 } 3548 Tcl_AppendResult(interp, zBuf, 0); 3549 #endif /* SQLITE_OMIT_UTF16 */ 3550 return TCL_OK; 3551 } 3552 3553 /* 3554 ** Usage: sqlite3_open filename ?options-list? 3555 */ 3556 static int test_open( 3557 void * clientData, 3558 Tcl_Interp *interp, 3559 int objc, 3560 Tcl_Obj *CONST objv[] 3561 ){ 3562 const char *zFilename; 3563 sqlite3 *db; 3564 int rc; 3565 char zBuf[100]; 3566 3567 if( objc!=3 && objc!=2 && objc!=1 ){ 3568 Tcl_AppendResult(interp, "wrong # args: should be \"", 3569 Tcl_GetString(objv[0]), " filename options-list", 0); 3570 return TCL_ERROR; 3571 } 3572 3573 zFilename = objc>1 ? Tcl_GetString(objv[1]) : 0; 3574 rc = sqlite3_open(zFilename, &db); 3575 3576 if( sqlite3TestMakePointerStr(interp, zBuf, db) ) return TCL_ERROR; 3577 Tcl_AppendResult(interp, zBuf, 0); 3578 return TCL_OK; 3579 } 3580 3581 /* 3582 ** Usage: sqlite3_open16 filename options 3583 */ 3584 static int test_open16( 3585 void * clientData, 3586 Tcl_Interp *interp, 3587 int objc, 3588 Tcl_Obj *CONST objv[] 3589 ){ 3590 #ifndef SQLITE_OMIT_UTF16 3591 const void *zFilename; 3592 sqlite3 *db; 3593 int rc; 3594 char zBuf[100]; 3595 3596 if( objc!=3 ){ 3597 Tcl_AppendResult(interp, "wrong # args: should be \"", 3598 Tcl_GetString(objv[0]), " filename options-list", 0); 3599 return TCL_ERROR; 3600 } 3601 3602 zFilename = Tcl_GetByteArrayFromObj(objv[1], 0); 3603 rc = sqlite3_open16(zFilename, &db); 3604 3605 if( sqlite3TestMakePointerStr(interp, zBuf, db) ) return TCL_ERROR; 3606 Tcl_AppendResult(interp, zBuf, 0); 3607 #endif /* SQLITE_OMIT_UTF16 */ 3608 return TCL_OK; 3609 } 3610 3611 /* 3612 ** Usage: sqlite3_complete16 <UTF-16 string> 3613 ** 3614 ** Return 1 if the supplied argument is a complete SQL statement, or zero 3615 ** otherwise. 3616 */ 3617 static int test_complete16( 3618 void * clientData, 3619 Tcl_Interp *interp, 3620 int objc, 3621 Tcl_Obj *CONST objv[] 3622 ){ 3623 #if !defined(SQLITE_OMIT_COMPLETE) && !defined(SQLITE_OMIT_UTF16) 3624 char *zBuf; 3625 3626 if( objc!=2 ){ 3627 Tcl_WrongNumArgs(interp, 1, objv, "<utf-16 sql>"); 3628 return TCL_ERROR; 3629 } 3630 3631 zBuf = (char*)Tcl_GetByteArrayFromObj(objv[1], 0); 3632 Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_complete16(zBuf))); 3633 #endif /* SQLITE_OMIT_COMPLETE && SQLITE_OMIT_UTF16 */ 3634 return TCL_OK; 3635 } 3636 3637 /* 3638 ** Usage: sqlite3_step STMT 3639 ** 3640 ** Advance the statement to the next row. 3641 */ 3642 static int test_step( 3643 void * clientData, 3644 Tcl_Interp *interp, 3645 int objc, 3646 Tcl_Obj *CONST objv[] 3647 ){ 3648 sqlite3_stmt *pStmt; 3649 int rc; 3650 3651 if( objc!=2 ){ 3652 Tcl_AppendResult(interp, "wrong # args: should be \"", 3653 Tcl_GetString(objv[0]), " STMT", 0); 3654 return TCL_ERROR; 3655 } 3656 3657 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3658 rc = sqlite3_step(pStmt); 3659 3660 /* if( rc!=SQLITE_DONE && rc!=SQLITE_ROW ) return TCL_ERROR; */ 3661 Tcl_SetResult(interp, (char *)t1ErrorName(rc), 0); 3662 return TCL_OK; 3663 } 3664 3665 static int test_sql( 3666 void * clientData, 3667 Tcl_Interp *interp, 3668 int objc, 3669 Tcl_Obj *CONST objv[] 3670 ){ 3671 sqlite3_stmt *pStmt; 3672 3673 if( objc!=2 ){ 3674 Tcl_WrongNumArgs(interp, 1, objv, "STMT"); 3675 return TCL_ERROR; 3676 } 3677 3678 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3679 Tcl_SetResult(interp, (char *)sqlite3_sql(pStmt), TCL_VOLATILE); 3680 return TCL_OK; 3681 } 3682 3683 /* 3684 ** Usage: sqlite3_column_count STMT 3685 ** 3686 ** Return the number of columns returned by the sql statement STMT. 3687 */ 3688 static int test_column_count( 3689 void * clientData, 3690 Tcl_Interp *interp, 3691 int objc, 3692 Tcl_Obj *CONST objv[] 3693 ){ 3694 sqlite3_stmt *pStmt; 3695 3696 if( objc!=2 ){ 3697 Tcl_AppendResult(interp, "wrong # args: should be \"", 3698 Tcl_GetString(objv[0]), " STMT column", 0); 3699 return TCL_ERROR; 3700 } 3701 3702 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3703 3704 Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_column_count(pStmt))); 3705 return TCL_OK; 3706 } 3707 3708 /* 3709 ** Usage: sqlite3_column_type STMT column 3710 ** 3711 ** Return the type of the data in column 'column' of the current row. 3712 */ 3713 static int test_column_type( 3714 void * clientData, 3715 Tcl_Interp *interp, 3716 int objc, 3717 Tcl_Obj *CONST objv[] 3718 ){ 3719 sqlite3_stmt *pStmt; 3720 int col; 3721 int tp; 3722 3723 if( objc!=3 ){ 3724 Tcl_AppendResult(interp, "wrong # args: should be \"", 3725 Tcl_GetString(objv[0]), " STMT column", 0); 3726 return TCL_ERROR; 3727 } 3728 3729 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3730 if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; 3731 3732 tp = sqlite3_column_type(pStmt, col); 3733 switch( tp ){ 3734 case SQLITE_INTEGER: 3735 Tcl_SetResult(interp, "INTEGER", TCL_STATIC); 3736 break; 3737 case SQLITE_NULL: 3738 Tcl_SetResult(interp, "NULL", TCL_STATIC); 3739 break; 3740 case SQLITE_FLOAT: 3741 Tcl_SetResult(interp, "FLOAT", TCL_STATIC); 3742 break; 3743 case SQLITE_TEXT: 3744 Tcl_SetResult(interp, "TEXT", TCL_STATIC); 3745 break; 3746 case SQLITE_BLOB: 3747 Tcl_SetResult(interp, "BLOB", TCL_STATIC); 3748 break; 3749 default: 3750 assert(0); 3751 } 3752 3753 return TCL_OK; 3754 } 3755 3756 /* 3757 ** Usage: sqlite3_column_int64 STMT column 3758 ** 3759 ** Return the data in column 'column' of the current row cast as an 3760 ** wide (64-bit) integer. 3761 */ 3762 static int test_column_int64( 3763 void * clientData, 3764 Tcl_Interp *interp, 3765 int objc, 3766 Tcl_Obj *CONST objv[] 3767 ){ 3768 sqlite3_stmt *pStmt; 3769 int col; 3770 i64 iVal; 3771 3772 if( objc!=3 ){ 3773 Tcl_AppendResult(interp, "wrong # args: should be \"", 3774 Tcl_GetString(objv[0]), " STMT column", 0); 3775 return TCL_ERROR; 3776 } 3777 3778 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3779 if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; 3780 3781 iVal = sqlite3_column_int64(pStmt, col); 3782 Tcl_SetObjResult(interp, Tcl_NewWideIntObj(iVal)); 3783 return TCL_OK; 3784 } 3785 3786 /* 3787 ** Usage: sqlite3_column_blob STMT column 3788 */ 3789 static int test_column_blob( 3790 void * clientData, 3791 Tcl_Interp *interp, 3792 int objc, 3793 Tcl_Obj *CONST objv[] 3794 ){ 3795 sqlite3_stmt *pStmt; 3796 int col; 3797 3798 int len; 3799 const void *pBlob; 3800 3801 if( objc!=3 ){ 3802 Tcl_AppendResult(interp, "wrong # args: should be \"", 3803 Tcl_GetString(objv[0]), " STMT column", 0); 3804 return TCL_ERROR; 3805 } 3806 3807 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3808 if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; 3809 3810 len = sqlite3_column_bytes(pStmt, col); 3811 pBlob = sqlite3_column_blob(pStmt, col); 3812 Tcl_SetObjResult(interp, Tcl_NewByteArrayObj(pBlob, len)); 3813 return TCL_OK; 3814 } 3815 3816 /* 3817 ** Usage: sqlite3_column_double STMT column 3818 ** 3819 ** Return the data in column 'column' of the current row cast as a double. 3820 */ 3821 static int test_column_double( 3822 void * clientData, 3823 Tcl_Interp *interp, 3824 int objc, 3825 Tcl_Obj *CONST objv[] 3826 ){ 3827 sqlite3_stmt *pStmt; 3828 int col; 3829 double rVal; 3830 3831 if( objc!=3 ){ 3832 Tcl_AppendResult(interp, "wrong # args: should be \"", 3833 Tcl_GetString(objv[0]), " STMT column", 0); 3834 return TCL_ERROR; 3835 } 3836 3837 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3838 if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; 3839 3840 rVal = sqlite3_column_double(pStmt, col); 3841 Tcl_SetObjResult(interp, Tcl_NewDoubleObj(rVal)); 3842 return TCL_OK; 3843 } 3844 3845 /* 3846 ** Usage: sqlite3_data_count STMT 3847 ** 3848 ** Return the number of columns returned by the sql statement STMT. 3849 */ 3850 static int test_data_count( 3851 void * clientData, 3852 Tcl_Interp *interp, 3853 int objc, 3854 Tcl_Obj *CONST objv[] 3855 ){ 3856 sqlite3_stmt *pStmt; 3857 3858 if( objc!=2 ){ 3859 Tcl_AppendResult(interp, "wrong # args: should be \"", 3860 Tcl_GetString(objv[0]), " STMT column", 0); 3861 return TCL_ERROR; 3862 } 3863 3864 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3865 3866 Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_data_count(pStmt))); 3867 return TCL_OK; 3868 } 3869 3870 /* 3871 ** Usage: sqlite3_column_text STMT column 3872 ** 3873 ** Usage: sqlite3_column_decltype STMT column 3874 ** 3875 ** Usage: sqlite3_column_name STMT column 3876 */ 3877 static int test_stmt_utf8( 3878 void * clientData, /* Pointer to SQLite API function to be invoke */ 3879 Tcl_Interp *interp, 3880 int objc, 3881 Tcl_Obj *CONST objv[] 3882 ){ 3883 sqlite3_stmt *pStmt; 3884 int col; 3885 const char *(*xFunc)(sqlite3_stmt*, int); 3886 const char *zRet; 3887 3888 xFunc = (const char *(*)(sqlite3_stmt*, int))clientData; 3889 if( objc!=3 ){ 3890 Tcl_AppendResult(interp, "wrong # args: should be \"", 3891 Tcl_GetString(objv[0]), " STMT column", 0); 3892 return TCL_ERROR; 3893 } 3894 3895 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3896 if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; 3897 zRet = xFunc(pStmt, col); 3898 if( zRet ){ 3899 Tcl_SetResult(interp, (char *)zRet, 0); 3900 } 3901 return TCL_OK; 3902 } 3903 3904 static int test_global_recover( 3905 void * clientData, 3906 Tcl_Interp *interp, 3907 int objc, 3908 Tcl_Obj *CONST objv[] 3909 ){ 3910 #ifndef SQLITE_OMIT_DEPRECATED 3911 int rc; 3912 if( objc!=1 ){ 3913 Tcl_WrongNumArgs(interp, 1, objv, ""); 3914 return TCL_ERROR; 3915 } 3916 rc = sqlite3_global_recover(); 3917 Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); 3918 #endif 3919 return TCL_OK; 3920 } 3921 3922 /* 3923 ** Usage: sqlite3_column_text STMT column 3924 ** 3925 ** Usage: sqlite3_column_decltype STMT column 3926 ** 3927 ** Usage: sqlite3_column_name STMT column 3928 */ 3929 static int test_stmt_utf16( 3930 void * clientData, /* Pointer to SQLite API function to be invoked */ 3931 Tcl_Interp *interp, 3932 int objc, 3933 Tcl_Obj *CONST objv[] 3934 ){ 3935 #ifndef SQLITE_OMIT_UTF16 3936 sqlite3_stmt *pStmt; 3937 int col; 3938 Tcl_Obj *pRet; 3939 const void *zName16; 3940 const void *(*xFunc)(sqlite3_stmt*, int); 3941 3942 xFunc = (const void *(*)(sqlite3_stmt*, int))clientData; 3943 if( objc!=3 ){ 3944 Tcl_AppendResult(interp, "wrong # args: should be \"", 3945 Tcl_GetString(objv[0]), " STMT column", 0); 3946 return TCL_ERROR; 3947 } 3948 3949 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3950 if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; 3951 3952 zName16 = xFunc(pStmt, col); 3953 if( zName16 ){ 3954 int n; 3955 const char *z = zName16; 3956 for(n=0; z[n] || z[n+1]; n+=2){} 3957 pRet = Tcl_NewByteArrayObj(zName16, n+2); 3958 Tcl_SetObjResult(interp, pRet); 3959 } 3960 #endif /* SQLITE_OMIT_UTF16 */ 3961 3962 return TCL_OK; 3963 } 3964 3965 /* 3966 ** Usage: sqlite3_column_int STMT column 3967 ** 3968 ** Usage: sqlite3_column_bytes STMT column 3969 ** 3970 ** Usage: sqlite3_column_bytes16 STMT column 3971 ** 3972 */ 3973 static int test_stmt_int( 3974 void * clientData, /* Pointer to SQLite API function to be invoked */ 3975 Tcl_Interp *interp, 3976 int objc, 3977 Tcl_Obj *CONST objv[] 3978 ){ 3979 sqlite3_stmt *pStmt; 3980 int col; 3981 int (*xFunc)(sqlite3_stmt*, int); 3982 3983 xFunc = (int (*)(sqlite3_stmt*, int))clientData; 3984 if( objc!=3 ){ 3985 Tcl_AppendResult(interp, "wrong # args: should be \"", 3986 Tcl_GetString(objv[0]), " STMT column", 0); 3987 return TCL_ERROR; 3988 } 3989 3990 if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; 3991 if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; 3992 3993 Tcl_SetObjResult(interp, Tcl_NewIntObj(xFunc(pStmt, col))); 3994 return TCL_OK; 3995 } 3996 3997 /* 3998 ** Usage: sqlite_set_magic DB MAGIC-NUMBER 3999 ** 4000 ** Set the db->magic value. This is used to test error recovery logic. 4001 */ 4002 static int sqlite_set_magic( 4003 void * clientData, 4004 Tcl_Interp *interp, 4005 int argc, 4006 char **argv 4007 ){ 4008 sqlite3 *db; 4009 if( argc!=3 ){ 4010 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 4011 " DB MAGIC", 0); 4012 return TCL_ERROR; 4013 } 4014 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 4015 if( strcmp(argv[2], "SQLITE_MAGIC_OPEN")==0 ){ 4016 db->magic = SQLITE_MAGIC_OPEN; 4017 }else if( strcmp(argv[2], "SQLITE_MAGIC_CLOSED")==0 ){ 4018 db->magic = SQLITE_MAGIC_CLOSED; 4019 }else if( strcmp(argv[2], "SQLITE_MAGIC_BUSY")==0 ){ 4020 db->magic = SQLITE_MAGIC_BUSY; 4021 }else if( strcmp(argv[2], "SQLITE_MAGIC_ERROR")==0 ){ 4022 db->magic = SQLITE_MAGIC_ERROR; 4023 }else if( Tcl_GetInt(interp, argv[2], (int*)&db->magic) ){ 4024 return TCL_ERROR; 4025 } 4026 return TCL_OK; 4027 } 4028 4029 /* 4030 ** Usage: sqlite3_interrupt DB 4031 ** 4032 ** Trigger an interrupt on DB 4033 */ 4034 static int test_interrupt( 4035 void * clientData, 4036 Tcl_Interp *interp, 4037 int argc, 4038 char **argv 4039 ){ 4040 sqlite3 *db; 4041 if( argc!=2 ){ 4042 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], " DB", 0); 4043 return TCL_ERROR; 4044 } 4045 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 4046 sqlite3_interrupt(db); 4047 return TCL_OK; 4048 } 4049 4050 static u8 *sqlite3_stack_baseline = 0; 4051 4052 /* 4053 ** Fill the stack with a known bitpattern. 4054 */ 4055 static void prepStack(void){ 4056 int i; 4057 u32 bigBuf[65536]; 4058 for(i=0; i<sizeof(bigBuf); i++) bigBuf[i] = 0xdeadbeef; 4059 sqlite3_stack_baseline = (u8*)&bigBuf[65536]; 4060 } 4061 4062 /* 4063 ** Get the current stack depth. Used for debugging only. 4064 */ 4065 u64 sqlite3StackDepth(void){ 4066 u8 x; 4067 return (u64)(sqlite3_stack_baseline - &x); 4068 } 4069 4070 /* 4071 ** Usage: sqlite3_stack_used DB SQL 4072 ** 4073 ** Try to measure the amount of stack space used by a call to sqlite3_exec 4074 */ 4075 static int test_stack_used( 4076 void * clientData, 4077 Tcl_Interp *interp, 4078 int argc, 4079 char **argv 4080 ){ 4081 sqlite3 *db; 4082 int i; 4083 if( argc!=3 ){ 4084 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 4085 " DB SQL", 0); 4086 return TCL_ERROR; 4087 } 4088 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 4089 prepStack(); 4090 (void)sqlite3_exec(db, argv[2], 0, 0, 0); 4091 for(i=65535; i>=0 && ((u32*)sqlite3_stack_baseline)[-i]==0xdeadbeef; i--){} 4092 Tcl_SetObjResult(interp, Tcl_NewIntObj(i*4)); 4093 return TCL_OK; 4094 } 4095 4096 /* 4097 ** Usage: sqlite_delete_function DB function-name 4098 ** 4099 ** Delete the user function 'function-name' from database handle DB. It 4100 ** is assumed that the user function was created as UTF8, any number of 4101 ** arguments (the way the TCL interface does it). 4102 */ 4103 static int delete_function( 4104 void * clientData, 4105 Tcl_Interp *interp, 4106 int argc, 4107 char **argv 4108 ){ 4109 int rc; 4110 sqlite3 *db; 4111 if( argc!=3 ){ 4112 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 4113 " DB function-name", 0); 4114 return TCL_ERROR; 4115 } 4116 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 4117 rc = sqlite3_create_function(db, argv[2], -1, SQLITE_UTF8, 0, 0, 0, 0); 4118 Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); 4119 return TCL_OK; 4120 } 4121 4122 /* 4123 ** Usage: sqlite_delete_collation DB collation-name 4124 ** 4125 ** Delete the collation sequence 'collation-name' from database handle 4126 ** DB. It is assumed that the collation sequence was created as UTF8 (the 4127 ** way the TCL interface does it). 4128 */ 4129 static int delete_collation( 4130 void * clientData, 4131 Tcl_Interp *interp, 4132 int argc, 4133 char **argv 4134 ){ 4135 int rc; 4136 sqlite3 *db; 4137 if( argc!=3 ){ 4138 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 4139 " DB function-name", 0); 4140 return TCL_ERROR; 4141 } 4142 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 4143 rc = sqlite3_create_collation(db, argv[2], SQLITE_UTF8, 0, 0); 4144 Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); 4145 return TCL_OK; 4146 } 4147 4148 /* 4149 ** Usage: sqlite3_get_autocommit DB 4150 ** 4151 ** Return true if the database DB is currently in auto-commit mode. 4152 ** Return false if not. 4153 */ 4154 static int get_autocommit( 4155 void * clientData, 4156 Tcl_Interp *interp, 4157 int argc, 4158 char **argv 4159 ){ 4160 char zBuf[30]; 4161 sqlite3 *db; 4162 if( argc!=2 ){ 4163 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 4164 " DB", 0); 4165 return TCL_ERROR; 4166 } 4167 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 4168 sprintf(zBuf, "%d", sqlite3_get_autocommit(db)); 4169 Tcl_AppendResult(interp, zBuf, 0); 4170 return TCL_OK; 4171 } 4172 4173 /* 4174 ** Usage: sqlite3_busy_timeout DB MS 4175 ** 4176 ** Set the busy timeout. This is more easily done using the timeout 4177 ** method of the TCL interface. But we need a way to test the case 4178 ** where it returns SQLITE_MISUSE. 4179 */ 4180 static int test_busy_timeout( 4181 void * clientData, 4182 Tcl_Interp *interp, 4183 int argc, 4184 char **argv 4185 ){ 4186 int rc, ms; 4187 sqlite3 *db; 4188 if( argc!=3 ){ 4189 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], 4190 " DB", 0); 4191 return TCL_ERROR; 4192 } 4193 if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; 4194 if( Tcl_GetInt(interp, argv[2], &ms) ) return TCL_ERROR; 4195 rc = sqlite3_busy_timeout(db, ms); 4196 Tcl_AppendResult(interp, sqlite3TestErrorName(rc), 0); 4197 return TCL_OK; 4198 } 4199 4200 /* 4201 ** Usage: tcl_variable_type VARIABLENAME 4202 ** 4203 ** Return the name of the internal representation for the 4204 ** value of the given variable. 4205 */ 4206 static int tcl_variable_type( 4207 void * clientData, 4208 Tcl_Interp *interp, 4209 int objc, 4210 Tcl_Obj *CONST objv[] 4211 ){ 4212 Tcl_Obj *pVar; 4213 if( objc!=2 ){ 4214 Tcl_WrongNumArgs(interp, 1, objv, "VARIABLE"); 4215 return TCL_ERROR; 4216 } 4217 pVar = Tcl_GetVar2Ex(interp, Tcl_GetString(objv[1]), 0, TCL_LEAVE_ERR_MSG); 4218 if( pVar==0 ) return TCL_ERROR; 4219 if( pVar->typePtr ){ 4220 Tcl_SetObjResult(interp, Tcl_NewStringObj(pVar->typePtr->name, -1)); 4221 } 4222 return TCL_OK; 4223 } 4224 4225 /* 4226 ** Usage: sqlite3_release_memory ?N? 4227 ** 4228 ** Attempt to release memory currently held but not actually required. 4229 ** The integer N is the number of bytes we are trying to release. The 4230 ** return value is the amount of memory actually released. 4231 */ 4232 static int test_release_memory( 4233 void * clientData, 4234 Tcl_Interp *interp, 4235 int objc, 4236 Tcl_Obj *CONST objv[] 4237 ){ 4238 #if defined(SQLITE_ENABLE_MEMORY_MANAGEMENT) && !defined(SQLITE_OMIT_DISKIO) 4239 int N; 4240 int amt; 4241 if( objc!=1 && objc!=2 ){ 4242 Tcl_WrongNumArgs(interp, 1, objv, "?N?"); 4243 return TCL_ERROR; 4244 } 4245 if( objc==2 ){ 4246 if( Tcl_GetIntFromObj(interp, objv[1], &N) ) return TCL_ERROR; 4247 }else{ 4248 N = -1; 4249 } 4250 amt = sqlite3_release_memory(N); 4251 Tcl_SetObjResult(interp, Tcl_NewIntObj(amt)); 4252 #endif 4253 return TCL_OK; 4254 } 4255 4256 /* 4257 ** Usage: sqlite3_soft_heap_limit ?N? 4258 ** 4259 ** Query or set the soft heap limit for the current thread. The 4260 ** limit is only changed if the N is present. The previous limit 4261 ** is returned. 4262 */ 4263 static int test_soft_heap_limit( 4264 void * clientData, 4265 Tcl_Interp *interp, 4266 int objc, 4267 Tcl_Obj *CONST objv[] 4268 ){ 4269 static int softHeapLimit = 0; 4270 int amt; 4271 if( objc!=1 && objc!=2 ){ 4272 Tcl_WrongNumArgs(interp, 1, objv, "?N?"); 4273 return TCL_ERROR; 4274 } 4275 amt = softHeapLimit; 4276 if( objc==2 ){ 4277 int N; 4278 if( Tcl_GetIntFromObj(interp, objv[1], &N) ) return TCL_ERROR; 4279 sqlite3_soft_heap_limit(N); 4280 softHeapLimit = N; 4281 } 4282 Tcl_SetObjResult(interp, Tcl_NewIntObj(amt)); 4283 return TCL_OK; 4284 } 4285 4286 /* 4287 ** Usage: sqlite3_thread_cleanup 4288 ** 4289 ** Call the sqlite3_thread_cleanup API. 4290 */ 4291 static int test_thread_cleanup( 4292 void * clientData, 4293 Tcl_Interp *interp, 4294 int objc, 4295 Tcl_Obj *CONST objv[] 4296 ){ 4297 #ifndef SQLITE_OMIT_DEPRECATED 4298 sqlite3_thread_cleanup(); 4299 #endif 4300 return TCL_OK; 4301 } 4302 4303 /* 4304 ** Usage: sqlite3_pager_refcounts DB 4305 ** 4306 ** Return a list of numbers which are the PagerRefcount for all 4307 ** pagers on each database connection. 4308 */ 4309 static int test_pager_refcounts( 4310 void * clientData, 4311 Tcl_Interp *interp, 4312 int objc, 4313 Tcl_Obj *CONST objv[] 4314 ){ 4315 sqlite3 *db; 4316 int i; 4317 int v, *a; 4318 Tcl_Obj *pResult; 4319 4320 if( objc!=2 ){ 4321 Tcl_AppendResult(interp, "wrong # args: should be \"", 4322 Tcl_GetStringFromObj(objv[0], 0), " DB", 0); 4323 return TCL_ERROR; 4324 } 4325 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 4326 pResult = Tcl_NewObj(); 4327 for(i=0; i<db->nDb; i++){ 4328 if( db->aDb[i].pBt==0 ){ 4329 v = -1; 4330 }else{ 4331 sqlite3_mutex_enter(db->mutex); 4332 a = sqlite3PagerStats(sqlite3BtreePager(db->aDb[i].pBt)); 4333 v = a[0]; 4334 sqlite3_mutex_leave(db->mutex); 4335 } 4336 Tcl_ListObjAppendElement(0, pResult, Tcl_NewIntObj(v)); 4337 } 4338 Tcl_SetObjResult(interp, pResult); 4339 return TCL_OK; 4340 } 4341 4342 4343 /* 4344 ** tclcmd: working_64bit_int 4345 ** 4346 ** Some TCL builds (ex: cygwin) do not support 64-bit integers. This 4347 ** leads to a number of test failures. The present command checks the 4348 ** TCL build to see whether or not it supports 64-bit integers. It 4349 ** returns TRUE if it does and FALSE if not. 4350 ** 4351 ** This command is used to warn users that their TCL build is defective 4352 ** and that the errors they are seeing in the test scripts might be 4353 ** a result of their defective TCL rather than problems in SQLite. 4354 */ 4355 static int working_64bit_int( 4356 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4357 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4358 int objc, /* Number of arguments */ 4359 Tcl_Obj *CONST objv[] /* Command arguments */ 4360 ){ 4361 Tcl_Obj *pTestObj; 4362 int working = 0; 4363 4364 pTestObj = Tcl_NewWideIntObj(1000000*(i64)1234567890); 4365 working = strcmp(Tcl_GetString(pTestObj), "1234567890000000")==0; 4366 Tcl_DecrRefCount(pTestObj); 4367 Tcl_SetObjResult(interp, Tcl_NewBooleanObj(working)); 4368 return TCL_OK; 4369 } 4370 4371 4372 /* 4373 ** tclcmd: vfs_unlink_test 4374 ** 4375 ** This TCL command unregisters the primary VFS and then registers 4376 ** it back again. This is used to test the ability to register a 4377 ** VFS when none are previously registered, and the ability to 4378 ** unregister the only available VFS. Ticket #2738 4379 */ 4380 static int vfs_unlink_test( 4381 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4382 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4383 int objc, /* Number of arguments */ 4384 Tcl_Obj *CONST objv[] /* Command arguments */ 4385 ){ 4386 int i; 4387 sqlite3_vfs *pMain; 4388 sqlite3_vfs *apVfs[20]; 4389 sqlite3_vfs one, two; 4390 4391 sqlite3_vfs_unregister(0); /* Unregister of NULL is harmless */ 4392 one.zName = "__one"; 4393 two.zName = "__two"; 4394 4395 /* Calling sqlite3_vfs_register with 2nd argument of 0 does not 4396 ** change the default VFS 4397 */ 4398 pMain = sqlite3_vfs_find(0); 4399 sqlite3_vfs_register(&one, 0); 4400 assert( pMain==0 || pMain==sqlite3_vfs_find(0) ); 4401 sqlite3_vfs_register(&two, 0); 4402 assert( pMain==0 || pMain==sqlite3_vfs_find(0) ); 4403 4404 /* We can find a VFS by its name */ 4405 assert( sqlite3_vfs_find("__one")==&one ); 4406 assert( sqlite3_vfs_find("__two")==&two ); 4407 4408 /* Calling sqlite_vfs_register with non-zero second parameter changes the 4409 ** default VFS, even if the 1st parameter is an existig VFS that is 4410 ** previously registered as the non-default. 4411 */ 4412 sqlite3_vfs_register(&one, 1); 4413 assert( sqlite3_vfs_find("__one")==&one ); 4414 assert( sqlite3_vfs_find("__two")==&two ); 4415 assert( sqlite3_vfs_find(0)==&one ); 4416 sqlite3_vfs_register(&two, 1); 4417 assert( sqlite3_vfs_find("__one")==&one ); 4418 assert( sqlite3_vfs_find("__two")==&two ); 4419 assert( sqlite3_vfs_find(0)==&two ); 4420 if( pMain ){ 4421 sqlite3_vfs_register(pMain, 1); 4422 assert( sqlite3_vfs_find("__one")==&one ); 4423 assert( sqlite3_vfs_find("__two")==&two ); 4424 assert( sqlite3_vfs_find(0)==pMain ); 4425 } 4426 4427 /* Unlink the default VFS. Repeat until there are no more VFSes 4428 ** registered. 4429 */ 4430 for(i=0; i<sizeof(apVfs)/sizeof(apVfs[0]); i++){ 4431 apVfs[i] = sqlite3_vfs_find(0); 4432 if( apVfs[i] ){ 4433 assert( apVfs[i]==sqlite3_vfs_find(apVfs[i]->zName) ); 4434 sqlite3_vfs_unregister(apVfs[i]); 4435 assert( 0==sqlite3_vfs_find(apVfs[i]->zName) ); 4436 } 4437 } 4438 assert( 0==sqlite3_vfs_find(0) ); 4439 4440 /* Register the main VFS as non-default (will be made default, since 4441 ** it'll be the only one in existence). 4442 */ 4443 sqlite3_vfs_register(pMain, 0); 4444 assert( sqlite3_vfs_find(0)==pMain ); 4445 4446 /* Un-register the main VFS again to restore an empty VFS list */ 4447 sqlite3_vfs_unregister(pMain); 4448 assert( 0==sqlite3_vfs_find(0) ); 4449 4450 /* Relink all VFSes in reverse order. */ 4451 for(i=sizeof(apVfs)/sizeof(apVfs[0])-1; i>=0; i--){ 4452 if( apVfs[i] ){ 4453 sqlite3_vfs_register(apVfs[i], 1); 4454 assert( apVfs[i]==sqlite3_vfs_find(0) ); 4455 assert( apVfs[i]==sqlite3_vfs_find(apVfs[i]->zName) ); 4456 } 4457 } 4458 4459 /* Unregister out sample VFSes. */ 4460 sqlite3_vfs_unregister(&one); 4461 sqlite3_vfs_unregister(&two); 4462 4463 /* Unregistering a VFS that is not currently registered is harmless */ 4464 sqlite3_vfs_unregister(&one); 4465 sqlite3_vfs_unregister(&two); 4466 assert( sqlite3_vfs_find("__one")==0 ); 4467 assert( sqlite3_vfs_find("__two")==0 ); 4468 4469 /* We should be left with the original default VFS back as the 4470 ** original */ 4471 assert( sqlite3_vfs_find(0)==pMain ); 4472 4473 return TCL_OK; 4474 } 4475 4476 /* 4477 ** tclcmd: vfs_initfail_test 4478 ** 4479 ** This TCL command attempts to vfs_find and vfs_register when the 4480 ** sqlite3_initialize() interface is failing. All calls should fail. 4481 */ 4482 static int vfs_initfail_test( 4483 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4484 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4485 int objc, /* Number of arguments */ 4486 Tcl_Obj *CONST objv[] /* Command arguments */ 4487 ){ 4488 sqlite3_vfs one; 4489 one.zName = "__one"; 4490 4491 if( sqlite3_vfs_find(0) ) return TCL_ERROR; 4492 sqlite3_vfs_register(&one, 0); 4493 if( sqlite3_vfs_find(0) ) return TCL_ERROR; 4494 sqlite3_vfs_register(&one, 1); 4495 if( sqlite3_vfs_find(0) ) return TCL_ERROR; 4496 return TCL_OK; 4497 } 4498 4499 /* 4500 ** Saved VFSes 4501 */ 4502 static sqlite3_vfs *apVfs[20]; 4503 static int nVfs = 0; 4504 4505 /* 4506 ** tclcmd: vfs_unregister_all 4507 ** 4508 ** Unregister all VFSes. 4509 */ 4510 static int vfs_unregister_all( 4511 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4512 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4513 int objc, /* Number of arguments */ 4514 Tcl_Obj *CONST objv[] /* Command arguments */ 4515 ){ 4516 int i; 4517 for(i=0; i<ArraySize(apVfs); i++){ 4518 apVfs[i] = sqlite3_vfs_find(0); 4519 if( apVfs[i]==0 ) break; 4520 sqlite3_vfs_unregister(apVfs[i]); 4521 } 4522 nVfs = i; 4523 return TCL_OK; 4524 } 4525 /* 4526 ** tclcmd: vfs_reregister_all 4527 ** 4528 ** Restore all VFSes that were removed using vfs_unregister_all 4529 */ 4530 static int vfs_reregister_all( 4531 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4532 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4533 int objc, /* Number of arguments */ 4534 Tcl_Obj *CONST objv[] /* Command arguments */ 4535 ){ 4536 int i; 4537 for(i=0; i<nVfs; i++){ 4538 sqlite3_vfs_register(apVfs[i], i==0); 4539 } 4540 return TCL_OK; 4541 } 4542 4543 4544 /* 4545 ** tclcmd: file_control_test DB 4546 ** 4547 ** This TCL command runs the sqlite3_file_control interface and 4548 ** verifies correct operation of the same. 4549 */ 4550 static int file_control_test( 4551 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4552 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4553 int objc, /* Number of arguments */ 4554 Tcl_Obj *CONST objv[] /* Command arguments */ 4555 ){ 4556 int iArg = 0; 4557 sqlite3 *db; 4558 int rc; 4559 4560 if( objc!=2 ){ 4561 Tcl_AppendResult(interp, "wrong # args: should be \"", 4562 Tcl_GetStringFromObj(objv[0], 0), " DB", 0); 4563 return TCL_ERROR; 4564 } 4565 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 4566 rc = sqlite3_file_control(db, 0, 0, &iArg); 4567 assert( rc==SQLITE_ERROR ); 4568 rc = sqlite3_file_control(db, "notadatabase", SQLITE_FCNTL_LOCKSTATE, &iArg); 4569 assert( rc==SQLITE_ERROR ); 4570 rc = sqlite3_file_control(db, "main", -1, &iArg); 4571 assert( rc==SQLITE_ERROR ); 4572 rc = sqlite3_file_control(db, "temp", -1, &iArg); 4573 assert( rc==SQLITE_ERROR ); 4574 4575 return TCL_OK; 4576 } 4577 4578 4579 /* 4580 ** tclcmd: file_control_lasterrno_test DB 4581 ** 4582 ** This TCL command runs the sqlite3_file_control interface and 4583 ** verifies correct operation of the SQLITE_LAST_ERRNO verb. 4584 */ 4585 static int file_control_lasterrno_test( 4586 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4587 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4588 int objc, /* Number of arguments */ 4589 Tcl_Obj *CONST objv[] /* Command arguments */ 4590 ){ 4591 int iArg = 0; 4592 sqlite3 *db; 4593 int rc; 4594 4595 if( objc!=2 ){ 4596 Tcl_AppendResult(interp, "wrong # args: should be \"", 4597 Tcl_GetStringFromObj(objv[0], 0), " DB", 0); 4598 return TCL_ERROR; 4599 } 4600 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ){ 4601 return TCL_ERROR; 4602 } 4603 rc = sqlite3_file_control(db, NULL, SQLITE_LAST_ERRNO, &iArg); 4604 if( rc ){ 4605 Tcl_SetObjResult(interp, Tcl_NewIntObj(rc)); 4606 return TCL_ERROR; 4607 } 4608 if( iArg!=0 ) { 4609 Tcl_AppendResult(interp, "Unexpected non-zero errno: ", 4610 Tcl_GetStringFromObj(Tcl_NewIntObj(iArg), 0), " ", 0); 4611 return TCL_ERROR; 4612 } 4613 return TCL_OK; 4614 } 4615 4616 /* 4617 ** tclcmd: file_control_lockproxy_test DB PWD 4618 ** 4619 ** This TCL command runs the sqlite3_file_control interface and 4620 ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and 4621 ** SQLITE_SET_LOCKPROXYFILE verbs. 4622 */ 4623 static int file_control_lockproxy_test( 4624 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4625 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4626 int objc, /* Number of arguments */ 4627 Tcl_Obj *CONST objv[] /* Command arguments */ 4628 ){ 4629 sqlite3 *db; 4630 const char *zPwd; 4631 int nPwd; 4632 4633 if( objc!=3 ){ 4634 Tcl_AppendResult(interp, "wrong # args: should be \"", 4635 Tcl_GetStringFromObj(objv[0], 0), " DB PWD", 0); 4636 return TCL_ERROR; 4637 } 4638 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ){ 4639 return TCL_ERROR; 4640 } 4641 zPwd = Tcl_GetStringFromObj(objv[2], &nPwd); 4642 4643 #if !defined(SQLITE_ENABLE_LOCKING_STYLE) 4644 # if defined(__APPLE__) 4645 # define SQLITE_ENABLE_LOCKING_STYLE 1 4646 # else 4647 # define SQLITE_ENABLE_LOCKING_STYLE 0 4648 # endif 4649 #endif 4650 #if SQLITE_ENABLE_LOCKING_STYLE && defined(__APPLE__) 4651 { 4652 char *testPath; 4653 int rc; 4654 char proxyPath[400]; 4655 4656 if( sizeof(proxyPath)<nPwd+20 ){ 4657 Tcl_AppendResult(interp, "PWD too big", (void*)0); 4658 return TCL_ERROR; 4659 } 4660 sprintf(proxyPath, "%s/test.proxy", zPwd); 4661 rc = sqlite3_file_control(db, NULL, SQLITE_SET_LOCKPROXYFILE, proxyPath); 4662 if( rc ){ 4663 Tcl_SetObjResult(interp, Tcl_NewIntObj(rc)); 4664 return TCL_ERROR; 4665 } 4666 rc = sqlite3_file_control(db, NULL, SQLITE_GET_LOCKPROXYFILE, &testPath); 4667 if( strncmp(proxyPath,testPath,11) ){ 4668 Tcl_AppendResult(interp, "Lock proxy file did not match the " 4669 "previously assigned value", 0); 4670 return TCL_ERROR; 4671 } 4672 if( rc ){ 4673 Tcl_SetObjResult(interp, Tcl_NewIntObj(rc)); 4674 return TCL_ERROR; 4675 } 4676 rc = sqlite3_file_control(db, NULL, SQLITE_SET_LOCKPROXYFILE, proxyPath); 4677 if( rc ){ 4678 Tcl_SetObjResult(interp, Tcl_NewIntObj(rc)); 4679 return TCL_ERROR; 4680 } 4681 } 4682 #endif 4683 return TCL_OK; 4684 } 4685 4686 4687 /* 4688 ** tclcmd: sqlite3_vfs_list 4689 ** 4690 ** Return a tcl list containing the names of all registered vfs's. 4691 */ 4692 static int vfs_list( 4693 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4694 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4695 int objc, /* Number of arguments */ 4696 Tcl_Obj *CONST objv[] /* Command arguments */ 4697 ){ 4698 sqlite3_vfs *pVfs; 4699 Tcl_Obj *pRet = Tcl_NewObj(); 4700 if( objc!=1 ){ 4701 Tcl_WrongNumArgs(interp, 1, objv, ""); 4702 return TCL_ERROR; 4703 } 4704 for(pVfs=sqlite3_vfs_find(0); pVfs; pVfs=pVfs->pNext){ 4705 Tcl_ListObjAppendElement(interp, pRet, Tcl_NewStringObj(pVfs->zName, -1)); 4706 } 4707 Tcl_SetObjResult(interp, pRet); 4708 return TCL_OK; 4709 } 4710 4711 /* 4712 ** tclcmd: sqlite3_limit DB ID VALUE 4713 ** 4714 ** This TCL command runs the sqlite3_limit interface and 4715 ** verifies correct operation of the same. 4716 */ 4717 static int test_limit( 4718 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4719 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4720 int objc, /* Number of arguments */ 4721 Tcl_Obj *CONST objv[] /* Command arguments */ 4722 ){ 4723 sqlite3 *db; 4724 int rc; 4725 static const struct { 4726 char *zName; 4727 int id; 4728 } aId[] = { 4729 { "SQLITE_LIMIT_LENGTH", SQLITE_LIMIT_LENGTH }, 4730 { "SQLITE_LIMIT_SQL_LENGTH", SQLITE_LIMIT_SQL_LENGTH }, 4731 { "SQLITE_LIMIT_COLUMN", SQLITE_LIMIT_COLUMN }, 4732 { "SQLITE_LIMIT_EXPR_DEPTH", SQLITE_LIMIT_EXPR_DEPTH }, 4733 { "SQLITE_LIMIT_COMPOUND_SELECT", SQLITE_LIMIT_COMPOUND_SELECT }, 4734 { "SQLITE_LIMIT_VDBE_OP", SQLITE_LIMIT_VDBE_OP }, 4735 { "SQLITE_LIMIT_FUNCTION_ARG", SQLITE_LIMIT_FUNCTION_ARG }, 4736 { "SQLITE_LIMIT_ATTACHED", SQLITE_LIMIT_ATTACHED }, 4737 { "SQLITE_LIMIT_LIKE_PATTERN_LENGTH", SQLITE_LIMIT_LIKE_PATTERN_LENGTH }, 4738 { "SQLITE_LIMIT_VARIABLE_NUMBER", SQLITE_LIMIT_VARIABLE_NUMBER }, 4739 { "SQLITE_LIMIT_TRIGGER_DEPTH", SQLITE_LIMIT_TRIGGER_DEPTH }, 4740 4741 /* Out of range test cases */ 4742 { "SQLITE_LIMIT_TOOSMALL", -1, }, 4743 { "SQLITE_LIMIT_TOOBIG", SQLITE_LIMIT_TRIGGER_DEPTH+1 }, 4744 }; 4745 int i, id; 4746 int val; 4747 const char *zId; 4748 4749 if( objc!=4 ){ 4750 Tcl_AppendResult(interp, "wrong # args: should be \"", 4751 Tcl_GetStringFromObj(objv[0], 0), " DB ID VALUE", 0); 4752 return TCL_ERROR; 4753 } 4754 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; 4755 zId = Tcl_GetString(objv[2]); 4756 for(i=0; i<sizeof(aId)/sizeof(aId[0]); i++){ 4757 if( strcmp(zId, aId[i].zName)==0 ){ 4758 id = aId[i].id; 4759 break; 4760 } 4761 } 4762 if( i>=sizeof(aId)/sizeof(aId[0]) ){ 4763 Tcl_AppendResult(interp, "unknown limit type: ", zId, (char*)0); 4764 return TCL_ERROR; 4765 } 4766 if( Tcl_GetIntFromObj(interp, objv[3], &val) ) return TCL_ERROR; 4767 rc = sqlite3_limit(db, id, val); 4768 Tcl_SetObjResult(interp, Tcl_NewIntObj(rc)); 4769 return TCL_OK; 4770 } 4771 4772 /* 4773 ** tclcmd: save_prng_state 4774 ** 4775 ** Save the state of the pseudo-random number generator. 4776 ** At the same time, verify that sqlite3_test_control works even when 4777 ** called with an out-of-range opcode. 4778 */ 4779 static int save_prng_state( 4780 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4781 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4782 int objc, /* Number of arguments */ 4783 Tcl_Obj *CONST objv[] /* Command arguments */ 4784 ){ 4785 int rc = sqlite3_test_control(9999); 4786 assert( rc==0 ); 4787 rc = sqlite3_test_control(-1); 4788 assert( rc==0 ); 4789 sqlite3_test_control(SQLITE_TESTCTRL_PRNG_SAVE); 4790 return TCL_OK; 4791 } 4792 /* 4793 ** tclcmd: restore_prng_state 4794 */ 4795 static int restore_prng_state( 4796 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4797 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4798 int objc, /* Number of arguments */ 4799 Tcl_Obj *CONST objv[] /* Command arguments */ 4800 ){ 4801 sqlite3_test_control(SQLITE_TESTCTRL_PRNG_RESTORE); 4802 return TCL_OK; 4803 } 4804 /* 4805 ** tclcmd: reset_prng_state 4806 */ 4807 static int reset_prng_state( 4808 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4809 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4810 int objc, /* Number of arguments */ 4811 Tcl_Obj *CONST objv[] /* Command arguments */ 4812 ){ 4813 sqlite3_test_control(SQLITE_TESTCTRL_PRNG_RESET); 4814 return TCL_OK; 4815 } 4816 4817 /* 4818 ** tclcmd: pcache_stats 4819 */ 4820 static int test_pcache_stats( 4821 ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ 4822 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4823 int objc, /* Number of arguments */ 4824 Tcl_Obj *CONST objv[] /* Command arguments */ 4825 ){ 4826 int nMin; 4827 int nMax; 4828 int nCurrent; 4829 int nRecyclable; 4830 Tcl_Obj *pRet; 4831 4832 sqlite3PcacheStats(&nCurrent, &nMax, &nMin, &nRecyclable); 4833 4834 pRet = Tcl_NewObj(); 4835 Tcl_ListObjAppendElement(interp, pRet, Tcl_NewStringObj("current", -1)); 4836 Tcl_ListObjAppendElement(interp, pRet, Tcl_NewIntObj(nCurrent)); 4837 Tcl_ListObjAppendElement(interp, pRet, Tcl_NewStringObj("max", -1)); 4838 Tcl_ListObjAppendElement(interp, pRet, Tcl_NewIntObj(nMax)); 4839 Tcl_ListObjAppendElement(interp, pRet, Tcl_NewStringObj("min", -1)); 4840 Tcl_ListObjAppendElement(interp, pRet, Tcl_NewIntObj(nMin)); 4841 Tcl_ListObjAppendElement(interp, pRet, Tcl_NewStringObj("recyclable", -1)); 4842 Tcl_ListObjAppendElement(interp, pRet, Tcl_NewIntObj(nRecyclable)); 4843 4844 Tcl_SetObjResult(interp, pRet); 4845 4846 return TCL_OK; 4847 } 4848 4849 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY 4850 static void test_unlock_notify_cb(void **aArg, int nArg){ 4851 int ii; 4852 for(ii=0; ii<nArg; ii++){ 4853 Tcl_EvalEx((Tcl_Interp *)aArg[ii], "unlock_notify", -1, TCL_EVAL_GLOBAL); 4854 } 4855 } 4856 #endif /* SQLITE_ENABLE_UNLOCK_NOTIFY */ 4857 4858 /* 4859 ** tclcmd: sqlite3_unlock_notify db 4860 */ 4861 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY 4862 static int test_unlock_notify( 4863 ClientData clientData, /* Unused */ 4864 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4865 int objc, /* Number of arguments */ 4866 Tcl_Obj *CONST objv[] /* Command arguments */ 4867 ){ 4868 sqlite3 *db; 4869 int rc; 4870 4871 if( objc!=2 ){ 4872 Tcl_WrongNumArgs(interp, 1, objv, "DB"); 4873 return TCL_ERROR; 4874 } 4875 4876 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ){ 4877 return TCL_ERROR; 4878 } 4879 rc = sqlite3_unlock_notify(db, test_unlock_notify_cb, (void *)interp); 4880 Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); 4881 return TCL_OK; 4882 } 4883 #endif 4884 4885 /* 4886 ** tclcmd: sqlite3_wal_checkpoint db ?NAME? 4887 */ 4888 static int test_wal_checkpoint( 4889 ClientData clientData, /* Unused */ 4890 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ 4891 int objc, /* Number of arguments */ 4892 Tcl_Obj *CONST objv[] /* Command arguments */ 4893 ){ 4894 char *zDb = 0; 4895 sqlite3 *db; 4896 int rc; 4897 4898 if( objc!=3 && objc!=2 ){ 4899 Tcl_WrongNumArgs(interp, 1, objv, "DB ?NAME?"); 4900 return TCL_ERROR; 4901 } 4902 4903 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ){ 4904 return TCL_ERROR; 4905 } 4906 if( objc==3 ){ 4907 zDb = Tcl_GetString(objv[2]); 4908 } 4909 rc = sqlite3_wal_checkpoint(db, zDb); 4910 Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); 4911 return TCL_OK; 4912 } 4913 4914 4915 /* 4916 ** tcl_objproc COMMANDNAME ARGS... 4917 ** 4918 ** Run a TCL command using its objProc interface. Throw an error if 4919 ** the command has no objProc interface. 4920 */ 4921 static int runAsObjProc( 4922 void * clientData, 4923 Tcl_Interp *interp, 4924 int objc, 4925 Tcl_Obj *CONST objv[] 4926 ){ 4927 Tcl_CmdInfo cmdInfo; 4928 if( objc<2 ){ 4929 Tcl_WrongNumArgs(interp, 1, objv, "COMMAND ..."); 4930 return TCL_ERROR; 4931 } 4932 if( !Tcl_GetCommandInfo(interp, Tcl_GetString(objv[1]), &cmdInfo) ){ 4933 Tcl_AppendResult(interp, "command not found: ", 4934 Tcl_GetString(objv[1]), (char*)0); 4935 return TCL_ERROR; 4936 } 4937 if( cmdInfo.objProc==0 ){ 4938 Tcl_AppendResult(interp, "command has no objProc: ", 4939 Tcl_GetString(objv[1]), (char*)0); 4940 return TCL_ERROR; 4941 } 4942 return cmdInfo.objProc(cmdInfo.objClientData, interp, objc-1, objv+1); 4943 } 4944 4945 4946 /* 4947 ** Register commands with the TCL interpreter. 4948 */ 4949 int Sqlitetest1_Init(Tcl_Interp *interp){ 4950 extern int sqlite3_search_count; 4951 extern int sqlite3_found_count; 4952 extern int sqlite3_interrupt_count; 4953 extern int sqlite3_open_file_count; 4954 extern int sqlite3_sort_count; 4955 extern int sqlite3_current_time; 4956 #if SQLITE_OS_UNIX && defined(__APPLE__) && SQLITE_ENABLE_LOCKING_STYLE 4957 extern int sqlite3_hostid_num; 4958 #endif 4959 extern int sqlite3_max_blobsize; 4960 extern int sqlite3BtreeSharedCacheReport(void*, 4961 Tcl_Interp*,int,Tcl_Obj*CONST*); 4962 static struct { 4963 char *zName; 4964 Tcl_CmdProc *xProc; 4965 } aCmd[] = { 4966 { "db_enter", (Tcl_CmdProc*)db_enter }, 4967 { "db_leave", (Tcl_CmdProc*)db_leave }, 4968 { "sqlite3_mprintf_int", (Tcl_CmdProc*)sqlite3_mprintf_int }, 4969 { "sqlite3_mprintf_int64", (Tcl_CmdProc*)sqlite3_mprintf_int64 }, 4970 { "sqlite3_mprintf_long", (Tcl_CmdProc*)sqlite3_mprintf_long }, 4971 { "sqlite3_mprintf_str", (Tcl_CmdProc*)sqlite3_mprintf_str }, 4972 { "sqlite3_snprintf_str", (Tcl_CmdProc*)sqlite3_snprintf_str }, 4973 { "sqlite3_mprintf_stronly", (Tcl_CmdProc*)sqlite3_mprintf_stronly}, 4974 { "sqlite3_mprintf_double", (Tcl_CmdProc*)sqlite3_mprintf_double }, 4975 { "sqlite3_mprintf_scaled", (Tcl_CmdProc*)sqlite3_mprintf_scaled }, 4976 { "sqlite3_mprintf_hexdouble", (Tcl_CmdProc*)sqlite3_mprintf_hexdouble}, 4977 { "sqlite3_mprintf_z_test", (Tcl_CmdProc*)test_mprintf_z }, 4978 { "sqlite3_mprintf_n_test", (Tcl_CmdProc*)test_mprintf_n }, 4979 { "sqlite3_snprintf_int", (Tcl_CmdProc*)test_snprintf_int }, 4980 { "sqlite3_last_insert_rowid", (Tcl_CmdProc*)test_last_rowid }, 4981 { "sqlite3_exec_printf", (Tcl_CmdProc*)test_exec_printf }, 4982 { "sqlite3_exec_hex", (Tcl_CmdProc*)test_exec_hex }, 4983 { "sqlite3_exec", (Tcl_CmdProc*)test_exec }, 4984 { "sqlite3_exec_nr", (Tcl_CmdProc*)test_exec_nr }, 4985 #ifndef SQLITE_OMIT_GET_TABLE 4986 { "sqlite3_get_table_printf", (Tcl_CmdProc*)test_get_table_printf }, 4987 #endif 4988 { "sqlite3_close", (Tcl_CmdProc*)sqlite_test_close }, 4989 { "sqlite3_create_function", (Tcl_CmdProc*)test_create_function }, 4990 { "sqlite3_create_aggregate", (Tcl_CmdProc*)test_create_aggregate }, 4991 { "sqlite_register_test_function", (Tcl_CmdProc*)test_register_func }, 4992 { "sqlite_abort", (Tcl_CmdProc*)sqlite_abort }, 4993 { "sqlite_bind", (Tcl_CmdProc*)test_bind }, 4994 { "breakpoint", (Tcl_CmdProc*)test_breakpoint }, 4995 { "sqlite3_key", (Tcl_CmdProc*)test_key }, 4996 { "sqlite3_rekey", (Tcl_CmdProc*)test_rekey }, 4997 { "sqlite_set_magic", (Tcl_CmdProc*)sqlite_set_magic }, 4998 { "sqlite3_interrupt", (Tcl_CmdProc*)test_interrupt }, 4999 { "sqlite_delete_function", (Tcl_CmdProc*)delete_function }, 5000 { "sqlite_delete_collation", (Tcl_CmdProc*)delete_collation }, 5001 { "sqlite3_get_autocommit", (Tcl_CmdProc*)get_autocommit }, 5002 { "sqlite3_stack_used", (Tcl_CmdProc*)test_stack_used }, 5003 { "sqlite3_busy_timeout", (Tcl_CmdProc*)test_busy_timeout }, 5004 { "printf", (Tcl_CmdProc*)test_printf }, 5005 { "sqlite3IoTrace", (Tcl_CmdProc*)test_io_trace }, 5006 }; 5007 static struct { 5008 char *zName; 5009 Tcl_ObjCmdProc *xProc; 5010 void *clientData; 5011 } aObjCmd[] = { 5012 { "sqlite3_connection_pointer", get_sqlite_pointer, 0 }, 5013 { "sqlite3_bind_int", test_bind_int, 0 }, 5014 { "sqlite3_bind_zeroblob", test_bind_zeroblob, 0 }, 5015 { "sqlite3_bind_int64", test_bind_int64, 0 }, 5016 { "sqlite3_bind_double", test_bind_double, 0 }, 5017 { "sqlite3_bind_null", test_bind_null ,0 }, 5018 { "sqlite3_bind_text", test_bind_text ,0 }, 5019 { "sqlite3_bind_text16", test_bind_text16 ,0 }, 5020 { "sqlite3_bind_blob", test_bind_blob ,0 }, 5021 { "sqlite3_bind_parameter_count", test_bind_parameter_count, 0}, 5022 { "sqlite3_bind_parameter_name", test_bind_parameter_name, 0}, 5023 { "sqlite3_bind_parameter_index", test_bind_parameter_index, 0}, 5024 { "sqlite3_clear_bindings", test_clear_bindings, 0}, 5025 { "sqlite3_sleep", test_sleep, 0}, 5026 { "sqlite3_errcode", test_errcode ,0 }, 5027 { "sqlite3_extended_errcode", test_ex_errcode ,0 }, 5028 { "sqlite3_errmsg", test_errmsg ,0 }, 5029 { "sqlite3_errmsg16", test_errmsg16 ,0 }, 5030 { "sqlite3_open", test_open ,0 }, 5031 { "sqlite3_open16", test_open16 ,0 }, 5032 { "sqlite3_complete16", test_complete16 ,0 }, 5033 5034 { "sqlite3_prepare", test_prepare ,0 }, 5035 { "sqlite3_prepare16", test_prepare16 ,0 }, 5036 { "sqlite3_prepare_v2", test_prepare_v2 ,0 }, 5037 { "sqlite3_prepare_tkt3134", test_prepare_tkt3134, 0}, 5038 { "sqlite3_prepare16_v2", test_prepare16_v2 ,0 }, 5039 { "sqlite3_finalize", test_finalize ,0 }, 5040 { "sqlite3_stmt_status", test_stmt_status ,0 }, 5041 { "sqlite3_reset", test_reset ,0 }, 5042 { "sqlite3_expired", test_expired ,0 }, 5043 { "sqlite3_transfer_bindings", test_transfer_bind ,0 }, 5044 { "sqlite3_changes", test_changes ,0 }, 5045 { "sqlite3_step", test_step ,0 }, 5046 { "sqlite3_sql", test_sql ,0 }, 5047 { "sqlite3_next_stmt", test_next_stmt ,0 }, 5048 5049 { "sqlite3_release_memory", test_release_memory, 0}, 5050 { "sqlite3_soft_heap_limit", test_soft_heap_limit, 0}, 5051 { "sqlite3_thread_cleanup", test_thread_cleanup, 0}, 5052 { "sqlite3_pager_refcounts", test_pager_refcounts, 0}, 5053 5054 { "sqlite3_load_extension", test_load_extension, 0}, 5055 { "sqlite3_enable_load_extension", test_enable_load, 0}, 5056 { "sqlite3_extended_result_codes", test_extended_result_codes, 0}, 5057 { "sqlite3_limit", test_limit, 0}, 5058 5059 { "save_prng_state", save_prng_state, 0 }, 5060 { "restore_prng_state", restore_prng_state, 0 }, 5061 { "reset_prng_state", reset_prng_state, 0 }, 5062 { "tcl_objproc", runAsObjProc, 0 }, 5063 5064 /* sqlite3_column_*() API */ 5065 { "sqlite3_column_count", test_column_count ,0 }, 5066 { "sqlite3_data_count", test_data_count ,0 }, 5067 { "sqlite3_column_type", test_column_type ,0 }, 5068 { "sqlite3_column_blob", test_column_blob ,0 }, 5069 { "sqlite3_column_double", test_column_double ,0 }, 5070 { "sqlite3_column_int64", test_column_int64 ,0 }, 5071 { "sqlite3_column_text", test_stmt_utf8, (void*)sqlite3_column_text }, 5072 { "sqlite3_column_name", test_stmt_utf8, (void*)sqlite3_column_name }, 5073 { "sqlite3_column_int", test_stmt_int, (void*)sqlite3_column_int }, 5074 { "sqlite3_column_bytes", test_stmt_int, (void*)sqlite3_column_bytes}, 5075 #ifndef SQLITE_OMIT_DECLTYPE 5076 { "sqlite3_column_decltype",test_stmt_utf8,(void*)sqlite3_column_decltype}, 5077 #endif 5078 #ifdef SQLITE_ENABLE_COLUMN_METADATA 5079 { "sqlite3_column_database_name",test_stmt_utf8,(void*)sqlite3_column_database_name}, 5080 { "sqlite3_column_table_name",test_stmt_utf8,(void*)sqlite3_column_table_name}, 5081 { "sqlite3_column_origin_name",test_stmt_utf8,(void*)sqlite3_column_origin_name}, 5082 #endif 5083 5084 #ifndef SQLITE_OMIT_UTF16 5085 { "sqlite3_column_bytes16", test_stmt_int, (void*)sqlite3_column_bytes16 }, 5086 { "sqlite3_column_text16", test_stmt_utf16, (void*)sqlite3_column_text16}, 5087 { "sqlite3_column_name16", test_stmt_utf16, (void*)sqlite3_column_name16}, 5088 { "add_alignment_test_collations", add_alignment_test_collations, 0 }, 5089 #ifndef SQLITE_OMIT_DECLTYPE 5090 { "sqlite3_column_decltype16",test_stmt_utf16,(void*)sqlite3_column_decltype16}, 5091 #endif 5092 #ifdef SQLITE_ENABLE_COLUMN_METADATA 5093 {"sqlite3_column_database_name16", 5094 test_stmt_utf16, sqlite3_column_database_name16}, 5095 {"sqlite3_column_table_name16", test_stmt_utf16, (void*)sqlite3_column_table_name16}, 5096 {"sqlite3_column_origin_name16", test_stmt_utf16, (void*)sqlite3_column_origin_name16}, 5097 #endif 5098 #endif 5099 { "sqlite3_create_collation_v2", test_create_collation_v2, 0 }, 5100 { "sqlite3_global_recover", test_global_recover, 0 }, 5101 { "working_64bit_int", working_64bit_int, 0 }, 5102 { "vfs_unlink_test", vfs_unlink_test, 0 }, 5103 { "vfs_initfail_test", vfs_initfail_test, 0 }, 5104 { "vfs_unregister_all", vfs_unregister_all, 0 }, 5105 { "vfs_reregister_all", vfs_reregister_all, 0 }, 5106 { "file_control_test", file_control_test, 0 }, 5107 { "file_control_lasterrno_test", file_control_lasterrno_test, 0 }, 5108 { "file_control_lockproxy_test", file_control_lockproxy_test, 0 }, 5109 { "sqlite3_vfs_list", vfs_list, 0 }, 5110 5111 /* Functions from os.h */ 5112 #ifndef SQLITE_OMIT_UTF16 5113 { "add_test_collate", test_collate, 0 }, 5114 { "add_test_collate_needed", test_collate_needed, 0 }, 5115 { "add_test_function", test_function, 0 }, 5116 #endif 5117 { "sqlite3_test_errstr", test_errstr, 0 }, 5118 { "tcl_variable_type", tcl_variable_type, 0 }, 5119 #ifndef SQLITE_OMIT_SHARED_CACHE 5120 { "sqlite3_enable_shared_cache", test_enable_shared, 0 }, 5121 { "sqlite3_shared_cache_report", sqlite3BtreeSharedCacheReport, 0}, 5122 #endif 5123 { "sqlite3_libversion_number", test_libversion_number, 0 }, 5124 #ifdef SQLITE_ENABLE_COLUMN_METADATA 5125 { "sqlite3_table_column_metadata", test_table_column_metadata, 0 }, 5126 #endif 5127 #ifndef SQLITE_OMIT_INCRBLOB 5128 { "sqlite3_blob_read", test_blob_read, 0 }, 5129 { "sqlite3_blob_write", test_blob_write, 0 }, 5130 #endif 5131 { "pcache_stats", test_pcache_stats, 0 }, 5132 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY 5133 { "sqlite3_unlock_notify", test_unlock_notify, 0 }, 5134 #endif 5135 { "sqlite3_wal_checkpoint", test_wal_checkpoint, 0 }, 5136 }; 5137 static int bitmask_size = sizeof(Bitmask)*8; 5138 int i; 5139 extern int sqlite3_sync_count, sqlite3_fullsync_count; 5140 extern int sqlite3_opentemp_count; 5141 extern int sqlite3_like_count; 5142 extern int sqlite3_xferopt_count; 5143 extern int sqlite3_pager_readdb_count; 5144 extern int sqlite3_pager_writedb_count; 5145 extern int sqlite3_pager_writej_count; 5146 #if SQLITE_OS_WIN 5147 extern int sqlite3_os_type; 5148 #endif 5149 #ifdef SQLITE_DEBUG 5150 extern int sqlite3WhereTrace; 5151 extern int sqlite3OSTrace; 5152 extern int sqlite3VdbeAddopTrace; 5153 extern int sqlite3WalTrace; 5154 #endif 5155 #ifdef SQLITE_TEST 5156 extern char sqlite3_query_plan[]; 5157 static char *query_plan = sqlite3_query_plan; 5158 #ifdef SQLITE_ENABLE_FTS3 5159 extern int sqlite3_fts3_enable_parentheses; 5160 #endif 5161 #endif 5162 5163 for(i=0; i<sizeof(aCmd)/sizeof(aCmd[0]); i++){ 5164 Tcl_CreateCommand(interp, aCmd[i].zName, aCmd[i].xProc, 0, 0); 5165 } 5166 for(i=0; i<sizeof(aObjCmd)/sizeof(aObjCmd[0]); i++){ 5167 Tcl_CreateObjCommand(interp, aObjCmd[i].zName, 5168 aObjCmd[i].xProc, aObjCmd[i].clientData, 0); 5169 } 5170 Tcl_LinkVar(interp, "sqlite_search_count", 5171 (char*)&sqlite3_search_count, TCL_LINK_INT); 5172 Tcl_LinkVar(interp, "sqlite_found_count", 5173 (char*)&sqlite3_found_count, TCL_LINK_INT); 5174 Tcl_LinkVar(interp, "sqlite_sort_count", 5175 (char*)&sqlite3_sort_count, TCL_LINK_INT); 5176 Tcl_LinkVar(interp, "sqlite3_max_blobsize", 5177 (char*)&sqlite3_max_blobsize, TCL_LINK_INT); 5178 Tcl_LinkVar(interp, "sqlite_like_count", 5179 (char*)&sqlite3_like_count, TCL_LINK_INT); 5180 Tcl_LinkVar(interp, "sqlite_interrupt_count", 5181 (char*)&sqlite3_interrupt_count, TCL_LINK_INT); 5182 Tcl_LinkVar(interp, "sqlite_open_file_count", 5183 (char*)&sqlite3_open_file_count, TCL_LINK_INT); 5184 Tcl_LinkVar(interp, "sqlite_current_time", 5185 (char*)&sqlite3_current_time, TCL_LINK_INT); 5186 #if SQLITE_OS_UNIX && defined(__APPLE__) && SQLITE_ENABLE_LOCKING_STYLE 5187 Tcl_LinkVar(interp, "sqlite_hostid_num", 5188 (char*)&sqlite3_hostid_num, TCL_LINK_INT); 5189 #endif 5190 Tcl_LinkVar(interp, "sqlite3_xferopt_count", 5191 (char*)&sqlite3_xferopt_count, TCL_LINK_INT); 5192 Tcl_LinkVar(interp, "sqlite3_pager_readdb_count", 5193 (char*)&sqlite3_pager_readdb_count, TCL_LINK_INT); 5194 Tcl_LinkVar(interp, "sqlite3_pager_writedb_count", 5195 (char*)&sqlite3_pager_writedb_count, TCL_LINK_INT); 5196 Tcl_LinkVar(interp, "sqlite3_pager_writej_count", 5197 (char*)&sqlite3_pager_writej_count, TCL_LINK_INT); 5198 #ifndef SQLITE_OMIT_UTF16 5199 Tcl_LinkVar(interp, "unaligned_string_counter", 5200 (char*)&unaligned_string_counter, TCL_LINK_INT); 5201 #endif 5202 #ifndef SQLITE_OMIT_UTF16 5203 Tcl_LinkVar(interp, "sqlite_last_needed_collation", 5204 (char*)&pzNeededCollation, TCL_LINK_STRING|TCL_LINK_READ_ONLY); 5205 #endif 5206 #if SQLITE_OS_WIN 5207 Tcl_LinkVar(interp, "sqlite_os_type", 5208 (char*)&sqlite3_os_type, TCL_LINK_INT); 5209 #endif 5210 #ifdef SQLITE_TEST 5211 Tcl_LinkVar(interp, "sqlite_query_plan", 5212 (char*)&query_plan, TCL_LINK_STRING|TCL_LINK_READ_ONLY); 5213 #endif 5214 #ifdef SQLITE_DEBUG 5215 Tcl_LinkVar(interp, "sqlite_addop_trace", 5216 (char*)&sqlite3VdbeAddopTrace, TCL_LINK_INT); 5217 Tcl_LinkVar(interp, "sqlite_where_trace", 5218 (char*)&sqlite3WhereTrace, TCL_LINK_INT); 5219 Tcl_LinkVar(interp, "sqlite_os_trace", 5220 (char*)&sqlite3OSTrace, TCL_LINK_INT); 5221 #ifndef SQLITE_OMIT_WAL 5222 Tcl_LinkVar(interp, "sqlite_wal_trace", 5223 (char*)&sqlite3WalTrace, TCL_LINK_INT); 5224 #endif 5225 #endif 5226 #ifndef SQLITE_OMIT_DISKIO 5227 Tcl_LinkVar(interp, "sqlite_opentemp_count", 5228 (char*)&sqlite3_opentemp_count, TCL_LINK_INT); 5229 #endif 5230 Tcl_LinkVar(interp, "sqlite_static_bind_value", 5231 (char*)&sqlite_static_bind_value, TCL_LINK_STRING); 5232 Tcl_LinkVar(interp, "sqlite_static_bind_nbyte", 5233 (char*)&sqlite_static_bind_nbyte, TCL_LINK_INT); 5234 Tcl_LinkVar(interp, "sqlite_temp_directory", 5235 (char*)&sqlite3_temp_directory, TCL_LINK_STRING); 5236 Tcl_LinkVar(interp, "bitmask_size", 5237 (char*)&bitmask_size, TCL_LINK_INT|TCL_LINK_READ_ONLY); 5238 Tcl_LinkVar(interp, "sqlite_sync_count", 5239 (char*)&sqlite3_sync_count, TCL_LINK_INT); 5240 Tcl_LinkVar(interp, "sqlite_fullsync_count", 5241 (char*)&sqlite3_fullsync_count, TCL_LINK_INT); 5242 #if defined(SQLITE_ENABLE_FTS3) && defined(SQLITE_TEST) 5243 Tcl_LinkVar(interp, "sqlite_fts3_enable_parentheses", 5244 (char*)&sqlite3_fts3_enable_parentheses, TCL_LINK_INT); 5245 #endif 5246 return TCL_OK; 5247 } 5248