| /* |
| ** 2001 September 15 |
| ** |
| ** The author disclaims copyright to this source code. In place of |
| ** a legal notice, here is a blessing: |
| ** |
| ** May you do good and not evil. |
| ** May you find forgiveness for yourself and forgive others. |
| ** May you share freely, never taking more than you give. |
| ** |
| ************************************************************************* |
| ** Code for testing all sorts of SQLite interfaces. This code |
| ** is not included in the SQLite library. It is used for automated |
| ** testing of the SQLite library. |
| */ |
| #include "sqliteInt.h" |
| #include "tcl.h" |
| #include <stdlib.h> |
| #include <string.h> |
| |
| /* |
| ** This is a copy of the first part of the SqliteDb structure in |
| ** tclsqlite.c. We need it here so that the get_sqlite_pointer routine |
| ** can extract the sqlite3* pointer from an existing Tcl SQLite |
| ** connection. |
| */ |
| struct SqliteDb { |
| sqlite3 *db; |
| }; |
| |
| /* |
| ** Convert text generated by the "%p" conversion format back into |
| ** a pointer. |
| */ |
| static int testHexToInt(int h){ |
| if( h>='0' && h<='9' ){ |
| return h - '0'; |
| }else if( h>='a' && h<='f' ){ |
| return h - 'a' + 10; |
| }else{ |
| assert( h>='A' && h<='F' ); |
| return h - 'A' + 10; |
| } |
| } |
| void *sqlite3TestTextToPtr(const char *z){ |
| void *p; |
| u64 v; |
| u32 v2; |
| if( z[0]=='0' && z[1]=='x' ){ |
| z += 2; |
| } |
| v = 0; |
| while( *z ){ |
| v = (v<<4) + testHexToInt(*z); |
| z++; |
| } |
| if( sizeof(p)==sizeof(v) ){ |
| memcpy(&p, &v, sizeof(p)); |
| }else{ |
| assert( sizeof(p)==sizeof(v2) ); |
| v2 = (u32)v; |
| memcpy(&p, &v2, sizeof(p)); |
| } |
| return p; |
| } |
| |
| |
| /* |
| ** A TCL command that returns the address of the sqlite* pointer |
| ** for an sqlite connection instance. Bad things happen if the |
| ** input is not an sqlite connection. |
| */ |
| static int get_sqlite_pointer( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| struct SqliteDb *p; |
| Tcl_CmdInfo cmdInfo; |
| char zBuf[100]; |
| if( objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "SQLITE-CONNECTION"); |
| return TCL_ERROR; |
| } |
| if( !Tcl_GetCommandInfo(interp, Tcl_GetString(objv[1]), &cmdInfo) ){ |
| Tcl_AppendResult(interp, "command not found: ", |
| Tcl_GetString(objv[1]), (char*)0); |
| return TCL_ERROR; |
| } |
| p = (struct SqliteDb*)cmdInfo.objClientData; |
| sprintf(zBuf, "%p", p->db); |
| if( strncmp(zBuf,"0x",2) ){ |
| sprintf(zBuf, "0x%p", p->db); |
| } |
| Tcl_AppendResult(interp, zBuf, 0); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Decode a pointer to an sqlite3 object. |
| */ |
| int getDbPointer(Tcl_Interp *interp, const char *zA, sqlite3 **ppDb){ |
| struct SqliteDb *p; |
| Tcl_CmdInfo cmdInfo; |
| if( Tcl_GetCommandInfo(interp, zA, &cmdInfo) ){ |
| p = (struct SqliteDb*)cmdInfo.objClientData; |
| *ppDb = p->db; |
| }else{ |
| *ppDb = (sqlite3*)sqlite3TestTextToPtr(zA); |
| } |
| return TCL_OK; |
| } |
| |
| |
| const char *sqlite3TestErrorName(int rc){ |
| const char *zName = 0; |
| switch( rc ){ |
| case SQLITE_OK: zName = "SQLITE_OK"; break; |
| case SQLITE_ERROR: zName = "SQLITE_ERROR"; break; |
| case SQLITE_INTERNAL: zName = "SQLITE_INTERNAL"; break; |
| case SQLITE_PERM: zName = "SQLITE_PERM"; break; |
| case SQLITE_ABORT: zName = "SQLITE_ABORT"; break; |
| case SQLITE_BUSY: zName = "SQLITE_BUSY"; break; |
| case SQLITE_LOCKED: zName = "SQLITE_LOCKED"; break; |
| case SQLITE_LOCKED_SHAREDCACHE: zName = "SQLITE_LOCKED_SHAREDCACHE";break; |
| case SQLITE_NOMEM: zName = "SQLITE_NOMEM"; break; |
| case SQLITE_READONLY: zName = "SQLITE_READONLY"; break; |
| case SQLITE_INTERRUPT: zName = "SQLITE_INTERRUPT"; break; |
| case SQLITE_IOERR: zName = "SQLITE_IOERR"; break; |
| case SQLITE_CORRUPT: zName = "SQLITE_CORRUPT"; break; |
| case SQLITE_NOTFOUND: zName = "SQLITE_NOTFOUND"; break; |
| case SQLITE_FULL: zName = "SQLITE_FULL"; break; |
| case SQLITE_CANTOPEN: zName = "SQLITE_CANTOPEN"; break; |
| case SQLITE_PROTOCOL: zName = "SQLITE_PROTOCOL"; break; |
| case SQLITE_EMPTY: zName = "SQLITE_EMPTY"; break; |
| case SQLITE_SCHEMA: zName = "SQLITE_SCHEMA"; break; |
| case SQLITE_TOOBIG: zName = "SQLITE_TOOBIG"; break; |
| case SQLITE_CONSTRAINT: zName = "SQLITE_CONSTRAINT"; break; |
| case SQLITE_MISMATCH: zName = "SQLITE_MISMATCH"; break; |
| case SQLITE_MISUSE: zName = "SQLITE_MISUSE"; break; |
| case SQLITE_NOLFS: zName = "SQLITE_NOLFS"; break; |
| case SQLITE_AUTH: zName = "SQLITE_AUTH"; break; |
| case SQLITE_FORMAT: zName = "SQLITE_FORMAT"; break; |
| case SQLITE_RANGE: zName = "SQLITE_RANGE"; break; |
| case SQLITE_NOTADB: zName = "SQLITE_NOTADB"; break; |
| case SQLITE_ROW: zName = "SQLITE_ROW"; break; |
| case SQLITE_DONE: zName = "SQLITE_DONE"; break; |
| case SQLITE_IOERR_READ: zName = "SQLITE_IOERR_READ"; break; |
| case SQLITE_IOERR_SHORT_READ: zName = "SQLITE_IOERR_SHORT_READ"; break; |
| case SQLITE_IOERR_WRITE: zName = "SQLITE_IOERR_WRITE"; break; |
| case SQLITE_IOERR_FSYNC: zName = "SQLITE_IOERR_FSYNC"; break; |
| case SQLITE_IOERR_DIR_FSYNC: zName = "SQLITE_IOERR_DIR_FSYNC"; break; |
| case SQLITE_IOERR_TRUNCATE: zName = "SQLITE_IOERR_TRUNCATE"; break; |
| case SQLITE_IOERR_FSTAT: zName = "SQLITE_IOERR_FSTAT"; break; |
| case SQLITE_IOERR_UNLOCK: zName = "SQLITE_IOERR_UNLOCK"; break; |
| case SQLITE_IOERR_RDLOCK: zName = "SQLITE_IOERR_RDLOCK"; break; |
| case SQLITE_IOERR_DELETE: zName = "SQLITE_IOERR_DELETE"; break; |
| case SQLITE_IOERR_BLOCKED: zName = "SQLITE_IOERR_BLOCKED"; break; |
| case SQLITE_IOERR_NOMEM: zName = "SQLITE_IOERR_NOMEM"; break; |
| case SQLITE_IOERR_ACCESS: zName = "SQLITE_IOERR_ACCESS"; break; |
| case SQLITE_IOERR_CHECKRESERVEDLOCK: |
| zName = "SQLITE_IOERR_CHECKRESERVEDLOCK"; break; |
| case SQLITE_IOERR_LOCK: zName = "SQLITE_IOERR_LOCK"; break; |
| default: zName = "SQLITE_Unknown"; break; |
| } |
| return zName; |
| } |
| #define t1ErrorName sqlite3TestErrorName |
| |
| /* |
| ** Convert an sqlite3_stmt* into an sqlite3*. This depends on the |
| ** fact that the sqlite3* is the first field in the Vdbe structure. |
| */ |
| #define StmtToDb(X) sqlite3_db_handle(X) |
| |
| /* |
| ** Check a return value to make sure it agrees with the results |
| ** from sqlite3_errcode. |
| */ |
| int sqlite3TestErrCode(Tcl_Interp *interp, sqlite3 *db, int rc){ |
| if( sqlite3_threadsafe()==0 && rc!=SQLITE_MISUSE && rc!=SQLITE_OK |
| && sqlite3_errcode(db)!=rc ){ |
| char zBuf[200]; |
| int r2 = sqlite3_errcode(db); |
| sprintf(zBuf, "error code %s (%d) does not match sqlite3_errcode %s (%d)", |
| t1ErrorName(rc), rc, t1ErrorName(r2), r2); |
| Tcl_ResetResult(interp); |
| Tcl_AppendResult(interp, zBuf, 0); |
| return 1; |
| } |
| return 0; |
| } |
| |
| /* |
| ** Decode a pointer to an sqlite3_stmt object. |
| */ |
| static int getStmtPointer( |
| Tcl_Interp *interp, |
| const char *zArg, |
| sqlite3_stmt **ppStmt |
| ){ |
| *ppStmt = (sqlite3_stmt*)sqlite3TestTextToPtr(zArg); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Generate a text representation of a pointer that can be understood |
| ** by the getDbPointer and getVmPointer routines above. |
| ** |
| ** The problem is, on some machines (Solaris) if you do a printf with |
| ** "%p" you cannot turn around and do a scanf with the same "%p" and |
| ** get your pointer back. You have to prepend a "0x" before it will |
| ** work. Or at least that is what is reported to me (drh). But this |
| ** behavior varies from machine to machine. The solution used her is |
| ** to test the string right after it is generated to see if it can be |
| ** understood by scanf, and if not, try prepending an "0x" to see if |
| ** that helps. If nothing works, a fatal error is generated. |
| */ |
| int sqlite3TestMakePointerStr(Tcl_Interp *interp, char *zPtr, void *p){ |
| sqlite3_snprintf(100, zPtr, "%p", p); |
| return TCL_OK; |
| } |
| |
| /* |
| ** The callback routine for sqlite3_exec_printf(). |
| */ |
| static int exec_printf_cb(void *pArg, int argc, char **argv, char **name){ |
| Tcl_DString *str = (Tcl_DString*)pArg; |
| int i; |
| |
| if( Tcl_DStringLength(str)==0 ){ |
| for(i=0; i<argc; i++){ |
| Tcl_DStringAppendElement(str, name[i] ? name[i] : "NULL"); |
| } |
| } |
| for(i=0; i<argc; i++){ |
| Tcl_DStringAppendElement(str, argv[i] ? argv[i] : "NULL"); |
| } |
| return 0; |
| } |
| |
| /* |
| ** The I/O tracing callback. |
| */ |
| #if !defined(SQLITE_OMIT_TRACE) && defined(SQLITE_ENABLE_IOTRACE) |
| static FILE *iotrace_file = 0; |
| static void io_trace_callback(const char *zFormat, ...){ |
| va_list ap; |
| va_start(ap, zFormat); |
| vfprintf(iotrace_file, zFormat, ap); |
| va_end(ap); |
| fflush(iotrace_file); |
| } |
| #endif |
| |
| /* |
| ** Usage: io_trace FILENAME |
| ** |
| ** Turn I/O tracing on or off. If FILENAME is not an empty string, |
| ** I/O tracing begins going into FILENAME. If FILENAME is an empty |
| ** string, I/O tracing is turned off. |
| */ |
| static int test_io_trace( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| #if !defined(SQLITE_OMIT_TRACE) && defined(SQLITE_ENABLE_IOTRACE) |
| if( argc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FILENAME\"", 0); |
| return TCL_ERROR; |
| } |
| if( iotrace_file ){ |
| if( iotrace_file!=stdout && iotrace_file!=stderr ){ |
| fclose(iotrace_file); |
| } |
| iotrace_file = 0; |
| sqlite3IoTrace = 0; |
| } |
| if( argv[1][0] ){ |
| if( strcmp(argv[1],"stdout")==0 ){ |
| iotrace_file = stdout; |
| }else if( strcmp(argv[1],"stderr")==0 ){ |
| iotrace_file = stderr; |
| }else{ |
| iotrace_file = fopen(argv[1], "w"); |
| } |
| sqlite3IoTrace = io_trace_callback; |
| } |
| #endif |
| return TCL_OK; |
| } |
| |
| |
| /* |
| ** Usage: sqlite3_exec_printf DB FORMAT STRING |
| ** |
| ** Invoke the sqlite3_exec_printf() interface using the open database |
| ** DB. The SQL is the string FORMAT. The format string should contain |
| ** one %s or %q. STRING is the value inserted into %s or %q. |
| */ |
| static int test_exec_printf( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| Tcl_DString str; |
| int rc; |
| char *zErr = 0; |
| char *zSql; |
| char zBuf[30]; |
| if( argc!=4 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB FORMAT STRING", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| Tcl_DStringInit(&str); |
| zSql = sqlite3_mprintf(argv[2], argv[3]); |
| rc = sqlite3_exec(db, zSql, exec_printf_cb, &str, &zErr); |
| sqlite3_free(zSql); |
| sprintf(zBuf, "%d", rc); |
| Tcl_AppendElement(interp, zBuf); |
| Tcl_AppendElement(interp, rc==SQLITE_OK ? Tcl_DStringValue(&str) : zErr); |
| Tcl_DStringFree(&str); |
| if( zErr ) sqlite3_free(zErr); |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_exec_hex DB HEX |
| ** |
| ** Invoke the sqlite3_exec() on a string that is obtained by translating |
| ** HEX into ASCII. Most characters are translated as is. %HH becomes |
| ** a hex character. |
| */ |
| static int test_exec_hex( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| Tcl_DString str; |
| int rc, i, j; |
| char *zErr = 0; |
| char *zHex; |
| char zSql[500]; |
| char zBuf[30]; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB HEX", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| zHex = argv[2]; |
| for(i=j=0; i<sizeof(zSql) && zHex[j]; i++, j++){ |
| if( zHex[j]=='%' && zHex[j+2] && zHex[j+2] ){ |
| zSql[i] = (testHexToInt(zHex[j+1])<<4) + testHexToInt(zHex[j+2]); |
| j += 2; |
| }else{ |
| zSql[i] = zHex[j]; |
| } |
| } |
| zSql[i] = 0; |
| Tcl_DStringInit(&str); |
| rc = sqlite3_exec(db, zSql, exec_printf_cb, &str, &zErr); |
| sprintf(zBuf, "%d", rc); |
| Tcl_AppendElement(interp, zBuf); |
| Tcl_AppendElement(interp, rc==SQLITE_OK ? Tcl_DStringValue(&str) : zErr); |
| Tcl_DStringFree(&str); |
| if( zErr ) sqlite3_free(zErr); |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: db_enter DB |
| ** db_leave DB |
| ** |
| ** Enter or leave the mutex on a database connection. |
| */ |
| static int db_enter( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| if( argc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| sqlite3_mutex_enter(db->mutex); |
| return TCL_OK; |
| } |
| static int db_leave( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| if( argc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| sqlite3_mutex_leave(db->mutex); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_exec DB SQL |
| ** |
| ** Invoke the sqlite3_exec interface using the open database DB |
| */ |
| static int test_exec( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| Tcl_DString str; |
| int rc; |
| char *zErr = 0; |
| char *zSql; |
| int i, j; |
| char zBuf[30]; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB SQL", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| Tcl_DStringInit(&str); |
| zSql = sqlite3_mprintf("%s", argv[2]); |
| for(i=j=0; zSql[i];){ |
| if( zSql[i]=='%' ){ |
| zSql[j++] = (testHexToInt(zSql[i+1])<<4) + testHexToInt(zSql[i+2]); |
| i += 3; |
| }else{ |
| zSql[j++] = zSql[i++]; |
| } |
| } |
| zSql[j] = 0; |
| rc = sqlite3_exec(db, zSql, exec_printf_cb, &str, &zErr); |
| sqlite3_free(zSql); |
| sprintf(zBuf, "%d", rc); |
| Tcl_AppendElement(interp, zBuf); |
| Tcl_AppendElement(interp, rc==SQLITE_OK ? Tcl_DStringValue(&str) : zErr); |
| Tcl_DStringFree(&str); |
| if( zErr ) sqlite3_free(zErr); |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_exec_nr DB SQL |
| ** |
| ** Invoke the sqlite3_exec interface using the open database DB. Discard |
| ** all results |
| */ |
| static int test_exec_nr( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| int rc; |
| char *zErr = 0; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB SQL", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| rc = sqlite3_exec(db, argv[2], 0, 0, &zErr); |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_mprintf_z_test SEPARATOR ARG0 ARG1 ... |
| ** |
| ** Test the %z format of sqlite_mprintf(). Use multiple mprintf() calls to |
| ** concatenate arg0 through argn using separator as the separator. |
| ** Return the result. |
| */ |
| static int test_mprintf_z( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| char *zResult = 0; |
| int i; |
| |
| for(i=2; i<argc && (i==2 || zResult); i++){ |
| zResult = sqlite3_mprintf("%z%s%s", zResult, argv[1], argv[i]); |
| } |
| Tcl_AppendResult(interp, zResult, 0); |
| sqlite3_free(zResult); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_mprintf_n_test STRING |
| ** |
| ** Test the %n format of sqlite_mprintf(). Return the length of the |
| ** input string. |
| */ |
| static int test_mprintf_n( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| char *zStr; |
| int n = 0; |
| zStr = sqlite3_mprintf("%s%n", argv[1], &n); |
| sqlite3_free(zStr); |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(n)); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_snprintf_int SIZE FORMAT INT |
| ** |
| ** Test the of sqlite3_snprintf() routine. SIZE is the size of the |
| ** output buffer in bytes. The maximum size is 100. FORMAT is the |
| ** format string. INT is a single integer argument. The FORMAT |
| ** string must require no more than this one integer argument. If |
| ** You pass in a format string that requires more than one argument, |
| ** bad things will happen. |
| */ |
| static int test_snprintf_int( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| char zStr[100]; |
| int n = atoi(argv[1]); |
| const char *zFormat = argv[2]; |
| int a1 = atoi(argv[3]); |
| if( n>sizeof(zStr) ) n = sizeof(zStr); |
| sqlite3_snprintf(sizeof(zStr), zStr, "abcdefghijklmnopqrstuvwxyz"); |
| sqlite3_snprintf(n, zStr, zFormat, a1); |
| Tcl_AppendResult(interp, zStr, 0); |
| return TCL_OK; |
| } |
| |
| #ifndef SQLITE_OMIT_GET_TABLE |
| |
| /* |
| ** Usage: sqlite3_get_table_printf DB FORMAT STRING ?--no-counts? |
| ** |
| ** Invoke the sqlite3_get_table_printf() interface using the open database |
| ** DB. The SQL is the string FORMAT. The format string should contain |
| ** one %s or %q. STRING is the value inserted into %s or %q. |
| */ |
| static int test_get_table_printf( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| Tcl_DString str; |
| int rc; |
| char *zErr = 0; |
| int nRow, nCol; |
| char **aResult; |
| int i; |
| char zBuf[30]; |
| char *zSql; |
| int resCount = -1; |
| if( argc==5 ){ |
| if( Tcl_GetInt(interp, argv[4], &resCount) ) return TCL_ERROR; |
| } |
| if( argc!=4 && argc!=5 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB FORMAT STRING ?COUNT?", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| Tcl_DStringInit(&str); |
| zSql = sqlite3_mprintf(argv[2],argv[3]); |
| if( argc==5 ){ |
| rc = sqlite3_get_table(db, zSql, &aResult, 0, 0, &zErr); |
| }else{ |
| rc = sqlite3_get_table(db, zSql, &aResult, &nRow, &nCol, &zErr); |
| resCount = (nRow+1)*nCol; |
| } |
| sqlite3_free(zSql); |
| sprintf(zBuf, "%d", rc); |
| Tcl_AppendElement(interp, zBuf); |
| if( rc==SQLITE_OK ){ |
| if( argc==4 ){ |
| sprintf(zBuf, "%d", nRow); |
| Tcl_AppendElement(interp, zBuf); |
| sprintf(zBuf, "%d", nCol); |
| Tcl_AppendElement(interp, zBuf); |
| } |
| for(i=0; i<resCount; i++){ |
| Tcl_AppendElement(interp, aResult[i] ? aResult[i] : "NULL"); |
| } |
| }else{ |
| Tcl_AppendElement(interp, zErr); |
| } |
| sqlite3_free_table(aResult); |
| if( zErr ) sqlite3_free(zErr); |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| return TCL_OK; |
| } |
| |
| #endif /* SQLITE_OMIT_GET_TABLE */ |
| |
| |
| /* |
| ** Usage: sqlite3_last_insert_rowid DB |
| ** |
| ** Returns the integer ROWID of the most recent insert. |
| */ |
| static int test_last_rowid( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| char zBuf[30]; |
| |
| if( argc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], " DB\"", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| sprintf(zBuf, "%lld", sqlite3_last_insert_rowid(db)); |
| Tcl_AppendResult(interp, zBuf, 0); |
| return SQLITE_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_key DB KEY |
| ** |
| ** Set the codec key. |
| */ |
| static int test_key( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| const char *zKey; |
| int nKey; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FILENAME\"", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| zKey = argv[2]; |
| nKey = strlen(zKey); |
| #ifdef SQLITE_HAS_CODEC |
| sqlite3_key(db, zKey, nKey); |
| #endif |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_rekey DB KEY |
| ** |
| ** Change the codec key. |
| */ |
| static int test_rekey( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| const char *zKey; |
| int nKey; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FILENAME\"", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| zKey = argv[2]; |
| nKey = strlen(zKey); |
| #ifdef SQLITE_HAS_CODEC |
| sqlite3_rekey(db, zKey, nKey); |
| #endif |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_close DB |
| ** |
| ** Closes the database opened by sqlite3_open. |
| */ |
| static int sqlite_test_close( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| int rc; |
| if( argc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FILENAME\"", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| rc = sqlite3_close(db); |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Implementation of the x_coalesce() function. |
| ** Return the first argument non-NULL argument. |
| */ |
| static void t1_ifnullFunc( |
| sqlite3_context *context, |
| int argc, |
| sqlite3_value **argv |
| ){ |
| int i; |
| for(i=0; i<argc; i++){ |
| if( SQLITE_NULL!=sqlite3_value_type(argv[i]) ){ |
| int n = sqlite3_value_bytes(argv[i]); |
| sqlite3_result_text(context, (char*)sqlite3_value_text(argv[i]), |
| n, SQLITE_TRANSIENT); |
| break; |
| } |
| } |
| } |
| |
| /* |
| ** These are test functions. hex8() interprets its argument as |
| ** UTF8 and returns a hex encoding. hex16le() interprets its argument |
| ** as UTF16le and returns a hex encoding. |
| */ |
| static void hex8Func(sqlite3_context *p, int argc, sqlite3_value **argv){ |
| const unsigned char *z; |
| int i; |
| char zBuf[200]; |
| z = sqlite3_value_text(argv[0]); |
| for(i=0; i<sizeof(zBuf)/2 - 2 && z[i]; i++){ |
| sprintf(&zBuf[i*2], "%02x", z[i]&0xff); |
| } |
| zBuf[i*2] = 0; |
| sqlite3_result_text(p, (char*)zBuf, -1, SQLITE_TRANSIENT); |
| } |
| #ifndef SQLITE_OMIT_UTF16 |
| static void hex16Func(sqlite3_context *p, int argc, sqlite3_value **argv){ |
| const unsigned short int *z; |
| int i; |
| char zBuf[400]; |
| z = sqlite3_value_text16(argv[0]); |
| for(i=0; i<sizeof(zBuf)/4 - 4 && z[i]; i++){ |
| sprintf(&zBuf[i*4], "%04x", z[i]&0xff); |
| } |
| zBuf[i*4] = 0; |
| sqlite3_result_text(p, (char*)zBuf, -1, SQLITE_TRANSIENT); |
| } |
| #endif |
| |
| /* |
| ** A structure into which to accumulate text. |
| */ |
| struct dstr { |
| int nAlloc; /* Space allocated */ |
| int nUsed; /* Space used */ |
| char *z; /* The space */ |
| }; |
| |
| /* |
| ** Append text to a dstr |
| */ |
| static void dstrAppend(struct dstr *p, const char *z, int divider){ |
| int n = strlen(z); |
| if( p->nUsed + n + 2 > p->nAlloc ){ |
| char *zNew; |
| p->nAlloc = p->nAlloc*2 + n + 200; |
| zNew = sqlite3_realloc(p->z, p->nAlloc); |
| if( zNew==0 ){ |
| sqlite3_free(p->z); |
| memset(p, 0, sizeof(*p)); |
| return; |
| } |
| p->z = zNew; |
| } |
| if( divider && p->nUsed>0 ){ |
| p->z[p->nUsed++] = divider; |
| } |
| memcpy(&p->z[p->nUsed], z, n+1); |
| p->nUsed += n; |
| } |
| |
| /* |
| ** Invoked for each callback from sqlite3ExecFunc |
| */ |
| static int execFuncCallback(void *pData, int argc, char **argv, char **NotUsed){ |
| struct dstr *p = (struct dstr*)pData; |
| int i; |
| for(i=0; i<argc; i++){ |
| if( argv[i]==0 ){ |
| dstrAppend(p, "NULL", ' '); |
| }else{ |
| dstrAppend(p, argv[i], ' '); |
| } |
| } |
| return 0; |
| } |
| |
| /* |
| ** Implementation of the x_sqlite_exec() function. This function takes |
| ** a single argument and attempts to execute that argument as SQL code. |
| ** This is illegal and should set the SQLITE_MISUSE flag on the database. |
| ** |
| ** 2004-Jan-07: We have changed this to make it legal to call sqlite3_exec() |
| ** from within a function call. |
| ** |
| ** This routine simulates the effect of having two threads attempt to |
| ** use the same database at the same time. |
| */ |
| static void sqlite3ExecFunc( |
| sqlite3_context *context, |
| int argc, |
| sqlite3_value **argv |
| ){ |
| struct dstr x; |
| memset(&x, 0, sizeof(x)); |
| (void)sqlite3_exec((sqlite3*)sqlite3_user_data(context), |
| (char*)sqlite3_value_text(argv[0]), |
| execFuncCallback, &x, 0); |
| sqlite3_result_text(context, x.z, x.nUsed, SQLITE_TRANSIENT); |
| sqlite3_free(x.z); |
| } |
| |
| /* |
| ** Implementation of tkt2213func(), a scalar function that takes exactly |
| ** one argument. It has two interesting features: |
| ** |
| ** * It calls sqlite3_value_text() 3 times on the argument sqlite3_value*. |
| ** If the three pointers returned are not the same an SQL error is raised. |
| ** |
| ** * Otherwise it returns a copy of the text representation of its |
| ** argument in such a way as the VDBE representation is a Mem* cell |
| ** with the MEM_Term flag clear. |
| ** |
| ** Ticket #2213 can therefore be tested by evaluating the following |
| ** SQL expression: |
| ** |
| ** tkt2213func(tkt2213func('a string')); |
| */ |
| static void tkt2213Function( |
| sqlite3_context *context, |
| int argc, |
| sqlite3_value **argv |
| ){ |
| int nText; |
| unsigned char const *zText1; |
| unsigned char const *zText2; |
| unsigned char const *zText3; |
| |
| nText = sqlite3_value_bytes(argv[0]); |
| zText1 = sqlite3_value_text(argv[0]); |
| zText2 = sqlite3_value_text(argv[0]); |
| zText3 = sqlite3_value_text(argv[0]); |
| |
| if( zText1!=zText2 || zText2!=zText3 ){ |
| sqlite3_result_error(context, "tkt2213 is not fixed", -1); |
| }else{ |
| char *zCopy = (char *)sqlite3_malloc(nText); |
| memcpy(zCopy, zText1, nText); |
| sqlite3_result_text(context, zCopy, nText, sqlite3_free); |
| } |
| } |
| |
| /* |
| ** The following SQL function takes 4 arguments. The 2nd and |
| ** 4th argument must be one of these strings: 'text', 'text16', |
| ** or 'blob' corresponding to API functions |
| ** |
| ** sqlite3_value_text() |
| ** sqlite3_value_text16() |
| ** sqlite3_value_blob() |
| ** |
| ** The third argument is a string, either 'bytes' or 'bytes16' or 'noop', |
| ** corresponding to APIs: |
| ** |
| ** sqlite3_value_bytes() |
| ** sqlite3_value_bytes16() |
| ** noop |
| ** |
| ** The APIs designated by the 2nd through 4th arguments are applied |
| ** to the first argument in order. If the pointers returned by the |
| ** second and fourth are different, this routine returns 1. Otherwise, |
| ** this routine returns 0. |
| ** |
| ** This function is used to test to see when returned pointers from |
| ** the _text(), _text16() and _blob() APIs become invalidated. |
| */ |
| static void ptrChngFunction( |
| sqlite3_context *context, |
| int argc, |
| sqlite3_value **argv |
| ){ |
| const void *p1, *p2; |
| const char *zCmd; |
| if( argc!=4 ) return; |
| zCmd = (const char*)sqlite3_value_text(argv[1]); |
| if( zCmd==0 ) return; |
| if( strcmp(zCmd,"text")==0 ){ |
| p1 = (const void*)sqlite3_value_text(argv[0]); |
| #ifndef SQLITE_OMIT_UTF16 |
| }else if( strcmp(zCmd, "text16")==0 ){ |
| p1 = (const void*)sqlite3_value_text16(argv[0]); |
| #endif |
| }else if( strcmp(zCmd, "blob")==0 ){ |
| p1 = (const void*)sqlite3_value_blob(argv[0]); |
| }else{ |
| return; |
| } |
| zCmd = (const char*)sqlite3_value_text(argv[2]); |
| if( zCmd==0 ) return; |
| if( strcmp(zCmd,"bytes")==0 ){ |
| sqlite3_value_bytes(argv[0]); |
| #ifndef SQLITE_OMIT_UTF16 |
| }else if( strcmp(zCmd, "bytes16")==0 ){ |
| sqlite3_value_bytes16(argv[0]); |
| #endif |
| }else if( strcmp(zCmd, "noop")==0 ){ |
| /* do nothing */ |
| }else{ |
| return; |
| } |
| zCmd = (const char*)sqlite3_value_text(argv[3]); |
| if( zCmd==0 ) return; |
| if( strcmp(zCmd,"text")==0 ){ |
| p2 = (const void*)sqlite3_value_text(argv[0]); |
| #ifndef SQLITE_OMIT_UTF16 |
| }else if( strcmp(zCmd, "text16")==0 ){ |
| p2 = (const void*)sqlite3_value_text16(argv[0]); |
| #endif |
| }else if( strcmp(zCmd, "blob")==0 ){ |
| p2 = (const void*)sqlite3_value_blob(argv[0]); |
| }else{ |
| return; |
| } |
| sqlite3_result_int(context, p1!=p2); |
| } |
| |
| |
| /* |
| ** Usage: sqlite_test_create_function DB |
| ** |
| ** Call the sqlite3_create_function API on the given database in order |
| ** to create a function named "x_coalesce". This function does the same thing |
| ** as the "coalesce" function. This function also registers an SQL function |
| ** named "x_sqlite_exec" that invokes sqlite3_exec(). Invoking sqlite3_exec() |
| ** in this way is illegal recursion and should raise an SQLITE_MISUSE error. |
| ** The effect is similar to trying to use the same database connection from |
| ** two threads at the same time. |
| ** |
| ** The original motivation for this routine was to be able to call the |
| ** sqlite3_create_function function while a query is in progress in order |
| ** to test the SQLITE_MISUSE detection logic. |
| */ |
| static int test_create_function( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| int rc; |
| sqlite3 *db; |
| |
| if( argc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB\"", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| rc = sqlite3_create_function(db, "x_coalesce", -1, SQLITE_ANY, 0, |
| t1_ifnullFunc, 0, 0); |
| if( rc==SQLITE_OK ){ |
| rc = sqlite3_create_function(db, "hex8", 1, SQLITE_ANY, 0, |
| hex8Func, 0, 0); |
| } |
| #ifndef SQLITE_OMIT_UTF16 |
| if( rc==SQLITE_OK ){ |
| rc = sqlite3_create_function(db, "hex16", 1, SQLITE_ANY, 0, |
| hex16Func, 0, 0); |
| } |
| #endif |
| if( rc==SQLITE_OK ){ |
| rc = sqlite3_create_function(db, "tkt2213func", 1, SQLITE_ANY, 0, |
| tkt2213Function, 0, 0); |
| } |
| if( rc==SQLITE_OK ){ |
| rc = sqlite3_create_function(db, "pointer_change", 4, SQLITE_ANY, 0, |
| ptrChngFunction, 0, 0); |
| } |
| |
| #ifndef SQLITE_OMIT_UTF16 |
| /* Use the sqlite3_create_function16() API here. Mainly for fun, but also |
| ** because it is not tested anywhere else. */ |
| if( rc==SQLITE_OK ){ |
| const void *zUtf16; |
| sqlite3_value *pVal; |
| sqlite3_mutex_enter(db->mutex); |
| pVal = sqlite3ValueNew(db); |
| sqlite3ValueSetStr(pVal, -1, "x_sqlite_exec", SQLITE_UTF8, SQLITE_STATIC); |
| zUtf16 = sqlite3ValueText(pVal, SQLITE_UTF16NATIVE); |
| if( db->mallocFailed ){ |
| rc = SQLITE_NOMEM; |
| }else{ |
| rc = sqlite3_create_function16(db, zUtf16, |
| 1, SQLITE_UTF16, db, sqlite3ExecFunc, 0, 0); |
| } |
| sqlite3ValueFree(pVal); |
| sqlite3_mutex_leave(db->mutex); |
| } |
| #endif |
| |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), 0); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Routines to implement the x_count() aggregate function. |
| ** |
| ** x_count() counts the number of non-null arguments. But there are |
| ** some twists for testing purposes. |
| ** |
| ** If the argument to x_count() is 40 then a UTF-8 error is reported |
| ** on the step function. If x_count(41) is seen, then a UTF-16 error |
| ** is reported on the step function. If the total count is 42, then |
| ** a UTF-8 error is reported on the finalize function. |
| */ |
| typedef struct t1CountCtx t1CountCtx; |
| struct t1CountCtx { |
| int n; |
| }; |
| static void t1CountStep( |
| sqlite3_context *context, |
| int argc, |
| sqlite3_value **argv |
| ){ |
| t1CountCtx *p; |
| p = sqlite3_aggregate_context(context, sizeof(*p)); |
| if( (argc==0 || SQLITE_NULL!=sqlite3_value_type(argv[0]) ) && p ){ |
| p->n++; |
| } |
| if( argc>0 ){ |
| int v = sqlite3_value_int(argv[0]); |
| if( v==40 ){ |
| sqlite3_result_error(context, "value of 40 handed to x_count", -1); |
| #ifndef SQLITE_OMIT_UTF16 |
| }else if( v==41 ){ |
| const char zUtf16ErrMsg[] = { 0, 0x61, 0, 0x62, 0, 0x63, 0, 0, 0}; |
| sqlite3_result_error16(context, &zUtf16ErrMsg[1-SQLITE_BIGENDIAN], -1); |
| #endif |
| } |
| } |
| } |
| static void t1CountFinalize(sqlite3_context *context){ |
| t1CountCtx *p; |
| p = sqlite3_aggregate_context(context, sizeof(*p)); |
| if( p ){ |
| if( p->n==42 ){ |
| sqlite3_result_error(context, "x_count totals to 42", -1); |
| }else{ |
| sqlite3_result_int(context, p ? p->n : 0); |
| } |
| } |
| } |
| |
| #ifndef SQLITE_OMIT_DEPRECATED |
| static void legacyCountStep( |
| sqlite3_context *context, |
| int argc, |
| sqlite3_value **argv |
| ){ |
| /* no-op */ |
| } |
| |
| static void legacyCountFinalize(sqlite3_context *context){ |
| sqlite3_result_int(context, sqlite3_aggregate_count(context)); |
| } |
| #endif |
| |
| /* |
| ** Usage: sqlite3_create_aggregate DB |
| ** |
| ** Call the sqlite3_create_function API on the given database in order |
| ** to create a function named "x_count". This function is similar |
| ** to the built-in count() function, with a few special quirks |
| ** for testing the sqlite3_result_error() APIs. |
| ** |
| ** The original motivation for this routine was to be able to call the |
| ** sqlite3_create_aggregate function while a query is in progress in order |
| ** to test the SQLITE_MISUSE detection logic. See misuse.test. |
| ** |
| ** This routine was later extended to test the use of sqlite3_result_error() |
| ** within aggregate functions. |
| ** |
| ** Later: It is now also extended to register the aggregate function |
| ** "legacy_count()" with the supplied database handle. This is used |
| ** to test the deprecated sqlite3_aggregate_count() API. |
| */ |
| static int test_create_aggregate( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| int rc; |
| if( argc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FILENAME\"", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| rc = sqlite3_create_function(db, "x_count", 0, SQLITE_UTF8, 0, 0, |
| t1CountStep,t1CountFinalize); |
| if( rc==SQLITE_OK ){ |
| rc = sqlite3_create_function(db, "x_count", 1, SQLITE_UTF8, 0, 0, |
| t1CountStep,t1CountFinalize); |
| } |
| #ifndef SQLITE_OMIT_DEPRECATED |
| if( rc==SQLITE_OK ){ |
| rc = sqlite3_create_function(db, "legacy_count", 0, SQLITE_ANY, 0, 0, |
| legacyCountStep, legacyCountFinalize |
| ); |
| } |
| #endif |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), 0); |
| return TCL_OK; |
| } |
| |
| |
| /* |
| ** Usage: printf TEXT |
| ** |
| ** Send output to printf. Use this rather than puts to merge the output |
| ** in the correct sequence with debugging printfs inserted into C code. |
| ** Puts uses a separate buffer and debugging statements will be out of |
| ** sequence if it is used. |
| */ |
| static int test_printf( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| if( argc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " TEXT\"", 0); |
| return TCL_ERROR; |
| } |
| printf("%s\n", argv[1]); |
| return TCL_OK; |
| } |
| |
| |
| |
| /* |
| ** Usage: sqlite3_mprintf_int FORMAT INTEGER INTEGER INTEGER |
| ** |
| ** Call mprintf with three integer arguments |
| */ |
| static int sqlite3_mprintf_int( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| int a[3], i; |
| char *z; |
| if( argc!=5 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FORMAT INT INT INT\"", 0); |
| return TCL_ERROR; |
| } |
| for(i=2; i<5; i++){ |
| if( Tcl_GetInt(interp, argv[i], &a[i-2]) ) return TCL_ERROR; |
| } |
| z = sqlite3_mprintf(argv[1], a[0], a[1], a[2]); |
| Tcl_AppendResult(interp, z, 0); |
| sqlite3_free(z); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_mprintf_int64 FORMAT INTEGER INTEGER INTEGER |
| ** |
| ** Call mprintf with three 64-bit integer arguments |
| */ |
| static int sqlite3_mprintf_int64( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| int i; |
| sqlite_int64 a[3]; |
| char *z; |
| if( argc!=5 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FORMAT INT INT INT\"", 0); |
| return TCL_ERROR; |
| } |
| for(i=2; i<5; i++){ |
| if( sqlite3Atoi64(argv[i], &a[i-2], 1000000, SQLITE_UTF8) ){ |
| Tcl_AppendResult(interp, "argument is not a valid 64-bit integer", 0); |
| return TCL_ERROR; |
| } |
| } |
| z = sqlite3_mprintf(argv[1], a[0], a[1], a[2]); |
| Tcl_AppendResult(interp, z, 0); |
| sqlite3_free(z); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_mprintf_long FORMAT INTEGER INTEGER INTEGER |
| ** |
| ** Call mprintf with three long integer arguments. This might be the |
| ** same as sqlite3_mprintf_int or sqlite3_mprintf_int64, depending on |
| ** platform. |
| */ |
| static int sqlite3_mprintf_long( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| int i; |
| long int a[3]; |
| int b[3]; |
| char *z; |
| if( argc!=5 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FORMAT INT INT INT\"", 0); |
| return TCL_ERROR; |
| } |
| for(i=2; i<5; i++){ |
| if( Tcl_GetInt(interp, argv[i], &b[i-2]) ) return TCL_ERROR; |
| a[i-2] = (long int)b[i-2]; |
| a[i-2] &= (((u64)1)<<(sizeof(int)*8))-1; |
| } |
| z = sqlite3_mprintf(argv[1], a[0], a[1], a[2]); |
| Tcl_AppendResult(interp, z, 0); |
| sqlite3_free(z); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_mprintf_str FORMAT INTEGER INTEGER STRING |
| ** |
| ** Call mprintf with two integer arguments and one string argument |
| */ |
| static int sqlite3_mprintf_str( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| int a[3], i; |
| char *z; |
| if( argc<4 || argc>5 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FORMAT INT INT ?STRING?\"", 0); |
| return TCL_ERROR; |
| } |
| for(i=2; i<4; i++){ |
| if( Tcl_GetInt(interp, argv[i], &a[i-2]) ) return TCL_ERROR; |
| } |
| z = sqlite3_mprintf(argv[1], a[0], a[1], argc>4 ? argv[4] : NULL); |
| Tcl_AppendResult(interp, z, 0); |
| sqlite3_free(z); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_snprintf_str INTEGER FORMAT INTEGER INTEGER STRING |
| ** |
| ** Call mprintf with two integer arguments and one string argument |
| */ |
| static int sqlite3_snprintf_str( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| int a[3], i; |
| int n; |
| char *z; |
| if( argc<5 || argc>6 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " INT FORMAT INT INT ?STRING?\"", 0); |
| return TCL_ERROR; |
| } |
| if( Tcl_GetInt(interp, argv[1], &n) ) return TCL_ERROR; |
| if( n<0 ){ |
| Tcl_AppendResult(interp, "N must be non-negative", 0); |
| return TCL_ERROR; |
| } |
| for(i=3; i<5; i++){ |
| if( Tcl_GetInt(interp, argv[i], &a[i-3]) ) return TCL_ERROR; |
| } |
| z = sqlite3_malloc( n+1 ); |
| sqlite3_snprintf(n, z, argv[2], a[0], a[1], argc>4 ? argv[5] : NULL); |
| Tcl_AppendResult(interp, z, 0); |
| sqlite3_free(z); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_mprintf_double FORMAT INTEGER INTEGER DOUBLE |
| ** |
| ** Call mprintf with two integer arguments and one double argument |
| */ |
| static int sqlite3_mprintf_double( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| int a[3], i; |
| double r; |
| char *z; |
| if( argc!=5 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FORMAT INT INT DOUBLE\"", 0); |
| return TCL_ERROR; |
| } |
| for(i=2; i<4; i++){ |
| if( Tcl_GetInt(interp, argv[i], &a[i-2]) ) return TCL_ERROR; |
| } |
| if( Tcl_GetDouble(interp, argv[4], &r) ) return TCL_ERROR; |
| z = sqlite3_mprintf(argv[1], a[0], a[1], r); |
| Tcl_AppendResult(interp, z, 0); |
| sqlite3_free(z); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_mprintf_scaled FORMAT DOUBLE DOUBLE |
| ** |
| ** Call mprintf with a single double argument which is the product of the |
| ** two arguments given above. This is used to generate overflow and underflow |
| ** doubles to test that they are converted properly. |
| */ |
| static int sqlite3_mprintf_scaled( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| int i; |
| double r[2]; |
| char *z; |
| if( argc!=4 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FORMAT DOUBLE DOUBLE\"", 0); |
| return TCL_ERROR; |
| } |
| for(i=2; i<4; i++){ |
| if( Tcl_GetDouble(interp, argv[i], &r[i-2]) ) return TCL_ERROR; |
| } |
| z = sqlite3_mprintf(argv[1], r[0]*r[1]); |
| Tcl_AppendResult(interp, z, 0); |
| sqlite3_free(z); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_mprintf_stronly FORMAT STRING |
| ** |
| ** Call mprintf with a single double argument which is the product of the |
| ** two arguments given above. This is used to generate overflow and underflow |
| ** doubles to test that they are converted properly. |
| */ |
| static int sqlite3_mprintf_stronly( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| char *z; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FORMAT STRING\"", 0); |
| return TCL_ERROR; |
| } |
| z = sqlite3_mprintf(argv[1], argv[2]); |
| Tcl_AppendResult(interp, z, 0); |
| sqlite3_free(z); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_mprintf_hexdouble FORMAT HEX |
| ** |
| ** Call mprintf with a single double argument which is derived from the |
| ** hexadecimal encoding of an IEEE double. |
| */ |
| static int sqlite3_mprintf_hexdouble( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| char *z; |
| double r; |
| unsigned int x1, x2; |
| sqlite_uint64 d; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " FORMAT STRING\"", 0); |
| return TCL_ERROR; |
| } |
| if( sscanf(argv[2], "%08x%08x", &x2, &x1)!=2 ){ |
| Tcl_AppendResult(interp, "2nd argument should be 16-characters of hex", 0); |
| return TCL_ERROR; |
| } |
| d = x2; |
| d = (d<<32) + x1; |
| memcpy(&r, &d, sizeof(r)); |
| z = sqlite3_mprintf(argv[1], r); |
| Tcl_AppendResult(interp, z, 0); |
| sqlite3_free(z); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_enable_shared_cache ?BOOLEAN? |
| ** |
| */ |
| #if !defined(SQLITE_OMIT_SHARED_CACHE) |
| static int test_enable_shared( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| int rc; |
| int enable; |
| int ret = 0; |
| |
| if( objc!=2 && objc!=1 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "?BOOLEAN?"); |
| return TCL_ERROR; |
| } |
| ret = sqlite3GlobalConfig.sharedCacheEnabled; |
| |
| if( objc==2 ){ |
| if( Tcl_GetBooleanFromObj(interp, objv[1], &enable) ){ |
| return TCL_ERROR; |
| } |
| rc = sqlite3_enable_shared_cache(enable); |
| if( rc!=SQLITE_OK ){ |
| Tcl_SetResult(interp, (char *)sqlite3ErrStr(rc), TCL_STATIC); |
| return TCL_ERROR; |
| } |
| } |
| Tcl_SetObjResult(interp, Tcl_NewBooleanObj(ret)); |
| return TCL_OK; |
| } |
| #endif |
| |
| |
| |
| /* |
| ** Usage: sqlite3_extended_result_codes DB BOOLEAN |
| ** |
| */ |
| static int test_extended_result_codes( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| int enable; |
| sqlite3 *db; |
| |
| if( objc!=3 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB BOOLEAN"); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| if( Tcl_GetBooleanFromObj(interp, objv[2], &enable) ) return TCL_ERROR; |
| sqlite3_extended_result_codes(db, enable); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_libversion_number |
| ** |
| */ |
| static int test_libversion_number( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_libversion_number())); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_table_column_metadata DB dbname tblname colname |
| ** |
| */ |
| #ifdef SQLITE_ENABLE_COLUMN_METADATA |
| static int test_table_column_metadata( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3 *db; |
| const char *zDb; |
| const char *zTbl; |
| const char *zCol; |
| int rc; |
| Tcl_Obj *pRet; |
| |
| const char *zDatatype; |
| const char *zCollseq; |
| int notnull; |
| int primarykey; |
| int autoincrement; |
| |
| if( objc!=5 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB dbname tblname colname"); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| zDb = Tcl_GetString(objv[2]); |
| zTbl = Tcl_GetString(objv[3]); |
| zCol = Tcl_GetString(objv[4]); |
| |
| if( strlen(zDb)==0 ) zDb = 0; |
| |
| rc = sqlite3_table_column_metadata(db, zDb, zTbl, zCol, |
| &zDatatype, &zCollseq, ¬null, &primarykey, &autoincrement); |
| |
| if( rc!=SQLITE_OK ){ |
| Tcl_AppendResult(interp, sqlite3_errmsg(db), 0); |
| return TCL_ERROR; |
| } |
| |
| pRet = Tcl_NewObj(); |
| Tcl_ListObjAppendElement(0, pRet, Tcl_NewStringObj(zDatatype, -1)); |
| Tcl_ListObjAppendElement(0, pRet, Tcl_NewStringObj(zCollseq, -1)); |
| Tcl_ListObjAppendElement(0, pRet, Tcl_NewIntObj(notnull)); |
| Tcl_ListObjAppendElement(0, pRet, Tcl_NewIntObj(primarykey)); |
| Tcl_ListObjAppendElement(0, pRet, Tcl_NewIntObj(autoincrement)); |
| Tcl_SetObjResult(interp, pRet); |
| |
| return TCL_OK; |
| } |
| #endif |
| |
| #ifndef SQLITE_OMIT_INCRBLOB |
| |
| static int blobHandleFromObj( |
| Tcl_Interp *interp, |
| Tcl_Obj *pObj, |
| sqlite3_blob **ppBlob |
| ){ |
| char *z; |
| int n; |
| |
| z = Tcl_GetStringFromObj(pObj, &n); |
| if( n==0 ){ |
| *ppBlob = 0; |
| }else{ |
| int notUsed; |
| Tcl_Channel channel; |
| ClientData instanceData; |
| |
| channel = Tcl_GetChannel(interp, z, ¬Used); |
| if( !channel ) return TCL_ERROR; |
| |
| Tcl_Flush(channel); |
| Tcl_Seek(channel, 0, SEEK_SET); |
| |
| instanceData = Tcl_GetChannelInstanceData(channel); |
| *ppBlob = *((sqlite3_blob **)instanceData); |
| } |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** sqlite3_blob_bytes CHANNEL |
| */ |
| static int test_blob_bytes( |
| ClientData clientData, /* Not used */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3_blob *pBlob; |
| int nByte; |
| |
| if( objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL"); |
| return TCL_ERROR; |
| } |
| |
| if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL_ERROR; |
| nByte = sqlite3_blob_bytes(pBlob); |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(nByte)); |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** sqlite3_blob_close CHANNEL |
| */ |
| static int test_blob_close( |
| ClientData clientData, /* Not used */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3_blob *pBlob; |
| |
| if( objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL"); |
| return TCL_ERROR; |
| } |
| |
| if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL_ERROR; |
| sqlite3_blob_close(pBlob); |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** sqlite3_blob_read CHANNEL OFFSET N |
| ** |
| ** This command is used to test the sqlite3_blob_read() in ways that |
| ** the Tcl channel interface does not. The first argument should |
| ** be the name of a valid channel created by the [incrblob] method |
| ** of a database handle. This function calls sqlite3_blob_read() |
| ** to read N bytes from offset OFFSET from the underlying SQLite |
| ** blob handle. |
| ** |
| ** On success, a byte-array object containing the read data is |
| ** returned. On failure, the interpreter result is set to the |
| ** text representation of the returned error code (i.e. "SQLITE_NOMEM") |
| ** and a Tcl exception is thrown. |
| */ |
| static int test_blob_read( |
| ClientData clientData, /* Not used */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3_blob *pBlob; |
| int nByte; |
| int iOffset; |
| unsigned char *zBuf = 0; |
| int rc; |
| |
| if( objc!=4 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL OFFSET N"); |
| return TCL_ERROR; |
| } |
| |
| if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL_ERROR; |
| if( TCL_OK!=Tcl_GetIntFromObj(interp, objv[2], &iOffset) |
| || TCL_OK!=Tcl_GetIntFromObj(interp, objv[3], &nByte) |
| ){ |
| return TCL_ERROR; |
| } |
| |
| if( nByte>0 ){ |
| zBuf = (unsigned char *)Tcl_Alloc(nByte); |
| } |
| rc = sqlite3_blob_read(pBlob, zBuf, nByte, iOffset); |
| if( rc==SQLITE_OK ){ |
| Tcl_SetObjResult(interp, Tcl_NewByteArrayObj(zBuf, nByte)); |
| }else{ |
| Tcl_SetResult(interp, (char *)sqlite3TestErrorName(rc), TCL_VOLATILE); |
| } |
| Tcl_Free((char *)zBuf); |
| |
| return (rc==SQLITE_OK ? TCL_OK : TCL_ERROR); |
| } |
| |
| /* |
| ** sqlite3_blob_write CHANNEL OFFSET DATA ?NDATA? |
| ** |
| ** This command is used to test the sqlite3_blob_write() in ways that |
| ** the Tcl channel interface does not. The first argument should |
| ** be the name of a valid channel created by the [incrblob] method |
| ** of a database handle. This function calls sqlite3_blob_write() |
| ** to write the DATA byte-array to the underlying SQLite blob handle. |
| ** at offset OFFSET. |
| ** |
| ** On success, an empty string is returned. On failure, the interpreter |
| ** result is set to the text representation of the returned error code |
| ** (i.e. "SQLITE_NOMEM") and a Tcl exception is thrown. |
| */ |
| static int test_blob_write( |
| ClientData clientData, /* Not used */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3_blob *pBlob; |
| int iOffset; |
| int rc; |
| |
| unsigned char *zBuf; |
| int nBuf; |
| |
| if( objc!=4 && objc!=5 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL OFFSET DATA ?NDATA?"); |
| return TCL_ERROR; |
| } |
| |
| if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL_ERROR; |
| if( TCL_OK!=Tcl_GetIntFromObj(interp, objv[2], &iOffset) ){ |
| return TCL_ERROR; |
| } |
| |
| zBuf = Tcl_GetByteArrayFromObj(objv[3], &nBuf); |
| if( objc==5 && Tcl_GetIntFromObj(interp, objv[4], &nBuf) ){ |
| return TCL_ERROR; |
| } |
| rc = sqlite3_blob_write(pBlob, zBuf, nBuf, iOffset); |
| if( rc!=SQLITE_OK ){ |
| Tcl_SetResult(interp, (char *)sqlite3TestErrorName(rc), TCL_VOLATILE); |
| } |
| |
| return (rc==SQLITE_OK ? TCL_OK : TCL_ERROR); |
| } |
| |
| static int test_blob_reopen( |
| ClientData clientData, /* Not used */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| Tcl_WideInt iRowid; |
| sqlite3_blob *pBlob; |
| int rc; |
| |
| if( objc!=3 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL ROWID"); |
| return TCL_ERROR; |
| } |
| |
| if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL_ERROR; |
| if( Tcl_GetWideIntFromObj(interp, objv[2], &iRowid) ) return TCL_ERROR; |
| |
| rc = sqlite3_blob_reopen(pBlob, iRowid); |
| if( rc!=SQLITE_OK ){ |
| Tcl_SetResult(interp, (char *)sqlite3TestErrorName(rc), TCL_VOLATILE); |
| } |
| |
| return (rc==SQLITE_OK ? TCL_OK : TCL_ERROR); |
| } |
| |
| #endif |
| |
| /* |
| ** Usage: sqlite3_create_collation_v2 DB-HANDLE NAME CMP-PROC DEL-PROC |
| ** |
| ** This Tcl proc is used for testing the experimental |
| ** sqlite3_create_collation_v2() interface. |
| */ |
| struct TestCollationX { |
| Tcl_Interp *interp; |
| Tcl_Obj *pCmp; |
| Tcl_Obj *pDel; |
| }; |
| typedef struct TestCollationX TestCollationX; |
| static void testCreateCollationDel(void *pCtx){ |
| TestCollationX *p = (TestCollationX *)pCtx; |
| |
| int rc = Tcl_EvalObjEx(p->interp, p->pDel, TCL_EVAL_DIRECT|TCL_EVAL_GLOBAL); |
| if( rc!=TCL_OK ){ |
| Tcl_BackgroundError(p->interp); |
| } |
| |
| Tcl_DecrRefCount(p->pCmp); |
| Tcl_DecrRefCount(p->pDel); |
| sqlite3_free((void *)p); |
| } |
| static int testCreateCollationCmp( |
| void *pCtx, |
| int nLeft, |
| const void *zLeft, |
| int nRight, |
| const void *zRight |
| ){ |
| TestCollationX *p = (TestCollationX *)pCtx; |
| Tcl_Obj *pScript = Tcl_DuplicateObj(p->pCmp); |
| int iRes = 0; |
| |
| Tcl_IncrRefCount(pScript); |
| Tcl_ListObjAppendElement(0, pScript, Tcl_NewStringObj((char *)zLeft, nLeft)); |
| Tcl_ListObjAppendElement(0, pScript, Tcl_NewStringObj((char *)zRight,nRight)); |
| |
| if( TCL_OK!=Tcl_EvalObjEx(p->interp, pScript, TCL_EVAL_DIRECT|TCL_EVAL_GLOBAL) |
| || TCL_OK!=Tcl_GetIntFromObj(p->interp, Tcl_GetObjResult(p->interp), &iRes) |
| ){ |
| Tcl_BackgroundError(p->interp); |
| } |
| Tcl_DecrRefCount(pScript); |
| |
| return iRes; |
| } |
| static int test_create_collation_v2( |
| ClientData clientData, /* Not used */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| TestCollationX *p; |
| sqlite3 *db; |
| int rc; |
| |
| if( objc!=5 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB-HANDLE NAME CMP-PROC DEL-PROC"); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| |
| p = (TestCollationX *)sqlite3_malloc(sizeof(TestCollationX)); |
| p->pCmp = objv[3]; |
| p->pDel = objv[4]; |
| p->interp = interp; |
| Tcl_IncrRefCount(p->pCmp); |
| Tcl_IncrRefCount(p->pDel); |
| |
| rc = sqlite3_create_collation_v2(db, Tcl_GetString(objv[2]), 16, |
| (void *)p, testCreateCollationCmp, testCreateCollationDel |
| ); |
| if( rc!=SQLITE_MISUSE ){ |
| Tcl_AppendResult(interp, "sqlite3_create_collate_v2() failed to detect " |
| "an invalid encoding", (char*)0); |
| return TCL_ERROR; |
| } |
| rc = sqlite3_create_collation_v2(db, Tcl_GetString(objv[2]), SQLITE_UTF8, |
| (void *)p, testCreateCollationCmp, testCreateCollationDel |
| ); |
| return TCL_OK; |
| } |
| |
| /* |
| ** USAGE: sqlite3_create_function_v2 DB NAME NARG ENC ?SWITCHES? |
| ** |
| ** Available switches are: |
| ** |
| ** -func SCRIPT |
| ** -step SCRIPT |
| ** -final SCRIPT |
| ** -destroy SCRIPT |
| */ |
| typedef struct CreateFunctionV2 CreateFunctionV2; |
| struct CreateFunctionV2 { |
| Tcl_Interp *interp; |
| Tcl_Obj *pFunc; /* Script for function invocation */ |
| Tcl_Obj *pStep; /* Script for agg. step invocation */ |
| Tcl_Obj *pFinal; /* Script for agg. finalization invocation */ |
| Tcl_Obj *pDestroy; /* Destructor script */ |
| }; |
| static void cf2Func(sqlite3_context *ctx, int nArg, sqlite3_value **aArg){ |
| } |
| static void cf2Step(sqlite3_context *ctx, int nArg, sqlite3_value **aArg){ |
| } |
| static void cf2Final(sqlite3_context *ctx){ |
| } |
| static void cf2Destroy(void *pUser){ |
| CreateFunctionV2 *p = (CreateFunctionV2 *)pUser; |
| |
| if( p->interp && p->pDestroy ){ |
| int rc = Tcl_EvalObjEx(p->interp, p->pDestroy, 0); |
| if( rc!=TCL_OK ) Tcl_BackgroundError(p->interp); |
| } |
| |
| if( p->pFunc ) Tcl_DecrRefCount(p->pFunc); |
| if( p->pStep ) Tcl_DecrRefCount(p->pStep); |
| if( p->pFinal ) Tcl_DecrRefCount(p->pFinal); |
| if( p->pDestroy ) Tcl_DecrRefCount(p->pDestroy); |
| sqlite3_free(p); |
| } |
| static int test_create_function_v2( |
| ClientData clientData, /* Not used */ |
| Tcl_Interp *interp, /* The invoking TCL interpreter */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3 *db; |
| const char *zFunc; |
| int nArg; |
| int enc; |
| CreateFunctionV2 *p; |
| int i; |
| int rc; |
| |
| struct EncTable { |
| const char *zEnc; |
| int enc; |
| } aEnc[] = { |
| {"utf8", SQLITE_UTF8 }, |
| {"utf16", SQLITE_UTF16 }, |
| {"utf16le", SQLITE_UTF16LE }, |
| {"utf16be", SQLITE_UTF16BE }, |
| {"any", SQLITE_ANY }, |
| {"0", 0 } |
| }; |
| |
| if( objc<5 || (objc%2)==0 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB NAME NARG ENC SWITCHES..."); |
| return TCL_ERROR; |
| } |
| |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| zFunc = Tcl_GetString(objv[2]); |
| if( Tcl_GetIntFromObj(interp, objv[3], &nArg) ) return TCL_ERROR; |
| if( Tcl_GetIndexFromObjStruct(interp, objv[4], aEnc, sizeof(aEnc[0]), |
| "encoding", 0, &enc) |
| ){ |
| return TCL_ERROR; |
| } |
| enc = aEnc[enc].enc; |
| |
| p = sqlite3_malloc(sizeof(CreateFunctionV2)); |
| assert( p ); |
| memset(p, 0, sizeof(CreateFunctionV2)); |
| p->interp = interp; |
| |
| for(i=5; i<objc; i+=2){ |
| int iSwitch; |
| const char *azSwitch[] = {"-func", "-step", "-final", "-destroy", 0}; |
| if( Tcl_GetIndexFromObj(interp, objv[i], azSwitch, "switch", 0, &iSwitch) ){ |
| sqlite3_free(p); |
| return TCL_ERROR; |
| } |
| |
| switch( iSwitch ){ |
| case 0: p->pFunc = objv[i+1]; break; |
| case 1: p->pStep = objv[i+1]; break; |
| case 2: p->pFinal = objv[i+1]; break; |
| case 3: p->pDestroy = objv[i+1]; break; |
| } |
| } |
| if( p->pFunc ) p->pFunc = Tcl_DuplicateObj(p->pFunc); |
| if( p->pStep ) p->pStep = Tcl_DuplicateObj(p->pStep); |
| if( p->pFinal ) p->pFinal = Tcl_DuplicateObj(p->pFinal); |
| if( p->pDestroy ) p->pDestroy = Tcl_DuplicateObj(p->pDestroy); |
| |
| if( p->pFunc ) Tcl_IncrRefCount(p->pFunc); |
| if( p->pStep ) Tcl_IncrRefCount(p->pStep); |
| if( p->pFinal ) Tcl_IncrRefCount(p->pFinal); |
| if( p->pDestroy ) Tcl_IncrRefCount(p->pDestroy); |
| |
| rc = sqlite3_create_function_v2(db, zFunc, nArg, enc, (void *)p, |
| (p->pFunc ? cf2Func : 0), |
| (p->pStep ? cf2Step : 0), |
| (p->pFinal ? cf2Final : 0), |
| cf2Destroy |
| ); |
| if( rc!=SQLITE_OK ){ |
| Tcl_ResetResult(interp); |
| Tcl_AppendResult(interp, sqlite3TestErrorName(rc), 0); |
| return TCL_ERROR; |
| } |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_load_extension DB-HANDLE FILE ?PROC? |
| */ |
| static int test_load_extension( |
| ClientData clientData, /* Not used */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| Tcl_CmdInfo cmdInfo; |
| sqlite3 *db; |
| int rc; |
| char *zDb; |
| char *zFile; |
| char *zProc = 0; |
| char *zErr = 0; |
| |
| if( objc!=4 && objc!=3 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB-HANDLE FILE ?PROC?"); |
| return TCL_ERROR; |
| } |
| zDb = Tcl_GetString(objv[1]); |
| zFile = Tcl_GetString(objv[2]); |
| if( objc==4 ){ |
| zProc = Tcl_GetString(objv[3]); |
| } |
| |
| /* Extract the C database handle from the Tcl command name */ |
| if( !Tcl_GetCommandInfo(interp, zDb, &cmdInfo) ){ |
| Tcl_AppendResult(interp, "command not found: ", zDb, (char*)0); |
| return TCL_ERROR; |
| } |
| db = ((struct SqliteDb*)cmdInfo.objClientData)->db; |
| assert(db); |
| |
| /* Call the underlying C function. If an error occurs, set rc to |
| ** TCL_ERROR and load any error string into the interpreter. If no |
| ** error occurs, set rc to TCL_OK. |
| */ |
| #ifdef SQLITE_OMIT_LOAD_EXTENSION |
| rc = SQLITE_ERROR; |
| zErr = sqlite3_mprintf("this build omits sqlite3_load_extension()"); |
| #else |
| rc = sqlite3_load_extension(db, zFile, zProc, &zErr); |
| #endif |
| if( rc!=SQLITE_OK ){ |
| Tcl_SetResult(interp, zErr ? zErr : "", TCL_VOLATILE); |
| rc = TCL_ERROR; |
| }else{ |
| rc = TCL_OK; |
| } |
| sqlite3_free(zErr); |
| |
| return rc; |
| } |
| |
| /* |
| ** Usage: sqlite3_enable_load_extension DB-HANDLE ONOFF |
| */ |
| static int test_enable_load( |
| ClientData clientData, /* Not used */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| Tcl_CmdInfo cmdInfo; |
| sqlite3 *db; |
| char *zDb; |
| int onoff; |
| |
| if( objc!=3 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB-HANDLE ONOFF"); |
| return TCL_ERROR; |
| } |
| zDb = Tcl_GetString(objv[1]); |
| |
| /* Extract the C database handle from the Tcl command name */ |
| if( !Tcl_GetCommandInfo(interp, zDb, &cmdInfo) ){ |
| Tcl_AppendResult(interp, "command not found: ", zDb, (char*)0); |
| return TCL_ERROR; |
| } |
| db = ((struct SqliteDb*)cmdInfo.objClientData)->db; |
| assert(db); |
| |
| /* Get the onoff parameter */ |
| if( Tcl_GetBooleanFromObj(interp, objv[2], &onoff) ){ |
| return TCL_ERROR; |
| } |
| |
| #ifdef SQLITE_OMIT_LOAD_EXTENSION |
| Tcl_AppendResult(interp, "this build omits sqlite3_load_extension()"); |
| return TCL_ERROR; |
| #else |
| sqlite3_enable_load_extension(db, onoff); |
| return TCL_OK; |
| #endif |
| } |
| |
| /* |
| ** Usage: sqlite_abort |
| ** |
| ** Shutdown the process immediately. This is not a clean shutdown. |
| ** This command is used to test the recoverability of a database in |
| ** the event of a program crash. |
| */ |
| static int sqlite_abort( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| #if defined(_MSC_VER) |
| /* We do this, otherwise the test will halt with a popup message |
| * that we have to click away before the test will continue. |
| */ |
| _set_abort_behavior( 0, _CALL_REPORTFAULT ); |
| #endif |
| exit(255); |
| assert( interp==0 ); /* This will always fail */ |
| return TCL_OK; |
| } |
| |
| /* |
| ** The following routine is a user-defined SQL function whose purpose |
| ** is to test the sqlite_set_result() API. |
| */ |
| static void testFunc(sqlite3_context *context, int argc, sqlite3_value **argv){ |
| while( argc>=2 ){ |
| const char *zArg0 = (char*)sqlite3_value_text(argv[0]); |
| if( zArg0 ){ |
| if( 0==sqlite3StrICmp(zArg0, "int") ){ |
| sqlite3_result_int(context, sqlite3_value_int(argv[1])); |
| }else if( sqlite3StrICmp(zArg0,"int64")==0 ){ |
| sqlite3_result_int64(context, sqlite3_value_int64(argv[1])); |
| }else if( sqlite3StrICmp(zArg0,"string")==0 ){ |
| sqlite3_result_text(context, (char*)sqlite3_value_text(argv[1]), -1, |
| SQLITE_TRANSIENT); |
| }else if( sqlite3StrICmp(zArg0,"double")==0 ){ |
| sqlite3_result_double(context, sqlite3_value_double(argv[1])); |
| }else if( sqlite3StrICmp(zArg0,"null")==0 ){ |
| sqlite3_result_null(context); |
| }else if( sqlite3StrICmp(zArg0,"value")==0 ){ |
| sqlite3_result_value(context, argv[sqlite3_value_int(argv[1])]); |
| }else{ |
| goto error_out; |
| } |
| }else{ |
| goto error_out; |
| } |
| argc -= 2; |
| argv += 2; |
| } |
| return; |
| |
| error_out: |
| sqlite3_result_error(context,"first argument should be one of: " |
| "int int64 string double null value", -1); |
| } |
| |
| /* |
| ** Usage: sqlite_register_test_function DB NAME |
| ** |
| ** Register the test SQL function on the database DB under the name NAME. |
| */ |
| static int test_register_func( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3 *db; |
| int rc; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB FUNCTION-NAME", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| rc = sqlite3_create_function(db, argv[2], -1, SQLITE_UTF8, 0, |
| testFunc, 0, 0); |
| if( rc!=0 ){ |
| Tcl_AppendResult(interp, sqlite3ErrStr(rc), 0); |
| return TCL_ERROR; |
| } |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_finalize STMT |
| ** |
| ** Finalize a statement handle. |
| */ |
| static int test_finalize( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int rc; |
| sqlite3 *db = 0; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " <STMT>", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| |
| if( pStmt ){ |
| db = StmtToDb(pStmt); |
| } |
| rc = sqlite3_finalize(pStmt); |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); |
| if( db && sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_stmt_status STMT CODE RESETFLAG |
| ** |
| ** Get the value of a status counter from a statement. |
| */ |
| static int test_stmt_status( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| int iValue; |
| int i, op, resetFlag; |
| const char *zOpName; |
| sqlite3_stmt *pStmt; |
| |
| static const struct { |
| const char *zName; |
| int op; |
| } aOp[] = { |
| { "SQLITE_STMTSTATUS_FULLSCAN_STEP", SQLITE_STMTSTATUS_FULLSCAN_STEP }, |
| { "SQLITE_STMTSTATUS_SORT", SQLITE_STMTSTATUS_SORT }, |
| { "SQLITE_STMTSTATUS_AUTOINDEX", SQLITE_STMTSTATUS_AUTOINDEX }, |
| }; |
| if( objc!=4 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "STMT PARAMETER RESETFLAG"); |
| return TCL_ERROR; |
| } |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| zOpName = Tcl_GetString(objv[2]); |
| for(i=0; i<ArraySize(aOp); i++){ |
| if( strcmp(aOp[i].zName, zOpName)==0 ){ |
| op = aOp[i].op; |
| break; |
| } |
| } |
| if( i>=ArraySize(aOp) ){ |
| if( Tcl_GetIntFromObj(interp, objv[2], &op) ) return TCL_ERROR; |
| } |
| if( Tcl_GetBooleanFromObj(interp, objv[3], &resetFlag) ) return TCL_ERROR; |
| iValue = sqlite3_stmt_status(pStmt, op, resetFlag); |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(iValue)); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_next_stmt DB STMT |
| ** |
| ** Return the next statment in sequence after STMT. |
| */ |
| static int test_next_stmt( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| sqlite3 *db = 0; |
| char zBuf[50]; |
| |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " DB STMT", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| if( getStmtPointer(interp, Tcl_GetString(objv[2]), &pStmt) ) return TCL_ERROR; |
| pStmt = sqlite3_next_stmt(db, pStmt); |
| if( pStmt ){ |
| if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; |
| Tcl_AppendResult(interp, zBuf, 0); |
| } |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_stmt_readonly STMT |
| ** |
| ** Return true if STMT is a NULL pointer or a pointer to a statement |
| ** that is guaranteed to leave the database unmodified. |
| */ |
| static int test_stmt_readonly( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int rc; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " STMT", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| rc = sqlite3_stmt_readonly(pStmt); |
| Tcl_SetObjResult(interp, Tcl_NewBooleanObj(rc)); |
| return TCL_OK; |
| } |
| |
| |
| /* |
| ** Usage: sqlite3_reset STMT |
| ** |
| ** Reset a statement handle. |
| */ |
| static int test_reset( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int rc; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " <STMT>", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| |
| rc = sqlite3_reset(pStmt); |
| if( pStmt && sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ){ |
| return TCL_ERROR; |
| } |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); |
| /* |
| if( rc ){ |
| return TCL_ERROR; |
| } |
| */ |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_expired STMT |
| ** |
| ** Return TRUE if a recompilation of the statement is recommended. |
| */ |
| static int test_expired( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #ifndef SQLITE_OMIT_DEPRECATED |
| sqlite3_stmt *pStmt; |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " <STMT>", 0); |
| return TCL_ERROR; |
| } |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| Tcl_SetObjResult(interp, Tcl_NewBooleanObj(sqlite3_expired(pStmt))); |
| #endif |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_transfer_bindings FROMSTMT TOSTMT |
| ** |
| ** Transfer all bindings from FROMSTMT over to TOSTMT |
| */ |
| static int test_transfer_bind( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #ifndef SQLITE_OMIT_DEPRECATED |
| sqlite3_stmt *pStmt1, *pStmt2; |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " FROM-STMT TO-STMT", 0); |
| return TCL_ERROR; |
| } |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt1)) return TCL_ERROR; |
| if( getStmtPointer(interp, Tcl_GetString(objv[2]), &pStmt2)) return TCL_ERROR; |
| Tcl_SetObjResult(interp, |
| Tcl_NewIntObj(sqlite3_transfer_bindings(pStmt1,pStmt2))); |
| #endif |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_changes DB |
| ** |
| ** Return the number of changes made to the database by the last SQL |
| ** execution. |
| */ |
| static int test_changes( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3 *db; |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_changes(db))); |
| return TCL_OK; |
| } |
| |
| /* |
| ** This is the "static_bind_value" that variables are bound to when |
| ** the FLAG option of sqlite3_bind is "static" |
| */ |
| static char *sqlite_static_bind_value = 0; |
| static int sqlite_static_bind_nbyte = 0; |
| |
| /* |
| ** Usage: sqlite3_bind VM IDX VALUE FLAGS |
| ** |
| ** Sets the value of the IDX-th occurance of "?" in the original SQL |
| ** string. VALUE is the new value. If FLAGS=="null" then VALUE is |
| ** ignored and the value is set to NULL. If FLAGS=="static" then |
| ** the value is set to the value of a static variable named |
| ** "sqlite_static_bind_value". If FLAGS=="normal" then a copy |
| ** of the VALUE is made. If FLAGS=="blob10" then a VALUE is ignored |
| ** an a 10-byte blob "abc\000xyz\000pq" is inserted. |
| */ |
| static int test_bind( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| sqlite3_stmt *pStmt; |
| int rc; |
| int idx; |
| if( argc!=5 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " VM IDX VALUE (null|static|normal)\"", 0); |
| return TCL_ERROR; |
| } |
| if( getStmtPointer(interp, argv[1], &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetInt(interp, argv[2], &idx) ) return TCL_ERROR; |
| if( strcmp(argv[4],"null")==0 ){ |
| rc = sqlite3_bind_null(pStmt, idx); |
| }else if( strcmp(argv[4],"static")==0 ){ |
| rc = sqlite3_bind_text(pStmt, idx, sqlite_static_bind_value, -1, 0); |
| }else if( strcmp(argv[4],"static-nbytes")==0 ){ |
| rc = sqlite3_bind_text(pStmt, idx, sqlite_static_bind_value, |
| sqlite_static_bind_nbyte, 0); |
| }else if( strcmp(argv[4],"normal")==0 ){ |
| rc = sqlite3_bind_text(pStmt, idx, argv[3], -1, SQLITE_TRANSIENT); |
| }else if( strcmp(argv[4],"blob10")==0 ){ |
| rc = sqlite3_bind_text(pStmt, idx, "abc\000xyz\000pq", 10, SQLITE_STATIC); |
| }else{ |
| Tcl_AppendResult(interp, "4th argument should be " |
| "\"null\" or \"static\" or \"normal\"", 0); |
| return TCL_ERROR; |
| } |
| if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; |
| if( rc ){ |
| char zBuf[50]; |
| sprintf(zBuf, "(%d) ", rc); |
| Tcl_AppendResult(interp, zBuf, sqlite3ErrStr(rc), 0); |
| return TCL_ERROR; |
| } |
| return TCL_OK; |
| } |
| |
| #ifndef SQLITE_OMIT_UTF16 |
| /* |
| ** Usage: add_test_collate <db ptr> <utf8> <utf16le> <utf16be> |
| ** |
| ** This function is used to test that SQLite selects the correct collation |
| ** sequence callback when multiple versions (for different text encodings) |
| ** are available. |
| ** |
| ** Calling this routine registers the collation sequence "test_collate" |
| ** with database handle <db>. The second argument must be a list of three |
| ** boolean values. If the first is true, then a version of test_collate is |
| ** registered for UTF-8, if the second is true, a version is registered for |
| ** UTF-16le, if the third is true, a UTF-16be version is available. |
| ** Previous versions of test_collate are deleted. |
| ** |
| ** The collation sequence test_collate is implemented by calling the |
| ** following TCL script: |
| ** |
| ** "test_collate <enc> <lhs> <rhs>" |
| ** |
| ** The <lhs> and <rhs> are the two values being compared, encoded in UTF-8. |
| ** The <enc> parameter is the encoding of the collation function that |
| ** SQLite selected to call. The TCL test script implements the |
| ** "test_collate" proc. |
| ** |
| ** Note that this will only work with one intepreter at a time, as the |
| ** interp pointer to use when evaluating the TCL script is stored in |
| ** pTestCollateInterp. |
| */ |
| static Tcl_Interp* pTestCollateInterp; |
| static int test_collate_func( |
| void *pCtx, |
| int nA, const void *zA, |
| int nB, const void *zB |
| ){ |
| Tcl_Interp *i = pTestCollateInterp; |
| int encin = SQLITE_PTR_TO_INT(pCtx); |
| int res; |
| int n; |
| |
| sqlite3_value *pVal; |
| Tcl_Obj *pX; |
| |
| pX = Tcl_NewStringObj("test_collate", -1); |
| Tcl_IncrRefCount(pX); |
| |
| switch( encin ){ |
| case SQLITE_UTF8: |
| Tcl_ListObjAppendElement(i,pX,Tcl_NewStringObj("UTF-8",-1)); |
| break; |
| case SQLITE_UTF16LE: |
| Tcl_ListObjAppendElement(i,pX,Tcl_NewStringObj("UTF-16LE",-1)); |
| break; |
| case SQLITE_UTF16BE: |
| Tcl_ListObjAppendElement(i,pX,Tcl_NewStringObj("UTF-16BE",-1)); |
| break; |
| default: |
| assert(0); |
| } |
| |
| sqlite3BeginBenignMalloc(); |
| pVal = sqlite3ValueNew(0); |
| if( pVal ){ |
| sqlite3ValueSetStr(pVal, nA, zA, encin, SQLITE_STATIC); |
| n = sqlite3_value_bytes(pVal); |
| Tcl_ListObjAppendElement(i,pX, |
| Tcl_NewStringObj((char*)sqlite3_value_text(pVal),n)); |
| sqlite3ValueSetStr(pVal, nB, zB, encin, SQLITE_STATIC); |
| n = sqlite3_value_bytes(pVal); |
| Tcl_ListObjAppendElement(i,pX, |
| Tcl_NewStringObj((char*)sqlite3_value_text(pVal),n)); |
| sqlite3ValueFree(pVal); |
| } |
| sqlite3EndBenignMalloc(); |
| |
| Tcl_EvalObjEx(i, pX, 0); |
| Tcl_DecrRefCount(pX); |
| Tcl_GetIntFromObj(i, Tcl_GetObjResult(i), &res); |
| return res; |
| } |
| static int test_collate( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3 *db; |
| int val; |
| sqlite3_value *pVal; |
| int rc; |
| |
| if( objc!=5 ) goto bad_args; |
| pTestCollateInterp = interp; |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| |
| if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[2], &val) ) return TCL_ERROR; |
| rc = sqlite3_create_collation(db, "test_collate", SQLITE_UTF8, |
| (void *)SQLITE_UTF8, val?test_collate_func:0); |
| if( rc==SQLITE_OK ){ |
| const void *zUtf16; |
| if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[3], &val) ) return TCL_ERROR; |
| rc = sqlite3_create_collation(db, "test_collate", SQLITE_UTF16LE, |
| (void *)SQLITE_UTF16LE, val?test_collate_func:0); |
| if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[4], &val) ) return TCL_ERROR; |
| |
| #if 0 |
| if( sqlite3_iMallocFail>0 ){ |
| sqlite3_iMallocFail++; |
| } |
| #endif |
| sqlite3_mutex_enter(db->mutex); |
| pVal = sqlite3ValueNew(db); |
| sqlite3ValueSetStr(pVal, -1, "test_collate", SQLITE_UTF8, SQLITE_STATIC); |
| zUtf16 = sqlite3ValueText(pVal, SQLITE_UTF16NATIVE); |
| if( db->mallocFailed ){ |
| rc = SQLITE_NOMEM; |
| }else{ |
| rc = sqlite3_create_collation16(db, zUtf16, SQLITE_UTF16BE, |
| (void *)SQLITE_UTF16BE, val?test_collate_func:0); |
| } |
| sqlite3ValueFree(pVal); |
| sqlite3_mutex_leave(db->mutex); |
| } |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| |
| if( rc!=SQLITE_OK ){ |
| Tcl_AppendResult(interp, sqlite3TestErrorName(rc), 0); |
| return TCL_ERROR; |
| } |
| return TCL_OK; |
| |
| bad_args: |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " <DB> <utf8> <utf16le> <utf16be>", 0); |
| return TCL_ERROR; |
| } |
| |
| /* |
| ** When the collation needed callback is invoked, record the name of |
| ** the requested collating function here. The recorded name is linked |
| ** to a TCL variable and used to make sure that the requested collation |
| ** name is correct. |
| */ |
| static char zNeededCollation[200]; |
| static char *pzNeededCollation = zNeededCollation; |
| |
| |
| /* |
| ** Called when a collating sequence is needed. Registered using |
| ** sqlite3_collation_needed16(). |
| */ |
| static void test_collate_needed_cb( |
| void *pCtx, |
| sqlite3 *db, |
| int eTextRep, |
| const void *pName |
| ){ |
| int enc = ENC(db); |
| int i; |
| char *z; |
| for(z = (char*)pName, i=0; *z || z[1]; z++){ |
| if( *z ) zNeededCollation[i++] = *z; |
| } |
| zNeededCollation[i] = 0; |
| sqlite3_create_collation( |
| db, "test_collate", ENC(db), SQLITE_INT_TO_PTR(enc), test_collate_func); |
| } |
| |
| /* |
| ** Usage: add_test_collate_needed DB |
| */ |
| static int test_collate_needed( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3 *db; |
| int rc; |
| |
| if( objc!=2 ) goto bad_args; |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| rc = sqlite3_collation_needed16(db, 0, test_collate_needed_cb); |
| zNeededCollation[0] = 0; |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| return TCL_OK; |
| |
| bad_args: |
| Tcl_WrongNumArgs(interp, 1, objv, "DB"); |
| return TCL_ERROR; |
| } |
| |
| /* |
| ** tclcmd: add_alignment_test_collations DB |
| ** |
| ** Add two new collating sequences to the database DB |
| ** |
| ** utf16_aligned |
| ** utf16_unaligned |
| ** |
| ** Both collating sequences use the same sort order as BINARY. |
| ** The only difference is that the utf16_aligned collating |
| ** sequence is declared with the SQLITE_UTF16_ALIGNED flag. |
| ** Both collating functions increment the unaligned utf16 counter |
| ** whenever they see a string that begins on an odd byte boundary. |
| */ |
| static int unaligned_string_counter = 0; |
| static int alignmentCollFunc( |
| void *NotUsed, |
| int nKey1, const void *pKey1, |
| int nKey2, const void *pKey2 |
| ){ |
| int rc, n; |
| n = nKey1<nKey2 ? nKey1 : nKey2; |
| if( nKey1>0 && 1==(1&(SQLITE_PTR_TO_INT(pKey1))) ) unaligned_string_counter++; |
| if( nKey2>0 && 1==(1&(SQLITE_PTR_TO_INT(pKey2))) ) unaligned_string_counter++; |
| rc = memcmp(pKey1, pKey2, n); |
| if( rc==0 ){ |
| rc = nKey1 - nKey2; |
| } |
| return rc; |
| } |
| static int add_alignment_test_collations( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3 *db; |
| if( objc>=2 ){ |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| sqlite3_create_collation(db, "utf16_unaligned", SQLITE_UTF16, |
| 0, alignmentCollFunc); |
| sqlite3_create_collation(db, "utf16_aligned", SQLITE_UTF16_ALIGNED, |
| 0, alignmentCollFunc); |
| } |
| return SQLITE_OK; |
| } |
| #endif /* !defined(SQLITE_OMIT_UTF16) */ |
| |
| /* |
| ** Usage: add_test_function <db ptr> <utf8> <utf16le> <utf16be> |
| ** |
| ** This function is used to test that SQLite selects the correct user |
| ** function callback when multiple versions (for different text encodings) |
| ** are available. |
| ** |
| ** Calling this routine registers up to three versions of the user function |
| ** "test_function" with database handle <db>. If the second argument is |
| ** true, then a version of test_function is registered for UTF-8, if the |
| ** third is true, a version is registered for UTF-16le, if the fourth is |
| ** true, a UTF-16be version is available. Previous versions of |
| ** test_function are deleted. |
| ** |
| ** The user function is implemented by calling the following TCL script: |
| ** |
| ** "test_function <enc> <arg>" |
| ** |
| ** Where <enc> is one of UTF-8, UTF-16LE or UTF16BE, and <arg> is the |
| ** single argument passed to the SQL function. The value returned by |
| ** the TCL script is used as the return value of the SQL function. It |
| ** is passed to SQLite using UTF-16BE for a UTF-8 test_function(), UTF-8 |
| ** for a UTF-16LE test_function(), and UTF-16LE for an implementation that |
| ** prefers UTF-16BE. |
| */ |
| #ifndef SQLITE_OMIT_UTF16 |
| static void test_function_utf8( |
| sqlite3_context *pCtx, |
| int nArg, |
| sqlite3_value **argv |
| ){ |
| Tcl_Interp *interp; |
| Tcl_Obj *pX; |
| sqlite3_value *pVal; |
| interp = (Tcl_Interp *)sqlite3_user_data(pCtx); |
| pX = Tcl_NewStringObj("test_function", -1); |
| Tcl_IncrRefCount(pX); |
| Tcl_ListObjAppendElement(interp, pX, Tcl_NewStringObj("UTF-8", -1)); |
| Tcl_ListObjAppendElement(interp, pX, |
| Tcl_NewStringObj((char*)sqlite3_value_text(argv[0]), -1)); |
| Tcl_EvalObjEx(interp, pX, 0); |
| Tcl_DecrRefCount(pX); |
| sqlite3_result_text(pCtx, Tcl_GetStringResult(interp), -1, SQLITE_TRANSIENT); |
| pVal = sqlite3ValueNew(0); |
| sqlite3ValueSetStr(pVal, -1, Tcl_GetStringResult(interp), |
| SQLITE_UTF8, SQLITE_STATIC); |
| sqlite3_result_text16be(pCtx, sqlite3_value_text16be(pVal), |
| -1, SQLITE_TRANSIENT); |
| sqlite3ValueFree(pVal); |
| } |
| static void test_function_utf16le( |
| sqlite3_context *pCtx, |
| int nArg, |
| sqlite3_value **argv |
| ){ |
| Tcl_Interp *interp; |
| Tcl_Obj *pX; |
| sqlite3_value *pVal; |
| interp = (Tcl_Interp *)sqlite3_user_data(pCtx); |
| pX = Tcl_NewStringObj("test_function", -1); |
| Tcl_IncrRefCount(pX); |
| Tcl_ListObjAppendElement(interp, pX, Tcl_NewStringObj("UTF-16LE", -1)); |
| Tcl_ListObjAppendElement(interp, pX, |
| Tcl_NewStringObj((char*)sqlite3_value_text(argv[0]), -1)); |
| Tcl_EvalObjEx(interp, pX, 0); |
| Tcl_DecrRefCount(pX); |
| pVal = sqlite3ValueNew(0); |
| sqlite3ValueSetStr(pVal, -1, Tcl_GetStringResult(interp), |
| SQLITE_UTF8, SQLITE_STATIC); |
| sqlite3_result_text(pCtx,(char*)sqlite3_value_text(pVal),-1,SQLITE_TRANSIENT); |
| sqlite3ValueFree(pVal); |
| } |
| static void test_function_utf16be( |
| sqlite3_context *pCtx, |
| int nArg, |
| sqlite3_value **argv |
| ){ |
| Tcl_Interp *interp; |
| Tcl_Obj *pX; |
| sqlite3_value *pVal; |
| interp = (Tcl_Interp *)sqlite3_user_data(pCtx); |
| pX = Tcl_NewStringObj("test_function", -1); |
| Tcl_IncrRefCount(pX); |
| Tcl_ListObjAppendElement(interp, pX, Tcl_NewStringObj("UTF-16BE", -1)); |
| Tcl_ListObjAppendElement(interp, pX, |
| Tcl_NewStringObj((char*)sqlite3_value_text(argv[0]), -1)); |
| Tcl_EvalObjEx(interp, pX, 0); |
| Tcl_DecrRefCount(pX); |
| pVal = sqlite3ValueNew(0); |
| sqlite3ValueSetStr(pVal, -1, Tcl_GetStringResult(interp), |
| SQLITE_UTF8, SQLITE_STATIC); |
| sqlite3_result_text16(pCtx, sqlite3_value_text16le(pVal), |
| -1, SQLITE_TRANSIENT); |
| sqlite3_result_text16be(pCtx, sqlite3_value_text16le(pVal), |
| -1, SQLITE_TRANSIENT); |
| sqlite3_result_text16le(pCtx, sqlite3_value_text16le(pVal), |
| -1, SQLITE_TRANSIENT); |
| sqlite3ValueFree(pVal); |
| } |
| #endif /* SQLITE_OMIT_UTF16 */ |
| static int test_function( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #ifndef SQLITE_OMIT_UTF16 |
| sqlite3 *db; |
| int val; |
| |
| if( objc!=5 ) goto bad_args; |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| |
| if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[2], &val) ) return TCL_ERROR; |
| if( val ){ |
| sqlite3_create_function(db, "test_function", 1, SQLITE_UTF8, |
| interp, test_function_utf8, 0, 0); |
| } |
| if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[3], &val) ) return TCL_ERROR; |
| if( val ){ |
| sqlite3_create_function(db, "test_function", 1, SQLITE_UTF16LE, |
| interp, test_function_utf16le, 0, 0); |
| } |
| if( TCL_OK!=Tcl_GetBooleanFromObj(interp, objv[4], &val) ) return TCL_ERROR; |
| if( val ){ |
| sqlite3_create_function(db, "test_function", 1, SQLITE_UTF16BE, |
| interp, test_function_utf16be, 0, 0); |
| } |
| |
| return TCL_OK; |
| bad_args: |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " <DB> <utf8> <utf16le> <utf16be>", 0); |
| #endif /* SQLITE_OMIT_UTF16 */ |
| return TCL_ERROR; |
| } |
| |
| /* |
| ** Usage: sqlite3_test_errstr <err code> |
| ** |
| ** Test that the english language string equivalents for sqlite error codes |
| ** are sane. The parameter is an integer representing an sqlite error code. |
| ** The result is a list of two elements, the string representation of the |
| ** error code and the english language explanation. |
| */ |
| static int test_errstr( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| char *zCode; |
| int i; |
| if( objc!=1 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "<error code>"); |
| } |
| |
| zCode = Tcl_GetString(objv[1]); |
| for(i=0; i<200; i++){ |
| if( 0==strcmp(t1ErrorName(i), zCode) ) break; |
| } |
| Tcl_SetResult(interp, (char *)sqlite3ErrStr(i), 0); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: breakpoint |
| ** |
| ** This routine exists for one purpose - to provide a place to put a |
| ** breakpoint with GDB that can be triggered using TCL code. The use |
| ** for this is when a particular test fails on (say) the 1485th iteration. |
| ** In the TCL test script, we can add code like this: |
| ** |
| ** if {$i==1485} breakpoint |
| ** |
| ** Then run testfixture in the debugger and wait for the breakpoint to |
| ** fire. Then additional breakpoints can be set to trace down the bug. |
| */ |
| static int test_breakpoint( |
| void *NotUsed, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int argc, /* Number of arguments */ |
| char **argv /* Text of each argument */ |
| ){ |
| return TCL_OK; /* Do nothing */ |
| } |
| |
| /* |
| ** Usage: sqlite3_bind_zeroblob STMT IDX N |
| ** |
| ** Test the sqlite3_bind_zeroblob interface. STMT is a prepared statement. |
| ** IDX is the index of a wildcard in the prepared statement. This command |
| ** binds a N-byte zero-filled BLOB to the wildcard. |
| */ |
| static int test_bind_zeroblob( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int idx; |
| int n; |
| int rc; |
| |
| if( objc!=4 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "STMT IDX N"); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[3], &n) ) return TCL_ERROR; |
| |
| rc = sqlite3_bind_zeroblob(pStmt, idx, n); |
| if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; |
| if( rc!=SQLITE_OK ){ |
| return TCL_ERROR; |
| } |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_bind_int STMT N VALUE |
| ** |
| ** Test the sqlite3_bind_int interface. STMT is a prepared statement. |
| ** N is the index of a wildcard in the prepared statement. This command |
| ** binds a 32-bit integer VALUE to that wildcard. |
| */ |
| static int test_bind_int( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int idx; |
| int value; |
| int rc; |
| |
| if( objc!=4 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[3], &value) ) return TCL_ERROR; |
| |
| rc = sqlite3_bind_int(pStmt, idx, value); |
| if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; |
| if( rc!=SQLITE_OK ){ |
| return TCL_ERROR; |
| } |
| |
| return TCL_OK; |
| } |
| |
| |
| /* |
| ** Usage: sqlite3_bind_int64 STMT N VALUE |
| ** |
| ** Test the sqlite3_bind_int64 interface. STMT is a prepared statement. |
| ** N is the index of a wildcard in the prepared statement. This command |
| ** binds a 64-bit integer VALUE to that wildcard. |
| */ |
| static int test_bind_int64( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int idx; |
| i64 value; |
| int rc; |
| |
| if( objc!=4 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; |
| if( Tcl_GetWideIntFromObj(interp, objv[3], &value) ) return TCL_ERROR; |
| |
| rc = sqlite3_bind_int64(pStmt, idx, value); |
| if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; |
| if( rc!=SQLITE_OK ){ |
| return TCL_ERROR; |
| } |
| |
| return TCL_OK; |
| } |
| |
| |
| /* |
| ** Usage: sqlite3_bind_double STMT N VALUE |
| ** |
| ** Test the sqlite3_bind_double interface. STMT is a prepared statement. |
| ** N is the index of a wildcard in the prepared statement. This command |
| ** binds a 64-bit integer VALUE to that wildcard. |
| */ |
| static int test_bind_double( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int idx; |
| double value; |
| int rc; |
| const char *zVal; |
| int i; |
| static const struct { |
| const char *zName; /* Name of the special floating point value */ |
| unsigned int iUpper; /* Upper 32 bits */ |
| unsigned int iLower; /* Lower 32 bits */ |
| } aSpecialFp[] = { |
| { "NaN", 0x7fffffff, 0xffffffff }, |
| { "SNaN", 0x7ff7ffff, 0xffffffff }, |
| { "-NaN", 0xffffffff, 0xffffffff }, |
| { "-SNaN", 0xfff7ffff, 0xffffffff }, |
| { "+Inf", 0x7ff00000, 0x00000000 }, |
| { "-Inf", 0xfff00000, 0x00000000 }, |
| { "Epsilon", 0x00000000, 0x00000001 }, |
| { "-Epsilon", 0x80000000, 0x00000001 }, |
| { "NaN0", 0x7ff80000, 0x00000000 }, |
| { "-NaN0", 0xfff80000, 0x00000000 }, |
| }; |
| |
| if( objc!=4 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; |
| |
| /* Intercept the string "NaN" and generate a NaN value for it. |
| ** All other strings are passed through to Tcl_GetDoubleFromObj(). |
| ** Tcl_GetDoubleFromObj() should understand "NaN" but some versions |
| ** contain a bug. |
| */ |
| zVal = Tcl_GetString(objv[3]); |
| for(i=0; i<sizeof(aSpecialFp)/sizeof(aSpecialFp[0]); i++){ |
| if( strcmp(aSpecialFp[i].zName, zVal)==0 ){ |
| sqlite3_uint64 x; |
| x = aSpecialFp[i].iUpper; |
| x <<= 32; |
| x |= aSpecialFp[i].iLower; |
| assert( sizeof(value)==8 ); |
| assert( sizeof(x)==8 ); |
| memcpy(&value, &x, 8); |
| break; |
| } |
| } |
| if( i>=sizeof(aSpecialFp)/sizeof(aSpecialFp[0]) && |
| Tcl_GetDoubleFromObj(interp, objv[3], &value) ){ |
| return TCL_ERROR; |
| } |
| rc = sqlite3_bind_double(pStmt, idx, value); |
| if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; |
| if( rc!=SQLITE_OK ){ |
| return TCL_ERROR; |
| } |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_bind_null STMT N |
| ** |
| ** Test the sqlite3_bind_null interface. STMT is a prepared statement. |
| ** N is the index of a wildcard in the prepared statement. This command |
| ** binds a NULL to the wildcard. |
| */ |
| static int test_bind_null( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int idx; |
| int rc; |
| |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " STMT N", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; |
| |
| rc = sqlite3_bind_null(pStmt, idx); |
| if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; |
| if( rc!=SQLITE_OK ){ |
| return TCL_ERROR; |
| } |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_bind_text STMT N STRING BYTES |
| ** |
| ** Test the sqlite3_bind_text interface. STMT is a prepared statement. |
| ** N is the index of a wildcard in the prepared statement. This command |
| ** binds a UTF-8 string STRING to the wildcard. The string is BYTES bytes |
| ** long. |
| */ |
| static int test_bind_text( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int idx; |
| int bytes; |
| char *value; |
| int rc; |
| |
| if( objc!=5 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE BYTES", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; |
| value = (char*)Tcl_GetByteArrayFromObj(objv[3], &bytes); |
| if( Tcl_GetIntFromObj(interp, objv[4], &bytes) ) return TCL_ERROR; |
| |
| rc = sqlite3_bind_text(pStmt, idx, value, bytes, SQLITE_TRANSIENT); |
| if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; |
| if( rc!=SQLITE_OK ){ |
| Tcl_AppendResult(interp, sqlite3TestErrorName(rc), 0); |
| return TCL_ERROR; |
| } |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_bind_text16 ?-static? STMT N STRING BYTES |
| ** |
| ** Test the sqlite3_bind_text16 interface. STMT is a prepared statement. |
| ** N is the index of a wildcard in the prepared statement. This command |
| ** binds a UTF-16 string STRING to the wildcard. The string is BYTES bytes |
| ** long. |
| */ |
| static int test_bind_text16( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #ifndef SQLITE_OMIT_UTF16 |
| sqlite3_stmt *pStmt; |
| int idx; |
| int bytes; |
| char *value; |
| int rc; |
| |
| void (*xDel)() = (objc==6?SQLITE_STATIC:SQLITE_TRANSIENT); |
| Tcl_Obj *oStmt = objv[objc-4]; |
| Tcl_Obj *oN = objv[objc-3]; |
| Tcl_Obj *oString = objv[objc-2]; |
| Tcl_Obj *oBytes = objv[objc-1]; |
| |
| if( objc!=5 && objc!=6){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE BYTES", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(oStmt), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, oN, &idx) ) return TCL_ERROR; |
| value = (char*)Tcl_GetByteArrayFromObj(oString, 0); |
| if( Tcl_GetIntFromObj(interp, oBytes, &bytes) ) return TCL_ERROR; |
| |
| rc = sqlite3_bind_text16(pStmt, idx, (void *)value, bytes, xDel); |
| if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; |
| if( rc!=SQLITE_OK ){ |
| Tcl_AppendResult(interp, sqlite3TestErrorName(rc), 0); |
| return TCL_ERROR; |
| } |
| |
| #endif /* SQLITE_OMIT_UTF16 */ |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_bind_blob ?-static? STMT N DATA BYTES |
| ** |
| ** Test the sqlite3_bind_blob interface. STMT is a prepared statement. |
| ** N is the index of a wildcard in the prepared statement. This command |
| ** binds a BLOB to the wildcard. The BLOB is BYTES bytes in size. |
| */ |
| static int test_bind_blob( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int idx; |
| int bytes; |
| char *value; |
| int rc; |
| sqlite3_destructor_type xDestructor = SQLITE_TRANSIENT; |
| |
| if( objc!=5 && objc!=6 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " STMT N DATA BYTES", 0); |
| return TCL_ERROR; |
| } |
| |
| if( objc==6 ){ |
| xDestructor = SQLITE_STATIC; |
| objv++; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &idx) ) return TCL_ERROR; |
| value = Tcl_GetString(objv[3]); |
| if( Tcl_GetIntFromObj(interp, objv[4], &bytes) ) return TCL_ERROR; |
| |
| rc = sqlite3_bind_blob(pStmt, idx, value, bytes, xDestructor); |
| if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) ) return TCL_ERROR; |
| if( rc!=SQLITE_OK ){ |
| return TCL_ERROR; |
| } |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_bind_parameter_count STMT |
| ** |
| ** Return the number of wildcards in the given statement. |
| */ |
| static int test_bind_parameter_count( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| |
| if( objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "STMT"); |
| return TCL_ERROR; |
| } |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_bind_parameter_count(pStmt))); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_bind_parameter_name STMT N |
| ** |
| ** Return the name of the Nth wildcard. The first wildcard is 1. |
| ** An empty string is returned if N is out of range or if the wildcard |
| ** is nameless. |
| */ |
| static int test_bind_parameter_name( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int i; |
| |
| if( objc!=3 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "STMT N"); |
| return TCL_ERROR; |
| } |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &i) ) return TCL_ERROR; |
| Tcl_SetObjResult(interp, |
| Tcl_NewStringObj(sqlite3_bind_parameter_name(pStmt,i),-1) |
| ); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_bind_parameter_index STMT NAME |
| ** |
| ** Return the index of the wildcard called NAME. Return 0 if there is |
| ** no such wildcard. |
| */ |
| static int test_bind_parameter_index( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| |
| if( objc!=3 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "STMT NAME"); |
| return TCL_ERROR; |
| } |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| Tcl_SetObjResult(interp, |
| Tcl_NewIntObj( |
| sqlite3_bind_parameter_index(pStmt,Tcl_GetString(objv[2])) |
| ) |
| ); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_clear_bindings STMT |
| ** |
| */ |
| static int test_clear_bindings( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| |
| if( objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "STMT"); |
| return TCL_ERROR; |
| } |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_clear_bindings(pStmt))); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_sleep MILLISECONDS |
| */ |
| static int test_sleep( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| int ms; |
| |
| if( objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "MILLISECONDS"); |
| return TCL_ERROR; |
| } |
| if( Tcl_GetIntFromObj(interp, objv[1], &ms) ){ |
| return TCL_ERROR; |
| } |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_sleep(ms))); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_extended_errcode DB |
| ** |
| ** Return the string representation of the most recent sqlite3_* API |
| ** error code. e.g. "SQLITE_ERROR". |
| */ |
| static int test_ex_errcode( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3 *db; |
| int rc; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| rc = sqlite3_extended_errcode(db); |
| Tcl_AppendResult(interp, (char *)t1ErrorName(rc), 0); |
| return TCL_OK; |
| } |
| |
| |
| /* |
| ** Usage: sqlite3_errcode DB |
| ** |
| ** Return the string representation of the most recent sqlite3_* API |
| ** error code. e.g. "SQLITE_ERROR". |
| */ |
| static int test_errcode( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3 *db; |
| int rc; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| rc = sqlite3_errcode(db); |
| Tcl_AppendResult(interp, (char *)t1ErrorName(rc), 0); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_errmsg DB |
| ** |
| ** Returns the UTF-8 representation of the error message string for the |
| ** most recent sqlite3_* API call. |
| */ |
| static int test_errmsg( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3 *db; |
| const char *zErr; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| |
| zErr = sqlite3_errmsg(db); |
| Tcl_SetObjResult(interp, Tcl_NewStringObj(zErr, -1)); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: test_errmsg16 DB |
| ** |
| ** Returns the UTF-16 representation of the error message string for the |
| ** most recent sqlite3_* API call. This is a byte array object at the TCL |
| ** level, and it includes the 0x00 0x00 terminator bytes at the end of the |
| ** UTF-16 string. |
| */ |
| static int test_errmsg16( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #ifndef SQLITE_OMIT_UTF16 |
| sqlite3 *db; |
| const void *zErr; |
| const char *z; |
| int bytes = 0; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| |
| zErr = sqlite3_errmsg16(db); |
| if( zErr ){ |
| z = zErr; |
| for(bytes=0; z[bytes] || z[bytes+1]; bytes+=2){} |
| } |
| Tcl_SetObjResult(interp, Tcl_NewByteArrayObj(zErr, bytes)); |
| #endif /* SQLITE_OMIT_UTF16 */ |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_prepare DB sql bytes ?tailvar? |
| ** |
| ** Compile up to <bytes> bytes of the supplied SQL string <sql> using |
| ** database handle <DB>. The parameter <tailval> is the name of a global |
| ** variable that is set to the unused portion of <sql> (if any). A |
| ** STMT handle is returned. |
| */ |
| static int test_prepare( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3 *db; |
| const char *zSql; |
| int bytes; |
| const char *zTail = 0; |
| sqlite3_stmt *pStmt = 0; |
| char zBuf[50]; |
| int rc; |
| |
| if( objc!=5 && objc!=4 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " DB sql bytes ?tailvar?", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| zSql = Tcl_GetString(objv[2]); |
| if( Tcl_GetIntFromObj(interp, objv[3], &bytes) ) return TCL_ERROR; |
| |
| rc = sqlite3_prepare(db, zSql, bytes, &pStmt, objc>=5 ? &zTail : 0); |
| Tcl_ResetResult(interp); |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| if( zTail && objc>=5 ){ |
| if( bytes>=0 ){ |
| bytes = bytes - (zTail-zSql); |
| } |
| if( strlen(zTail)<bytes ){ |
| bytes = strlen(zTail); |
| } |
| Tcl_ObjSetVar2(interp, objv[4], 0, Tcl_NewStringObj(zTail, bytes), 0); |
| } |
| if( rc!=SQLITE_OK ){ |
| assert( pStmt==0 ); |
| sprintf(zBuf, "(%d) ", rc); |
| Tcl_AppendResult(interp, zBuf, sqlite3_errmsg(db), 0); |
| return TCL_ERROR; |
| } |
| |
| if( pStmt ){ |
| if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; |
| Tcl_AppendResult(interp, zBuf, 0); |
| } |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_prepare_v2 DB sql bytes ?tailvar? |
| ** |
| ** Compile up to <bytes> bytes of the supplied SQL string <sql> using |
| ** database handle <DB>. The parameter <tailval> is the name of a global |
| ** variable that is set to the unused portion of <sql> (if any). A |
| ** STMT handle is returned. |
| */ |
| static int test_prepare_v2( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3 *db; |
| const char *zSql; |
| int bytes; |
| const char *zTail = 0; |
| sqlite3_stmt *pStmt = 0; |
| char zBuf[50]; |
| int rc; |
| |
| if( objc!=5 && objc!=4 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " DB sql bytes tailvar", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| zSql = Tcl_GetString(objv[2]); |
| if( Tcl_GetIntFromObj(interp, objv[3], &bytes) ) return TCL_ERROR; |
| |
| rc = sqlite3_prepare_v2(db, zSql, bytes, &pStmt, objc>=5 ? &zTail : 0); |
| assert(rc==SQLITE_OK || pStmt==0); |
| Tcl_ResetResult(interp); |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| if( zTail && objc>=5 ){ |
| if( bytes>=0 ){ |
| bytes = bytes - (zTail-zSql); |
| } |
| Tcl_ObjSetVar2(interp, objv[4], 0, Tcl_NewStringObj(zTail, bytes), 0); |
| } |
| if( rc!=SQLITE_OK ){ |
| assert( pStmt==0 ); |
| sprintf(zBuf, "(%d) ", rc); |
| Tcl_AppendResult(interp, zBuf, sqlite3_errmsg(db), 0); |
| return TCL_ERROR; |
| } |
| |
| if( pStmt ){ |
| if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; |
| Tcl_AppendResult(interp, zBuf, 0); |
| } |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_prepare_tkt3134 DB |
| ** |
| ** Generate a prepared statement for a zero-byte string as a test |
| ** for ticket #3134. The string should be preceeded by a zero byte. |
| */ |
| static int test_prepare_tkt3134( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3 *db; |
| static const char zSql[] = "\000SELECT 1"; |
| sqlite3_stmt *pStmt = 0; |
| char zBuf[50]; |
| int rc; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " DB sql bytes tailvar", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| rc = sqlite3_prepare_v2(db, &zSql[1], 0, &pStmt, 0); |
| assert(rc==SQLITE_OK || pStmt==0); |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| if( rc!=SQLITE_OK ){ |
| assert( pStmt==0 ); |
| sprintf(zBuf, "(%d) ", rc); |
| Tcl_AppendResult(interp, zBuf, sqlite3_errmsg(db), 0); |
| return TCL_ERROR; |
| } |
| |
| if( pStmt ){ |
| if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; |
| Tcl_AppendResult(interp, zBuf, 0); |
| } |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_prepare16 DB sql bytes tailvar |
| ** |
| ** Compile up to <bytes> bytes of the supplied SQL string <sql> using |
| ** database handle <DB>. The parameter <tailval> is the name of a global |
| ** variable that is set to the unused portion of <sql> (if any). A |
| ** STMT handle is returned. |
| */ |
| static int test_prepare16( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #ifndef SQLITE_OMIT_UTF16 |
| sqlite3 *db; |
| const void *zSql; |
| const void *zTail = 0; |
| Tcl_Obj *pTail = 0; |
| sqlite3_stmt *pStmt = 0; |
| char zBuf[50]; |
| int rc; |
| int bytes; /* The integer specified as arg 3 */ |
| int objlen; /* The byte-array length of arg 2 */ |
| |
| if( objc!=5 && objc!=4 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " DB sql bytes ?tailvar?", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| zSql = Tcl_GetByteArrayFromObj(objv[2], &objlen); |
| if( Tcl_GetIntFromObj(interp, objv[3], &bytes) ) return TCL_ERROR; |
| |
| rc = sqlite3_prepare16(db, zSql, bytes, &pStmt, objc>=5 ? &zTail : 0); |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| if( rc ){ |
| return TCL_ERROR; |
| } |
| |
| if( objc>=5 ){ |
| if( zTail ){ |
| objlen = objlen - ((u8 *)zTail-(u8 *)zSql); |
| }else{ |
| objlen = 0; |
| } |
| pTail = Tcl_NewByteArrayObj((u8 *)zTail, objlen); |
| Tcl_IncrRefCount(pTail); |
| Tcl_ObjSetVar2(interp, objv[4], 0, pTail, 0); |
| Tcl_DecrRefCount(pTail); |
| } |
| |
| if( pStmt ){ |
| if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; |
| } |
| Tcl_AppendResult(interp, zBuf, 0); |
| #endif /* SQLITE_OMIT_UTF16 */ |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_prepare16_v2 DB sql bytes ?tailvar? |
| ** |
| ** Compile up to <bytes> bytes of the supplied SQL string <sql> using |
| ** database handle <DB>. The parameter <tailval> is the name of a global |
| ** variable that is set to the unused portion of <sql> (if any). A |
| ** STMT handle is returned. |
| */ |
| static int test_prepare16_v2( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #ifndef SQLITE_OMIT_UTF16 |
| sqlite3 *db; |
| const void *zSql; |
| const void *zTail = 0; |
| Tcl_Obj *pTail = 0; |
| sqlite3_stmt *pStmt = 0; |
| char zBuf[50]; |
| int rc; |
| int bytes; /* The integer specified as arg 3 */ |
| int objlen; /* The byte-array length of arg 2 */ |
| |
| if( objc!=5 && objc!=4 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " DB sql bytes ?tailvar?", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| zSql = Tcl_GetByteArrayFromObj(objv[2], &objlen); |
| if( Tcl_GetIntFromObj(interp, objv[3], &bytes) ) return TCL_ERROR; |
| |
| rc = sqlite3_prepare16_v2(db, zSql, bytes, &pStmt, objc>=5 ? &zTail : 0); |
| if( sqlite3TestErrCode(interp, db, rc) ) return TCL_ERROR; |
| if( rc ){ |
| return TCL_ERROR; |
| } |
| |
| if( objc>=5 ){ |
| if( zTail ){ |
| objlen = objlen - ((u8 *)zTail-(u8 *)zSql); |
| }else{ |
| objlen = 0; |
| } |
| pTail = Tcl_NewByteArrayObj((u8 *)zTail, objlen); |
| Tcl_IncrRefCount(pTail); |
| Tcl_ObjSetVar2(interp, objv[4], 0, pTail, 0); |
| Tcl_DecrRefCount(pTail); |
| } |
| |
| if( pStmt ){ |
| if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL_ERROR; |
| } |
| Tcl_AppendResult(interp, zBuf, 0); |
| #endif /* SQLITE_OMIT_UTF16 */ |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_open filename ?options-list? |
| */ |
| static int test_open( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| const char *zFilename; |
| sqlite3 *db; |
| int rc; |
| char zBuf[100]; |
| |
| if( objc!=3 && objc!=2 && objc!=1 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " filename options-list", 0); |
| return TCL_ERROR; |
| } |
| |
| zFilename = objc>1 ? Tcl_GetString(objv[1]) : 0; |
| rc = sqlite3_open(zFilename, &db); |
| |
| if( sqlite3TestMakePointerStr(interp, zBuf, db) ) return TCL_ERROR; |
| Tcl_AppendResult(interp, zBuf, 0); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_open16 filename options |
| */ |
| static int test_open16( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #ifndef SQLITE_OMIT_UTF16 |
| const void *zFilename; |
| sqlite3 *db; |
| int rc; |
| char zBuf[100]; |
| |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " filename options-list", 0); |
| return TCL_ERROR; |
| } |
| |
| zFilename = Tcl_GetByteArrayFromObj(objv[1], 0); |
| rc = sqlite3_open16(zFilename, &db); |
| |
| if( sqlite3TestMakePointerStr(interp, zBuf, db) ) return TCL_ERROR; |
| Tcl_AppendResult(interp, zBuf, 0); |
| #endif /* SQLITE_OMIT_UTF16 */ |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_complete16 <UTF-16 string> |
| ** |
| ** Return 1 if the supplied argument is a complete SQL statement, or zero |
| ** otherwise. |
| */ |
| static int test_complete16( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #if !defined(SQLITE_OMIT_COMPLETE) && !defined(SQLITE_OMIT_UTF16) |
| char *zBuf; |
| |
| if( objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "<utf-16 sql>"); |
| return TCL_ERROR; |
| } |
| |
| zBuf = (char*)Tcl_GetByteArrayFromObj(objv[1], 0); |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_complete16(zBuf))); |
| #endif /* SQLITE_OMIT_COMPLETE && SQLITE_OMIT_UTF16 */ |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_step STMT |
| ** |
| ** Advance the statement to the next row. |
| */ |
| static int test_step( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int rc; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " STMT", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| rc = sqlite3_step(pStmt); |
| |
| /* if( rc!=SQLITE_DONE && rc!=SQLITE_ROW ) return TCL_ERROR; */ |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), 0); |
| return TCL_OK; |
| } |
| |
| static int test_sql( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| |
| if( objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "STMT"); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| Tcl_SetResult(interp, (char *)sqlite3_sql(pStmt), TCL_VOLATILE); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_column_count STMT |
| ** |
| ** Return the number of columns returned by the sql statement STMT. |
| */ |
| static int test_column_count( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " STMT column", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_column_count(pStmt))); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_column_type STMT column |
| ** |
| ** Return the type of the data in column 'column' of the current row. |
| */ |
| static int test_column_type( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int col; |
| int tp; |
| |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " STMT column", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; |
| |
| tp = sqlite3_column_type(pStmt, col); |
| switch( tp ){ |
| case SQLITE_INTEGER: |
| Tcl_SetResult(interp, "INTEGER", TCL_STATIC); |
| break; |
| case SQLITE_NULL: |
| Tcl_SetResult(interp, "NULL", TCL_STATIC); |
| break; |
| case SQLITE_FLOAT: |
| Tcl_SetResult(interp, "FLOAT", TCL_STATIC); |
| break; |
| case SQLITE_TEXT: |
| Tcl_SetResult(interp, "TEXT", TCL_STATIC); |
| break; |
| case SQLITE_BLOB: |
| Tcl_SetResult(interp, "BLOB", TCL_STATIC); |
| break; |
| default: |
| assert(0); |
| } |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_column_int64 STMT column |
| ** |
| ** Return the data in column 'column' of the current row cast as an |
| ** wide (64-bit) integer. |
| */ |
| static int test_column_int64( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int col; |
| i64 iVal; |
| |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " STMT column", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; |
| |
| iVal = sqlite3_column_int64(pStmt, col); |
| Tcl_SetObjResult(interp, Tcl_NewWideIntObj(iVal)); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_column_blob STMT column |
| */ |
| static int test_column_blob( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int col; |
| |
| int len; |
| const void *pBlob; |
| |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " STMT column", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; |
| |
| len = sqlite3_column_bytes(pStmt, col); |
| pBlob = sqlite3_column_blob(pStmt, col); |
| Tcl_SetObjResult(interp, Tcl_NewByteArrayObj(pBlob, len)); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_column_double STMT column |
| ** |
| ** Return the data in column 'column' of the current row cast as a double. |
| */ |
| static int test_column_double( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int col; |
| double rVal; |
| |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " STMT column", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; |
| |
| rVal = sqlite3_column_double(pStmt, col); |
| Tcl_SetObjResult(interp, Tcl_NewDoubleObj(rVal)); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_data_count STMT |
| ** |
| ** Return the number of columns returned by the sql statement STMT. |
| */ |
| static int test_data_count( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " STMT column", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(sqlite3_data_count(pStmt))); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_column_text STMT column |
| ** |
| ** Usage: sqlite3_column_decltype STMT column |
| ** |
| ** Usage: sqlite3_column_name STMT column |
| */ |
| static int test_stmt_utf8( |
| void * clientData, /* Pointer to SQLite API function to be invoke */ |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int col; |
| const char *(*xFunc)(sqlite3_stmt*, int); |
| const char *zRet; |
| |
| xFunc = (const char *(*)(sqlite3_stmt*, int))clientData; |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " STMT column", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; |
| zRet = xFunc(pStmt, col); |
| if( zRet ){ |
| Tcl_SetResult(interp, (char *)zRet, 0); |
| } |
| return TCL_OK; |
| } |
| |
| static int test_global_recover( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #ifndef SQLITE_OMIT_DEPRECATED |
| int rc; |
| if( objc!=1 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, ""); |
| return TCL_ERROR; |
| } |
| rc = sqlite3_global_recover(); |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); |
| #endif |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_column_text STMT column |
| ** |
| ** Usage: sqlite3_column_decltype STMT column |
| ** |
| ** Usage: sqlite3_column_name STMT column |
| */ |
| static int test_stmt_utf16( |
| void * clientData, /* Pointer to SQLite API function to be invoked */ |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #ifndef SQLITE_OMIT_UTF16 |
| sqlite3_stmt *pStmt; |
| int col; |
| Tcl_Obj *pRet; |
| const void *zName16; |
| const void *(*xFunc)(sqlite3_stmt*, int); |
| |
| xFunc = (const void *(*)(sqlite3_stmt*, int))clientData; |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " STMT column", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; |
| |
| zName16 = xFunc(pStmt, col); |
| if( zName16 ){ |
| int n; |
| const char *z = zName16; |
| for(n=0; z[n] || z[n+1]; n+=2){} |
| pRet = Tcl_NewByteArrayObj(zName16, n+2); |
| Tcl_SetObjResult(interp, pRet); |
| } |
| #endif /* SQLITE_OMIT_UTF16 */ |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_column_int STMT column |
| ** |
| ** Usage: sqlite3_column_bytes STMT column |
| ** |
| ** Usage: sqlite3_column_bytes16 STMT column |
| ** |
| */ |
| static int test_stmt_int( |
| void * clientData, /* Pointer to SQLite API function to be invoked */ |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_stmt *pStmt; |
| int col; |
| int (*xFunc)(sqlite3_stmt*, int); |
| |
| xFunc = (int (*)(sqlite3_stmt*, int))clientData; |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetString(objv[0]), " STMT column", 0); |
| return TCL_ERROR; |
| } |
| |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| if( Tcl_GetIntFromObj(interp, objv[2], &col) ) return TCL_ERROR; |
| |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(xFunc(pStmt, col))); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite_set_magic DB MAGIC-NUMBER |
| ** |
| ** Set the db->magic value. This is used to test error recovery logic. |
| */ |
| static int sqlite_set_magic( |
| void * clientData, |
| Tcl_Interp *interp, |
| int argc, |
| char **argv |
| ){ |
| sqlite3 *db; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB MAGIC", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| if( strcmp(argv[2], "SQLITE_MAGIC_OPEN")==0 ){ |
| db->magic = SQLITE_MAGIC_OPEN; |
| }else if( strcmp(argv[2], "SQLITE_MAGIC_CLOSED")==0 ){ |
| db->magic = SQLITE_MAGIC_CLOSED; |
| }else if( strcmp(argv[2], "SQLITE_MAGIC_BUSY")==0 ){ |
| db->magic = SQLITE_MAGIC_BUSY; |
| }else if( strcmp(argv[2], "SQLITE_MAGIC_ERROR")==0 ){ |
| db->magic = SQLITE_MAGIC_ERROR; |
| }else if( Tcl_GetInt(interp, argv[2], (int*)&db->magic) ){ |
| return TCL_ERROR; |
| } |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_interrupt DB |
| ** |
| ** Trigger an interrupt on DB |
| */ |
| static int test_interrupt( |
| void * clientData, |
| Tcl_Interp *interp, |
| int argc, |
| char **argv |
| ){ |
| sqlite3 *db; |
| if( argc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| sqlite3_interrupt(db); |
| return TCL_OK; |
| } |
| |
| static u8 *sqlite3_stack_baseline = 0; |
| |
| /* |
| ** Fill the stack with a known bitpattern. |
| */ |
| static void prepStack(void){ |
| int i; |
| u32 bigBuf[65536]; |
| for(i=0; i<sizeof(bigBuf); i++) bigBuf[i] = 0xdeadbeef; |
| sqlite3_stack_baseline = (u8*)&bigBuf[65536]; |
| } |
| |
| /* |
| ** Get the current stack depth. Used for debugging only. |
| */ |
| u64 sqlite3StackDepth(void){ |
| u8 x; |
| return (u64)(sqlite3_stack_baseline - &x); |
| } |
| |
| /* |
| ** Usage: sqlite3_stack_used DB SQL |
| ** |
| ** Try to measure the amount of stack space used by a call to sqlite3_exec |
| */ |
| static int test_stack_used( |
| void * clientData, |
| Tcl_Interp *interp, |
| int argc, |
| char **argv |
| ){ |
| sqlite3 *db; |
| int i; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB SQL", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| prepStack(); |
| (void)sqlite3_exec(db, argv[2], 0, 0, 0); |
| for(i=65535; i>=0 && ((u32*)sqlite3_stack_baseline)[-i]==0xdeadbeef; i--){} |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(i*4)); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite_delete_function DB function-name |
| ** |
| ** Delete the user function 'function-name' from database handle DB. It |
| ** is assumed that the user function was created as UTF8, any number of |
| ** arguments (the way the TCL interface does it). |
| */ |
| static int delete_function( |
| void * clientData, |
| Tcl_Interp *interp, |
| int argc, |
| char **argv |
| ){ |
| int rc; |
| sqlite3 *db; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB function-name", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| rc = sqlite3_create_function(db, argv[2], -1, SQLITE_UTF8, 0, 0, 0, 0); |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite_delete_collation DB collation-name |
| ** |
| ** Delete the collation sequence 'collation-name' from database handle |
| ** DB. It is assumed that the collation sequence was created as UTF8 (the |
| ** way the TCL interface does it). |
| */ |
| static int delete_collation( |
| void * clientData, |
| Tcl_Interp *interp, |
| int argc, |
| char **argv |
| ){ |
| int rc; |
| sqlite3 *db; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB function-name", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| rc = sqlite3_create_collation(db, argv[2], SQLITE_UTF8, 0, 0); |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_get_autocommit DB |
| ** |
| ** Return true if the database DB is currently in auto-commit mode. |
| ** Return false if not. |
| */ |
| static int get_autocommit( |
| void * clientData, |
| Tcl_Interp *interp, |
| int argc, |
| char **argv |
| ){ |
| char zBuf[30]; |
| sqlite3 *db; |
| if( argc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| sprintf(zBuf, "%d", sqlite3_get_autocommit(db)); |
| Tcl_AppendResult(interp, zBuf, 0); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_busy_timeout DB MS |
| ** |
| ** Set the busy timeout. This is more easily done using the timeout |
| ** method of the TCL interface. But we need a way to test the case |
| ** where it returns SQLITE_MISUSE. |
| */ |
| static int test_busy_timeout( |
| void * clientData, |
| Tcl_Interp *interp, |
| int argc, |
| char **argv |
| ){ |
| int rc, ms; |
| sqlite3 *db; |
| if( argc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], |
| " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, argv[1], &db) ) return TCL_ERROR; |
| if( Tcl_GetInt(interp, argv[2], &ms) ) return TCL_ERROR; |
| rc = sqlite3_busy_timeout(db, ms); |
| Tcl_AppendResult(interp, sqlite3TestErrorName(rc), 0); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: tcl_variable_type VARIABLENAME |
| ** |
| ** Return the name of the internal representation for the |
| ** value of the given variable. |
| */ |
| static int tcl_variable_type( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| Tcl_Obj *pVar; |
| if( objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "VARIABLE"); |
| return TCL_ERROR; |
| } |
| pVar = Tcl_GetVar2Ex(interp, Tcl_GetString(objv[1]), 0, TCL_LEAVE_ERR_MSG); |
| if( pVar==0 ) return TCL_ERROR; |
| if( pVar->typePtr ){ |
| Tcl_SetObjResult(interp, Tcl_NewStringObj(pVar->typePtr->name, -1)); |
| } |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_release_memory ?N? |
| ** |
| ** Attempt to release memory currently held but not actually required. |
| ** The integer N is the number of bytes we are trying to release. The |
| ** return value is the amount of memory actually released. |
| */ |
| static int test_release_memory( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #if defined(SQLITE_ENABLE_MEMORY_MANAGEMENT) && !defined(SQLITE_OMIT_DISKIO) |
| int N; |
| int amt; |
| if( objc!=1 && objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "?N?"); |
| return TCL_ERROR; |
| } |
| if( objc==2 ){ |
| if( Tcl_GetIntFromObj(interp, objv[1], &N) ) return TCL_ERROR; |
| }else{ |
| N = -1; |
| } |
| amt = sqlite3_release_memory(N); |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(amt)); |
| #endif |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_soft_heap_limit ?N? |
| ** |
| ** Query or set the soft heap limit for the current thread. The |
| ** limit is only changed if the N is present. The previous limit |
| ** is returned. |
| */ |
| static int test_soft_heap_limit( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3_int64 amt; |
| sqlite3_int64 N = -1; |
| if( objc!=1 && objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "?N?"); |
| return TCL_ERROR; |
| } |
| if( objc==2 ){ |
| if( Tcl_GetWideIntFromObj(interp, objv[1], &N) ) return TCL_ERROR; |
| } |
| amt = sqlite3_soft_heap_limit64(N); |
| Tcl_SetObjResult(interp, Tcl_NewWideIntObj(amt)); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_thread_cleanup |
| ** |
| ** Call the sqlite3_thread_cleanup API. |
| */ |
| static int test_thread_cleanup( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| #ifndef SQLITE_OMIT_DEPRECATED |
| sqlite3_thread_cleanup(); |
| #endif |
| return TCL_OK; |
| } |
| |
| /* |
| ** Usage: sqlite3_pager_refcounts DB |
| ** |
| ** Return a list of numbers which are the PagerRefcount for all |
| ** pagers on each database connection. |
| */ |
| static int test_pager_refcounts( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| sqlite3 *db; |
| int i; |
| int v, *a; |
| Tcl_Obj *pResult; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| pResult = Tcl_NewObj(); |
| for(i=0; i<db->nDb; i++){ |
| if( db->aDb[i].pBt==0 ){ |
| v = -1; |
| }else{ |
| sqlite3_mutex_enter(db->mutex); |
| a = sqlite3PagerStats(sqlite3BtreePager(db->aDb[i].pBt)); |
| v = a[0]; |
| sqlite3_mutex_leave(db->mutex); |
| } |
| Tcl_ListObjAppendElement(0, pResult, Tcl_NewIntObj(v)); |
| } |
| Tcl_SetObjResult(interp, pResult); |
| return TCL_OK; |
| } |
| |
| |
| /* |
| ** tclcmd: working_64bit_int |
| ** |
| ** Some TCL builds (ex: cygwin) do not support 64-bit integers. This |
| ** leads to a number of test failures. The present command checks the |
| ** TCL build to see whether or not it supports 64-bit integers. It |
| ** returns TRUE if it does and FALSE if not. |
| ** |
| ** This command is used to warn users that their TCL build is defective |
| ** and that the errors they are seeing in the test scripts might be |
| ** a result of their defective TCL rather than problems in SQLite. |
| */ |
| static int working_64bit_int( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| Tcl_Obj *pTestObj; |
| int working = 0; |
| |
| pTestObj = Tcl_NewWideIntObj(1000000*(i64)1234567890); |
| working = strcmp(Tcl_GetString(pTestObj), "1234567890000000")==0; |
| Tcl_DecrRefCount(pTestObj); |
| Tcl_SetObjResult(interp, Tcl_NewBooleanObj(working)); |
| return TCL_OK; |
| } |
| |
| |
| /* |
| ** tclcmd: vfs_unlink_test |
| ** |
| ** This TCL command unregisters the primary VFS and then registers |
| ** it back again. This is used to test the ability to register a |
| ** VFS when none are previously registered, and the ability to |
| ** unregister the only available VFS. Ticket #2738 |
| */ |
| static int vfs_unlink_test( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| int i; |
| sqlite3_vfs *pMain; |
| sqlite3_vfs *apVfs[20]; |
| sqlite3_vfs one, two; |
| |
| sqlite3_vfs_unregister(0); /* Unregister of NULL is harmless */ |
| one.zName = "__one"; |
| two.zName = "__two"; |
| |
| /* Calling sqlite3_vfs_register with 2nd argument of 0 does not |
| ** change the default VFS |
| */ |
| pMain = sqlite3_vfs_find(0); |
| sqlite3_vfs_register(&one, 0); |
| assert( pMain==0 || pMain==sqlite3_vfs_find(0) ); |
| sqlite3_vfs_register(&two, 0); |
| assert( pMain==0 || pMain==sqlite3_vfs_find(0) ); |
| |
| /* We can find a VFS by its name */ |
| assert( sqlite3_vfs_find("__one")==&one ); |
| assert( sqlite3_vfs_find("__two")==&two ); |
| |
| /* Calling sqlite_vfs_register with non-zero second parameter changes the |
| ** default VFS, even if the 1st parameter is an existig VFS that is |
| ** previously registered as the non-default. |
| */ |
| sqlite3_vfs_register(&one, 1); |
| assert( sqlite3_vfs_find("__one")==&one ); |
| assert( sqlite3_vfs_find("__two")==&two ); |
| assert( sqlite3_vfs_find(0)==&one ); |
| sqlite3_vfs_register(&two, 1); |
| assert( sqlite3_vfs_find("__one")==&one ); |
| assert( sqlite3_vfs_find("__two")==&two ); |
| assert( sqlite3_vfs_find(0)==&two ); |
| if( pMain ){ |
| sqlite3_vfs_register(pMain, 1); |
| assert( sqlite3_vfs_find("__one")==&one ); |
| assert( sqlite3_vfs_find("__two")==&two ); |
| assert( sqlite3_vfs_find(0)==pMain ); |
| } |
| |
| /* Unlink the default VFS. Repeat until there are no more VFSes |
| ** registered. |
| */ |
| for(i=0; i<sizeof(apVfs)/sizeof(apVfs[0]); i++){ |
| apVfs[i] = sqlite3_vfs_find(0); |
| if( apVfs[i] ){ |
| assert( apVfs[i]==sqlite3_vfs_find(apVfs[i]->zName) ); |
| sqlite3_vfs_unregister(apVfs[i]); |
| assert( 0==sqlite3_vfs_find(apVfs[i]->zName) ); |
| } |
| } |
| assert( 0==sqlite3_vfs_find(0) ); |
| |
| /* Register the main VFS as non-default (will be made default, since |
| ** it'll be the only one in existence). |
| */ |
| sqlite3_vfs_register(pMain, 0); |
| assert( sqlite3_vfs_find(0)==pMain ); |
| |
| /* Un-register the main VFS again to restore an empty VFS list */ |
| sqlite3_vfs_unregister(pMain); |
| assert( 0==sqlite3_vfs_find(0) ); |
| |
| /* Relink all VFSes in reverse order. */ |
| for(i=sizeof(apVfs)/sizeof(apVfs[0])-1; i>=0; i--){ |
| if( apVfs[i] ){ |
| sqlite3_vfs_register(apVfs[i], 1); |
| assert( apVfs[i]==sqlite3_vfs_find(0) ); |
| assert( apVfs[i]==sqlite3_vfs_find(apVfs[i]->zName) ); |
| } |
| } |
| |
| /* Unregister out sample VFSes. */ |
| sqlite3_vfs_unregister(&one); |
| sqlite3_vfs_unregister(&two); |
| |
| /* Unregistering a VFS that is not currently registered is harmless */ |
| sqlite3_vfs_unregister(&one); |
| sqlite3_vfs_unregister(&two); |
| assert( sqlite3_vfs_find("__one")==0 ); |
| assert( sqlite3_vfs_find("__two")==0 ); |
| |
| /* We should be left with the original default VFS back as the |
| ** original */ |
| assert( sqlite3_vfs_find(0)==pMain ); |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** tclcmd: vfs_initfail_test |
| ** |
| ** This TCL command attempts to vfs_find and vfs_register when the |
| ** sqlite3_initialize() interface is failing. All calls should fail. |
| */ |
| static int vfs_initfail_test( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3_vfs one; |
| one.zName = "__one"; |
| |
| if( sqlite3_vfs_find(0) ) return TCL_ERROR; |
| sqlite3_vfs_register(&one, 0); |
| if( sqlite3_vfs_find(0) ) return TCL_ERROR; |
| sqlite3_vfs_register(&one, 1); |
| if( sqlite3_vfs_find(0) ) return TCL_ERROR; |
| return TCL_OK; |
| } |
| |
| /* |
| ** Saved VFSes |
| */ |
| static sqlite3_vfs *apVfs[20]; |
| static int nVfs = 0; |
| |
| /* |
| ** tclcmd: vfs_unregister_all |
| ** |
| ** Unregister all VFSes. |
| */ |
| static int vfs_unregister_all( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| int i; |
| for(i=0; i<ArraySize(apVfs); i++){ |
| apVfs[i] = sqlite3_vfs_find(0); |
| if( apVfs[i]==0 ) break; |
| sqlite3_vfs_unregister(apVfs[i]); |
| } |
| nVfs = i; |
| return TCL_OK; |
| } |
| /* |
| ** tclcmd: vfs_reregister_all |
| ** |
| ** Restore all VFSes that were removed using vfs_unregister_all |
| */ |
| static int vfs_reregister_all( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| int i; |
| for(i=0; i<nVfs; i++){ |
| sqlite3_vfs_register(apVfs[i], i==0); |
| } |
| return TCL_OK; |
| } |
| |
| |
| /* |
| ** tclcmd: file_control_test DB |
| ** |
| ** This TCL command runs the sqlite3_file_control interface and |
| ** verifies correct operation of the same. |
| */ |
| static int file_control_test( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| int iArg = 0; |
| sqlite3 *db; |
| int rc; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| rc = sqlite3_file_control(db, 0, 0, &iArg); |
| assert( rc==SQLITE_NOTFOUND ); |
| rc = sqlite3_file_control(db, "notadatabase", SQLITE_FCNTL_LOCKSTATE, &iArg); |
| assert( rc==SQLITE_ERROR ); |
| rc = sqlite3_file_control(db, "main", -1, &iArg); |
| assert( rc==SQLITE_NOTFOUND ); |
| rc = sqlite3_file_control(db, "temp", -1, &iArg); |
| assert( rc==SQLITE_NOTFOUND || rc==SQLITE_ERROR ); |
| |
| return TCL_OK; |
| } |
| |
| |
| /* |
| ** tclcmd: file_control_lasterrno_test DB |
| ** |
| ** This TCL command runs the sqlite3_file_control interface and |
| ** verifies correct operation of the SQLITE_LAST_ERRNO verb. |
| */ |
| static int file_control_lasterrno_test( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| int iArg = 0; |
| sqlite3 *db; |
| int rc; |
| |
| if( objc!=2 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " DB", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ){ |
| return TCL_ERROR; |
| } |
| rc = sqlite3_file_control(db, NULL, SQLITE_LAST_ERRNO, &iArg); |
| if( rc ){ |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(rc)); |
| return TCL_ERROR; |
| } |
| if( iArg!=0 ) { |
| Tcl_AppendResult(interp, "Unexpected non-zero errno: ", |
| Tcl_GetStringFromObj(Tcl_NewIntObj(iArg), 0), " ", 0); |
| return TCL_ERROR; |
| } |
| return TCL_OK; |
| } |
| |
| /* |
| ** tclcmd: file_control_chunksize_test DB DBNAME SIZE |
| ** |
| ** This TCL command runs the sqlite3_file_control interface and |
| ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and |
| ** SQLITE_SET_LOCKPROXYFILE verbs. |
| */ |
| static int file_control_chunksize_test( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| int nSize; /* New chunk size */ |
| char *zDb; /* Db name ("main", "temp" etc.) */ |
| sqlite3 *db; /* Database handle */ |
| int rc; /* file_control() return code */ |
| |
| if( objc!=4 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB DBNAME SIZE"); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) |
| || Tcl_GetIntFromObj(interp, objv[3], &nSize) |
| ){ |
| return TCL_ERROR; |
| } |
| zDb = Tcl_GetString(objv[2]); |
| if( zDb[0]=='\0' ) zDb = NULL; |
| |
| rc = sqlite3_file_control(db, zDb, SQLITE_FCNTL_CHUNK_SIZE, (void *)&nSize); |
| if( rc ){ |
| Tcl_SetResult(interp, (char *)sqlite3TestErrorName(rc), TCL_STATIC); |
| return TCL_ERROR; |
| } |
| return TCL_OK; |
| } |
| |
| /* |
| ** tclcmd: file_control_sizehint_test DB DBNAME SIZE |
| ** |
| ** This TCL command runs the sqlite3_file_control interface and |
| ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and |
| ** SQLITE_SET_LOCKPROXYFILE verbs. |
| */ |
| static int file_control_sizehint_test( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3_int64 nSize; /* Hinted size */ |
| char *zDb; /* Db name ("main", "temp" etc.) */ |
| sqlite3 *db; /* Database handle */ |
| int rc; /* file_control() return code */ |
| |
| if( objc!=4 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB DBNAME SIZE"); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) |
| || Tcl_GetWideIntFromObj(interp, objv[3], &nSize) |
| ){ |
| return TCL_ERROR; |
| } |
| zDb = Tcl_GetString(objv[2]); |
| if( zDb[0]=='\0' ) zDb = NULL; |
| |
| rc = sqlite3_file_control(db, zDb, SQLITE_FCNTL_SIZE_HINT, (void *)&nSize); |
| if( rc ){ |
| Tcl_SetResult(interp, (char *)sqlite3TestErrorName(rc), TCL_STATIC); |
| return TCL_ERROR; |
| } |
| return TCL_OK; |
| } |
| |
| /* |
| ** tclcmd: file_control_lockproxy_test DB PWD |
| ** |
| ** This TCL command runs the sqlite3_file_control interface and |
| ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and |
| ** SQLITE_SET_LOCKPROXYFILE verbs. |
| */ |
| static int file_control_lockproxy_test( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3 *db; |
| const char *zPwd; |
| int nPwd; |
| |
| if( objc!=3 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " DB PWD", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ){ |
| return TCL_ERROR; |
| } |
| zPwd = Tcl_GetStringFromObj(objv[2], &nPwd); |
| |
| #if !defined(SQLITE_ENABLE_LOCKING_STYLE) |
| # if defined(__APPLE__) |
| # define SQLITE_ENABLE_LOCKING_STYLE 1 |
| # else |
| # define SQLITE_ENABLE_LOCKING_STYLE 0 |
| # endif |
| #endif |
| #if SQLITE_ENABLE_LOCKING_STYLE && defined(__APPLE__) |
| { |
| char *testPath; |
| int rc; |
| char proxyPath[400]; |
| |
| if( sizeof(proxyPath)<nPwd+20 ){ |
| Tcl_AppendResult(interp, "PWD too big", (void*)0); |
| return TCL_ERROR; |
| } |
| sprintf(proxyPath, "%s/test.proxy", zPwd); |
| rc = sqlite3_file_control(db, NULL, SQLITE_SET_LOCKPROXYFILE, proxyPath); |
| if( rc ){ |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(rc)); |
| return TCL_ERROR; |
| } |
| rc = sqlite3_file_control(db, NULL, SQLITE_GET_LOCKPROXYFILE, &testPath); |
| if( strncmp(proxyPath,testPath,11) ){ |
| Tcl_AppendResult(interp, "Lock proxy file did not match the " |
| "previously assigned value", 0); |
| return TCL_ERROR; |
| } |
| if( rc ){ |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(rc)); |
| return TCL_ERROR; |
| } |
| rc = sqlite3_file_control(db, NULL, SQLITE_SET_LOCKPROXYFILE, proxyPath); |
| if( rc ){ |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(rc)); |
| return TCL_ERROR; |
| } |
| } |
| #endif |
| return TCL_OK; |
| } |
| |
| |
| /* |
| ** tclcmd: sqlite3_vfs_list |
| ** |
| ** Return a tcl list containing the names of all registered vfs's. |
| */ |
| static int vfs_list( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3_vfs *pVfs; |
| Tcl_Obj *pRet = Tcl_NewObj(); |
| if( objc!=1 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, ""); |
| return TCL_ERROR; |
| } |
| for(pVfs=sqlite3_vfs_find(0); pVfs; pVfs=pVfs->pNext){ |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewStringObj(pVfs->zName, -1)); |
| } |
| Tcl_SetObjResult(interp, pRet); |
| return TCL_OK; |
| } |
| |
| /* |
| ** tclcmd: sqlite3_limit DB ID VALUE |
| ** |
| ** This TCL command runs the sqlite3_limit interface and |
| ** verifies correct operation of the same. |
| */ |
| static int test_limit( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3 *db; |
| int rc; |
| static const struct { |
| char *zName; |
| int id; |
| } aId[] = { |
| { "SQLITE_LIMIT_LENGTH", SQLITE_LIMIT_LENGTH }, |
| { "SQLITE_LIMIT_SQL_LENGTH", SQLITE_LIMIT_SQL_LENGTH }, |
| { "SQLITE_LIMIT_COLUMN", SQLITE_LIMIT_COLUMN }, |
| { "SQLITE_LIMIT_EXPR_DEPTH", SQLITE_LIMIT_EXPR_DEPTH }, |
| { "SQLITE_LIMIT_COMPOUND_SELECT", SQLITE_LIMIT_COMPOUND_SELECT }, |
| { "SQLITE_LIMIT_VDBE_OP", SQLITE_LIMIT_VDBE_OP }, |
| { "SQLITE_LIMIT_FUNCTION_ARG", SQLITE_LIMIT_FUNCTION_ARG }, |
| { "SQLITE_LIMIT_ATTACHED", SQLITE_LIMIT_ATTACHED }, |
| { "SQLITE_LIMIT_LIKE_PATTERN_LENGTH", SQLITE_LIMIT_LIKE_PATTERN_LENGTH }, |
| { "SQLITE_LIMIT_VARIABLE_NUMBER", SQLITE_LIMIT_VARIABLE_NUMBER }, |
| { "SQLITE_LIMIT_TRIGGER_DEPTH", SQLITE_LIMIT_TRIGGER_DEPTH }, |
| |
| /* Out of range test cases */ |
| { "SQLITE_LIMIT_TOOSMALL", -1, }, |
| { "SQLITE_LIMIT_TOOBIG", SQLITE_LIMIT_TRIGGER_DEPTH+1 }, |
| }; |
| int i, id; |
| int val; |
| const char *zId; |
| |
| if( objc!=4 ){ |
| Tcl_AppendResult(interp, "wrong # args: should be \"", |
| Tcl_GetStringFromObj(objv[0], 0), " DB ID VALUE", 0); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| zId = Tcl_GetString(objv[2]); |
| for(i=0; i<sizeof(aId)/sizeof(aId[0]); i++){ |
| if( strcmp(zId, aId[i].zName)==0 ){ |
| id = aId[i].id; |
| break; |
| } |
| } |
| if( i>=sizeof(aId)/sizeof(aId[0]) ){ |
| Tcl_AppendResult(interp, "unknown limit type: ", zId, (char*)0); |
| return TCL_ERROR; |
| } |
| if( Tcl_GetIntFromObj(interp, objv[3], &val) ) return TCL_ERROR; |
| rc = sqlite3_limit(db, id, val); |
| Tcl_SetObjResult(interp, Tcl_NewIntObj(rc)); |
| return TCL_OK; |
| } |
| |
| /* |
| ** tclcmd: save_prng_state |
| ** |
| ** Save the state of the pseudo-random number generator. |
| ** At the same time, verify that sqlite3_test_control works even when |
| ** called with an out-of-range opcode. |
| */ |
| static int save_prng_state( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| int rc = sqlite3_test_control(9999); |
| assert( rc==0 ); |
| rc = sqlite3_test_control(-1); |
| assert( rc==0 ); |
| sqlite3_test_control(SQLITE_TESTCTRL_PRNG_SAVE); |
| return TCL_OK; |
| } |
| /* |
| ** tclcmd: restore_prng_state |
| */ |
| static int restore_prng_state( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3_test_control(SQLITE_TESTCTRL_PRNG_RESTORE); |
| return TCL_OK; |
| } |
| /* |
| ** tclcmd: reset_prng_state |
| */ |
| static int reset_prng_state( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3_test_control(SQLITE_TESTCTRL_PRNG_RESET); |
| return TCL_OK; |
| } |
| |
| /* |
| ** tclcmd: pcache_stats |
| */ |
| static int test_pcache_stats( |
| ClientData clientData, /* Pointer to sqlite3_enable_XXX function */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| int nMin; |
| int nMax; |
| int nCurrent; |
| int nRecyclable; |
| Tcl_Obj *pRet; |
| |
| sqlite3PcacheStats(&nCurrent, &nMax, &nMin, &nRecyclable); |
| |
| pRet = Tcl_NewObj(); |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewStringObj("current", -1)); |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewIntObj(nCurrent)); |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewStringObj("max", -1)); |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewIntObj(nMax)); |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewStringObj("min", -1)); |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewIntObj(nMin)); |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewStringObj("recyclable", -1)); |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewIntObj(nRecyclable)); |
| |
| Tcl_SetObjResult(interp, pRet); |
| |
| return TCL_OK; |
| } |
| |
| #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY |
| static void test_unlock_notify_cb(void **aArg, int nArg){ |
| int ii; |
| for(ii=0; ii<nArg; ii++){ |
| Tcl_EvalEx((Tcl_Interp *)aArg[ii], "unlock_notify", -1, TCL_EVAL_GLOBAL); |
| } |
| } |
| #endif /* SQLITE_ENABLE_UNLOCK_NOTIFY */ |
| |
| /* |
| ** tclcmd: sqlite3_unlock_notify db |
| */ |
| #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY |
| static int test_unlock_notify( |
| ClientData clientData, /* Unused */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| sqlite3 *db; |
| int rc; |
| |
| if( objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB"); |
| return TCL_ERROR; |
| } |
| |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ){ |
| return TCL_ERROR; |
| } |
| rc = sqlite3_unlock_notify(db, test_unlock_notify_cb, (void *)interp); |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); |
| return TCL_OK; |
| } |
| #endif |
| |
| /* |
| ** tclcmd: sqlite3_wal_checkpoint db ?NAME? |
| */ |
| static int test_wal_checkpoint( |
| ClientData clientData, /* Unused */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| char *zDb = 0; |
| sqlite3 *db; |
| int rc; |
| |
| if( objc!=3 && objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB ?NAME?"); |
| return TCL_ERROR; |
| } |
| |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ){ |
| return TCL_ERROR; |
| } |
| if( objc==3 ){ |
| zDb = Tcl_GetString(objv[2]); |
| } |
| rc = sqlite3_wal_checkpoint(db, zDb); |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), TCL_STATIC); |
| return TCL_OK; |
| } |
| |
| /* |
| ** tclcmd: sqlite3_wal_checkpoint_v2 db MODE ?NAME? |
| ** |
| ** This command calls the wal_checkpoint_v2() function with the specified |
| ** mode argument (passive, full or restart). If present, the database name |
| ** NAME is passed as the second argument to wal_checkpoint_v2(). If it the |
| ** NAME argument is not present, a NULL pointer is passed instead. |
| ** |
| ** If wal_checkpoint_v2() returns any value other than SQLITE_BUSY or |
| ** SQLITE_OK, then this command returns TCL_ERROR. The Tcl result is set |
| ** to the error message obtained from sqlite3_errmsg(). |
| ** |
| ** Otherwise, this command returns a list of three integers. The first integer |
| ** is 1 if SQLITE_BUSY was returned, or 0 otherwise. The following two integers |
| ** are the values returned via the output paramaters by wal_checkpoint_v2() - |
| ** the number of frames in the log and the number of frames in the log |
| ** that have been checkpointed. |
| */ |
| static int test_wal_checkpoint_v2( |
| ClientData clientData, /* Unused */ |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| char *zDb = 0; |
| sqlite3 *db; |
| int rc; |
| |
| int eMode; |
| int nLog = -555; |
| int nCkpt = -555; |
| Tcl_Obj *pRet; |
| |
| const char * aMode[] = { "passive", "full", "restart", 0 }; |
| assert( SQLITE_CHECKPOINT_PASSIVE==0 ); |
| assert( SQLITE_CHECKPOINT_FULL==1 ); |
| assert( SQLITE_CHECKPOINT_RESTART==2 ); |
| |
| if( objc!=3 && objc!=4 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB MODE ?NAME?"); |
| return TCL_ERROR; |
| } |
| |
| if( objc==4 ){ |
| zDb = Tcl_GetString(objv[3]); |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) |
| || Tcl_GetIndexFromObj(interp, objv[2], aMode, "mode", 0, &eMode) |
| ){ |
| return TCL_ERROR; |
| } |
| |
| rc = sqlite3_wal_checkpoint_v2(db, zDb, eMode, &nLog, &nCkpt); |
| if( rc!=SQLITE_OK && rc!=SQLITE_BUSY ){ |
| Tcl_SetResult(interp, (char *)sqlite3_errmsg(db), TCL_VOLATILE); |
| return TCL_ERROR; |
| } |
| |
| pRet = Tcl_NewObj(); |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewIntObj(rc==SQLITE_BUSY?1:0)); |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewIntObj(nLog)); |
| Tcl_ListObjAppendElement(interp, pRet, Tcl_NewIntObj(nCkpt)); |
| Tcl_SetObjResult(interp, pRet); |
| |
| return TCL_OK; |
| } |
| |
| /* |
| ** tclcmd: test_sqlite3_log ?SCRIPT? |
| */ |
| static struct LogCallback { |
| Tcl_Interp *pInterp; |
| Tcl_Obj *pObj; |
| } logcallback = {0, 0}; |
| static void xLogcallback(void *unused, int err, char *zMsg){ |
| Tcl_Obj *pNew = Tcl_DuplicateObj(logcallback.pObj); |
| Tcl_IncrRefCount(pNew); |
| Tcl_ListObjAppendElement( |
| 0, pNew, Tcl_NewStringObj(sqlite3TestErrorName(err), -1) |
| ); |
| Tcl_ListObjAppendElement(0, pNew, Tcl_NewStringObj(zMsg, -1)); |
| Tcl_EvalObjEx(logcallback.pInterp, pNew, TCL_EVAL_GLOBAL|TCL_EVAL_DIRECT); |
| Tcl_DecrRefCount(pNew); |
| } |
| static int test_sqlite3_log( |
| ClientData clientData, |
| Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| int objc, /* Number of arguments */ |
| Tcl_Obj *CONST objv[] /* Command arguments */ |
| ){ |
| if( objc>2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "SCRIPT"); |
| return TCL_ERROR; |
| } |
| if( logcallback.pObj ){ |
| Tcl_DecrRefCount(logcallback.pObj); |
| logcallback.pObj = 0; |
| logcallback.pInterp = 0; |
| sqlite3_config(SQLITE_CONFIG_LOG, 0, 0); |
| } |
| if( objc>1 ){ |
| logcallback.pObj = objv[1]; |
| Tcl_IncrRefCount(logcallback.pObj); |
| logcallback.pInterp = interp; |
| sqlite3_config(SQLITE_CONFIG_LOG, xLogcallback, 0); |
| } |
| return TCL_OK; |
| } |
| |
| /* |
| ** tcl_objproc COMMANDNAME ARGS... |
| ** |
| ** Run a TCL command using its objProc interface. Throw an error if |
| ** the command has no objProc interface. |
| */ |
| static int runAsObjProc( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| Tcl_CmdInfo cmdInfo; |
| if( objc<2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "COMMAND ..."); |
| return TCL_ERROR; |
| } |
| if( !Tcl_GetCommandInfo(interp, Tcl_GetString(objv[1]), &cmdInfo) ){ |
| Tcl_AppendResult(interp, "command not found: ", |
| Tcl_GetString(objv[1]), (char*)0); |
| return TCL_ERROR; |
| } |
| if( cmdInfo.objProc==0 ){ |
| Tcl_AppendResult(interp, "command has no objProc: ", |
| Tcl_GetString(objv[1]), (char*)0); |
| return TCL_ERROR; |
| } |
| return cmdInfo.objProc(cmdInfo.objClientData, interp, objc-1, objv+1); |
| } |
| |
| #ifndef SQLITE_OMIT_EXPLAIN |
| /* |
| ** WARNING: The following function, printExplainQueryPlan() is an exact |
| ** copy of example code from eqp.in (eqp.html). If this code is modified, |
| ** then the documentation copy needs to be modified as well. |
| */ |
| /* |
| ** Argument pStmt is a prepared SQL statement. This function compiles |
| ** an EXPLAIN QUERY PLAN command to report on the prepared statement, |
| ** and prints the report to stdout using printf(). |
| */ |
| int printExplainQueryPlan(sqlite3_stmt *pStmt){ |
| const char *zSql; /* Input SQL */ |
| char *zExplain; /* SQL with EXPLAIN QUERY PLAN prepended */ |
| sqlite3_stmt *pExplain; /* Compiled EXPLAIN QUERY PLAN command */ |
| int rc; /* Return code from sqlite3_prepare_v2() */ |
| |
| zSql = sqlite3_sql(pStmt); |
| if( zSql==0 ) return SQLITE_ERROR; |
| |
| zExplain = sqlite3_mprintf("EXPLAIN QUERY PLAN %s", zSql); |
| if( zExplain==0 ) return SQLITE_NOMEM; |
| |
| rc = sqlite3_prepare_v2(sqlite3_db_handle(pStmt), zExplain, -1, &pExplain, 0); |
| sqlite3_free(zExplain); |
| if( rc!=SQLITE_OK ) return rc; |
| |
| while( SQLITE_ROW==sqlite3_step(pExplain) ){ |
| int iSelectid = sqlite3_column_int(pExplain, 0); |
| int iOrder = sqlite3_column_int(pExplain, 1); |
| int iFrom = sqlite3_column_int(pExplain, 2); |
| const char *zDetail = (const char *)sqlite3_column_text(pExplain, 3); |
| |
| printf("%d %d %d %s\n", iSelectid, iOrder, iFrom, zDetail); |
| } |
| |
| return sqlite3_finalize(pExplain); |
| } |
| |
| static int test_print_eqp( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| int rc; |
| sqlite3_stmt *pStmt; |
| |
| if( objc!=2 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "STMT"); |
| return TCL_ERROR; |
| } |
| if( getStmtPointer(interp, Tcl_GetString(objv[1]), &pStmt) ) return TCL_ERROR; |
| rc = printExplainQueryPlan(pStmt); |
| Tcl_SetResult(interp, (char *)t1ErrorName(rc), 0); |
| return TCL_OK; |
| } |
| #endif /* SQLITE_OMIT_EXPLAIN */ |
| |
| /* |
| ** optimization_control DB OPT BOOLEAN |
| ** |
| ** Enable or disable query optimizations using the sqlite3_test_control() |
| ** interface. Disable if BOOLEAN is false and enable if BOOLEAN is true. |
| ** OPT is the name of the optimization to be disabled. |
| */ |
| static int optimization_control( |
| void * clientData, |
| Tcl_Interp *interp, |
| int objc, |
| Tcl_Obj *CONST objv[] |
| ){ |
| int i; |
| sqlite3 *db; |
| const char *zOpt; |
| int onoff; |
| int mask; |
| static const struct { |
| const char *zOptName; |
| int mask; |
| } aOpt[] = { |
| { "all", SQLITE_OptMask }, |
| { "query-flattener", SQLITE_QueryFlattener }, |
| { "column-cache", SQLITE_ColumnCache }, |
| { "index-sort", SQLITE_IndexSort }, |
| { "index-search", SQLITE_IndexSearch }, |
| { "index-cover", SQLITE_IndexCover }, |
| { "groupby-order", SQLITE_GroupByOrder }, |
| { "factor-constants", SQLITE_FactorOutConst }, |
| }; |
| |
| if( objc!=4 ){ |
| Tcl_WrongNumArgs(interp, 1, objv, "DB OPT BOOLEAN"); |
| return TCL_ERROR; |
| } |
| if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| if( Tcl_GetBooleanFromObj(interp, objv[3], &onoff) ) return TCL_ERROR; |
| zOpt = Tcl_GetString(objv[2]); |
| for(i=0; i<sizeof(aOpt)/sizeof(aOpt[0]); i++){ |
| if( strcmp(zOpt, aOpt[i].zOptName)==0 ){ |
| mask = aOpt[i].mask; |
| break; |
| } |
| } |
| if( onoff ) mask = ~mask; |
| if( i>=sizeof(aOpt)/sizeof(aOpt[0]) ){ |
| Tcl_AppendResult(interp, "unknown optimization - should be one of:", |
| (char*)0); |
| for(i=0; i<sizeof(aOpt)/sizeof(aOpt[0]); i++){ |
| Tcl_AppendResult(interp, " ", aOpt[i].zOptName); |
| } |
| return TCL_ERROR; |
| } |
| sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS, db, mask); |
| return TCL_OK; |
| } |
| |
| /* |
| ** Register commands with the TCL interpreter. |
| */ |
| int Sqlitetest1_Init(Tcl_Interp *interp){ |
| extern int sqlite3_search_count; |
| extern int sqlite3_found_count; |
| extern int sqlite3_interrupt_count; |
| extern int sqlite3_open_file_count; |
| extern int sqlite3_sort_count; |
| extern int sqlite3_current_time; |
| #if SQLITE_OS_UNIX && defined(__APPLE__) && SQLITE_ENABLE_LOCKING_STYLE |
| extern int sqlite3_hostid_num; |
| #endif |
| extern int sqlite3_max_blobsize; |
| extern int sqlite3BtreeSharedCacheReport(void*, |
| Tcl_Interp*,int,Tcl_Obj*CONST*); |
| static struct { |
| char *zName; |
| Tcl_CmdProc *xProc; |
| } aCmd[] = { |
| { "db_enter", (Tcl_CmdProc*)db_enter }, |
| { "db_leave", (Tcl_CmdProc*)db_leave }, |
| { "sqlite3_mprintf_int", (Tcl_CmdProc*)sqlite3_mprintf_int }, |
| { "sqlite3_mprintf_int64", (Tcl_CmdProc*)sqlite3_mprintf_int64 }, |
| { "sqlite3_mprintf_long", (Tcl_CmdProc*)sqlite3_mprintf_long }, |
| { "sqlite3_mprintf_str", (Tcl_CmdProc*)sqlite3_mprintf_str }, |
| { "sqlite3_snprintf_str", (Tcl_CmdProc*)sqlite3_snprintf_str }, |
| { "sqlite3_mprintf_stronly", (Tcl_CmdProc*)sqlite3_mprintf_stronly}, |
| { "sqlite3_mprintf_double", (Tcl_CmdProc*)sqlite3_mprintf_double }, |
| { "sqlite3_mprintf_scaled", (Tcl_CmdProc*)sqlite3_mprintf_scaled }, |
| { "sqlite3_mprintf_hexdouble", (Tcl_CmdProc*)sqlite3_mprintf_hexdouble}, |
| { "sqlite3_mprintf_z_test", (Tcl_CmdProc*)test_mprintf_z }, |
| { "sqlite3_mprintf_n_test", (Tcl_CmdProc*)test_mprintf_n }, |
| { "sqlite3_snprintf_int", (Tcl_CmdProc*)test_snprintf_int }, |
| { "sqlite3_last_insert_rowid", (Tcl_CmdProc*)test_last_rowid }, |
| { "sqlite3_exec_printf", (Tcl_CmdProc*)test_exec_printf }, |
| { "sqlite3_exec_hex", (Tcl_CmdProc*)test_exec_hex }, |
| { "sqlite3_exec", (Tcl_CmdProc*)test_exec }, |
| { "sqlite3_exec_nr", (Tcl_CmdProc*)test_exec_nr }, |
| #ifndef SQLITE_OMIT_GET_TABLE |
| { "sqlite3_get_table_printf", (Tcl_CmdProc*)test_get_table_printf }, |
| #endif |
| { "sqlite3_close", (Tcl_CmdProc*)sqlite_test_close }, |
| { "sqlite3_create_function", (Tcl_CmdProc*)test_create_function }, |
| { "sqlite3_create_aggregate", (Tcl_CmdProc*)test_create_aggregate }, |
| { "sqlite_register_test_function", (Tcl_CmdProc*)test_register_func }, |
| { "sqlite_abort", (Tcl_CmdProc*)sqlite_abort }, |
| { "sqlite_bind", (Tcl_CmdProc*)test_bind }, |
| { "breakpoint", (Tcl_CmdProc*)test_breakpoint }, |
| { "sqlite3_key", (Tcl_CmdProc*)test_key }, |
| { "sqlite3_rekey", (Tcl_CmdProc*)test_rekey }, |
| { "sqlite_set_magic", (Tcl_CmdProc*)sqlite_set_magic }, |
| { "sqlite3_interrupt", (Tcl_CmdProc*)test_interrupt }, |
| { "sqlite_delete_function", (Tcl_CmdProc*)delete_function }, |
| { "sqlite_delete_collation", (Tcl_CmdProc*)delete_collation }, |
| { "sqlite3_get_autocommit", (Tcl_CmdProc*)get_autocommit }, |
| { "sqlite3_stack_used", (Tcl_CmdProc*)test_stack_used }, |
| { "sqlite3_busy_timeout", (Tcl_CmdProc*)test_busy_timeout }, |
| { "printf", (Tcl_CmdProc*)test_printf }, |
| { "sqlite3IoTrace", (Tcl_CmdProc*)test_io_trace }, |
| }; |
| static struct { |
| char *zName; |
| Tcl_ObjCmdProc *xProc; |
| void *clientData; |
| } aObjCmd[] = { |
| { "sqlite3_connection_pointer", get_sqlite_pointer, 0 }, |
| { "sqlite3_bind_int", test_bind_int, 0 }, |
| { "sqlite3_bind_zeroblob", test_bind_zeroblob, 0 }, |
| { "sqlite3_bind_int64", test_bind_int64, 0 }, |
| { "sqlite3_bind_double", test_bind_double, 0 }, |
| { "sqlite3_bind_null", test_bind_null ,0 }, |
| { "sqlite3_bind_text", test_bind_text ,0 }, |
| { "sqlite3_bind_text16", test_bind_text16 ,0 }, |
| { "sqlite3_bind_blob", test_bind_blob ,0 }, |
| { "sqlite3_bind_parameter_count", test_bind_parameter_count, 0}, |
| { "sqlite3_bind_parameter_name", test_bind_parameter_name, 0}, |
| { "sqlite3_bind_parameter_index", test_bind_parameter_index, 0}, |
| { "sqlite3_clear_bindings", test_clear_bindings, 0}, |
| { "sqlite3_sleep", test_sleep, 0}, |
| { "sqlite3_errcode", test_errcode ,0 }, |
| { "sqlite3_extended_errcode", test_ex_errcode ,0 }, |
| { "sqlite3_errmsg", test_errmsg ,0 }, |
| { "sqlite3_errmsg16", test_errmsg16 ,0 }, |
| { "sqlite3_open", test_open ,0 }, |
| { "sqlite3_open16", test_open16 ,0 }, |
| { "sqlite3_complete16", test_complete16 ,0 }, |
| |
| { "sqlite3_prepare", test_prepare ,0 }, |
| { "sqlite3_prepare16", test_prepare16 ,0 }, |
| { "sqlite3_prepare_v2", test_prepare_v2 ,0 }, |
| { "sqlite3_prepare_tkt3134", test_prepare_tkt3134, 0}, |
| { "sqlite3_prepare16_v2", test_prepare16_v2 ,0 }, |
| { "sqlite3_finalize", test_finalize ,0 }, |
| { "sqlite3_stmt_status", test_stmt_status ,0 }, |
| { "sqlite3_reset", test_reset ,0 }, |
| { "sqlite3_expired", test_expired ,0 }, |
| { "sqlite3_transfer_bindings", test_transfer_bind ,0 }, |
| { "sqlite3_changes", test_changes ,0 }, |
| { "sqlite3_step", test_step ,0 }, |
| { "sqlite3_sql", test_sql ,0 }, |
| { "sqlite3_next_stmt", test_next_stmt ,0 }, |
| { "sqlite3_stmt_readonly", test_stmt_readonly ,0 }, |
| |
| { "sqlite3_release_memory", test_release_memory, 0}, |
| { "sqlite3_soft_heap_limit", test_soft_heap_limit, 0}, |
| { "sqlite3_thread_cleanup", test_thread_cleanup, 0}, |
| { "sqlite3_pager_refcounts", test_pager_refcounts, 0}, |
| |
| { "sqlite3_load_extension", test_load_extension, 0}, |
| { "sqlite3_enable_load_extension", test_enable_load, 0}, |
| { "sqlite3_extended_result_codes", test_extended_result_codes, 0}, |
| { "sqlite3_limit", test_limit, 0}, |
| |
| { "save_prng_state", save_prng_state, 0 }, |
| { "restore_prng_state", restore_prng_state, 0 }, |
| { "reset_prng_state", reset_prng_state, 0 }, |
| { "optimization_control", optimization_control,0}, |
| { "tcl_objproc", runAsObjProc, 0 }, |
| |
| /* sqlite3_column_*() API */ |
| { "sqlite3_column_count", test_column_count ,0 }, |
| { "sqlite3_data_count", test_data_count ,0 }, |
| { "sqlite3_column_type", test_column_type ,0 }, |
| { "sqlite3_column_blob", test_column_blob ,0 }, |
| { "sqlite3_column_double", test_column_double ,0 }, |
| { "sqlite3_column_int64", test_column_int64 ,0 }, |
| { "sqlite3_column_text", test_stmt_utf8, (void*)sqlite3_column_text }, |
| { "sqlite3_column_name", test_stmt_utf8, (void*)sqlite3_column_name }, |
| { "sqlite3_column_int", test_stmt_int, (void*)sqlite3_column_int }, |
| { "sqlite3_column_bytes", test_stmt_int, (void*)sqlite3_column_bytes}, |
| #ifndef SQLITE_OMIT_DECLTYPE |
| { "sqlite3_column_decltype",test_stmt_utf8,(void*)sqlite3_column_decltype}, |
| #endif |
| #ifdef SQLITE_ENABLE_COLUMN_METADATA |
| { "sqlite3_column_database_name",test_stmt_utf8,(void*)sqlite3_column_database_name}, |
| { "sqlite3_column_table_name",test_stmt_utf8,(void*)sqlite3_column_table_name}, |
| { "sqlite3_column_origin_name",test_stmt_utf8,(void*)sqlite3_column_origin_name}, |
| #endif |
| |
| #ifndef SQLITE_OMIT_UTF16 |
| { "sqlite3_column_bytes16", test_stmt_int, (void*)sqlite3_column_bytes16 }, |
| { "sqlite3_column_text16", test_stmt_utf16, (void*)sqlite3_column_text16}, |
| { "sqlite3_column_name16", test_stmt_utf16, (void*)sqlite3_column_name16}, |
| { "add_alignment_test_collations", add_alignment_test_collations, 0 }, |
| #ifndef SQLITE_OMIT_DECLTYPE |
| { "sqlite3_column_decltype16",test_stmt_utf16,(void*)sqlite3_column_decltype16}, |
| #endif |
| #ifdef SQLITE_ENABLE_COLUMN_METADATA |
| {"sqlite3_column_database_name16", |
| test_stmt_utf16, sqlite3_column_database_name16}, |
| {"sqlite3_column_table_name16", test_stmt_utf16, (void*)sqlite3_column_table_name16}, |
| {"sqlite3_column_origin_name16", test_stmt_utf16, (void*)sqlite3_column_origin_name16}, |
| #endif |
| #endif |
| { "sqlite3_create_collation_v2", test_create_collation_v2, 0 }, |
| { "sqlite3_global_recover", test_global_recover, 0 }, |
| { "working_64bit_int", working_64bit_int, 0 }, |
| { "vfs_unlink_test", vfs_unlink_test, 0 }, |
| { "vfs_initfail_test", vfs_initfail_test, 0 }, |
| { "vfs_unregister_all", vfs_unregister_all, 0 }, |
| { "vfs_reregister_all", vfs_reregister_all, 0 }, |
| { "file_control_test", file_control_test, 0 }, |
| { "file_control_lasterrno_test", file_control_lasterrno_test, 0 }, |
| { "file_control_lockproxy_test", file_control_lockproxy_test, 0 }, |
| { "file_control_chunksize_test", file_control_chunksize_test, 0 }, |
| { "file_control_sizehint_test", file_control_sizehint_test, 0 }, |
| { "sqlite3_vfs_list", vfs_list, 0 }, |
| { "sqlite3_create_function_v2", test_create_function_v2, 0 }, |
| |
| /* Functions from os.h */ |
| #ifndef SQLITE_OMIT_UTF16 |
| { "add_test_collate", test_collate, 0 }, |
| { "add_test_collate_needed", test_collate_needed, 0 }, |
| { "add_test_function", test_function, 0 }, |
| #endif |
| { "sqlite3_test_errstr", test_errstr, 0 }, |
| { "tcl_variable_type", tcl_variable_type, 0 }, |
| #ifndef SQLITE_OMIT_SHARED_CACHE |
| { "sqlite3_enable_shared_cache", test_enable_shared, 0 }, |
| { "sqlite3_shared_cache_report", sqlite3BtreeSharedCacheReport, 0}, |
| #endif |
| { "sqlite3_libversion_number", test_libversion_number, 0 }, |
| #ifdef SQLITE_ENABLE_COLUMN_METADATA |
| { "sqlite3_table_column_metadata", test_table_column_metadata, 0 }, |
| #endif |
| #ifndef SQLITE_OMIT_INCRBLOB |
| { "sqlite3_blob_read", test_blob_read, 0 }, |
| { "sqlite3_blob_write", test_blob_write, 0 }, |
| { "sqlite3_blob_reopen", test_blob_reopen, 0 }, |
| { "sqlite3_blob_bytes", test_blob_bytes, 0 }, |
| { "sqlite3_blob_close", test_blob_close, 0 }, |
| #endif |
| { "pcache_stats", test_pcache_stats, 0 }, |
| #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY |
| { "sqlite3_unlock_notify", test_unlock_notify, 0 }, |
| #endif |
| { "sqlite3_wal_checkpoint", test_wal_checkpoint, 0 }, |
| { "sqlite3_wal_checkpoint_v2",test_wal_checkpoint_v2, 0 }, |
| { "test_sqlite3_log", test_sqlite3_log, 0 }, |
| #ifndef SQLITE_OMIT_EXPLAIN |
| { "print_explain_query_plan", test_print_eqp, 0 }, |
| #endif |
| }; |
| static int bitmask_size = sizeof(Bitmask)*8; |
| int i; |
| extern int sqlite3_sync_count, sqlite3_fullsync_count; |
| extern int sqlite3_opentemp_count; |
| extern int sqlite3_like_count; |
| extern int sqlite3_xferopt_count; |
| extern int sqlite3_pager_readdb_count; |
| extern int sqlite3_pager_writedb_count; |
| extern int sqlite3_pager_writej_count; |
| #if SQLITE_OS_WIN |
| extern int sqlite3_os_type; |
| #endif |
| #ifdef SQLITE_DEBUG |
| extern int sqlite3WhereTrace; |
| extern int sqlite3OSTrace; |
| extern int sqlite3VdbeAddopTrace; |
| extern int sqlite3WalTrace; |
| #endif |
| #ifdef SQLITE_TEST |
| extern char sqlite3_query_plan[]; |
| static char *query_plan = sqlite3_query_plan; |
| #ifdef SQLITE_ENABLE_FTS3 |
| extern int sqlite3_fts3_enable_parentheses; |
| #endif |
| #endif |
| |
| for(i=0; i<sizeof(aCmd)/sizeof(aCmd[0]); i++){ |
| Tcl_CreateCommand(interp, aCmd[i].zName, aCmd[i].xProc, 0, 0); |
| } |
| for(i=0; i<sizeof(aObjCmd)/sizeof(aObjCmd[0]); i++){ |
| Tcl_CreateObjCommand(interp, aObjCmd[i].zName, |
| aObjCmd[i].xProc, aObjCmd[i].clientData, 0); |
| } |
| Tcl_LinkVar(interp, "sqlite_search_count", |
| (char*)&sqlite3_search_count, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite_found_count", |
| (char*)&sqlite3_found_count, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite_sort_count", |
| (char*)&sqlite3_sort_count, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite3_max_blobsize", |
| (char*)&sqlite3_max_blobsize, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite_like_count", |
| (char*)&sqlite3_like_count, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite_interrupt_count", |
| (char*)&sqlite3_interrupt_count, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite_open_file_count", |
| (char*)&sqlite3_open_file_count, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite_current_time", |
| (char*)&sqlite3_current_time, TCL_LINK_INT); |
| #if SQLITE_OS_UNIX && defined(__APPLE__) && SQLITE_ENABLE_LOCKING_STYLE |
| Tcl_LinkVar(interp, "sqlite_hostid_num", |
| (char*)&sqlite3_hostid_num, TCL_LINK_INT); |
| #endif |
| Tcl_LinkVar(interp, "sqlite3_xferopt_count", |
| (char*)&sqlite3_xferopt_count, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite3_pager_readdb_count", |
| (char*)&sqlite3_pager_readdb_count, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite3_pager_writedb_count", |
| (char*)&sqlite3_pager_writedb_count, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite3_pager_writej_count", |
| (char*)&sqlite3_pager_writej_count, TCL_LINK_INT); |
| #ifndef SQLITE_OMIT_UTF16 |
| Tcl_LinkVar(interp, "unaligned_string_counter", |
| (char*)&unaligned_string_counter, TCL_LINK_INT); |
| #endif |
| #ifndef SQLITE_OMIT_UTF16 |
| Tcl_LinkVar(interp, "sqlite_last_needed_collation", |
| (char*)&pzNeededCollation, TCL_LINK_STRING|TCL_LINK_READ_ONLY); |
| #endif |
| #if SQLITE_OS_WIN |
| Tcl_LinkVar(interp, "sqlite_os_type", |
| (char*)&sqlite3_os_type, TCL_LINK_INT); |
| #endif |
| #ifdef SQLITE_TEST |
| Tcl_LinkVar(interp, "sqlite_query_plan", |
| (char*)&query_plan, TCL_LINK_STRING|TCL_LINK_READ_ONLY); |
| #endif |
| #ifdef SQLITE_DEBUG |
| Tcl_LinkVar(interp, "sqlite_addop_trace", |
| (char*)&sqlite3VdbeAddopTrace, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite_where_trace", |
| (char*)&sqlite3WhereTrace, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite_os_trace", |
| (char*)&sqlite3OSTrace, TCL_LINK_INT); |
| #ifndef SQLITE_OMIT_WAL |
| Tcl_LinkVar(interp, "sqlite_wal_trace", |
| (char*)&sqlite3WalTrace, TCL_LINK_INT); |
| #endif |
| #endif |
| #ifndef SQLITE_OMIT_DISKIO |
| Tcl_LinkVar(interp, "sqlite_opentemp_count", |
| (char*)&sqlite3_opentemp_count, TCL_LINK_INT); |
| #endif |
| Tcl_LinkVar(interp, "sqlite_static_bind_value", |
| (char*)&sqlite_static_bind_value, TCL_LINK_STRING); |
| Tcl_LinkVar(interp, "sqlite_static_bind_nbyte", |
| (char*)&sqlite_static_bind_nbyte, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite_temp_directory", |
| (char*)&sqlite3_temp_directory, TCL_LINK_STRING); |
| Tcl_LinkVar(interp, "bitmask_size", |
| (char*)&bitmask_size, TCL_LINK_INT|TCL_LINK_READ_ONLY); |
| Tcl_LinkVar(interp, "sqlite_sync_count", |
| (char*)&sqlite3_sync_count, TCL_LINK_INT); |
| Tcl_LinkVar(interp, "sqlite_fullsync_count", |
| (char*)&sqlite3_fullsync_count, TCL_LINK_INT); |
| #if defined(SQLITE_ENABLE_FTS3) && defined(SQLITE_TEST) |
| Tcl_LinkVar(interp, "sqlite_fts3_enable_parentheses", |
| (char*)&sqlite3_fts3_enable_parentheses, TCL_LINK_INT); |
| #endif |
| return TCL_OK; |
| } |