/testfixture/src/test1_c.cs
C# | 6843 lines | 4352 code | 479 blank | 2012 comment | 946 complexity | bf9b03885ff23f6ac2f249711e2306e7 MD5 | raw file
- using System;
- using System.Diagnostics;
- using System.Text;
- using i64 = System.Int64;
- using u32 = System.UInt32;
- namespace Community.CsharpSqlite
- {
- #if TCLSH
- using tcl.lang;
- using ClientData = System.Object;
- using sqlite3_int64 = System.Int64;
- using sqlite3_stmt = Sqlite3.Vdbe;
- using sqlite3_u3264 = System.UInt64;
- using sqlite3_value = Sqlite3.Mem;
- using Tcl_Interp = tcl.lang.Interp;
- using Tcl_Obj = tcl.lang.TclObject;
- public partial class Sqlite3
- {
- /*
- ** 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.
- *************************************************************************
- ** Included in SQLite3 port to C#-SQLite; 2008 Noah B Hart
- ** C#-SQLite is an independent reimplementation of the SQLite software library
- **
- ** SQLITE_SOURCE_ID: 2011-06-23 19:49:22 4374b7e83ea0a3fbc3691f9c0c936272862f32f2
- **
- *************************************************************************
- */
- //#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=null;
- //};
- /*
- ** 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
- {
- Debug.Assert( h >= 'A' && h <= 'F' );
- return h - 'A' + 10;
- }
- }
- static object sqlite3TestTextToPtr( Tcl_Interp interp, string z )
- {
- //object p ;
- //var v = new u64[1];
- //u32 v2;
- //int zIndex = 0;
- //if ( z[0] == '0' && z[1] == 'x' )
- //{
- // zIndex += 2;
- //}
- //v[0] = 0;
- //while ( zIndex < z.Length )* z )
- //{
- // v[0] = ( v[0] << 4 ) + (ulong)testHexToInt( z[zIndex] );
- // zIndex++;
- //}
- //if ( sizeof( object ) == sizeof( u64 ) )
- //{
- // Marshal.Copy( v, 0, (IntPtr)p, 1 );// memcpy( &p, v, sizeof( p ) );
- //}
- //else
- //{
- // Debug.Assert( sizeof( p ) == sizeof( v2 ) );
- // v2 = (u32)v;
- // memcpy( &p, v2, sizeof( p ) );
- //}
- WrappedCommand cmdInfo = new WrappedCommand();
- if ( TCL.Tcl_GetCommandInfo( interp, z, out cmdInfo ) || cmdInfo == null )
- {
- return null;
- }
- else
- {
- return cmdInfo.objClientData;
- }
- }
- /*
- ** 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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- SqliteDb p;
- WrappedCommand cmdInfo = null;
- //string zBuf ;//[100];
- if ( objc != 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "SQLITE-CONNECTION" );
- return TCL.TCL_ERROR;
- }
- if ( TCL.Tcl_GetCommandInfo( interp, objv[1].ToString(), out cmdInfo ) )
- {
- TCL.Tcl_AppendResult( interp, "command not found: ",
- TCL.Tcl_GetString( objv[1] ), null );
- return TCL.TCL_ERROR;
- }
- //p = (SqliteDb)cmdInfo.objclientdata;
- //zBuf = p.db.GetHashCode().ToString();
- //sqlite3_snprintf( zBuf, "%p", p.db );
- //if( strncmp(zBuf,"0x",2) ){
- // sqlite3_snprintf(zBuf, "0x%p", p.db);
- //}
- //TCL.Tcl_AppendResult(interp, zBuf,null );
- TCL.Tcl_AppendResult( interp, objv[1].ToString() );
- return TCL.TCL_OK;
- }
- /*
- ** Decode a pointer to an sqlite3 object.
- */
- static int getDbPointer( Tcl_Interp interp, string zA, out sqlite3 ppDb )
- {
- SqliteDb p;
- WrappedCommand cmdInfo = new WrappedCommand();
- if ( !TCL.Tcl_GetCommandInfo( interp, zA, out cmdInfo ) )
- {
- if ( cmdInfo == null )
- {
- ppDb = new sqlite3();
- }
- else
- {
- p = (SqliteDb)cmdInfo.objClientData;
- ppDb = p.db;
- }
- }
- else
- {
- ppDb = null;
- }
- return TCL.TCL_OK;
- }
- static string sqlite3TestErrorName( int rc )
- {
- string zName = "";
- 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;
- case SQLITE_CORRUPT_VTAB:
- zName = "SQLITE_CORRUPT_VTAB";
- break;
- case SQLITE_READONLY_RECOVERY:
- zName = "SQLITE_READONLY_RECOVERY";
- break;
- case SQLITE_READONLY_CANTLOCK:
- zName = "SQLITE_READONLY_CANTLOCK";
- break;
- default:
- zName = "SQLITE_Unknown";
- break;
- }
- return zName;
- }
- //#define t1ErrorName sqlite3TestErrorName
- static string t1ErrorName( int i )
- {
- return sqlite3TestErrorName( i );
- }
- /*
- ** 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)
- static sqlite3 StmtToDb( Vdbe v )
- {
- return sqlite3_db_handle( v );
- }
- /*
- ** Check a return value to make sure it agrees with the results
- ** from sqlite3_errcode.
- */
- static int sqlite3TestErrCode( Tcl_Interp interp, sqlite3 db, int rc )
- {
- if ( sqlite3_threadsafe() == 0 && rc != SQLITE_MISUSE && rc != SQLITE_OK
- && sqlite3_errcode( db ) != rc )
- {
- StringBuilder zBuf = new StringBuilder( 200 );//char zBuf[200];
- int r2 = sqlite3_errcode( db );
- sqlite3_snprintf( 200, zBuf, "error code %s (%d) does not match sqlite3_errcode %s (%d)",
- sqlite3TestErrorName( rc ), rc, sqlite3TestErrorName( r2 ), r2 );//t1ErrorName( rc ), rc, t1ErrorName( r2 ), r2 );
- TCL.Tcl_ResetResult( interp );
- TCL.Tcl_AppendResult( interp, zBuf.ToString() );
- return 1;
- }
- return 0;
- }
- /*
- ** Decode a pointer to an sqlite3_stmt object.
- */
- static int getStmtPointer(
- Tcl_Interp interp,
- string zArg,
- out sqlite3_stmt ppStmt
- )
- {
- ppStmt = (sqlite3_stmt)sqlite3TestTextToPtr( interp, zArg );
- WrappedCommand cmdInfo = new WrappedCommand();
- TCL.Tcl_GetCommandInfo( interp, zArg, out cmdInfo );
- ppStmt = cmdInfo == null ? null : (sqlite3_stmt)cmdInfo.objClientData;
- return TCL.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.
- */
- /*
- ** Decode a pointer to an sqlite3_stmt object.
- */
- static int sqlite3TestMakePointerStr( Tcl_Interp interp, StringBuilder zPtr, object p )
- {
- sqlite3_snprintf( 100, zPtr, "->%p", p );
- if ( TCL.Tcl_CreateCommandPointer( interp, zPtr, p ) )
- {
- return TCL.TCL_ERROR;
- }
- return TCL.TCL_OK;
- }
- /*
- ** The callback routine for sqlite3_exec_printf().
- */
- static int exec_printf_cb( object pArg, sqlite3_int64 argc, object p2, object p3 )
- {
- string[] name = (string[])p3;
- string[] argv = (string[])p2;
- TclObject str = (TclObject)pArg;
- int i;
- if ( TCL.Tcl_DStringLength( str ) == 0 )
- {
- for ( i = 0; i < argc; i++ )
- {
- TCL.Tcl_DStringAppendElement( str, name[i] != null ? name[i] + " " : "NULL " );
- }
- }
- string beginbrace = "", endbrace = "";
- for ( i = 0; i < argc; i++ )
- {
- if ( argc > 1 )
- {
- if ( Util.scanElement( null, argv[i].ToString() ) != 0 )
- {
- beginbrace = "{";
- endbrace = "}";
- }
- else
- {
- beginbrace = "";
- endbrace = "";
- }
- }
- TCL.Tcl_DStringAppendElement( str, argv[i] != null ? beginbrace + argv[i] + endbrace + ( i < argc - 1 ? " " : "" ) : "NULL" );
- }
- return 0;
- }
- /*
- ** The I/O tracing callback.
- */
- #if !(SQLITE_OMIT_TRACE) && TRACE
- //static FILE *iotrace_file = 0;
- //static void io_trace_callback(string 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(
- // object NotUsed,
- // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- // int argc, /* Number of arguments */
- // Tcl_Obj[] argv /* Text of each argument */
- //){
- #if !(SQLITE_OMIT_TRACE) && (TRACE)
- // if( argc!=2 ){
- // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
- // " FILENAME\"", 0);
- // return TCL.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.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3 db = null;
- TclObject str = null;
- int rc;
- string zErr = "";
- string zSql = "";
- StringBuilder zBuf = new StringBuilder( 30 );
- if ( argc != 4 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB FORMAT STRING" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_DStringInit( out str );
- zSql = sqlite3_mprintf( argv[2].ToString(), argv[3].ToString() );
- rc = sqlite3_exec( db, zSql, (dxCallback)exec_printf_cb, str, ref zErr );
- sqlite3DbFree( db, ref zSql );
- sqlite3_snprintf( 30, zBuf, "%d", rc );
- TCL.Tcl_AppendElement( interp, zBuf );
- TCL.Tcl_AppendElement( interp, rc == SQLITE_OK ? str.ToString() : zErr ); //TCL.Tcl_DStringValue(ref str)
- TCL.Tcl_DStringFree( ref str );
- if ( zErr != null )
- sqlite3DbFree( db, ref zErr );
- if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
- return TCL.TCL_ERROR;
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3 db = null;
- TclObject str = null;
- int rc, i, j;
- string zErr = "";
- string zHex;
- StringBuilder zSql = new StringBuilder( 500 );
- string zBuf = "";
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB HEX" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- zHex = argv[2].ToString();
- for ( i = j = 0; j < zHex.Length && zHex[j] != 0; i++, j++ )
- {
- if ( zHex[j] == '%' && zHex[j + 2] != 0 && zHex[j + 2] != 0 )
- {
- zSql.Append( (char)( ( testHexToInt( zHex[j + 1] ) << 4 ) + testHexToInt( zHex[j + 2] ) ) );
- j += 2;
- }
- else
- {
- zSql.Append( zHex[j] );
- }
- }
- //zSql[i] = '\0';
- TCL.Tcl_DStringInit( out str );
- rc = sqlite3_exec( db, zSql.ToString(), (dxCallback)exec_printf_cb, str, ref zErr );
- zBuf = rc.ToString();// sprintf( zBuf, "%d", rc );
- TCL.Tcl_AppendElement( interp, zBuf );
- TCL.Tcl_AppendElement( interp, rc == SQLITE_OK ? str.ToString() : zErr );
- TCL.Tcl_DStringFree( ref str );
- // //sqlite3_free(ref zErr);
- if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
- return TCL.TCL_ERROR;
- return TCL.TCL_OK;
- }
- /*
- ** Usage: db_enter DB
- ** db_leave DB
- **
- ** Enter or leave the mutex on a database connection.
- */
- static int db_enter(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3 db = null;
- if ( argc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- sqlite3_mutex_enter( db.mutex );
- return TCL.TCL_OK;
- }
- static int db_leave(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3 db = null;
- if ( argc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- sqlite3_mutex_leave( db.mutex );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_exec DB SQL
- **
- ** Invoke the sqlite3_exec interface using the open database DB
- */
- static int test_exec(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3 db = null;
- TclObject str = TclString.newInstance( "" );
- int rc;
- string zErr = "";
- string zSql;
- int i, j;
- StringBuilder zBuf = new StringBuilder( 30 );
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB SQL" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_DStringInit( out str );
- zSql = sqlite3_mprintf( "%s", argv[2].ToString() );
- StringBuilder sb = new StringBuilder( zSql.Length );
- for ( i = 0; i < zSql.Length; i++ )
- {
- if ( zSql[i] == '%' )
- {
- sb.Append( (char)( ( testHexToInt( zSql[i + 1] ) << 4 ) + testHexToInt( zSql[i + 2] ) ) );
- i += 2;
- }
- else
- sb.Append( zSql[i] );
- }
- ////zSql[j] = 0;
- rc = sqlite3_exec( db, sb.ToString(), exec_printf_cb, str, ref zErr );
- sqlite3DbFree( db, ref zSql );
- sqlite3_snprintf( 30, zBuf, "%d", rc );
- TCL.Tcl_AppendElement( interp, zBuf );
- TCL.Tcl_AppendElement( interp, rc == SQLITE_OK ? str.ToString() : zErr );
- //TCL.Tcl_DStringFree(&str);
- if ( zErr != "" )
- sqlite3DbFree( db, ref zErr );
- if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
- return TCL.TCL_ERROR;
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3 db = null;
- int rc;
- string zErr = "";
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB SQL" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_exec( db, argv[2].ToString(), null, null, ref zErr );
- if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
- return TCL.TCL_ERROR;
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- string zResult = "";
- int i;
- for ( i = 2; i < argc && ( i == 2 || zResult != "" ); i++ )
- {
- zResult = sqlite3_mprintf( "%z%s%s", zResult, argv[1].ToString(), argv[i].ToString() );
- }
- TCL.Tcl_AppendResult( interp, zResult );
- //sqlite3DbFree( db, zResult );
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- string zStr;
- int n = 0;
- zStr = sqlite3_mprintf( "%s%n", argv[1].ToString() );
- n = zStr.Length;
- //sqlite3DbFree( db, zStr );
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( n ) );
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- StringBuilder zStr = new StringBuilder( 100 );
- int n = atoi( argv[1].ToString() );
- string zFormat = argv[2].ToString();
- int a1 = atoi( argv[3].ToString() );
- if ( n > zStr.Capacity )
- n = zStr.Capacity;// sizeof( zStr );
- zStr = new StringBuilder( "abcdefghijklmnopqrstuvwxyz" );
- sqlite3_snprintf( n, zStr, zFormat, a1 );
- TCL.Tcl_AppendResult( interp, zStr );
- return TCL.TCL_OK;
- }
- #if !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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- ){
- sqlite3 db=null;
- TCL.Tcl_DString str;
- int rc;
- string zErr = 0;
- int nRow, nCol;
- char **aResult;
- int i;
- char zBuf[30];
- string zSql;
- int resCount = -1;
- if( argc==5 ){
- if( TCL.Tcl_GetInt(interp, argv[4], out resCount) ) return TCL.TCL_ERROR;
- }
- if( argc!=4 && argc!=5 ){
- TCL.Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
- " DB FORMAT STRING ?COUNT?", 0);
- return TCL.TCL_ERROR;
- }
- if( getDbPointer(interp, argv[1].ToString(), out db) !=0) return TCL.TCL_ERROR;
- TCL.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;
- }
- sqlite3DbFree(db,zSql);
- sqlite3_snprintf(zBuf, "%d", rc);
- TCL.Tcl_AppendElement(interp, zBuf);
- if( rc==SQLITE_OK ){
- if( argc==4 ){
- sqlite3_snprintf(zBuf, "%d", nRow);
- TCL.Tcl_AppendElement(interp, zBuf);
- sqlite3_snprintf(zBuf, "%d", nCol);
- TCL.Tcl_AppendElement(interp, zBuf);
- }
- for(i=0; i<resCount; i++){
- TCL.Tcl_AppendElement(interp, aResult[i] ? aResult[i] : "NULL");
- }
- }else{
- TCL.Tcl_AppendElement(interp, zErr);
- }
- //sqlite3_free_table(aResult);
- if( zErr ) sqlite3DbFree(db,zErr);
- if( sqlite3TestErrCode(interp, db, rc) ) return TCL.TCL_ERROR;
- return TCL.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(
- // object NotUsed,
- // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- // int argc, /* Number of arguments */
- // Tcl_Obj[] argv /* Text of each argument */
- //){
- // sqlite3 db=null;
- // char zBuf[30];
- // if( argc!=2 ){
- // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], " DB\"");
- // return TCL.TCL_ERROR;
- // }
- // if( getDbPointer(interp, argv[1].ToString(), out db) !=0) return TCL.TCL_ERROR;
- // sqlite3_snprintf(zBuf, "%lld", sqlite3_last_insert_rowid(db));
- // TCL.Tcl_AppendResult(interp, zBuf);
- // return SQLITE_OK;
- //}
- /*
- ** Usage: sqlite3_key DB KEY
- **
- ** Set the codec key.
- */
- static int test_key(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3 db = null;
- string zKey;
- int nKey;
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " FILENAME\"" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- zKey = argv[2].ToString();
- nKey = zKey.Length;
- #if SQLITE_HAS_CODEC
- sqlite3_key( db, zKey, nKey );
- #endif
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_rekey DB KEY
- **
- ** Change the codec key.
- */
- static int test_rekey(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3 db = null;
- string zKey;
- int nKey;
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " FILENAME\"" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- zKey = argv[2].ToString();
- nKey = zKey.Length;
- #if SQLITE_HAS_CODEC
- sqlite3_rekey( db, zKey, nKey );
- #endif
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_close DB
- **
- ** Closes the database opened by sqlite3_open.
- */
- static int sqlite_test_close(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3 db = null;
- int rc;
- if ( argc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " FILENAME\"" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_close( db );
- TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
- return TCL.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, 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 )
- {
- string z;
- int i;
- StringBuilder zBuf = new StringBuilder( 200 );
- z = sqlite3_value_text( argv[0] );
- StringBuilder zTemp = new StringBuilder( 200 );
- for ( i = 0; i < zBuf.Capacity / 2 - 2 && i < argv[0].n; i++ )
- {
- sqlite3_snprintf( 4, zTemp, "%02x", z[i] & 0xff );
- zBuf.Append( zTemp );
- }
- //zBuf[i*2] = 0;
- sqlite3_result_text( p, zBuf, -1, SQLITE_TRANSIENT );
- }
- #if !SQLITE_OMIT_UTF16
- static void hex16Func(sqlite3_context p, int argc, sqlite3_value[] argv){
- Debugger.Break (); //TODO --
- // 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++){
- // sqlite3_snprintf(&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
- {
- public int nAlloc; /* Space allocated */
- public int nUsed; /* Space used */
- public StringBuilder z; /* The space */
- };
- /*
- ** Append text to a dstr
- */
- static void dstrAppend( dstr p, string z, int divider )
- {
- int n = z.Length;// strlen( z );
- // if( p.nUsed + n + 2 > p.nAlloc ){
- // string zNew;
- p.nAlloc = p.nAlloc * 2 + n + 200;
- p.z.Capacity = p.nAlloc;
- // zNew = sqlite3_realloc(p.z, p.nAlloc);
- // if( zNew==0 ){
- // sqlite3DbFree(db,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;
- p.z.Append( divider + z );
- }
- /*
- ** Invoked for each callback from sqlite3ExecFunc
- */
- static int execFuncCallback( object pData, sqlite3_int64 argc, object _argv, object NotUsed )
- {
- Tcl_Obj[] argv = (Tcl_Obj[])_argv;
- dstr p = (dstr)pData;
- int i;
- for ( i = 0; i < argc; i++ )
- {
- if ( argv[i] == null )
- {
- dstrAppend( p, "NULL", ' ' );
- }
- else
- {
- dstrAppend( p, argv[i].ToString(), ' ' );
- }
- }
- 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
- )
- {
- dstr x = new dstr();
- //memset(&x, 0, sizeof(x));
- string sDummy = "";
- sqlite3_exec( (sqlite3)sqlite3_context_db_handle( context ),
- sqlite3_value_text( argv[0] ),
- (dxCallback)execFuncCallback, (object)x, ref sDummy );
- sqlite3_result_text( context, x.z, x.nUsed, SQLITE_TRANSIENT );
- x.z = null;// sqlite3DbFree( db, ref 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;
- string zText1;
- string zText2;
- string 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
- {
- //string zCopy = (char )sqlite3Malloc(nText);
- //memcpy(zCopy, zText1, nText);
- sqlite3_result_text( context, zText1, nText, null ); //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
- )
- {
- sqlite3_result_int( context, 0 );
- return;
- //Debugger.Break(); //TODO --
- //string p1 = "", p2 = "";
- //string zCmd;
- //if ( argc != 4 )
- // return;
- //zCmd = sqlite3_value_text( argv[1] );
- //if ( zCmd == null )
- // return;
- // if( strcmp(zCmd,"text")==0 ){
- // p1 = (const void)sqlite3_value_text(argv[0]);
- //#if !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]);
- //#if !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]);
- //#if !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 ? 1 : 0 );
- }
- /*
- ** 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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- int rc;
- sqlite3 db = null;
- if ( argc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB\"" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_create_function( db, "x_coalesce", -1, SQLITE_ANY, 0,
- t1_ifnullFunc, null, null );
- if ( rc == SQLITE_OK )
- {
- rc = sqlite3_create_function( db, "hex8", 1, SQLITE_ANY, 0,
- hex8Func, null, null );
- }
- #if !SQLITE_OMIT_UTF16
- if( rc==SQLITE_OK ){
- rc = sqlite3_create_function(db, "hex16", 1, SQLITE_ANY, null, hex16Func, null,null);
- }
- #endif
- if ( rc == SQLITE_OK )
- {
- rc = sqlite3_create_function( db, "tkt2213func", 1, SQLITE_ANY, 0,
- tkt2213Function, null, null );
- }
- if ( rc == SQLITE_OK )
- {
- rc = sqlite3_create_function( db, "pointer_change", 4, SQLITE_ANY, 0,
- ptrChngFunction, null, null );
- }
- #if !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 ){
- string 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 !=0{
- rc = SQLITE_NOMEM;
- }else{
- rc = sqlite3_create_function16(db, zUtf16, 1, SQLITE_UTF16, db, sqlite3ExecFunc,null,null );
- }
- sqlite3ValueFree(ref pVal);
- sqlite3_mutex_leave(db.mutex);
- }
- #endif
- if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_SetResult( interp, sqlite3TestErrorName( rc ), 0 );
- return TCL.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;
- static void t1CountStep(
- sqlite3_context context,
- int argc,
- sqlite3_value[] argv
- )
- {
- SumCtx p;
- Mem pMem = sqlite3_aggregate_context( context, 1 );//sizeof(*p));
- if ( pMem._SumCtx == null )
- pMem._SumCtx = new SumCtx();
- p = pMem._SumCtx;
- if ( p.Context == null )
- p.Context = pMem;
- if ( ( argc == 0 || SQLITE_NULL != sqlite3_value_type( argv[0] ) ) && p != null )
- {
- p.cnt++;
- }
- 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 );
- #if !SQLITE_OMIT_UTF16
- }else if( v==41 ){
- Debugger.Break (); // TODO --
- //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 )
- {
- SumCtx p;
- Mem pMem = sqlite3_aggregate_context( context, 0 );//sizeof(*p));
- p = pMem._SumCtx;
- if ( p != null )
- {
- if ( p.cnt == 42 )
- {
- sqlite3_result_error( context, "x_count totals to 42", -1 );
- }
- else
- {
- sqlite3_result_int( context, p != null ? (int)p.cnt : 0 );
- }
- }
- }
- #if !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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3 db = new sqlite3();
- int rc;
- if ( argc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0].ToString(),
- " FILENAME\"" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_create_function( db, "x_count", 0, SQLITE_UTF8, 0, null,
- t1CountStep, t1CountFinalize );
- if ( rc == SQLITE_OK )
- {
- rc = sqlite3_create_function( db, "x_count", 1, SQLITE_UTF8, 0, null,
- t1CountStep, t1CountFinalize );
- }
- #if !SQLITE_OMIT_DEPRECATED
- if ( rc == SQLITE_OK )
- {
- rc = sqlite3_create_function( db, "legacy_count", 0, SQLITE_ANY, 0, null,
- legacyCountStep, legacyCountFinalize
- );
- }
- #endif
- if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_SetResult( interp, t1ErrorName( rc ), 0 );
- return TCL.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(
- // object NotUsed,
- // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- // int argc, /* Number of arguments */
- // Tcl_Obj[] argv /* Text of each argument */
- //){
- // if( argc!=2 ){
- // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
- // " TEXT\"");
- // return TCL.TCL_ERROR;
- // }
- // printf("%s\n", argv[1]);
- // return TCL.TCL_OK;
- //}
- /*
- ** Usage: sqlite3_mprintf_int FORMAT INTEGER INTEGER INTEGER
- **
- ** Call mprintf with three integer arguments
- */
- static int sqlite3_mprintf_int(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- long[] a = new long[3];
- int i;
- string z;
- if ( argc != 5 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " FORMAT INT INT INT\"" );
- return TCL.TCL_ERROR;
- }
- for ( i = 2; i < 5; i++ )
- {
- if ( TCL.Tcl_GetLong( interp, argv[i], out a[i - 2] ) )
- return TCL.TCL_ERROR;
- }
- z = sqlite3_mprintf( argv[1].ToString(), a[0], a[1], a[2] );
- TCL.Tcl_AppendResult( interp, z );
- //sqlite3DbFree(db,z);
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_mprintf_int64 FORMAT INTEGER INTEGER INTEGER
- **
- ** Call mprintf with three 64-bit integer arguments
- */
- static int sqlite3_mprintf_int64(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- int i;
- sqlite3_int64[] a = new sqlite3_int64[3];
- string z;
- if ( argc != 5 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " FORMAT INT INT INT\"" );
- return TCL.TCL_ERROR;
- }
- for ( i = 2; i < 5; i++ )
- {
- if ( sqlite3Atoi64( argv[i].ToString(), ref a[i - 2], argv[i].ToString().Length, SQLITE_UTF8 ) != 0 )
- {
- TCL.Tcl_AppendResult( interp, "argument is not a valid 64-bit integer" );
- return TCL.TCL_ERROR;
- }
- }
- z = sqlite3_mprintf( argv[1].ToString(), a[0], a[1], a[2] );
- TCL.Tcl_AppendResult( interp, z );
- //sqlite3DbFree(db,z);
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- int i;
- long[] a = new long[3];
- long[] b = new long[3];
- string z;
- if ( argc != 5 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " FORMAT INT INT INT\"" );
- return TCL.TCL_ERROR;
- }
- for ( i = 2; i < 5; i++ )
- {
- if ( TCL.Tcl_GetLong( interp, argv[i], out b[i - 2] ) )
- return TCL.TCL_ERROR;
- a[i - 2] = b[i - 2];
- //a[i-2] &= (((u64)1)<<(sizeof(int)*8))-1;
- }
- z = sqlite3_mprintf( argv[1].ToString(), a[0], a[1], a[2] );
- TCL.Tcl_AppendResult( interp, z );
- ////sqlite3_free(z);
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- long[] a = new long[3];
- int i;
- string z;
- if ( argc < 4 || argc > 5 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " FORMAT INT INT ?STRING?\"" );
- return TCL.TCL_ERROR;
- }
- for ( i = 2; i < 4; i++ )
- {
- if ( TCL.Tcl_GetLong( interp, argv[i], out a[i - 2] ) )
- return TCL.TCL_ERROR;
- }
- z = sqlite3_mprintf( argv[1].ToString(), a[0], a[1], argc > 4 ? argv[4].ToString() : null );
- TCL.Tcl_AppendResult( interp, z );
- //sqlite3DbFree(db,z);
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- long[] a = new long[3];
- int i;
- int n = 0;
- StringBuilder z;
- if ( argc < 5 || argc > 6 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " INT FORMAT INT INT ?STRING?\"" );
- return TCL.TCL_ERROR;
- }
- if ( TCL.Tcl_GetInt( interp, argv[1], out n ) )
- return TCL.TCL_ERROR;
- if ( n < 0 )
- {
- TCL.Tcl_AppendResult( interp, "N must be non-negative" );
- return TCL.TCL_ERROR;
- }
- for ( i = 3; i < 5; i++ )
- {
- if ( TCL.Tcl_GetLong( interp, argv[i], out a[i - 3] ) )
- return TCL.TCL_ERROR;
- }
- z = new StringBuilder( n + 1 );//sqlite3Malloc( n+1 );
- sqlite3_snprintf( n, z, argv[2].ToString(), a[0], a[1], argc > 4 ? argv[5].ToString() : null );
- TCL.Tcl_AppendResult( interp, z );
- //sqlite3DbFree(db,z);
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- long[] a = new long[3];
- int i;
- double r = 0;
- string z;
- if ( argc != 5 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " FORMAT INT INT DOUBLE\"" );
- return TCL.TCL_ERROR;
- }
- for ( i = 2; i < 4; i++ )
- {
- if ( TCL.Tcl_GetLong( interp, argv[i], out a[i - 2] ) )
- return TCL.TCL_ERROR;
- }
- if ( TCL.Tcl_GetDouble( interp, argv[4], out r ) )
- return TCL.TCL_ERROR;
- z = sqlite3_mprintf( argv[1].ToString(), a[0], a[1], r );
- TCL.Tcl_AppendResult( interp, z );
- //sqlite3DbFree(db,z);
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- int i;
- double[] r = new double[2];
- string z;
- if ( argc != 4 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " FORMAT DOUBLE DOUBLE\"" );
- return TCL.TCL_ERROR;
- }
- for ( i = 2; i < 4; i++ )
- {
- if ( TCL.Tcl_GetDouble( interp, argv[i], out r[i - 2] ) )
- return TCL.TCL_ERROR;
- }
- z = sqlite3_mprintf( argv[1].ToString(), r[0] * r[1] );
- TCL.Tcl_AppendResult( interp, z );
- //sqlite3DbFree(db,z);
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- string z;
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " FORMAT STRING\"" );
- return TCL.TCL_ERROR;
- }
- z = sqlite3_mprintf( argv[1].ToString(), argv[2].ToString() );
- TCL.Tcl_AppendResult( interp, z );
- //sqlite3DbFree( db, z );
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- string z;
- double r;
- u32 x1, x2;
- i64 d = 0;
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " FORMAT STRING\"" );
- return TCL.TCL_ERROR;
- }
- //if( sscanf(argv[2].ToString(), "%08x%08x", ref x2, ref x1)!=2 ){
- if ( argv[2].ToString().Length != 16
- || !u32.TryParse( argv[2].ToString().Substring( 0, 8 ), System.Globalization.NumberStyles.HexNumber, null, out x2 )
- || !u32.TryParse( argv[2].ToString().Substring( 8, 8 ), System.Globalization.NumberStyles.HexNumber, null, out x1 )
- )
- {
- TCL.Tcl_AppendResult( interp, "2nd argument should be 16-characters of hex" );
- return TCL.TCL_ERROR;
- }
- d = x2;
- d = ( d << 32 ) + x1;
- #if WINDOWS_PHONE
- r = BitConverter.ToDouble(BitConverter.GetBytes((long)d), 0);
- #else
- r = BitConverter.Int64BitsToDouble( d );// memcpy( &r, d, sizeof( r ) );
- #endif
- z = sqlite3_mprintf( argv[1].ToString(), r );
- TCL.Tcl_AppendResult( interp, z );
- //sqlite3DbFree(db,z);
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_enable_shared_cache ?BOOLEAN?
- **
- */
- #if !SQLITE_OMIT_SHARED_CACHE
- static int test_enable_shared(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- int rc;
- bool enable = false;
- int ret = 0;
- if ( objc != 2 && objc != 1 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "?BOOLEAN?" );
- return TCL.TCL_ERROR;
- }
- ret = sqlite3GlobalConfig.sharedCacheEnabled ? 1 : 0;
- if ( objc == 2 )
- {
- if ( TCL.Tcl_GetBooleanFromObj( interp, objv[1], out enable ) )
- {
- return TCL.TCL_ERROR;
- }
- rc = sqlite3_enable_shared_cache( enable );
- if ( rc != SQLITE_OK )
- {
- TCL.Tcl_SetResult( interp, sqlite3ErrStr( rc ), TCL.TCL_STATIC );
- return TCL.TCL_ERROR;
- }
- }
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewBooleanObj( ret ) );
- return TCL.TCL_OK;
- }
- #endif
- /*
- ** Usage: sqlite3_extended_result_codes DB BOOLEAN
- **
- */
- static int test_extended_result_codes(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- bool enable = false;
- sqlite3 db = null;
- if ( objc != 3 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB BOOLEAN" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, objv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.Tcl_GetBooleanFromObj( interp, objv[2], out enable ) )
- return TCL.TCL_ERROR;
- sqlite3_extended_result_codes( db, enable );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_libversion_number
- **
- */
- static int test_libversion_number(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_libversion_number() ) );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_table_column_metadata DB dbname tblname colname
- **
- */
- #if SQLITE_ENABLE_COLUMN_METADATA
- static int test_table_column_metadata(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- sqlite3 db = null;
- string zDb = null;
- string zTbl = null;
- string zCol = null;
- int rc;
- Tcl_Obj pRet;
- string zDatatype = null;
- string zCollseq = null;
- int notnull = 0;
- int primarykey = 0;
- int autoincrement = 0;
- if ( objc != 5 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB dbname tblname colname" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- zDb = TCL.Tcl_GetString( objv[2] );
- zTbl = TCL.Tcl_GetString( objv[3] );
- zCol = TCL.Tcl_GetString( objv[4] );
- if ( zDb.Length == 0 )
- zDb = null;
- rc = sqlite3_table_column_metadata( db, zDb, zTbl, zCol,
- ref zDatatype, ref zCollseq, ref notnull, ref primarykey, ref autoincrement );
- if ( rc != SQLITE_OK )
- {
- TCL.Tcl_AppendResult( interp, sqlite3_errmsg( db ) );
- return TCL.TCL_ERROR;
- }
- pRet = TCL.Tcl_NewObj();
- TCL.Tcl_ListObjAppendElement( null, pRet, TCL.Tcl_NewStringObj( zDatatype, -1 ) );
- TCL.Tcl_ListObjAppendElement( null, pRet, TCL.Tcl_NewStringObj( zCollseq, -1 ) );
- TCL.Tcl_ListObjAppendElement( null, pRet, TCL.Tcl_NewIntObj( notnull ) );
- TCL.Tcl_ListObjAppendElement( null, pRet, TCL.Tcl_NewIntObj( primarykey ) );
- TCL.Tcl_ListObjAppendElement( null, pRet, TCL.Tcl_NewIntObj( autoincrement ) );
- TCL.Tcl_SetObjResult( interp, pRet );
- return TCL.TCL_OK;
- }
- #endif
- #if !SQLITE_OMIT_INCRBLOB
- static int blobHandleFromObj(
- Tcl_Interp interp,
- Tcl_Obj *pObj,
- sqlite3_blob **ppBlob
- ){
- string z;
- int n;
- z = TCL.Tcl_GetStringFromObj(pObj, &n);
- if( n==0 ){
- *ppBlob = 0;
- }else{
- int notUsed;
- TCL.Tcl_Channel channel;
- ClientData instanceData;
- channel = TCL.Tcl_GetChannel(interp, z, ¬Used);
- if( null==channel ) return TCL.TCL_ERROR;
- TCL.Tcl_Flush(channel);
- TCL.Tcl_Seek(channel, 0, SEEK_SET);
- instanceData = TCL.Tcl_GetChannelInstanceData(channel);
- *ppBlob = *((sqlite3_blob *)instanceData);
- }
- return TCL.TCL_OK;
- }
- /*
- ** sqlite3_blob_bytes CHANNEL
- */
- static int test_blob_bytes(
- ClientData clientData, /* Not used */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- ){
- sqlite3_blob *pBlob;
- int nByte;
- if( objc!=2 ){
- TCL.Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL");
- return TCL.TCL_ERROR;
- }
- if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL.TCL_ERROR;
- nByte = sqlite3_blob_bytes(pBlob);
- TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(nByte));
- return TCL.TCL_OK;
- }
- /*
- ** sqlite3_blob_close CHANNEL
- */
- static int test_blob_close(
- ClientData clientData, /* Not used */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- ){
- sqlite3_blob *pBlob;
- if( objc!=2 ){
- TCL.Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL");
- return TCL.TCL_ERROR;
- }
- if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL.TCL_ERROR;
- sqlite3_blob_close(pBlob);
- return TCL.TCL_OK;
- }
- /*
- ** sqlite3_blob_read CHANNEL OFFSET N
- **
- ** This command is used to test the sqlite3_blob_read() in ways that
- ** the Tcl channel interface does not. The first argument should
- ** be the name of a valid channel created by the [incrblob] method
- ** of a database handle. This function calls sqlite3_blob_read()
- ** to read N bytes from offset OFFSET from the underlying SQLite
- ** blob handle.
- **
- ** On success, a byte-array object containing the read data is
- ** returned. On failure, the interpreter result is set to the
- ** text representation of the returned error code (i.e. "SQLITE_NOMEM")
- ** and a Tcl exception is thrown.
- */
- static int test_blob_read(
- ClientData clientData, /* Not used */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- ){
- sqlite3_blob *pBlob;
- int nByte;
- int iOffset;
- unsigned string zBuf = 0;
- int rc;
- if( objc!=4 ){
- TCL.Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL OFFSET N");
- return TCL.TCL_ERROR;
- }
- if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL.TCL_ERROR;
- if( TCL_OK!=TCL.Tcl_GetIntFromObj(interp, objv[2], &iOffset)
- || TCL_OK!=TCL.Tcl_GetIntFromObj(interp, objv[3], &nByte)
- ){
- return TCL.TCL_ERROR;
- }
- if( nByte>0 ){
- zBuf = (unsigned char )TCL.Tcl_Alloc(nByte);
- }
- rc = sqlite3_blob_read(pBlob, zBuf, nByte, iOffset);
- if( rc==SQLITE_OK ){
- TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewByteArrayObj(zBuf, nByte));
- }else{
- TCL.Tcl_SetResult(interp, (char )sqlite3TestErrorName(rc), TCL.TCL_VOLATILE);
- }
- TCL.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[] objv /* Command arguments */
- ){
- sqlite3_blob *pBlob;
- int iOffset;
- int rc;
- unsigned string zBuf;
- int nBuf;
- if( objc!=4 && objc!=5 ){
- TCL.Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL OFFSET DATA ?NDATA?");
- return TCL.TCL_ERROR;
- }
- if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL.TCL_ERROR;
- if( TCL_OK!=TCL.Tcl_GetIntFromObj(interp, objv[2], &iOffset) ){
- return TCL.TCL_ERROR;
- }
- zBuf = TCL.Tcl_GetByteArrayFromObj(objv[3], &nBuf);
- if( objc==5 && TCL.Tcl_GetIntFromObj(interp, objv[4], &nBuf) ){
- return TCL.TCL_ERROR;
- }
- rc = sqlite3_blob_write(pBlob, zBuf, nBuf, iOffset);
- if( rc!=SQLITE_OK ){
- TCL.Tcl_SetResult(interp, (char )sqlite3TestErrorName(rc), TCL.TCL_VOLATILE);
- }
- return (rc==SQLITE_OK ? TCL_OK : TCL_ERROR);
- }
- static int test_blob_reopen(
- ClientData clientData, /* Not used */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- ){
- TCL.Tcl_WideInt iRowid;
- sqlite3_blob *pBlob;
- int rc;
- if( objc!=3 ){
- TCL.Tcl_WrongNumArgs(interp, 1, objv, "CHANNEL ROWID");
- return TCL.TCL_ERROR;
- }
- if( blobHandleFromObj(interp, objv[1], &pBlob) ) return TCL.TCL_ERROR;
- if( TCL.Tcl_GetWideIntFromObj(interp, objv[2], &iRowid) ) return TCL.TCL_ERROR;
- rc = sqlite3_blob_reopen(pBlob, iRowid);
- if( rc!=SQLITE_OK ){
- TCL.Tcl_SetResult(interp, (char )sqlite3TestErrorName(rc), TCL.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.
- */
- public struct TestCollationX
- {
- public Tcl_Interp interp;
- public Tcl_Obj pCmp;
- public Tcl_Obj pDel;
- };
- //typedef struct TestCollationX TestCollationX;
- static void testCreateCollationDel( ref object pCtx )
- {
- TestCollationX p = (TestCollationX)pCtx;
- int rc = TCL.Tcl_EvalObjEx( p.interp, p.pDel, TCL.TCL_EVAL_DIRECT | TCL.TCL_EVAL_GLOBAL );
- if ( rc != TCL.TCL_OK )
- {
- TCL.Tcl_BackgroundError( p.interp );
- }
- TCL.Tcl_DecrRefCount( ref p.pCmp );
- TCL.Tcl_DecrRefCount( ref p.pDel );
- //sqlite3Free(ref p);
- }
- static int testCreateCollationCmp(
- object pCtx,
- int nLeft,
- string zLeft,
- int nRight,
- string zRight
- )
- {
- TestCollationX p = (TestCollationX)pCtx;
- Tcl_Obj pScript = TCL.Tcl_DuplicateObj( p.pCmp );
- int iRes = 0;
- TCL.Tcl_IncrRefCount( pScript );
- TCL.Tcl_ListObjAppendElement( null, pScript, TCL.Tcl_NewStringObj( zLeft, nLeft ) );
- TCL.Tcl_ListObjAppendElement( null, pScript, TCL.Tcl_NewStringObj( zRight, nRight ) );
- if ( TCL.TCL_OK != TCL.Tcl_EvalObjEx( p.interp, pScript, TCL.TCL_EVAL_DIRECT | TCL.TCL_EVAL_GLOBAL )
- || ( TCL.Tcl_GetIntFromObj( p.interp, TCL.Tcl_GetObjResult( p.interp ), out iRes ) != TCL.TCL_OK )
- )
- {
- TCL.Tcl_BackgroundError( p.interp );
- }
- TCL.Tcl_DecrRefCount( ref pScript );
- return iRes;
- }
- static int test_create_collation_v2(
- object clientdata, /* Not used */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- TestCollationX p;
- sqlite3 db = null;
- int rc;
- if ( objc != 5 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB-HANDLE NAME CMP-PROC DEL-PROC" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- p = new TestCollationX(); //(TestCollationX )sqlite3Malloc(sizeof(TestCollationX));
- p.pCmp = objv[3];
- p.pDel = objv[4];
- p.interp = interp;
- TCL.Tcl_IncrRefCount( p.pCmp );
- TCL.Tcl_IncrRefCount( p.pDel );
- rc = sqlite3_create_collation_v2( db, TCL.Tcl_GetString( objv[2] ), 16,
- p, (dxCompare)testCreateCollationCmp, testCreateCollationDel
- );
- if ( rc != SQLITE_MISUSE )
- {
- TCL.Tcl_AppendResult( interp, "sqlite3_create_collate_v2() failed to detect " +
- "an invalid encoding" );
- return TCL.TCL_ERROR;
- }
- rc = sqlite3_create_collation_v2( db, TCL.Tcl_GetString( objv[2] ), SQLITE_UTF8,
- p, (dxCompare)testCreateCollationCmp, testCreateCollationDel
- );
- return TCL.TCL_OK;
- }
- /*
- ** USAGE: sqlite3_create_function_v2 DB NAME NARG ENC ?SWITCHES?
- **
- ** Available switches are:
- **
- ** -func SCRIPT
- ** -step SCRIPT
- ** -final SCRIPT
- ** -destroy SCRIPT
- */
- //typedef struct CreateFunctionV2 CreateFunctionV2;
- public class CreateFunctionV2
- {
- public Tcl_Interp interp;
- public Tcl_Obj pFunc; /* Script for function invocation */
- public Tcl_Obj pStep; /* Script for agg. step invocation */
- public Tcl_Obj pFinal; /* Script for agg. finalization invocation */
- public Tcl_Obj pDestroy; /* Destructor script */
- };
- static void cf2Func( sqlite3_context ctx, int nArg, sqlite3_value[] aArg )
- {
- }
- static void cf2Step( sqlite3_context ctx, int nArg, sqlite3_value[] aArg )
- {
- }
- static void cf2Final( sqlite3_context ctx )
- {
- }
- static void cf2Destroy( object pUser )
- {
- CreateFunctionV2 p = (CreateFunctionV2)pUser;
- if ( p.interp != null && p.pDestroy != null )
- {
- int rc = TCL.Tcl_EvalObjEx( p.interp, p.pDestroy, 0 );
- if ( rc != TCL.TCL_OK )
- TCL.Tcl_BackgroundError( p.interp );
- }
- if ( p.pFunc != null )
- TCL.Tcl_DecrRefCount( ref p.pFunc );
- if ( p.pStep != null )
- TCL.Tcl_DecrRefCount( ref p.pStep );
- if ( p.pFinal != null )
- TCL.Tcl_DecrRefCount( ref p.pFinal );
- if ( p.pDestroy != null )
- TCL.Tcl_DecrRefCount( ref p.pDestroy );
- //sqlite3_free( p);
- }
- public class EncTable
- {
- public string zEnc;
- public int enc;
- public EncTable( string zEnc, int enc )
- {
- this.zEnc = zEnc;
- this.enc = enc;
- }
- }
- static int test_create_function_v2(
- ClientData clientData, /* Not used */
- Tcl_Interp interp, /* The invoking TCL interpreter */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- sqlite3 db = null;
- string zFunc;
- int nArg = 0;
- int enc = 0;
- CreateFunctionV2 p;
- int i;
- int rc;
- EncTable[] aEnc = {
- new EncTable("utf8", SQLITE_UTF8 ),
- new EncTable("utf16", SQLITE_UTF16 ),
- new EncTable("utf16le", SQLITE_UTF16LE ),
- new EncTable("utf16be", SQLITE_UTF16BE ),
- new EncTable("any", SQLITE_ANY ),
- new EncTable("0", 0 )
- };
- if ( objc < 5 || ( objc % 2 ) == 0 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB NAME NARG ENC SWITCHES..." );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- zFunc = TCL.Tcl_GetString( objv[2] );
- if ( TCL.Tcl_GetIntFromObj( interp, objv[3], out nArg ) != 0 )
- return TCL.TCL_ERROR;
- //if ( TCL.Tcl_GetIndexFromObjStruct( interp, objv[4], aEnc,//sizeof(aEnc[0]),
- // "encoding", 0, ref enc)
- //)
- int iEnc;
- for ( iEnc = 0; iEnc < aEnc.Length && ( aEnc[iEnc].zEnc != objv[4].ToString() ); iEnc++ )
- {
- }
- if ( iEnc >= aEnc.Length )
- return TCL.TCL_ERROR;
- enc = aEnc[iEnc].enc;
- p = new CreateFunctionV2();//sqlite3_malloc( sizeof( CreateFunctionV2 ) );
- //Debug.Assert( p );
- //memset(p, 0, sizeof(CreateFunctionV2));
- p.interp = interp;
- for ( i = 5; i < objc; i += 2 )
- {
- int iSwitch = 0;
- string[] azSwitch = { "-func", "-step", "-final", "-destroy", "" };
- if ( TCL.Tcl_GetIndexFromObj( interp, objv[i], azSwitch, "switch", 0, out iSwitch ) )
- {
- //sqlite3_free(p);
- return TCL.TCL_ERROR;
- }
- switch ( iSwitch )
- {
- case 0:
- p.pFunc = objv[i + 1];
- break;
- case 1:
- p.pStep = objv[i + 1];
- break;
- case 2:
- p.pFinal = objv[i + 1];
- break;
- case 3:
- p.pDestroy = objv[i + 1];
- break;
- }
- }
- if ( p.pFunc != null )
- p.pFunc = TCL.Tcl_DuplicateObj( p.pFunc );
- if ( p.pStep != null )
- p.pStep = TCL.Tcl_DuplicateObj( p.pStep );
- if ( p.pFinal != null )
- p.pFinal = TCL.Tcl_DuplicateObj( p.pFinal );
- if ( p.pDestroy != null )
- p.pDestroy = TCL.Tcl_DuplicateObj( p.pDestroy );
- if ( p.pFunc != null )
- TCL.Tcl_IncrRefCount( p.pFunc );
- if ( p.pStep != null )
- TCL.Tcl_IncrRefCount( p.pStep );
- if ( p.pFinal != null )
- TCL.Tcl_IncrRefCount( p.pFinal );
- if ( p.pDestroy != null )
- TCL.Tcl_IncrRefCount( p.pDestroy );
- rc = sqlite3_create_function_v2( db, zFunc, nArg, enc, p,
- ( p.pFunc != null ? (dxFunc)cf2Func : (dxFunc)null ),
- ( p.pStep != null ? (dxStep)cf2Step : (dxStep)null ),
- ( p.pFinal != null ? (dxFinal)cf2Final : (dxFinal)null ),
- (dxFDestroy)cf2Destroy
- );
- if ( rc != SQLITE_OK )
- {
- TCL.Tcl_ResetResult( interp );
- TCL.Tcl_AppendResult( interp, sqlite3TestErrorName( rc ) );
- return TCL.TCL_ERROR;
- }
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_load_extension DB-HANDLE FILE ?PROC?
- */
- //static int test_load_extension(
- // object clientdata, /* Not used */
- // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- // int objc, /* Number of arguments */
- // Tcl_Obj[] objv /* Command arguments */
- //){
- // TCL.Tcl_CmdInfo cmdInfo;
- // sqlite3 db=null;
- // int rc;
- // string zDb;
- // string zFile;
- // string zProc = 0;
- // string zErr = 0;
- // if( objc!=4 && objc!=3 ){
- // TCL.Tcl_WrongNumArgs(interp, 1, objv, "DB-HANDLE FILE ?PROC?");
- // return TCL.TCL_ERROR;
- // }
- // zDb = TCL.Tcl_GetString(objv[1]);
- // zFile = TCL.Tcl_GetString(objv[2]);
- // if( objc==4 ){
- // zProc = TCL.Tcl_GetString(objv[3]);
- // }
- // /* Extract the C database handle from the Tcl command name */
- // if( null==TCL.Tcl_GetCommandInfo(interp, zDb, cmdInfo) ){
- // TCL.Tcl_AppendResult(interp, "command not found: ", zDb);
- // return TCL.TCL_ERROR;
- // }
- // db = ((struct SqliteDb)cmdInfo.objclientdata).db;
- // Debug.Assert(db);
- // /* Call the underlying C function. If an error occurs, set rc to
- // ** TCL.TCL_ERROR and load any error string into the interpreter. If no
- // ** error occurs, set rc to TCL.TCL_OK.
- // */
- #if 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.Tcl_SetResult(interp, zErr ? zErr : "", TCL.Tcl_VOLATILE);
- // rc = TCL.TCL_ERROR;
- // }else{
- // rc = TCL.TCL_OK;
- // }
- // sqlite3DbFree(db,zErr);
- // return rc;
- //}
- /*
- ** Usage: sqlite3_enable_load_extension DB-HANDLE ONOFF
- */
- //static int test_enable_load(
- // object clientdata, /* Not used */
- // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- // int objc, /* Number of arguments */
- // Tcl_Obj[] objv /* Command arguments */
- //){
- // TCL.Tcl_CmdInfo cmdInfo;
- // sqlite3 db=null;
- // string zDb;
- // int onoff;
- // if( objc!=3 ){
- // TCL.Tcl_WrongNumArgs(interp, 1, objv, "DB-HANDLE ONOFF");
- // return TCL.TCL_ERROR;
- // }
- // zDb = TCL.Tcl_GetString(objv[1]);
- // /* Extract the C database handle from the Tcl command name */
- // if( null==TCL.Tcl_GetCommandInfo(interp, zDb, cmdInfo) ){
- // TCL.Tcl_AppendResult(interp, "command not found: ", zDb);
- // return TCL.TCL_ERROR;
- // }
- // db = ((struct SqliteDb)cmdInfo.objclientdata).db;
- // Debug.Assert(db);
- // /* Get the onoff parameter */
- // if( TCL.Tcl_GetBooleanFromObj(interp, objv[2], out onoff) ){
- // return TCL.TCL_ERROR;
- // }
- #if SQLITE_OMIT_LOAD_EXTENSION
- // TCL.Tcl_AppendResult(interp, "this build omits sqlite3_load_extension()");
- // return TCL.TCL_ERROR;
- #else
- // sqlite3_enable_load_extension(db, onoff);
- // return TCL.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(
- // object NotUsed,
- // Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- // int argc, /* Number of arguments */
- // Tcl_Obj[] argv /* Text of each argument */
- //){
- //#if defined(_MSC_VER)
- // /* We do this, otherwise the test will halt with a popup message
- // * that we have to click away before the test will continue.
- // */
- // _set_abort_behavior( 0, _CALL_REPORTFAULT );
- //#endif
- // exit(255);
- // Debug.Assert( interp==0 ); /* This will always fail */
- // return TCL.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 )
- {
- int ARGV = 0;
- while ( argc >= 2 )
- {
- string zArg0 = sqlite3_value_text( argv[ARGV] );
- if ( zArg0 != null )
- {
- if ( zArg0.Equals( "int", StringComparison.InvariantCultureIgnoreCase ) )
- {
- sqlite3_result_int( context, sqlite3_value_int( argv[ARGV + 1] ) );
- }
- else if ( zArg0.Equals( "int64", StringComparison.InvariantCultureIgnoreCase ) )
- {
- sqlite3_result_int64( context, sqlite3_value_int64( argv[ARGV + 1] ) );
- }
- else if ( zArg0.Equals( "string", StringComparison.InvariantCultureIgnoreCase ) )
- {
- sqlite3_result_text( context, sqlite3_value_text( argv[ARGV + 1] ), -1,
- SQLITE_TRANSIENT );
- }
- else if ( zArg0.Equals( "double", StringComparison.InvariantCultureIgnoreCase ) )
- {
- sqlite3_result_double( context, sqlite3_value_double( argv[ARGV + 1] ) );
- }
- else if ( zArg0.Equals( "null", StringComparison.InvariantCultureIgnoreCase ) )
- {
- sqlite3_result_null( context );
- }
- else if ( zArg0.Equals( "value", StringComparison.InvariantCultureIgnoreCase ) )
- {
- sqlite3_result_value( context, argv[sqlite3_value_int( argv[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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3 db = null;
- int rc;
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB FUNCTION-NAME" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_create_function( db, argv[2].ToString(), -1, SQLITE_UTF8, 0,
- testFunc, null, null );
- if ( rc != 0 )
- {
- TCL.Tcl_AppendResult( interp, sqlite3ErrStr( rc ) );
- return TCL.TCL_ERROR;
- }
- if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
- return TCL.TCL_ERROR;
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_finalize STMT
- **
- ** Finalize a statement handle.
- */
- static int test_finalize(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int rc;
- sqlite3 db = null;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " <STMT>" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( pStmt != null )
- {
- db = sqlite3_db_handle( pStmt );// StmtToDb( pStmt );
- }
- rc = sqlite3_finalize( pStmt );
- TCL.Tcl_SetResult( interp, sqlite3TestErrorName( rc ), TCL.TCL_STATIC );//t1ErrorName( rc ), TCL.TCL_STATIC );
- if ( db != null && sqlite3TestErrCode( interp, db, rc ) != 0 )
- return TCL.TCL_ERROR;
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_stmt_status STMT CODE RESETFLAG
- **
- ** Get the value of a status counter from a statement.
- */
- static int test_stmt_status(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- int iValue;
- int i, op = 0;
- bool resetFlag = false;
- string zOpName;
- sqlite3_stmt pStmt = null;
- //struct _aOp{
- // string zName;
- // int op;
- //}
- _aOp[] aOp = {
- new _aOp( "SQLITE_STMTSTATUS_FULLSCAN_STEP", SQLITE_STMTSTATUS_FULLSCAN_STEP ),
- new _aOp( "SQLITE_STMTSTATUS_SORT", SQLITE_STMTSTATUS_SORT ),
- new _aOp( "SQLITE_STMTSTATUS_AUTOINDEX", SQLITE_STMTSTATUS_AUTOINDEX )
- };
- if ( objc != 4 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT PARAMETER RESETFLAG" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- zOpName = TCL.Tcl_GetString( objv[2] );
- for ( i = 0; i < ArraySize( aOp ); i++ )
- {
- if ( aOp[i].zName == zOpName )
- {
- op = aOp[i].op;
- break;
- }
- }
- if ( i >= ArraySize( aOp ) )
- {
- if ( TCL.Tcl_GetIntFromObj( interp, objv[2], out op ) != 0 )
- return TCL.TCL_ERROR;
- }
- if ( TCL.Tcl_GetBooleanFromObj( interp, objv[3], out resetFlag ) )
- return TCL.TCL_ERROR;
- iValue = sqlite3_stmt_status( pStmt, op, resetFlag ? 1 : 0 );
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( iValue ) );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_next_stmt DB STMT
- **
- ** Return the next statment in sequence after STMT.
- */
- static int test_next_stmt(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- sqlite3 db = null;
- StringBuilder zBuf = new StringBuilder( 50 );
- if ( objc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " DB STMT" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[2] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- pStmt = sqlite3_next_stmt( db, pStmt );
- if ( pStmt != null )
- {
- if ( sqlite3TestMakePointerStr( interp, zBuf, pStmt ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_AppendResult( interp, zBuf );
- }
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_stmt_readonly STMT
- **
- ** Return true if STMT is a NULL pointer or a pointer to a statement
- ** that is guaranteed to leave the database unmodified.
- */
- static int test_stmt_readonly(
- object clientData,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int rc;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT", 0 );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_stmt_readonly( pStmt ) ? 1 : 0;
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewBooleanObj( rc ) );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: uses_stmt_journal STMT
- **
- ** Return true if STMT uses a statement journal.
- */
- static int uses_stmt_journal(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int rc;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT", 0 );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_stmt_readonly( pStmt ) ? 1 : 0;
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewBooleanObj( pStmt.usesStmtJournal ? 1 : 0 ) );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_reset STMT
- **
- ** Reset a statement handle.
- */
- static int test_reset(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int rc;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " <STMT>" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_reset( pStmt );
- if ( pStmt != null && sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
- {
- return TCL.TCL_ERROR;
- }
- TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
- /*
- if( rc !=0){
- return TCL.TCL_ERROR;
- }
- */
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_expired STMT
- **
- ** Return TRUE if a recompilation of the statement is recommended.
- */
- static int test_expired(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- #if !SQLITE_OMIT_DEPRECATED
- sqlite3_stmt pStmt = null;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " <STMT>" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 ) return TCL.TCL_ERROR;
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewBooleanObj( sqlite3_expired( pStmt ) ) );
- #endif
- TCL.Tcl_SetResult( interp, "0", 0 );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3TransferBindings FROMSTMT TOSTMT
- **
- ** Transfer all bindings from FROMSTMT over to TOSTMT
- */
- static int test_transfer_bind(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- #if !SQLITE_OMIT_DEPRECATED
- sqlite3_stmt pStmt1 = null, pStmt2 = null;
- if ( objc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " FROM-STMT TO-STMT" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt1 ) != 0 ) return TCL.TCL_ERROR;
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[2] ), out pStmt2 ) != 0 ) return TCL.TCL_ERROR;
- TCL.Tcl_SetObjResult( interp,
- TCL.Tcl_NewIntObj( pStmt1.nVar == pStmt2.nVar ? sqlite3TransferBindings( pStmt1, pStmt2 ) : TCL.TCL_ERROR ) );
- #endif
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_changes DB
- **
- ** Return the number of changes made to the database by the last SQL
- ** execution.
- */
- static int test_changes(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3 db = null;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " DB" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_changes( db ) ) );
- return TCL.TCL_OK;
- }
- /*
- ** This is the "static_bind_value" that variables are bound to when
- ** the FLAG option of sqlite3_bind is "static"
- */
- //static string sqlite_static_bind_value = "";
- //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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- sqlite3_stmt pStmt = null;
- int rc;
- int idx = 0;
- if ( argc != 5 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " VM IDX VALUE (null|static|normal)\"" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, argv[1].ToString(), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.Tcl_GetInt( interp, argv[2], out idx ) )
- return TCL.TCL_ERROR;
- if ( argv[4].ToString() == "null" )
- {
- rc = sqlite3_bind_null( pStmt, idx );
- }
- else if ( argv[4].ToString() == "static" )
- {
- rc = sqlite3_bind_text( pStmt, idx, sqlite_static_bind_value.sValue, -1, null );
- }
- else if ( argv[4].ToString() == "static-nbytes" )
- {
- rc = sqlite3_bind_text( pStmt, idx, sqlite_static_bind_value.sValue,
- sqlite_static_bind_nbyte.iValue, null );
- }
- else if ( argv[4].ToString() == "normal" )
- {
- rc = sqlite3_bind_text( pStmt, idx, argv[3].ToString(), -1, SQLITE_TRANSIENT );
- }
- else if ( argv[4].ToString() == "blob10" )
- {
- rc = sqlite3_bind_text( pStmt, idx, "abc\0xyz\0pq", 10, SQLITE_STATIC );
- }
- else
- {
- TCL.Tcl_AppendResult( interp, "4th argument should be " +
- "\"null\" or \"static\" or \"normal\"" );
- return TCL.TCL_ERROR;
- }
- if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
- return TCL.TCL_ERROR;
- if ( rc != 0 )
- {
- StringBuilder zBuf = new StringBuilder( 50 );
- sqlite3_snprintf( 50, zBuf, "(%d) ", rc );
- TCL.Tcl_SetResult( interp, zBuf + sqlite3ErrStr( rc ), 0 );
- return TCL.TCL_ERROR;
- }
- return TCL.TCL_OK;
- }
- #if !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(
- // object pCtx,,
- // int nA, string zA,
- // int nB, string zB
- //){
- // Tcl_Interp *i = pTestCollateInterp;
- // int encin = SQLITE_PTR_TO_INT(pCtx);
- // int res;
- // int n;
- // sqlite3_value pVal;
- // Tcl_Obj pX;
- // pX = TCL.Tcl_NewStringObj("test_collate", -1);
- // TCL.Tcl_IncrRefCount(pX);
- // switch( encin ){
- // case SQLITE_UTF8:
- // TCL.Tcl_ListObjAppendElement(i,pX,TCL.Tcl_NewStringObj("UTF-8",-1));
- // break;
- // case SQLITE_UTF16LE:
- // TCL.Tcl_ListObjAppendElement(i,pX,TCL.Tcl_NewStringObj("UTF-16LE",-1));
- // break;
- // case SQLITE_UTF16BE:
- // TCL.Tcl_ListObjAppendElement(i,pX,TCL.Tcl_NewStringObj("UTF-16BE",-1));
- // break;
- // default:
- // Debug.Assert(false);
- // }
- //sqlite3BeginBenignMalloc();
- // pVal = sqlite3ValueNew(0);
- // if( pVal ){
- // sqlite3ValueSetStr(pVal, nA, zA, encin, SQLITE_STATIC);
- // n = sqlite3_value_bytes(pVal);
- // TCL.Tcl_ListObjAppendElement(i,pX,
- // TCL.Tcl_NewStringObj((char)sqlite3_value_text(pVal),n));
- // sqlite3ValueSetStr(pVal, nB, zB, encin, SQLITE_STATIC);
- // n = sqlite3_value_bytes(pVal);
- // TCL.Tcl_ListObjAppendElement(i,pX,
- // TCL.Tcl_NewStringObj((char)sqlite3_value_text(pVal),n));
- // sqlite3ValueFree(pVal);
- //}
- //sqlite3EndBenignMalloc();
- // TCL.Tcl_EvalObjEx(i, pX, 0);
- // TCL.Tcl_DecrRefCount(pX);
- // TCL.Tcl_GetIntFromObj(i, TCL.Tcl_GetObjResult(i), res);
- // return res;
- //}
- //static int test_collate(
- // object clientdata,
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- // sqlite3 db=null;
- // int val;
- // sqlite3_value pVal;
- // int rc;
- // if( objc!=5 ) goto bad_args;
- // pTestCollateInterp = interp;
- // if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;
- // if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[2], out val) ) return TCL.TCL_ERROR;
- // rc = sqlite3_create_collation(db, "test_collate", SQLITE_UTF8,
- // (void )SQLITE_UTF8, val?test_collate_func:0);
- // if( rc==SQLITE_OK ){
- // string zUtf16;
- // if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[3], out val) ) return TCL.TCL_ERROR;
- // rc = sqlite3_create_collation(db, "test_collate", SQLITE_UTF16LE,
- // (void )SQLITE_UTF16LE, val?test_collate_func:0);
- // if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[4], out val) ) return TCL.TCL_ERROR;
- //#if FALSE
- // 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 !=0{
- // 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.TCL_ERROR;
- // if( rc!=SQLITE_OK ){
- // TCL.Tcl_AppendResult(interp, sqlite3TestErrorName(rc));
- // return TCL.TCL_ERROR;
- // }
- // return TCL.TCL_OK;
- //bad_args:
- // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
- // TCL.Tcl_GetStringFromObj(objv[0], 0), " <DB> <utf8> <utf16le> <utf16be>", 0);
- // return TCL.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(
- // object pCtx,,
- // sqlite3 db,
- // int eTextRep,
- // const void pName
- //){
- // int enc = ENC(db);
- // int i;
- // string z;
- // for(z = (char)pName, i=0; *z || z[1]; z++){
- // if( *z ) zNeededCollation[i++] = *z;
- // }
- // zNeededCollation[i] = 0;
- // sqlite3_create_collation(
- // db, "test_collate", ENC(db), SQLITE_INT_TO_PTR(enc), test_collate_func);
- //}
- /*
- ** Usage: add_test_collate_needed DB
- */
- //static int test_collate_needed(
- // object clientdata,
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- // sqlite3 db=null;
- // int rc;
- // if( objc!=2 ) goto bad_args;
- // if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;
- // rc = sqlite3_collation_needed16(db, 0, test_collate_needed_cb);
- // zNeededCollation[0] = 0;
- // if( sqlite3TestErrCode(interp, db, rc) ) return TCL.TCL_ERROR;
- // return TCL.TCL_OK;
- //bad_args:
- // TCL.Tcl_WrongNumArgs(interp, 1, objv, "DB");
- // return TCL.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(
- // object NotUsed,
- // int nKey1, const void pKey1,
- // int nKey2, const void pKey2
- //){
- // int rc, n;
- // n = nKey1<nKey2 ? nKey1 : nKey2;
- //if( nKey1>0 && 1==(1&(SQLITE_PTR_TO_INT(pKey1))) ) unaligned_string_counter++;
- //if( nKey2>0 && 1==(1&(SQLITE_PTR_TO_INT(pKey2))) ) unaligned_string_counter++;
- // rc = memcmp(pKey1, pKey2, n);
- // if( rc==0 ){
- // rc = nKey1 - nKey2;
- // }
- // return rc;
- //}
- //static int add_alignment_test_collations(
- // object clientdata,
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- // sqlite3 db=null;
- // if( objc>=2 ){
- // if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.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 // * !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.
- */
- #if !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_context_db_handle(pCtx);
- // pX = TCL.Tcl_NewStringObj("test_function", -1);
- // TCL.Tcl_IncrRefCount(pX);
- // TCL.Tcl_ListObjAppendElement(interp, pX, TCL.Tcl_NewStringObj("UTF-8", -1));
- // TCL.Tcl_ListObjAppendElement(interp, pX,
- // TCL.Tcl_NewStringObj((char)sqlite3_value_text(argv[0]), -1));
- // TCL.Tcl_EvalObjEx(interp, pX, 0);
- // TCL.Tcl_DecrRefCount(pX);
- // sqlite3_result_text(pCtx, TCL.Tcl_GetStringResult(interp), -1, SQLITE_TRANSIENT);
- // pVal = sqlite3ValueNew(0);
- // sqlite3ValueSetStr(pVal, -1, TCL.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_context_db_handle(pCtx);
- // pX = TCL.Tcl_NewStringObj("test_function", -1);
- // TCL.Tcl_IncrRefCount(pX);
- // TCL.Tcl_ListObjAppendElement(interp, pX, TCL.Tcl_NewStringObj("UTF-16LE", -1));
- // TCL.Tcl_ListObjAppendElement(interp, pX,
- // TCL.Tcl_NewStringObj((char)sqlite3_value_text(argv[0]), -1));
- // TCL.Tcl_EvalObjEx(interp, pX, 0);
- // TCL.Tcl_DecrRefCount(pX);
- // pVal = sqlite3ValueNew(0);
- // sqlite3ValueSetStr(pVal, -1, TCL.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_context_db_handle(pCtx);
- // pX = TCL.Tcl_NewStringObj("test_function", -1);
- // TCL.Tcl_IncrRefCount(pX);
- // TCL.Tcl_ListObjAppendElement(interp, pX, TCL.Tcl_NewStringObj("UTF-16BE", -1));
- // TCL.Tcl_ListObjAppendElement(interp, pX,
- // TCL.Tcl_NewStringObj((char)sqlite3_value_text(argv[0]), -1));
- // TCL.Tcl_EvalObjEx(interp, pX, 0);
- // TCL.Tcl_DecrRefCount(pX);
- // pVal = sqlite3ValueNew(0);
- // sqlite3ValueSetStr(pVal, -1, TCL.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(
- // object clientdata,
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- #if !SQLITE_OMIT_UTF16
- // sqlite3 db=null;
- // int val;
- // if( objc!=5 ) goto bad_args;
- // if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;
- // if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[2], out val) ) return TCL.TCL_ERROR;
- // if( val ){
- // sqlite3_create_function(db, "test_function", 1, SQLITE_UTF8,
- // interp, test_function_utf8, 0, 0);
- // }
- // if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[3], out val) ) return TCL.TCL_ERROR;
- // if( val ){
- // sqlite3_create_function(db, "test_function", 1, SQLITE_UTF16LE,
- // interp, test_function_utf16le, 0, 0);
- // }
- // if( TCL.TCL_OK!=TCL.Tcl_GetBooleanFromObj(interp, objv[4], out val) ) return TCL.TCL_ERROR;
- // if( val ){
- // sqlite3_create_function(db, "test_function", 1, SQLITE_UTF16BE,
- // interp, test_function_utf16be, 0, 0);
- // }
- // return TCL.TCL_OK;
- //bad_args:
- // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
- // TCL.Tcl_GetStringFromObj(objv[0], 0), " <DB> <utf8> <utf16le> <utf16be>", 0);
- #endif // * SQLITE_OMIT_UTF16 */
- // return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- string zCode;
- int i;
- if ( objc != 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "<error code>" );
- }
- zCode = TCL.Tcl_GetString( objv[1] );
- for ( i = 0; i < 200; i++ )
- {
- if ( t1ErrorName( i ).Equals( zCode ) )
- break;
- }
- TCL.Tcl_SetResult( interp, sqlite3ErrStr( i ), 0 );
- return TCL.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(
- object NotUsed,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int argc, /* Number of arguments */
- Tcl_Obj[] argv /* Text of each argument */
- )
- {
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int idx = 0;
- int n = 0;
- int rc;
- if ( objc != 4 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT IDX N" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[3], out n ) )
- return TCL.TCL_ERROR;
- rc = sqlite3_bind_zeroblob( pStmt, idx, n );
- if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
- return TCL.TCL_ERROR;
- if ( rc != SQLITE_OK )
- {
- return TCL.TCL_ERROR;
- }
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int idx = 0;
- int value = 0;
- int rc;
- if ( objc != 4 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N VALUE" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[3], out value ) )
- return TCL.TCL_ERROR;
- rc = sqlite3_bind_int( pStmt, idx, value );
- if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
- return TCL.TCL_ERROR;
- if ( rc != SQLITE_OK )
- {
- return TCL.TCL_ERROR;
- }
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int idx = 0;
- i64 value = 0;
- int rc;
- if ( objc != 4 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N VALUE" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
- return TCL.TCL_ERROR;
- if ( TCL.Tcl_GetWideIntFromObj( interp, objv[3], out value ) )
- return TCL.TCL_ERROR;
- rc = sqlite3_bind_int64( pStmt, idx, value );
- if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
- return TCL.TCL_ERROR;
- if ( rc != SQLITE_OK )
- {
- return TCL.TCL_ERROR;
- }
- return TCL.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.
- */
- class _aSpecialFp
- {
- public string zName; /* Name of the special floating point value */
- public u32 iUpper; /* Upper 32 bits */
- public u32 iLower; /* Lower 32 bits */
- public _aSpecialFp( string zName, u32 iUpper, u32 iLower )
- {
- this.zName = zName;
- this.iUpper = iUpper;
- this.iLower = iLower;
- }
- }
- static int test_bind_double(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- ;
- int idx = 0;
- double value = 0;
- int rc;
- string zVal;
- int i;
- _aSpecialFp[] aSpecialFp = new _aSpecialFp[] {
- new _aSpecialFp( "NaN", 0x7fffffff, 0xffffffff ),
- new _aSpecialFp( "SNaN", 0x7ff7ffff, 0xffffffff ),
- new _aSpecialFp( "-NaN", 0xffffffff, 0xffffffff ),
- new _aSpecialFp( "-SNaN", 0xfff7ffff, 0xffffffff ),
- new _aSpecialFp( "+Inf", 0x7ff00000, 0x00000000 ),
- new _aSpecialFp( "-Inf", 0xfff00000, 0x00000000 ),
- new _aSpecialFp( "Epsilon", 0x00000000, 0x00000001 ),
- new _aSpecialFp( "-Epsilon", 0x80000000, 0x00000001 ),
- new _aSpecialFp( "NaN0", 0x7ff80000, 0x00000000 ),
- new _aSpecialFp( "-NaN0", 0xfff80000, 0x00000000 ),
- };
- if ( objc != 4 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N VALUE" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
- return TCL.TCL_ERROR;
- /* Intercept the string "NaN" and generate a NaN value for it.
- ** All other strings are passed through to TCL.Tcl_GetDoubleFromObj().
- ** TCL.Tcl_GetDoubleFromObj() should understand "NaN" but some versions
- ** contain a bug.
- */
- zVal = TCL.Tcl_GetString( objv[3] );
- for ( i = 0; i < aSpecialFp.Length; i++ )
- {//sizeof(aSpecialFp)/sizeof(aSpecialFp[0]); i++){
- if ( aSpecialFp[i].zName == zVal )
- {
- i64 x;
- x = aSpecialFp[i].iUpper;
- x <<= 32;
- x |= aSpecialFp[i].iLower;
- Debug.Assert( sizeof( double ) == 8 );
- Debug.Assert( sizeof( sqlite3_u3264 ) == 8 );
- #if WINDOWS_PHONE
- value = BitConverter.ToDouble(BitConverter.GetBytes((long)x), 0);
- #else
- value = BitConverter.Int64BitsToDouble( x );//memcpy(&value, x, 8);
- #endif
- //value = Double.NaN;
- break;
- }
- }
- if ( ( i >= aSpecialFp.Length ) && //sizeof(aSpecialFp)/sizeof(aSpecialFp[0]) &&
- TCL.Tcl_GetDoubleFromObj( interp, objv[3], out value ) )
- {
- return TCL.TCL_ERROR;
- }
- rc = sqlite3_bind_double( pStmt, idx, value );
- if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
- return TCL.TCL_ERROR;
- if ( rc != SQLITE_OK )
- {
- return TCL.TCL_ERROR;
- }
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- ;
- int idx = 0;
- int rc;
- if ( objc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
- return TCL.TCL_ERROR;
- rc = sqlite3_bind_null( pStmt, idx );
- if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
- return TCL.TCL_ERROR;
- if ( rc != SQLITE_OK )
- {
- return TCL.TCL_ERROR;
- }
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int idx = 0;
- int bytes = 0;
- byte[] value;
- int rc;
- if ( objc != 5 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N VALUE BYTES" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out idx ) )
- return TCL.TCL_ERROR;
- value = TCL.Tcl_GetByteArrayFromObj( objv[3], out bytes );
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[4], out bytes ) )
- return TCL.TCL_ERROR;
- rc = sqlite3_bind_text( pStmt, idx, Encoding.UTF8.GetString( value, 0, value.Length ), bytes, SQLITE_TRANSIENT );
- if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
- return TCL.TCL_ERROR;
- if ( rc != SQLITE_OK )
- {
- TCL.Tcl_AppendResult( interp, sqlite3TestErrorName( rc ) );
- return TCL.TCL_ERROR;
- }
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- #if !SQLITE_OMIT_UTF16
- sqlite3_stmt pStmt=null;
- int idx=0;
- int bytes=0;
- string value;
- int rc;
- dxDel 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.Tcl_AppendResult(interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj(objv[0], 0), " STMT N VALUE BYTES", 0);
- return TCL.TCL_ERROR;
- }
- if( getStmtPointer(interp, TCL.Tcl_GetString(oStmt), out pStmt)!=0 ) return TCL.TCL_ERROR;
- if( TCL.Tcl_GetIntFromObj(interp, oN, out idx) ) return TCL.TCL_ERROR;
- int dummy0 = 0;
- value = Encoding.UTF8.GetString(TCL.Tcl_GetByteArrayFromObj( oString, out dummy0 ));
- if( TCL.Tcl_GetIntFromObj(interp, oBytes, out bytes) ) return TCL.TCL_ERROR;
- rc = sqlite3_bind_text16(pStmt, idx, value, bytes, xDel);
- if( sqlite3TestErrCode(interp, StmtToDb(pStmt), rc) !=0) return TCL.TCL_ERROR;
- if( rc!=SQLITE_OK ){
- TCL.Tcl_AppendResult(interp, sqlite3TestErrorName(rc));
- return TCL.TCL_ERROR;
- }
- #endif // * SQLITE_OMIT_UTF16 */
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int idx = 0;
- int bytes = 0;
- byte[] value;
- int rc;
- dxDel xDestructor = SQLITE_TRANSIENT;
- int iObjv = 0;
- if ( objc != 5 && objc != 6 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " STMT N DATA BYTES" );
- return TCL.TCL_ERROR;
- }
- if ( objc == 6 )
- {
- xDestructor = SQLITE_STATIC;
- iObjv++;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[iObjv + 1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[iObjv + 2], out idx ) )
- return TCL.TCL_ERROR;
- value = Encoding.UTF8.GetBytes( TCL.Tcl_GetString( objv[iObjv + 3] ) );
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[iObjv + 4], out bytes ) )
- return TCL.TCL_ERROR;
- rc = sqlite3_bind_blob( pStmt, idx, value, bytes, xDestructor );
- if ( sqlite3TestErrCode( interp, StmtToDb( pStmt ), rc ) != 0 )
- return TCL.TCL_ERROR;
- if ( rc != SQLITE_OK )
- {
- return TCL.TCL_ERROR;
- }
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_bind_parameter_count STMT
- **
- ** Return the number of wildcards in the given statement.
- */
- static int test_bind_parameter_count(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- if ( objc != 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_bind_parameter_count( pStmt ) ) );
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int i = 0;
- if ( objc != 3 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT N" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out i ) )
- return TCL.TCL_ERROR;
- TCL.Tcl_SetObjResult( interp,
- TCL.Tcl_NewStringObj( sqlite3_bind_parameter_name( pStmt, i ), -1 )
- );
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- if ( objc != 3 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT NAME" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_SetObjResult( interp,
- TCL.Tcl_NewIntObj(
- sqlite3_bind_parameter_index( pStmt, TCL.Tcl_GetString( objv[2] ) )
- )
- );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_clear_bindings STMT
- **
- */
- static int test_clear_bindings(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- if ( objc != 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_clear_bindings( pStmt ) ) );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_sleep MILLISECONDS
- */
- static int test_sleep(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- int ms = 0;
- if ( objc != 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "MILLISECONDS" );
- return TCL.TCL_ERROR;
- }
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[1], out ms ) )
- {
- return TCL.TCL_ERROR;
- }
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_sleep( ms ) ) );
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3 db = null;
- int rc;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " DB" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_extended_errcode( db );
- TCL.Tcl_AppendResult( interp, t1ErrorName( rc ) );
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3 db = null;
- int rc;
- StringBuilder zBuf = new StringBuilder( 50 );
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " DB" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_errcode( db );
- if ( ( rc & 0xff ) == rc )
- {
- zBuf.Length = 0;
- }
- else
- {
- sqlite3_snprintf( 30, zBuf, "+%d", rc >> 8 );
- }
- TCL.Tcl_AppendResult( interp, t1ErrorName( rc ), zBuf );
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3 db = null;
- string zErr;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " DB" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- zErr = sqlite3_errmsg( db );
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewStringObj( zErr, -1 ) );
- return TCL.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(
- // object clientdata,
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- #if !SQLITE_OMIT_UTF16
- sqlite3 db;
- string zErr;
- string z;
- int bytes = 0;
- if( objc!=2 ){
- TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
- TCL.Tcl_GetString(objv[0]), " DB", 0);
- return TCL.TCL_ERROR;
- }
- if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), &db) ) return TCL.TCL_ERROR;
- zErr = sqlite3_errmsg16(db);
- if( zErr ){
- z = zErr;
- for(bytes=0; z[bytes] || z[bytes+1]; bytes+=2){}
- }
- TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewByteArrayObj(zErr, bytes));
- #endif // * SQLITE_OMIT_UTF16 */
- // return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3 db = null;
- string zSql;
- int bytes = 0;
- string zTail = "";
- sqlite3_stmt pStmt = null;
- StringBuilder zBuf = new StringBuilder( 50 );
- int rc;
- if ( objc != 5 && objc != 4 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " DB sql bytes ?tailvar?" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- zSql = TCL.Tcl_GetString( objv[2] );
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[3], out bytes ) )
- return TCL.TCL_ERROR;
- if ( bytes > zSql.Length )
- bytes = zSql.Length;
- rc = sqlite3_prepare( db, zSql, bytes, ref pStmt, ref zTail );
- TCL.Tcl_ResetResult( interp );
- if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
- return TCL.TCL_ERROR;
- if ( zTail != null && objc >= 5 )
- {
- if ( bytes >= 0 )
- {
- bytes = bytes - zSql.Length - zTail.Length;// ( zTail - zSql );
- }
- if ( zTail.Length < bytes )
- {
- bytes = zTail.Length;
- }
- TCL.Tcl_ObjSetVar2( interp, objv[4], null, TCL.Tcl_NewStringObj( zTail, bytes ), 0 );
- }
- if ( rc != SQLITE_OK )
- {
- Debug.Assert( pStmt == null );
- sqlite3_snprintf( 200, zBuf, "(%d) ", rc );
- TCL.Tcl_SetResult( interp, zBuf + sqlite3_errmsg( db ), 0 );
- return TCL.TCL_ERROR;
- }
- if ( pStmt != null )
- {
- if ( sqlite3TestMakePointerStr( interp, zBuf, pStmt ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_AppendResult( interp, zBuf, null );
- }
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3 db = null;
- string zSql;
- int bytes = 0;
- string zTail = "";
- sqlite3_stmt pStmt = null;
- StringBuilder zBuf = new StringBuilder( 50 );
- int rc;
- if ( objc != 5 && objc != 4 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " DB sql bytes ?tailvar?", null );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- zSql = TCL.Tcl_GetString( objv[2] );
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[3], out bytes ) )
- return TCL.TCL_ERROR;
- rc = sqlite3_prepare_v2( db, zSql, bytes, ref pStmt, ref zTail );
- Debug.Assert( rc == SQLITE_OK || pStmt == null );
- TCL.Tcl_ResetResult( interp );
- if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
- return TCL.TCL_ERROR;
- if ( zTail != null && objc >= 5 )
- {
- if ( bytes >= 0 )
- {
- bytes = bytes - zSql.Length - zTail.Length;// ( zTail - zSql );
- }
- TCL.Tcl_ObjSetVar2( interp, objv[4], null, TCL.Tcl_NewStringObj( zTail, bytes ), 0 );
- }
- if ( rc != SQLITE_OK )
- {
- Debug.Assert( pStmt == null );
- sqlite3_snprintf( 50, zBuf, "(%d) ", rc );
- TCL.Tcl_AppendResult( interp, zBuf, sqlite3_errmsg( db ) );
- return TCL.TCL_ERROR;
- }
- if ( pStmt != null )
- {
- if ( sqlite3TestMakePointerStr( interp, zBuf, pStmt ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_AppendResult( interp, zBuf );
- }
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3 db = null;
- string zSql = "\000SELECT 1";
- sqlite3_stmt pStmt = null;
- StringBuilder zBuf = new StringBuilder( 50 );
- int rc;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " DB sql bytes tailvar" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_prepare_v2( db, zSql.Substring( 1 ), 0, ref pStmt, 0 );
- Debug.Assert( rc == SQLITE_OK || pStmt == null );
- if ( sqlite3TestErrCode( interp, db, rc ) != 0 )
- return TCL.TCL_ERROR;
- if ( rc != SQLITE_OK )
- {
- Debug.Assert( pStmt == null );
- zBuf.Length = 0;
- zBuf.Append( rc.ToString() ); //sprintf( zBuf, "(%d) ", rc );
- TCL.Tcl_AppendResult( interp, zBuf, sqlite3_errmsg( db ) );
- return TCL.TCL_ERROR;
- }
- if ( pStmt != null )
- {
- if ( sqlite3TestMakePointerStr( interp, zBuf, pStmt ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_AppendResult( interp, zBuf );
- }
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- #if !SQLITE_OMIT_UTF16
- sqlite3 db=null;
- string zSql;
- string zTail = 0;
- Tcl_Obj pTail = 0;
- sqlite3_stmt pStmt = null;
- 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.Tcl_AppendResult(interp, "wrong # args: should be \"",
- TCL.Tcl_GetString(objv[0]), " DB sql bytes ?tailvar?", 0);
- return TCL.TCL_ERROR;
- }
- if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;
- zSql = TCL.Tcl_GetByteArrayFromObj(objv[2], out objlen);
- if( TCL.Tcl_GetIntFromObj(interp, objv[3], out bytes) ) return TCL.TCL_ERROR;
- rc = sqlite3_prepare16(db, zSql, bytes, pStmt, objc>=5 ? &zTail : 0);
- if( sqlite3TestErrCode(interp, db, rc) ) return TCL.TCL_ERROR;
- if( rc !=0){
- return TCL.TCL_ERROR;
- }
- if( objc>=5 ){
- if( zTail ){
- objlen = objlen - ((u8 )zTail-(u8 )zSql);
- }else{
- objlen = 0;
- }
- pTail = TCL.Tcl_NewByteArrayObj((u8 )zTail, objlen);
- TCL.Tcl_IncrRefCount(pTail);
- Tcl_ObjSetVar2(interp, objv[4], 0, pTail, 0);
- TCL.Tcl_DecrRefCount(pTail);
- }
- if( pStmt ){
- if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL.TCL_ERROR;
- }
- TCL.Tcl_AppendResult(interp, zBuf);
- #endif // * SQLITE_OMIT_UTF16 */
- return TCL.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(
- // object clientdata,
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- #if !SQLITE_OMIT_UTF16
- // sqlite3 db=null;
- // string zSql;
- // string zTail = 0;
- // Tcl_Obj pTail = 0;
- // sqlite3_stmt pStmt = null;
- // 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.Tcl_AppendResult(interp, "wrong # args: should be \"",
- // TCL.Tcl_GetString(objv[0]), " DB sql bytes ?tailvar?", 0);
- // return TCL.TCL_ERROR;
- // }
- // if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;
- // zSql = TCL.Tcl_GetByteArrayFromObj(objv[2], out objlen);
- // if( TCL.Tcl_GetIntFromObj(interp, objv[3], out bytes) ) return TCL.TCL_ERROR;
- // rc = sqlite3_prepare16_v2(db, zSql, bytes, pStmt,objc>=5 ? &zTail : 0);
- // if( sqlite3TestErrCode(interp, db, rc) ) return TCL.TCL_ERROR;
- // if( rc !=0){
- // return TCL.TCL_ERROR;
- // }
- if( objc>=5 ){
- if( zTail ){
- objlen = objlen - ((u8 )zTail-(u8 )zSql);
- }else{
- objlen = 0;
- }
- pTail = TCL.Tcl_NewByteArrayObj((u8 )zTail, objlen);
- TCL.Tcl_IncrRefCount(pTail);
- Tcl_ObjSetVar2(interp, objv[4], 0, pTail, 0);
- TCL.Tcl_DecrRefCount(pTail);
- // }
- // if( pStmt ){
- // if( sqlite3TestMakePointerStr(interp, zBuf, pStmt) ) return TCL.TCL_ERROR;
- // }
- // TCL.Tcl_AppendResult(interp, zBuf);
- #endif // * SQLITE_OMIT_UTF16 */
- // return TCL.TCL_OK;
- //}
- /*
- ** Usage: sqlite3_open filename ?options-list?
- */
- static int test_open(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- string zFilename;
- SqliteDb db = new SqliteDb();
- int rc;
- StringBuilder zBuf = new StringBuilder( 100 );
- if ( objc != 3 && objc != 2 && objc != 1 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " filename options-list" );
- return TCL.TCL_ERROR;
- }
- zFilename = objc > 1 ? TCL.Tcl_GetString( objv[1] ) : null;
- rc = sqlite3_open( zFilename, out db.db );
- if ( sqlite3TestMakePointerStr( interp, zBuf, db ) != TCL.TCL_OK )
- return TCL.TCL_ERROR;
- TCL.Tcl_AppendResult( interp, zBuf );
- return TCL.TCL_OK;
- }
- class OpenFlag
- {
- public string zFlag;
- public int flag;
- public OpenFlag( string zFlag, int flag )
- {
- this.zFlag = zFlag;
- this.flag = flag;
- }
- }
- /*
- ** Usage: sqlite3_open_v2 FILENAME FLAGS VFS
- */
- static int test_open_v2(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- string zFilename;
- string zVfs;
- int flags = 0;
- sqlite3 db = null;
- int rc;
- StringBuilder zBuf = new StringBuilder( 100 );
- int nFlag = 0;
- Tcl_Obj[] apFlag = null;
- int i;
- if ( objc != 4 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "FILENAME FLAGS VFS" );
- return TCL.TCL_ERROR;
- }
- zFilename = TCL.Tcl_GetString( objv[1] );
- zVfs = TCL.Tcl_GetString( objv[3] );
- if ( zVfs[0] == 0x00 )
- zVfs = null;
- rc = TCL.Tcl_ListObjGetElements( interp, objv[2], out nFlag, out apFlag ) ? TCL.TCL_OK : 1;
- if ( rc != TCL.TCL_OK )
- return rc;
- for ( i = 0; i < nFlag; i++ )
- {
- int iFlag;
- OpenFlag[] aFlag = new OpenFlag[] {
- new OpenFlag( "SQLITE_OPEN_READONLY", SQLITE_OPEN_READONLY ),
- new OpenFlag( "SQLITE_OPEN_READWRITE", SQLITE_OPEN_READWRITE ),
- new OpenFlag( "SQLITE_OPEN_CREATE", SQLITE_OPEN_CREATE ),
- new OpenFlag( "SQLITE_OPEN_DELETEONCLOSE", SQLITE_OPEN_DELETEONCLOSE ),
- new OpenFlag( "SQLITE_OPEN_EXCLUSIVE", SQLITE_OPEN_EXCLUSIVE ),
- new OpenFlag( "SQLITE_OPEN_AUTOPROXY", SQLITE_OPEN_AUTOPROXY ),
- new OpenFlag( "SQLITE_OPEN_MAIN_DB", SQLITE_OPEN_MAIN_DB ),
- new OpenFlag( "SQLITE_OPEN_TEMP_DB", SQLITE_OPEN_TEMP_DB ),
- new OpenFlag( "SQLITE_OPEN_TRANSIENT_DB", SQLITE_OPEN_TRANSIENT_DB ),
- new OpenFlag( "SQLITE_OPEN_MAIN_JOURNAL", SQLITE_OPEN_MAIN_JOURNAL ),
- new OpenFlag( "SQLITE_OPEN_TEMP_JOURNAL", SQLITE_OPEN_TEMP_JOURNAL ),
- new OpenFlag( "SQLITE_OPEN_SUBJOURNAL", SQLITE_OPEN_SUBJOURNAL ),
- new OpenFlag( "SQLITE_OPEN_MASTER_JOURNAL", SQLITE_OPEN_MASTER_JOURNAL ),
- new OpenFlag( "SQLITE_OPEN_NOMUTEX", SQLITE_OPEN_NOMUTEX ),
- new OpenFlag( "SQLITE_OPEN_FULLMUTEX", SQLITE_OPEN_FULLMUTEX ),
- new OpenFlag( "SQLITE_OPEN_SHAREDCACHE", SQLITE_OPEN_SHAREDCACHE ),
- new OpenFlag( "SQLITE_OPEN_PRIVATECACHE", SQLITE_OPEN_PRIVATECACHE ),
- new OpenFlag( "SQLITE_OPEN_WAL", SQLITE_OPEN_WAL ),
- new OpenFlag( "SQLITE_OPEN_URI", SQLITE_OPEN_URI ),
- new OpenFlag( null, 0 )
- };
- //rc = TCL.Tcl_GetIndexFromObjStruct( interp, apFlag[i], aFlag, sizeof( aFlag[0] ),
- // "flag", 0, ref iFlag );
- for ( iFlag = 0; iFlag < aFlag.Length && ( aFlag[iFlag].zFlag != objv[4].ToString() ); iFlag++ )
- {
- }
- if ( iFlag >= aFlag.Length )
- return TCL.TCL_ERROR;
- flags |= aFlag[iFlag].flag;
- }
- rc = sqlite3_open_v2( zFilename, out db, flags, zVfs );
- if ( sqlite3TestMakePointerStr( interp, zBuf, db ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_AppendResult( interp, zBuf, 0 );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_open16 filename options
- */
- //static int test_open16(
- // object clientdata,
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- #if !SQLITE_OMIT_UTF16
- // string zFilename;
- // sqlite3 db=null;
- // int rc;
- // char zBuf[100];
- // if( objc!=3 ){
- // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
- // TCL.Tcl_GetString(objv[0]), " filename options-list", 0);
- // return TCL.TCL_ERROR;
- // }
- // zFilename = TCL.Tcl_GetByteArrayFromObj(objv[1], 0);
- // rc = sqlite3_open16(zFilename, ref db);
- // if ( sqlite3TestMakePointerStr( interp, zBuf, db ) != TCL.TCL_OK ) return TCL.TCL_ERROR;
- // TCL.Tcl_AppendResult(interp, zBuf);
- #endif // * SQLITE_OMIT_UTF16 */
- // return TCL.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(
- // object clientdata,
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- #if !SQLITE_OMIT_COMPLETE && !SQLITE_OMIT_UTF16
- // string zBuf;
- // if( objc!=2 ){
- // TCL.Tcl_WrongNumArgs(interp, 1, objv, "<utf-16 sql>");
- // return TCL.TCL_ERROR;
- // }
- // zBuf = (char)TCL.Tcl_GetByteArrayFromObj(objv[1], 0);
- // TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(sqlite3_complete16(zBuf)));
- #endif // * SQLITE_OMIT_COMPLETE && SQLITE_OMIT_UTF16 */
- // return TCL.TCL_OK;
- //}
- /*
- ** Usage: sqlite3_step STMT
- **
- ** Advance the statement to the next row.
- */
- static int test_step(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int rc;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " STMT" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_step( pStmt );
- /* if( rc!=SQLITE_DONE && rc!=SQLITE_ROW ) return TCL.TCL_ERROR; */
- TCL.Tcl_SetResult( interp, t1ErrorName( rc ), 0 );
- return TCL.TCL_OK;
- }
- static int test_sql(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- if ( objc != 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_SetResult( interp, sqlite3_sql( pStmt ), TCL.TCL_VOLATILE );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_column_count STMT
- **
- ** Return the number of columns returned by the sql statement STMT.
- */
- static int test_column_count(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " STMT column" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_column_count( pStmt ) ) );
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int col = 0;
- int tp;
- if ( objc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " STMT column" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
- return TCL.TCL_ERROR;
- tp = sqlite3_column_type( pStmt, col );
- switch ( tp )
- {
- case SQLITE_INTEGER:
- TCL.Tcl_SetResult( interp, "INTEGER", TCL.TCL_STATIC );
- break;
- case SQLITE_NULL:
- TCL.Tcl_SetResult( interp, "NULL", TCL.TCL_STATIC );
- break;
- case SQLITE_FLOAT:
- TCL.Tcl_SetResult( interp, "FLOAT", TCL.TCL_STATIC );
- break;
- case SQLITE_TEXT:
- TCL.Tcl_SetResult( interp, "TEXT", TCL.TCL_STATIC );
- break;
- case SQLITE_BLOB:
- TCL.Tcl_SetResult( interp, "BLOB", TCL.TCL_STATIC );
- break;
- default:
- Debugger.Break();
- break;
- }
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = new sqlite3_stmt();
- int col = 0;
- i64 iVal;
- if ( objc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " STMT column" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != TCL.TCL_OK )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
- return TCL.TCL_ERROR;
- iVal = sqlite3_column_int64( pStmt, col );
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewWideIntObj( iVal ) );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_column_blob STMT column
- */
- static int test_column_blob(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = new sqlite3_stmt();
- int col = 0;
- int len;
- byte[] pBlob;
- if ( objc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " STMT column" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != TCL.TCL_OK )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
- return TCL.TCL_ERROR;
- len = sqlite3_column_bytes( pStmt, col );
- pBlob = sqlite3_column_blob( pStmt, col );
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewByteArrayObj( pBlob, len ) );
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = new sqlite3_stmt();
- int col = 0;
- double rVal;
- if ( objc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " STMT column" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != TCL.TCL_OK )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
- return TCL.TCL_ERROR;
- rVal = sqlite3_column_double( pStmt, col );
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewDoubleObj( rVal ) );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_data_count STMT
- **
- ** Return the number of columns returned by the sql statement STMT.
- */
- static int test_data_count(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " STMT column" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != TCL.TCL_OK )
- return TCL.TCL_ERROR;
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( sqlite3_data_count( pStmt ) ) );
- return TCL.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(
- object clientdata, /* Pointer to SQLite API function to be invoke */
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int col = 0;
- dxColumn xFunc;//string (*xFunc)(sqlite3_stmt*, int);
- string zRet;
- xFunc = (dxColumn)clientdata; //(string ()(sqlite3_stmt*, int))clientData;
- if ( objc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " STMT column" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
- return TCL.TCL_ERROR;
- zRet = (string)xFunc( pStmt, col );
- if ( zRet != null )
- {
- TCL.Tcl_SetResult( interp, zRet, 0 );
- }
- return TCL.TCL_OK;
- }
- static int test_global_recover(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- #if !SQLITE_OMIT_DEPRECATED
- int rc;
- if ( objc != 1 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "" );
- return TCL.TCL_ERROR;
- }
- rc = sqlite3_global_recover();
- TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
- #else
- TCL.Tcl_SetResult( interp, t1ErrorName( SQLITE_OK ), TCL.TCL_STATIC );
- #endif
- return TCL.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(
- // object clientdata, /* Pointer to SQLite API function to be invoked */
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- #if !SQLITE_OMIT_UTF16
- // sqlite3_stmt pStmt;
- // int col;
- // Tcl_Obj pRet;
- // string zName16;
- // const void *(*xFunc)(sqlite3_stmt*, int);
- xFunc = (dxColumn)clientdata; //(string ()(sqlite3_stmt*, int))clientData;
- // if( objc!=3 ){
- // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
- // TCL.Tcl_GetString(objv[0]), " STMT column", 0);
- // return TCL.TCL_ERROR;
- // }
- // if( getStmtPointer(interp, TCL.Tcl_GetString(objv[1]), pStmt) ) return TCL.TCL_ERROR;
- // if( TCL.Tcl_GetIntFromObj(interp, objv[2], out col) ) return TCL.TCL_ERROR;
- // zName16 = xFunc(pStmt, col);
- // if( zName16 ){
- int n;
- string z = zName16;
- for(n=0; z[n] || z[n+1]; n+=2){}
- pRet = TCL.Tcl_NewByteArrayObj(zName16, n+2);
- // TCL.Tcl_SetObjResult(interp, pRet);
- // }
- #endif // * SQLITE_OMIT_UTF16 */
- // return TCL.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(
- object clientdata, /* Pointer to SQLite API function to be invoked */
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_stmt pStmt = null;
- int col = 0;
- dxColumn_I xFunc;//(sqlite3_stmt*, int) ;
- xFunc = (dxColumn_I)clientdata; //(int ()(sqlite3_stmt*, int))clientData;
- if ( objc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetString( objv[0] ), " STMT column" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[2], out col ) )
- return TCL.TCL_ERROR;
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( xFunc( pStmt, col ) ) );
- return TCL.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(
- object clientdata, /* Pointer to SQLite API function to be invoked */
- Tcl_Interp interp,
- int argc,
- Tcl_Obj[] argv
- )
- {
- sqlite3 db = null;
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB MAGIC" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- if ( argv[2].ToString() == "SQLITE_MAGIC_OPEN" )
- {
- db.magic = SQLITE_MAGIC_OPEN;
- }
- else if ( argv[2].ToString() == "SQLITE_MAGIC_CLOSED" )
- {
- db.magic = SQLITE_MAGIC_CLOSED;
- }
- else if ( argv[2].ToString() == "SQLITE_MAGIC_BUSY" )
- {
- db.magic = SQLITE_MAGIC_BUSY;
- }
- else if ( argv[2].ToString() == "SQLITE_MAGIC_ERROR" )
- {
- db.magic = SQLITE_MAGIC_ERROR;
- }
- else if ( TCL.Tcl_GetInt( interp, argv[2], out db.magic ) )
- {
- return TCL.TCL_ERROR;
- }
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_interrupt DB
- **
- ** Trigger an interrupt on DB
- */
- static int test_interrupt(
- object clientdata,
- Tcl_Interp interp,
- int argc,
- Tcl_Obj[] argv )
- {
- sqlite3 db = null;
- if ( argc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0], " DB" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- sqlite3_interrupt( db );
- return TCL.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(
- // object clientdata,
- // Tcl_Interp interp,
- // int argc,
- // char **argv
- //){
- // sqlite3 db=null;
- // int i;
- // if( argc!=3 ){
- // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
- // " DB SQL", 0);
- // return TCL.TCL_ERROR;
- // }
- // if( getDbPointer(interp, argv[1].ToString(), out db) !=0) return TCL.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.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(i*4));
- // return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int argc,
- Tcl_Obj[] argv
- )
- {
- int rc;
- sqlite3 db = null;
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB function-name", null );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_create_function( db, argv[2].ToString(), -1, SQLITE_UTF8, null, null, null, null );
- TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int argc,
- Tcl_Obj[] argv
- )
- {
- int rc;
- sqlite3 db = null;
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB function-name", null );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_create_collation( db, argv[2].ToString(), SQLITE_UTF8, null, null );
- TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int argc,
- Tcl_Obj[] argv
- )
- {
- StringBuilder zBuf = new StringBuilder( 30 );
- sqlite3 db = null;
- if ( argc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- sqlite3_snprintf( 30, zBuf, "%d", sqlite3_get_autocommit( db ) );
- TCL.Tcl_AppendResult( interp, zBuf );
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int argc,
- Tcl_Obj[] argv
- )
- {
- int rc, ms = 0;
- sqlite3 db = null;
- if ( argc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"", argv[0],
- " DB" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, argv[1].ToString(), out db ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.Tcl_GetInt( interp, argv[2], out ms ) )
- return TCL.TCL_ERROR;
- rc = sqlite3_busy_timeout( db, ms );
- TCL.Tcl_AppendResult( interp, sqlite3TestErrorName( rc ) );
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- Tcl_Obj pVar;
- if ( objc != 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "VARIABLE" );
- return TCL.TCL_ERROR;
- }
- pVar = TCL.Tcl_GetVar2Ex( interp, TCL.Tcl_GetString( objv[1] ), null, (TCL.VarFlag)TCL.TCL_LEAVE_ERR_MSG );
- if ( pVar == null )
- return TCL.TCL_ERROR;
- if ( pVar.typePtr != "" )
- {
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewStringObj( pVar.typePtr, -1 ) );
- }
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- #if SQLITE_ENABLE_MEMORY_MANAGEMENT && !SQLITE_OMIT_DISKIO
- int N;
- int amt;
- if( objc!=1 && objc!=2 ){
- TCL.Tcl_WrongNumArgs(interp, 1, objv, "?N?");
- return TCL.TCL_ERROR;
- }
- if( objc==2 ){
- if( TCL.Tcl_GetIntFromObj(interp, objv[1], out N) ) return TCL.TCL_ERROR;
- }else{
- N = -1;
- }
- amt = sqlite3_release_memory(N);
- TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(amt));
- #endif
- return TCL.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(
- object clientdata,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- sqlite3_int64 amt;
- sqlite3_int64 N = -1;
- if ( objc != 1 && objc != 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "?N?" );
- return TCL.TCL_ERROR;
- }
- if ( objc == 2 )
- {
- if ( TCL.Tcl_GetWideIntFromObj( interp, objv[1], out N ) )
- return TCL.TCL_ERROR;
- }
- amt = sqlite3_soft_heap_limit64( N );
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewWideIntObj( amt ) );
- return TCL.TCL_OK;
- }
- /*
- ** Usage: sqlite3_thread_cleanup
- **
- ** Call the sqlite3_thread_cleanup API.
- */
- //static int test_thread_cleanup(
- // object clientdata,
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- // sqlite3_thread_cleanup();
- // return TCL.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(
- // object clientdata,
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- // sqlite3 db=null;
- // int i;
- // int v, *a;
- // Tcl_Obj pResult;
- // if( objc!=2 ){
- // TCL.Tcl_AppendResult(interp, "wrong # args: should be \"",
- // TCL.Tcl_GetStringFromObj(objv[0], 0), " DB", 0);
- // return TCL.TCL_ERROR;
- // }
- // if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), out db) !=0) return TCL.TCL_ERROR;
- // pResult = TCL.Tcl_NewObj();
- // for(i=0; i<db.nDb; i++){
- // if( db.aDb[i].pBt==null ){
- // v = -1;
- // }else{
- // sqlite3_mutex_enter(db.mutex);
- // a = sqlite3PagerStats(sqlite3BtreePager(db.aDb[i].pBt));
- // v = a[0];
- // sqlite3_mutex_leave(db.mutex);
- // }
- // TCL.Tcl_ListObjAppendElement(0, pResult, TCL.Tcl_NewIntObj(v));
- // }
- // TCL.Tcl_SetObjResult(interp, pResult);
- // return TCL.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(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- Tcl_Obj pTestObj;
- int working = 0;
- pTestObj = TCL.Tcl_NewWideIntObj( 1000000 * (i64)1234567890 );
- working = ( TCL.Tcl_GetString( pTestObj ) == "1234567890000000" ) ? 1 : 0;
- TCL.Tcl_DecrRefCount( ref pTestObj );
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewBooleanObj( working ) );
- return TCL.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(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- int i;
- sqlite3_vfs pMain;
- sqlite3_vfs one = new sqlite3_vfs();
- sqlite3_vfs two = new sqlite3_vfs();
- sqlite3_vfs_unregister( null ); /* 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( null );
- sqlite3_vfs_register( one, 0 );
- Debug.Assert( pMain == null || pMain == sqlite3_vfs_find( null ) );
- sqlite3_vfs_register( two, 0 );
- Debug.Assert( pMain == null || pMain == sqlite3_vfs_find( null ) );
- /* We can find a VFS by its name */
- Debug.Assert( sqlite3_vfs_find( "__one" ) == one );
- Debug.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 );
- Debug.Assert( sqlite3_vfs_find( "__one" ) == one );
- Debug.Assert( sqlite3_vfs_find( "__two" ) == two );
- Debug.Assert( sqlite3_vfs_find( null ) == one );
- sqlite3_vfs_register( two, 1 );
- Debug.Assert( sqlite3_vfs_find( "__one" ) == one );
- Debug.Assert( sqlite3_vfs_find( "__two" ) == two );
- Debug.Assert( sqlite3_vfs_find( null ) == two );
- if ( pMain != null )
- {
- sqlite3_vfs_register( pMain, 1 );
- Debug.Assert( sqlite3_vfs_find( "__one" ) == one );
- Debug.Assert( sqlite3_vfs_find( "__two" ) == two );
- Debug.Assert( sqlite3_vfs_find( null ) == pMain );
- }
- /* Unlink the default VFS. Repeat until there are no more VFSes
- ** registered.
- */
- for ( i = 0; i < apVfs.Length; i++ )
- {//sizeof(apVfs)/sizeof(apVfs[0]); i++){
- apVfs[i] = sqlite3_vfs_find( null );
- if ( apVfs[i] != null )
- {
- Debug.Assert( apVfs[i] == sqlite3_vfs_find( apVfs[i].zName ) );
- sqlite3_vfs_unregister( apVfs[i] );
- Debug.Assert( null == sqlite3_vfs_find( apVfs[i].zName ) );
- }
- }
- Debug.Assert( null == sqlite3_vfs_find( null ) );
- /* 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 );
- Debug.Assert( sqlite3_vfs_find( null ) == pMain );
- /* Un-register the main VFS again to restore an empty VFS list */
- sqlite3_vfs_unregister( pMain );
- Debug.Assert( null == sqlite3_vfs_find( null ) );
- /* Relink all VFSes in reverse order. */
- for ( i = apVfs.Length - 1; i >= 0; i-- )
- {//sizeof(apVfs)/sizeof(apVfs[0])-1; i>=0; i--){
- if ( apVfs[i] != null )
- {
- sqlite3_vfs_register( apVfs[i], 1 );
- Debug.Assert( apVfs[i] == sqlite3_vfs_find( null ) );
- Debug.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 );
- Debug.Assert( sqlite3_vfs_find( "__one" ) == null );
- Debug.Assert( sqlite3_vfs_find( "__two" ) == null );
- /* We should be left with the original default VFS back as the
- ** original */
- Debug.Assert( sqlite3_vfs_find( null ) == pMain );
- return TCL.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[] objv /* Command arguments */
- //){
- // sqlite3_vfs one;
- // one.zName = "__one";
- // if( sqlite3_vfs_find(0) ) return TCL.TCL_ERROR;
- // sqlite3_vfs_register(&one, 0);
- // if( sqlite3_vfs_find(0) ) return TCL.TCL_ERROR;
- // sqlite3_vfs_register(&one, 1);
- // if( sqlite3_vfs_find(0) ) return TCL.TCL_ERROR;
- // return TCL.TCL_OK;
- //}
- /*
- ** Saved VFSes
- */
- static sqlite3_vfs[] apVfs = new sqlite3_vfs[20];
- static int nVfs = 0;
- /*
- ** tclcmd: vfs_unregister_all
- **
- ** Unregister all VFSes.
- */
- static int vfs_unregister_all(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- int i;
- for ( i = 0; i < apVfs.Length; i++ )
- {
- apVfs[i] = sqlite3_vfs_find( null );
- if ( apVfs[i] == null )
- break;
- sqlite3_vfs_unregister( apVfs[i] );
- }
- nVfs = i;
- return TCL.TCL_OK;
- }
- /*
- ** tclcmd: vfs_reregister_all
- **
- ** Restore all VFSes that were removed using vfs_unregister_all
- */
- static int vfs_reregister_all(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- int i;
- for ( i = 0; i < nVfs; i++ )
- {
- sqlite3_vfs_register( apVfs[i], i == 0 ? 1 : 0 );
- }
- return TCL.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(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- sqlite3_int64 iArg = 0;
- sqlite3 db = null;
- int rc;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " DB" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- rc = sqlite3_file_control( db, null, 0, ref iArg );
- Debug.Assert( rc == SQLITE_NOTFOUND );
- rc = sqlite3_file_control( db, "notadatabase", SQLITE_FCNTL_LOCKSTATE, ref iArg );
- Debug.Assert( rc == SQLITE_ERROR );
- rc = sqlite3_file_control( db, "main", -1, ref iArg );
- Debug.Assert( rc == SQLITE_NOTFOUND );
- rc = sqlite3_file_control( db, "temp", -1, ref iArg );
- Debug.Assert( rc == SQLITE_NOTFOUND || rc == SQLITE_ERROR );
- return TCL.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[] objv /* Command arguments */
- )
- {
- sqlite3_int64 iArg = 0;
- sqlite3 db = null;
- int rc;
- if ( objc != 2 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " DB" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- {
- return TCL.TCL_ERROR;
- }
- rc = sqlite3_file_control( db, null, SQLITE_LAST_ERRNO, ref iArg );
- if ( rc != 0 )
- {
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( rc ) );
- return TCL.TCL_ERROR;
- }
- if ( iArg != 0 )
- {
- TCL.Tcl_AppendResult( interp, "Unexpected non-zero errno: ", iArg.ToString(), "" );
- //TCL.Tcl_GetStringFromObj(TCL.Tcl_NewIntObj(iArg), 0), " ", 0);
- return TCL.TCL_ERROR;
- }
- return TCL.TCL_OK;
- }
- /*
- ** tclcmd: file_control_chunksize_test DB DBNAME SIZE
- **
- ** This TCL command runs the sqlite3_file_control interface and
- ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and
- ** SQLITE_SET_LOCKPROXYFILE verbs.
- */
- static int file_control_chunksize_test(
- ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- int nSize = 0; /* New chunk size */
- string zDb; /* Db name ("main", "temp" etc.) */
- sqlite3 db = null; /* Database handle */
- int rc; /* file_control() return code */
- if ( objc != 4 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB DBNAME SIZE" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0
- || TCL.Tcl_GetIntFromObj( interp, objv[3], out nSize ) != 0
- )
- {
- return TCL.TCL_ERROR;
- }
- zDb = TCL.Tcl_GetString( objv[2] );
- if ( zDb == "" )
- zDb = null;
- i64 iSize = 0;
- rc = sqlite3_file_control( db, zDb, SQLITE_FCNTL_CHUNK_SIZE, ref iSize );
- nSize = (int)iSize;
- if ( rc != 0 )
- {
- TCL.Tcl_SetResult( interp, sqlite3TestErrorName( rc ), TCL.TCL_STATIC );
- return TCL.TCL_ERROR;
- }
- return TCL.TCL_OK;
- }
- /*
- ** tclcmd: file_control_sizehint_test DB DBNAME SIZE
- **
- ** This TCL command runs the sqlite3_file_control interface and
- ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and
- ** SQLITE_SET_LOCKPROXYFILE verbs.
- */
- static int file_control_sizehint_test(
- ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- sqlite3_int64 nSize = 0; /* Hinted size */
- string zDb; /* Db name ("main", "temp" etc.) */
- sqlite3 db = null; /* Database handle */
- int rc; /* file_control() return code */
- if ( objc != 4 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB DBNAME SIZE" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0
- || TCL.Tcl_GetWideIntFromObj( interp, objv[3], out nSize )
- )
- {
- return TCL.TCL_ERROR;
- }
- zDb = TCL.Tcl_GetString( objv[2] );
- if ( zDb[0] == '\0' )
- zDb = null;
- rc = sqlite3_file_control( db, zDb, SQLITE_FCNTL_SIZE_HINT, ref nSize );
- if ( rc != 0 )
- {
- TCL.Tcl_SetResult( interp, sqlite3TestErrorName( rc ), TCL.TCL_STATIC );
- return TCL.TCL_ERROR;
- }
- return TCL.TCL_OK;
- }
- /*
- ** tclcmd: file_control_lockproxy_test DB PWD
- **
- ** This TCL command runs the sqlite3_file_control interface and
- ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and
- ** SQLITE_SET_LOCKPROXYFILE verbs.
- */
- static int file_control_lockproxy_test(
- ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- sqlite3 db = null;
- string zPwd;
- int nPwd = 0;
- if ( objc != 3 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " DB PWD" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- {
- return TCL.TCL_ERROR;
- }
- zPwd = TCL.Tcl_GetStringFromObj( objv[2], out nPwd );
- //#if !(SQLITE_ENABLE_LOCKING_STYLE) && (__APPLE__)
- //{
- // char *testPath;
- // int rc;
- // char proxyPath[400];
- // if( sizeof(proxyPath)<nPwd+20 ){
- // TCL.Tcl_AppendResult(interp, "PWD too big", (void)0);
- // return TCL.TCL_ERROR;
- // }
- // sprintf(proxyPath, "%s/test.proxy", zPwd);
- // rc = sqlite3_file_control(db, NULL, SQLITE_SET_LOCKPROXYFILE, proxyPath);
- // if( rc ){
- // TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(rc));
- // return TCL.TCL_ERROR;
- // }
- // rc = sqlite3_file_control(db, NULL, SQLITE_GET_LOCKPROXYFILE, &testPath);
- // if( strncmp(proxyPath,testPath,11) ){
- // TCL.Tcl_AppendResult(interp, "Lock proxy file did not match the "
- // "previously assigned value", 0);
- // return TCL.TCL_ERROR;
- // }
- // if( rc ){
- // TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(rc));
- // return TCL.TCL_ERROR;
- // }
- // rc = sqlite3_file_control(db, NULL, SQLITE_SET_LOCKPROXYFILE, proxyPath);
- // if( rc ){
- // TCL.Tcl_SetObjResult(interp, TCL.Tcl_NewIntObj(rc));
- // return TCL.TCL_ERROR;
- // }
- //}
- //#endif
- return TCL.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[] objv /* Command arguments */
- //){
- // sqlite3_vfs pVfs;
- // Tcl_Obj pRet = TCL.Tcl_NewObj();
- // if( objc!=1 ){
- // TCL.Tcl_WrongNumArgs(interp, 1, objv, "");
- // return TCL.TCL_ERROR;
- // }
- // for(pVfs=sqlite3_vfs_find(0); pVfs!=null; pVfs=pVfs.pNext){
- // TCL.Tcl_ListObjAppendElement(interp, pRet, TCL.Tcl_NewStringObj(pVfs.zName, -1));
- // }
- // TCL.Tcl_SetObjResult(interp, pRet);
- // return TCL.TCL_OK;
- //}
- /*
- ** tclcmd: sqlite3_limit DB ID VALUE
- **
- ** This TCL command runs the sqlite3_limit interface and
- ** verifies correct operation of the same.
- */
- struct _aID
- {
- public string zName;
- public int id;
- public _aID( string zName, int id )
- {
- this.zName = zName;
- this.id = id;
- }
- }
- static int test_limit(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- sqlite3 db = null;
- int rc = 0;
- _aID[] aId = new _aID[] {
- new _aID( "SQLITE_LIMIT_LENGTH", SQLITE_LIMIT_LENGTH ),
- new _aID( "SQLITE_LIMIT_SQL_LENGTH", SQLITE_LIMIT_SQL_LENGTH ),
- new _aID( "SQLITE_LIMIT_COLUMN", SQLITE_LIMIT_COLUMN ),
- new _aID( "SQLITE_LIMIT_EXPR_DEPTH", SQLITE_LIMIT_EXPR_DEPTH ),
- new _aID( "SQLITE_LIMIT_COMPOUND_SELECT", SQLITE_LIMIT_COMPOUND_SELECT ),
- new _aID( "SQLITE_LIMIT_VDBE_OP", SQLITE_LIMIT_VDBE_OP ),
- new _aID( "SQLITE_LIMIT_FUNCTION_ARG", SQLITE_LIMIT_FUNCTION_ARG ),
- new _aID( "SQLITE_LIMIT_ATTACHED", SQLITE_LIMIT_ATTACHED ),
- new _aID( "SQLITE_LIMIT_LIKE_PATTERN_LENGTH", SQLITE_LIMIT_LIKE_PATTERN_LENGTH ),
- new _aID( "SQLITE_LIMIT_VARIABLE_NUMBER", SQLITE_LIMIT_VARIABLE_NUMBER ),
- new _aID( "SQLITE_LIMIT_TRIGGER_DEPTH", SQLITE_LIMIT_TRIGGER_DEPTH ),
- /* Out of range test cases */
- new _aID( "SQLITE_LIMIT_TOOSMALL", -1 ),
- new _aID( "SQLITE_LIMIT_TOOBIG", SQLITE_LIMIT_TRIGGER_DEPTH+1 ),
- };
- int i, id = 0;
- int val = 0;
- string zId;
- if ( objc != 4 )
- {
- TCL.Tcl_AppendResult( interp, "wrong # args: should be \"",
- TCL.Tcl_GetStringFromObj( objv[0], 0 ), " DB ID VALUE" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- zId = TCL.Tcl_GetString( objv[2] );
- for ( i = 0; i < aId.Length; i++ )
- {
- if ( zId == aId[i].zName )
- {
- id = aId[i].id;
- break;
- }
- }
- if ( i >= aId.Length )
- {
- TCL.Tcl_AppendResult( interp, "unknown limit type: ", zId, '\0' );
- return TCL.TCL_ERROR;
- }
- if ( TCL.TCL_OK != TCL.Tcl_GetIntFromObj( interp, objv[3], out val ) )
- return TCL.TCL_ERROR;
- rc = sqlite3_limit( db, id, val );
- TCL.Tcl_SetObjResult( interp, TCL.Tcl_NewIntObj( rc ) );
- return TCL.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(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- int rc = sqlite3_test_control( 9999 );
- Debug.Assert( rc == 0 );
- rc = sqlite3_test_control( -1 );
- Debug.Assert( rc == 0 );
- sqlite3_test_control( SQLITE_TESTCTRL_PRNG_SAVE );
- return TCL.TCL_OK;
- }
- /*
- ** tclcmd: restore_prng_state
- */
- static int restore_prng_state(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- sqlite3_test_control( SQLITE_TESTCTRL_PRNG_RESTORE );
- return TCL.TCL_OK;
- }
- /*
- ** tclcmd: reset_prng_state
- */
- static int reset_prng_state(
- object clientdata, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- sqlite3_test_control( SQLITE_TESTCTRL_PRNG_RESET );
- return TCL.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[] objv /* Command arguments */
- )
- {
- int nMin;
- int nMax;
- int nCurrent;
- int nRecyclable;
- Tcl_Obj pRet;
- sqlite3PcacheStats( out nCurrent, out nMax, out nMin, out nRecyclable );
- pRet = TCL.Tcl_NewObj();
- TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewStringObj( "current", -1 ) );
- TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nCurrent ) );
- TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewStringObj( "max", -1 ) );
- TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nMax ) );
- TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewStringObj( "min", -1 ) );
- TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nMin ) );
- TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewStringObj( "recyclable", -1 ) );
- TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nRecyclable ) );
- TCL.Tcl_SetObjResult( interp, pRet );
- return TCL.TCL_OK;
- }
- public class _aObjCmd
- {
- public string zName;
- public Interp.dxObjCmdProc xProc;
- public object clientData;
- public _aObjCmd( string zName, Interp.dxObjCmdProc xProc )
- {
- this.zName = zName;
- this.xProc = xProc;
- this.clientData = null;
- }
- public _aObjCmd( string zName, Interp.dxObjCmdProc xProc, object clientdata )
- {
- this.zName = zName;
- this.xProc = xProc;
- this.clientData = clientdata.GetType().Name == "Int32" && (int)clientdata == 0 ? null : clientdata;
- }
- }
- #if SQLITE_ENABLE_UNLOCK_NOTIFY
- static void test_unlock_notify_cb(void **aArg, int nArg){
- int ii;
- for(ii=0; ii<nArg; ii++){
- TCL.Tcl_EvalEx((Tcl_Interp )aArg[ii], "unlock_notify", -1, TCL.TCL_EVAL_GLOBAL);
- }
- }
- #endif //* SQLITE_ENABLE_UNLOCK_NOTIFY */
- /*
- ** tclcmd: sqlite3_unlock_notify db
- */
- #if 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[] objv /* Command arguments */
- ){
- sqlite3 db;
- int rc;
- if( objc!=2 ){
- TCL.Tcl_WrongNumArgs(interp, 1, objv, "DB");
- return TCL.TCL_ERROR;
- }
- if( getDbPointer(interp, TCL.Tcl_GetString(objv[1]), &db) ){
- return TCL.TCL_ERROR;
- }
- rc = sqlite3_unlock_notify(db, test_unlock_notify_cb, (void )interp);
- TCL.Tcl_SetResult(interp, (char )t1ErrorName(rc), TCL.TCL_STATIC);
- return TCL.TCL_OK;
- }
- #endif
- /*
- ** tclcmd: sqlite3_wal_checkpoint db ?NAME?
- */
- static int test_wal_checkpoint(
- ClientData clientData, /* Unused */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- string zDb = "";
- sqlite3 db = null;
- int rc;
- if ( objc != 3 && objc != 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB ?NAME?" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- {
- return TCL.TCL_ERROR;
- }
- if ( objc == 3 )
- {
- zDb = TCL.Tcl_GetString( objv[2] );
- }
- rc = sqlite3_wal_checkpoint( db, zDb );
- TCL.Tcl_SetResult( interp, t1ErrorName( rc ), TCL.TCL_STATIC );
- return TCL.TCL_OK;
- }
- /*
- ** tclcmd: sqlite3_wal_checkpoint_v2 db MODE ?NAME?
- **
- ** This command calls the wal_checkpoint_v2() function with the specified
- ** mode argument (passive, full or restart). If present, the database name
- ** NAME is passed as the second argument to wal_checkpoint_v2(). If it the
- ** NAME argument is not present, a NULL pointer is passed instead.
- **
- ** If wal_checkpoint_v2() returns any value other than SQLITE_BUSY or
- ** SQLITE_OK, then this command returns TCL_ERROR. The Tcl result is set
- ** to the error message obtained from sqlite3_errmsg().
- **
- ** Otherwise, this command returns a list of three integers. The first integer
- ** is 1 if SQLITE_BUSY was returned, or 0 otherwise. The following two integers
- ** are the values returned via the output paramaters by wal_checkpoint_v2() -
- ** the number of frames in the log and the number of frames in the log
- ** that have been checkpointed.
- */
- static int test_wal_checkpoint_v2(
- ClientData clientData, /* Pointer to sqlite3_enable_XXX function */
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- string zDb = "";
- sqlite3 db = null;
- int rc;
- int eMode = 0;
- int nLog = -555;
- int nCkpt = -555;
- Tcl_Obj pRet;
- string[] aMode = new string[] { "passive", "full", "restart" };
- Debug.Assert( SQLITE_CHECKPOINT_PASSIVE == 0 );
- Debug.Assert( SQLITE_CHECKPOINT_FULL == 1 );
- Debug.Assert( SQLITE_CHECKPOINT_RESTART == 2 );
- if ( objc != 3 && objc != 4 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB MODE ?NAME?" );
- return TCL.TCL_ERROR;
- }
- if ( objc == 4 )
- {
- zDb = TCL.Tcl_GetString( objv[3] );
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0
- || TCL.Tcl_GetIndexFromObj( interp, objv[2], aMode, "mode", 0, out eMode )
- )
- {
- return TCL.TCL_ERROR;
- }
- rc = sqlite3_wal_checkpoint_v2( db, zDb, eMode, out nLog, out nCkpt );
- if ( rc != SQLITE_OK && rc != SQLITE_BUSY )
- {
- TCL.Tcl_SetResult( interp, sqlite3_errmsg( db ), TCL.TCL_VOLATILE );
- return TCL.TCL_ERROR;
- }
- pRet = TCL.Tcl_NewObj();
- TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( rc == SQLITE_BUSY ? 1 : 0 ) );
- TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nLog ) );
- TCL.Tcl_ListObjAppendElement( interp, pRet, TCL.Tcl_NewIntObj( nCkpt ) );
- TCL.Tcl_SetObjResult( interp, pRet );
- return TCL.TCL_OK;
- }
- /*
- ** tclcmd: test_sqlite3_log ?SCRIPT?
- */
- struct LogCallback
- {
- public Tcl_Interp pInterp;
- public Tcl_Obj pObj;
- }
- static LogCallback logcallback = new LogCallback();
- static void xLogcallback( object unused, int err, string zMsg )
- {
- Tcl_Obj pNew = TCL.Tcl_DuplicateObj( logcallback.pObj );
- TCL.Tcl_IncrRefCount( pNew );
- TCL.Tcl_ListObjAppendElement(
- null, pNew, TCL.Tcl_NewStringObj( sqlite3TestErrorName( err ), -1 )
- );
- TCL.Tcl_ListObjAppendElement( null, pNew, TCL.Tcl_NewStringObj( zMsg, -1 ) );
- TCL.Tcl_EvalObjEx( logcallback.pInterp, pNew, TCL.TCL_EVAL_GLOBAL | TCL.TCL_EVAL_DIRECT );
- TCL.Tcl_DecrRefCount( ref pNew );
- }
- static int test_sqlite3_log(
- ClientData clientData,
- Tcl_Interp interp, /* The TCL interpreter that invoked this command */
- int objc, /* Number of arguments */
- Tcl_Obj[] objv /* Command arguments */
- )
- {
- if ( objc > 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "SCRIPT" );
- return TCL.TCL_ERROR;
- }
- if ( logcallback.pObj != null )
- {
- TCL.Tcl_DecrRefCount( ref logcallback.pObj );
- logcallback.pObj = null;
- logcallback.pInterp = null;
- sqlite3_config( SQLITE_CONFIG_LOG, 0, 0 );
- }
- if ( objc > 1 )
- {
- logcallback.pObj = objv[1];
- TCL.Tcl_IncrRefCount( logcallback.pObj );
- logcallback.pInterp = interp;
- sqlite3_config( SQLITE_CONFIG_LOG, (dxLogcallback)xLogcallback, 0 );
- }
- return TCL.TCL_OK;
- }
- /*
- ** tcl_objproc COMMANDNAME ARGS...
- **
- ** Run a TCL command using its objProc interface. Throw an error if
- ** the command has no objProc interface.
- */
- //static int runAsObjProc(
- // void * clientData,
- // Tcl_Interp interp,
- // int objc,
- // Tcl_Obj[] objv
- //){
- // TCL.Tcl_CmdInfo cmdInfo;
- // if( objc<2 ){
- // TCL.Tcl_WrongNumArgs(interp, 1, objv, "COMMAND ...");
- // return TCL.TCL_ERROR;
- // }
- // if( null==TCL.Tcl_GetCommandInfo(interp, TCL.Tcl_GetString(objv[1]), &cmdInfo) ){
- // TCL.Tcl_AppendResult(interp, "command not found: ",
- // TCL.Tcl_GetString(objv[1]), (char)0);
- // return TCL.TCL_ERROR;
- // }
- // if( cmdInfo.objProc==0 ){
- // TCL.Tcl_AppendResult(interp, "command has no objProc: ",
- // TCL.Tcl_GetString(objv[1]), (char)0);
- // return TCL.TCL_ERROR;
- // }
- // return cmdInfo.objProc(cmdInfo.objClientData, interp, objc-1, objv+1);
- //}
- /*
- ** Register commands with the TCL interpreter.
- */
- #if !SQLITE_OMIT_EXPLAIN
- /*
- ** WARNING: The following function, printExplainQueryPlan() is an exact
- ** copy of example code from eqp.in (eqp.html). If this code is modified,
- ** then the documentation copy needs to be modified as well.
- */
- /*
- ** Argument pStmt is a prepared SQL statement. This function compiles
- ** an EXPLAIN QUERY PLAN command to report on the prepared statement,
- ** and prints the report to stdout using printf().
- */
- static int printExplainQueryPlan( sqlite3_stmt pStmt )
- {
- string zSql; /* Input SQL */
- string zExplain; /* SQL with EXPLAIN QUERY PLAN prepended */
- sqlite3_stmt pExplain = null; /* Compiled EXPLAIN QUERY PLAN command */
- int rc; /* Return code from sqlite3_prepare_v2() */
- zSql = sqlite3_sql( pStmt );
- if ( zSql == null )
- return SQLITE_ERROR;
- zExplain = sqlite3_mprintf( "EXPLAIN QUERY PLAN %s", zSql );
- //if ( zExplain == null )
- // return SQLITE_NOMEM;
- rc = sqlite3_prepare_v2( sqlite3_db_handle( pStmt ), zExplain, -1, ref pExplain, 0 );
- //sqlite3_free(zExplain);
- if ( rc != SQLITE_OK )
- return rc;
- while ( SQLITE_ROW == sqlite3_step( pExplain ) )
- {
- int iSelectid = sqlite3_column_int( pExplain, 0 );
- int iOrder = sqlite3_column_int( pExplain, 1 );
- int iFrom = sqlite3_column_int( pExplain, 2 );
- string zDetail = sqlite3_column_text( pExplain, 3 );
- printf( "%d %d %d %s\n", iSelectid, iOrder, iFrom, zDetail );
- }
- return sqlite3_finalize( pExplain );
- }
- static int test_print_eqp(
- object clientData,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- int rc;
- sqlite3_stmt pStmt = null;
- if ( objc != 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "STMT" );
- return TCL.TCL_ERROR;
- }
- if ( getStmtPointer( interp, TCL.Tcl_GetString( objv[1] ), out pStmt ) != 0 )
- return TCL.TCL_ERROR;
- rc = printExplainQueryPlan( pStmt );
- /* This is needed on Windows so that a test case using this
- ** function can open a read pipe and get the output of
- ** printExplainQueryPlan() immediately.
- */
- //fflush( stdout );
- TCL.Tcl_SetResult( interp, t1ErrorName( rc ), 0 );
- return TCL.TCL_OK;
- }
- #endif //* SQLITE_OMIT_EXPLAIN */
- class Verb
- {
- public string zName;
- public int i;
- public Verb( string zName, int i )
- {
- this.zName = zName;
- this.i = i;
- }
- }
- /*
- ** sqlite3_test_control VERB ARGS...
- */
- static int test_test_control(
- object clientData,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- Verb[] aVerb = new Verb[] {
- new Verb( "SQLITE_TESTCTRL_LOCALTIME_FAULT", SQLITE_TESTCTRL_LOCALTIME_FAULT ),
- };
- int iVerb;
- int iFlag;
- int rc;
- if ( objc < 2 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "VERB ARGS..." );
- return TCL.TCL_ERROR;
- }
- //rc = TCL.Tcl_GetIndexFromObjStruct(
- // interp, objv[1], aVerb, sizeof(aVerb[0]), "VERB", 0, &iVerb
- //);
- for ( iVerb = 0; iVerb < aVerb.Length && ( aVerb[iVerb].zName != objv[1].ToString() ); iVerb++ )
- {
- }
- if ( iVerb >= aVerb.Length )
- return TCL.TCL_ERROR;
- iFlag = aVerb[iVerb].i;
- switch ( iFlag )
- {
- case SQLITE_TESTCTRL_LOCALTIME_FAULT:
- {
- bool val = false;
- if ( objc != 3 )
- {
- TCL.Tcl_WrongNumArgs( interp, 2, objv, "ONOFF" );
- return TCL.TCL_ERROR;
- }
- if ( TCL.Tcl_GetBooleanFromObj( interp, objv[2], out val ) )
- return TCL.TCL_ERROR;
- sqlite3_test_control( SQLITE_TESTCTRL_LOCALTIME_FAULT, val );
- break;
- }
- }
- TCL.Tcl_ResetResult( interp );
- return TCL.TCL_OK;
- }
- /*
- ** optimization_control DB OPT BOOLEAN
- **
- ** Enable or disable query optimizations using the sqlite3_test_control()
- ** interface. Disable if BOOLEAN is false and enable if BOOLEAN is true.
- ** OPT is the name of the optimization to be disabled.
- */
- public class _aOpt
- {
- public string zOptName;
- public int mask;
- public _aOpt( string zOptName, int mask )
- {
- this.zOptName = zOptName;
- this.mask = mask;
- }
- }
- static int optimization_control(
- object clientData,
- Tcl_Interp interp,
- int objc,
- Tcl_Obj[] objv
- )
- {
- int i;
- sqlite3 db = null;
- string zOpt;
- bool onoff = false;
- int mask = 0;
- _aOpt[] aOpt = {
- new _aOpt( "all", SQLITE_OptMask ),
- new _aOpt( "query-flattener", SQLITE_QueryFlattener ),
- new _aOpt( "column-cache", SQLITE_ColumnCache ),
- new _aOpt( "index-sort", SQLITE_IndexSort ),
- new _aOpt( "index-search", SQLITE_IndexSearch ),
- new _aOpt( "index-cover", SQLITE_IndexCover ),
- new _aOpt( "groupby-order", SQLITE_GroupByOrder ),
- new _aOpt( "factor-constants", SQLITE_FactorOutConst ),
- new _aOpt( "real-as-int", SQLITE_IdxRealAsInt ),
- };
- if ( objc != 4 )
- {
- TCL.Tcl_WrongNumArgs( interp, 1, objv, "DB OPT BOOLEAN" );
- return TCL.TCL_ERROR;
- }
- if ( getDbPointer( interp, TCL.Tcl_GetString( objv[1] ), out db ) != 0 )
- return TCL.TCL_ERROR;
- if ( TCL.Tcl_GetBooleanFromObj( interp, objv[3], out onoff ) )
- return TCL.TCL_ERROR;
- zOpt = TCL.Tcl_GetString( objv[2] );
- for ( i = 0; i < aOpt.Length; i++ )//sizeof(aOpt)/sizeof(aOpt[0]); i++)
- {
- if ( zOpt == aOpt[i].zOptName )
- {
- mask = aOpt[i].mask;
- break;
- }
- }
- if ( onoff )
- mask = ~mask;
- if ( i >= aOpt.Length )//sizeof(aOpt)/sizeof(aOpt[0]) )
- {
- TCL.Tcl_AppendResult( interp, "unknown optimization - should be one of:",
- null );
- for ( i = 0; i < aOpt.Length; i++ )//sizeof(aOpt)/sizeof(aOpt[0]); i++)
- {
- TCL.Tcl_AppendResult( interp, " ", aOpt[i].zOptName );
- }
- return TCL.TCL_ERROR;
- }
- sqlite3_test_control( SQLITE_TESTCTRL_OPTIMIZATIONS, db, mask );
- return TCL.TCL_OK;
- }
- static Var.SQLITE3_GETSET bitmask_size = new Var.SQLITE3_GETSET( "bitmask_size" );
- #if SQLITE_OS_UNIX && (__APPLE__) && SQLITE_ENABLE_LOCKING_STYLE
- extern int sqlite3_hostid_num;
- #endif
- static Var.SQLITE3_GETSET sqlite_static_bind_nbyte = new Var.SQLITE3_GETSET( "static_bind_nbyte" );
- static Var.SQLITE3_GETSET sqlite_static_bind_value = new Var.SQLITE3_GETSET( "static_bind_value" );
- public static int Sqlitetest1_Init( Tcl_Interp interp )
- {
- // extern int sqlite3_search_count;
- // extern int sqlite3_found_count;
- // extern int sqlite3_interrupt_count;
- // extern int sqlite3_sort_count;
- // extern int sqlite3_current_time;
- // extern int sqlite3_max_blobsize;
- // extern int sqlite3BtreeSharedCacheReport(void*,
- // Tcl_Interp *,int,Tcl_Obj*CONST);
- // static struct {
- // string zName;
- // TCL.Tcl_CmdProc *xProc;
- _aCmd[] aCmd = new _aCmd[] {
- new _aCmd( "db_enter", db_enter ),
- new _aCmd( "db_leave", db_leave ),
- new _aCmd( "sqlite3_mprintf_int", sqlite3_mprintf_int ),
- new _aCmd( "sqlite3_mprintf_int64", sqlite3_mprintf_int64 ),
- new _aCmd( "sqlite3_mprintf_long", sqlite3_mprintf_long ),
- new _aCmd( "sqlite3_mprintf_str", sqlite3_mprintf_str ),
- new _aCmd( "sqlite3_snprintf_str", sqlite3_snprintf_str ),
- new _aCmd( "sqlite3_mprintf_stronly", sqlite3_mprintf_stronly),
- new _aCmd( "sqlite3_mprintf_double", sqlite3_mprintf_double ),
- new _aCmd( "sqlite3_mprintf_scaled", sqlite3_mprintf_scaled ),
- new _aCmd( "sqlite3_mprintf_hexdouble", sqlite3_mprintf_hexdouble),
- new _aCmd( "sqlite3_mprintf_z_test", test_mprintf_z ),
- new _aCmd( "sqlite3_mprintf_n_test", test_mprintf_n ),
- new _aCmd( "sqlite3_snprintf_int", test_snprintf_int ),
- // new _aCmd( "sqlite3_last_insert_rowid", test_last_rowid ),
- new _aCmd( "sqlite3_exec_printf", test_exec_printf ),
- new _aCmd( "sqlite3_exec_hex", test_exec_hex ),
- new _aCmd( "sqlite3_exec", test_exec ),
- new _aCmd( "sqlite3_exec_nr", test_exec_nr ),
- #if !SQLITE_OMIT_GET_TABLE
- new _aCmd( "sqlite3_get_table_printf", test_get_table_printf ),
- #endif
- new _aCmd( "sqlite3_close", sqlite_test_close ),
- new _aCmd( "sqlite3_create_function", test_create_function ),
- new _aCmd( "sqlite3_create_aggregate", test_create_aggregate ),
- new _aCmd( "sqlite_register_test_function", test_register_func ),
- // new _aCmd( "sqlite_abort", sqlite_abort ),
- new _aCmd( "sqlite_bind", test_bind ),
- new _aCmd( "breakpoint", test_breakpoint ),
- new _aCmd( "sqlite3_key", test_key ),
- new _aCmd( "sqlite3_rekey", test_rekey ),
- new _aCmd( "sqlite_set_magic", sqlite_set_magic ),
- new _aCmd( "sqlite3_interrupt", test_interrupt ),
- new _aCmd( "sqlite_delete_function", delete_function ),
- new _aCmd( "sqlite_delete_collation", delete_collation ),
- new _aCmd( "sqlite3_get_autocommit", get_autocommit ),
- // new _aCmd( "sqlite3_stack_used", test_stack_used ),
- new _aCmd( "sqlite3_busy_timeout", test_busy_timeout ),
- // new _aCmd( "printf", test_printf ),
- // new _aCmd( "sqlite3IoTrace", test_io_trace ),
- };
- // static struct {
- // string zName;
- // Tcl_ObjCmdProc *xProc;
- // void *object;
- _aObjCmd[] aObjCmd = new _aObjCmd[]{
- new _aObjCmd( "sqlite3_connection_pointer", get_sqlite_pointer, 0 ),
- new _aObjCmd( "sqlite3_bind_int", test_bind_int, 0 ),
- new _aObjCmd( "sqlite3_bind_zeroblob", test_bind_zeroblob, 0 ),
- new _aObjCmd( "sqlite3_bind_int64", test_bind_int64, 0 ),
- new _aObjCmd( "sqlite3_bind_double", test_bind_double, 0 ),
- new _aObjCmd( "sqlite3_bind_null", test_bind_null ,0 ),
- new _aObjCmd( "sqlite3_bind_text", test_bind_text ,0 ),
- new _aObjCmd( "sqlite3_bind_text16", test_bind_text16 ,0 ),
- new _aObjCmd( "sqlite3_bind_blob", test_bind_blob ,0 ),
- new _aObjCmd( "sqlite3_bind_parameter_count", test_bind_parameter_count, 0),
- new _aObjCmd( "sqlite3_bind_parameter_name", test_bind_parameter_name, 0),
- new _aObjCmd( "sqlite3_bind_parameter_index", test_bind_parameter_index, 0),
- new _aObjCmd( "sqlite3_clear_bindings", test_clear_bindings, 0),
- new _aObjCmd( "sqlite3_sleep", test_sleep, 0),
- new _aObjCmd( "sqlite3_errcode", test_errcode ,0 ),
- new _aObjCmd( "sqlite3_extended_errcode", test_ex_errcode ,0 ),
- new _aObjCmd( "sqlite3_errmsg", test_errmsg ,0 ),
- // new _aObjCmd( "sqlite3_errmsg16", test_errmsg16 ,0 ),
- new _aObjCmd( "sqlite3_open", test_open ,0 ),
- // new _aObjCmd( "sqlite3_open16", test_open16 ,0 ),
- new _aObjCmd( "sqlite3_open_v2", test_open_v2 ,0 ),
- // new _aObjCmd( "sqlite3_complete16", test_complete16 ,0 ),
- new _aObjCmd( "sqlite3_prepare", test_prepare ,0 ),
- new _aObjCmd( "sqlite3_prepare16", test_prepare16 ,0 ),
- new _aObjCmd( "sqlite3_prepare_v2", test_prepare_v2 ,0 ),
- new _aObjCmd( "sqlite3_prepare_tkt3134", test_prepare_tkt3134, 0),
- // new _aObjCmd( "sqlite3_prepare16_v2", test_prepare16_v2 ,0 ),
- new _aObjCmd( "sqlite3_finalize", test_finalize ,0 ),
- new _aObjCmd( "sqlite3_reset", test_reset ,0 ),
- new _aObjCmd( "sqlite3_expired", test_expired ,0 ),
- new _aObjCmd( "sqlite3_transfer_bindings", test_transfer_bind ,0 ),
- new _aObjCmd( "sqlite3_changes", test_changes ,0 ),
- new _aObjCmd( "sqlite3_step", test_step ,0 ),
- // { "sqlite3_sql", test_sql ,0 },
- new _aObjCmd( "sqlite3_next_stmt", test_next_stmt ,0 ),
- new _aObjCmd( "sqlite3_stmt_readonly", test_stmt_readonly ,0 ),
- new _aObjCmd( "uses_stmt_journal", uses_stmt_journal ,0 ),
- new _aObjCmd( "sqlite3_release_memory", test_release_memory, 0),
- new _aObjCmd( "sqlite3_soft_heap_limit", test_soft_heap_limit, 0),
- // new _aObjCmd( "sqlite3_thread_cleanup", test_thread_cleanup, 0),
- // new _aObjCmd( "sqlite3_pager_refcounts", test_pager_refcounts, 0),
- // new _aObjCmd( "sqlite3_load_extension", test_load_extension, 0),
- // new _aObjCmd( "sqlite3_enable_load_extension", test_enable_load, 0),
- new _aObjCmd( "sqlite3_extended_result_codes", test_extended_result_codes, 0),
- new _aObjCmd( "sqlite3_limit", test_limit, 0),
- new _aObjCmd( "save_prng_state", save_prng_state, 0 ),
- new _aObjCmd( "restore_prng_state", restore_prng_state, 0 ),
- new _aObjCmd( "reset_prng_state", reset_prng_state, 0 ),
- new _aObjCmd( "optimization_control", optimization_control,0),
- // { "tcl_objproc", runAsObjProc, 0 },
- // /* sqlite3_column_*() API */
- new _aObjCmd( "sqlite3_column_count", test_column_count ,0 ),
- new _aObjCmd( "sqlite3_data_count", test_data_count ,0 ),
- new _aObjCmd( "sqlite3_column_type", test_column_type ,0 ),
- new _aObjCmd( "sqlite3_column_blob", test_column_blob ,0 ),
- new _aObjCmd( "sqlite3_column_double", test_column_double ,0 ),
- new _aObjCmd( "sqlite3_column_int64", test_column_int64 ,0 ),
- new _aObjCmd( "sqlite3_column_text", test_stmt_utf8, (dxColumn)sqlite3_column_text ),
- new _aObjCmd( "sqlite3_column_name", test_stmt_utf8, (dxColumn)sqlite3_column_name ),
- new _aObjCmd( "sqlite3_column_int", test_stmt_int, (dxColumn_I)sqlite3_column_int ),
- new _aObjCmd( "sqlite3_column_bytes", test_stmt_int, (dxColumn_I)sqlite3_column_bytes ),
- #if !SQLITE_OMIT_DECLTYPE
- new _aObjCmd( "sqlite3_column_decltype", test_stmt_utf8, (dxColumn) sqlite3_column_decltype ),
- #endif
- #if SQLITE_ENABLE_COLUMN_METADATA
- new _aObjCmd( "sqlite3_column_database_name", test_stmt_utf8, (dxColumn)sqlite3_column_database_name),
- new _aObjCmd( "sqlite3_column_table_name", test_stmt_utf8, (dxColumn)sqlite3_column_table_name),
- new _aObjCmd( "sqlite3_column_origin_name", test_stmt_utf8, (dxColumn)sqlite3_column_origin_name),
- #endif
- #if !SQLITE_OMIT_UTF16
- // { "sqlite3_column_bytes16", test_stmt_int, sqlite3_column_bytes16 ),
- // { "sqlite3_column_text16", test_stmt_utf16, sqlite3_column_text16 ),
- // { "sqlite3_column_decltype16", test_stmt_utf16, sqlite3_column_decltype16),
- // { "sqlite3_column_name16", test_stmt_utf16, sqlite3_column_name16 ),
- // { "add_alignment_test_collations", add_alignment_test_collations, 0 ),
- #if SQLITE_ENABLE_COLUMN_METADATA
- //{"sqlite3_column_database_name16",
- // test_stmt_utf16, sqlite3_column_database_name16),
- //{"sqlite3_column_table_name16", test_stmt_utf16, sqlite3_column_table_name16),
- //{"sqlite3_column_origin_name16", test_stmt_utf16, sqlite3_column_origin_name16),
- #endif
- #endif
- new _aObjCmd( "sqlite3_create_collation_v2", test_create_collation_v2, 0 ),
- new _aObjCmd( "sqlite3_global_recover", test_global_recover, 0 ),
- new _aObjCmd( "working_64bit_int", working_64bit_int, 0 ),
- new _aObjCmd( "vfs_unlink_test", vfs_unlink_test, 0 ),
- //{ "vfs_initfail_test", vfs_initfail_test, 0 },
- new _aObjCmd( "vfs_unregister_all", vfs_unregister_all, 0 ),
- new _aObjCmd("vfs_reregister_all", vfs_reregister_all, 0 ),
- new _aObjCmd( "file_control_test", file_control_test, 0 ),
- new _aObjCmd("file_control_lasterrno_test", file_control_lasterrno_test, 0 ),
- new _aObjCmd("file_control_lockproxy_test", file_control_lockproxy_test, 0 ),
- new _aObjCmd("file_control_chunksize_test", file_control_chunksize_test, 0 ),
- new _aObjCmd("file_control_sizehint_test", file_control_sizehint_test, 0),
- //new _aObjCmd( "sqlite3_vfs_list", vfs_list, 0 ),
- new _aObjCmd( "sqlite3_create_function_v2", test_create_function_v2, 0 ),
- // /* Functions from os.h */
- #if !SQLITE_OMIT_UTF16
- // { "add_test_collate", test_collate, 0 ),
- // { "add_test_collate_needed", test_collate_needed, 0 ),
- // { "add_test_function", test_function, 0 ),
- #endif
- new _aObjCmd( "sqlite3_test_errstr", test_errstr, 0 ),
- new _aObjCmd( "tcl_variable_type", tcl_variable_type, 0 ),
- #if !SQLITE_OMIT_SHARED_CACHE
- new _aObjCmd( "sqlite3_enable_shared_cache", test_enable_shared, 0 ),
- //{ "sqlite3_shared_cache_report", sqlite3BtreeSharedCacheReport, 0),
- #endif
- new _aObjCmd( "sqlite3_libversion_number", test_libversion_number, 0 ),
- #if SQLITE_ENABLE_COLUMN_METADATA
- new _aObjCmd( "sqlite3_table_column_metadata", test_table_column_metadata, 0 ),
- #endif
- #if !SQLITE_OMIT_INCRBLOB
- // new _aObjCmd( "sqlite3_blob_read", test_blob_read, 0 ),
- // new _aObjCmd( "sqlite3_blob_write", test_blob_write, 0 ),
- //{ "sqlite3_blob_reopen", test_blob_reopen, 0 },
- //{ "sqlite3_blob_bytes", test_blob_bytes, 0 },
- //{ "sqlite3_blob_close", test_blob_close, 0 },
- #endif
- new _aObjCmd( "pcache_stats", test_pcache_stats, 0 ),
- #if SQLITE_ENABLE_UNLOCK_NOTIFY
- { "sqlite3_unlock_notify", test_unlock_notify, 0 },
- #endif
- new _aObjCmd( "sqlite3_wal_checkpoint", test_wal_checkpoint, 0 ),
- new _aObjCmd( "sqlite3_wal_checkpoint_v2", test_wal_checkpoint_v2, 0 ),
- new _aObjCmd( "test_sqlite3_log", test_sqlite3_log, 0 ),
- #if !SQLITE_OMIT_EXPLAIN
- new _aObjCmd( "print_explain_query_plan", test_print_eqp, 0 ),
- #endif
- new _aObjCmd( "sqlite3_test_control", test_test_control ),
- };
- bitmask_size.iValue = BMS;
- int i;
- // extern int sqlite3_sync_count, sqlite3_fullsync_count;
- // extern int sqlite3_opentemp_count;
- // extern int sqlite3_like_count;
- // extern int sqlite3_xferopt_count;
- // extern int sqlite3_pager_readdb_count;
- // extern int sqlite3_pager_writedb_count;
- // extern int sqlite3_pager_writej_count;
- #if SQLITE_OS_WIN
- // extern int sqlite3_os_type;
- #endif
- #if SQLITE_DEBUG
- // extern int sqlite3WhereTrace;
- // extern int sqlite3OSTrace;
- // extern int sqlite3VdbeAddopTrace;
- // extern int sqlite3WalTrace;
- #endif
- #if SQLITE_TEST
- // extern char sqlite3_query_plan[];
- // static char *query_plan = sqlite3_query_plan;
- #if SQLITE_ENABLE_FTS3
- extern int sqlite3_fts3_enable_parentheses;
- #endif
- #endif
- for ( i = 0; i < aCmd.Length; i++ )
- {//sizeof(aCmd)/sizeof(aCmd[0]); i++){
- TCL.Tcl_CreateCommand( interp, aCmd[i].zName, aCmd[i].xProc, null, null );
- }
- for ( i = 0; i < aObjCmd.Length; i++ )
- {// i<sizeof(aObjCmd)/sizeof(aObjCmd[0]); i++){
- TCL.Tcl_CreateObjCommand( interp, aObjCmd[i].zName,
- (Interp.dxObjCmdProc)aObjCmd[i].xProc, (object)aObjCmd[i].clientData, null );
- }
- TCL.Tcl_LinkVar( interp, "sqlite_search_count",
- sqlite3_search_count, VarFlags.SQLITE3_LINK_INT );
- TCL.Tcl_LinkVar( interp, "sqlite_found_count",
- sqlite3_found_count, VarFlags.SQLITE3_LINK_INT );
- TCL.Tcl_LinkVar( interp, "sqlite_sort_count",
- sqlite3_sort_count, VarFlags.SQLITE3_LINK_INT );
- TCL.Tcl_LinkVar( interp, "sqlite3_max_blobsize",
- sqlite3_max_blobsize, VarFlags.SQLITE3_LINK_INT );
- TCL.Tcl_LinkVar( interp, "sqlite_like_count",
- sqlite3_like_count, VarFlags.SQLITE3_LINK_INT );
- TCL.Tcl_LinkVar( interp, "sqlite_interrupt_count",
- sqlite3_interrupt_count, VarFlags.SQLITE3_LINK_INT );
- TCL.Tcl_LinkVar( interp, "sqlite_open_file_count",
- sqlite3_open_file_count, VarFlags.SQLITE3_LINK_INT );
- TCL.Tcl_LinkVar( interp, "sqlite_current_time",
- sqlite3_current_time, VarFlags.SQLITE3_LINK_INT );
- #if SQLITE_OS_UNIX && (__APPLE__) && SQLITE_ENABLE_LOCKING_STYLE
- TCL.Tcl_LinkVar(interp, "sqlite_hostid_num",
- (char)&sqlite3_hostid_num, TCL.Tcl_LINK_INT);
- #endif
- TCL.Tcl_LinkVar( interp, "sqlite3_xferopt_count",
- sqlite3_xferopt_count, VarFlags.SQLITE3_LINK_INT );
- TCL.Tcl_LinkVar( interp, "sqlite3_pager_readdb_count",
- sqlite3_pager_readdb_count, VarFlags.SQLITE3_LINK_INT );
- TCL.Tcl_LinkVar( interp, "sqlite3_pager_writedb_count",
- sqlite3_pager_writedb_count, VarFlags.SQLITE3_LINK_INT );
- TCL.Tcl_LinkVar( interp, "sqlite3_pager_writej_count",
- sqlite3_pager_writej_count, VarFlags.SQLITE3_LINK_INT );
- #if !SQLITE_OMIT_UTF16
- // TCL.Tcl_LinkVar(interp, "unaligned_string_counter",
- // (char)&unaligned_string_counter, VarFlag.SQLITE3_LINK_INT);
- #endif
- #if !SQLITE_OMIT_UTF16
- // TCL.Tcl_LinkVar(interp, "sqlite_last_needed_collation",
- // (char)&pzNeededCollation, VarFlag.TCL_LINK_STRING|VarFlag.TCL_LINK_READ_ONLY);
- #endif
- #if SQLITE_OS_WIN
- // TCL.Tcl_LinkVar(interp, "sqlite_os_type",
- // (char)&sqlite3_os_type, VarFlag.SQLITE3_LINK_INT);
- #endif
- #if SQLITE_TEST
- TCL.Tcl_LinkVar( interp, "sqlite_query_plan",
- sqlite3_query_plan, VarFlags.SQLITE3_LINK_STRING | VarFlags.SQLITE3_LINK_READ_ONLY );
- #endif
- #if SQLITE_DEBUG
- // TCL.Tcl_LinkVar(interp, "sqlite_addop_trace",
- // (char)&sqlite3VdbeAddopTrace, VarFlag.SQLITE3_LINK_INT);
- // TCL.Tcl_LinkVar(interp, "sqlite_where_trace",
- // (char)&sqlite3WhereTrace, VarFlag.SQLITE3_LINK_INT);
- // TCL.Tcl_LinkVar(interp, "sqlite_os_trace",
- // (char)&sqlite3OSTrace, VarFlag.SQLITE3_LINK_INT);
- #if !SQLITE_OMIT_WAL
- TCL.Tcl_LinkVar((interp, "sqlite_wal_trace",
- (char)&sqlite3WalTrace, VarFlag.SQLITE3_LINK_INT);
- #endif
- #endif
- #if !SQLITE_OMIT_DISKIO
- TCL.Tcl_LinkVar( interp, "sqlite_opentemp_count",
- sqlite3_opentemp_count, VarFlags.SQLITE3_LINK_INT );
- #endif
- TCL.Tcl_LinkVar( interp, "sqlite_static_bind_value",
- sqlite_static_bind_value, VarFlags.SQLITE3_LINK_STRING );
- TCL.Tcl_LinkVar( interp, "sqlite_static_bind_nbyte",
- sqlite_static_bind_nbyte, VarFlags.SQLITE3_LINK_INT );
- // TCL.Tcl_LinkVar(interp, "sqlite_temp_directory",
- // (char)&sqlite3_temp_directory, VarFlag.TCL_LINK_STRING);
- TCL.Tcl_LinkVar( interp, "bitmask_size",
- bitmask_size, VarFlags.SQLITE3_LINK_INT | VarFlags.SQLITE3_LINK_READ_ONLY );
- TCL.Tcl_LinkVar( interp, "sqlite_sync_count",
- sqlite3_sync_count, VarFlags.SQLITE3_LINK_INT );
- TCL.Tcl_LinkVar( interp, "sqlite_fullsync_count",
- sqlite3_fullsync_count, VarFlags.SQLITE3_LINK_INT );
- #if (SQLITE_ENABLE_FTS3) && (SQLITE_TEST)
- TCL.Tcl_LinkVar(interp, "sqlite_fts3_enable_parentheses",
- (char)&sqlite3_fts3_enable_parentheses, TCL.Tcl_LINK_INT);
- #endif
- return TCL.TCL_OK;
- }
- }
- #endif
- }