third_party/sqlite/src/test1.c - Issue 3108030: Move bundled copy of sqlite one level deeper to better separate it...

Unified Diff: third_party/sqlite/src/test1.c

Issue 3108030: Move bundled copy of sqlite one level deeper to better separate it... (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src/

Patch Set: Created 10 years, 4 months ago

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Jump to:

View side-by-side diff with in-line comments

Download patch

Index: third_party/sqlite/src/test1.c

===================================================================

--- third_party/sqlite/src/test1.c (revision 56608)

+++ third_party/sqlite/src/test1.c (working copy)

@@ -1,5169 +0,0 @@

-/*

-** 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.

-**

-** $Id: test1.c,v 1.354 2009/08/10 04:37:50 danielk1977 Exp $

-*/

-#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]) ){

- 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, &notnull, &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

-/*

-** 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 */

-){

- Tcl_Channel channel;

- ClientData instanceData;

- sqlite3_blob *pBlob;

- int notUsed;

- int nByte;

- int iOffset;

- unsigned char *zBuf;

- int rc;

- if( objc!=4 ){

- Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL OFFSET N");

- return TCL_ERROR;

- }

- channel = Tcl_GetChannel(interp, Tcl_GetString(objv[1]), &notUsed);

- if( !channel

- || TCL_OK!=Tcl_GetIntFromObj(interp, objv[2], &iOffset)

- || TCL_OK!=Tcl_GetIntFromObj(interp, objv[3], &nByte)

- || nByte<0 || iOffset<0

- ){

- return TCL_ERROR;

- }

- instanceData = Tcl_GetChannelInstanceData(channel);

- pBlob = *((sqlite3_blob **)instanceData);

- 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 */

-){

- Tcl_Channel channel;

- ClientData instanceData;

- sqlite3_blob *pBlob;

- int notUsed;

- 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;

- }

- channel = Tcl_GetChannel(interp, Tcl_GetString(objv[1]), &notUsed);

- if( !channel || TCL_OK!=Tcl_GetIntFromObj(interp, objv[2], &iOffset) ){

- return TCL_ERROR;

- }

- instanceData = Tcl_GetChannelInstanceData(channel);

- pBlob = *((sqlite3_blob **)instanceData);

- 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);

-#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_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 */

-){

- 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 },

- };

- 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_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 = (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), (void *)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&(int)pKey1) ) unaligned_string_counter++;

- if( nKey2>0 && 1==(1&(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: 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);

- 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);

- 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_GLOBALRECOVER

-#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[]

-){

- static int softHeapLimit = 0;

- int amt;

- if( objc!=1 && objc!=2 ){

- Tcl_WrongNumArgs(interp, 1, objv, "?N?");

- return TCL_ERROR;

- }

- amt = softHeapLimit;

- if( objc==2 ){

- int N;

- if( Tcl_GetIntFromObj(interp, objv[1], &N) ) return TCL_ERROR;

- sqlite3_soft_heap_limit(N);

- softHeapLimit = N;

- }

- Tcl_SetObjResult(interp, Tcl_NewIntObj(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_ERROR );

- 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_ERROR );

- rc = sqlite3_file_control(db, "temp", -1, &iArg);

- assert( 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_lockproxy_test DB

-**

-** 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;

- 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;

- }

-#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 *proxyPath = "test.proxy";

- char *testPath;

- int rc;

- 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

-/*

-** Register commands with the TCL interpreter.

-*/

-int Sqlitetest1_Init(Tcl_Interp *interp){

- extern int sqlite3_search_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__)

- 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_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 },

- /* 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

- { "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 },

- { "sqlite3_vfs_list", vfs_list, 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 },

-#endif

- { "pcache_stats", test_pcache_stats, 0 },

-#ifdef SQLITE_ENABLE_UNLOCK_NOTIFY

- { "sqlite3_unlock_notify", test_unlock_notify, 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 defined(__linux__) && defined(SQLITE_TEST) && SQLITE_THREADSAFE

- extern int threadsOverrideEachOthersLocks;

-#endif

-#if SQLITE_OS_WIN

- extern int sqlite3_os_type;

-#endif

-#ifdef SQLITE_DEBUG

- extern int sqlite3WhereTrace;

- extern int sqlite3OSTrace;

- extern int sqlite3VdbeAddopTrace;

-#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

- 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_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__)

- 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

-#if defined(__linux__) && defined(SQLITE_TEST) && SQLITE_THREADSAFE

- Tcl_LinkVar(interp, "threadsOverrideEachOthersLocks",

- (char*)&threadsOverrideEachOthersLocks, 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);

-#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;

« no previous file with comments | « third_party/sqlite/src/tclsqlite.c ('k') | third_party/sqlite/src/test2.c » ('j') | no next file with comments »