Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(2)

Issues Search
    My Issues | Starred     Open | Closed | All

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

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

Powered by Google App Engine
This is Rietveld 408576698