4 ** The author disclaims copyright to this source code. In place of
5 ** a legal notice, here is a blessing:
7 ** May you do good and not evil.
8 ** May you find forgiveness for yourself and forgive others.
9 ** May you share freely, never taking more than you give.
11 *************************************************************************
12 ** Code for testing all sorts of SQLite interfaces. This code
13 ** is not included in the SQLite library. It is used for automated
14 ** testing of the SQLite library.
16 #include "sqliteInt.h"
22 #if defined(INCLUDE_SQLITE_TCL_H)
23 # include "sqlite_tcl.h"
31 ** This is a copy of the first part of the SqliteDb structure in
32 ** tclsqlite.c. We need it here so that the get_sqlite_pointer routine
33 ** can extract the sqlite3* pointer from an existing Tcl SQLite
41 ** Convert text generated by the "%p" conversion format back into
44 static int testHexToInt(int h
){
45 if( h
>='0' && h
<='9' ){
47 }else if( h
>='a' && h
<='f' ){
50 assert( h
>='A' && h
<='F' );
54 void *sqlite3TestTextToPtr(const char *z
){
58 if( z
[0]=='0' && z
[1]=='x' ){
63 v
= (v
<<4) + testHexToInt(*z
);
66 if( sizeof(p
)==sizeof(v
) ){
67 memcpy(&p
, &v
, sizeof(p
));
69 assert( sizeof(p
)==sizeof(v2
) );
71 memcpy(&p
, &v2
, sizeof(p
));
78 ** A TCL command that returns the address of the sqlite* pointer
79 ** for an sqlite connection instance. Bad things happen if the
80 ** input is not an sqlite connection.
82 static int SQLITE_TCLAPI
get_sqlite_pointer(
92 Tcl_WrongNumArgs(interp
, 1, objv
, "SQLITE-CONNECTION");
95 if( !Tcl_GetCommandInfo(interp
, Tcl_GetString(objv
[1]), &cmdInfo
) ){
96 Tcl_AppendResult(interp
, "command not found: ",
97 Tcl_GetString(objv
[1]), (char*)0);
100 p
= (struct SqliteDb
*)cmdInfo
.objClientData
;
101 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "%p", p
->db
);
102 Tcl_AppendResult(interp
, zBuf
, 0);
107 ** Decode a pointer to an sqlite3 object.
109 int getDbPointer(Tcl_Interp
*interp
, const char *zA
, sqlite3
**ppDb
){
112 if( Tcl_GetCommandInfo(interp
, zA
, &cmdInfo
) ){
113 p
= (struct SqliteDb
*)cmdInfo
.objClientData
;
116 *ppDb
= (sqlite3
*)sqlite3TestTextToPtr(zA
);
123 ** Decode a Win32 HANDLE object.
125 int getWin32Handle(Tcl_Interp
*interp
, const char *zA
, LPHANDLE phFile
){
126 *phFile
= (HANDLE
)sqlite3TestTextToPtr(zA
);
131 extern const char *sqlite3ErrName(int);
132 #define t1ErrorName sqlite3ErrName
135 ** Convert an sqlite3_stmt* into an sqlite3*. This depends on the
136 ** fact that the sqlite3* is the first field in the Vdbe structure.
138 #define StmtToDb(X) sqlite3_db_handle(X)
141 ** Check a return value to make sure it agrees with the results
142 ** from sqlite3_errcode.
144 int sqlite3TestErrCode(Tcl_Interp
*interp
, sqlite3
*db
, int rc
){
145 if( sqlite3_threadsafe()==0 && rc
!=SQLITE_MISUSE
&& rc
!=SQLITE_OK
146 && sqlite3_errcode(db
)!=rc
){
148 int r2
= sqlite3_errcode(db
);
149 sqlite3_snprintf(sizeof(zBuf
), zBuf
,
150 "error code %s (%d) does not match sqlite3_errcode %s (%d)",
151 t1ErrorName(rc
), rc
, t1ErrorName(r2
), r2
);
152 Tcl_ResetResult(interp
);
153 Tcl_AppendResult(interp
, zBuf
, 0);
160 ** Decode a pointer to an sqlite3_stmt object.
162 static int getStmtPointer(
165 sqlite3_stmt
**ppStmt
167 *ppStmt
= (sqlite3_stmt
*)sqlite3TestTextToPtr(zArg
);
172 ** Generate a text representation of a pointer that can be understood
173 ** by the getDbPointer and getVmPointer routines above.
175 ** The problem is, on some machines (Solaris) if you do a printf with
176 ** "%p" you cannot turn around and do a scanf with the same "%p" and
177 ** get your pointer back. You have to prepend a "0x" before it will
178 ** work. Or at least that is what is reported to me (drh). But this
179 ** behavior varies from machine to machine. The solution used her is
180 ** to test the string right after it is generated to see if it can be
181 ** understood by scanf, and if not, try prepending an "0x" to see if
182 ** that helps. If nothing works, a fatal error is generated.
184 int sqlite3TestMakePointerStr(Tcl_Interp
*interp
, char *zPtr
, void *p
){
185 sqlite3_snprintf(100, zPtr
, "%p", p
);
190 ** The callback routine for sqlite3_exec_printf().
192 static int exec_printf_cb(void *pArg
, int argc
, char **argv
, char **name
){
193 Tcl_DString
*str
= (Tcl_DString
*)pArg
;
196 if( Tcl_DStringLength(str
)==0 ){
197 for(i
=0; i
<argc
; i
++){
198 Tcl_DStringAppendElement(str
, name
[i
] ? name
[i
] : "NULL");
201 for(i
=0; i
<argc
; i
++){
202 Tcl_DStringAppendElement(str
, argv
[i
] ? argv
[i
] : "NULL");
208 ** The I/O tracing callback.
210 #if !defined(SQLITE_OMIT_TRACE) && defined(SQLITE_ENABLE_IOTRACE)
211 static FILE *iotrace_file
= 0;
212 static void io_trace_callback(const char *zFormat
, ...){
214 va_start(ap
, zFormat
);
215 vfprintf(iotrace_file
, zFormat
, ap
);
217 fflush(iotrace_file
);
222 ** Usage: io_trace FILENAME
224 ** Turn I/O tracing on or off. If FILENAME is not an empty string,
225 ** I/O tracing begins going into FILENAME. If FILENAME is an empty
226 ** string, I/O tracing is turned off.
228 static int SQLITE_TCLAPI
test_io_trace(
230 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
231 int argc
, /* Number of arguments */
232 char **argv
/* Text of each argument */
234 #if !defined(SQLITE_OMIT_TRACE) && defined(SQLITE_ENABLE_IOTRACE)
236 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
241 if( iotrace_file
!=stdout
&& iotrace_file
!=stderr
){
242 fclose(iotrace_file
);
248 if( strcmp(argv
[1],"stdout")==0 ){
249 iotrace_file
= stdout
;
250 }else if( strcmp(argv
[1],"stderr")==0 ){
251 iotrace_file
= stderr
;
253 iotrace_file
= fopen(argv
[1], "w");
255 sqlite3IoTrace
= io_trace_callback
;
262 ** Usage: clang_sanitize_address
264 ** Returns true if the program was compiled using clang with the
265 ** -fsanitize=address switch on the command line. False otherwise.
267 ** Also return true if the OMIT_MISUSE environment variable exists.
269 static int SQLITE_TCLAPI
clang_sanitize_address(
271 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
272 int argc
, /* Number of arguments */
273 char **argv
/* Text of each argument */
276 #if defined(__has_feature)
277 # if __has_feature(address_sanitizer)
281 #ifdef __SANITIZE_ADDRESS__
284 if( res
==0 && getenv("OMIT_MISUSE")!=0 ) res
= 1;
285 Tcl_SetObjResult(interp
, Tcl_NewIntObj(res
));
290 ** Usage: sqlite3_exec_printf DB FORMAT STRING
292 ** Invoke the sqlite3_exec_printf() interface using the open database
293 ** DB. The SQL is the string FORMAT. The format string should contain
294 ** one %s or %q. STRING is the value inserted into %s or %q.
296 static int SQLITE_TCLAPI
test_exec_printf(
298 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
299 int argc
, /* Number of arguments */
300 char **argv
/* Text of each argument */
309 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
310 " DB FORMAT STRING", 0);
313 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
314 Tcl_DStringInit(&str
);
315 zSql
= sqlite3_mprintf(argv
[2], argv
[3]);
316 rc
= sqlite3_exec(db
, zSql
, exec_printf_cb
, &str
, &zErr
);
318 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "%d", rc
);
319 Tcl_AppendElement(interp
, zBuf
);
320 Tcl_AppendElement(interp
, rc
==SQLITE_OK
? Tcl_DStringValue(&str
) : zErr
);
321 Tcl_DStringFree(&str
);
322 if( zErr
) sqlite3_free(zErr
);
323 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
328 ** Usage: sqlite3_exec_hex DB HEX
330 ** Invoke the sqlite3_exec() on a string that is obtained by translating
331 ** HEX into ASCII. Most characters are translated as is. %HH becomes
334 static int SQLITE_TCLAPI
test_exec_hex(
336 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
337 int argc
, /* Number of arguments */
338 char **argv
/* Text of each argument */
348 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
352 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
354 for(i
=j
=0; i
<(sizeof(zSql
)-1) && zHex
[j
]; i
++, j
++){
355 if( zHex
[j
]=='%' && zHex
[j
+2] && zHex
[j
+2] ){
356 zSql
[i
] = (testHexToInt(zHex
[j
+1])<<4) + testHexToInt(zHex
[j
+2]);
363 Tcl_DStringInit(&str
);
364 rc
= sqlite3_exec(db
, zSql
, exec_printf_cb
, &str
, &zErr
);
365 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "%d", rc
);
366 Tcl_AppendElement(interp
, zBuf
);
367 Tcl_AppendElement(interp
, rc
==SQLITE_OK
? Tcl_DStringValue(&str
) : zErr
);
368 Tcl_DStringFree(&str
);
369 if( zErr
) sqlite3_free(zErr
);
370 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
375 ** Usage: db_enter DB
378 ** Enter or leave the mutex on a database connection.
380 static int SQLITE_TCLAPI
db_enter(
382 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
383 int argc
, /* Number of arguments */
384 char **argv
/* Text of each argument */
388 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
392 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
393 sqlite3_mutex_enter(db
->mutex
);
396 static int SQLITE_TCLAPI
db_leave(
398 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
399 int argc
, /* Number of arguments */
400 char **argv
/* Text of each argument */
404 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
408 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
409 sqlite3_mutex_leave(db
->mutex
);
414 ** Usage: sqlite3_exec DB SQL
416 ** Invoke the sqlite3_exec interface using the open database DB
418 static int SQLITE_TCLAPI
test_exec(
420 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
421 int argc
, /* Number of arguments */
422 char **argv
/* Text of each argument */
432 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
436 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
437 Tcl_DStringInit(&str
);
438 zSql
= sqlite3_mprintf("%s", argv
[2]);
439 for(i
=j
=0; zSql
[i
];){
441 zSql
[j
++] = (testHexToInt(zSql
[i
+1])<<4) + testHexToInt(zSql
[i
+2]);
444 zSql
[j
++] = zSql
[i
++];
448 rc
= sqlite3_exec(db
, zSql
, exec_printf_cb
, &str
, &zErr
);
450 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "%d", rc
);
451 Tcl_AppendElement(interp
, zBuf
);
452 Tcl_AppendElement(interp
, rc
==SQLITE_OK
? Tcl_DStringValue(&str
) : zErr
);
453 Tcl_DStringFree(&str
);
454 if( zErr
) sqlite3_free(zErr
);
455 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
460 ** Usage: sqlite3_exec_nr DB SQL
462 ** Invoke the sqlite3_exec interface using the open database DB. Discard
465 static int SQLITE_TCLAPI
test_exec_nr(
467 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
468 int argc
, /* Number of arguments */
469 char **argv
/* Text of each argument */
475 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
479 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
480 rc
= sqlite3_exec(db
, argv
[2], 0, 0, &zErr
);
481 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
486 ** Usage: sqlite3_mprintf_z_test SEPARATOR ARG0 ARG1 ...
488 ** Test the %z format of sqlite_mprintf(). Use multiple mprintf() calls to
489 ** concatenate arg0 through argn using separator as the separator.
490 ** Return the result.
492 static int SQLITE_TCLAPI
test_mprintf_z(
494 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
495 int argc
, /* Number of arguments */
496 char **argv
/* Text of each argument */
501 for(i
=2; i
<argc
&& (i
==2 || zResult
); i
++){
502 zResult
= sqlite3_mprintf("%z%s%s", zResult
, argv
[1], argv
[i
]);
504 Tcl_AppendResult(interp
, zResult
, 0);
505 sqlite3_free(zResult
);
510 ** Usage: sqlite3_mprintf_n_test STRING
512 ** Test the %n format of sqlite_mprintf(). Return the length of the
515 static int SQLITE_TCLAPI
test_mprintf_n(
517 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
518 int argc
, /* Number of arguments */
519 char **argv
/* Text of each argument */
523 zStr
= sqlite3_mprintf("%s%n", argv
[1], &n
);
525 Tcl_SetObjResult(interp
, Tcl_NewIntObj(n
));
530 ** Usage: sqlite3_snprintf_int SIZE FORMAT INT
532 ** Test the of sqlite3_snprintf() routine. SIZE is the size of the
533 ** output buffer in bytes. The maximum size is 100. FORMAT is the
534 ** format string. INT is a single integer argument. The FORMAT
535 ** string must require no more than this one integer argument. If
536 ** You pass in a format string that requires more than one argument,
537 ** bad things will happen.
539 static int SQLITE_TCLAPI
test_snprintf_int(
541 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
542 int argc
, /* Number of arguments */
543 char **argv
/* Text of each argument */
546 int n
= atoi(argv
[1]);
547 const char *zFormat
= argv
[2];
548 int a1
= atoi(argv
[3]);
549 if( n
>sizeof(zStr
) ) n
= sizeof(zStr
);
550 sqlite3_snprintf(sizeof(zStr
), zStr
, "abcdefghijklmnopqrstuvwxyz");
551 sqlite3_snprintf(n
, zStr
, zFormat
, a1
);
552 Tcl_AppendResult(interp
, zStr
, 0);
556 #ifndef SQLITE_OMIT_GET_TABLE
559 ** Usage: sqlite3_get_table_printf DB FORMAT STRING ?--no-counts?
561 ** Invoke the sqlite3_get_table_printf() interface using the open database
562 ** DB. The SQL is the string FORMAT. The format string should contain
563 ** one %s or %q. STRING is the value inserted into %s or %q.
565 static int SQLITE_TCLAPI
test_get_table_printf(
567 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
568 int argc
, /* Number of arguments */
569 char **argv
/* Text of each argument */
575 int nRow
= 0, nCol
= 0;
582 if( Tcl_GetInt(interp
, argv
[4], &resCount
) ) return TCL_ERROR
;
584 if( argc
!=4 && argc
!=5 ){
585 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
586 " DB FORMAT STRING ?COUNT?", 0);
589 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
590 Tcl_DStringInit(&str
);
591 zSql
= sqlite3_mprintf(argv
[2],argv
[3]);
593 rc
= sqlite3_get_table(db
, zSql
, &aResult
, 0, 0, &zErr
);
595 rc
= sqlite3_get_table(db
, zSql
, &aResult
, &nRow
, &nCol
, &zErr
);
596 resCount
= (nRow
+1)*nCol
;
599 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "%d", rc
);
600 Tcl_AppendElement(interp
, zBuf
);
603 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "%d", nRow
);
604 Tcl_AppendElement(interp
, zBuf
);
605 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "%d", nCol
);
606 Tcl_AppendElement(interp
, zBuf
);
608 for(i
=0; i
<resCount
; i
++){
609 Tcl_AppendElement(interp
, aResult
[i
] ? aResult
[i
] : "NULL");
612 Tcl_AppendElement(interp
, zErr
);
614 sqlite3_free_table(aResult
);
615 if( zErr
) sqlite3_free(zErr
);
616 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
620 #endif /* SQLITE_OMIT_GET_TABLE */
624 ** Usage: sqlite3_last_insert_rowid DB
626 ** Returns the integer ROWID of the most recent insert.
628 static int SQLITE_TCLAPI
test_last_rowid(
630 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
631 int argc
, /* Number of arguments */
632 char **argv
/* Text of each argument */
638 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0], " DB\"", 0);
641 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
642 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "%lld", sqlite3_last_insert_rowid(db
));
643 Tcl_AppendResult(interp
, zBuf
, 0);
648 ** Usage: sqlite3_key DB KEY
650 ** Set the codec key.
652 static int SQLITE_TCLAPI
test_key(
654 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
655 int argc
, /* Number of arguments */
656 char **argv
/* Text of each argument */
658 #if defined(SQLITE_HAS_CODEC) && !defined(SQLITE_OMIT_CODEC_FROM_TCL)
663 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
667 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
670 sqlite3_key(db
, zKey
, nKey
);
676 ** Usage: sqlite3_rekey DB KEY
678 ** Change the codec key.
680 static int SQLITE_TCLAPI
test_rekey(
682 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
683 int argc
, /* Number of arguments */
684 char **argv
/* Text of each argument */
686 #ifdef SQLITE_HAS_CODEC
691 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
695 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
698 sqlite3_rekey(db
, zKey
, nKey
);
704 ** Usage: sqlite3_close DB
706 ** Closes the database opened by sqlite3_open.
708 static int SQLITE_TCLAPI
sqlite_test_close(
710 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
711 int argc
, /* Number of arguments */
712 char **argv
/* Text of each argument */
717 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
721 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
722 rc
= sqlite3_close(db
);
723 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
728 ** Usage: sqlite3_close_v2 DB
730 ** Closes the database opened by sqlite3_open.
732 static int SQLITE_TCLAPI
sqlite_test_close_v2(
734 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
735 int argc
, /* Number of arguments */
736 char **argv
/* Text of each argument */
741 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
745 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
746 rc
= sqlite3_close_v2(db
);
747 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
752 ** Implementation of the x_coalesce() function.
753 ** Return the first argument non-NULL argument.
755 static void t1_ifnullFunc(
756 sqlite3_context
*context
,
761 for(i
=0; i
<argc
; i
++){
762 if( SQLITE_NULL
!=sqlite3_value_type(argv
[i
]) ){
763 int n
= sqlite3_value_bytes(argv
[i
]);
764 sqlite3_result_text(context
, (char*)sqlite3_value_text(argv
[i
]),
765 n
, SQLITE_TRANSIENT
);
772 ** These are test functions. hex8() interprets its argument as
773 ** UTF8 and returns a hex encoding. hex16le() interprets its argument
774 ** as UTF16le and returns a hex encoding.
776 static void hex8Func(sqlite3_context
*p
, int argc
, sqlite3_value
**argv
){
777 const unsigned char *z
;
780 z
= sqlite3_value_text(argv
[0]);
781 for(i
=0; i
<sizeof(zBuf
)/2 - 2 && z
[i
]; i
++){
782 sqlite3_snprintf(sizeof(zBuf
)-i
*2, &zBuf
[i
*2], "%02x", z
[i
]);
785 sqlite3_result_text(p
, (char*)zBuf
, -1, SQLITE_TRANSIENT
);
787 #ifndef SQLITE_OMIT_UTF16
788 static void hex16Func(sqlite3_context
*p
, int argc
, sqlite3_value
**argv
){
789 const unsigned short int *z
;
792 z
= sqlite3_value_text16(argv
[0]);
793 for(i
=0; i
<sizeof(zBuf
)/4 - 4 && z
[i
]; i
++){
794 sqlite3_snprintf(sizeof(zBuf
)-i
*4, &zBuf
[i
*4],"%04x", z
[i
]&0xff);
797 sqlite3_result_text(p
, (char*)zBuf
, -1, SQLITE_TRANSIENT
);
802 ** A structure into which to accumulate text.
805 int nAlloc
; /* Space allocated */
806 int nUsed
; /* Space used */
807 char *z
; /* The space */
811 ** Append text to a dstr
813 static void dstrAppend(struct dstr
*p
, const char *z
, int divider
){
814 int n
= (int)strlen(z
);
815 if( p
->nUsed
+ n
+ 2 > p
->nAlloc
){
817 p
->nAlloc
= p
->nAlloc
*2 + n
+ 200;
818 zNew
= sqlite3_realloc(p
->z
, p
->nAlloc
);
821 memset(p
, 0, sizeof(*p
));
826 if( divider
&& p
->nUsed
>0 ){
827 p
->z
[p
->nUsed
++] = divider
;
829 memcpy(&p
->z
[p
->nUsed
], z
, n
+1);
834 ** Invoked for each callback from sqlite3ExecFunc
836 static int execFuncCallback(void *pData
, int argc
, char **argv
, char **NotUsed
){
837 struct dstr
*p
= (struct dstr
*)pData
;
839 for(i
=0; i
<argc
; i
++){
841 dstrAppend(p
, "NULL", ' ');
843 dstrAppend(p
, argv
[i
], ' ');
850 ** Implementation of the x_sqlite_exec() function. This function takes
851 ** a single argument and attempts to execute that argument as SQL code.
852 ** This is illegal and should set the SQLITE_MISUSE flag on the database.
854 ** 2004-Jan-07: We have changed this to make it legal to call sqlite3_exec()
855 ** from within a function call.
857 ** This routine simulates the effect of having two threads attempt to
858 ** use the same database at the same time.
860 static void sqlite3ExecFunc(
861 sqlite3_context
*context
,
866 memset(&x
, 0, sizeof(x
));
867 (void)sqlite3_exec((sqlite3
*)sqlite3_user_data(context
),
868 (char*)sqlite3_value_text(argv
[0]),
869 execFuncCallback
, &x
, 0);
870 sqlite3_result_text(context
, x
.z
, x
.nUsed
, SQLITE_TRANSIENT
);
875 ** Implementation of tkt2213func(), a scalar function that takes exactly
876 ** one argument. It has two interesting features:
878 ** * It calls sqlite3_value_text() 3 times on the argument sqlite3_value*.
879 ** If the three pointers returned are not the same an SQL error is raised.
881 ** * Otherwise it returns a copy of the text representation of its
882 ** argument in such a way as the VDBE representation is a Mem* cell
883 ** with the MEM_Term flag clear.
885 ** Ticket #2213 can therefore be tested by evaluating the following
888 ** tkt2213func(tkt2213func('a string'));
890 static void tkt2213Function(
891 sqlite3_context
*context
,
896 unsigned char const *zText1
;
897 unsigned char const *zText2
;
898 unsigned char const *zText3
;
900 nText
= sqlite3_value_bytes(argv
[0]);
901 zText1
= sqlite3_value_text(argv
[0]);
902 zText2
= sqlite3_value_text(argv
[0]);
903 zText3
= sqlite3_value_text(argv
[0]);
905 if( zText1
!=zText2
|| zText2
!=zText3
){
906 sqlite3_result_error(context
, "tkt2213 is not fixed", -1);
908 char *zCopy
= (char *)sqlite3_malloc(nText
);
909 memcpy(zCopy
, zText1
, nText
);
910 sqlite3_result_text(context
, zCopy
, nText
, sqlite3_free
);
915 ** The following SQL function takes 4 arguments. The 2nd and
916 ** 4th argument must be one of these strings: 'text', 'text16',
917 ** or 'blob' corresponding to API functions
919 ** sqlite3_value_text()
920 ** sqlite3_value_text16()
921 ** sqlite3_value_blob()
923 ** The third argument is a string, either 'bytes' or 'bytes16' or 'noop',
924 ** corresponding to APIs:
926 ** sqlite3_value_bytes()
927 ** sqlite3_value_bytes16()
930 ** The APIs designated by the 2nd through 4th arguments are applied
931 ** to the first argument in order. If the pointers returned by the
932 ** second and fourth are different, this routine returns 1. Otherwise,
933 ** this routine returns 0.
935 ** This function is used to test to see when returned pointers from
936 ** the _text(), _text16() and _blob() APIs become invalidated.
938 static void ptrChngFunction(
939 sqlite3_context
*context
,
945 if( argc
!=4 ) return;
946 zCmd
= (const char*)sqlite3_value_text(argv
[1]);
947 if( zCmd
==0 ) return;
948 if( strcmp(zCmd
,"text")==0 ){
949 p1
= (const void*)sqlite3_value_text(argv
[0]);
950 #ifndef SQLITE_OMIT_UTF16
951 }else if( strcmp(zCmd
, "text16")==0 ){
952 p1
= (const void*)sqlite3_value_text16(argv
[0]);
954 }else if( strcmp(zCmd
, "blob")==0 ){
955 p1
= (const void*)sqlite3_value_blob(argv
[0]);
959 zCmd
= (const char*)sqlite3_value_text(argv
[2]);
960 if( zCmd
==0 ) return;
961 if( strcmp(zCmd
,"bytes")==0 ){
962 sqlite3_value_bytes(argv
[0]);
963 #ifndef SQLITE_OMIT_UTF16
964 }else if( strcmp(zCmd
, "bytes16")==0 ){
965 sqlite3_value_bytes16(argv
[0]);
967 }else if( strcmp(zCmd
, "noop")==0 ){
972 zCmd
= (const char*)sqlite3_value_text(argv
[3]);
973 if( zCmd
==0 ) return;
974 if( strcmp(zCmd
,"text")==0 ){
975 p2
= (const void*)sqlite3_value_text(argv
[0]);
976 #ifndef SQLITE_OMIT_UTF16
977 }else if( strcmp(zCmd
, "text16")==0 ){
978 p2
= (const void*)sqlite3_value_text16(argv
[0]);
980 }else if( strcmp(zCmd
, "blob")==0 ){
981 p2
= (const void*)sqlite3_value_blob(argv
[0]);
985 sqlite3_result_int(context
, p1
!=p2
);
989 ** This SQL function returns a different answer each time it is called, even if
990 ** the arguments are the same.
992 static void nondeterministicFunction(
993 sqlite3_context
*context
,
998 sqlite3_result_int(context
, cnt
++);
1002 ** Usage: sqlite3_create_function DB
1004 ** Call the sqlite3_create_function API on the given database in order
1005 ** to create a function named "x_coalesce". This function does the same thing
1006 ** as the "coalesce" function. This function also registers an SQL function
1007 ** named "x_sqlite_exec" that invokes sqlite3_exec(). Invoking sqlite3_exec()
1008 ** in this way is illegal recursion and should raise an SQLITE_MISUSE error.
1009 ** The effect is similar to trying to use the same database connection from
1010 ** two threads at the same time.
1012 ** The original motivation for this routine was to be able to call the
1013 ** sqlite3_create_function function while a query is in progress in order
1014 ** to test the SQLITE_MISUSE detection logic.
1016 static int SQLITE_TCLAPI
test_create_function(
1018 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1019 int argc
, /* Number of arguments */
1020 char **argv
/* Text of each argument */
1026 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1030 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
1031 rc
= sqlite3_create_function(db
, "x_coalesce", -1, SQLITE_UTF8
, 0,
1032 t1_ifnullFunc
, 0, 0);
1033 if( rc
==SQLITE_OK
){
1034 rc
= sqlite3_create_function(db
, "hex8", 1, SQLITE_UTF8
| SQLITE_DETERMINISTIC
,
1037 #ifndef SQLITE_OMIT_UTF16
1038 if( rc
==SQLITE_OK
){
1039 rc
= sqlite3_create_function(db
, "hex16", 1, SQLITE_UTF16
| SQLITE_DETERMINISTIC
,
1040 0, hex16Func
, 0, 0);
1043 if( rc
==SQLITE_OK
){
1044 rc
= sqlite3_create_function(db
, "tkt2213func", 1, SQLITE_ANY
, 0,
1045 tkt2213Function
, 0, 0);
1047 if( rc
==SQLITE_OK
){
1048 rc
= sqlite3_create_function(db
, "pointer_change", 4, SQLITE_ANY
, 0,
1049 ptrChngFunction
, 0, 0);
1052 /* Functions counter1() and counter2() have the same implementation - they
1053 ** both return an ascending integer with each call. But counter1() is marked
1054 ** as non-deterministic and counter2() is marked as deterministic.
1056 if( rc
==SQLITE_OK
){
1057 rc
= sqlite3_create_function(db
, "counter1", -1, SQLITE_UTF8
,
1058 0, nondeterministicFunction
, 0, 0);
1060 if( rc
==SQLITE_OK
){
1061 rc
= sqlite3_create_function(db
, "counter2", -1, SQLITE_UTF8
|SQLITE_DETERMINISTIC
,
1062 0, nondeterministicFunction
, 0, 0);
1065 #ifndef SQLITE_OMIT_UTF16
1066 /* Use the sqlite3_create_function16() API here. Mainly for fun, but also
1067 ** because it is not tested anywhere else. */
1068 if( rc
==SQLITE_OK
){
1070 sqlite3_value
*pVal
;
1071 sqlite3_mutex_enter(db
->mutex
);
1072 pVal
= sqlite3ValueNew(db
);
1073 sqlite3ValueSetStr(pVal
, -1, "x_sqlite_exec", SQLITE_UTF8
, SQLITE_STATIC
);
1074 zUtf16
= sqlite3ValueText(pVal
, SQLITE_UTF16NATIVE
);
1075 if( db
->mallocFailed
){
1078 rc
= sqlite3_create_function16(db
, zUtf16
,
1079 1, SQLITE_UTF16
, db
, sqlite3ExecFunc
, 0, 0);
1081 sqlite3ValueFree(pVal
);
1082 sqlite3_mutex_leave(db
->mutex
);
1086 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
1087 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), 0);
1092 ** Routines to implement the x_count() aggregate function.
1094 ** x_count() counts the number of non-null arguments. But there are
1095 ** some twists for testing purposes.
1097 ** If the argument to x_count() is 40 then a UTF-8 error is reported
1098 ** on the step function. If x_count(41) is seen, then a UTF-16 error
1099 ** is reported on the step function. If the total count is 42, then
1100 ** a UTF-8 error is reported on the finalize function.
1102 typedef struct t1CountCtx t1CountCtx
;
1106 static void t1CountStep(
1107 sqlite3_context
*context
,
1109 sqlite3_value
**argv
1112 p
= sqlite3_aggregate_context(context
, sizeof(*p
));
1113 if( (argc
==0 || SQLITE_NULL
!=sqlite3_value_type(argv
[0]) ) && p
){
1117 int v
= sqlite3_value_int(argv
[0]);
1119 sqlite3_result_error(context
, "value of 40 handed to x_count", -1);
1120 #ifndef SQLITE_OMIT_UTF16
1122 const char zUtf16ErrMsg
[] = { 0, 0x61, 0, 0x62, 0, 0x63, 0, 0, 0};
1123 sqlite3_result_error16(context
, &zUtf16ErrMsg
[1-SQLITE_BIGENDIAN
], -1);
1128 static void t1CountFinalize(sqlite3_context
*context
){
1130 p
= sqlite3_aggregate_context(context
, sizeof(*p
));
1133 sqlite3_result_error(context
, "x_count totals to 42", -1);
1135 sqlite3_result_int(context
, p
? p
->n
: 0);
1140 #ifndef SQLITE_OMIT_DEPRECATED
1141 static void legacyCountStep(
1142 sqlite3_context
*context
,
1144 sqlite3_value
**argv
1149 static void legacyCountFinalize(sqlite3_context
*context
){
1150 sqlite3_result_int(context
, sqlite3_aggregate_count(context
));
1155 ** Usage: sqlite3_create_aggregate DB
1157 ** Call the sqlite3_create_function API on the given database in order
1158 ** to create a function named "x_count". This function is similar
1159 ** to the built-in count() function, with a few special quirks
1160 ** for testing the sqlite3_result_error() APIs.
1162 ** The original motivation for this routine was to be able to call the
1163 ** sqlite3_create_aggregate function while a query is in progress in order
1164 ** to test the SQLITE_MISUSE detection logic. See misuse.test.
1166 ** This routine was later extended to test the use of sqlite3_result_error()
1167 ** within aggregate functions.
1169 ** Later: It is now also extended to register the aggregate function
1170 ** "legacy_count()" with the supplied database handle. This is used
1171 ** to test the deprecated sqlite3_aggregate_count() API.
1173 static int SQLITE_TCLAPI
test_create_aggregate(
1175 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1176 int argc
, /* Number of arguments */
1177 char **argv
/* Text of each argument */
1182 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1186 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
1187 rc
= sqlite3_create_function(db
, "x_count", 0, SQLITE_UTF8
, 0, 0,
1188 t1CountStep
,t1CountFinalize
);
1189 if( rc
==SQLITE_OK
){
1190 rc
= sqlite3_create_function(db
, "x_count", 1, SQLITE_UTF8
, 0, 0,
1191 t1CountStep
,t1CountFinalize
);
1193 #ifndef SQLITE_OMIT_DEPRECATED
1194 if( rc
==SQLITE_OK
){
1195 rc
= sqlite3_create_function(db
, "legacy_count", 0, SQLITE_ANY
, 0, 0,
1196 legacyCountStep
, legacyCountFinalize
1200 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
1201 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), 0);
1207 ** Usage: printf TEXT
1209 ** Send output to printf. Use this rather than puts to merge the output
1210 ** in the correct sequence with debugging printfs inserted into C code.
1211 ** Puts uses a separate buffer and debugging statements will be out of
1212 ** sequence if it is used.
1214 static int SQLITE_TCLAPI
test_printf(
1216 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1217 int argc
, /* Number of arguments */
1218 char **argv
/* Text of each argument */
1221 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1225 printf("%s\n", argv
[1]);
1232 ** Usage: sqlite3_mprintf_int FORMAT INTEGER INTEGER INTEGER
1234 ** Call mprintf with three integer arguments
1236 static int SQLITE_TCLAPI
sqlite3_mprintf_int(
1238 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1239 int argc
, /* Number of arguments */
1240 char **argv
/* Text of each argument */
1245 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1246 " FORMAT INT INT INT\"", 0);
1250 if( Tcl_GetInt(interp
, argv
[i
], &a
[i
-2]) ) return TCL_ERROR
;
1252 z
= sqlite3_mprintf(argv
[1], a
[0], a
[1], a
[2]);
1253 Tcl_AppendResult(interp
, z
, 0);
1259 ** Usage: sqlite3_mprintf_int64 FORMAT INTEGER INTEGER INTEGER
1261 ** Call mprintf with three 64-bit integer arguments
1263 static int SQLITE_TCLAPI
sqlite3_mprintf_int64(
1265 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1266 int argc
, /* Number of arguments */
1267 char **argv
/* Text of each argument */
1273 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1274 " FORMAT INT INT INT\"", 0);
1278 if( sqlite3Atoi64(argv
[i
], &a
[i
-2], sqlite3Strlen30(argv
[i
]), SQLITE_UTF8
) ){
1279 Tcl_AppendResult(interp
, "argument is not a valid 64-bit integer", 0);
1283 z
= sqlite3_mprintf(argv
[1], a
[0], a
[1], a
[2]);
1284 Tcl_AppendResult(interp
, z
, 0);
1290 ** Usage: sqlite3_mprintf_long FORMAT INTEGER INTEGER INTEGER
1292 ** Call mprintf with three long integer arguments. This might be the
1293 ** same as sqlite3_mprintf_int or sqlite3_mprintf_int64, depending on
1296 static int SQLITE_TCLAPI
sqlite3_mprintf_long(
1298 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1299 int argc
, /* Number of arguments */
1300 char **argv
/* Text of each argument */
1307 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1308 " FORMAT INT INT INT\"", 0);
1312 if( Tcl_GetInt(interp
, argv
[i
], &b
[i
-2]) ) return TCL_ERROR
;
1313 a
[i
-2] = (long int)b
[i
-2];
1314 a
[i
-2] &= (((u64
)1)<<(sizeof(int)*8))-1;
1316 z
= sqlite3_mprintf(argv
[1], a
[0], a
[1], a
[2]);
1317 Tcl_AppendResult(interp
, z
, 0);
1323 ** Usage: sqlite3_mprintf_str FORMAT INTEGER INTEGER STRING
1325 ** Call mprintf with two integer arguments and one string argument
1327 static int SQLITE_TCLAPI
sqlite3_mprintf_str(
1329 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1330 int argc
, /* Number of arguments */
1331 char **argv
/* Text of each argument */
1335 if( argc
<4 || argc
>5 ){
1336 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1337 " FORMAT INT INT ?STRING?\"", 0);
1341 if( Tcl_GetInt(interp
, argv
[i
], &a
[i
-2]) ) return TCL_ERROR
;
1343 z
= sqlite3_mprintf(argv
[1], a
[0], a
[1], argc
>4 ? argv
[4] : NULL
);
1344 Tcl_AppendResult(interp
, z
, 0);
1350 ** Usage: sqlite3_snprintf_str INTEGER FORMAT INTEGER INTEGER STRING
1352 ** Call mprintf with two integer arguments and one string argument
1354 static int SQLITE_TCLAPI
sqlite3_snprintf_str(
1356 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1357 int argc
, /* Number of arguments */
1358 char **argv
/* Text of each argument */
1363 if( argc
<5 || argc
>6 ){
1364 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1365 " INT FORMAT INT INT ?STRING?\"", 0);
1368 if( Tcl_GetInt(interp
, argv
[1], &n
) ) return TCL_ERROR
;
1370 Tcl_AppendResult(interp
, "N must be non-negative", 0);
1374 if( Tcl_GetInt(interp
, argv
[i
], &a
[i
-3]) ) return TCL_ERROR
;
1376 z
= sqlite3_malloc( n
+1 );
1377 sqlite3_snprintf(n
, z
, argv
[2], a
[0], a
[1], argc
>4 ? argv
[5] : NULL
);
1378 Tcl_AppendResult(interp
, z
, 0);
1384 ** Usage: sqlite3_mprintf_double FORMAT INTEGER INTEGER DOUBLE
1386 ** Call mprintf with two integer arguments and one double argument
1388 static int SQLITE_TCLAPI
sqlite3_mprintf_double(
1390 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1391 int argc
, /* Number of arguments */
1392 char **argv
/* Text of each argument */
1398 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1399 " FORMAT INT INT DOUBLE\"", 0);
1403 if( Tcl_GetInt(interp
, argv
[i
], &a
[i
-2]) ) return TCL_ERROR
;
1405 if( Tcl_GetDouble(interp
, argv
[4], &r
) ) return TCL_ERROR
;
1406 z
= sqlite3_mprintf(argv
[1], a
[0], a
[1], r
);
1407 Tcl_AppendResult(interp
, z
, 0);
1413 ** Usage: sqlite3_mprintf_scaled FORMAT DOUBLE DOUBLE
1415 ** Call mprintf with a single double argument which is the product of the
1416 ** two arguments given above. This is used to generate overflow and underflow
1417 ** doubles to test that they are converted properly.
1419 static int SQLITE_TCLAPI
sqlite3_mprintf_scaled(
1421 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1422 int argc
, /* Number of arguments */
1423 char **argv
/* Text of each argument */
1429 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1430 " FORMAT DOUBLE DOUBLE\"", 0);
1434 if( Tcl_GetDouble(interp
, argv
[i
], &r
[i
-2]) ) return TCL_ERROR
;
1436 z
= sqlite3_mprintf(argv
[1], r
[0]*r
[1]);
1437 Tcl_AppendResult(interp
, z
, 0);
1443 ** Usage: sqlite3_mprintf_stronly FORMAT STRING
1445 ** Call mprintf with a single double argument which is the product of the
1446 ** two arguments given above. This is used to generate overflow and underflow
1447 ** doubles to test that they are converted properly.
1449 static int SQLITE_TCLAPI
sqlite3_mprintf_stronly(
1451 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1452 int argc
, /* Number of arguments */
1453 char **argv
/* Text of each argument */
1457 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1458 " FORMAT STRING\"", 0);
1461 z
= sqlite3_mprintf(argv
[1], argv
[2]);
1462 Tcl_AppendResult(interp
, z
, 0);
1468 ** Usage: sqlite3_mprintf_hexdouble FORMAT HEX
1470 ** Call mprintf with a single double argument which is derived from the
1471 ** hexadecimal encoding of an IEEE double.
1473 static int SQLITE_TCLAPI
sqlite3_mprintf_hexdouble(
1475 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1476 int argc
, /* Number of arguments */
1477 char **argv
/* Text of each argument */
1481 unsigned int x1
, x2
;
1484 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
1485 " FORMAT STRING\"", 0);
1488 if( sscanf(argv
[2], "%08x%08x", &x2
, &x1
)!=2 ){
1489 Tcl_AppendResult(interp
, "2nd argument should be 16-characters of hex", 0);
1494 memcpy(&r
, &d
, sizeof(r
));
1495 z
= sqlite3_mprintf(argv
[1], r
);
1496 Tcl_AppendResult(interp
, z
, 0);
1502 ** Usage: sqlite3_enable_shared_cache ?BOOLEAN?
1505 #if !defined(SQLITE_OMIT_SHARED_CACHE)
1506 static int SQLITE_TCLAPI
test_enable_shared(
1507 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
1508 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1509 int objc
, /* Number of arguments */
1510 Tcl_Obj
*CONST objv
[] /* Command arguments */
1516 if( objc
!=2 && objc
!=1 ){
1517 Tcl_WrongNumArgs(interp
, 1, objv
, "?BOOLEAN?");
1520 ret
= sqlite3GlobalConfig
.sharedCacheEnabled
;
1523 if( Tcl_GetBooleanFromObj(interp
, objv
[1], &enable
) ){
1526 rc
= sqlite3_enable_shared_cache(enable
);
1527 if( rc
!=SQLITE_OK
){
1528 Tcl_SetResult(interp
, (char *)sqlite3ErrStr(rc
), TCL_STATIC
);
1532 Tcl_SetObjResult(interp
, Tcl_NewBooleanObj(ret
));
1540 ** Usage: sqlite3_extended_result_codes DB BOOLEAN
1543 static int SQLITE_TCLAPI
test_extended_result_codes(
1544 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
1545 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1546 int objc
, /* Number of arguments */
1547 Tcl_Obj
*CONST objv
[] /* Command arguments */
1553 Tcl_WrongNumArgs(interp
, 1, objv
, "DB BOOLEAN");
1556 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
1557 if( Tcl_GetBooleanFromObj(interp
, objv
[2], &enable
) ) return TCL_ERROR
;
1558 sqlite3_extended_result_codes(db
, enable
);
1563 ** Usage: sqlite3_libversion_number
1566 static int SQLITE_TCLAPI
test_libversion_number(
1567 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
1568 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1569 int objc
, /* Number of arguments */
1570 Tcl_Obj
*CONST objv
[] /* Command arguments */
1572 Tcl_SetObjResult(interp
, Tcl_NewIntObj(sqlite3_libversion_number()));
1577 ** Usage: sqlite3_table_column_metadata DB dbname tblname colname
1580 static int SQLITE_TCLAPI
test_table_column_metadata(
1581 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
1582 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1583 int objc
, /* Number of arguments */
1584 Tcl_Obj
*CONST objv
[] /* Command arguments */
1593 const char *zDatatype
;
1594 const char *zCollseq
;
1599 if( objc
!=5 && objc
!=4 ){
1600 Tcl_WrongNumArgs(interp
, 1, objv
, "DB dbname tblname colname");
1603 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
1604 zDb
= Tcl_GetString(objv
[2]);
1605 zTbl
= Tcl_GetString(objv
[3]);
1606 zCol
= objc
==5 ? Tcl_GetString(objv
[4]) : 0;
1608 if( strlen(zDb
)==0 ) zDb
= 0;
1610 rc
= sqlite3_table_column_metadata(db
, zDb
, zTbl
, zCol
,
1611 &zDatatype
, &zCollseq
, ¬null
, &primarykey
, &autoincrement
);
1613 if( rc
!=SQLITE_OK
){
1614 Tcl_AppendResult(interp
, sqlite3_errmsg(db
), 0);
1618 pRet
= Tcl_NewObj();
1619 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewStringObj(zDatatype
, -1));
1620 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewStringObj(zCollseq
, -1));
1621 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewIntObj(notnull
));
1622 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewIntObj(primarykey
));
1623 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewIntObj(autoincrement
));
1624 Tcl_SetObjResult(interp
, pRet
);
1629 #ifndef SQLITE_OMIT_INCRBLOB
1631 static int SQLITE_TCLAPI
blobHandleFromObj(
1634 sqlite3_blob
**ppBlob
1639 z
= Tcl_GetStringFromObj(pObj
, &n
);
1644 Tcl_Channel channel
;
1645 ClientData instanceData
;
1647 channel
= Tcl_GetChannel(interp
, z
, ¬Used
);
1648 if( !channel
) return TCL_ERROR
;
1651 Tcl_Seek(channel
, 0, SEEK_SET
);
1653 instanceData
= Tcl_GetChannelInstanceData(channel
);
1654 *ppBlob
= *((sqlite3_blob
**)instanceData
);
1660 static int SQLITE_TCLAPI
test_blob_reopen(
1661 ClientData clientData
, /* Not used */
1662 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1663 int objc
, /* Number of arguments */
1664 Tcl_Obj
*CONST objv
[] /* Command arguments */
1667 sqlite3_blob
*pBlob
;
1671 Tcl_WrongNumArgs(interp
, 1, objv
, "CHANNEL ROWID");
1675 if( blobHandleFromObj(interp
, objv
[1], &pBlob
) ) return TCL_ERROR
;
1676 if( Tcl_GetWideIntFromObj(interp
, objv
[2], &iRowid
) ) return TCL_ERROR
;
1678 rc
= sqlite3_blob_reopen(pBlob
, iRowid
);
1679 if( rc
!=SQLITE_OK
){
1680 Tcl_SetResult(interp
, (char *)sqlite3ErrName(rc
), TCL_VOLATILE
);
1683 return (rc
==SQLITE_OK
? TCL_OK
: TCL_ERROR
);
1689 ** Usage: sqlite3_create_collation_v2 DB-HANDLE NAME CMP-PROC DEL-PROC
1691 ** This Tcl proc is used for testing the experimental
1692 ** sqlite3_create_collation_v2() interface.
1694 struct TestCollationX
{
1699 typedef struct TestCollationX TestCollationX
;
1700 static void testCreateCollationDel(void *pCtx
){
1701 TestCollationX
*p
= (TestCollationX
*)pCtx
;
1703 int rc
= Tcl_EvalObjEx(p
->interp
, p
->pDel
, TCL_EVAL_DIRECT
|TCL_EVAL_GLOBAL
);
1705 Tcl_BackgroundError(p
->interp
);
1708 Tcl_DecrRefCount(p
->pCmp
);
1709 Tcl_DecrRefCount(p
->pDel
);
1710 sqlite3_free((void *)p
);
1712 static int testCreateCollationCmp(
1719 TestCollationX
*p
= (TestCollationX
*)pCtx
;
1720 Tcl_Obj
*pScript
= Tcl_DuplicateObj(p
->pCmp
);
1723 Tcl_IncrRefCount(pScript
);
1724 Tcl_ListObjAppendElement(0, pScript
, Tcl_NewStringObj((char *)zLeft
, nLeft
));
1725 Tcl_ListObjAppendElement(0, pScript
, Tcl_NewStringObj((char *)zRight
,nRight
));
1727 if( TCL_OK
!=Tcl_EvalObjEx(p
->interp
, pScript
, TCL_EVAL_DIRECT
|TCL_EVAL_GLOBAL
)
1728 || TCL_OK
!=Tcl_GetIntFromObj(p
->interp
, Tcl_GetObjResult(p
->interp
), &iRes
)
1730 Tcl_BackgroundError(p
->interp
);
1732 Tcl_DecrRefCount(pScript
);
1736 static int SQLITE_TCLAPI
test_create_collation_v2(
1737 ClientData clientData
, /* Not used */
1738 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1739 int objc
, /* Number of arguments */
1740 Tcl_Obj
*CONST objv
[] /* Command arguments */
1747 Tcl_WrongNumArgs(interp
, 1, objv
, "DB-HANDLE NAME CMP-PROC DEL-PROC");
1750 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
1752 p
= (TestCollationX
*)sqlite3_malloc(sizeof(TestCollationX
));
1756 Tcl_IncrRefCount(p
->pCmp
);
1757 Tcl_IncrRefCount(p
->pDel
);
1759 rc
= sqlite3_create_collation_v2(db
, Tcl_GetString(objv
[2]), 16,
1760 (void *)p
, testCreateCollationCmp
, testCreateCollationDel
1762 if( rc
!=SQLITE_MISUSE
){
1763 Tcl_AppendResult(interp
, "sqlite3_create_collate_v2() failed to detect "
1764 "an invalid encoding", (char*)0);
1767 rc
= sqlite3_create_collation_v2(db
, Tcl_GetString(objv
[2]), SQLITE_UTF8
,
1768 (void *)p
, testCreateCollationCmp
, testCreateCollationDel
1774 ** USAGE: sqlite3_create_function_v2 DB NAME NARG ENC ?SWITCHES?
1776 ** Available switches are:
1783 typedef struct CreateFunctionV2 CreateFunctionV2
;
1784 struct CreateFunctionV2
{
1786 Tcl_Obj
*pFunc
; /* Script for function invocation */
1787 Tcl_Obj
*pStep
; /* Script for agg. step invocation */
1788 Tcl_Obj
*pFinal
; /* Script for agg. finalization invocation */
1789 Tcl_Obj
*pDestroy
; /* Destructor script */
1791 static void cf2Func(sqlite3_context
*ctx
, int nArg
, sqlite3_value
**aArg
){
1793 static void cf2Step(sqlite3_context
*ctx
, int nArg
, sqlite3_value
**aArg
){
1795 static void cf2Final(sqlite3_context
*ctx
){
1797 static void cf2Destroy(void *pUser
){
1798 CreateFunctionV2
*p
= (CreateFunctionV2
*)pUser
;
1800 if( p
->interp
&& p
->pDestroy
){
1801 int rc
= Tcl_EvalObjEx(p
->interp
, p
->pDestroy
, 0);
1802 if( rc
!=TCL_OK
) Tcl_BackgroundError(p
->interp
);
1805 if( p
->pFunc
) Tcl_DecrRefCount(p
->pFunc
);
1806 if( p
->pStep
) Tcl_DecrRefCount(p
->pStep
);
1807 if( p
->pFinal
) Tcl_DecrRefCount(p
->pFinal
);
1808 if( p
->pDestroy
) Tcl_DecrRefCount(p
->pDestroy
);
1811 static int SQLITE_TCLAPI
test_create_function_v2(
1812 ClientData clientData
, /* Not used */
1813 Tcl_Interp
*interp
, /* The invoking TCL interpreter */
1814 int objc
, /* Number of arguments */
1815 Tcl_Obj
*CONST objv
[] /* Command arguments */
1821 CreateFunctionV2
*p
;
1829 {"utf8", SQLITE_UTF8
},
1830 {"utf16", SQLITE_UTF16
},
1831 {"utf16le", SQLITE_UTF16LE
},
1832 {"utf16be", SQLITE_UTF16BE
},
1833 {"any", SQLITE_ANY
},
1837 if( objc
<5 || (objc
%2)==0 ){
1838 Tcl_WrongNumArgs(interp
, 1, objv
, "DB NAME NARG ENC SWITCHES...");
1842 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
1843 zFunc
= Tcl_GetString(objv
[2]);
1844 if( Tcl_GetIntFromObj(interp
, objv
[3], &nArg
) ) return TCL_ERROR
;
1845 if( Tcl_GetIndexFromObjStruct(interp
, objv
[4], aEnc
, sizeof(aEnc
[0]),
1846 "encoding", 0, &enc
)
1850 enc
= aEnc
[enc
].enc
;
1852 p
= sqlite3_malloc(sizeof(CreateFunctionV2
));
1854 memset(p
, 0, sizeof(CreateFunctionV2
));
1857 for(i
=5; i
<objc
; i
+=2){
1859 const char *azSwitch
[] = {"-func", "-step", "-final", "-destroy", 0};
1860 if( Tcl_GetIndexFromObj(interp
, objv
[i
], azSwitch
, "switch", 0, &iSwitch
) ){
1866 case 0: p
->pFunc
= objv
[i
+1]; break;
1867 case 1: p
->pStep
= objv
[i
+1]; break;
1868 case 2: p
->pFinal
= objv
[i
+1]; break;
1869 case 3: p
->pDestroy
= objv
[i
+1]; break;
1872 if( p
->pFunc
) p
->pFunc
= Tcl_DuplicateObj(p
->pFunc
);
1873 if( p
->pStep
) p
->pStep
= Tcl_DuplicateObj(p
->pStep
);
1874 if( p
->pFinal
) p
->pFinal
= Tcl_DuplicateObj(p
->pFinal
);
1875 if( p
->pDestroy
) p
->pDestroy
= Tcl_DuplicateObj(p
->pDestroy
);
1877 if( p
->pFunc
) Tcl_IncrRefCount(p
->pFunc
);
1878 if( p
->pStep
) Tcl_IncrRefCount(p
->pStep
);
1879 if( p
->pFinal
) Tcl_IncrRefCount(p
->pFinal
);
1880 if( p
->pDestroy
) Tcl_IncrRefCount(p
->pDestroy
);
1882 rc
= sqlite3_create_function_v2(db
, zFunc
, nArg
, enc
, (void *)p
,
1883 (p
->pFunc
? cf2Func
: 0),
1884 (p
->pStep
? cf2Step
: 0),
1885 (p
->pFinal
? cf2Final
: 0),
1888 if( rc
!=SQLITE_OK
){
1889 Tcl_ResetResult(interp
);
1890 Tcl_AppendResult(interp
, sqlite3ErrName(rc
), 0);
1897 ** Usage: sqlite3_load_extension DB-HANDLE FILE ?PROC?
1899 static int SQLITE_TCLAPI
test_load_extension(
1900 ClientData clientData
, /* Not used */
1901 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1902 int objc
, /* Number of arguments */
1903 Tcl_Obj
*CONST objv
[] /* Command arguments */
1905 Tcl_CmdInfo cmdInfo
;
1913 if( objc
!=4 && objc
!=3 ){
1914 Tcl_WrongNumArgs(interp
, 1, objv
, "DB-HANDLE FILE ?PROC?");
1917 zDb
= Tcl_GetString(objv
[1]);
1918 zFile
= Tcl_GetString(objv
[2]);
1920 zProc
= Tcl_GetString(objv
[3]);
1923 /* Extract the C database handle from the Tcl command name */
1924 if( !Tcl_GetCommandInfo(interp
, zDb
, &cmdInfo
) ){
1925 Tcl_AppendResult(interp
, "command not found: ", zDb
, (char*)0);
1928 db
= ((struct SqliteDb
*)cmdInfo
.objClientData
)->db
;
1931 /* Call the underlying C function. If an error occurs, set rc to
1932 ** TCL_ERROR and load any error string into the interpreter. If no
1933 ** error occurs, set rc to TCL_OK.
1935 #ifdef SQLITE_OMIT_LOAD_EXTENSION
1937 zErr
= sqlite3_mprintf("this build omits sqlite3_load_extension()");
1941 rc
= sqlite3_load_extension(db
, zFile
, zProc
, &zErr
);
1943 if( rc
!=SQLITE_OK
){
1944 Tcl_SetResult(interp
, zErr
? zErr
: "", TCL_VOLATILE
);
1955 ** Usage: sqlite3_enable_load_extension DB-HANDLE ONOFF
1957 static int SQLITE_TCLAPI
test_enable_load(
1958 ClientData clientData
, /* Not used */
1959 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
1960 int objc
, /* Number of arguments */
1961 Tcl_Obj
*CONST objv
[] /* Command arguments */
1963 Tcl_CmdInfo cmdInfo
;
1969 Tcl_WrongNumArgs(interp
, 1, objv
, "DB-HANDLE ONOFF");
1972 zDb
= Tcl_GetString(objv
[1]);
1974 /* Extract the C database handle from the Tcl command name */
1975 if( !Tcl_GetCommandInfo(interp
, zDb
, &cmdInfo
) ){
1976 Tcl_AppendResult(interp
, "command not found: ", zDb
, (char*)0);
1979 db
= ((struct SqliteDb
*)cmdInfo
.objClientData
)->db
;
1982 /* Get the onoff parameter */
1983 if( Tcl_GetBooleanFromObj(interp
, objv
[2], &onoff
) ){
1987 #ifdef SQLITE_OMIT_LOAD_EXTENSION
1988 Tcl_AppendResult(interp
, "this build omits sqlite3_load_extension()");
1991 sqlite3_enable_load_extension(db
, onoff
);
1997 ** Usage: sqlite_abort
1999 ** Shutdown the process immediately. This is not a clean shutdown.
2000 ** This command is used to test the recoverability of a database in
2001 ** the event of a program crash.
2003 static int SQLITE_TCLAPI
sqlite_abort(
2005 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
2006 int argc
, /* Number of arguments */
2007 char **argv
/* Text of each argument */
2009 #if defined(_MSC_VER)
2010 /* We do this, otherwise the test will halt with a popup message
2011 * that we have to click away before the test will continue.
2013 _set_abort_behavior( 0, _CALL_REPORTFAULT
);
2016 assert( interp
==0 ); /* This will always fail */
2021 ** The following routine is a user-defined SQL function whose purpose
2022 ** is to test the sqlite_set_result() API.
2024 static void testFunc(sqlite3_context
*context
, int argc
, sqlite3_value
**argv
){
2026 const char *zArg0
= (char*)sqlite3_value_text(argv
[0]);
2028 if( 0==sqlite3StrICmp(zArg0
, "int") ){
2029 sqlite3_result_int(context
, sqlite3_value_int(argv
[1]));
2030 }else if( sqlite3StrICmp(zArg0
,"int64")==0 ){
2031 sqlite3_result_int64(context
, sqlite3_value_int64(argv
[1]));
2032 }else if( sqlite3StrICmp(zArg0
,"string")==0 ){
2033 sqlite3_result_text(context
, (char*)sqlite3_value_text(argv
[1]), -1,
2035 }else if( sqlite3StrICmp(zArg0
,"double")==0 ){
2036 sqlite3_result_double(context
, sqlite3_value_double(argv
[1]));
2037 }else if( sqlite3StrICmp(zArg0
,"null")==0 ){
2038 sqlite3_result_null(context
);
2039 }else if( sqlite3StrICmp(zArg0
,"value")==0 ){
2040 sqlite3_result_value(context
, argv
[sqlite3_value_int(argv
[1])]);
2053 sqlite3_result_error(context
,"first argument should be one of: "
2054 "int int64 string double null value", -1);
2058 ** Usage: sqlite_register_test_function DB NAME
2060 ** Register the test SQL function on the database DB under the name NAME.
2062 static int SQLITE_TCLAPI
test_register_func(
2064 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
2065 int argc
, /* Number of arguments */
2066 char **argv
/* Text of each argument */
2071 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
2072 " DB FUNCTION-NAME", 0);
2075 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
2076 rc
= sqlite3_create_function(db
, argv
[2], -1, SQLITE_UTF8
, 0,
2079 Tcl_AppendResult(interp
, sqlite3ErrStr(rc
), 0);
2082 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
2087 ** Usage: sqlite3_finalize STMT
2089 ** Finalize a statement handle.
2091 static int SQLITE_TCLAPI
test_finalize(
2095 Tcl_Obj
*CONST objv
[]
2097 sqlite3_stmt
*pStmt
;
2102 Tcl_AppendResult(interp
, "wrong # args: should be \"",
2103 Tcl_GetStringFromObj(objv
[0], 0), " <STMT>", 0);
2107 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
2110 db
= StmtToDb(pStmt
);
2112 rc
= sqlite3_finalize(pStmt
);
2113 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
2114 if( db
&& sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
2119 ** Usage: sqlite3_stmt_status STMT CODE RESETFLAG
2121 ** Get the value of a status counter from a statement.
2123 static int SQLITE_TCLAPI
test_stmt_status(
2127 Tcl_Obj
*CONST objv
[]
2130 int i
, op
= 0, resetFlag
;
2131 const char *zOpName
;
2132 sqlite3_stmt
*pStmt
;
2134 static const struct {
2138 { "SQLITE_STMTSTATUS_FULLSCAN_STEP", SQLITE_STMTSTATUS_FULLSCAN_STEP
},
2139 { "SQLITE_STMTSTATUS_SORT", SQLITE_STMTSTATUS_SORT
},
2140 { "SQLITE_STMTSTATUS_AUTOINDEX", SQLITE_STMTSTATUS_AUTOINDEX
},
2141 { "SQLITE_STMTSTATUS_VM_STEP", SQLITE_STMTSTATUS_VM_STEP
},
2142 { "SQLITE_STMTSTATUS_REPREPARE", SQLITE_STMTSTATUS_REPREPARE
},
2143 { "SQLITE_STMTSTATUS_RUN", SQLITE_STMTSTATUS_RUN
},
2144 { "SQLITE_STMTSTATUS_MEMUSED", SQLITE_STMTSTATUS_MEMUSED
},
2147 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT PARAMETER RESETFLAG");
2150 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
2151 zOpName
= Tcl_GetString(objv
[2]);
2152 for(i
=0; i
<ArraySize(aOp
); i
++){
2153 if( strcmp(aOp
[i
].zName
, zOpName
)==0 ){
2158 if( i
>=ArraySize(aOp
) ){
2159 if( Tcl_GetIntFromObj(interp
, objv
[2], &op
) ) return TCL_ERROR
;
2161 if( Tcl_GetBooleanFromObj(interp
, objv
[3], &resetFlag
) ) return TCL_ERROR
;
2162 iValue
= sqlite3_stmt_status(pStmt
, op
, resetFlag
);
2163 Tcl_SetObjResult(interp
, Tcl_NewIntObj(iValue
));
2167 #ifdef SQLITE_ENABLE_STMT_SCANSTATUS
2169 ** Usage: sqlite3_stmt_scanstatus STMT IDX
2171 static int SQLITE_TCLAPI
test_stmt_scanstatus(
2175 Tcl_Obj
*CONST objv
[]
2177 sqlite3_stmt
*pStmt
; /* First argument */
2178 int idx
; /* Second argument */
2181 const char *zExplain
;
2182 sqlite3_int64 nLoop
;
2183 sqlite3_int64 nVisit
;
2188 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT IDX");
2191 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
2192 if( Tcl_GetIntFromObj(interp
, objv
[2], &idx
) ) return TCL_ERROR
;
2194 res
= sqlite3_stmt_scanstatus(pStmt
, idx
, SQLITE_SCANSTAT_NLOOP
, (void*)&nLoop
);
2196 Tcl_Obj
*pRet
= Tcl_NewObj();
2197 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewStringObj("nLoop", -1));
2198 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewWideIntObj(nLoop
));
2199 sqlite3_stmt_scanstatus(pStmt
, idx
, SQLITE_SCANSTAT_NVISIT
, (void*)&nVisit
);
2200 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewStringObj("nVisit", -1));
2201 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewWideIntObj(nVisit
));
2202 sqlite3_stmt_scanstatus(pStmt
, idx
, SQLITE_SCANSTAT_EST
, (void*)&rEst
);
2203 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewStringObj("nEst", -1));
2204 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewDoubleObj(rEst
));
2205 sqlite3_stmt_scanstatus(pStmt
, idx
, SQLITE_SCANSTAT_NAME
, (void*)&zName
);
2206 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewStringObj("zName", -1));
2207 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewStringObj(zName
, -1));
2208 sqlite3_stmt_scanstatus(pStmt
, idx
, SQLITE_SCANSTAT_EXPLAIN
, (void*)&zExplain
);
2209 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewStringObj("zExplain", -1));
2210 Tcl_ListObjAppendElement(0, pRet
, Tcl_NewStringObj(zExplain
, -1));
2211 Tcl_SetObjResult(interp
, pRet
);
2213 Tcl_ResetResult(interp
);
2219 ** Usage: sqlite3_stmt_scanstatus_reset STMT
2221 static int SQLITE_TCLAPI
test_stmt_scanstatus_reset(
2225 Tcl_Obj
*CONST objv
[]
2227 sqlite3_stmt
*pStmt
; /* First argument */
2229 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT");
2232 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
2233 sqlite3_stmt_scanstatus_reset(pStmt
);
2238 #ifdef SQLITE_ENABLE_SQLLOG
2240 ** Usage: sqlite3_config_sqllog
2242 ** Zero the SQLITE_CONFIG_SQLLOG configuration
2244 static int SQLITE_TCLAPI
test_config_sqllog(
2248 Tcl_Obj
*CONST objv
[]
2251 Tcl_WrongNumArgs(interp
, 1, objv
, "");
2254 sqlite3_config(SQLITE_CONFIG_SQLLOG
, 0, 0);
2260 ** Usage: sqlite3_config_sorterref
2262 ** Set the SQLITE_CONFIG_SORTERREF_SIZE configuration option
2264 static int SQLITE_TCLAPI
test_config_sorterref(
2268 Tcl_Obj
*CONST objv
[]
2272 Tcl_WrongNumArgs(interp
, 1, objv
, "NBYTE");
2275 if( Tcl_GetIntFromObj(interp
, objv
[1], &iVal
) ) return TCL_ERROR
;
2276 sqlite3_config(SQLITE_CONFIG_SORTERREF_SIZE
, iVal
);
2281 ** Usage: vfs_current_time_int64
2283 ** Return the value returned by the default VFS's xCurrentTimeInt64 method.
2285 static int SQLITE_TCLAPI
vfsCurrentTimeInt64(
2289 Tcl_Obj
*CONST objv
[]
2292 sqlite3_vfs
*pVfs
= sqlite3_vfs_find(0);
2294 Tcl_WrongNumArgs(interp
, 1, objv
, "");
2297 pVfs
->xCurrentTimeInt64(pVfs
, &t
);
2298 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj(t
));
2302 #ifdef SQLITE_ENABLE_SNAPSHOT
2304 ** Usage: sqlite3_snapshot_get DB DBNAME
2306 static int SQLITE_TCLAPI
test_snapshot_get(
2310 Tcl_Obj
*CONST objv
[]
2315 sqlite3_snapshot
*pSnapshot
= 0;
2318 Tcl_WrongNumArgs(interp
, 1, objv
, "DB DBNAME");
2321 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
2322 zName
= Tcl_GetString(objv
[2]);
2324 rc
= sqlite3_snapshot_get(db
, zName
, &pSnapshot
);
2325 if( rc
!=SQLITE_OK
){
2326 Tcl_SetObjResult(interp
, Tcl_NewStringObj(sqlite3ErrName(rc
), -1));
2330 if( sqlite3TestMakePointerStr(interp
, zBuf
, pSnapshot
) ) return TCL_ERROR
;
2331 Tcl_SetObjResult(interp
, Tcl_NewStringObj(zBuf
, -1));
2335 #endif /* SQLITE_ENABLE_SNAPSHOT */
2337 #ifdef SQLITE_ENABLE_SNAPSHOT
2339 ** Usage: sqlite3_snapshot_recover DB DBNAME
2341 static int SQLITE_TCLAPI
test_snapshot_recover(
2345 Tcl_Obj
*CONST objv
[]
2352 Tcl_WrongNumArgs(interp
, 1, objv
, "DB DBNAME");
2355 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
2356 zName
= Tcl_GetString(objv
[2]);
2358 rc
= sqlite3_snapshot_recover(db
, zName
);
2359 if( rc
!=SQLITE_OK
){
2360 Tcl_SetObjResult(interp
, Tcl_NewStringObj(sqlite3ErrName(rc
), -1));
2363 Tcl_ResetResult(interp
);
2367 #endif /* SQLITE_ENABLE_SNAPSHOT */
2369 #ifdef SQLITE_ENABLE_SNAPSHOT
2371 ** Usage: sqlite3_snapshot_open DB DBNAME SNAPSHOT
2373 static int SQLITE_TCLAPI
test_snapshot_open(
2377 Tcl_Obj
*CONST objv
[]
2382 sqlite3_snapshot
*pSnapshot
;
2385 Tcl_WrongNumArgs(interp
, 1, objv
, "DB DBNAME SNAPSHOT");
2388 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
2389 zName
= Tcl_GetString(objv
[2]);
2390 pSnapshot
= (sqlite3_snapshot
*)sqlite3TestTextToPtr(Tcl_GetString(objv
[3]));
2392 rc
= sqlite3_snapshot_open(db
, zName
, pSnapshot
);
2393 if( rc
!=SQLITE_OK
){
2394 Tcl_SetObjResult(interp
, Tcl_NewStringObj(sqlite3ErrName(rc
), -1));
2397 Tcl_ResetResult(interp
);
2401 #endif /* SQLITE_ENABLE_SNAPSHOT */
2403 #ifdef SQLITE_ENABLE_SNAPSHOT
2405 ** Usage: sqlite3_snapshot_free SNAPSHOT
2407 static int SQLITE_TCLAPI
test_snapshot_free(
2411 Tcl_Obj
*CONST objv
[]
2413 sqlite3_snapshot
*pSnapshot
;
2415 Tcl_WrongNumArgs(interp
, 1, objv
, "SNAPSHOT");
2418 pSnapshot
= (sqlite3_snapshot
*)sqlite3TestTextToPtr(Tcl_GetString(objv
[1]));
2419 sqlite3_snapshot_free(pSnapshot
);
2422 #endif /* SQLITE_ENABLE_SNAPSHOT */
2424 #ifdef SQLITE_ENABLE_SNAPSHOT
2426 ** Usage: sqlite3_snapshot_cmp SNAPSHOT1 SNAPSHOT2
2428 static int SQLITE_TCLAPI
test_snapshot_cmp(
2432 Tcl_Obj
*CONST objv
[]
2435 sqlite3_snapshot
*p1
;
2436 sqlite3_snapshot
*p2
;
2438 Tcl_WrongNumArgs(interp
, 1, objv
, "SNAPSHOT1 SNAPSHOT2");
2441 p1
= (sqlite3_snapshot
*)sqlite3TestTextToPtr(Tcl_GetString(objv
[1]));
2442 p2
= (sqlite3_snapshot
*)sqlite3TestTextToPtr(Tcl_GetString(objv
[2]));
2443 res
= sqlite3_snapshot_cmp(p1
, p2
);
2444 Tcl_SetObjResult(interp
, Tcl_NewIntObj(res
));
2447 #endif /* SQLITE_ENABLE_SNAPSHOT */
2449 #ifdef SQLITE_ENABLE_SNAPSHOT
2451 ** Usage: sqlite3_snapshot_get_blob DB DBNAME
2453 static int SQLITE_TCLAPI
test_snapshot_get_blob(
2457 Tcl_Obj
*CONST objv
[]
2462 sqlite3_snapshot
*pSnapshot
= 0;
2465 Tcl_WrongNumArgs(interp
, 1, objv
, "DB DBNAME");
2468 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
2469 zName
= Tcl_GetString(objv
[2]);
2471 rc
= sqlite3_snapshot_get(db
, zName
, &pSnapshot
);
2472 if( rc
!=SQLITE_OK
){
2473 Tcl_SetObjResult(interp
, Tcl_NewStringObj(sqlite3ErrName(rc
), -1));
2476 Tcl_SetObjResult(interp
,
2477 Tcl_NewByteArrayObj((unsigned char*)pSnapshot
, sizeof(sqlite3_snapshot
))
2479 sqlite3_snapshot_free(pSnapshot
);
2483 #endif /* SQLITE_ENABLE_SNAPSHOT */
2485 #ifdef SQLITE_ENABLE_SNAPSHOT
2487 ** Usage: sqlite3_snapshot_open_blob DB DBNAME SNAPSHOT
2489 static int SQLITE_TCLAPI
test_snapshot_open_blob(
2493 Tcl_Obj
*CONST objv
[]
2498 unsigned char *pBlob
;
2502 Tcl_WrongNumArgs(interp
, 1, objv
, "DB DBNAME SNAPSHOT");
2505 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
2506 zName
= Tcl_GetString(objv
[2]);
2507 pBlob
= Tcl_GetByteArrayFromObj(objv
[3], &nBlob
);
2508 if( nBlob
!=sizeof(sqlite3_snapshot
) ){
2509 Tcl_AppendResult(interp
, "bad SNAPSHOT", 0);
2512 rc
= sqlite3_snapshot_open(db
, zName
, (sqlite3_snapshot
*)pBlob
);
2513 if( rc
!=SQLITE_OK
){
2514 Tcl_SetObjResult(interp
, Tcl_NewStringObj(sqlite3ErrName(rc
), -1));
2519 #endif /* SQLITE_ENABLE_SNAPSHOT */
2521 #ifdef SQLITE_ENABLE_SNAPSHOT
2523 ** Usage: sqlite3_snapshot_cmp_blob SNAPSHOT1 SNAPSHOT2
2525 static int SQLITE_TCLAPI
test_snapshot_cmp_blob(
2529 Tcl_Obj
*CONST objv
[]
2538 Tcl_WrongNumArgs(interp
, 1, objv
, "SNAPSHOT1 SNAPSHOT2");
2542 p1
= Tcl_GetByteArrayFromObj(objv
[1], &n1
);
2543 p2
= Tcl_GetByteArrayFromObj(objv
[2], &n2
);
2545 if( n1
!=sizeof(sqlite3_snapshot
) || n1
!=n2
){
2546 Tcl_AppendResult(interp
, "bad SNAPSHOT", 0);
2550 res
= sqlite3_snapshot_cmp((sqlite3_snapshot
*)p1
, (sqlite3_snapshot
*)p2
);
2551 Tcl_SetObjResult(interp
, Tcl_NewIntObj(res
));
2554 #endif /* SQLITE_ENABLE_SNAPSHOT */
2557 ** Usage: sqlite3_delete_database FILENAME
2559 int sqlite3_delete_database(const char*); /* in test_delete.c */
2560 static int SQLITE_TCLAPI
test_delete_database(
2564 Tcl_Obj
*CONST objv
[]
2569 Tcl_WrongNumArgs(interp
, 1, objv
, "FILE");
2572 zFile
= (const char*)Tcl_GetString(objv
[1]);
2573 rc
= sqlite3_delete_database(zFile
);
2575 Tcl_SetObjResult(interp
, Tcl_NewStringObj(sqlite3ErrName(rc
), -1));
2580 ** Usage: atomic_batch_write PATH
2582 static int SQLITE_TCLAPI
test_atomic_batch_write(
2586 Tcl_Obj
*CONST objv
[]
2588 char *zFile
= 0; /* Path to file to test */
2589 sqlite3
*db
= 0; /* Database handle */
2590 sqlite3_file
*pFd
= 0; /* SQLite fd open on zFile */
2591 int bRes
= 0; /* Integer result of this command */
2592 int dc
= 0; /* Device-characteristics mask */
2593 int rc
; /* sqlite3_open() return code */
2596 Tcl_WrongNumArgs(interp
, 1, objv
, "PATH");
2599 zFile
= Tcl_GetString(objv
[1]);
2601 rc
= sqlite3_open(zFile
, &db
);
2602 if( rc
!=SQLITE_OK
){
2603 Tcl_AppendResult(interp
, sqlite3_errmsg(db
), 0);
2608 rc
= sqlite3_file_control(db
, "main", SQLITE_FCNTL_FILE_POINTER
, (void*)&pFd
);
2609 dc
= pFd
->pMethods
->xDeviceCharacteristics(pFd
);
2610 if( dc
& SQLITE_IOCAP_BATCH_ATOMIC
){
2614 Tcl_SetObjResult(interp
, Tcl_NewIntObj(bRes
));
2620 ** Usage: sqlite3_next_stmt DB STMT
2622 ** Return the next statment in sequence after STMT.
2624 static int SQLITE_TCLAPI
test_next_stmt(
2628 Tcl_Obj
*CONST objv
[]
2630 sqlite3_stmt
*pStmt
;
2635 Tcl_AppendResult(interp
, "wrong # args: should be \"",
2636 Tcl_GetStringFromObj(objv
[0], 0), " DB STMT", 0);
2640 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
2641 if( getStmtPointer(interp
, Tcl_GetString(objv
[2]), &pStmt
) ) return TCL_ERROR
;
2642 pStmt
= sqlite3_next_stmt(db
, pStmt
);
2644 if( sqlite3TestMakePointerStr(interp
, zBuf
, pStmt
) ) return TCL_ERROR
;
2645 Tcl_AppendResult(interp
, zBuf
, 0);
2651 ** Usage: sqlite3_stmt_readonly STMT
2653 ** Return true if STMT is a NULL pointer or a pointer to a statement
2654 ** that is guaranteed to leave the database unmodified.
2656 static int SQLITE_TCLAPI
test_stmt_readonly(
2660 Tcl_Obj
*CONST objv
[]
2662 sqlite3_stmt
*pStmt
;
2666 Tcl_AppendResult(interp
, "wrong # args: should be \"",
2667 Tcl_GetStringFromObj(objv
[0], 0), " STMT", 0);
2671 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
2672 rc
= sqlite3_stmt_readonly(pStmt
);
2673 Tcl_SetObjResult(interp
, Tcl_NewBooleanObj(rc
));
2678 ** Usage: sqlite3_stmt_isexplain STMT
2680 ** Return 1, 2, or 0 respectively if STMT is an EXPLAIN statement, an
2681 ** EXPLAIN QUERY PLAN statement or an ordinary statement or NULL pointer.
2683 static int SQLITE_TCLAPI
test_stmt_isexplain(
2687 Tcl_Obj
*CONST objv
[]
2689 sqlite3_stmt
*pStmt
;
2693 Tcl_AppendResult(interp
, "wrong # args: should be \"",
2694 Tcl_GetStringFromObj(objv
[0], 0), " STMT", 0);
2698 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
2699 rc
= sqlite3_stmt_isexplain(pStmt
);
2700 Tcl_SetObjResult(interp
, Tcl_NewIntObj(rc
));
2705 ** Usage: sqlite3_stmt_busy STMT
2707 ** Return true if STMT is a non-NULL pointer to a statement
2708 ** that has been stepped but not to completion.
2710 static int SQLITE_TCLAPI
test_stmt_busy(
2714 Tcl_Obj
*CONST objv
[]
2716 sqlite3_stmt
*pStmt
;
2720 Tcl_AppendResult(interp
, "wrong # args: should be \"",
2721 Tcl_GetStringFromObj(objv
[0], 0), " STMT", 0);
2725 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
2726 rc
= sqlite3_stmt_busy(pStmt
);
2727 Tcl_SetObjResult(interp
, Tcl_NewBooleanObj(rc
));
2732 ** Usage: uses_stmt_journal STMT
2734 ** Return true if STMT uses a statement journal.
2736 static int SQLITE_TCLAPI
uses_stmt_journal(
2740 Tcl_Obj
*CONST objv
[]
2742 sqlite3_stmt
*pStmt
;
2745 Tcl_AppendResult(interp
, "wrong # args: should be \"",
2746 Tcl_GetStringFromObj(objv
[0], 0), " STMT", 0);
2750 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
2751 sqlite3_stmt_readonly(pStmt
);
2752 Tcl_SetObjResult(interp
, Tcl_NewBooleanObj(((Vdbe
*)pStmt
)->usesStmtJournal
));
2758 ** Usage: sqlite3_reset STMT
2760 ** Reset a statement handle.
2762 static int SQLITE_TCLAPI
test_reset(
2766 Tcl_Obj
*CONST objv
[]
2768 sqlite3_stmt
*pStmt
;
2772 Tcl_AppendResult(interp
, "wrong # args: should be \"",
2773 Tcl_GetStringFromObj(objv
[0], 0), " <STMT>", 0);
2777 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
2779 rc
= sqlite3_reset(pStmt
);
2780 if( pStmt
&& sqlite3TestErrCode(interp
, StmtToDb(pStmt
), rc
) ){
2783 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
2793 ** Usage: sqlite3_expired STMT
2795 ** Return TRUE if a recompilation of the statement is recommended.
2797 static int SQLITE_TCLAPI
test_expired(
2801 Tcl_Obj
*CONST objv
[]
2803 #ifndef SQLITE_OMIT_DEPRECATED
2804 sqlite3_stmt
*pStmt
;
2806 Tcl_AppendResult(interp
, "wrong # args: should be \"",
2807 Tcl_GetStringFromObj(objv
[0], 0), " <STMT>", 0);
2810 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
2811 Tcl_SetObjResult(interp
, Tcl_NewBooleanObj(sqlite3_expired(pStmt
)));
2817 ** Usage: sqlite3_transfer_bindings FROMSTMT TOSTMT
2819 ** Transfer all bindings from FROMSTMT over to TOSTMT
2821 static int SQLITE_TCLAPI
test_transfer_bind(
2825 Tcl_Obj
*CONST objv
[]
2827 #ifndef SQLITE_OMIT_DEPRECATED
2828 sqlite3_stmt
*pStmt1
, *pStmt2
;
2830 Tcl_AppendResult(interp
, "wrong # args: should be \"",
2831 Tcl_GetStringFromObj(objv
[0], 0), " FROM-STMT TO-STMT", 0);
2834 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt1
)) return TCL_ERROR
;
2835 if( getStmtPointer(interp
, Tcl_GetString(objv
[2]), &pStmt2
)) return TCL_ERROR
;
2836 Tcl_SetObjResult(interp
,
2837 Tcl_NewIntObj(sqlite3_transfer_bindings(pStmt1
,pStmt2
)));
2843 ** Usage: sqlite3_changes DB
2845 ** Return the number of changes made to the database by the last SQL
2848 static int SQLITE_TCLAPI
test_changes(
2852 Tcl_Obj
*CONST objv
[]
2856 Tcl_AppendResult(interp
, "wrong # args: should be \"",
2857 Tcl_GetString(objv
[0]), " DB", 0);
2860 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
2861 Tcl_SetObjResult(interp
, Tcl_NewIntObj(sqlite3_changes(db
)));
2866 ** This is the "static_bind_value" that variables are bound to when
2867 ** the FLAG option of sqlite3_bind is "static"
2869 static char *sqlite_static_bind_value
= 0;
2870 static int sqlite_static_bind_nbyte
= 0;
2873 ** Usage: sqlite3_bind VM IDX VALUE FLAGS
2875 ** Sets the value of the IDX-th occurrence of "?" in the original SQL
2876 ** string. VALUE is the new value. If FLAGS=="null" then VALUE is
2877 ** ignored and the value is set to NULL. If FLAGS=="static" then
2878 ** the value is set to the value of a static variable named
2879 ** "sqlite_static_bind_value". If FLAGS=="normal" then a copy
2880 ** of the VALUE is made. If FLAGS=="blob10" then a VALUE is ignored
2881 ** an a 10-byte blob "abc\000xyz\000pq" is inserted.
2883 static int SQLITE_TCLAPI
test_bind(
2885 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
2886 int argc
, /* Number of arguments */
2887 char **argv
/* Text of each argument */
2889 sqlite3_stmt
*pStmt
;
2893 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
2894 " VM IDX VALUE (null|static|normal)\"", 0);
2897 if( getStmtPointer(interp
, argv
[1], &pStmt
) ) return TCL_ERROR
;
2898 if( Tcl_GetInt(interp
, argv
[2], &idx
) ) return TCL_ERROR
;
2899 if( strcmp(argv
[4],"null")==0 ){
2900 rc
= sqlite3_bind_null(pStmt
, idx
);
2901 }else if( strcmp(argv
[4],"static")==0 ){
2902 rc
= sqlite3_bind_text(pStmt
, idx
, sqlite_static_bind_value
, -1, 0);
2903 }else if( strcmp(argv
[4],"static-nbytes")==0 ){
2904 rc
= sqlite3_bind_text(pStmt
, idx
, sqlite_static_bind_value
,
2905 sqlite_static_bind_nbyte
, 0);
2906 }else if( strcmp(argv
[4],"normal")==0 ){
2907 rc
= sqlite3_bind_text(pStmt
, idx
, argv
[3], -1, SQLITE_TRANSIENT
);
2908 }else if( strcmp(argv
[4],"blob10")==0 ){
2909 rc
= sqlite3_bind_text(pStmt
, idx
, "abc\000xyz\000pq", 10, SQLITE_STATIC
);
2911 Tcl_AppendResult(interp
, "4th argument should be "
2912 "\"null\" or \"static\" or \"normal\"", 0);
2915 if( sqlite3TestErrCode(interp
, StmtToDb(pStmt
), rc
) ) return TCL_ERROR
;
2918 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "(%d) ", rc
);
2919 Tcl_AppendResult(interp
, zBuf
, sqlite3ErrStr(rc
), 0);
2925 #ifndef SQLITE_OMIT_UTF16
2927 ** Usage: add_test_collate <db ptr> <utf8> <utf16le> <utf16be>
2929 ** This function is used to test that SQLite selects the correct collation
2930 ** sequence callback when multiple versions (for different text encodings)
2933 ** Calling this routine registers the collation sequence "test_collate"
2934 ** with database handle <db>. The second argument must be a list of three
2935 ** boolean values. If the first is true, then a version of test_collate is
2936 ** registered for UTF-8, if the second is true, a version is registered for
2937 ** UTF-16le, if the third is true, a UTF-16be version is available.
2938 ** Previous versions of test_collate are deleted.
2940 ** The collation sequence test_collate is implemented by calling the
2941 ** following TCL script:
2943 ** "test_collate <enc> <lhs> <rhs>"
2945 ** The <lhs> and <rhs> are the two values being compared, encoded in UTF-8.
2946 ** The <enc> parameter is the encoding of the collation function that
2947 ** SQLite selected to call. The TCL test script implements the
2948 ** "test_collate" proc.
2950 ** Note that this will only work with one interpreter at a time, as the
2951 ** interp pointer to use when evaluating the TCL script is stored in
2952 ** pTestCollateInterp.
2954 static Tcl_Interp
* pTestCollateInterp
;
2955 static int test_collate_func(
2957 int nA
, const void *zA
,
2958 int nB
, const void *zB
2960 Tcl_Interp
*i
= pTestCollateInterp
;
2961 int encin
= SQLITE_PTR_TO_INT(pCtx
);
2965 sqlite3_value
*pVal
;
2968 pX
= Tcl_NewStringObj("test_collate", -1);
2969 Tcl_IncrRefCount(pX
);
2973 Tcl_ListObjAppendElement(i
,pX
,Tcl_NewStringObj("UTF-8",-1));
2975 case SQLITE_UTF16LE
:
2976 Tcl_ListObjAppendElement(i
,pX
,Tcl_NewStringObj("UTF-16LE",-1));
2978 case SQLITE_UTF16BE
:
2979 Tcl_ListObjAppendElement(i
,pX
,Tcl_NewStringObj("UTF-16BE",-1));
2985 sqlite3BeginBenignMalloc();
2986 pVal
= sqlite3ValueNew(0);
2988 sqlite3ValueSetStr(pVal
, nA
, zA
, encin
, SQLITE_STATIC
);
2989 n
= sqlite3_value_bytes(pVal
);
2990 Tcl_ListObjAppendElement(i
,pX
,
2991 Tcl_NewStringObj((char*)sqlite3_value_text(pVal
),n
));
2992 sqlite3ValueSetStr(pVal
, nB
, zB
, encin
, SQLITE_STATIC
);
2993 n
= sqlite3_value_bytes(pVal
);
2994 Tcl_ListObjAppendElement(i
,pX
,
2995 Tcl_NewStringObj((char*)sqlite3_value_text(pVal
),n
));
2996 sqlite3ValueFree(pVal
);
2998 sqlite3EndBenignMalloc();
3000 Tcl_EvalObjEx(i
, pX
, 0);
3001 Tcl_DecrRefCount(pX
);
3002 Tcl_GetIntFromObj(i
, Tcl_GetObjResult(i
), &res
);
3005 static int SQLITE_TCLAPI
test_collate(
3009 Tcl_Obj
*CONST objv
[]
3013 sqlite3_value
*pVal
;
3016 if( objc
!=5 ) goto bad_args
;
3017 pTestCollateInterp
= interp
;
3018 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
3020 if( TCL_OK
!=Tcl_GetBooleanFromObj(interp
, objv
[2], &val
) ) return TCL_ERROR
;
3021 rc
= sqlite3_create_collation(db
, "test_collate", SQLITE_UTF8
,
3022 (void *)SQLITE_UTF8
, val
?test_collate_func
:0);
3023 if( rc
==SQLITE_OK
){
3025 if( TCL_OK
!=Tcl_GetBooleanFromObj(interp
, objv
[3], &val
) ) return TCL_ERROR
;
3026 rc
= sqlite3_create_collation(db
, "test_collate", SQLITE_UTF16LE
,
3027 (void *)SQLITE_UTF16LE
, val
?test_collate_func
:0);
3028 if( TCL_OK
!=Tcl_GetBooleanFromObj(interp
, objv
[4], &val
) ) return TCL_ERROR
;
3031 if( sqlite3_iMallocFail
>0 ){
3032 sqlite3_iMallocFail
++;
3035 sqlite3_mutex_enter(db
->mutex
);
3036 pVal
= sqlite3ValueNew(db
);
3037 sqlite3ValueSetStr(pVal
, -1, "test_collate", SQLITE_UTF8
, SQLITE_STATIC
);
3038 zUtf16
= sqlite3ValueText(pVal
, SQLITE_UTF16NATIVE
);
3039 if( db
->mallocFailed
){
3042 rc
= sqlite3_create_collation16(db
, zUtf16
, SQLITE_UTF16BE
,
3043 (void *)SQLITE_UTF16BE
, val
?test_collate_func
:0);
3045 sqlite3ValueFree(pVal
);
3046 sqlite3_mutex_leave(db
->mutex
);
3048 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
3050 if( rc
!=SQLITE_OK
){
3051 Tcl_AppendResult(interp
, sqlite3ErrName(rc
), 0);
3057 Tcl_AppendResult(interp
, "wrong # args: should be \"",
3058 Tcl_GetStringFromObj(objv
[0], 0), " <DB> <utf8> <utf16le> <utf16be>", 0);
3063 ** Usage: add_test_utf16bin_collate <db ptr>
3065 ** Add a utf-16 collation sequence named "utf16bin" to the database
3066 ** handle. This collation sequence compares arguments in the same way as the
3067 ** built-in collation "binary".
3069 static int test_utf16bin_collate_func(
3071 int nA
, const void *zA
,
3072 int nB
, const void *zB
3074 int nCmp
= (nA
>nB
? nB
: nA
);
3075 int res
= memcmp(zA
, zB
, nCmp
);
3076 if( res
==0 ) res
= nA
- nB
;
3079 static int SQLITE_TCLAPI
test_utf16bin_collate(
3083 Tcl_Obj
*CONST objv
[]
3088 if( objc
!=2 ) goto bad_args
;
3089 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
3091 rc
= sqlite3_create_collation(db
, "utf16bin", SQLITE_UTF16
, 0,
3092 test_utf16bin_collate_func
3094 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
3098 Tcl_WrongNumArgs(interp
, 1, objv
, "DB");
3103 ** When the collation needed callback is invoked, record the name of
3104 ** the requested collating function here. The recorded name is linked
3105 ** to a TCL variable and used to make sure that the requested collation
3108 static char zNeededCollation
[200];
3109 static char *pzNeededCollation
= zNeededCollation
;
3113 ** Called when a collating sequence is needed. Registered using
3114 ** sqlite3_collation_needed16().
3116 static void test_collate_needed_cb(
3125 for(z
= (char*)pName
, i
=0; *z
|| z
[1]; z
++){
3126 if( *z
) zNeededCollation
[i
++] = *z
;
3128 zNeededCollation
[i
] = 0;
3129 sqlite3_create_collation(
3130 db
, "test_collate", ENC(db
), SQLITE_INT_TO_PTR(enc
), test_collate_func
);
3134 ** Usage: add_test_collate_needed DB
3136 static int SQLITE_TCLAPI
test_collate_needed(
3140 Tcl_Obj
*CONST objv
[]
3145 if( objc
!=2 ) goto bad_args
;
3146 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
3147 rc
= sqlite3_collation_needed16(db
, 0, test_collate_needed_cb
);
3148 zNeededCollation
[0] = 0;
3149 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
3153 Tcl_WrongNumArgs(interp
, 1, objv
, "DB");
3158 ** tclcmd: add_alignment_test_collations DB
3160 ** Add two new collating sequences to the database DB
3165 ** Both collating sequences use the same sort order as BINARY.
3166 ** The only difference is that the utf16_aligned collating
3167 ** sequence is declared with the SQLITE_UTF16_ALIGNED flag.
3168 ** Both collating functions increment the unaligned utf16 counter
3169 ** whenever they see a string that begins on an odd byte boundary.
3171 static int unaligned_string_counter
= 0;
3172 static int alignmentCollFunc(
3174 int nKey1
, const void *pKey1
,
3175 int nKey2
, const void *pKey2
3178 n
= nKey1
<nKey2
? nKey1
: nKey2
;
3179 if( nKey1
>0 && 1==(1&(SQLITE_PTR_TO_INT(pKey1
))) ) unaligned_string_counter
++;
3180 if( nKey2
>0 && 1==(1&(SQLITE_PTR_TO_INT(pKey2
))) ) unaligned_string_counter
++;
3181 rc
= memcmp(pKey1
, pKey2
, n
);
3187 static int SQLITE_TCLAPI
add_alignment_test_collations(
3191 Tcl_Obj
*CONST objv
[]
3195 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
3196 sqlite3_create_collation(db
, "utf16_unaligned", SQLITE_UTF16
,
3197 0, alignmentCollFunc
);
3198 sqlite3_create_collation(db
, "utf16_aligned", SQLITE_UTF16_ALIGNED
,
3199 0, alignmentCollFunc
);
3203 #endif /* !defined(SQLITE_OMIT_UTF16) */
3206 ** Usage: add_test_function <db ptr> <utf8> <utf16le> <utf16be>
3208 ** This function is used to test that SQLite selects the correct user
3209 ** function callback when multiple versions (for different text encodings)
3212 ** Calling this routine registers up to three versions of the user function
3213 ** "test_function" with database handle <db>. If the second argument is
3214 ** true, then a version of test_function is registered for UTF-8, if the
3215 ** third is true, a version is registered for UTF-16le, if the fourth is
3216 ** true, a UTF-16be version is available. Previous versions of
3217 ** test_function are deleted.
3219 ** The user function is implemented by calling the following TCL script:
3221 ** "test_function <enc> <arg>"
3223 ** Where <enc> is one of UTF-8, UTF-16LE or UTF16BE, and <arg> is the
3224 ** single argument passed to the SQL function. The value returned by
3225 ** the TCL script is used as the return value of the SQL function. It
3226 ** is passed to SQLite using UTF-16BE for a UTF-8 test_function(), UTF-8
3227 ** for a UTF-16LE test_function(), and UTF-16LE for an implementation that
3228 ** prefers UTF-16BE.
3230 #ifndef SQLITE_OMIT_UTF16
3231 static void test_function_utf8(
3232 sqlite3_context
*pCtx
,
3234 sqlite3_value
**argv
3238 sqlite3_value
*pVal
;
3239 interp
= (Tcl_Interp
*)sqlite3_user_data(pCtx
);
3240 pX
= Tcl_NewStringObj("test_function", -1);
3241 Tcl_IncrRefCount(pX
);
3242 Tcl_ListObjAppendElement(interp
, pX
, Tcl_NewStringObj("UTF-8", -1));
3243 Tcl_ListObjAppendElement(interp
, pX
,
3244 Tcl_NewStringObj((char*)sqlite3_value_text(argv
[0]), -1));
3245 Tcl_EvalObjEx(interp
, pX
, 0);
3246 Tcl_DecrRefCount(pX
);
3247 sqlite3_result_text(pCtx
, Tcl_GetStringResult(interp
), -1, SQLITE_TRANSIENT
);
3248 pVal
= sqlite3ValueNew(0);
3249 sqlite3ValueSetStr(pVal
, -1, Tcl_GetStringResult(interp
),
3250 SQLITE_UTF8
, SQLITE_STATIC
);
3251 sqlite3_result_text16be(pCtx
, sqlite3_value_text16be(pVal
),
3252 -1, SQLITE_TRANSIENT
);
3253 sqlite3ValueFree(pVal
);
3255 static void test_function_utf16le(
3256 sqlite3_context
*pCtx
,
3258 sqlite3_value
**argv
3262 sqlite3_value
*pVal
;
3263 interp
= (Tcl_Interp
*)sqlite3_user_data(pCtx
);
3264 pX
= Tcl_NewStringObj("test_function", -1);
3265 Tcl_IncrRefCount(pX
);
3266 Tcl_ListObjAppendElement(interp
, pX
, Tcl_NewStringObj("UTF-16LE", -1));
3267 Tcl_ListObjAppendElement(interp
, pX
,
3268 Tcl_NewStringObj((char*)sqlite3_value_text(argv
[0]), -1));
3269 Tcl_EvalObjEx(interp
, pX
, 0);
3270 Tcl_DecrRefCount(pX
);
3271 pVal
= sqlite3ValueNew(0);
3272 sqlite3ValueSetStr(pVal
, -1, Tcl_GetStringResult(interp
),
3273 SQLITE_UTF8
, SQLITE_STATIC
);
3274 sqlite3_result_text(pCtx
,(char*)sqlite3_value_text(pVal
),-1,SQLITE_TRANSIENT
);
3275 sqlite3ValueFree(pVal
);
3277 static void test_function_utf16be(
3278 sqlite3_context
*pCtx
,
3280 sqlite3_value
**argv
3284 sqlite3_value
*pVal
;
3285 interp
= (Tcl_Interp
*)sqlite3_user_data(pCtx
);
3286 pX
= Tcl_NewStringObj("test_function", -1);
3287 Tcl_IncrRefCount(pX
);
3288 Tcl_ListObjAppendElement(interp
, pX
, Tcl_NewStringObj("UTF-16BE", -1));
3289 Tcl_ListObjAppendElement(interp
, pX
,
3290 Tcl_NewStringObj((char*)sqlite3_value_text(argv
[0]), -1));
3291 Tcl_EvalObjEx(interp
, pX
, 0);
3292 Tcl_DecrRefCount(pX
);
3293 pVal
= sqlite3ValueNew(0);
3294 sqlite3ValueSetStr(pVal
, -1, Tcl_GetStringResult(interp
),
3295 SQLITE_UTF8
, SQLITE_STATIC
);
3296 sqlite3_result_text16(pCtx
, sqlite3_value_text16le(pVal
),
3297 -1, SQLITE_TRANSIENT
);
3298 sqlite3_result_text16be(pCtx
, sqlite3_value_text16le(pVal
),
3299 -1, SQLITE_TRANSIENT
);
3300 sqlite3_result_text16le(pCtx
, sqlite3_value_text16le(pVal
),
3301 -1, SQLITE_TRANSIENT
);
3302 sqlite3ValueFree(pVal
);
3304 #endif /* SQLITE_OMIT_UTF16 */
3305 static int SQLITE_TCLAPI
test_function(
3309 Tcl_Obj
*CONST objv
[]
3311 #ifndef SQLITE_OMIT_UTF16
3315 if( objc
!=5 ) goto bad_args
;
3316 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
3318 if( TCL_OK
!=Tcl_GetBooleanFromObj(interp
, objv
[2], &val
) ) return TCL_ERROR
;
3320 sqlite3_create_function(db
, "test_function", 1, SQLITE_UTF8
,
3321 interp
, test_function_utf8
, 0, 0);
3323 if( TCL_OK
!=Tcl_GetBooleanFromObj(interp
, objv
[3], &val
) ) return TCL_ERROR
;
3325 sqlite3_create_function(db
, "test_function", 1, SQLITE_UTF16LE
,
3326 interp
, test_function_utf16le
, 0, 0);
3328 if( TCL_OK
!=Tcl_GetBooleanFromObj(interp
, objv
[4], &val
) ) return TCL_ERROR
;
3330 sqlite3_create_function(db
, "test_function", 1, SQLITE_UTF16BE
,
3331 interp
, test_function_utf16be
, 0, 0);
3336 Tcl_AppendResult(interp
, "wrong # args: should be \"",
3337 Tcl_GetStringFromObj(objv
[0], 0), " <DB> <utf8> <utf16le> <utf16be>", 0);
3338 #endif /* SQLITE_OMIT_UTF16 */
3343 ** Usage: sqlite3_test_errstr <err code>
3345 ** Test that the english language string equivalents for sqlite error codes
3346 ** are sane. The parameter is an integer representing an sqlite error code.
3347 ** The result is a list of two elements, the string representation of the
3348 ** error code and the english language explanation.
3350 static int SQLITE_TCLAPI
test_errstr(
3354 Tcl_Obj
*CONST objv
[]
3359 Tcl_WrongNumArgs(interp
, 1, objv
, "<error code>");
3362 zCode
= Tcl_GetString(objv
[1]);
3363 for(i
=0; i
<200; i
++){
3364 if( 0==strcmp(t1ErrorName(i
), zCode
) ) break;
3366 Tcl_SetResult(interp
, (char *)sqlite3ErrStr(i
), 0);
3371 ** Usage: breakpoint
3373 ** This routine exists for one purpose - to provide a place to put a
3374 ** breakpoint with GDB that can be triggered using TCL code. The use
3375 ** for this is when a particular test fails on (say) the 1485th iteration.
3376 ** In the TCL test script, we can add code like this:
3378 ** if {$i==1485} breakpoint
3380 ** Then run testfixture in the debugger and wait for the breakpoint to
3381 ** fire. Then additional breakpoints can be set to trace down the bug.
3383 static int SQLITE_TCLAPI
test_breakpoint(
3385 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
3386 int argc
, /* Number of arguments */
3387 char **argv
/* Text of each argument */
3389 return TCL_OK
; /* Do nothing */
3393 ** Usage: sqlite3_bind_zeroblob STMT IDX N
3395 ** Test the sqlite3_bind_zeroblob interface. STMT is a prepared statement.
3396 ** IDX is the index of a wildcard in the prepared statement. This command
3397 ** binds a N-byte zero-filled BLOB to the wildcard.
3399 static int SQLITE_TCLAPI
test_bind_zeroblob(
3403 Tcl_Obj
*CONST objv
[]
3405 sqlite3_stmt
*pStmt
;
3411 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT IDX N");
3415 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
3416 if( Tcl_GetIntFromObj(interp
, objv
[2], &idx
) ) return TCL_ERROR
;
3417 if( Tcl_GetIntFromObj(interp
, objv
[3], &n
) ) return TCL_ERROR
;
3419 rc
= sqlite3_bind_zeroblob(pStmt
, idx
, n
);
3420 if( sqlite3TestErrCode(interp
, StmtToDb(pStmt
), rc
) ) return TCL_ERROR
;
3421 if( rc
!=SQLITE_OK
){
3429 ** Usage: sqlite3_bind_zeroblob64 STMT IDX N
3431 ** Test the sqlite3_bind_zeroblob64 interface. STMT is a prepared statement.
3432 ** IDX is the index of a wildcard in the prepared statement. This command
3433 ** binds a N-byte zero-filled BLOB to the wildcard.
3435 static int SQLITE_TCLAPI
test_bind_zeroblob64(
3439 Tcl_Obj
*CONST objv
[]
3441 sqlite3_stmt
*pStmt
;
3447 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT IDX N");
3451 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
3452 if( Tcl_GetIntFromObj(interp
, objv
[2], &idx
) ) return TCL_ERROR
;
3453 if( Tcl_GetWideIntFromObj(interp
, objv
[3], &n
) ) return TCL_ERROR
;
3455 rc
= sqlite3_bind_zeroblob64(pStmt
, idx
, n
);
3456 if( sqlite3TestErrCode(interp
, StmtToDb(pStmt
), rc
) ) return TCL_ERROR
;
3457 if( rc
!=SQLITE_OK
){
3458 Tcl_AppendResult(interp
, sqlite3ErrName(rc
), 0);
3466 ** Usage: sqlite3_bind_int STMT N VALUE
3468 ** Test the sqlite3_bind_int interface. STMT is a prepared statement.
3469 ** N is the index of a wildcard in the prepared statement. This command
3470 ** binds a 32-bit integer VALUE to that wildcard.
3472 static int SQLITE_TCLAPI
test_bind_int(
3476 Tcl_Obj
*CONST objv
[]
3478 sqlite3_stmt
*pStmt
;
3484 Tcl_AppendResult(interp
, "wrong # args: should be \"",
3485 Tcl_GetStringFromObj(objv
[0], 0), " STMT N VALUE", 0);
3489 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
3490 if( Tcl_GetIntFromObj(interp
, objv
[2], &idx
) ) return TCL_ERROR
;
3491 if( Tcl_GetIntFromObj(interp
, objv
[3], &value
) ) return TCL_ERROR
;
3493 rc
= sqlite3_bind_int(pStmt
, idx
, value
);
3494 if( sqlite3TestErrCode(interp
, StmtToDb(pStmt
), rc
) ) return TCL_ERROR
;
3495 if( rc
!=SQLITE_OK
){
3504 ** Usage: intarray_addr INT ...
3506 ** Return the address of a C-language array of 32-bit integers.
3508 ** Space to hold the array is obtained from malloc(). Call this procedure once
3509 ** with no arguments in order to release memory. Each call to this procedure
3510 ** overwrites the previous array.
3512 static int SQLITE_TCLAPI
test_intarray_addr(
3516 Tcl_Obj
*CONST objv
[]
3524 p
= sqlite3_malloc( sizeof(p
[0])*(objc
-1) );
3525 if( p
==0 ) return TCL_ERROR
;
3526 for(i
=0; i
<objc
-1; i
++){
3527 if( Tcl_GetIntFromObj(interp
, objv
[1+i
], &p
[i
]) ){
3534 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj((sqlite3_int64
)p
));
3538 ** Usage: intarray_addr INT ...
3540 ** Return the address of a C-language array of 32-bit integers.
3542 ** Space to hold the array is obtained from malloc(). Call this procedure once
3543 ** with no arguments in order to release memory. Each call to this procedure
3544 ** overwrites the previous array.
3546 static int SQLITE_TCLAPI
test_int64array_addr(
3550 Tcl_Obj
*CONST objv
[]
3553 static sqlite3_int64
*p
= 0;
3558 p
= sqlite3_malloc( sizeof(p
[0])*(objc
-1) );
3559 if( p
==0 ) return TCL_ERROR
;
3560 for(i
=0; i
<objc
-1; i
++){
3562 if( Tcl_GetWideIntFromObj(interp
, objv
[1+i
], &v
) ){
3570 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj((sqlite3_int64
)p
));
3574 ** Usage: doublearray_addr INT ...
3576 ** Return the address of a C-language array of doubles.
3578 ** Space to hold the array is obtained from malloc(). Call this procedure once
3579 ** with no arguments in order to release memory. Each call to this procedure
3580 ** overwrites the previous array.
3582 static int SQLITE_TCLAPI
test_doublearray_addr(
3586 Tcl_Obj
*CONST objv
[]
3589 static double *p
= 0;
3594 p
= sqlite3_malloc( sizeof(p
[0])*(objc
-1) );
3595 if( p
==0 ) return TCL_ERROR
;
3596 for(i
=0; i
<objc
-1; i
++){
3597 if( Tcl_GetDoubleFromObj(interp
, objv
[1+i
], &p
[i
]) ){
3604 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj((sqlite3_int64
)p
));
3608 ** Usage: textarray_addr TEXT ...
3610 ** Return the address of a C-language array of strings.
3612 ** Space to hold the array is obtained from malloc(). Call this procedure once
3613 ** with no arguments in order to release memory. Each call to this procedure
3614 ** overwrites the previous array.
3616 static int SQLITE_TCLAPI
test_textarray_addr(
3620 Tcl_Obj
*CONST objv
[]
3624 static char **p
= 0;
3626 for(i
=0; i
<n
; i
++) sqlite3_free(p
[i
]);
3630 p
= sqlite3_malloc( sizeof(p
[0])*(objc
-1) );
3631 if( p
==0 ) return TCL_ERROR
;
3632 for(i
=0; i
<objc
-1; i
++){
3633 p
[i
] = sqlite3_mprintf("%s", Tcl_GetString(objv
[1+i
]));
3637 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj((sqlite3_int64
)p
));
3643 ** Usage: sqlite3_bind_int64 STMT N VALUE
3645 ** Test the sqlite3_bind_int64 interface. STMT is a prepared statement.
3646 ** N is the index of a wildcard in the prepared statement. This command
3647 ** binds a 64-bit integer VALUE to that wildcard.
3649 static int SQLITE_TCLAPI
test_bind_int64(
3653 Tcl_Obj
*CONST objv
[]
3655 sqlite3_stmt
*pStmt
;
3661 Tcl_AppendResult(interp
, "wrong # args: should be \"",
3662 Tcl_GetStringFromObj(objv
[0], 0), " STMT N VALUE", 0);
3666 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
3667 if( Tcl_GetIntFromObj(interp
, objv
[2], &idx
) ) return TCL_ERROR
;
3668 if( Tcl_GetWideIntFromObj(interp
, objv
[3], &value
) ) return TCL_ERROR
;
3670 rc
= sqlite3_bind_int64(pStmt
, idx
, value
);
3671 if( sqlite3TestErrCode(interp
, StmtToDb(pStmt
), rc
) ) return TCL_ERROR
;
3672 if( rc
!=SQLITE_OK
){
3681 ** Usage: sqlite3_bind_double STMT N VALUE
3683 ** Test the sqlite3_bind_double interface. STMT is a prepared statement.
3684 ** N is the index of a wildcard in the prepared statement. This command
3685 ** binds a 64-bit integer VALUE to that wildcard.
3687 static int SQLITE_TCLAPI
test_bind_double(
3691 Tcl_Obj
*CONST objv
[]
3693 sqlite3_stmt
*pStmt
;
3699 static const struct {
3700 const char *zName
; /* Name of the special floating point value */
3701 unsigned int iUpper
; /* Upper 32 bits */
3702 unsigned int iLower
; /* Lower 32 bits */
3704 { "NaN", 0x7fffffff, 0xffffffff },
3705 { "SNaN", 0x7ff7ffff, 0xffffffff },
3706 { "-NaN", 0xffffffff, 0xffffffff },
3707 { "-SNaN", 0xfff7ffff, 0xffffffff },
3708 { "+Inf", 0x7ff00000, 0x00000000 },
3709 { "-Inf", 0xfff00000, 0x00000000 },
3710 { "Epsilon", 0x00000000, 0x00000001 },
3711 { "-Epsilon", 0x80000000, 0x00000001 },
3712 { "NaN0", 0x7ff80000, 0x00000000 },
3713 { "-NaN0", 0xfff80000, 0x00000000 },
3717 Tcl_AppendResult(interp
, "wrong # args: should be \"",
3718 Tcl_GetStringFromObj(objv
[0], 0), " STMT N VALUE", 0);
3722 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
3723 if( Tcl_GetIntFromObj(interp
, objv
[2], &idx
) ) return TCL_ERROR
;
3725 /* Intercept the string "NaN" and generate a NaN value for it.
3726 ** All other strings are passed through to Tcl_GetDoubleFromObj().
3727 ** Tcl_GetDoubleFromObj() should understand "NaN" but some versions
3730 zVal
= Tcl_GetString(objv
[3]);
3731 for(i
=0; i
<sizeof(aSpecialFp
)/sizeof(aSpecialFp
[0]); i
++){
3732 if( strcmp(aSpecialFp
[i
].zName
, zVal
)==0 ){
3734 x
= aSpecialFp
[i
].iUpper
;
3736 x
|= aSpecialFp
[i
].iLower
;
3737 assert( sizeof(value
)==8 );
3738 assert( sizeof(x
)==8 );
3739 memcpy(&value
, &x
, 8);
3743 if( i
>=sizeof(aSpecialFp
)/sizeof(aSpecialFp
[0]) &&
3744 Tcl_GetDoubleFromObj(interp
, objv
[3], &value
) ){
3747 rc
= sqlite3_bind_double(pStmt
, idx
, value
);
3748 if( sqlite3TestErrCode(interp
, StmtToDb(pStmt
), rc
) ) return TCL_ERROR
;
3749 if( rc
!=SQLITE_OK
){
3757 ** Usage: sqlite3_bind_null STMT N
3759 ** Test the sqlite3_bind_null interface. STMT is a prepared statement.
3760 ** N is the index of a wildcard in the prepared statement. This command
3761 ** binds a NULL to the wildcard.
3763 static int SQLITE_TCLAPI
test_bind_null(
3767 Tcl_Obj
*CONST objv
[]
3769 sqlite3_stmt
*pStmt
;
3774 Tcl_AppendResult(interp
, "wrong # args: should be \"",
3775 Tcl_GetStringFromObj(objv
[0], 0), " STMT N", 0);
3779 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
3780 if( Tcl_GetIntFromObj(interp
, objv
[2], &idx
) ) return TCL_ERROR
;
3782 rc
= sqlite3_bind_null(pStmt
, idx
);
3783 if( sqlite3TestErrCode(interp
, StmtToDb(pStmt
), rc
) ) return TCL_ERROR
;
3784 if( rc
!=SQLITE_OK
){
3792 ** Usage: sqlite3_bind_text STMT N STRING BYTES
3794 ** Test the sqlite3_bind_text interface. STMT is a prepared statement.
3795 ** N is the index of a wildcard in the prepared statement. This command
3796 ** binds a UTF-8 string STRING to the wildcard. The string is BYTES bytes
3799 static int SQLITE_TCLAPI
test_bind_text(
3803 Tcl_Obj
*CONST objv
[]
3805 sqlite3_stmt
*pStmt
;
3812 Tcl_AppendResult(interp
, "wrong # args: should be \"",
3813 Tcl_GetStringFromObj(objv
[0], 0), " STMT N VALUE BYTES", 0);
3817 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
3818 if( Tcl_GetIntFromObj(interp
, objv
[2], &idx
) ) return TCL_ERROR
;
3819 value
= (char*)Tcl_GetByteArrayFromObj(objv
[3], &bytes
);
3820 if( Tcl_GetIntFromObj(interp
, objv
[4], &bytes
) ) return TCL_ERROR
;
3822 rc
= sqlite3_bind_text(pStmt
, idx
, value
, bytes
, SQLITE_TRANSIENT
);
3823 if( sqlite3TestErrCode(interp
, StmtToDb(pStmt
), rc
) ) return TCL_ERROR
;
3824 if( rc
!=SQLITE_OK
){
3825 Tcl_AppendResult(interp
, sqlite3ErrName(rc
), 0);
3833 ** Usage: sqlite3_bind_text16 ?-static? STMT N STRING BYTES
3835 ** Test the sqlite3_bind_text16 interface. STMT is a prepared statement.
3836 ** N is the index of a wildcard in the prepared statement. This command
3837 ** binds a UTF-16 string STRING to the wildcard. The string is BYTES bytes
3840 static int SQLITE_TCLAPI
test_bind_text16(
3844 Tcl_Obj
*CONST objv
[]
3846 #ifndef SQLITE_OMIT_UTF16
3847 sqlite3_stmt
*pStmt
;
3853 void (*xDel
)(void*) = (objc
==6?SQLITE_STATIC
:SQLITE_TRANSIENT
);
3854 Tcl_Obj
*oStmt
= objv
[objc
-4];
3855 Tcl_Obj
*oN
= objv
[objc
-3];
3856 Tcl_Obj
*oString
= objv
[objc
-2];
3857 Tcl_Obj
*oBytes
= objv
[objc
-1];
3859 if( objc
!=5 && objc
!=6){
3860 Tcl_AppendResult(interp
, "wrong # args: should be \"",
3861 Tcl_GetStringFromObj(objv
[0], 0), " STMT N VALUE BYTES", 0);
3865 if( getStmtPointer(interp
, Tcl_GetString(oStmt
), &pStmt
) ) return TCL_ERROR
;
3866 if( Tcl_GetIntFromObj(interp
, oN
, &idx
) ) return TCL_ERROR
;
3867 value
= (char*)Tcl_GetByteArrayFromObj(oString
, 0);
3868 if( Tcl_GetIntFromObj(interp
, oBytes
, &bytes
) ) return TCL_ERROR
;
3870 rc
= sqlite3_bind_text16(pStmt
, idx
, (void *)value
, bytes
, xDel
);
3871 if( sqlite3TestErrCode(interp
, StmtToDb(pStmt
), rc
) ) return TCL_ERROR
;
3872 if( rc
!=SQLITE_OK
){
3873 Tcl_AppendResult(interp
, sqlite3ErrName(rc
), 0);
3877 #endif /* SQLITE_OMIT_UTF16 */
3882 ** Usage: sqlite3_bind_blob ?-static? STMT N DATA BYTES
3884 ** Test the sqlite3_bind_blob interface. STMT is a prepared statement.
3885 ** N is the index of a wildcard in the prepared statement. This command
3886 ** binds a BLOB to the wildcard. The BLOB is BYTES bytes in size.
3888 static int SQLITE_TCLAPI
test_bind_blob(
3892 Tcl_Obj
*CONST objv
[]
3894 sqlite3_stmt
*pStmt
;
3899 sqlite3_destructor_type xDestructor
= SQLITE_TRANSIENT
;
3901 if( objc
!=5 && objc
!=6 ){
3902 Tcl_AppendResult(interp
, "wrong # args: should be \"",
3903 Tcl_GetStringFromObj(objv
[0], 0), " STMT N DATA BYTES", 0);
3908 xDestructor
= SQLITE_STATIC
;
3912 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
3913 if( Tcl_GetIntFromObj(interp
, objv
[2], &idx
) ) return TCL_ERROR
;
3915 value
= (char*)Tcl_GetByteArrayFromObj(objv
[3], &len
);
3916 if( Tcl_GetIntFromObj(interp
, objv
[4], &bytes
) ) return TCL_ERROR
;
3920 sqlite3_snprintf(sizeof(zBuf
), zBuf
,
3921 "cannot use %d blob bytes, have %d", bytes
, len
);
3922 Tcl_AppendResult(interp
, zBuf
, -1);
3926 rc
= sqlite3_bind_blob(pStmt
, idx
, value
, bytes
, xDestructor
);
3927 if( sqlite3TestErrCode(interp
, StmtToDb(pStmt
), rc
) ) return TCL_ERROR
;
3928 if( rc
!=SQLITE_OK
){
3936 ** Usage: sqlite3_bind_parameter_count STMT
3938 ** Return the number of wildcards in the given statement.
3940 static int SQLITE_TCLAPI
test_bind_parameter_count(
3944 Tcl_Obj
*CONST objv
[]
3946 sqlite3_stmt
*pStmt
;
3949 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT");
3952 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
3953 Tcl_SetObjResult(interp
, Tcl_NewIntObj(sqlite3_bind_parameter_count(pStmt
)));
3958 ** Usage: sqlite3_bind_parameter_name STMT N
3960 ** Return the name of the Nth wildcard. The first wildcard is 1.
3961 ** An empty string is returned if N is out of range or if the wildcard
3964 static int SQLITE_TCLAPI
test_bind_parameter_name(
3968 Tcl_Obj
*CONST objv
[]
3970 sqlite3_stmt
*pStmt
;
3974 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT N");
3977 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
3978 if( Tcl_GetIntFromObj(interp
, objv
[2], &i
) ) return TCL_ERROR
;
3979 Tcl_SetObjResult(interp
,
3980 Tcl_NewStringObj(sqlite3_bind_parameter_name(pStmt
,i
),-1)
3986 ** Usage: sqlite3_bind_parameter_index STMT NAME
3988 ** Return the index of the wildcard called NAME. Return 0 if there is
3989 ** no such wildcard.
3991 static int SQLITE_TCLAPI
test_bind_parameter_index(
3995 Tcl_Obj
*CONST objv
[]
3997 sqlite3_stmt
*pStmt
;
4000 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT NAME");
4003 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4004 Tcl_SetObjResult(interp
,
4006 sqlite3_bind_parameter_index(pStmt
,Tcl_GetString(objv
[2]))
4013 ** Usage: sqlite3_clear_bindings STMT
4016 static int SQLITE_TCLAPI
test_clear_bindings(
4020 Tcl_Obj
*CONST objv
[]
4022 sqlite3_stmt
*pStmt
;
4025 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT");
4028 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4029 Tcl_SetObjResult(interp
, Tcl_NewIntObj(sqlite3_clear_bindings(pStmt
)));
4034 ** Usage: sqlite3_sleep MILLISECONDS
4036 static int SQLITE_TCLAPI
test_sleep(
4040 Tcl_Obj
*CONST objv
[]
4045 Tcl_WrongNumArgs(interp
, 1, objv
, "MILLISECONDS");
4048 if( Tcl_GetIntFromObj(interp
, objv
[1], &ms
) ){
4051 Tcl_SetObjResult(interp
, Tcl_NewIntObj(sqlite3_sleep(ms
)));
4056 ** Usage: sqlite3_extended_errcode DB
4058 ** Return the string representation of the most recent sqlite3_* API
4059 ** error code. e.g. "SQLITE_ERROR".
4061 static int SQLITE_TCLAPI
test_ex_errcode(
4065 Tcl_Obj
*CONST objv
[]
4071 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4072 Tcl_GetString(objv
[0]), " DB", 0);
4075 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
4076 rc
= sqlite3_extended_errcode(db
);
4077 Tcl_AppendResult(interp
, (char *)t1ErrorName(rc
), 0);
4083 ** Usage: sqlite3_errcode DB
4085 ** Return the string representation of the most recent sqlite3_* API
4086 ** error code. e.g. "SQLITE_ERROR".
4088 static int SQLITE_TCLAPI
test_errcode(
4092 Tcl_Obj
*CONST objv
[]
4098 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4099 Tcl_GetString(objv
[0]), " DB", 0);
4102 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
4103 rc
= sqlite3_errcode(db
);
4104 Tcl_AppendResult(interp
, (char *)t1ErrorName(rc
), 0);
4109 ** Usage: sqlite3_errmsg DB
4111 ** Returns the UTF-8 representation of the error message string for the
4112 ** most recent sqlite3_* API call.
4114 static int SQLITE_TCLAPI
test_errmsg(
4118 Tcl_Obj
*CONST objv
[]
4124 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4125 Tcl_GetString(objv
[0]), " DB", 0);
4128 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
4130 zErr
= sqlite3_errmsg(db
);
4131 Tcl_SetObjResult(interp
, Tcl_NewStringObj(zErr
, -1));
4136 ** Usage: test_errmsg16 DB
4138 ** Returns the UTF-16 representation of the error message string for the
4139 ** most recent sqlite3_* API call. This is a byte array object at the TCL
4140 ** level, and it includes the 0x00 0x00 terminator bytes at the end of the
4143 static int SQLITE_TCLAPI
test_errmsg16(
4147 Tcl_Obj
*CONST objv
[]
4149 #ifndef SQLITE_OMIT_UTF16
4156 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4157 Tcl_GetString(objv
[0]), " DB", 0);
4160 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
4162 zErr
= sqlite3_errmsg16(db
);
4165 for(bytes
=0; z
[bytes
] || z
[bytes
+1]; bytes
+=2){}
4167 Tcl_SetObjResult(interp
, Tcl_NewByteArrayObj(zErr
, bytes
));
4168 #endif /* SQLITE_OMIT_UTF16 */
4173 ** Usage: sqlite3_prepare DB sql bytes ?tailvar?
4175 ** Compile up to <bytes> bytes of the supplied SQL string <sql> using
4176 ** database handle <DB>. The parameter <tailval> is the name of a global
4177 ** variable that is set to the unused portion of <sql> (if any). A
4178 ** STMT handle is returned.
4180 static int SQLITE_TCLAPI
test_prepare(
4184 Tcl_Obj
*CONST objv
[]
4189 const char *zTail
= 0;
4190 sqlite3_stmt
*pStmt
= 0;
4194 if( objc
!=5 && objc
!=4 ){
4195 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4196 Tcl_GetString(objv
[0]), " DB sql bytes ?tailvar?", 0);
4199 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
4200 zSql
= Tcl_GetString(objv
[2]);
4201 if( Tcl_GetIntFromObj(interp
, objv
[3], &bytes
) ) return TCL_ERROR
;
4203 rc
= sqlite3_prepare(db
, zSql
, bytes
, &pStmt
, objc
>=5 ? &zTail
: 0);
4204 Tcl_ResetResult(interp
);
4205 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
4206 if( zTail
&& objc
>=5 ){
4208 bytes
= bytes
- (int)(zTail
-zSql
);
4210 if( (int)strlen(zTail
)<bytes
){
4211 bytes
= (int)strlen(zTail
);
4213 Tcl_ObjSetVar2(interp
, objv
[4], 0, Tcl_NewStringObj(zTail
, bytes
), 0);
4215 if( rc
!=SQLITE_OK
){
4217 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "(%d) ", rc
);
4218 Tcl_AppendResult(interp
, zBuf
, sqlite3_errmsg(db
), 0);
4223 if( sqlite3TestMakePointerStr(interp
, zBuf
, pStmt
) ) return TCL_ERROR
;
4224 Tcl_AppendResult(interp
, zBuf
, 0);
4230 ** Usage: sqlite3_prepare_v2 DB sql bytes ?tailvar?
4232 ** Compile up to <bytes> bytes of the supplied SQL string <sql> using
4233 ** database handle <DB>. The parameter <tailval> is the name of a global
4234 ** variable that is set to the unused portion of <sql> (if any). A
4235 ** STMT handle is returned.
4237 static int SQLITE_TCLAPI
test_prepare_v2(
4241 Tcl_Obj
*CONST objv
[]
4245 char *zCopy
= 0; /* malloc() copy of zSql */
4247 const char *zTail
= 0;
4248 const char **pzTail
;
4249 sqlite3_stmt
*pStmt
= 0;
4253 if( objc
!=5 && objc
!=4 ){
4254 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4255 Tcl_GetString(objv
[0]), " DB sql bytes tailvar", 0);
4258 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
4259 zSql
= Tcl_GetString(objv
[2]);
4260 if( Tcl_GetIntFromObj(interp
, objv
[3], &bytes
) ) return TCL_ERROR
;
4262 /* Instead of using zSql directly, make a copy into a buffer obtained
4263 ** directly from malloc(). The idea is to make it easier for valgrind
4264 ** to spot buffer overreads. */
4266 zCopy
= malloc(bytes
);
4267 memcpy(zCopy
, zSql
, bytes
);
4269 int n
= (int)strlen(zSql
) + 1;
4271 memcpy(zCopy
, zSql
, n
);
4273 pzTail
= objc
>=5 ? &zTail
: 0;
4274 rc
= sqlite3_prepare_v2(db
, zCopy
, bytes
, &pStmt
, pzTail
);
4276 zTail
= &zSql
[(zTail
- zCopy
)];
4280 assert(rc
==SQLITE_OK
|| pStmt
==0);
4281 Tcl_ResetResult(interp
);
4282 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
4283 if( rc
==SQLITE_OK
&& objc
>=5 && zTail
){
4285 bytes
= bytes
- (int)(zTail
-zSql
);
4287 Tcl_ObjSetVar2(interp
, objv
[4], 0, Tcl_NewStringObj(zTail
, bytes
), 0);
4289 if( rc
!=SQLITE_OK
){
4291 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "(%d) ", rc
);
4292 Tcl_AppendResult(interp
, zBuf
, sqlite3_errmsg(db
), 0);
4297 if( sqlite3TestMakePointerStr(interp
, zBuf
, pStmt
) ) return TCL_ERROR
;
4298 Tcl_AppendResult(interp
, zBuf
, 0);
4304 ** Usage: sqlite3_prepare_v3 DB sql bytes flags ?tailvar?
4306 ** Compile up to <bytes> bytes of the supplied SQL string <sql> using
4307 ** database handle <DB> and flags <flags>. The parameter <tailval> is
4308 ** the name of a global variable that is set to the unused portion of
4309 ** <sql> (if any). A STMT handle is returned.
4311 static int SQLITE_TCLAPI
test_prepare_v3(
4315 Tcl_Obj
*CONST objv
[]
4319 char *zCopy
= 0; /* malloc() copy of zSql */
4321 const char *zTail
= 0;
4322 const char **pzTail
;
4323 sqlite3_stmt
*pStmt
= 0;
4327 if( objc
!=6 && objc
!=5 ){
4328 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4329 Tcl_GetString(objv
[0]), " DB sql bytes flags tailvar", 0);
4332 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
4333 zSql
= Tcl_GetString(objv
[2]);
4334 if( Tcl_GetIntFromObj(interp
, objv
[3], &bytes
) ) return TCL_ERROR
;
4335 if( Tcl_GetIntFromObj(interp
, objv
[4], &flags
) ) return TCL_ERROR
;
4337 /* Instead of using zSql directly, make a copy into a buffer obtained
4338 ** directly from malloc(). The idea is to make it easier for valgrind
4339 ** to spot buffer overreads. */
4341 zCopy
= malloc(bytes
);
4342 memcpy(zCopy
, zSql
, bytes
);
4344 int n
= (int)strlen(zSql
) + 1;
4346 memcpy(zCopy
, zSql
, n
);
4348 pzTail
= objc
>=6 ? &zTail
: 0;
4349 rc
= sqlite3_prepare_v3(db
, zCopy
, bytes
, (unsigned int)flags
,&pStmt
,pzTail
);
4351 zTail
= &zSql
[(zTail
- zCopy
)];
4353 assert(rc
==SQLITE_OK
|| pStmt
==0);
4354 Tcl_ResetResult(interp
);
4355 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
4356 if( rc
==SQLITE_OK
&& zTail
&& objc
>=6 ){
4358 bytes
= bytes
- (int)(zTail
-zSql
);
4360 Tcl_ObjSetVar2(interp
, objv
[5], 0, Tcl_NewStringObj(zTail
, bytes
), 0);
4362 if( rc
!=SQLITE_OK
){
4364 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "(%d) ", rc
);
4365 Tcl_AppendResult(interp
, zBuf
, sqlite3_errmsg(db
), 0);
4370 if( sqlite3TestMakePointerStr(interp
, zBuf
, pStmt
) ) return TCL_ERROR
;
4371 Tcl_AppendResult(interp
, zBuf
, 0);
4377 ** Usage: sqlite3_prepare_tkt3134 DB
4379 ** Generate a prepared statement for a zero-byte string as a test
4380 ** for ticket #3134. The string should be preceded by a zero byte.
4382 static int SQLITE_TCLAPI
test_prepare_tkt3134(
4386 Tcl_Obj
*CONST objv
[]
4389 static const char zSql
[] = "\000SELECT 1";
4390 sqlite3_stmt
*pStmt
= 0;
4395 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4396 Tcl_GetString(objv
[0]), " DB sql bytes tailvar", 0);
4399 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
4400 rc
= sqlite3_prepare_v2(db
, &zSql
[1], 0, &pStmt
, 0);
4401 assert(rc
==SQLITE_OK
|| pStmt
==0);
4402 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
4403 if( rc
!=SQLITE_OK
){
4405 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "(%d) ", rc
);
4406 Tcl_AppendResult(interp
, zBuf
, sqlite3_errmsg(db
), 0);
4411 if( sqlite3TestMakePointerStr(interp
, zBuf
, pStmt
) ) return TCL_ERROR
;
4412 Tcl_AppendResult(interp
, zBuf
, 0);
4418 ** Usage: sqlite3_prepare16 DB sql bytes tailvar
4420 ** Compile up to <bytes> bytes of the supplied SQL string <sql> using
4421 ** database handle <DB>. The parameter <tailval> is the name of a global
4422 ** variable that is set to the unused portion of <sql> (if any). A
4423 ** STMT handle is returned.
4425 static int SQLITE_TCLAPI
test_prepare16(
4429 Tcl_Obj
*CONST objv
[]
4431 #ifndef SQLITE_OMIT_UTF16
4434 const void *zTail
= 0;
4436 sqlite3_stmt
*pStmt
= 0;
4439 int bytes
; /* The integer specified as arg 3 */
4440 int objlen
; /* The byte-array length of arg 2 */
4442 if( objc
!=5 && objc
!=4 ){
4443 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4444 Tcl_GetString(objv
[0]), " DB sql bytes ?tailvar?", 0);
4447 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
4448 zSql
= Tcl_GetByteArrayFromObj(objv
[2], &objlen
);
4449 if( Tcl_GetIntFromObj(interp
, objv
[3], &bytes
) ) return TCL_ERROR
;
4451 rc
= sqlite3_prepare16(db
, zSql
, bytes
, &pStmt
, objc
>=5 ? &zTail
: 0);
4452 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
4459 objlen
= objlen
- (int)((u8
*)zTail
-(u8
*)zSql
);
4463 pTail
= Tcl_NewByteArrayObj((u8
*)zTail
, objlen
);
4464 Tcl_IncrRefCount(pTail
);
4465 Tcl_ObjSetVar2(interp
, objv
[4], 0, pTail
, 0);
4466 Tcl_DecrRefCount(pTail
);
4470 if( sqlite3TestMakePointerStr(interp
, zBuf
, pStmt
) ) return TCL_ERROR
;
4472 Tcl_AppendResult(interp
, zBuf
, 0);
4473 #endif /* SQLITE_OMIT_UTF16 */
4478 ** Usage: sqlite3_prepare16_v2 DB sql bytes ?tailvar?
4480 ** Compile up to <bytes> bytes of the supplied SQL string <sql> using
4481 ** database handle <DB>. The parameter <tailval> is the name of a global
4482 ** variable that is set to the unused portion of <sql> (if any). A
4483 ** STMT handle is returned.
4485 static int SQLITE_TCLAPI
test_prepare16_v2(
4489 Tcl_Obj
*CONST objv
[]
4491 #ifndef SQLITE_OMIT_UTF16
4494 const void *zTail
= 0;
4496 sqlite3_stmt
*pStmt
= 0;
4499 int bytes
; /* The integer specified as arg 3 */
4500 int objlen
; /* The byte-array length of arg 2 */
4502 if( objc
!=5 && objc
!=4 ){
4503 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4504 Tcl_GetString(objv
[0]), " DB sql bytes ?tailvar?", 0);
4507 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
4508 zSql
= Tcl_GetByteArrayFromObj(objv
[2], &objlen
);
4509 if( Tcl_GetIntFromObj(interp
, objv
[3], &bytes
) ) return TCL_ERROR
;
4511 rc
= sqlite3_prepare16_v2(db
, zSql
, bytes
, &pStmt
, objc
>=5 ? &zTail
: 0);
4512 if( sqlite3TestErrCode(interp
, db
, rc
) ) return TCL_ERROR
;
4519 objlen
= objlen
- (int)((u8
*)zTail
-(u8
*)zSql
);
4523 pTail
= Tcl_NewByteArrayObj((u8
*)zTail
, objlen
);
4524 Tcl_IncrRefCount(pTail
);
4525 Tcl_ObjSetVar2(interp
, objv
[4], 0, pTail
, 0);
4526 Tcl_DecrRefCount(pTail
);
4530 if( sqlite3TestMakePointerStr(interp
, zBuf
, pStmt
) ) return TCL_ERROR
;
4532 Tcl_AppendResult(interp
, zBuf
, 0);
4533 #endif /* SQLITE_OMIT_UTF16 */
4538 ** Usage: sqlite3_open filename ?options-list?
4540 static int SQLITE_TCLAPI
test_open(
4544 Tcl_Obj
*CONST objv
[]
4546 const char *zFilename
;
4550 if( objc
!=3 && objc
!=2 && objc
!=1 ){
4551 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4552 Tcl_GetString(objv
[0]), " filename options-list", 0);
4556 zFilename
= objc
>1 ? Tcl_GetString(objv
[1]) : 0;
4557 sqlite3_open(zFilename
, &db
);
4559 if( sqlite3TestMakePointerStr(interp
, zBuf
, db
) ) return TCL_ERROR
;
4560 Tcl_AppendResult(interp
, zBuf
, 0);
4565 ** Usage: sqlite3_open_v2 FILENAME FLAGS VFS
4567 static int SQLITE_TCLAPI
test_open_v2(
4571 Tcl_Obj
*CONST objv
[]
4573 const char *zFilename
;
4585 Tcl_WrongNumArgs(interp
, 1, objv
, "FILENAME FLAGS VFS");
4588 zFilename
= Tcl_GetString(objv
[1]);
4589 zVfs
= Tcl_GetString(objv
[3]);
4590 if( zVfs
[0]==0x00 ) zVfs
= 0;
4592 rc
= Tcl_ListObjGetElements(interp
, objv
[2], &nFlag
, &apFlag
);
4593 if( rc
!=TCL_OK
) return rc
;
4594 for(i
=0; i
<nFlag
; i
++){
4600 { "SQLITE_OPEN_READONLY", SQLITE_OPEN_READONLY
},
4601 { "SQLITE_OPEN_READWRITE", SQLITE_OPEN_READWRITE
},
4602 { "SQLITE_OPEN_CREATE", SQLITE_OPEN_CREATE
},
4603 { "SQLITE_OPEN_DELETEONCLOSE", SQLITE_OPEN_DELETEONCLOSE
},
4604 { "SQLITE_OPEN_EXCLUSIVE", SQLITE_OPEN_EXCLUSIVE
},
4605 { "SQLITE_OPEN_AUTOPROXY", SQLITE_OPEN_AUTOPROXY
},
4606 { "SQLITE_OPEN_MAIN_DB", SQLITE_OPEN_MAIN_DB
},
4607 { "SQLITE_OPEN_TEMP_DB", SQLITE_OPEN_TEMP_DB
},
4608 { "SQLITE_OPEN_TRANSIENT_DB", SQLITE_OPEN_TRANSIENT_DB
},
4609 { "SQLITE_OPEN_MAIN_JOURNAL", SQLITE_OPEN_MAIN_JOURNAL
},
4610 { "SQLITE_OPEN_TEMP_JOURNAL", SQLITE_OPEN_TEMP_JOURNAL
},
4611 { "SQLITE_OPEN_SUBJOURNAL", SQLITE_OPEN_SUBJOURNAL
},
4612 { "SQLITE_OPEN_MASTER_JOURNAL", SQLITE_OPEN_MASTER_JOURNAL
},
4613 { "SQLITE_OPEN_NOMUTEX", SQLITE_OPEN_NOMUTEX
},
4614 { "SQLITE_OPEN_FULLMUTEX", SQLITE_OPEN_FULLMUTEX
},
4615 { "SQLITE_OPEN_SHAREDCACHE", SQLITE_OPEN_SHAREDCACHE
},
4616 { "SQLITE_OPEN_PRIVATECACHE", SQLITE_OPEN_PRIVATECACHE
},
4617 { "SQLITE_OPEN_WAL", SQLITE_OPEN_WAL
},
4618 { "SQLITE_OPEN_URI", SQLITE_OPEN_URI
},
4621 rc
= Tcl_GetIndexFromObjStruct(interp
, apFlag
[i
], aFlag
, sizeof(aFlag
[0]),
4624 if( rc
!=TCL_OK
) return rc
;
4625 flags
|= aFlag
[iFlag
].flag
;
4628 rc
= sqlite3_open_v2(zFilename
, &db
, flags
, zVfs
);
4629 if( sqlite3TestMakePointerStr(interp
, zBuf
, db
) ) return TCL_ERROR
;
4630 Tcl_AppendResult(interp
, zBuf
, 0);
4635 ** Usage: sqlite3_open16 filename options
4637 static int SQLITE_TCLAPI
test_open16(
4641 Tcl_Obj
*CONST objv
[]
4643 #ifndef SQLITE_OMIT_UTF16
4644 const void *zFilename
;
4649 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4650 Tcl_GetString(objv
[0]), " filename options-list", 0);
4654 zFilename
= Tcl_GetByteArrayFromObj(objv
[1], 0);
4655 sqlite3_open16(zFilename
, &db
);
4657 if( sqlite3TestMakePointerStr(interp
, zBuf
, db
) ) return TCL_ERROR
;
4658 Tcl_AppendResult(interp
, zBuf
, 0);
4659 #endif /* SQLITE_OMIT_UTF16 */
4664 ** Usage: sqlite3_complete16 <UTF-16 string>
4666 ** Return 1 if the supplied argument is a complete SQL statement, or zero
4669 static int SQLITE_TCLAPI
test_complete16(
4673 Tcl_Obj
*CONST objv
[]
4675 #if !defined(SQLITE_OMIT_COMPLETE) && !defined(SQLITE_OMIT_UTF16)
4679 Tcl_WrongNumArgs(interp
, 1, objv
, "<utf-16 sql>");
4683 zBuf
= (char*)Tcl_GetByteArrayFromObj(objv
[1], 0);
4684 Tcl_SetObjResult(interp
, Tcl_NewIntObj(sqlite3_complete16(zBuf
)));
4685 #endif /* SQLITE_OMIT_COMPLETE && SQLITE_OMIT_UTF16 */
4690 ** Usage: sqlite3_normalize SQL
4692 ** Return the normalized value for an SQL statement.
4694 static int SQLITE_TCLAPI
test_normalize(
4698 Tcl_Obj
*CONST objv
[]
4702 extern char *sqlite3_normalize(const char*);
4705 Tcl_WrongNumArgs(interp
, 1, objv
, "SQL");
4709 zSql
= (char*)Tcl_GetString(objv
[1]);
4710 zNorm
= sqlite3_normalize(zSql
);
4712 Tcl_SetObjResult(interp
, Tcl_NewStringObj(zNorm
, -1));
4713 sqlite3_free(zNorm
);
4719 ** Usage: sqlite3_step STMT
4721 ** Advance the statement to the next row.
4723 static int SQLITE_TCLAPI
test_step(
4727 Tcl_Obj
*CONST objv
[]
4729 sqlite3_stmt
*pStmt
;
4733 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4734 Tcl_GetString(objv
[0]), " STMT", 0);
4738 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4739 rc
= sqlite3_step(pStmt
);
4741 /* if( rc!=SQLITE_DONE && rc!=SQLITE_ROW ) return TCL_ERROR; */
4742 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), 0);
4746 static int SQLITE_TCLAPI
test_sql(
4750 Tcl_Obj
*CONST objv
[]
4752 sqlite3_stmt
*pStmt
;
4755 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT");
4759 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4760 Tcl_SetResult(interp
, (char *)sqlite3_sql(pStmt
), TCL_VOLATILE
);
4763 static int SQLITE_TCLAPI
test_ex_sql(
4767 Tcl_Obj
*CONST objv
[]
4769 sqlite3_stmt
*pStmt
;
4773 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT");
4777 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4778 z
= sqlite3_expanded_sql(pStmt
);
4779 Tcl_SetResult(interp
, z
, TCL_VOLATILE
);
4783 #ifdef SQLITE_ENABLE_NORMALIZE
4784 static int SQLITE_TCLAPI
test_norm_sql(
4788 Tcl_Obj
*CONST objv
[]
4790 sqlite3_stmt
*pStmt
;
4793 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT");
4797 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4798 Tcl_SetResult(interp
, (char *)sqlite3_normalized_sql(pStmt
), TCL_VOLATILE
);
4801 #endif /* SQLITE_ENABLE_NORMALIZE */
4804 ** Usage: sqlite3_column_count STMT
4806 ** Return the number of columns returned by the sql statement STMT.
4808 static int SQLITE_TCLAPI
test_column_count(
4812 Tcl_Obj
*CONST objv
[]
4814 sqlite3_stmt
*pStmt
;
4817 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4818 Tcl_GetString(objv
[0]), " STMT column", 0);
4822 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4824 Tcl_SetObjResult(interp
, Tcl_NewIntObj(sqlite3_column_count(pStmt
)));
4829 ** Usage: sqlite3_column_type STMT column
4831 ** Return the type of the data in column 'column' of the current row.
4833 static int SQLITE_TCLAPI
test_column_type(
4837 Tcl_Obj
*CONST objv
[]
4839 sqlite3_stmt
*pStmt
;
4844 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4845 Tcl_GetString(objv
[0]), " STMT column", 0);
4849 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4850 if( Tcl_GetIntFromObj(interp
, objv
[2], &col
) ) return TCL_ERROR
;
4852 tp
= sqlite3_column_type(pStmt
, col
);
4854 case SQLITE_INTEGER
:
4855 Tcl_SetResult(interp
, "INTEGER", TCL_STATIC
);
4858 Tcl_SetResult(interp
, "NULL", TCL_STATIC
);
4861 Tcl_SetResult(interp
, "FLOAT", TCL_STATIC
);
4864 Tcl_SetResult(interp
, "TEXT", TCL_STATIC
);
4867 Tcl_SetResult(interp
, "BLOB", TCL_STATIC
);
4877 ** Usage: sqlite3_column_int64 STMT column
4879 ** Return the data in column 'column' of the current row cast as an
4880 ** wide (64-bit) integer.
4882 static int SQLITE_TCLAPI
test_column_int64(
4886 Tcl_Obj
*CONST objv
[]
4888 sqlite3_stmt
*pStmt
;
4893 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4894 Tcl_GetString(objv
[0]), " STMT column", 0);
4898 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4899 if( Tcl_GetIntFromObj(interp
, objv
[2], &col
) ) return TCL_ERROR
;
4901 iVal
= sqlite3_column_int64(pStmt
, col
);
4902 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj(iVal
));
4907 ** Usage: sqlite3_column_blob STMT column
4909 static int SQLITE_TCLAPI
test_column_blob(
4913 Tcl_Obj
*CONST objv
[]
4915 sqlite3_stmt
*pStmt
;
4922 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4923 Tcl_GetString(objv
[0]), " STMT column", 0);
4927 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4928 if( Tcl_GetIntFromObj(interp
, objv
[2], &col
) ) return TCL_ERROR
;
4930 len
= sqlite3_column_bytes(pStmt
, col
);
4931 pBlob
= sqlite3_column_blob(pStmt
, col
);
4932 Tcl_SetObjResult(interp
, Tcl_NewByteArrayObj(pBlob
, len
));
4937 ** Usage: sqlite3_column_double STMT column
4939 ** Return the data in column 'column' of the current row cast as a double.
4941 static int SQLITE_TCLAPI
test_column_double(
4945 Tcl_Obj
*CONST objv
[]
4947 sqlite3_stmt
*pStmt
;
4952 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4953 Tcl_GetString(objv
[0]), " STMT column", 0);
4957 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4958 if( Tcl_GetIntFromObj(interp
, objv
[2], &col
) ) return TCL_ERROR
;
4960 rVal
= sqlite3_column_double(pStmt
, col
);
4961 Tcl_SetObjResult(interp
, Tcl_NewDoubleObj(rVal
));
4966 ** Usage: sqlite3_data_count STMT
4968 ** Return the number of columns returned by the sql statement STMT.
4970 static int SQLITE_TCLAPI
test_data_count(
4974 Tcl_Obj
*CONST objv
[]
4976 sqlite3_stmt
*pStmt
;
4979 Tcl_AppendResult(interp
, "wrong # args: should be \"",
4980 Tcl_GetString(objv
[0]), " STMT column", 0);
4984 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
4986 Tcl_SetObjResult(interp
, Tcl_NewIntObj(sqlite3_data_count(pStmt
)));
4991 ** Usage: sqlite3_column_text STMT column
4993 ** Usage: sqlite3_column_decltype STMT column
4995 ** Usage: sqlite3_column_name STMT column
4997 static int SQLITE_TCLAPI
test_stmt_utf8(
4998 void * clientData
, /* Pointer to SQLite API function to be invoke */
5001 Tcl_Obj
*CONST objv
[]
5003 sqlite3_stmt
*pStmt
;
5005 const char *(*xFunc
)(sqlite3_stmt
*, int);
5008 xFunc
= (const char *(*)(sqlite3_stmt
*, int))clientData
;
5010 Tcl_AppendResult(interp
, "wrong # args: should be \"",
5011 Tcl_GetString(objv
[0]), " STMT column", 0);
5015 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
5016 if( Tcl_GetIntFromObj(interp
, objv
[2], &col
) ) return TCL_ERROR
;
5017 zRet
= xFunc(pStmt
, col
);
5019 Tcl_SetResult(interp
, (char *)zRet
, 0);
5024 static int SQLITE_TCLAPI
test_global_recover(
5028 Tcl_Obj
*CONST objv
[]
5030 #ifndef SQLITE_OMIT_DEPRECATED
5033 Tcl_WrongNumArgs(interp
, 1, objv
, "");
5036 rc
= sqlite3_global_recover();
5037 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
5043 ** Usage: sqlite3_column_text STMT column
5045 ** Usage: sqlite3_column_decltype STMT column
5047 ** Usage: sqlite3_column_name STMT column
5049 static int SQLITE_TCLAPI
test_stmt_utf16(
5050 void * clientData
, /* Pointer to SQLite API function to be invoked */
5053 Tcl_Obj
*CONST objv
[]
5055 #ifndef SQLITE_OMIT_UTF16
5056 sqlite3_stmt
*pStmt
;
5059 const void *zName16
;
5060 const void *(*xFunc
)(sqlite3_stmt
*, int);
5062 xFunc
= (const void *(*)(sqlite3_stmt
*, int))clientData
;
5064 Tcl_AppendResult(interp
, "wrong # args: should be \"",
5065 Tcl_GetString(objv
[0]), " STMT column", 0);
5069 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
5070 if( Tcl_GetIntFromObj(interp
, objv
[2], &col
) ) return TCL_ERROR
;
5072 zName16
= xFunc(pStmt
, col
);
5075 const char *z
= zName16
;
5076 for(n
=0; z
[n
] || z
[n
+1]; n
+=2){}
5077 pRet
= Tcl_NewByteArrayObj(zName16
, n
+2);
5078 Tcl_SetObjResult(interp
, pRet
);
5080 #endif /* SQLITE_OMIT_UTF16 */
5086 ** Usage: sqlite3_column_int STMT column
5088 ** Usage: sqlite3_column_bytes STMT column
5090 ** Usage: sqlite3_column_bytes16 STMT column
5093 static int SQLITE_TCLAPI
test_stmt_int(
5094 void * clientData
, /* Pointer to SQLite API function to be invoked */
5097 Tcl_Obj
*CONST objv
[]
5099 sqlite3_stmt
*pStmt
;
5101 int (*xFunc
)(sqlite3_stmt
*, int);
5103 xFunc
= (int (*)(sqlite3_stmt
*, int))clientData
;
5105 Tcl_AppendResult(interp
, "wrong # args: should be \"",
5106 Tcl_GetString(objv
[0]), " STMT column", 0);
5110 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
5111 if( Tcl_GetIntFromObj(interp
, objv
[2], &col
) ) return TCL_ERROR
;
5113 Tcl_SetObjResult(interp
, Tcl_NewIntObj(xFunc(pStmt
, col
)));
5118 ** Usage: sqlite_set_magic DB MAGIC-NUMBER
5120 ** Set the db->magic value. This is used to test error recovery logic.
5122 static int SQLITE_TCLAPI
sqlite_set_magic(
5130 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
5134 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
5135 if( strcmp(argv
[2], "SQLITE_MAGIC_OPEN")==0 ){
5136 db
->magic
= SQLITE_MAGIC_OPEN
;
5137 }else if( strcmp(argv
[2], "SQLITE_MAGIC_CLOSED")==0 ){
5138 db
->magic
= SQLITE_MAGIC_CLOSED
;
5139 }else if( strcmp(argv
[2], "SQLITE_MAGIC_BUSY")==0 ){
5140 db
->magic
= SQLITE_MAGIC_BUSY
;
5141 }else if( strcmp(argv
[2], "SQLITE_MAGIC_ERROR")==0 ){
5142 db
->magic
= SQLITE_MAGIC_ERROR
;
5143 }else if( Tcl_GetInt(interp
, argv
[2], (int*)&db
->magic
) ){
5150 ** Usage: sqlite3_interrupt DB
5152 ** Trigger an interrupt on DB
5154 static int SQLITE_TCLAPI
test_interrupt(
5162 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0], " DB", 0);
5165 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
5166 sqlite3_interrupt(db
);
5171 ** Usage: sqlite_delete_function DB function-name
5173 ** Delete the user function 'function-name' from database handle DB. It
5174 ** is assumed that the user function was created as UTF8, any number of
5175 ** arguments (the way the TCL interface does it).
5177 static int SQLITE_TCLAPI
delete_function(
5186 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
5187 " DB function-name", 0);
5190 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
5191 rc
= sqlite3_create_function(db
, argv
[2], -1, SQLITE_UTF8
, 0, 0, 0, 0);
5192 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
5197 ** Usage: sqlite_delete_collation DB collation-name
5199 ** Delete the collation sequence 'collation-name' from database handle
5200 ** DB. It is assumed that the collation sequence was created as UTF8 (the
5201 ** way the TCL interface does it).
5203 static int SQLITE_TCLAPI
delete_collation(
5212 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
5213 " DB function-name", 0);
5216 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
5217 rc
= sqlite3_create_collation(db
, argv
[2], SQLITE_UTF8
, 0, 0);
5218 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
5223 ** Usage: sqlite3_get_autocommit DB
5225 ** Return true if the database DB is currently in auto-commit mode.
5226 ** Return false if not.
5228 static int SQLITE_TCLAPI
get_autocommit(
5237 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
5241 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
5242 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "%d", sqlite3_get_autocommit(db
));
5243 Tcl_AppendResult(interp
, zBuf
, 0);
5248 ** Usage: sqlite3_busy_timeout DB MS
5250 ** Set the busy timeout. This is more easily done using the timeout
5251 ** method of the TCL interface. But we need a way to test the case
5252 ** where it returns SQLITE_MISUSE.
5254 static int SQLITE_TCLAPI
test_busy_timeout(
5263 Tcl_AppendResult(interp
, "wrong # args: should be \"", argv
[0],
5267 if( getDbPointer(interp
, argv
[1], &db
) ) return TCL_ERROR
;
5268 if( Tcl_GetInt(interp
, argv
[2], &ms
) ) return TCL_ERROR
;
5269 rc
= sqlite3_busy_timeout(db
, ms
);
5270 Tcl_AppendResult(interp
, sqlite3ErrName(rc
), 0);
5275 ** Usage: tcl_variable_type VARIABLENAME
5277 ** Return the name of the internal representation for the
5278 ** value of the given variable.
5280 static int SQLITE_TCLAPI
tcl_variable_type(
5284 Tcl_Obj
*CONST objv
[]
5288 Tcl_WrongNumArgs(interp
, 1, objv
, "VARIABLE");
5291 pVar
= Tcl_GetVar2Ex(interp
, Tcl_GetString(objv
[1]), 0, TCL_LEAVE_ERR_MSG
);
5292 if( pVar
==0 ) return TCL_ERROR
;
5293 if( pVar
->typePtr
){
5294 Tcl_SetObjResult(interp
, Tcl_NewStringObj(pVar
->typePtr
->name
, -1));
5300 ** Usage: sqlite3_release_memory ?N?
5302 ** Attempt to release memory currently held but not actually required.
5303 ** The integer N is the number of bytes we are trying to release. The
5304 ** return value is the amount of memory actually released.
5306 static int SQLITE_TCLAPI
test_release_memory(
5310 Tcl_Obj
*CONST objv
[]
5312 #if defined(SQLITE_ENABLE_MEMORY_MANAGEMENT) && !defined(SQLITE_OMIT_DISKIO)
5315 if( objc
!=1 && objc
!=2 ){
5316 Tcl_WrongNumArgs(interp
, 1, objv
, "?N?");
5320 if( Tcl_GetIntFromObj(interp
, objv
[1], &N
) ) return TCL_ERROR
;
5324 amt
= sqlite3_release_memory(N
);
5325 Tcl_SetObjResult(interp
, Tcl_NewIntObj(amt
));
5332 ** Usage: sqlite3_db_release_memory DB
5334 ** Attempt to release memory currently held by database DB. Return the
5335 ** result code (which in the current implementation is always zero).
5337 static int SQLITE_TCLAPI
test_db_release_memory(
5341 Tcl_Obj
*CONST objv
[]
5346 Tcl_WrongNumArgs(interp
, 1, objv
, "DB");
5349 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
5350 rc
= sqlite3_db_release_memory(db
);
5351 Tcl_SetObjResult(interp
, Tcl_NewIntObj(rc
));
5356 ** Usage: sqlite3_db_cacheflush DB
5358 ** Attempt to flush any dirty pages to disk.
5360 static int SQLITE_TCLAPI
test_db_cacheflush(
5364 Tcl_Obj
*CONST objv
[]
5369 Tcl_WrongNumArgs(interp
, 1, objv
, "DB");
5372 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
5373 rc
= sqlite3_db_cacheflush(db
);
5375 Tcl_SetResult(interp
, (char *)sqlite3ErrStr(rc
), TCL_STATIC
);
5379 Tcl_ResetResult(interp
);
5384 ** Usage: sqlite3_system_errno DB
5386 ** Return the low-level system errno value.
5388 static int SQLITE_TCLAPI
test_system_errno(
5392 Tcl_Obj
*CONST objv
[]
5397 Tcl_WrongNumArgs(interp
, 1, objv
, "DB");
5400 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
5401 iErrno
= sqlite3_system_errno(db
);
5402 Tcl_SetObjResult(interp
, Tcl_NewIntObj(iErrno
));
5407 ** Usage: sqlite3_db_filename DB DBNAME
5409 ** Return the name of a file associated with a database.
5411 static int SQLITE_TCLAPI
test_db_filename(
5415 Tcl_Obj
*CONST objv
[]
5418 const char *zDbName
;
5420 Tcl_WrongNumArgs(interp
, 1, objv
, "DB DBNAME");
5423 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
5424 zDbName
= Tcl_GetString(objv
[2]);
5425 Tcl_AppendResult(interp
, sqlite3_db_filename(db
, zDbName
), (void*)0);
5430 ** Usage: sqlite3_db_readonly DB DBNAME
5432 ** Return 1 or 0 if DBNAME is readonly or not. Return -1 if DBNAME does
5435 static int SQLITE_TCLAPI
test_db_readonly(
5439 Tcl_Obj
*CONST objv
[]
5442 const char *zDbName
;
5444 Tcl_WrongNumArgs(interp
, 1, objv
, "DB DBNAME");
5447 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
5448 zDbName
= Tcl_GetString(objv
[2]);
5449 Tcl_SetObjResult(interp
, Tcl_NewIntObj(sqlite3_db_readonly(db
, zDbName
)));
5454 ** Usage: sqlite3_soft_heap_limit ?N?
5456 ** Query or set the soft heap limit for the current thread. The
5457 ** limit is only changed if the N is present. The previous limit
5460 static int SQLITE_TCLAPI
test_soft_heap_limit(
5464 Tcl_Obj
*CONST objv
[]
5468 if( objc
!=1 && objc
!=2 ){
5469 Tcl_WrongNumArgs(interp
, 1, objv
, "?N?");
5473 if( Tcl_GetWideIntFromObj(interp
, objv
[1], &N
) ) return TCL_ERROR
;
5475 amt
= sqlite3_soft_heap_limit64(N
);
5476 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj(amt
));
5481 ** Usage: sqlite3_thread_cleanup
5483 ** Call the sqlite3_thread_cleanup API.
5485 static int SQLITE_TCLAPI
test_thread_cleanup(
5489 Tcl_Obj
*CONST objv
[]
5491 #ifndef SQLITE_OMIT_DEPRECATED
5492 sqlite3_thread_cleanup();
5498 ** Usage: sqlite3_pager_refcounts DB
5500 ** Return a list of numbers which are the PagerRefcount for all
5501 ** pagers on each database connection.
5503 static int SQLITE_TCLAPI
test_pager_refcounts(
5507 Tcl_Obj
*CONST objv
[]
5515 Tcl_AppendResult(interp
, "wrong # args: should be \"",
5516 Tcl_GetStringFromObj(objv
[0], 0), " DB", 0);
5519 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
5520 pResult
= Tcl_NewObj();
5521 for(i
=0; i
<db
->nDb
; i
++){
5522 if( db
->aDb
[i
].pBt
==0 ){
5525 sqlite3_mutex_enter(db
->mutex
);
5526 a
= sqlite3PagerStats(sqlite3BtreePager(db
->aDb
[i
].pBt
));
5528 sqlite3_mutex_leave(db
->mutex
);
5530 Tcl_ListObjAppendElement(0, pResult
, Tcl_NewIntObj(v
));
5532 Tcl_SetObjResult(interp
, pResult
);
5538 ** tclcmd: working_64bit_int
5540 ** Some TCL builds (ex: cygwin) do not support 64-bit integers. This
5541 ** leads to a number of test failures. The present command checks the
5542 ** TCL build to see whether or not it supports 64-bit integers. It
5543 ** returns TRUE if it does and FALSE if not.
5545 ** This command is used to warn users that their TCL build is defective
5546 ** and that the errors they are seeing in the test scripts might be
5547 ** a result of their defective TCL rather than problems in SQLite.
5549 static int SQLITE_TCLAPI
working_64bit_int(
5550 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
5551 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
5552 int objc
, /* Number of arguments */
5553 Tcl_Obj
*CONST objv
[] /* Command arguments */
5558 pTestObj
= Tcl_NewWideIntObj(1000000*(i64
)1234567890);
5559 working
= strcmp(Tcl_GetString(pTestObj
), "1234567890000000")==0;
5560 Tcl_DecrRefCount(pTestObj
);
5561 Tcl_SetObjResult(interp
, Tcl_NewBooleanObj(working
));
5567 ** tclcmd: vfs_unlink_test
5569 ** This TCL command unregisters the primary VFS and then registers
5570 ** it back again. This is used to test the ability to register a
5571 ** VFS when none are previously registered, and the ability to
5572 ** unregister the only available VFS. Ticket #2738
5574 static int SQLITE_TCLAPI
vfs_unlink_test(
5575 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
5576 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
5577 int objc
, /* Number of arguments */
5578 Tcl_Obj
*CONST objv
[] /* Command arguments */
5582 sqlite3_vfs
*apVfs
[20];
5583 sqlite3_vfs one
, two
;
5585 sqlite3_vfs_unregister(0); /* Unregister of NULL is harmless */
5586 one
.zName
= "__one";
5587 two
.zName
= "__two";
5589 /* Calling sqlite3_vfs_register with 2nd argument of 0 does not
5590 ** change the default VFS
5592 pMain
= sqlite3_vfs_find(0);
5593 sqlite3_vfs_register(&one
, 0);
5594 assert( pMain
==0 || pMain
==sqlite3_vfs_find(0) );
5595 sqlite3_vfs_register(&two
, 0);
5596 assert( pMain
==0 || pMain
==sqlite3_vfs_find(0) );
5598 /* We can find a VFS by its name */
5599 assert( sqlite3_vfs_find("__one")==&one
);
5600 assert( sqlite3_vfs_find("__two")==&two
);
5602 /* Calling sqlite_vfs_register with non-zero second parameter changes the
5603 ** default VFS, even if the 1st parameter is an existig VFS that is
5604 ** previously registered as the non-default.
5606 sqlite3_vfs_register(&one
, 1);
5607 assert( sqlite3_vfs_find("__one")==&one
);
5608 assert( sqlite3_vfs_find("__two")==&two
);
5609 assert( sqlite3_vfs_find(0)==&one
);
5610 sqlite3_vfs_register(&two
, 1);
5611 assert( sqlite3_vfs_find("__one")==&one
);
5612 assert( sqlite3_vfs_find("__two")==&two
);
5613 assert( sqlite3_vfs_find(0)==&two
);
5615 sqlite3_vfs_register(pMain
, 1);
5616 assert( sqlite3_vfs_find("__one")==&one
);
5617 assert( sqlite3_vfs_find("__two")==&two
);
5618 assert( sqlite3_vfs_find(0)==pMain
);
5621 /* Unlink the default VFS. Repeat until there are no more VFSes
5624 for(i
=0; i
<sizeof(apVfs
)/sizeof(apVfs
[0]); i
++){
5625 apVfs
[i
] = sqlite3_vfs_find(0);
5627 assert( apVfs
[i
]==sqlite3_vfs_find(apVfs
[i
]->zName
) );
5628 sqlite3_vfs_unregister(apVfs
[i
]);
5629 assert( 0==sqlite3_vfs_find(apVfs
[i
]->zName
) );
5632 assert( 0==sqlite3_vfs_find(0) );
5634 /* Register the main VFS as non-default (will be made default, since
5635 ** it'll be the only one in existence).
5637 sqlite3_vfs_register(pMain
, 0);
5638 assert( sqlite3_vfs_find(0)==pMain
);
5640 /* Un-register the main VFS again to restore an empty VFS list */
5641 sqlite3_vfs_unregister(pMain
);
5642 assert( 0==sqlite3_vfs_find(0) );
5644 /* Relink all VFSes in reverse order. */
5645 for(i
=sizeof(apVfs
)/sizeof(apVfs
[0])-1; i
>=0; i
--){
5647 sqlite3_vfs_register(apVfs
[i
], 1);
5648 assert( apVfs
[i
]==sqlite3_vfs_find(0) );
5649 assert( apVfs
[i
]==sqlite3_vfs_find(apVfs
[i
]->zName
) );
5653 /* Unregister out sample VFSes. */
5654 sqlite3_vfs_unregister(&one
);
5655 sqlite3_vfs_unregister(&two
);
5657 /* Unregistering a VFS that is not currently registered is harmless */
5658 sqlite3_vfs_unregister(&one
);
5659 sqlite3_vfs_unregister(&two
);
5660 assert( sqlite3_vfs_find("__one")==0 );
5661 assert( sqlite3_vfs_find("__two")==0 );
5663 /* We should be left with the original default VFS back as the
5665 assert( sqlite3_vfs_find(0)==pMain
);
5671 ** tclcmd: vfs_initfail_test
5673 ** This TCL command attempts to vfs_find and vfs_register when the
5674 ** sqlite3_initialize() interface is failing. All calls should fail.
5676 static int SQLITE_TCLAPI
vfs_initfail_test(
5677 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
5678 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
5679 int objc
, /* Number of arguments */
5680 Tcl_Obj
*CONST objv
[] /* Command arguments */
5683 one
.zName
= "__one";
5685 if( sqlite3_vfs_find(0) ) return TCL_ERROR
;
5686 sqlite3_vfs_register(&one
, 0);
5687 if( sqlite3_vfs_find(0) ) return TCL_ERROR
;
5688 sqlite3_vfs_register(&one
, 1);
5689 if( sqlite3_vfs_find(0) ) return TCL_ERROR
;
5696 static sqlite3_vfs
*apVfs
[20];
5697 static int nVfs
= 0;
5700 ** tclcmd: vfs_unregister_all
5702 ** Unregister all VFSes.
5704 static int SQLITE_TCLAPI
vfs_unregister_all(
5705 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
5706 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
5707 int objc
, /* Number of arguments */
5708 Tcl_Obj
*CONST objv
[] /* Command arguments */
5711 for(i
=0; i
<ArraySize(apVfs
); i
++){
5712 apVfs
[i
] = sqlite3_vfs_find(0);
5713 if( apVfs
[i
]==0 ) break;
5714 sqlite3_vfs_unregister(apVfs
[i
]);
5720 ** tclcmd: vfs_reregister_all
5722 ** Restore all VFSes that were removed using vfs_unregister_all. Taking
5723 ** care to put the linked list back together in the same order as it was
5724 ** in before vfs_unregister_all was invoked.
5726 static int SQLITE_TCLAPI
vfs_reregister_all(
5727 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
5728 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
5729 int objc
, /* Number of arguments */
5730 Tcl_Obj
*CONST objv
[] /* Command arguments */
5733 for(i
=nVfs
-1; i
>=0; i
--){
5734 sqlite3_vfs_register(apVfs
[i
], 1);
5741 ** tclcmd: file_control_test DB
5743 ** This TCL command runs the sqlite3_file_control interface and
5744 ** verifies correct operation of the same.
5746 static int SQLITE_TCLAPI
file_control_test(
5747 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
5748 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
5749 int objc
, /* Number of arguments */
5750 Tcl_Obj
*CONST objv
[] /* Command arguments */
5757 Tcl_AppendResult(interp
, "wrong # args: should be \"",
5758 Tcl_GetStringFromObj(objv
[0], 0), " DB", 0);
5761 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
5762 rc
= sqlite3_file_control(db
, 0, 0, &iArg
);
5763 assert( rc
==SQLITE_NOTFOUND
);
5764 rc
= sqlite3_file_control(db
, "notadatabase", SQLITE_FCNTL_LOCKSTATE
, &iArg
);
5765 assert( rc
==SQLITE_ERROR
);
5766 rc
= sqlite3_file_control(db
, "main", -1, &iArg
);
5767 assert( rc
==SQLITE_NOTFOUND
);
5768 rc
= sqlite3_file_control(db
, "temp", -1, &iArg
);
5769 assert( rc
==SQLITE_NOTFOUND
|| rc
==SQLITE_ERROR
);
5776 ** tclcmd: file_control_lasterrno_test DB
5778 ** This TCL command runs the sqlite3_file_control interface and
5779 ** verifies correct operation of the SQLITE_LAST_ERRNO verb.
5781 static int SQLITE_TCLAPI
file_control_lasterrno_test(
5782 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
5783 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
5784 int objc
, /* Number of arguments */
5785 Tcl_Obj
*CONST objv
[] /* Command arguments */
5792 Tcl_AppendResult(interp
, "wrong # args: should be \"",
5793 Tcl_GetStringFromObj(objv
[0], 0), " DB", 0);
5796 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
5799 rc
= sqlite3_file_control(db
, NULL
, SQLITE_LAST_ERRNO
, &iArg
);
5801 Tcl_SetObjResult(interp
, Tcl_NewIntObj(rc
));
5805 Tcl_AppendResult(interp
, "Unexpected non-zero errno: ",
5806 Tcl_GetStringFromObj(Tcl_NewIntObj(iArg
), 0), " ", 0);
5813 ** tclcmd: file_control_data_version DB DBNAME
5815 ** This TCL command runs the sqlite3_file_control with the
5816 ** SQLITE_FCNTL_DATA_VERSION opcode, returning the result.
5818 static int SQLITE_TCLAPI
file_control_data_version(
5819 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
5820 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
5821 int objc
, /* Number of arguments */
5822 Tcl_Obj
*CONST objv
[] /* Command arguments */
5824 unsigned int iVers
; /* data version */
5825 char *zDb
; /* Db name ("main", "temp" etc.) */
5826 sqlite3
*db
; /* Database handle */
5827 int rc
; /* file_control() return code */
5830 if( objc
!=3 && objc
!=2 ){
5831 Tcl_WrongNumArgs(interp
, 1, objv
, "DB [DBNAME]");
5834 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
5837 zDb
= objc
==3 ? Tcl_GetString(objv
[2]) : NULL
;
5839 rc
= sqlite3_file_control(db
, zDb
, SQLITE_FCNTL_DATA_VERSION
, (void *)&iVers
);
5841 Tcl_SetResult(interp
, (char *)sqlite3ErrName(rc
), TCL_STATIC
);
5844 sqlite3_snprintf(sizeof(zBuf
),zBuf
,"%u",iVers
);
5845 Tcl_SetResult(interp
, (char *)zBuf
, TCL_VOLATILE
);
5851 ** tclcmd: file_control_chunksize_test DB DBNAME SIZE
5853 ** This TCL command runs the sqlite3_file_control interface and
5854 ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and
5855 ** SQLITE_SET_LOCKPROXYFILE verbs.
5857 static int SQLITE_TCLAPI
file_control_chunksize_test(
5858 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
5859 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
5860 int objc
, /* Number of arguments */
5861 Tcl_Obj
*CONST objv
[] /* Command arguments */
5863 int nSize
; /* New chunk size */
5864 char *zDb
; /* Db name ("main", "temp" etc.) */
5865 sqlite3
*db
; /* Database handle */
5866 int rc
; /* file_control() return code */
5869 Tcl_WrongNumArgs(interp
, 1, objv
, "DB DBNAME SIZE");
5872 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
)
5873 || Tcl_GetIntFromObj(interp
, objv
[3], &nSize
)
5877 zDb
= Tcl_GetString(objv
[2]);
5878 if( zDb
[0]=='\0' ) zDb
= NULL
;
5880 rc
= sqlite3_file_control(db
, zDb
, SQLITE_FCNTL_CHUNK_SIZE
, (void *)&nSize
);
5882 Tcl_SetResult(interp
, (char *)sqlite3ErrName(rc
), TCL_STATIC
);
5889 ** tclcmd: file_control_sizehint_test DB DBNAME SIZE
5891 ** This TCL command runs the sqlite3_file_control interface
5892 ** with SQLITE_FCNTL_SIZE_HINT
5894 static int SQLITE_TCLAPI
file_control_sizehint_test(
5895 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
5896 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
5897 int objc
, /* Number of arguments */
5898 Tcl_Obj
*CONST objv
[] /* Command arguments */
5900 Tcl_WideInt nSize
; /* Hinted size */
5901 char *zDb
; /* Db name ("main", "temp" etc.) */
5902 sqlite3
*db
; /* Database handle */
5903 int rc
; /* file_control() return code */
5906 Tcl_WrongNumArgs(interp
, 1, objv
, "DB DBNAME SIZE");
5909 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
)
5910 || Tcl_GetWideIntFromObj(interp
, objv
[3], &nSize
)
5914 zDb
= Tcl_GetString(objv
[2]);
5915 if( zDb
[0]=='\0' ) zDb
= NULL
;
5917 rc
= sqlite3_file_control(db
, zDb
, SQLITE_FCNTL_SIZE_HINT
, (void *)&nSize
);
5919 Tcl_SetResult(interp
, (char *)sqlite3ErrName(rc
), TCL_STATIC
);
5926 ** tclcmd: file_control_lockproxy_test DB PWD
5928 ** This TCL command runs the sqlite3_file_control interface and
5929 ** verifies correct operation of the SQLITE_GET_LOCKPROXYFILE and
5930 ** SQLITE_SET_LOCKPROXYFILE verbs.
5932 static int SQLITE_TCLAPI
file_control_lockproxy_test(
5933 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
5934 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
5935 int objc
, /* Number of arguments */
5936 Tcl_Obj
*CONST objv
[] /* Command arguments */
5941 Tcl_AppendResult(interp
, "wrong # args: should be \"",
5942 Tcl_GetStringFromObj(objv
[0], 0), " DB PWD", 0);
5945 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
5949 #if !defined(SQLITE_ENABLE_LOCKING_STYLE)
5950 # if defined(__APPLE__)
5951 # define SQLITE_ENABLE_LOCKING_STYLE 1
5953 # define SQLITE_ENABLE_LOCKING_STYLE 0
5956 #if SQLITE_ENABLE_LOCKING_STYLE && defined(__APPLE__)
5962 char proxyPath
[400];
5964 zPwd
= Tcl_GetStringFromObj(objv
[2], &nPwd
);
5965 if( sizeof(proxyPath
)<nPwd
+20 ){
5966 Tcl_AppendResult(interp
, "PWD too big", (void*)0);
5969 sqlite3_snprintf(sizeof(proxyPath
), proxyPath
, "%s/test.proxy", zPwd
);
5970 rc
= sqlite3_file_control(db
, NULL
, SQLITE_SET_LOCKPROXYFILE
, proxyPath
);
5972 Tcl_SetObjResult(interp
, Tcl_NewIntObj(rc
));
5975 rc
= sqlite3_file_control(db
, NULL
, SQLITE_GET_LOCKPROXYFILE
, &testPath
);
5976 if( strncmp(proxyPath
,testPath
,11) ){
5977 Tcl_AppendResult(interp
, "Lock proxy file did not match the "
5978 "previously assigned value", 0);
5982 Tcl_SetObjResult(interp
, Tcl_NewIntObj(rc
));
5985 rc
= sqlite3_file_control(db
, NULL
, SQLITE_SET_LOCKPROXYFILE
, proxyPath
);
5987 Tcl_SetObjResult(interp
, Tcl_NewIntObj(rc
));
5997 ** tclcmd: file_control_win32_av_retry DB NRETRY DELAY
5999 ** This TCL command runs the sqlite3_file_control interface with
6000 ** the SQLITE_FCNTL_WIN32_AV_RETRY opcode.
6002 static int SQLITE_TCLAPI
file_control_win32_av_retry(
6003 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6004 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6005 int objc
, /* Number of arguments */
6006 Tcl_Obj
*CONST objv
[] /* Command arguments */
6014 Tcl_AppendResult(interp
, "wrong # args: should be \"",
6015 Tcl_GetStringFromObj(objv
[0], 0), " DB NRETRY DELAY", 0);
6018 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
6021 if( Tcl_GetIntFromObj(interp
, objv
[2], &a
[0]) ) return TCL_ERROR
;
6022 if( Tcl_GetIntFromObj(interp
, objv
[3], &a
[1]) ) return TCL_ERROR
;
6023 rc
= sqlite3_file_control(db
, NULL
, SQLITE_FCNTL_WIN32_AV_RETRY
, (void*)a
);
6024 sqlite3_snprintf(sizeof(z
), z
, "%d %d %d", rc
, a
[0], a
[1]);
6025 Tcl_AppendResult(interp
, z
, (char*)0);
6030 ** tclcmd: file_control_win32_get_handle DB
6032 ** This TCL command runs the sqlite3_file_control interface with
6033 ** the SQLITE_FCNTL_WIN32_GET_HANDLE opcode.
6035 static int file_control_win32_get_handle(
6036 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6037 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6038 int objc
, /* Number of arguments */
6039 Tcl_Obj
*CONST objv
[] /* Command arguments */
6043 HANDLE hFile
= NULL
;
6047 Tcl_AppendResult(interp
, "wrong # args: should be \"",
6048 Tcl_GetStringFromObj(objv
[0], 0), " DB", 0);
6051 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
6054 rc
= sqlite3_file_control(db
, NULL
, SQLITE_FCNTL_WIN32_GET_HANDLE
,
6056 sqlite3_snprintf(sizeof(z
), z
, "%d %p", rc
, (void*)hFile
);
6057 Tcl_AppendResult(interp
, z
, (char*)0);
6062 ** tclcmd: file_control_win32_set_handle DB HANDLE
6064 ** This TCL command runs the sqlite3_file_control interface with
6065 ** the SQLITE_FCNTL_WIN32_SET_HANDLE opcode.
6067 static int SQLITE_TCLAPI
file_control_win32_set_handle(
6068 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6069 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6070 int objc
, /* Number of arguments */
6071 Tcl_Obj
*CONST objv
[] /* Command arguments */
6075 HANDLE hFile
= NULL
;
6079 Tcl_AppendResult(interp
, "wrong # args: should be \"",
6080 Tcl_GetStringFromObj(objv
[0], 0), " DB HANDLE", 0);
6083 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
6086 if( getWin32Handle(interp
, Tcl_GetString(objv
[2]), &hFile
) ){
6089 rc
= sqlite3_file_control(db
, NULL
, SQLITE_FCNTL_WIN32_SET_HANDLE
,
6091 sqlite3_snprintf(sizeof(z
), z
, "%d %p", rc
, (void*)hFile
);
6092 Tcl_AppendResult(interp
, z
, (char*)0);
6098 ** tclcmd: file_control_persist_wal DB PERSIST-FLAG
6100 ** This TCL command runs the sqlite3_file_control interface with
6101 ** the SQLITE_FCNTL_PERSIST_WAL opcode.
6103 static int SQLITE_TCLAPI
file_control_persist_wal(
6104 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6105 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6106 int objc
, /* Number of arguments */
6107 Tcl_Obj
*CONST objv
[] /* Command arguments */
6115 Tcl_AppendResult(interp
, "wrong # args: should be \"",
6116 Tcl_GetStringFromObj(objv
[0], 0), " DB FLAG", 0);
6119 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
6122 if( Tcl_GetIntFromObj(interp
, objv
[2], &bPersist
) ) return TCL_ERROR
;
6123 rc
= sqlite3_file_control(db
, NULL
, SQLITE_FCNTL_PERSIST_WAL
, (void*)&bPersist
);
6124 sqlite3_snprintf(sizeof(z
), z
, "%d %d", rc
, bPersist
);
6125 Tcl_AppendResult(interp
, z
, (char*)0);
6130 ** tclcmd: file_control_powersafe_overwrite DB PSOW-FLAG
6132 ** This TCL command runs the sqlite3_file_control interface with
6133 ** the SQLITE_FCNTL_POWERSAFE_OVERWRITE opcode.
6135 static int SQLITE_TCLAPI
file_control_powersafe_overwrite(
6136 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6137 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6138 int objc
, /* Number of arguments */
6139 Tcl_Obj
*CONST objv
[] /* Command arguments */
6147 Tcl_AppendResult(interp
, "wrong # args: should be \"",
6148 Tcl_GetStringFromObj(objv
[0], 0), " DB FLAG", 0);
6151 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
6154 if( Tcl_GetIntFromObj(interp
, objv
[2], &b
) ) return TCL_ERROR
;
6155 rc
= sqlite3_file_control(db
,NULL
,SQLITE_FCNTL_POWERSAFE_OVERWRITE
,(void*)&b
);
6156 sqlite3_snprintf(sizeof(z
), z
, "%d %d", rc
, b
);
6157 Tcl_AppendResult(interp
, z
, (char*)0);
6163 ** tclcmd: file_control_vfsname DB ?AUXDB?
6165 ** Return a string that describes the stack of VFSes.
6167 static int SQLITE_TCLAPI
file_control_vfsname(
6168 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6169 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6170 int objc
, /* Number of arguments */
6171 Tcl_Obj
*CONST objv
[] /* Command arguments */
6174 const char *zDbName
= "main";
6177 if( objc
!=2 && objc
!=3 ){
6178 Tcl_AppendResult(interp
, "wrong # args: should be \"",
6179 Tcl_GetStringFromObj(objv
[0], 0), " DB ?AUXDB?", 0);
6182 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
6186 zDbName
= Tcl_GetString(objv
[2]);
6188 sqlite3_file_control(db
, zDbName
, SQLITE_FCNTL_VFSNAME
,(void*)&zVfsName
);
6189 Tcl_AppendResult(interp
, zVfsName
, (char*)0);
6190 sqlite3_free(zVfsName
);
6195 ** tclcmd: file_control_tempfilename DB ?AUXDB?
6197 ** Return a string that is a temporary filename
6199 static int SQLITE_TCLAPI
file_control_tempfilename(
6200 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6201 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6202 int objc
, /* Number of arguments */
6203 Tcl_Obj
*CONST objv
[] /* Command arguments */
6206 const char *zDbName
= "main";
6209 if( objc
!=2 && objc
!=3 ){
6210 Tcl_AppendResult(interp
, "wrong # args: should be \"",
6211 Tcl_GetStringFromObj(objv
[0], 0), " DB ?AUXDB?", 0);
6214 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
6218 zDbName
= Tcl_GetString(objv
[2]);
6220 sqlite3_file_control(db
, zDbName
, SQLITE_FCNTL_TEMPFILENAME
, (void*)&zTName
);
6221 Tcl_AppendResult(interp
, zTName
, (char*)0);
6222 sqlite3_free(zTName
);
6228 ** tclcmd: sqlite3_vfs_list
6230 ** Return a tcl list containing the names of all registered vfs's.
6232 static int SQLITE_TCLAPI
vfs_list(
6233 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6234 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6235 int objc
, /* Number of arguments */
6236 Tcl_Obj
*CONST objv
[] /* Command arguments */
6239 Tcl_Obj
*pRet
= Tcl_NewObj();
6241 Tcl_WrongNumArgs(interp
, 1, objv
, "");
6244 for(pVfs
=sqlite3_vfs_find(0); pVfs
; pVfs
=pVfs
->pNext
){
6245 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewStringObj(pVfs
->zName
, -1));
6247 Tcl_SetObjResult(interp
, pRet
);
6252 ** tclcmd: sqlite3_limit DB ID VALUE
6254 ** This TCL command runs the sqlite3_limit interface and
6255 ** verifies correct operation of the same.
6257 static int SQLITE_TCLAPI
test_limit(
6258 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6259 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6260 int objc
, /* Number of arguments */
6261 Tcl_Obj
*CONST objv
[] /* Command arguments */
6265 static const struct {
6269 { "SQLITE_LIMIT_LENGTH", SQLITE_LIMIT_LENGTH
},
6270 { "SQLITE_LIMIT_SQL_LENGTH", SQLITE_LIMIT_SQL_LENGTH
},
6271 { "SQLITE_LIMIT_COLUMN", SQLITE_LIMIT_COLUMN
},
6272 { "SQLITE_LIMIT_EXPR_DEPTH", SQLITE_LIMIT_EXPR_DEPTH
},
6273 { "SQLITE_LIMIT_COMPOUND_SELECT", SQLITE_LIMIT_COMPOUND_SELECT
},
6274 { "SQLITE_LIMIT_VDBE_OP", SQLITE_LIMIT_VDBE_OP
},
6275 { "SQLITE_LIMIT_FUNCTION_ARG", SQLITE_LIMIT_FUNCTION_ARG
},
6276 { "SQLITE_LIMIT_ATTACHED", SQLITE_LIMIT_ATTACHED
},
6277 { "SQLITE_LIMIT_LIKE_PATTERN_LENGTH", SQLITE_LIMIT_LIKE_PATTERN_LENGTH
},
6278 { "SQLITE_LIMIT_VARIABLE_NUMBER", SQLITE_LIMIT_VARIABLE_NUMBER
},
6279 { "SQLITE_LIMIT_TRIGGER_DEPTH", SQLITE_LIMIT_TRIGGER_DEPTH
},
6280 { "SQLITE_LIMIT_WORKER_THREADS", SQLITE_LIMIT_WORKER_THREADS
},
6282 /* Out of range test cases */
6283 { "SQLITE_LIMIT_TOOSMALL", -1, },
6284 { "SQLITE_LIMIT_TOOBIG", SQLITE_LIMIT_WORKER_THREADS
+1 },
6291 Tcl_AppendResult(interp
, "wrong # args: should be \"",
6292 Tcl_GetStringFromObj(objv
[0], 0), " DB ID VALUE", 0);
6295 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
6296 zId
= Tcl_GetString(objv
[2]);
6297 for(i
=0; i
<sizeof(aId
)/sizeof(aId
[0]); i
++){
6298 if( strcmp(zId
, aId
[i
].zName
)==0 ){
6303 if( i
>=sizeof(aId
)/sizeof(aId
[0]) ){
6304 Tcl_AppendResult(interp
, "unknown limit type: ", zId
, (char*)0);
6307 if( Tcl_GetIntFromObj(interp
, objv
[3], &val
) ) return TCL_ERROR
;
6308 rc
= sqlite3_limit(db
, id
, val
);
6309 Tcl_SetObjResult(interp
, Tcl_NewIntObj(rc
));
6314 ** tclcmd: save_prng_state
6316 ** Save the state of the pseudo-random number generator.
6317 ** At the same time, verify that sqlite3_test_control works even when
6318 ** called with an out-of-range opcode.
6320 static int SQLITE_TCLAPI
save_prng_state(
6321 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6322 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6323 int objc
, /* Number of arguments */
6324 Tcl_Obj
*CONST objv
[] /* Command arguments */
6326 int rc
= sqlite3_test_control(9999);
6328 rc
= sqlite3_test_control(-1);
6330 sqlite3_test_control(SQLITE_TESTCTRL_PRNG_SAVE
);
6334 ** tclcmd: restore_prng_state
6336 static int SQLITE_TCLAPI
restore_prng_state(
6337 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6338 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6339 int objc
, /* Number of arguments */
6340 Tcl_Obj
*CONST objv
[] /* Command arguments */
6342 sqlite3_test_control(SQLITE_TESTCTRL_PRNG_RESTORE
);
6346 ** tclcmd: reset_prng_state
6348 static int SQLITE_TCLAPI
reset_prng_state(
6349 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6350 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6351 int objc
, /* Number of arguments */
6352 Tcl_Obj
*CONST objv
[] /* Command arguments */
6354 sqlite3_test_control(SQLITE_TESTCTRL_PRNG_RESET
);
6359 ** tclcmd: database_may_be_corrupt
6361 ** Indicate that database files might be corrupt. In other words, set the normal
6362 ** state of operation.
6364 static int SQLITE_TCLAPI
database_may_be_corrupt(
6365 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6366 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6367 int objc
, /* Number of arguments */
6368 Tcl_Obj
*CONST objv
[] /* Command arguments */
6370 sqlite3_test_control(SQLITE_TESTCTRL_NEVER_CORRUPT
, 0);
6374 ** tclcmd: database_never_corrupt
6376 ** Indicate that database files are always well-formed. This enables
6377 ** extra assert() statements that test conditions that are always true
6378 ** for well-formed databases.
6380 static int SQLITE_TCLAPI
database_never_corrupt(
6381 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6382 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6383 int objc
, /* Number of arguments */
6384 Tcl_Obj
*CONST objv
[] /* Command arguments */
6386 sqlite3_test_control(SQLITE_TESTCTRL_NEVER_CORRUPT
, 1);
6391 ** tclcmd: pcache_stats
6393 static int SQLITE_TCLAPI
test_pcache_stats(
6394 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
6395 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6396 int objc
, /* Number of arguments */
6397 Tcl_Obj
*CONST objv
[] /* Command arguments */
6405 sqlite3PcacheStats(&nCurrent
, &nMax
, &nMin
, &nRecyclable
);
6407 pRet
= Tcl_NewObj();
6408 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewStringObj("current", -1));
6409 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewIntObj(nCurrent
));
6410 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewStringObj("max", -1));
6411 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewIntObj(nMax
));
6412 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewStringObj("min", -1));
6413 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewIntObj(nMin
));
6414 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewStringObj("recyclable", -1));
6415 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewIntObj(nRecyclable
));
6417 Tcl_SetObjResult(interp
, pRet
);
6422 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
6423 static void test_unlock_notify_cb(void **aArg
, int nArg
){
6425 for(ii
=0; ii
<nArg
; ii
++){
6426 Tcl_EvalEx((Tcl_Interp
*)aArg
[ii
], "unlock_notify", -1, TCL_EVAL_GLOBAL
);
6429 #endif /* SQLITE_ENABLE_UNLOCK_NOTIFY */
6432 ** tclcmd: sqlite3_unlock_notify db
6434 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
6435 static int SQLITE_TCLAPI
test_unlock_notify(
6436 ClientData clientData
, /* Unused */
6437 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6438 int objc
, /* Number of arguments */
6439 Tcl_Obj
*CONST objv
[] /* Command arguments */
6445 Tcl_WrongNumArgs(interp
, 1, objv
, "DB");
6449 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
6452 rc
= sqlite3_unlock_notify(db
, test_unlock_notify_cb
, (void *)interp
);
6453 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
6459 ** tclcmd: sqlite3_wal_checkpoint db ?NAME?
6461 static int SQLITE_TCLAPI
test_wal_checkpoint(
6462 ClientData clientData
, /* Unused */
6463 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6464 int objc
, /* Number of arguments */
6465 Tcl_Obj
*CONST objv
[] /* Command arguments */
6471 if( objc
!=3 && objc
!=2 ){
6472 Tcl_WrongNumArgs(interp
, 1, objv
, "DB ?NAME?");
6476 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
6480 zDb
= Tcl_GetString(objv
[2]);
6482 rc
= sqlite3_wal_checkpoint(db
, zDb
);
6483 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
6488 ** tclcmd: sqlite3_wal_checkpoint_v2 db MODE ?NAME?
6490 ** This command calls the wal_checkpoint_v2() function with the specified
6491 ** mode argument (passive, full or restart). If present, the database name
6492 ** NAME is passed as the second argument to wal_checkpoint_v2(). If it the
6493 ** NAME argument is not present, a NULL pointer is passed instead.
6495 ** If wal_checkpoint_v2() returns any value other than SQLITE_BUSY or
6496 ** SQLITE_OK, then this command returns TCL_ERROR. The Tcl result is set
6497 ** to the error message obtained from sqlite3_errmsg().
6499 ** Otherwise, this command returns a list of three integers. The first integer
6500 ** is 1 if SQLITE_BUSY was returned, or 0 otherwise. The following two integers
6501 ** are the values returned via the output parameters by wal_checkpoint_v2() -
6502 ** the number of frames in the log and the number of frames in the log
6503 ** that have been checkpointed.
6505 static int SQLITE_TCLAPI
test_wal_checkpoint_v2(
6506 ClientData clientData
, /* Unused */
6507 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6508 int objc
, /* Number of arguments */
6509 Tcl_Obj
*CONST objv
[] /* Command arguments */
6520 const char * aMode
[] = { "passive", "full", "restart", "truncate", 0 };
6521 assert( SQLITE_CHECKPOINT_PASSIVE
==0 );
6522 assert( SQLITE_CHECKPOINT_FULL
==1 );
6523 assert( SQLITE_CHECKPOINT_RESTART
==2 );
6524 assert( SQLITE_CHECKPOINT_TRUNCATE
==3 );
6526 if( objc
!=3 && objc
!=4 ){
6527 Tcl_WrongNumArgs(interp
, 1, objv
, "DB MODE ?NAME?");
6532 zDb
= Tcl_GetString(objv
[3]);
6534 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) || (
6535 TCL_OK
!=Tcl_GetIntFromObj(0, objv
[2], &eMode
)
6536 && TCL_OK
!=Tcl_GetIndexFromObj(interp
, objv
[2], aMode
, "mode", 0, &eMode
)
6541 rc
= sqlite3_wal_checkpoint_v2(db
, zDb
, eMode
, &nLog
, &nCkpt
);
6542 if( rc
!=SQLITE_OK
&& rc
!=SQLITE_BUSY
){
6543 const char *zErrCode
= sqlite3ErrName(rc
);
6544 Tcl_ResetResult(interp
);
6545 Tcl_AppendResult(interp
, zErrCode
, " - ", (char *)sqlite3_errmsg(db
), 0);
6549 pRet
= Tcl_NewObj();
6550 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewIntObj(rc
==SQLITE_BUSY
?1:0));
6551 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewIntObj(nLog
));
6552 Tcl_ListObjAppendElement(interp
, pRet
, Tcl_NewIntObj(nCkpt
));
6553 Tcl_SetObjResult(interp
, pRet
);
6559 ** tclcmd: sqlite3_wal_autocheckpoint db VALUE
6561 static int SQLITE_TCLAPI
test_wal_autocheckpoint(
6562 ClientData clientData
, /* Unused */
6563 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6564 int objc
, /* Number of arguments */
6565 Tcl_Obj
*CONST objv
[] /* Command arguments */
6573 Tcl_WrongNumArgs(interp
, 1, objv
, "DB VALUE");
6577 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
)
6578 || Tcl_GetIntFromObj(0, objv
[2], &iVal
)
6583 rc
= sqlite3_wal_autocheckpoint(db
, iVal
);
6584 Tcl_ResetResult(interp
);
6585 if( rc
!=SQLITE_OK
){
6586 const char *zErrCode
= sqlite3ErrName(rc
);
6587 Tcl_SetObjResult(interp
, Tcl_NewStringObj(zErrCode
, -1));
6596 ** tclcmd: test_sqlite3_log ?SCRIPT?
6598 static struct LogCallback
{
6599 Tcl_Interp
*pInterp
;
6601 } logcallback
= {0, 0};
6602 static void xLogcallback(void *unused
, int err
, char *zMsg
){
6603 Tcl_Obj
*pNew
= Tcl_DuplicateObj(logcallback
.pObj
);
6604 Tcl_IncrRefCount(pNew
);
6605 Tcl_ListObjAppendElement(
6606 0, pNew
, Tcl_NewStringObj(sqlite3ErrName(err
), -1)
6608 Tcl_ListObjAppendElement(0, pNew
, Tcl_NewStringObj(zMsg
, -1));
6609 Tcl_EvalObjEx(logcallback
.pInterp
, pNew
, TCL_EVAL_GLOBAL
|TCL_EVAL_DIRECT
);
6610 Tcl_DecrRefCount(pNew
);
6612 static int SQLITE_TCLAPI
test_sqlite3_log(
6613 ClientData clientData
,
6614 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
6615 int objc
, /* Number of arguments */
6616 Tcl_Obj
*CONST objv
[] /* Command arguments */
6619 Tcl_WrongNumArgs(interp
, 1, objv
, "SCRIPT");
6622 if( logcallback
.pObj
){
6623 Tcl_DecrRefCount(logcallback
.pObj
);
6624 logcallback
.pObj
= 0;
6625 logcallback
.pInterp
= 0;
6626 sqlite3_config(SQLITE_CONFIG_LOG
, (void*)0, (void*)0);
6629 logcallback
.pObj
= objv
[1];
6630 Tcl_IncrRefCount(logcallback
.pObj
);
6631 logcallback
.pInterp
= interp
;
6632 sqlite3_config(SQLITE_CONFIG_LOG
, xLogcallback
, (void*)0);
6638 ** tcl_objproc COMMANDNAME ARGS...
6640 ** Run a TCL command using its objProc interface. Throw an error if
6641 ** the command has no objProc interface.
6643 static int SQLITE_TCLAPI
runAsObjProc(
6647 Tcl_Obj
*CONST objv
[]
6649 Tcl_CmdInfo cmdInfo
;
6651 Tcl_WrongNumArgs(interp
, 1, objv
, "COMMAND ...");
6654 if( !Tcl_GetCommandInfo(interp
, Tcl_GetString(objv
[1]), &cmdInfo
) ){
6655 Tcl_AppendResult(interp
, "command not found: ",
6656 Tcl_GetString(objv
[1]), (char*)0);
6659 if( cmdInfo
.objProc
==0 ){
6660 Tcl_AppendResult(interp
, "command has no objProc: ",
6661 Tcl_GetString(objv
[1]), (char*)0);
6664 return cmdInfo
.objProc(cmdInfo
.objClientData
, interp
, objc
-1, objv
+1);
6667 #ifndef SQLITE_OMIT_EXPLAIN
6669 ** WARNING: The following function, printExplainQueryPlan() is an exact
6670 ** copy of example code from eqp.in (eqp.html). If this code is modified,
6671 ** then the documentation copy needs to be modified as well.
6674 ** Argument pStmt is a prepared SQL statement. This function compiles
6675 ** an EXPLAIN QUERY PLAN command to report on the prepared statement,
6676 ** and prints the report to stdout using printf().
6678 int printExplainQueryPlan(sqlite3_stmt
*pStmt
){
6679 const char *zSql
; /* Input SQL */
6680 char *zExplain
; /* SQL with EXPLAIN QUERY PLAN prepended */
6681 sqlite3_stmt
*pExplain
; /* Compiled EXPLAIN QUERY PLAN command */
6682 int rc
; /* Return code from sqlite3_prepare_v2() */
6684 zSql
= sqlite3_sql(pStmt
);
6685 if( zSql
==0 ) return SQLITE_ERROR
;
6687 zExplain
= sqlite3_mprintf("EXPLAIN QUERY PLAN %s", zSql
);
6688 if( zExplain
==0 ) return SQLITE_NOMEM
;
6690 rc
= sqlite3_prepare_v2(sqlite3_db_handle(pStmt
), zExplain
, -1, &pExplain
, 0);
6691 sqlite3_free(zExplain
);
6692 if( rc
!=SQLITE_OK
) return rc
;
6694 while( SQLITE_ROW
==sqlite3_step(pExplain
) ){
6695 int iSelectid
= sqlite3_column_int(pExplain
, 0);
6696 int iOrder
= sqlite3_column_int(pExplain
, 1);
6697 int iFrom
= sqlite3_column_int(pExplain
, 2);
6698 const char *zDetail
= (const char *)sqlite3_column_text(pExplain
, 3);
6700 printf("%d %d %d %s\n", iSelectid
, iOrder
, iFrom
, zDetail
);
6703 return sqlite3_finalize(pExplain
);
6706 static int SQLITE_TCLAPI
test_print_eqp(
6710 Tcl_Obj
*CONST objv
[]
6713 sqlite3_stmt
*pStmt
;
6716 Tcl_WrongNumArgs(interp
, 1, objv
, "STMT");
6719 if( getStmtPointer(interp
, Tcl_GetString(objv
[1]), &pStmt
) ) return TCL_ERROR
;
6720 rc
= printExplainQueryPlan(pStmt
);
6721 /* This is needed on Windows so that a test case using this
6722 ** function can open a read pipe and get the output of
6723 ** printExplainQueryPlan() immediately.
6726 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), 0);
6729 #endif /* SQLITE_OMIT_EXPLAIN */
6732 ** sqlite3_test_control VERB ARGS...
6734 static int SQLITE_TCLAPI
test_test_control(
6738 Tcl_Obj
*CONST objv
[]
6744 { "SQLITE_TESTCTRL_LOCALTIME_FAULT", SQLITE_TESTCTRL_LOCALTIME_FAULT
},
6745 { "SQLITE_TESTCTRL_SORTER_MMAP", SQLITE_TESTCTRL_SORTER_MMAP
},
6746 { "SQLITE_TESTCTRL_IMPOSTER", SQLITE_TESTCTRL_IMPOSTER
},
6747 { "SQLITE_TESTCTRL_INTERNAL_FUNCTIONS", SQLITE_TESTCTRL_INTERNAL_FUNCTIONS
},
6754 Tcl_WrongNumArgs(interp
, 1, objv
, "VERB ARGS...");
6758 rc
= Tcl_GetIndexFromObjStruct(
6759 interp
, objv
[1], aVerb
, sizeof(aVerb
[0]), "VERB", 0, &iVerb
6761 if( rc
!=TCL_OK
) return rc
;
6763 iFlag
= aVerb
[iVerb
].i
;
6765 case SQLITE_TESTCTRL_INTERNAL_FUNCTIONS
:
6766 case SQLITE_TESTCTRL_LOCALTIME_FAULT
: {
6769 Tcl_WrongNumArgs(interp
, 2, objv
, "ONOFF");
6772 if( Tcl_GetBooleanFromObj(interp
, objv
[2], &val
) ) return TCL_ERROR
;
6773 sqlite3_test_control(iFlag
, val
);
6777 case SQLITE_TESTCTRL_SORTER_MMAP
: {
6781 Tcl_WrongNumArgs(interp
, 2, objv
, "DB LIMIT");
6784 if( getDbPointer(interp
, Tcl_GetString(objv
[2]), &db
) ) return TCL_ERROR
;
6785 if( Tcl_GetIntFromObj(interp
, objv
[3], &val
) ) return TCL_ERROR
;
6786 sqlite3_test_control(SQLITE_TESTCTRL_SORTER_MMAP
, db
, val
);
6790 case SQLITE_TESTCTRL_IMPOSTER
: {
6792 const char *zDbName
;
6795 Tcl_WrongNumArgs(interp
, 2, objv
, "DB dbName onOff tnum");
6798 if( getDbPointer(interp
, Tcl_GetString(objv
[2]), &db
) ) return TCL_ERROR
;
6799 zDbName
= Tcl_GetString(objv
[3]);
6800 if( Tcl_GetIntFromObj(interp
, objv
[4], &onOff
) ) return TCL_ERROR
;
6801 if( Tcl_GetIntFromObj(interp
, objv
[5], &tnum
) ) return TCL_ERROR
;
6802 sqlite3_test_control(SQLITE_TESTCTRL_IMPOSTER
, db
, zDbName
, onOff
, tnum
);
6807 Tcl_ResetResult(interp
);
6812 #include <sys/time.h>
6813 #include <sys/resource.h>
6815 static int SQLITE_TCLAPI
test_getrusage(
6819 Tcl_Obj
*CONST objv
[]
6823 memset(&r
, 0, sizeof(r
));
6824 getrusage(RUSAGE_SELF
, &r
);
6826 sqlite3_snprintf(sizeof(buf
), buf
,
6827 "ru_utime=%d.%06d ru_stime=%d.%06d ru_minflt=%d ru_majflt=%d",
6828 (int)r
.ru_utime
.tv_sec
, (int)r
.ru_utime
.tv_usec
,
6829 (int)r
.ru_stime
.tv_sec
, (int)r
.ru_stime
.tv_usec
,
6830 (int)r
.ru_minflt
, (int)r
.ru_majflt
6832 Tcl_SetObjResult(interp
, Tcl_NewStringObj(buf
, -1));
6839 ** Information passed from the main thread into the windows file locker
6840 ** background thread.
6842 struct win32FileLocker
{
6843 char *evName
; /* Name of event to signal thread startup */
6844 HANDLE h
; /* Handle of the file to be locked */
6845 int delay1
; /* Delay before locking */
6846 int delay2
; /* Delay before unlocking */
6847 int ok
; /* Finished ok */
6848 int err
; /* True if an error occurs */
6854 #include <process.h>
6856 ** The background thread that does file locking.
6858 static void SQLITE_CDECL
win32_file_locker(void *pAppData
){
6859 struct win32FileLocker
*p
= (struct win32FileLocker
*)pAppData
;
6861 HANDLE ev
= OpenEvent(EVENT_MODIFY_STATE
, FALSE
, p
->evName
);
6867 if( p
->delay1
) Sleep(p
->delay1
);
6868 if( LockFile(p
->h
, 0, 0, 100000000, 0) ){
6870 UnlockFile(p
->h
, 0, 0, 100000000, 0);
6884 ** lock_win32_file FILENAME DELAY1 DELAY2
6886 ** Get an exclusive manditory lock on file for DELAY2 milliseconds.
6887 ** Wait DELAY1 milliseconds before acquiring the lock.
6889 static int SQLITE_TCLAPI
win32_file_lock(
6893 Tcl_Obj
*CONST objv
[]
6895 static struct win32FileLocker x
= { "win32_file_lock", 0, 0, 0, 0, 0 };
6896 const char *zFilename
;
6902 if( objc
!=4 && objc
!=1 ){
6903 Tcl_WrongNumArgs(interp
, 1, objv
, "FILENAME DELAY1 DELAY2");
6907 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "%d %d %d %d %d",
6908 x
.ok
, x
.err
, x
.delay1
, x
.delay2
, x
.h
);
6909 Tcl_AppendResult(interp
, zBuf
, (char*)0);
6912 while( x
.h
&& retry
<30 ){
6917 Tcl_AppendResult(interp
, "busy", (char*)0);
6920 if( Tcl_GetIntFromObj(interp
, objv
[2], &x
.delay1
) ) return TCL_ERROR
;
6921 if( Tcl_GetIntFromObj(interp
, objv
[3], &x
.delay2
) ) return TCL_ERROR
;
6922 zFilename
= Tcl_GetString(objv
[1]);
6923 x
.h
= CreateFile(zFilename
, GENERIC_READ
|GENERIC_WRITE
,
6924 FILE_SHARE_READ
|FILE_SHARE_WRITE
, 0, OPEN_ALWAYS
,
6925 FILE_ATTRIBUTE_NORMAL
, 0);
6927 Tcl_AppendResult(interp
, "cannot open file: ", zFilename
, (char*)0);
6930 ev
= CreateEvent(NULL
, TRUE
, FALSE
, x
.evName
);
6932 Tcl_AppendResult(interp
, "cannot create event: ", x
.evName
, (char*)0);
6935 _beginthread(win32_file_locker
, 0, (void*)&x
);
6937 if ( (wResult
= WaitForSingleObject(ev
, 10000))!=WAIT_OBJECT_0
){
6938 sqlite3_snprintf(sizeof(zBuf
), zBuf
, "0x%x", wResult
);
6939 Tcl_AppendResult(interp
, "wait failed: ", zBuf
, (char*)0);
6948 ** exists_win32_path PATH
6950 ** Returns non-zero if the specified path exists, whose fully qualified name
6951 ** may exceed 260 characters if it is prefixed with "\\?\".
6953 static int SQLITE_TCLAPI
win32_exists_path(
6957 Tcl_Obj
*CONST objv
[]
6960 Tcl_WrongNumArgs(interp
, 1, objv
, "PATH");
6963 Tcl_SetObjResult(interp
, Tcl_NewBooleanObj(
6964 GetFileAttributesW( Tcl_GetUnicode(objv
[1]))!=INVALID_FILE_ATTRIBUTES
));
6969 ** find_win32_file PATTERN
6971 ** Returns a list of entries in a directory that match the specified pattern,
6972 ** whose fully qualified name may exceed 248 characters if it is prefixed with
6975 static int SQLITE_TCLAPI
win32_find_file(
6979 Tcl_Obj
*CONST objv
[]
6981 HANDLE hFindFile
= INVALID_HANDLE_VALUE
;
6982 WIN32_FIND_DATAW findData
;
6986 Tcl_WrongNumArgs(interp
, 1, objv
, "PATTERN");
6989 hFindFile
= FindFirstFileW(Tcl_GetUnicode(objv
[1]), &findData
);
6990 if( hFindFile
==INVALID_HANDLE_VALUE
){
6991 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj(GetLastError()));
6994 listObj
= Tcl_NewObj();
6995 Tcl_IncrRefCount(listObj
);
6997 Tcl_ListObjAppendElement(interp
, listObj
, Tcl_NewUnicodeObj(
6998 findData
.cFileName
, -1));
6999 Tcl_ListObjAppendElement(interp
, listObj
, Tcl_NewWideIntObj(
7000 findData
.dwFileAttributes
));
7001 } while( FindNextFileW(hFindFile
, &findData
) );
7002 lastErrno
= GetLastError();
7003 if( lastErrno
!=NO_ERROR
&& lastErrno
!=ERROR_NO_MORE_FILES
){
7004 FindClose(hFindFile
);
7005 Tcl_DecrRefCount(listObj
);
7006 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj(GetLastError()));
7009 FindClose(hFindFile
);
7010 Tcl_SetObjResult(interp
, listObj
);
7015 ** delete_win32_file FILENAME
7017 ** Deletes the specified file, whose fully qualified name may exceed 260
7018 ** characters if it is prefixed with "\\?\".
7020 static int SQLITE_TCLAPI
win32_delete_file(
7024 Tcl_Obj
*CONST objv
[]
7027 Tcl_WrongNumArgs(interp
, 1, objv
, "FILENAME");
7030 if( !DeleteFileW(Tcl_GetUnicode(objv
[1])) ){
7031 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj(GetLastError()));
7034 Tcl_ResetResult(interp
);
7039 ** make_win32_dir DIRECTORY
7041 ** Creates the specified directory, whose fully qualified name may exceed 248
7042 ** characters if it is prefixed with "\\?\".
7044 static int SQLITE_TCLAPI
win32_mkdir(
7048 Tcl_Obj
*CONST objv
[]
7051 Tcl_WrongNumArgs(interp
, 1, objv
, "DIRECTORY");
7054 if( !CreateDirectoryW(Tcl_GetUnicode(objv
[1]), NULL
) ){
7055 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj(GetLastError()));
7058 Tcl_ResetResult(interp
);
7063 ** remove_win32_dir DIRECTORY
7065 ** Removes the specified directory, whose fully qualified name may exceed 248
7066 ** characters if it is prefixed with "\\?\".
7068 static int SQLITE_TCLAPI
win32_rmdir(
7072 Tcl_Obj
*CONST objv
[]
7075 Tcl_WrongNumArgs(interp
, 1, objv
, "DIRECTORY");
7078 if( !RemoveDirectoryW(Tcl_GetUnicode(objv
[1])) ){
7079 Tcl_SetObjResult(interp
, Tcl_NewWideIntObj(GetLastError()));
7082 Tcl_ResetResult(interp
);
7089 ** optimization_control DB OPT BOOLEAN
7091 ** Enable or disable query optimizations using the sqlite3_test_control()
7092 ** interface. Disable if BOOLEAN is false and enable if BOOLEAN is true.
7093 ** OPT is the name of the optimization to be disabled.
7095 static int SQLITE_TCLAPI
optimization_control(
7099 Tcl_Obj
*CONST objv
[]
7106 static const struct {
7107 const char *zOptName
;
7110 { "all", SQLITE_AllOpts
},
7112 { "query-flattener", SQLITE_QueryFlattener
},
7113 { "groupby-order", SQLITE_GroupByOrder
},
7114 { "factor-constants", SQLITE_FactorOutConst
},
7115 { "distinct-opt", SQLITE_DistinctOpt
},
7116 { "cover-idx-scan", SQLITE_CoverIdxScan
},
7117 { "order-by-idx-join", SQLITE_OrderByIdxJoin
},
7118 { "transitive", SQLITE_Transitive
},
7119 { "omit-noop-join", SQLITE_OmitNoopJoin
},
7120 { "stat3", SQLITE_Stat34
},
7121 { "stat4", SQLITE_Stat34
},
7122 { "skip-scan", SQLITE_SkipScan
},
7126 Tcl_WrongNumArgs(interp
, 1, objv
, "DB OPT BOOLEAN");
7129 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
7130 if( Tcl_GetBooleanFromObj(interp
, objv
[3], &onoff
) ) return TCL_ERROR
;
7131 zOpt
= Tcl_GetString(objv
[2]);
7132 for(i
=0; i
<sizeof(aOpt
)/sizeof(aOpt
[0]); i
++){
7133 if( strcmp(zOpt
, aOpt
[i
].zOptName
)==0 ){
7134 mask
= aOpt
[i
].mask
;
7138 if( onoff
) mask
= ~mask
;
7139 if( i
>=sizeof(aOpt
)/sizeof(aOpt
[0]) ){
7140 Tcl_AppendResult(interp
, "unknown optimization - should be one of:",
7142 for(i
=0; i
<sizeof(aOpt
)/sizeof(aOpt
[0]); i
++){
7143 Tcl_AppendResult(interp
, " ", aOpt
[i
].zOptName
, (char*)0);
7147 sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS
, db
, mask
);
7152 ** load_static_extension DB NAME ...
7154 ** Load one or more statically linked extensions.
7156 static int SQLITE_TCLAPI
tclLoadStaticExtensionCmd(
7160 Tcl_Obj
*CONST objv
[]
7162 extern int sqlite3_amatch_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7163 extern int sqlite3_carray_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7164 extern int sqlite3_closure_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7165 extern int sqlite3_csv_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7166 extern int sqlite3_eval_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7167 extern int sqlite3_explain_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7168 extern int sqlite3_fileio_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7169 extern int sqlite3_fuzzer_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7170 extern int sqlite3_ieee_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7171 extern int sqlite3_nextchar_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7172 extern int sqlite3_percentile_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7173 #ifndef SQLITE_OMIT_VIRTUALTABLE
7174 extern int sqlite3_prefixes_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7176 extern int sqlite3_regexp_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7177 extern int sqlite3_remember_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7178 extern int sqlite3_series_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7179 extern int sqlite3_spellfix_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7180 extern int sqlite3_totype_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7181 extern int sqlite3_wholenumber_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7182 extern int sqlite3_unionvtab_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7183 #ifdef SQLITE_HAVE_ZLIB
7184 extern int sqlite3_zipfile_init(sqlite3
*,char**,const sqlite3_api_routines
*);
7186 static const struct {
7187 const char *zExtName
;
7188 int (*pInit
)(sqlite3
*,char**,const sqlite3_api_routines
*);
7190 { "amatch", sqlite3_amatch_init
},
7191 { "carray", sqlite3_carray_init
},
7192 { "closure", sqlite3_closure_init
},
7193 { "csv", sqlite3_csv_init
},
7194 { "eval", sqlite3_eval_init
},
7195 { "explain", sqlite3_explain_init
},
7196 { "fileio", sqlite3_fileio_init
},
7197 { "fuzzer", sqlite3_fuzzer_init
},
7198 { "ieee754", sqlite3_ieee_init
},
7199 { "nextchar", sqlite3_nextchar_init
},
7200 { "percentile", sqlite3_percentile_init
},
7201 #ifndef SQLITE_OMIT_VIRTUALTABLE
7202 { "prefixes", sqlite3_prefixes_init
},
7204 { "regexp", sqlite3_regexp_init
},
7205 { "remember", sqlite3_remember_init
},
7206 { "series", sqlite3_series_init
},
7207 { "spellfix", sqlite3_spellfix_init
},
7208 { "totype", sqlite3_totype_init
},
7209 { "unionvtab", sqlite3_unionvtab_init
},
7210 { "wholenumber", sqlite3_wholenumber_init
},
7211 #ifdef SQLITE_HAVE_ZLIB
7212 { "zipfile", sqlite3_zipfile_init
},
7220 Tcl_WrongNumArgs(interp
, 1, objv
, "DB NAME ...");
7223 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
7224 for(j
=2; j
<objc
; j
++){
7225 zName
= Tcl_GetString(objv
[j
]);
7226 for(i
=0; i
<ArraySize(aExtension
); i
++){
7227 if( strcmp(zName
, aExtension
[i
].zExtName
)==0 ) break;
7229 if( i
>=ArraySize(aExtension
) ){
7230 Tcl_AppendResult(interp
, "no such extension: ", zName
, (char*)0);
7233 if( aExtension
[i
].pInit
){
7234 rc
= aExtension
[i
].pInit(db
, &zErrMsg
, 0);
7238 if( rc
!=SQLITE_OK
|| zErrMsg
){
7239 Tcl_AppendResult(interp
, "initialization of ", zName
, " failed: ", zErrMsg
,
7241 sqlite3_free(zErrMsg
);
7249 ** sorter_test_fakeheap BOOL
7252 static int SQLITE_TCLAPI
sorter_test_fakeheap(
7256 Tcl_Obj
*CONST objv
[]
7260 Tcl_WrongNumArgs(interp
, 1, objv
, "BOOL");
7264 if( Tcl_GetBooleanFromObj(interp
, objv
[1], &bArg
) ){
7269 if( sqlite3GlobalConfig
.pHeap
==0 ){
7270 sqlite3GlobalConfig
.pHeap
= SQLITE_INT_TO_PTR(-1);
7273 if( sqlite3GlobalConfig
.pHeap
==SQLITE_INT_TO_PTR(-1) ){
7274 sqlite3GlobalConfig
.pHeap
= 0;
7278 Tcl_ResetResult(interp
);
7283 ** sorter_test_sort4_helper DB SQL1 NSTEP SQL2
7285 ** Compile SQL statement $SQL1 and step it $NSTEP times. For each row,
7286 ** check that the leftmost and rightmost columns returned are both integers,
7287 ** and that both contain the same value.
7289 ** Then execute statement $SQL2. Check that the statement returns the same
7290 ** set of integers in the same order as in the previous step (using $SQL1).
7292 static int SQLITE_TCLAPI
sorter_test_sort4_helper(
7296 Tcl_Obj
*CONST objv
[]
7302 unsigned int iCksum1
= 0;
7303 unsigned int iCksum2
= 0;
7307 sqlite3_stmt
*pStmt
;
7310 Tcl_WrongNumArgs(interp
, 1, objv
, "DB SQL1 NSTEP SQL2");
7314 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
7315 zSql1
= Tcl_GetString(objv
[2]);
7316 if( Tcl_GetIntFromObj(interp
, objv
[3], &nStep
) ) return TCL_ERROR
;
7317 zSql2
= Tcl_GetString(objv
[4]);
7319 rc
= sqlite3_prepare_v2(db
, zSql1
, -1, &pStmt
, 0);
7320 if( rc
!=SQLITE_OK
) goto sql_error
;
7322 iB
= sqlite3_column_count(pStmt
)-1;
7323 for(iStep
=0; iStep
<nStep
&& SQLITE_ROW
==sqlite3_step(pStmt
); iStep
++){
7324 int a
= sqlite3_column_int(pStmt
, 0);
7325 if( a
!=sqlite3_column_int(pStmt
, iB
) ){
7326 Tcl_AppendResult(interp
, "data error: (a!=b)", 0);
7330 iCksum1
+= (iCksum1
<< 3) + (unsigned int)a
;
7332 rc
= sqlite3_finalize(pStmt
);
7333 if( rc
!=SQLITE_OK
) goto sql_error
;
7335 rc
= sqlite3_prepare_v2(db
, zSql2
, -1, &pStmt
, 0);
7336 if( rc
!=SQLITE_OK
) goto sql_error
;
7337 for(iStep
=0; SQLITE_ROW
==sqlite3_step(pStmt
); iStep
++){
7338 int a
= sqlite3_column_int(pStmt
, 0);
7339 iCksum2
+= (iCksum2
<< 3) + (unsigned int)a
;
7341 rc
= sqlite3_finalize(pStmt
);
7342 if( rc
!=SQLITE_OK
) goto sql_error
;
7344 if( iCksum1
!=iCksum2
){
7345 Tcl_AppendResult(interp
, "checksum mismatch", 0);
7351 Tcl_AppendResult(interp
, "sql error: ", sqlite3_errmsg(db
), 0);
7356 #ifdef SQLITE_USER_AUTHENTICATION
7357 #include "sqlite3userauth.h"
7359 ** tclcmd: sqlite3_user_authenticate DB USERNAME PASSWORD
7361 static int SQLITE_TCLAPI
test_user_authenticate(
7362 ClientData clientData
, /* Unused */
7363 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
7364 int objc
, /* Number of arguments */
7365 Tcl_Obj
*CONST objv
[] /* Command arguments */
7374 Tcl_WrongNumArgs(interp
, 1, objv
, "DB USERNAME PASSWORD");
7377 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
7380 zUser
= Tcl_GetString(objv
[2]);
7381 zPasswd
= Tcl_GetStringFromObj(objv
[3], &nPasswd
);
7382 rc
= sqlite3_user_authenticate(db
, zUser
, zPasswd
, nPasswd
);
7383 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
7386 #endif /* SQLITE_USER_AUTHENTICATION */
7388 #ifdef SQLITE_USER_AUTHENTICATION
7390 ** tclcmd: sqlite3_user_add DB USERNAME PASSWORD ISADMIN
7392 static int SQLITE_TCLAPI
test_user_add(
7393 ClientData clientData
, /* Unused */
7394 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
7395 int objc
, /* Number of arguments */
7396 Tcl_Obj
*CONST objv
[] /* Command arguments */
7406 Tcl_WrongNumArgs(interp
, 1, objv
, "DB USERNAME PASSWORD ISADMIN");
7409 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
7412 zUser
= Tcl_GetString(objv
[2]);
7413 zPasswd
= Tcl_GetStringFromObj(objv
[3], &nPasswd
);
7414 Tcl_GetBooleanFromObj(interp
, objv
[4], &isAdmin
);
7415 rc
= sqlite3_user_add(db
, zUser
, zPasswd
, nPasswd
, isAdmin
);
7416 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
7419 #endif /* SQLITE_USER_AUTHENTICATION */
7421 #ifdef SQLITE_USER_AUTHENTICATION
7423 ** tclcmd: sqlite3_user_change DB USERNAME PASSWORD ISADMIN
7425 static int SQLITE_TCLAPI
test_user_change(
7426 ClientData clientData
, /* Unused */
7427 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
7428 int objc
, /* Number of arguments */
7429 Tcl_Obj
*CONST objv
[] /* Command arguments */
7439 Tcl_WrongNumArgs(interp
, 1, objv
, "DB USERNAME PASSWORD ISADMIN");
7442 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
7445 zUser
= Tcl_GetString(objv
[2]);
7446 zPasswd
= Tcl_GetStringFromObj(objv
[3], &nPasswd
);
7447 Tcl_GetBooleanFromObj(interp
, objv
[4], &isAdmin
);
7448 rc
= sqlite3_user_change(db
, zUser
, zPasswd
, nPasswd
, isAdmin
);
7449 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
7452 #endif /* SQLITE_USER_AUTHENTICATION */
7454 #ifdef SQLITE_USER_AUTHENTICATION
7456 ** tclcmd: sqlite3_user_delete DB USERNAME
7458 static int SQLITE_TCLAPI
test_user_delete(
7459 ClientData clientData
, /* Unused */
7460 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
7461 int objc
, /* Number of arguments */
7462 Tcl_Obj
*CONST objv
[] /* Command arguments */
7469 Tcl_WrongNumArgs(interp
, 1, objv
, "DB USERNAME");
7472 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ){
7475 zUser
= Tcl_GetString(objv
[2]);
7476 rc
= sqlite3_user_delete(db
, zUser
);
7477 Tcl_SetResult(interp
, (char *)t1ErrorName(rc
), TCL_STATIC
);
7480 #endif /* SQLITE_USER_AUTHENTICATION */
7483 ** tclcmd: bad_behavior TYPE
7485 ** Do some things that should trigger a valgrind or -fsanitize=undefined
7486 ** warning. This is used to verify that errors and warnings output by those
7487 ** tools are detected by the test scripts.
7490 ** 1 Overflow a signed integer
7491 ** 2 Jump based on an uninitialized variable
7492 ** 3 Read after free
7495 static int SQLITE_TCLAPI
test_bad_behavior(
7496 ClientData clientData
, /* Pointer to an integer containing zero */
7497 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
7498 int objc
, /* Number of arguments */
7499 Tcl_Obj
*CONST objv
[] /* Command arguments */
7503 int i
= *(int*)clientData
;
7508 Tcl_WrongNumArgs(interp
, 1, objv
, "TYPE");
7511 if( Tcl_GetIntFromObj(interp
, objv
[1], &iType
) ) return TCL_ERROR
;
7514 xyz
= 0x7fffff00 - i
;
7516 Tcl_SetObjResult(interp
, Tcl_NewIntObj(xyz
));
7521 if( w
[i
]>0 ) w
[1]++;
7522 Tcl_SetObjResult(interp
, Tcl_NewIntObj(w
[1]));
7526 a
= malloc( sizeof(int)*10 );
7527 for(j
=0; j
<10; j
++) a
[j
] = j
;
7529 Tcl_SetObjResult(interp
, Tcl_NewIntObj(a
[i
]));
7533 Tcl_Panic("Deliberate panic");
7541 ** tclcmd: register_dbstat_vtab DB
7543 ** Cause the dbstat virtual table to be available on the connection DB
7545 static int SQLITE_TCLAPI
test_register_dbstat_vtab(
7549 Tcl_Obj
*CONST objv
[]
7551 #ifdef SQLITE_OMIT_VIRTUALTABLE
7552 Tcl_AppendResult(interp
, "dbstat not available because of "
7553 "SQLITE_OMIT_VIRTUALTABLE", (void*)0);
7556 struct SqliteDb
{ sqlite3
*db
; };
7558 Tcl_CmdInfo cmdInfo
;
7561 Tcl_WrongNumArgs(interp
, 1, objv
, "DB");
7565 zDb
= Tcl_GetString(objv
[1]);
7566 if( Tcl_GetCommandInfo(interp
, zDb
, &cmdInfo
) ){
7567 sqlite3
* db
= ((struct SqliteDb
*)cmdInfo
.objClientData
)->db
;
7568 sqlite3DbstatRegister(db
);
7571 #endif /* SQLITE_OMIT_VIRTUALTABLE */
7575 ** tclcmd: sqlite3_db_config DB SETTING VALUE
7577 ** Invoke sqlite3_db_config() for one of the setting values.
7579 static int SQLITE_TCLAPI
test_sqlite3_db_config(
7583 Tcl_Obj
*CONST objv
[]
7585 static const struct {
7589 { "FKEY", SQLITE_DBCONFIG_ENABLE_FKEY
},
7590 { "TRIGGER", SQLITE_DBCONFIG_ENABLE_TRIGGER
},
7591 { "FTS3_TOKENIZER", SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
},
7592 { "LOAD_EXTENSION", SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
},
7593 { "NO_CKPT_ON_CLOSE",SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
},
7594 { "QPSG", SQLITE_DBCONFIG_ENABLE_QPSG
},
7595 { "TRIGGER_EQP", SQLITE_DBCONFIG_TRIGGER_EQP
},
7596 { "RESET_DB", SQLITE_DBCONFIG_RESET_DATABASE
},
7597 { "DEFENSIVE", SQLITE_DBCONFIG_DEFENSIVE
},
7601 const char *zSetting
;
7605 Tcl_WrongNumArgs(interp
, 1, objv
, "DB SETTING VALUE");
7608 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
7609 zSetting
= Tcl_GetString(objv
[2]);
7610 if( sqlite3_strglob("SQLITE_*", zSetting
)==0 ) zSetting
+= 7;
7611 if( sqlite3_strglob("DBCONFIG_*", zSetting
)==0 ) zSetting
+= 9;
7612 if( sqlite3_strglob("ENABLE_*", zSetting
)==0 ) zSetting
+= 7;
7613 for(i
=0; i
<ArraySize(aSetting
); i
++){
7614 if( strcmp(zSetting
, aSetting
[i
].zName
)==0 ) break;
7616 if( i
>=ArraySize(aSetting
) ){
7617 Tcl_SetObjResult(interp
,
7618 Tcl_NewStringObj("unknown sqlite3_db_config setting", -1));
7621 if( Tcl_GetIntFromObj(interp
, objv
[3], &v
) ) return TCL_ERROR
;
7622 sqlite3_db_config(db
, aSetting
[i
].eVal
, v
, &v
);
7623 Tcl_SetObjResult(interp
, Tcl_NewIntObj(v
));
7628 ** Change the name of the main database schema from "main" to "icecube".
7630 static int SQLITE_TCLAPI
test_dbconfig_maindbname_icecube(
7634 Tcl_Obj
*CONST objv
[]
7638 extern int getDbPointer(Tcl_Interp
*, const char*, sqlite3
**);
7640 Tcl_WrongNumArgs(interp
, 1, objv
, "DB");
7643 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
7644 rc
= sqlite3_db_config(db
, SQLITE_DBCONFIG_MAINDBNAME
, "icecube");
7645 Tcl_SetObjResult(interp
, Tcl_NewIntObj(rc
));
7651 ** Usage: sqlite3_mmap_warm DB DBNAME
7653 static int SQLITE_TCLAPI
test_mmap_warm(
7657 Tcl_Obj
*CONST objv
[]
7659 extern int getDbPointer(Tcl_Interp
*, const char*, sqlite3
**);
7660 extern int sqlite3_mmap_warm(sqlite3
*db
, const char *);
7662 if( objc
!=2 && objc
!=3 ){
7663 Tcl_WrongNumArgs(interp
, 1, objv
, "DB ?DBNAME?");
7668 const char *zDb
= 0;
7669 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
7671 zDb
= Tcl_GetString(objv
[2]);
7673 rc
= sqlite3_mmap_warm(db
, zDb
);
7674 Tcl_SetObjResult(interp
, Tcl_NewStringObj(sqlite3ErrName(rc
), -1));
7680 ** Usage: decode_hexdb TEXT
7682 ** Example: db deserialize [decode_hexdb $output_of_dbtotxt]
7684 ** This routine returns a byte-array for an SQLite database file that
7685 ** is constructed from a text input which is the output of the "dbtotxt"
7688 static int SQLITE_TCLAPI
test_decode_hexdb(
7692 Tcl_Obj
*CONST objv
[]
7694 const char *zIn
= 0;
7695 unsigned char *a
= 0;
7702 unsigned char x
[16];
7704 Tcl_WrongNumArgs(interp
, 1, objv
, "HEXDB");
7707 zIn
= Tcl_GetString(objv
[1]);
7708 for(i
=0; zIn
[i
]; i
=iNext
){
7710 for(iNext
=i
; zIn
[iNext
] && zIn
[iNext
]!='\n'; iNext
++){}
7711 if( zIn
[iNext
]=='\n' ) iNext
++;
7712 while( zIn
[i
]==' ' || zIn
[i
]=='\t' ){ i
++; }
7715 rc
= sscanf(zIn
+i
, "| size %d pagesize %d", &n
, &pgsz
);
7716 if( rc
!=2 ) continue;
7718 Tcl_AppendResult(interp
, "bad 'size' field", (void*)0);
7723 Tcl_AppendResult(interp
, "out of memory", (void*)0);
7729 rc
= sscanf(zIn
+i
, "| page %d offset %d", &j
, &k
);
7734 rc
= sscanf(zIn
+i
,"| %d: %hhx %hhx %hhx %hhx %hhx %hhx %hhx %hhx"
7735 " %hhx %hhx %hhx %hhx %hhx %hhx %hhx %hhx",
7736 &j
, &x
[0], &x
[1], &x
[2], &x
[3], &x
[4], &x
[5], &x
[6], &x
[7],
7737 &x
[8], &x
[9], &x
[10], &x
[11], &x
[12], &x
[13], &x
[14], &x
[15]);
7746 Tcl_SetObjResult(interp
, Tcl_NewByteArrayObj(a
, n
));
7753 ** Register commands with the TCL interpreter.
7755 int Sqlitetest1_Init(Tcl_Interp
*interp
){
7756 extern int sqlite3_search_count
;
7757 extern int sqlite3_found_count
;
7758 extern int sqlite3_interrupt_count
;
7759 extern int sqlite3_open_file_count
;
7760 extern int sqlite3_sort_count
;
7761 extern int sqlite3_current_time
;
7762 #if SQLITE_OS_UNIX && defined(__APPLE__) && SQLITE_ENABLE_LOCKING_STYLE
7763 extern int sqlite3_hostid_num
;
7765 extern int sqlite3_max_blobsize
;
7766 extern int SQLITE_TCLAPI
sqlite3BtreeSharedCacheReport(void*,
7767 Tcl_Interp
*,int,Tcl_Obj
*CONST
*);
7768 static int iZero
= 0;
7773 { "db_enter", (Tcl_CmdProc
*)db_enter
},
7774 { "db_leave", (Tcl_CmdProc
*)db_leave
},
7775 { "sqlite3_mprintf_int", (Tcl_CmdProc
*)sqlite3_mprintf_int
},
7776 { "sqlite3_mprintf_int64", (Tcl_CmdProc
*)sqlite3_mprintf_int64
},
7777 { "sqlite3_mprintf_long", (Tcl_CmdProc
*)sqlite3_mprintf_long
},
7778 { "sqlite3_mprintf_str", (Tcl_CmdProc
*)sqlite3_mprintf_str
},
7779 { "sqlite3_snprintf_str", (Tcl_CmdProc
*)sqlite3_snprintf_str
},
7780 { "sqlite3_mprintf_stronly", (Tcl_CmdProc
*)sqlite3_mprintf_stronly
},
7781 { "sqlite3_mprintf_double", (Tcl_CmdProc
*)sqlite3_mprintf_double
},
7782 { "sqlite3_mprintf_scaled", (Tcl_CmdProc
*)sqlite3_mprintf_scaled
},
7783 { "sqlite3_mprintf_hexdouble", (Tcl_CmdProc
*)sqlite3_mprintf_hexdouble
},
7784 { "sqlite3_mprintf_z_test", (Tcl_CmdProc
*)test_mprintf_z
},
7785 { "sqlite3_mprintf_n_test", (Tcl_CmdProc
*)test_mprintf_n
},
7786 { "sqlite3_snprintf_int", (Tcl_CmdProc
*)test_snprintf_int
},
7787 { "sqlite3_last_insert_rowid", (Tcl_CmdProc
*)test_last_rowid
},
7788 { "sqlite3_exec_printf", (Tcl_CmdProc
*)test_exec_printf
},
7789 { "sqlite3_exec_hex", (Tcl_CmdProc
*)test_exec_hex
},
7790 { "sqlite3_exec", (Tcl_CmdProc
*)test_exec
},
7791 { "sqlite3_exec_nr", (Tcl_CmdProc
*)test_exec_nr
},
7792 #ifndef SQLITE_OMIT_GET_TABLE
7793 { "sqlite3_get_table_printf", (Tcl_CmdProc
*)test_get_table_printf
},
7795 { "sqlite3_close", (Tcl_CmdProc
*)sqlite_test_close
},
7796 { "sqlite3_close_v2", (Tcl_CmdProc
*)sqlite_test_close_v2
},
7797 { "sqlite3_create_function", (Tcl_CmdProc
*)test_create_function
},
7798 { "sqlite3_create_aggregate", (Tcl_CmdProc
*)test_create_aggregate
},
7799 { "sqlite_register_test_function", (Tcl_CmdProc
*)test_register_func
},
7800 { "sqlite_abort", (Tcl_CmdProc
*)sqlite_abort
},
7801 { "sqlite_bind", (Tcl_CmdProc
*)test_bind
},
7802 { "breakpoint", (Tcl_CmdProc
*)test_breakpoint
},
7803 { "sqlite3_key", (Tcl_CmdProc
*)test_key
},
7804 { "sqlite3_rekey", (Tcl_CmdProc
*)test_rekey
},
7805 { "sqlite_set_magic", (Tcl_CmdProc
*)sqlite_set_magic
},
7806 { "sqlite3_interrupt", (Tcl_CmdProc
*)test_interrupt
},
7807 { "sqlite_delete_function", (Tcl_CmdProc
*)delete_function
},
7808 { "sqlite_delete_collation", (Tcl_CmdProc
*)delete_collation
},
7809 { "sqlite3_get_autocommit", (Tcl_CmdProc
*)get_autocommit
},
7810 { "sqlite3_busy_timeout", (Tcl_CmdProc
*)test_busy_timeout
},
7811 { "printf", (Tcl_CmdProc
*)test_printf
},
7812 { "sqlite3IoTrace", (Tcl_CmdProc
*)test_io_trace
},
7813 { "clang_sanitize_address", (Tcl_CmdProc
*)clang_sanitize_address
},
7817 Tcl_ObjCmdProc
*xProc
;
7820 { "sqlite3_db_config", test_sqlite3_db_config
, 0 },
7821 { "bad_behavior", test_bad_behavior
, (void*)&iZero
},
7822 { "register_dbstat_vtab", test_register_dbstat_vtab
},
7823 { "sqlite3_connection_pointer", get_sqlite_pointer
, 0 },
7824 { "intarray_addr", test_intarray_addr
, 0 },
7825 { "int64array_addr", test_int64array_addr
, 0 },
7826 { "doublearray_addr", test_doublearray_addr
, 0 },
7827 { "textarray_addr", test_textarray_addr
, 0 },
7828 { "sqlite3_bind_int", test_bind_int
, 0 },
7829 { "sqlite3_bind_zeroblob", test_bind_zeroblob
, 0 },
7830 { "sqlite3_bind_zeroblob64", test_bind_zeroblob64
, 0 },
7831 { "sqlite3_bind_int64", test_bind_int64
, 0 },
7832 { "sqlite3_bind_double", test_bind_double
, 0 },
7833 { "sqlite3_bind_null", test_bind_null
,0 },
7834 { "sqlite3_bind_text", test_bind_text
,0 },
7835 { "sqlite3_bind_text16", test_bind_text16
,0 },
7836 { "sqlite3_bind_blob", test_bind_blob
,0 },
7837 { "sqlite3_bind_parameter_count", test_bind_parameter_count
, 0},
7838 { "sqlite3_bind_parameter_name", test_bind_parameter_name
, 0},
7839 { "sqlite3_bind_parameter_index", test_bind_parameter_index
, 0},
7840 { "sqlite3_clear_bindings", test_clear_bindings
, 0},
7841 { "sqlite3_sleep", test_sleep
, 0},
7842 { "sqlite3_errcode", test_errcode
,0 },
7843 { "sqlite3_extended_errcode", test_ex_errcode
,0 },
7844 { "sqlite3_errmsg", test_errmsg
,0 },
7845 { "sqlite3_errmsg16", test_errmsg16
,0 },
7846 { "sqlite3_open", test_open
,0 },
7847 { "sqlite3_open16", test_open16
,0 },
7848 { "sqlite3_open_v2", test_open_v2
,0 },
7849 { "sqlite3_complete16", test_complete16
,0 },
7850 { "sqlite3_normalize", test_normalize
,0 },
7852 { "sqlite3_prepare", test_prepare
,0 },
7853 { "sqlite3_prepare16", test_prepare16
,0 },
7854 { "sqlite3_prepare_v2", test_prepare_v2
,0 },
7855 { "sqlite3_prepare_v3", test_prepare_v3
,0 },
7856 { "sqlite3_prepare_tkt3134", test_prepare_tkt3134
, 0},
7857 { "sqlite3_prepare16_v2", test_prepare16_v2
,0 },
7858 { "sqlite3_finalize", test_finalize
,0 },
7859 { "sqlite3_stmt_status", test_stmt_status
,0 },
7860 { "sqlite3_reset", test_reset
,0 },
7861 { "sqlite3_expired", test_expired
,0 },
7862 { "sqlite3_transfer_bindings", test_transfer_bind
,0 },
7863 { "sqlite3_changes", test_changes
,0 },
7864 { "sqlite3_step", test_step
,0 },
7865 { "sqlite3_sql", test_sql
,0 },
7866 { "sqlite3_expanded_sql", test_ex_sql
,0 },
7867 #ifdef SQLITE_ENABLE_NORMALIZE
7868 { "sqlite3_normalized_sql", test_norm_sql
,0 },
7870 { "sqlite3_next_stmt", test_next_stmt
,0 },
7871 { "sqlite3_stmt_readonly", test_stmt_readonly
,0 },
7872 { "sqlite3_stmt_isexplain", test_stmt_isexplain
,0 },
7873 { "sqlite3_stmt_busy", test_stmt_busy
,0 },
7874 { "uses_stmt_journal", uses_stmt_journal
,0 },
7876 { "sqlite3_release_memory", test_release_memory
, 0},
7877 { "sqlite3_db_release_memory", test_db_release_memory
, 0},
7878 { "sqlite3_db_cacheflush", test_db_cacheflush
, 0},
7879 { "sqlite3_system_errno", test_system_errno
, 0},
7880 { "sqlite3_db_filename", test_db_filename
, 0},
7881 { "sqlite3_db_readonly", test_db_readonly
, 0},
7882 { "sqlite3_soft_heap_limit", test_soft_heap_limit
, 0},
7883 { "sqlite3_thread_cleanup", test_thread_cleanup
, 0},
7884 { "sqlite3_pager_refcounts", test_pager_refcounts
, 0},
7886 { "sqlite3_load_extension", test_load_extension
, 0},
7887 { "sqlite3_enable_load_extension", test_enable_load
, 0},
7888 { "sqlite3_extended_result_codes", test_extended_result_codes
, 0},
7889 { "sqlite3_limit", test_limit
, 0},
7890 { "dbconfig_maindbname_icecube", test_dbconfig_maindbname_icecube
},
7892 { "save_prng_state", save_prng_state
, 0 },
7893 { "restore_prng_state", restore_prng_state
, 0 },
7894 { "reset_prng_state", reset_prng_state
, 0 },
7895 { "database_never_corrupt", database_never_corrupt
, 0},
7896 { "database_may_be_corrupt", database_may_be_corrupt
, 0},
7897 { "optimization_control", optimization_control
,0},
7899 { "lock_win32_file", win32_file_lock
, 0 },
7900 { "exists_win32_path", win32_exists_path
, 0 },
7901 { "find_win32_file", win32_find_file
, 0 },
7902 { "delete_win32_file", win32_delete_file
, 0 },
7903 { "make_win32_dir", win32_mkdir
, 0 },
7904 { "remove_win32_dir", win32_rmdir
, 0 },
7906 { "tcl_objproc", runAsObjProc
, 0 },
7908 /* sqlite3_column_*() API */
7909 { "sqlite3_column_count", test_column_count
,0 },
7910 { "sqlite3_data_count", test_data_count
,0 },
7911 { "sqlite3_column_type", test_column_type
,0 },
7912 { "sqlite3_column_blob", test_column_blob
,0 },
7913 { "sqlite3_column_double", test_column_double
,0 },
7914 { "sqlite3_column_int64", test_column_int64
,0 },
7915 { "sqlite3_column_text", test_stmt_utf8
, (void*)sqlite3_column_text
},
7916 { "sqlite3_column_name", test_stmt_utf8
, (void*)sqlite3_column_name
},
7917 { "sqlite3_column_int", test_stmt_int
, (void*)sqlite3_column_int
},
7918 { "sqlite3_column_bytes", test_stmt_int
, (void*)sqlite3_column_bytes
},
7919 #ifndef SQLITE_OMIT_DECLTYPE
7920 { "sqlite3_column_decltype",test_stmt_utf8
,(void*)sqlite3_column_decltype
},
7922 #ifdef SQLITE_ENABLE_COLUMN_METADATA
7923 { "sqlite3_column_database_name",test_stmt_utf8
,(void*)sqlite3_column_database_name
},
7924 { "sqlite3_column_table_name",test_stmt_utf8
,(void*)sqlite3_column_table_name
},
7925 { "sqlite3_column_origin_name",test_stmt_utf8
,(void*)sqlite3_column_origin_name
},
7928 #ifndef SQLITE_OMIT_UTF16
7929 { "sqlite3_column_bytes16", test_stmt_int
, (void*)sqlite3_column_bytes16
},
7930 { "sqlite3_column_text16", test_stmt_utf16
, (void*)sqlite3_column_text16
},
7931 { "sqlite3_column_name16", test_stmt_utf16
, (void*)sqlite3_column_name16
},
7932 { "add_alignment_test_collations", add_alignment_test_collations
, 0 },
7933 #ifndef SQLITE_OMIT_DECLTYPE
7934 { "sqlite3_column_decltype16",test_stmt_utf16
,(void*)sqlite3_column_decltype16
},
7936 #ifdef SQLITE_ENABLE_COLUMN_METADATA
7937 {"sqlite3_column_database_name16",
7938 test_stmt_utf16
, (void*)sqlite3_column_database_name16
},
7939 {"sqlite3_column_table_name16", test_stmt_utf16
, (void*)sqlite3_column_table_name16
},
7940 {"sqlite3_column_origin_name16", test_stmt_utf16
, (void*)sqlite3_column_origin_name16
},
7943 { "sqlite3_create_collation_v2", test_create_collation_v2
, 0 },
7944 { "sqlite3_global_recover", test_global_recover
, 0 },
7945 { "working_64bit_int", working_64bit_int
, 0 },
7946 { "vfs_unlink_test", vfs_unlink_test
, 0 },
7947 { "vfs_initfail_test", vfs_initfail_test
, 0 },
7948 { "vfs_unregister_all", vfs_unregister_all
, 0 },
7949 { "vfs_reregister_all", vfs_reregister_all
, 0 },
7950 { "file_control_test", file_control_test
, 0 },
7951 { "file_control_lasterrno_test", file_control_lasterrno_test
, 0 },
7952 { "file_control_lockproxy_test", file_control_lockproxy_test
, 0 },
7953 { "file_control_chunksize_test", file_control_chunksize_test
, 0 },
7954 { "file_control_sizehint_test", file_control_sizehint_test
, 0 },
7955 { "file_control_data_version", file_control_data_version
, 0 },
7957 { "file_control_win32_av_retry", file_control_win32_av_retry
, 0 },
7958 { "file_control_win32_get_handle", file_control_win32_get_handle
, 0 },
7959 { "file_control_win32_set_handle", file_control_win32_set_handle
, 0 },
7961 { "file_control_persist_wal", file_control_persist_wal
, 0 },
7962 { "file_control_powersafe_overwrite",file_control_powersafe_overwrite
,0},
7963 { "file_control_vfsname", file_control_vfsname
, 0 },
7964 { "file_control_tempfilename", file_control_tempfilename
, 0 },
7965 { "sqlite3_vfs_list", vfs_list
, 0 },
7966 { "sqlite3_create_function_v2", test_create_function_v2
, 0 },
7968 /* Functions from os.h */
7969 #ifndef SQLITE_OMIT_UTF16
7970 { "add_test_collate", test_collate
, 0 },
7971 { "add_test_collate_needed", test_collate_needed
, 0 },
7972 { "add_test_function", test_function
, 0 },
7973 { "add_test_utf16bin_collate", test_utf16bin_collate
, 0 },
7975 { "sqlite3_test_errstr", test_errstr
, 0 },
7976 { "tcl_variable_type", tcl_variable_type
, 0 },
7977 #ifndef SQLITE_OMIT_SHARED_CACHE
7978 { "sqlite3_enable_shared_cache", test_enable_shared
, 0 },
7979 { "sqlite3_shared_cache_report", sqlite3BtreeSharedCacheReport
, 0},
7981 { "sqlite3_libversion_number", test_libversion_number
, 0 },
7982 { "sqlite3_table_column_metadata", test_table_column_metadata
, 0 },
7983 #ifndef SQLITE_OMIT_INCRBLOB
7984 { "sqlite3_blob_reopen", test_blob_reopen
, 0 },
7986 { "pcache_stats", test_pcache_stats
, 0 },
7987 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
7988 { "sqlite3_unlock_notify", test_unlock_notify
, 0 },
7990 { "sqlite3_wal_checkpoint", test_wal_checkpoint
, 0 },
7991 { "sqlite3_wal_checkpoint_v2",test_wal_checkpoint_v2
, 0 },
7992 { "sqlite3_wal_autocheckpoint",test_wal_autocheckpoint
, 0 },
7993 { "test_sqlite3_log", test_sqlite3_log
, 0 },
7994 #ifndef SQLITE_OMIT_EXPLAIN
7995 { "print_explain_query_plan", test_print_eqp
, 0 },
7997 { "sqlite3_test_control", test_test_control
},
7999 { "getrusage", test_getrusage
},
8001 { "load_static_extension", tclLoadStaticExtensionCmd
},
8002 { "sorter_test_fakeheap", sorter_test_fakeheap
},
8003 { "sorter_test_sort4_helper", sorter_test_sort4_helper
},
8004 #ifdef SQLITE_USER_AUTHENTICATION
8005 { "sqlite3_user_authenticate", test_user_authenticate
, 0 },
8006 { "sqlite3_user_add", test_user_add
, 0 },
8007 { "sqlite3_user_change", test_user_change
, 0 },
8008 { "sqlite3_user_delete", test_user_delete
, 0 },
8010 #ifdef SQLITE_ENABLE_STMT_SCANSTATUS
8011 { "sqlite3_stmt_scanstatus", test_stmt_scanstatus
, 0 },
8012 { "sqlite3_stmt_scanstatus_reset", test_stmt_scanstatus_reset
, 0 },
8014 #ifdef SQLITE_ENABLE_SQLLOG
8015 { "sqlite3_config_sqllog", test_config_sqllog
, 0 },
8017 { "vfs_current_time_int64", vfsCurrentTimeInt64
, 0 },
8018 #ifdef SQLITE_ENABLE_SNAPSHOT
8019 { "sqlite3_snapshot_get", test_snapshot_get
, 0 },
8020 { "sqlite3_snapshot_open", test_snapshot_open
, 0 },
8021 { "sqlite3_snapshot_free", test_snapshot_free
, 0 },
8022 { "sqlite3_snapshot_cmp", test_snapshot_cmp
, 0 },
8023 { "sqlite3_snapshot_recover", test_snapshot_recover
, 0 },
8024 { "sqlite3_snapshot_get_blob", test_snapshot_get_blob
, 0 },
8025 { "sqlite3_snapshot_open_blob", test_snapshot_open_blob
, 0 },
8026 { "sqlite3_snapshot_cmp_blob", test_snapshot_cmp_blob
, 0 },
8028 { "sqlite3_delete_database", test_delete_database
, 0 },
8029 { "atomic_batch_write", test_atomic_batch_write
, 0 },
8030 { "sqlite3_mmap_warm", test_mmap_warm
, 0 },
8031 { "sqlite3_config_sorterref", test_config_sorterref
, 0 },
8032 { "decode_hexdb", test_decode_hexdb
, 0 },
8034 static int bitmask_size
= sizeof(Bitmask
)*8;
8035 static int longdouble_size
= sizeof(LONGDOUBLE_TYPE
);
8037 extern int sqlite3_sync_count
, sqlite3_fullsync_count
;
8038 extern int sqlite3_opentemp_count
;
8039 extern int sqlite3_like_count
;
8040 extern int sqlite3_xferopt_count
;
8041 extern int sqlite3_pager_readdb_count
;
8042 extern int sqlite3_pager_writedb_count
;
8043 extern int sqlite3_pager_writej_count
;
8045 extern LONG
volatile sqlite3_os_type
;
8048 extern int sqlite3WhereTrace
;
8049 extern int sqlite3OSTrace
;
8050 extern int sqlite3WalTrace
;
8053 #ifdef SQLITE_ENABLE_FTS3
8054 extern int sqlite3_fts3_enable_parentheses
;
8057 #if defined(SQLITE_ENABLE_SELECTTRACE)
8058 extern int sqlite3SelectTrace
;
8061 for(i
=0; i
<sizeof(aCmd
)/sizeof(aCmd
[0]); i
++){
8062 Tcl_CreateCommand(interp
, aCmd
[i
].zName
, aCmd
[i
].xProc
, 0, 0);
8064 for(i
=0; i
<sizeof(aObjCmd
)/sizeof(aObjCmd
[0]); i
++){
8065 Tcl_CreateObjCommand(interp
, aObjCmd
[i
].zName
,
8066 aObjCmd
[i
].xProc
, aObjCmd
[i
].clientData
, 0);
8068 Tcl_LinkVar(interp
, "sqlite_search_count",
8069 (char*)&sqlite3_search_count
, TCL_LINK_INT
);
8070 Tcl_LinkVar(interp
, "sqlite_found_count",
8071 (char*)&sqlite3_found_count
, TCL_LINK_INT
);
8072 Tcl_LinkVar(interp
, "sqlite_sort_count",
8073 (char*)&sqlite3_sort_count
, TCL_LINK_INT
);
8074 Tcl_LinkVar(interp
, "sqlite3_max_blobsize",
8075 (char*)&sqlite3_max_blobsize
, TCL_LINK_INT
);
8076 Tcl_LinkVar(interp
, "sqlite_like_count",
8077 (char*)&sqlite3_like_count
, TCL_LINK_INT
);
8078 Tcl_LinkVar(interp
, "sqlite_interrupt_count",
8079 (char*)&sqlite3_interrupt_count
, TCL_LINK_INT
);
8080 Tcl_LinkVar(interp
, "sqlite_open_file_count",
8081 (char*)&sqlite3_open_file_count
, TCL_LINK_INT
);
8082 Tcl_LinkVar(interp
, "sqlite_current_time",
8083 (char*)&sqlite3_current_time
, TCL_LINK_INT
);
8084 #if SQLITE_OS_UNIX && defined(__APPLE__) && SQLITE_ENABLE_LOCKING_STYLE
8085 Tcl_LinkVar(interp
, "sqlite_hostid_num",
8086 (char*)&sqlite3_hostid_num
, TCL_LINK_INT
);
8088 Tcl_LinkVar(interp
, "sqlite3_xferopt_count",
8089 (char*)&sqlite3_xferopt_count
, TCL_LINK_INT
);
8090 Tcl_LinkVar(interp
, "sqlite3_pager_readdb_count",
8091 (char*)&sqlite3_pager_readdb_count
, TCL_LINK_INT
);
8092 Tcl_LinkVar(interp
, "sqlite3_pager_writedb_count",
8093 (char*)&sqlite3_pager_writedb_count
, TCL_LINK_INT
);
8094 Tcl_LinkVar(interp
, "sqlite3_pager_writej_count",
8095 (char*)&sqlite3_pager_writej_count
, TCL_LINK_INT
);
8096 #ifndef SQLITE_OMIT_UTF16
8097 Tcl_LinkVar(interp
, "unaligned_string_counter",
8098 (char*)&unaligned_string_counter
, TCL_LINK_INT
);
8100 #ifndef SQLITE_OMIT_UTF16
8101 Tcl_LinkVar(interp
, "sqlite_last_needed_collation",
8102 (char*)&pzNeededCollation
, TCL_LINK_STRING
|TCL_LINK_READ_ONLY
);
8105 Tcl_LinkVar(interp
, "sqlite_os_type",
8106 (char*)&sqlite3_os_type
, TCL_LINK_LONG
);
8110 static const char *query_plan
= "*** OBSOLETE VARIABLE ***";
8111 Tcl_LinkVar(interp
, "sqlite_query_plan",
8112 (char*)&query_plan
, TCL_LINK_STRING
|TCL_LINK_READ_ONLY
);
8116 Tcl_LinkVar(interp
, "sqlite_where_trace",
8117 (char*)&sqlite3WhereTrace
, TCL_LINK_INT
);
8118 Tcl_LinkVar(interp
, "sqlite_os_trace",
8119 (char*)&sqlite3OSTrace
, TCL_LINK_INT
);
8120 #ifndef SQLITE_OMIT_WAL
8121 Tcl_LinkVar(interp
, "sqlite_wal_trace",
8122 (char*)&sqlite3WalTrace
, TCL_LINK_INT
);
8125 #ifndef SQLITE_OMIT_DISKIO
8126 Tcl_LinkVar(interp
, "sqlite_opentemp_count",
8127 (char*)&sqlite3_opentemp_count
, TCL_LINK_INT
);
8129 Tcl_LinkVar(interp
, "sqlite_static_bind_value",
8130 (char*)&sqlite_static_bind_value
, TCL_LINK_STRING
);
8131 Tcl_LinkVar(interp
, "sqlite_static_bind_nbyte",
8132 (char*)&sqlite_static_bind_nbyte
, TCL_LINK_INT
);
8133 Tcl_LinkVar(interp
, "sqlite_temp_directory",
8134 (char*)&sqlite3_temp_directory
, TCL_LINK_STRING
);
8135 Tcl_LinkVar(interp
, "sqlite_data_directory",
8136 (char*)&sqlite3_data_directory
, TCL_LINK_STRING
);
8137 Tcl_LinkVar(interp
, "bitmask_size",
8138 (char*)&bitmask_size
, TCL_LINK_INT
|TCL_LINK_READ_ONLY
);
8139 Tcl_LinkVar(interp
, "longdouble_size",
8140 (char*)&longdouble_size
, TCL_LINK_INT
|TCL_LINK_READ_ONLY
);
8141 Tcl_LinkVar(interp
, "sqlite_sync_count",
8142 (char*)&sqlite3_sync_count
, TCL_LINK_INT
);
8143 Tcl_LinkVar(interp
, "sqlite_fullsync_count",
8144 (char*)&sqlite3_fullsync_count
, TCL_LINK_INT
);
8145 #if defined(SQLITE_ENABLE_SELECTTRACE)
8146 Tcl_LinkVar(interp
, "sqlite3SelectTrace",
8147 (char*)&sqlite3SelectTrace
, TCL_LINK_INT
);
8149 #if defined(SQLITE_ENABLE_FTS3) && defined(SQLITE_TEST)
8150 Tcl_LinkVar(interp
, "sqlite_fts3_enable_parentheses",
8151 (char*)&sqlite3_fts3_enable_parentheses
, TCL_LINK_INT
);