/*
** 2001 September 15
**
** The author disclaims copyright to this source code. In place of
** a legal notice, here is a blessing:
**
** May you do good and not evil.
** May you find forgiveness for yourself and forgive others.
** May you share freely, never taking more than you give.
**
*************************************************************************
** Code for testing the pager.c module in SQLite. This code
** is not included in the SQLite library. It is used for automated
** testing of the SQLite library.
*/
#include "sqliteInt.h"
#if defined(INCLUDE_SQLITE_TCL_H)
# include "sqlite_tcl.h"
#else
# include "tcl.h"
#endif
#include <stdlib.h>
#include <string.h>
#include <ctype.h>

extern const char *sqlite3ErrName(int);

/*
** Page size and reserved size used for testing.
*/
static int test_pagesize = 1024;

/*
** Dummy page reinitializer
*/
static void pager_test_reiniter(DbPage *pNotUsed){
 return;
}

/*
** Usage: pager_open FILENAME N-PAGE
**
** Open a new pager
*/
static int SQLITE_TCLAPI pager_open(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 u32 pageSize;
 Pager *pPager;
 int nPage;
 int rc;
 char zBuf[100];
 if( argc!=3 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " FILENAME N-PAGE\"", 0);
 return TCL_ERROR;
 }
 if( Tcl_GetInt(interp, argv[2], &nPage) ) return TCL_ERROR;
 rc = sqlite3PagerOpen(sqlite3_vfs_find(0), &pPager, argv[1], 0, 0,
 SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_MAIN_DB,
 pager_test_reiniter);
 if( rc!=SQLITE_OK ){
 Tcl_AppendResult(interp, sqlite3ErrName(rc), 0);
 return TCL_ERROR;
 }
 sqlite3PagerSetCachesize(pPager, nPage);
 pageSize = test_pagesize;
 sqlite3PagerSetPagesize(pPager, &pageSize, -1);
 sqlite3_snprintf(sizeof(zBuf),zBuf,"%p",pPager);
 Tcl_AppendResult(interp, zBuf, 0);
 return TCL_OK;
}

/*
** Usage: pager_close ID
**
** Close the given pager.
*/
static int SQLITE_TCLAPI pager_close(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 Pager *pPager;
 int rc;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " ID\"", 0);
 return TCL_ERROR;
 }
 pPager = sqlite3TestTextToPtr(argv[1]);
 rc = sqlite3PagerClose(pPager, 0);
 if( rc!=SQLITE_OK ){
 Tcl_AppendResult(interp, sqlite3ErrName(rc), 0);
 return TCL_ERROR;
 }
 return TCL_OK;
}

/*
** Usage: pager_rollback ID
**
** Rollback changes
*/
static int SQLITE_TCLAPI pager_rollback(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 Pager *pPager;
 int rc;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " ID\"", 0);
 return TCL_ERROR;
 }
 pPager = sqlite3TestTextToPtr(argv[1]);
 rc = sqlite3PagerRollback(pPager);
 if( rc!=SQLITE_OK ){
 Tcl_AppendResult(interp, sqlite3ErrName(rc), 0);
 return TCL_ERROR;
 }
 return TCL_OK;
}

/*
** Usage: pager_commit ID
**
** Commit all changes
*/
static int SQLITE_TCLAPI pager_commit(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 Pager *pPager;
 int rc;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " ID\"", 0);
 return TCL_ERROR;
 }
 pPager = sqlite3TestTextToPtr(argv[1]);
 rc = sqlite3PagerCommitPhaseOne(pPager, 0, 0);
 if( rc!=SQLITE_OK ){
 Tcl_AppendResult(interp, sqlite3ErrName(rc), 0);
 return TCL_ERROR;
 }
 rc = sqlite3PagerCommitPhaseTwo(pPager);
 if( rc!=SQLITE_OK ){
 Tcl_AppendResult(interp, sqlite3ErrName(rc), 0);
 return TCL_ERROR;
 }
 return TCL_OK;
}

/*
** Usage: pager_stmt_begin ID
**
** Start a new checkpoint.
*/
static int SQLITE_TCLAPI pager_stmt_begin(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 Pager *pPager;
 int rc;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " ID\"", 0);
 return TCL_ERROR;
 }
 pPager = sqlite3TestTextToPtr(argv[1]);
 rc = sqlite3PagerOpenSavepoint(pPager, 1);
 if( rc!=SQLITE_OK ){
 Tcl_AppendResult(interp, sqlite3ErrName(rc), 0);
 return TCL_ERROR;
 }
 return TCL_OK;
}

/*
** Usage: pager_stmt_rollback ID
**
** Rollback changes to a checkpoint
*/
static int SQLITE_TCLAPI pager_stmt_rollback(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 Pager *pPager;
 int rc;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " ID\"", 0);
 return TCL_ERROR;
 }
 pPager = sqlite3TestTextToPtr(argv[1]);
 rc = sqlite3PagerSavepoint(pPager, SAVEPOINT_ROLLBACK, 0);
 sqlite3PagerSavepoint(pPager, SAVEPOINT_RELEASE, 0);
 if( rc!=SQLITE_OK ){
 Tcl_AppendResult(interp, sqlite3ErrName(rc), 0);
 return TCL_ERROR;
 }
 return TCL_OK;
}

/*
** Usage: pager_stmt_commit ID
**
** Commit changes to a checkpoint
*/
static int SQLITE_TCLAPI pager_stmt_commit(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 Pager *pPager;
 int rc;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " ID\"", 0);
 return TCL_ERROR;
 }
 pPager = sqlite3TestTextToPtr(argv[1]);
 rc = sqlite3PagerSavepoint(pPager, SAVEPOINT_RELEASE, 0);
 if( rc!=SQLITE_OK ){
 Tcl_AppendResult(interp, sqlite3ErrName(rc), 0);
 return TCL_ERROR;
 }
 return TCL_OK;
}

/*
** Usage: pager_stats ID
**
** Return pager statistics.
*/
static int SQLITE_TCLAPI pager_stats(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 Pager *pPager;
 int i, *a;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " ID\"", 0);
 return TCL_ERROR;
 }
 pPager = sqlite3TestTextToPtr(argv[1]);
 a = sqlite3PagerStats(pPager);
 for(i=0; i<9; i++){
 static char *zName[] = {
 "ref", "page", "max", "size", "state", "err",
 "hit", "miss", "ovfl",
 };
 char zBuf[100];
 Tcl_AppendElement(interp, zName[i]);
 sqlite3_snprintf(sizeof(zBuf),zBuf,"%d",a[i]);
 Tcl_AppendElement(interp, zBuf);
 }
 return TCL_OK;
}

/*
** Usage: pager_pagecount ID
**
** Return the size of the database file.
*/
static int SQLITE_TCLAPI pager_pagecount(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 Pager *pPager;
 char zBuf[100];
 int nPage;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " ID\"", 0);
 return TCL_ERROR;
 }
 pPager = sqlite3TestTextToPtr(argv[1]);
 sqlite3PagerPagecount(pPager, &nPage);
 sqlite3_snprintf(sizeof(zBuf), zBuf, "%d", nPage);
 Tcl_AppendResult(interp, zBuf, 0);
 return TCL_OK;
}

/*
** Usage: page_get ID PGNO
**
** Return a pointer to a page from the database.
*/
static int SQLITE_TCLAPI page_get(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 Pager *pPager;
 char zBuf[100];
 DbPage *pPage = 0;
 int pgno;
 int rc;
 if( argc!=3 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " ID PGNO\"", 0);
 return TCL_ERROR;
 }
 pPager = sqlite3TestTextToPtr(argv[1]);
 if( Tcl_GetInt(interp, argv[2], &pgno) ) return TCL_ERROR;
 rc = sqlite3PagerSharedLock(pPager);
 if( rc==SQLITE_OK ){
 rc = sqlite3PagerGet(pPager, pgno, &pPage, 0);
 }
 if( rc!=SQLITE_OK ){
 Tcl_AppendResult(interp, sqlite3ErrName(rc), 0);
 return TCL_ERROR;
 }
 sqlite3_snprintf(sizeof(zBuf),zBuf,"%p",pPage);
 Tcl_AppendResult(interp, zBuf, 0);
 return TCL_OK;
}

/*
** Usage: page_lookup ID PGNO
**
** Return a pointer to a page if the page is already in cache.
** If not in cache, return an empty string.
*/
static int SQLITE_TCLAPI page_lookup(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 Pager *pPager;
 char zBuf[100];
 DbPage *pPage;
 int pgno;
 if( argc!=3 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " ID PGNO\"", 0);
 return TCL_ERROR;
 }
 pPager = sqlite3TestTextToPtr(argv[1]);
 if( Tcl_GetInt(interp, argv[2], &pgno) ) return TCL_ERROR;
 pPage = sqlite3PagerLookup(pPager, pgno);
 if( pPage ){
 sqlite3_snprintf(sizeof(zBuf),zBuf,"%p",pPage);
 Tcl_AppendResult(interp, zBuf, 0);
 }
 return TCL_OK;
}

/*
** Usage: pager_truncate ID PGNO
*/
static int SQLITE_TCLAPI pager_truncate(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 Pager *pPager;
 int pgno;
 if( argc!=3 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " ID PGNO\"", 0);
 return TCL_ERROR;
 }
 pPager = sqlite3TestTextToPtr(argv[1]);
 if( Tcl_GetInt(interp, argv[2], &pgno) ) return TCL_ERROR;
 sqlite3PagerTruncateImage(pPager, pgno);
 return TCL_OK;
}


/*
** Usage: page_unref PAGE
**
** Drop a pointer to a page.
*/
static int SQLITE_TCLAPI page_unref(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 DbPage *pPage;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " PAGE\"", 0);
 return TCL_ERROR;
 }
 pPage = (DbPage *)sqlite3TestTextToPtr(argv[1]);
 sqlite3PagerUnref(pPage);
 return TCL_OK;
}

/*
** Usage: page_read PAGE
**
** Return the content of a page
*/
static int SQLITE_TCLAPI page_read(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 char zBuf[100];
 DbPage *pPage;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " PAGE\"", 0);
 return TCL_ERROR;
 }
 pPage = sqlite3TestTextToPtr(argv[1]);
 memcpy(zBuf, sqlite3PagerGetData(pPage), sizeof(zBuf));
 Tcl_AppendResult(interp, zBuf, 0);
 return TCL_OK;
}

/*
** Usage: page_number PAGE
**
** Return the page number for a page.
*/
static int SQLITE_TCLAPI page_number(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 char zBuf[100];
 DbPage *pPage;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " PAGE\"", 0);
 return TCL_ERROR;
 }
 pPage = (DbPage *)sqlite3TestTextToPtr(argv[1]);
 sqlite3_snprintf(sizeof(zBuf), zBuf, "%d", sqlite3PagerPagenumber(pPage));
 Tcl_AppendResult(interp, zBuf, 0);
 return TCL_OK;
}

/*
** Usage: page_write PAGE DATA
**
** Write something into a page.
*/
static int SQLITE_TCLAPI page_write(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 DbPage *pPage;
 char *pData;
 int rc;
 if( argc!=3 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " PAGE DATA\"", 0);
 return TCL_ERROR;
 }
 pPage = (DbPage *)sqlite3TestTextToPtr(argv[1]);
 rc = sqlite3PagerWrite(pPage);
 if( rc!=SQLITE_OK ){
 Tcl_AppendResult(interp, sqlite3ErrName(rc), 0);
 return TCL_ERROR;
 }
 pData = sqlite3PagerGetData(pPage);
 strncpy(pData, argv[2], test_pagesize-1);
 pData[test_pagesize-1] = 0;
 return TCL_OK;
}

#ifndef SQLITE_OMIT_DISKIO
/*
** Usage: fake_big_file N FILENAME
**
** Write a few bytes at the N megabyte point of FILENAME. This will
** create a large file. If the file was a valid SQLite database, then
** the next time the database is opened, SQLite will begin allocating
** new pages after N. If N is 2096 or bigger, this will test the
** ability of SQLite to write to large files.
*/
static int SQLITE_TCLAPI fake_big_file(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 sqlite3_vfs *pVfs;
 sqlite3_file *fd = 0;
 int rc;
 int n;
 i64 offset;
 char *zFile;
 int nFile;
 if( argc!=3 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " N-MEGABYTES FILE\"", 0);
 return TCL_ERROR;
 }
 if( Tcl_GetInt(interp, argv[1], &n) ) return TCL_ERROR;
#if defined(_WIN32)
 if( n>2 ){
 Tcl_AppendResult(interp, "cannot create ", argv[1],
 "MB file because Windows "
 "does not support sparse files", (void*)0);
 return TCL_ERROR;
 }
#endif

 pVfs = sqlite3_vfs_find(0);
 nFile = (int)strlen(argv[2]);
 zFile = sqlite3_malloc( nFile+2 );
 if( zFile==0 ) return TCL_ERROR;
 memcpy(zFile, argv[2], nFile+1);
 zFile[nFile+1] = 0;
 rc = sqlite3OsOpenMalloc(pVfs, zFile, &fd, 
 (SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE|SQLITE_OPEN_MAIN_DB), 0
 );
 if( rc ){
 Tcl_AppendResult(interp, "open failed: ", sqlite3ErrName(rc), 0);
 sqlite3_free(zFile);
 return TCL_ERROR;
 }
 offset = n;
 offset *= 1024*1024;
 rc = sqlite3OsWrite(fd, "Hello, World!", 14, offset);
 sqlite3OsCloseFree(fd);
 sqlite3_free(zFile);
 if( rc ){
 Tcl_AppendResult(interp, "write failed: ", sqlite3ErrName(rc), 0);
 return TCL_ERROR;
 }
 return TCL_OK;
}
#endif


/*
** test_control_pending_byte PENDING_BYTE
**
** Set the PENDING_BYTE using the sqlite3_test_control() interface.
*/
static int SQLITE_TCLAPI testPendingByte(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 int pbyte;
 int rc;
 if( argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " PENDING-BYTE\"", (void*)0);
 return TCL_ERROR;
 }
 if( Tcl_GetInt(interp, argv[1], &pbyte) ) return TCL_ERROR;
 rc = sqlite3_test_control(SQLITE_TESTCTRL_PENDING_BYTE, pbyte);
 Tcl_SetObjResult(interp, Tcl_NewIntObj(rc));
 return TCL_OK;
}

/*
** The sqlite3FaultSim() callback:
*/
static Tcl_Interp *faultSimInterp = 0;
static int faultSimScriptSize = 0;
static char *faultSimScript;
static int faultSimCallback(int x){
 char zInt[30];
 int i;
 int isNeg;
 int rc;
 if( x==0 ){
 memcpy(faultSimScript+faultSimScriptSize, "0", 2);
 }else{
 /* Convert x to text without using any sqlite3 routines */
 if( x<0 ){
 isNeg = 1;
 x = -x;
 }else{
 isNeg = 0;
 }
 zInt[sizeof(zInt)-1] = 0;
 for(i=sizeof(zInt)-2; i>0 && x>0; i--, x /= 10){
 zInt[i] = (x%10) + '0';
 }
 if( isNeg ) zInt[i--] = '-';
 memcpy(faultSimScript+faultSimScriptSize, zInt+i+1, sizeof(zInt)-i-1);
 }
 rc = Tcl_Eval(faultSimInterp, faultSimScript);
 if( rc ){
 fprintf(stderr, "fault simulator script failed: [%s]", faultSimScript);
 rc = SQLITE_ERROR;
 }else{
 rc = atoi(Tcl_GetStringResult(faultSimInterp));
 }
 Tcl_ResetResult(faultSimInterp);
 return rc;
}

/*
** sqlite3_test_control_fault_install SCRIPT
**
** Arrange to invoke SCRIPT with the integer argument to sqlite3FaultSim()
** appended, whenever sqlite3FaultSim() is called. Or, if SCRIPT is the
** empty string, cancel the sqlite3FaultSim() callback.
*/
static int SQLITE_TCLAPI faultInstallCmd(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 const char *zScript;
 int nScript;
 int rc;
 if( argc!=1 && argc!=2 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " SCRIPT\"", (void*)0);
 }
 zScript = argc==2 ? argv[1] : "";
 nScript = (int)strlen(zScript);
 if( faultSimScript ){
 free(faultSimScript);
 faultSimScript = 0;
 }
 if( nScript==0 ){
 rc = sqlite3_test_control(SQLITE_TESTCTRL_FAULT_INSTALL, 0);
 }else{
 faultSimScript = malloc( nScript+100 );
 if( faultSimScript==0 ){
 Tcl_AppendResult(interp, "out of memory", (void*)0);
 return SQLITE_ERROR;
 }
 memcpy(faultSimScript, zScript, nScript);
 faultSimScript[nScript] = ' ';
 faultSimScriptSize = nScript+1;
 faultSimInterp = interp;
 rc = sqlite3_test_control(SQLITE_TESTCTRL_FAULT_INSTALL, faultSimCallback);
 }
 Tcl_SetObjResult(interp, Tcl_NewIntObj(rc));
 return SQLITE_OK;
}

/*
** sqlite3BitvecBuiltinTest SIZE PROGRAM
**
** Invoke the SQLITE_TESTCTRL_BITVEC_TEST operator on test_control.
** See comments on sqlite3BitvecBuiltinTest() for additional information.
*/
static int SQLITE_TCLAPI testBitvecBuiltinTest(
 void *NotUsed,
 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */
 int argc, /* Number of arguments */
 const char **argv /* Text of each argument */
){
 int sz, rc;
 int nProg = 0;
 int aProg[100];
 const char *z;
 if( argc!=3 ){
 Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
 " SIZE PROGRAM\"", (void*)0);
 }
 if( Tcl_GetInt(interp, argv[1], &sz) ) return TCL_ERROR;
 z = argv[2];
 while( nProg<99 && *z ){
 while( *z && !sqlite3Isdigit(*z) ){ z++; }
 if( *z==0 ) break;
 aProg[nProg++] = atoi(z);
 while( sqlite3Isdigit(*z) ){ z++; }
 }
 aProg[nProg] = 0;
 rc = sqlite3_test_control(SQLITE_TESTCTRL_BITVEC_TEST, sz, aProg);
 Tcl_SetObjResult(interp, Tcl_NewIntObj(rc));
 return TCL_OK;
} 

/*
** Register commands with the TCL interpreter.
*/
int Sqlitetest2_Init(Tcl_Interp *interp){
 extern int sqlite3_io_error_persist;
 extern int sqlite3_io_error_pending;
 extern int sqlite3_io_error_hit;
 extern int sqlite3_io_error_hardhit;
 extern int sqlite3_diskfull_pending;
 extern int sqlite3_diskfull;
 static struct {
 char *zName;
 Tcl_CmdProc *xProc;
 } aCmd[] = {
 { "pager_open", (Tcl_CmdProc*)pager_open },
 { "pager_close", (Tcl_CmdProc*)pager_close },
 { "pager_commit", (Tcl_CmdProc*)pager_commit },
 { "pager_rollback", (Tcl_CmdProc*)pager_rollback },
 { "pager_stmt_begin", (Tcl_CmdProc*)pager_stmt_begin },
 { "pager_stmt_commit", (Tcl_CmdProc*)pager_stmt_commit },
 { "pager_stmt_rollback", (Tcl_CmdProc*)pager_stmt_rollback },
 { "pager_stats", (Tcl_CmdProc*)pager_stats },
 { "pager_pagecount", (Tcl_CmdProc*)pager_pagecount },
 { "page_get", (Tcl_CmdProc*)page_get },
 { "page_lookup", (Tcl_CmdProc*)page_lookup },
 { "page_unref", (Tcl_CmdProc*)page_unref },
 { "page_read", (Tcl_CmdProc*)page_read },
 { "page_write", (Tcl_CmdProc*)page_write },
 { "page_number", (Tcl_CmdProc*)page_number },
 { "pager_truncate", (Tcl_CmdProc*)pager_truncate },
#ifndef SQLITE_OMIT_DISKIO
 { "fake_big_file", (Tcl_CmdProc*)fake_big_file },
#endif
 { "sqlite3BitvecBuiltinTest",(Tcl_CmdProc*)testBitvecBuiltinTest },
 { "sqlite3_test_control_pending_byte", (Tcl_CmdProc*)testPendingByte },
 { "sqlite3_test_control_fault_install", (Tcl_CmdProc*)faultInstallCmd },
 };
 int i;
 for(i=0; i<sizeof(aCmd)/sizeof(aCmd[0]); i++){
 Tcl_CreateCommand(interp, aCmd[i].zName, aCmd[i].xProc, 0, 0);
 }
 Tcl_LinkVar(interp, "sqlite_io_error_pending",
 (char*)&sqlite3_io_error_pending, TCL_LINK_INT);
 Tcl_LinkVar(interp, "sqlite_io_error_persist",
 (char*)&sqlite3_io_error_persist, TCL_LINK_INT);
 Tcl_LinkVar(interp, "sqlite_io_error_hit",
 (char*)&sqlite3_io_error_hit, TCL_LINK_INT);
 Tcl_LinkVar(interp, "sqlite_io_error_hardhit",
 (char*)&sqlite3_io_error_hardhit, TCL_LINK_INT);
 Tcl_LinkVar(interp, "sqlite_diskfull_pending",
 (char*)&sqlite3_diskfull_pending, TCL_LINK_INT);
 Tcl_LinkVar(interp, "sqlite_diskfull",
 (char*)&sqlite3_diskfull, TCL_LINK_INT);
#ifndef SQLITE_OMIT_WSD
 Tcl_LinkVar(interp, "sqlite_pending_byte",
 (char*)&sqlite3PendingByte, TCL_LINK_INT | TCL_LINK_READ_ONLY);
#endif
 return TCL_OK;
}