xref: /sqlite-3.40.0/src/test2.c (revision 78d41832)
1 /*
2 ** 2001 September 15
3 **
4 ** The author disclaims copyright to this source code.  In place of
5 ** a legal notice, here is a blessing:
6 **
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.
10 **
11 *************************************************************************
12 ** Code for testing the pager.c module in SQLite.  This code
13 ** is not included in the SQLite library.  It is used for automated
14 ** testing of the SQLite library.
15 **
16 ** $Id: test2.c,v 1.63 2008/12/17 17:30:26 danielk1977 Exp $
17 */
18 #include "sqliteInt.h"
19 #include "tcl.h"
20 #include <stdlib.h>
21 #include <string.h>
22 #include <ctype.h>
23 
24 /*
25 ** Interpret an SQLite error number
26 */
27 static char *errorName(int rc){
28   char *zName;
29   switch( rc ){
30     case SQLITE_OK:         zName = "SQLITE_OK";          break;
31     case SQLITE_ERROR:      zName = "SQLITE_ERROR";       break;
32     case SQLITE_PERM:       zName = "SQLITE_PERM";        break;
33     case SQLITE_ABORT:      zName = "SQLITE_ABORT";       break;
34     case SQLITE_BUSY:       zName = "SQLITE_BUSY";        break;
35     case SQLITE_NOMEM:      zName = "SQLITE_NOMEM";       break;
36     case SQLITE_READONLY:   zName = "SQLITE_READONLY";    break;
37     case SQLITE_INTERRUPT:  zName = "SQLITE_INTERRUPT";   break;
38     case SQLITE_IOERR:      zName = "SQLITE_IOERR";       break;
39     case SQLITE_CORRUPT:    zName = "SQLITE_CORRUPT";     break;
40     case SQLITE_FULL:       zName = "SQLITE_FULL";        break;
41     case SQLITE_CANTOPEN:   zName = "SQLITE_CANTOPEN";    break;
42     case SQLITE_PROTOCOL:   zName = "SQLITE_PROTOCOL";    break;
43     case SQLITE_EMPTY:      zName = "SQLITE_EMPTY";       break;
44     case SQLITE_SCHEMA:     zName = "SQLITE_SCHEMA";      break;
45     case SQLITE_CONSTRAINT: zName = "SQLITE_CONSTRAINT";  break;
46     case SQLITE_MISMATCH:   zName = "SQLITE_MISMATCH";    break;
47     case SQLITE_MISUSE:     zName = "SQLITE_MISUSE";      break;
48     case SQLITE_NOLFS:      zName = "SQLITE_NOLFS";       break;
49     default:                zName = "SQLITE_Unknown";     break;
50   }
51   return zName;
52 }
53 
54 /*
55 ** Page size and reserved size used for testing.
56 */
57 static int test_pagesize = 1024;
58 
59 /*
60 ** Usage:   pager_open FILENAME N-PAGE
61 **
62 ** Open a new pager
63 */
64 static int pager_open(
65   void *NotUsed,
66   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
67   int argc,              /* Number of arguments */
68   const char **argv      /* Text of each argument */
69 ){
70   u16 pageSize;
71   Pager *pPager;
72   int nPage;
73   int rc;
74   char zBuf[100];
75   if( argc!=3 ){
76     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
77        " FILENAME N-PAGE\"", 0);
78     return TCL_ERROR;
79   }
80   if( Tcl_GetInt(interp, argv[2], &nPage) ) return TCL_ERROR;
81   rc = sqlite3PagerOpen(sqlite3_vfs_find(0), &pPager, argv[1], 0, 0,
82       SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_MAIN_DB);
83   if( rc!=SQLITE_OK ){
84     Tcl_AppendResult(interp, errorName(rc), 0);
85     return TCL_ERROR;
86   }
87   sqlite3PagerSetCachesize(pPager, nPage);
88   pageSize = test_pagesize;
89   sqlite3PagerSetPagesize(pPager, &pageSize);
90   sqlite3_snprintf(sizeof(zBuf),zBuf,"%p",pPager);
91   Tcl_AppendResult(interp, zBuf, 0);
92   return TCL_OK;
93 }
94 
95 /*
96 ** Usage:   pager_close ID
97 **
98 ** Close the given pager.
99 */
100 static int pager_close(
101   void *NotUsed,
102   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
103   int argc,              /* Number of arguments */
104   const char **argv      /* Text of each argument */
105 ){
106   Pager *pPager;
107   int rc;
108   if( argc!=2 ){
109     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
110        " ID\"", 0);
111     return TCL_ERROR;
112   }
113   pPager = sqlite3TestTextToPtr(argv[1]);
114   rc = sqlite3PagerClose(pPager);
115   if( rc!=SQLITE_OK ){
116     Tcl_AppendResult(interp, errorName(rc), 0);
117     return TCL_ERROR;
118   }
119   return TCL_OK;
120 }
121 
122 /*
123 ** Usage:   pager_rollback ID
124 **
125 ** Rollback changes
126 */
127 static int pager_rollback(
128   void *NotUsed,
129   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
130   int argc,              /* Number of arguments */
131   const char **argv      /* Text of each argument */
132 ){
133   Pager *pPager;
134   int rc;
135   if( argc!=2 ){
136     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
137        " ID\"", 0);
138     return TCL_ERROR;
139   }
140   pPager = sqlite3TestTextToPtr(argv[1]);
141   rc = sqlite3PagerRollback(pPager);
142   if( rc!=SQLITE_OK ){
143     Tcl_AppendResult(interp, errorName(rc), 0);
144     return TCL_ERROR;
145   }
146   return TCL_OK;
147 }
148 
149 /*
150 ** Usage:   pager_commit ID
151 **
152 ** Commit all changes
153 */
154 static int pager_commit(
155   void *NotUsed,
156   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
157   int argc,              /* Number of arguments */
158   const char **argv      /* Text of each argument */
159 ){
160   Pager *pPager;
161   int rc;
162   if( argc!=2 ){
163     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
164        " ID\"", 0);
165     return TCL_ERROR;
166   }
167   pPager = sqlite3TestTextToPtr(argv[1]);
168   rc = sqlite3PagerCommitPhaseOne(pPager, 0, 0, 0);
169   if( rc!=SQLITE_OK ){
170     Tcl_AppendResult(interp, errorName(rc), 0);
171     return TCL_ERROR;
172   }
173   rc = sqlite3PagerCommitPhaseTwo(pPager);
174   if( rc!=SQLITE_OK ){
175     Tcl_AppendResult(interp, errorName(rc), 0);
176     return TCL_ERROR;
177   }
178   return TCL_OK;
179 }
180 
181 /*
182 ** Usage:   pager_stmt_begin ID
183 **
184 ** Start a new checkpoint.
185 */
186 static int pager_stmt_begin(
187   void *NotUsed,
188   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
189   int argc,              /* Number of arguments */
190   const char **argv      /* Text of each argument */
191 ){
192   Pager *pPager;
193   int rc;
194   if( argc!=2 ){
195     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
196        " ID\"", 0);
197     return TCL_ERROR;
198   }
199   pPager = sqlite3TestTextToPtr(argv[1]);
200   rc = sqlite3PagerOpenSavepoint(pPager, 1);
201   if( rc!=SQLITE_OK ){
202     Tcl_AppendResult(interp, errorName(rc), 0);
203     return TCL_ERROR;
204   }
205   return TCL_OK;
206 }
207 
208 /*
209 ** Usage:   pager_stmt_rollback ID
210 **
211 ** Rollback changes to a checkpoint
212 */
213 static int pager_stmt_rollback(
214   void *NotUsed,
215   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
216   int argc,              /* Number of arguments */
217   const char **argv      /* Text of each argument */
218 ){
219   Pager *pPager;
220   int rc;
221   if( argc!=2 ){
222     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
223        " ID\"", 0);
224     return TCL_ERROR;
225   }
226   pPager = sqlite3TestTextToPtr(argv[1]);
227   rc = sqlite3PagerSavepoint(pPager, SAVEPOINT_ROLLBACK, 0);
228   sqlite3PagerSavepoint(pPager, SAVEPOINT_RELEASE, 0);
229   if( rc!=SQLITE_OK ){
230     Tcl_AppendResult(interp, errorName(rc), 0);
231     return TCL_ERROR;
232   }
233   return TCL_OK;
234 }
235 
236 /*
237 ** Usage:   pager_stmt_commit ID
238 **
239 ** Commit changes to a checkpoint
240 */
241 static int pager_stmt_commit(
242   void *NotUsed,
243   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
244   int argc,              /* Number of arguments */
245   const char **argv      /* Text of each argument */
246 ){
247   Pager *pPager;
248   int rc;
249   if( argc!=2 ){
250     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
251        " ID\"", 0);
252     return TCL_ERROR;
253   }
254   pPager = sqlite3TestTextToPtr(argv[1]);
255   rc = sqlite3PagerSavepoint(pPager, SAVEPOINT_RELEASE, 0);
256   if( rc!=SQLITE_OK ){
257     Tcl_AppendResult(interp, errorName(rc), 0);
258     return TCL_ERROR;
259   }
260   return TCL_OK;
261 }
262 
263 /*
264 ** Usage:   pager_stats ID
265 **
266 ** Return pager statistics.
267 */
268 static int pager_stats(
269   void *NotUsed,
270   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
271   int argc,              /* Number of arguments */
272   const char **argv      /* Text of each argument */
273 ){
274   Pager *pPager;
275   int i, *a;
276   if( argc!=2 ){
277     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
278        " ID\"", 0);
279     return TCL_ERROR;
280   }
281   pPager = sqlite3TestTextToPtr(argv[1]);
282   a = sqlite3PagerStats(pPager);
283   for(i=0; i<9; i++){
284     static char *zName[] = {
285       "ref", "page", "max", "size", "state", "err",
286       "hit", "miss", "ovfl",
287     };
288     char zBuf[100];
289     Tcl_AppendElement(interp, zName[i]);
290     sqlite3_snprintf(sizeof(zBuf),zBuf,"%d",a[i]);
291     Tcl_AppendElement(interp, zBuf);
292   }
293   return TCL_OK;
294 }
295 
296 /*
297 ** Usage:   pager_pagecount ID
298 **
299 ** Return the size of the database file.
300 */
301 static int pager_pagecount(
302   void *NotUsed,
303   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
304   int argc,              /* Number of arguments */
305   const char **argv      /* Text of each argument */
306 ){
307   Pager *pPager;
308   char zBuf[100];
309   int nPage;
310   if( argc!=2 ){
311     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
312        " ID\"", 0);
313     return TCL_ERROR;
314   }
315   pPager = sqlite3TestTextToPtr(argv[1]);
316   sqlite3PagerPagecount(pPager, &nPage);
317   sqlite3_snprintf(sizeof(zBuf), zBuf, "%d", nPage);
318   Tcl_AppendResult(interp, zBuf, 0);
319   return TCL_OK;
320 }
321 
322 /*
323 ** Usage:   page_get ID PGNO
324 **
325 ** Return a pointer to a page from the database.
326 */
327 static int page_get(
328   void *NotUsed,
329   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
330   int argc,              /* Number of arguments */
331   const char **argv      /* Text of each argument */
332 ){
333   Pager *pPager;
334   char zBuf[100];
335   DbPage *pPage;
336   int pgno;
337   int rc;
338   if( argc!=3 ){
339     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
340        " ID PGNO\"", 0);
341     return TCL_ERROR;
342   }
343   pPager = sqlite3TestTextToPtr(argv[1]);
344   if( Tcl_GetInt(interp, argv[2], &pgno) ) return TCL_ERROR;
345   rc = sqlite3PagerGet(pPager, pgno, &pPage);
346   if( rc!=SQLITE_OK ){
347     Tcl_AppendResult(interp, errorName(rc), 0);
348     return TCL_ERROR;
349   }
350   sqlite3_snprintf(sizeof(zBuf),zBuf,"%p",pPage);
351   Tcl_AppendResult(interp, zBuf, 0);
352   return TCL_OK;
353 }
354 
355 /*
356 ** Usage:   page_lookup ID PGNO
357 **
358 ** Return a pointer to a page if the page is already in cache.
359 ** If not in cache, return an empty string.
360 */
361 static int page_lookup(
362   void *NotUsed,
363   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
364   int argc,              /* Number of arguments */
365   const char **argv      /* Text of each argument */
366 ){
367   Pager *pPager;
368   char zBuf[100];
369   DbPage *pPage;
370   int pgno;
371   if( argc!=3 ){
372     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
373        " ID PGNO\"", 0);
374     return TCL_ERROR;
375   }
376   pPager = sqlite3TestTextToPtr(argv[1]);
377   if( Tcl_GetInt(interp, argv[2], &pgno) ) return TCL_ERROR;
378   pPage = sqlite3PagerLookup(pPager, pgno);
379   if( pPage ){
380     sqlite3_snprintf(sizeof(zBuf),zBuf,"%p",pPage);
381     Tcl_AppendResult(interp, zBuf, 0);
382   }
383   return TCL_OK;
384 }
385 
386 /*
387 ** Usage:   pager_truncate ID PGNO
388 */
389 static int pager_truncate(
390   void *NotUsed,
391   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
392   int argc,              /* Number of arguments */
393   const char **argv      /* Text of each argument */
394 ){
395   Pager *pPager;
396   int rc;
397   int pgno;
398   if( argc!=3 ){
399     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
400        " ID PGNO\"", 0);
401     return TCL_ERROR;
402   }
403   pPager = sqlite3TestTextToPtr(argv[1]);
404   if( Tcl_GetInt(interp, argv[2], &pgno) ) return TCL_ERROR;
405   rc = sqlite3PagerTruncate(pPager, pgno);
406   if( rc!=SQLITE_OK ){
407     Tcl_AppendResult(interp, errorName(rc), 0);
408     return TCL_ERROR;
409   }
410   return TCL_OK;
411 }
412 
413 
414 /*
415 ** Usage:   page_unref PAGE
416 **
417 ** Drop a pointer to a page.
418 */
419 static int page_unref(
420   void *NotUsed,
421   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
422   int argc,              /* Number of arguments */
423   const char **argv      /* Text of each argument */
424 ){
425   DbPage *pPage;
426   int rc;
427   if( argc!=2 ){
428     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
429        " PAGE\"", 0);
430     return TCL_ERROR;
431   }
432   pPage = (DbPage *)sqlite3TestTextToPtr(argv[1]);
433   rc = sqlite3PagerUnref(pPage);
434   if( rc!=SQLITE_OK ){
435     Tcl_AppendResult(interp, errorName(rc), 0);
436     return TCL_ERROR;
437   }
438   return TCL_OK;
439 }
440 
441 /*
442 ** Usage:   page_read PAGE
443 **
444 ** Return the content of a page
445 */
446 static int page_read(
447   void *NotUsed,
448   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
449   int argc,              /* Number of arguments */
450   const char **argv      /* Text of each argument */
451 ){
452   char zBuf[100];
453   DbPage *pPage;
454   if( argc!=2 ){
455     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
456        " PAGE\"", 0);
457     return TCL_ERROR;
458   }
459   pPage = sqlite3TestTextToPtr(argv[1]);
460   memcpy(zBuf, sqlite3PagerGetData(pPage), sizeof(zBuf));
461   Tcl_AppendResult(interp, zBuf, 0);
462   return TCL_OK;
463 }
464 
465 /*
466 ** Usage:   page_number PAGE
467 **
468 ** Return the page number for a page.
469 */
470 static int page_number(
471   void *NotUsed,
472   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
473   int argc,              /* Number of arguments */
474   const char **argv      /* Text of each argument */
475 ){
476   char zBuf[100];
477   DbPage *pPage;
478   if( argc!=2 ){
479     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
480        " PAGE\"", 0);
481     return TCL_ERROR;
482   }
483   pPage = (DbPage *)sqlite3TestTextToPtr(argv[1]);
484   sqlite3_snprintf(sizeof(zBuf), zBuf, "%d", sqlite3PagerPagenumber(pPage));
485   Tcl_AppendResult(interp, zBuf, 0);
486   return TCL_OK;
487 }
488 
489 /*
490 ** Usage:   page_write PAGE DATA
491 **
492 ** Write something into a page.
493 */
494 static int page_write(
495   void *NotUsed,
496   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
497   int argc,              /* Number of arguments */
498   const char **argv      /* Text of each argument */
499 ){
500   DbPage *pPage;
501   char *pData;
502   int rc;
503   if( argc!=3 ){
504     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
505        " PAGE DATA\"", 0);
506     return TCL_ERROR;
507   }
508   pPage = (DbPage *)sqlite3TestTextToPtr(argv[1]);
509   rc = sqlite3PagerWrite(pPage);
510   if( rc!=SQLITE_OK ){
511     Tcl_AppendResult(interp, errorName(rc), 0);
512     return TCL_ERROR;
513   }
514   pData = sqlite3PagerGetData(pPage);
515   strncpy(pData, argv[2], test_pagesize-1);
516   pData[test_pagesize-1] = 0;
517   return TCL_OK;
518 }
519 
520 #ifndef SQLITE_OMIT_DISKIO
521 /*
522 ** Usage:   fake_big_file  N  FILENAME
523 **
524 ** Write a few bytes at the N megabyte point of FILENAME.  This will
525 ** create a large file.  If the file was a valid SQLite database, then
526 ** the next time the database is opened, SQLite will begin allocating
527 ** new pages after N.  If N is 2096 or bigger, this will test the
528 ** ability of SQLite to write to large files.
529 */
530 static int fake_big_file(
531   void *NotUsed,
532   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
533   int argc,              /* Number of arguments */
534   const char **argv      /* Text of each argument */
535 ){
536   sqlite3_vfs *pVfs;
537   sqlite3_file *fd = 0;
538   int rc;
539   int n;
540   i64 offset;
541   if( argc!=3 ){
542     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
543        " N-MEGABYTES FILE\"", 0);
544     return TCL_ERROR;
545   }
546   if( Tcl_GetInt(interp, argv[1], &n) ) return TCL_ERROR;
547 
548   pVfs = sqlite3_vfs_find(0);
549   rc = sqlite3OsOpenMalloc(pVfs, argv[2], &fd,
550       (SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE|SQLITE_OPEN_MAIN_DB), 0
551   );
552   if( rc ){
553     Tcl_AppendResult(interp, "open failed: ", errorName(rc), 0);
554     return TCL_ERROR;
555   }
556   offset = n;
557   offset *= 1024*1024;
558   rc = sqlite3OsWrite(fd, "Hello, World!", 14, offset);
559   sqlite3OsCloseFree(fd);
560   if( rc ){
561     Tcl_AppendResult(interp, "write failed: ", errorName(rc), 0);
562     return TCL_ERROR;
563   }
564   return TCL_OK;
565 }
566 #endif
567 
568 
569 /*
570 ** sqlite3BitvecBuiltinTest SIZE PROGRAM
571 **
572 ** Invoke the SQLITE_TESTCTRL_BITVEC_TEST operator on test_control.
573 ** See comments on sqlite3BitvecBuiltinTest() for additional information.
574 */
575 static int testBitvecBuiltinTest(
576   void *NotUsed,
577   Tcl_Interp *interp,    /* The TCL interpreter that invoked this command */
578   int argc,              /* Number of arguments */
579   const char **argv      /* Text of each argument */
580 ){
581   int sz, rc;
582   int nProg = 0;
583   int aProg[100];
584   const char *z;
585   if( argc!=3 ){
586     Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0],
587                      " SIZE PROGRAM\"", (void*)0);
588   }
589   if( Tcl_GetInt(interp, argv[1], &sz) ) return TCL_ERROR;
590   z = argv[2];
591   while( nProg<99 && *z ){
592     while( *z && !isdigit(*z) ){ z++; }
593     if( *z==0 ) break;
594     aProg[nProg++] = atoi(z);
595     while( isdigit(*z) ){ z++; }
596   }
597   aProg[nProg] = 0;
598   rc = sqlite3_test_control(SQLITE_TESTCTRL_BITVEC_TEST, sz, aProg);
599   Tcl_SetObjResult(interp, Tcl_NewIntObj(rc));
600   return TCL_OK;
601 }
602 
603 /*
604 ** Register commands with the TCL interpreter.
605 */
606 int Sqlitetest2_Init(Tcl_Interp *interp){
607   extern int sqlite3_io_error_persist;
608   extern int sqlite3_io_error_pending;
609   extern int sqlite3_io_error_hit;
610   extern int sqlite3_io_error_hardhit;
611   extern int sqlite3_diskfull_pending;
612   extern int sqlite3_diskfull;
613   extern int sqlite3_pager_n_sort_bucket;
614   static struct {
615     char *zName;
616     Tcl_CmdProc *xProc;
617   } aCmd[] = {
618     { "pager_open",              (Tcl_CmdProc*)pager_open          },
619     { "pager_close",             (Tcl_CmdProc*)pager_close         },
620     { "pager_commit",            (Tcl_CmdProc*)pager_commit        },
621     { "pager_rollback",          (Tcl_CmdProc*)pager_rollback      },
622     { "pager_stmt_begin",        (Tcl_CmdProc*)pager_stmt_begin    },
623     { "pager_stmt_commit",       (Tcl_CmdProc*)pager_stmt_commit   },
624     { "pager_stmt_rollback",     (Tcl_CmdProc*)pager_stmt_rollback },
625     { "pager_stats",             (Tcl_CmdProc*)pager_stats         },
626     { "pager_pagecount",         (Tcl_CmdProc*)pager_pagecount     },
627     { "page_get",                (Tcl_CmdProc*)page_get            },
628     { "page_lookup",             (Tcl_CmdProc*)page_lookup         },
629     { "page_unref",              (Tcl_CmdProc*)page_unref          },
630     { "page_read",               (Tcl_CmdProc*)page_read           },
631     { "page_write",              (Tcl_CmdProc*)page_write          },
632     { "page_number",             (Tcl_CmdProc*)page_number         },
633     { "pager_truncate",          (Tcl_CmdProc*)pager_truncate      },
634 #ifndef SQLITE_OMIT_DISKIO
635     { "fake_big_file",           (Tcl_CmdProc*)fake_big_file       },
636 #endif
637     { "sqlite3BitvecBuiltinTest",(Tcl_CmdProc*)testBitvecBuiltinTest},
638   };
639   int i;
640   for(i=0; i<sizeof(aCmd)/sizeof(aCmd[0]); i++){
641     Tcl_CreateCommand(interp, aCmd[i].zName, aCmd[i].xProc, 0, 0);
642   }
643   Tcl_LinkVar(interp, "sqlite_io_error_pending",
644      (char*)&sqlite3_io_error_pending, TCL_LINK_INT);
645   Tcl_LinkVar(interp, "sqlite_io_error_persist",
646      (char*)&sqlite3_io_error_persist, TCL_LINK_INT);
647   Tcl_LinkVar(interp, "sqlite_io_error_hit",
648      (char*)&sqlite3_io_error_hit, TCL_LINK_INT);
649   Tcl_LinkVar(interp, "sqlite_io_error_hardhit",
650      (char*)&sqlite3_io_error_hardhit, TCL_LINK_INT);
651   Tcl_LinkVar(interp, "sqlite_diskfull_pending",
652      (char*)&sqlite3_diskfull_pending, TCL_LINK_INT);
653   Tcl_LinkVar(interp, "sqlite_diskfull",
654      (char*)&sqlite3_diskfull, TCL_LINK_INT);
655   Tcl_LinkVar(interp, "sqlite_pending_byte",
656      (char*)&sqlite3_pending_byte, TCL_LINK_INT);
657   Tcl_LinkVar(interp, "sqlite_pager_n_sort_bucket",
658      (char*)&sqlite3_pager_n_sort_bucket, TCL_LINK_INT);
659   return TCL_OK;
660 }
661