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 the virtual table interfaces. This code
13 ** is not included in the SQLite library. It is used for automated
14 ** testing of the SQLite library.
16 ** The emphasis of this file is a virtual table that provides
17 ** access to TCL variables.
19 #include "sqliteInt.h"
20 #if defined(INCLUDE_SQLITE_TCL_H)
21 # include "sqlite_tcl.h"
28 #ifndef SQLITE_OMIT_VIRTUALTABLE
31 ** Characters that make up the idxStr created by xBestIndex for xFilter.
33 #define TCLVAR_NAME_EQ 'e'
34 #define TCLVAR_NAME_MATCH 'm'
35 #define TCLVAR_VALUE_GLOB 'g'
36 #define TCLVAR_VALUE_REGEXP 'r'
37 #define TCLVAR_VALUE_LIKE 'l'
39 typedef struct tclvar_vtab tclvar_vtab
;
40 typedef struct tclvar_cursor tclvar_cursor
;
43 ** A tclvar virtual-table object
50 /* A tclvar cursor object */
51 struct tclvar_cursor
{
52 sqlite3_vtab_cursor base
;
54 Tcl_Obj
*pList1
; /* Result of [info vars ?pattern?] */
55 Tcl_Obj
*pList2
; /* Result of [array names [lindex $pList1 $i1]] */
56 int i1
; /* Current item in pList1 */
57 int i2
; /* Current item (if any) in pList2 */
60 /* Methods for the tclvar module */
61 static int tclvarConnect(
64 int argc
, const char *const*argv
,
65 sqlite3_vtab
**ppVtab
,
69 static const char zSchema
[] =
70 "CREATE TABLE whatever(name TEXT, arrayname TEXT, value TEXT)";
71 pVtab
= sqlite3MallocZero( sizeof(*pVtab
) );
72 if( pVtab
==0 ) return SQLITE_NOMEM
;
73 *ppVtab
= &pVtab
->base
;
74 pVtab
->interp
= (Tcl_Interp
*)pAux
;
75 sqlite3_declare_vtab(db
, zSchema
);
78 /* Note that for this virtual table, the xCreate and xConnect
79 ** methods are identical. */
81 static int tclvarDisconnect(sqlite3_vtab
*pVtab
){
85 /* The xDisconnect and xDestroy methods are also the same */
88 ** Open a new tclvar cursor.
90 static int tclvarOpen(sqlite3_vtab
*pVTab
, sqlite3_vtab_cursor
**ppCursor
){
92 pCur
= sqlite3MallocZero(sizeof(tclvar_cursor
));
93 *ppCursor
= &pCur
->base
;
98 ** Close a tclvar cursor.
100 static int tclvarClose(sqlite3_vtab_cursor
*cur
){
101 tclvar_cursor
*pCur
= (tclvar_cursor
*)cur
;
103 Tcl_DecrRefCount(pCur
->pList1
);
106 Tcl_DecrRefCount(pCur
->pList2
);
113 ** Returns 1 if data is ready, or 0 if not.
115 static int next2(Tcl_Interp
*interp
, tclvar_cursor
*pCur
, Tcl_Obj
*pObj
){
120 p
= Tcl_NewStringObj("array names", -1);
122 Tcl_ListObjAppendElement(0, p
, pObj
);
123 Tcl_EvalObjEx(interp
, p
, TCL_EVAL_GLOBAL
);
125 pCur
->pList2
= Tcl_GetObjResult(interp
);
126 Tcl_IncrRefCount(pCur
->pList2
);
127 assert( pCur
->i2
==0 );
131 Tcl_ListObjLength(0, pCur
->pList2
, &n
);
133 Tcl_DecrRefCount(pCur
->pList2
);
144 static int tclvarNext(sqlite3_vtab_cursor
*cur
){
149 tclvar_cursor
*pCur
= (tclvar_cursor
*)cur
;
150 Tcl_Interp
*interp
= ((tclvar_vtab
*)(cur
->pVtab
))->interp
;
152 Tcl_ListObjLength(0, pCur
->pList1
, &n
);
153 while( !ok
&& pCur
->i1
<n
){
154 Tcl_ListObjIndex(0, pCur
->pList1
, pCur
->i1
, &pObj
);
155 ok
= next2(interp
, pCur
, pObj
);
164 static int tclvarFilter(
165 sqlite3_vtab_cursor
*pVtabCursor
,
166 int idxNum
, const char *idxStr
,
167 int argc
, sqlite3_value
**argv
169 tclvar_cursor
*pCur
= (tclvar_cursor
*)pVtabCursor
;
170 Tcl_Interp
*interp
= ((tclvar_vtab
*)(pVtabCursor
->pVtab
))->interp
;
171 Tcl_Obj
*p
= Tcl_NewStringObj("tclvar_filter_cmd", -1);
173 const char *zEq
= "";
174 const char *zMatch
= "";
175 const char *zGlob
= "";
176 const char *zRegexp
= "";
177 const char *zLike
= "";
180 for(i
=0; idxStr
[i
]; i
++){
183 zEq
= (const char*)sqlite3_value_text(argv
[i
]);
185 case TCLVAR_NAME_MATCH
:
186 zMatch
= (const char*)sqlite3_value_text(argv
[i
]);
188 case TCLVAR_VALUE_GLOB
:
189 zGlob
= (const char*)sqlite3_value_text(argv
[i
]);
191 case TCLVAR_VALUE_REGEXP
:
192 zRegexp
= (const char*)sqlite3_value_text(argv
[i
]);
194 case TCLVAR_VALUE_LIKE
:
195 zLike
= (const char*)sqlite3_value_text(argv
[i
]);
203 Tcl_ListObjAppendElement(0, p
, Tcl_NewStringObj(zEq
, -1));
204 Tcl_ListObjAppendElement(0, p
, Tcl_NewStringObj(zMatch
, -1));
205 Tcl_ListObjAppendElement(0, p
, Tcl_NewStringObj(zGlob
, -1));
206 Tcl_ListObjAppendElement(0, p
, Tcl_NewStringObj(zRegexp
, -1));
207 Tcl_ListObjAppendElement(0, p
, Tcl_NewStringObj(zLike
, -1));
209 Tcl_EvalObjEx(interp
, p
, TCL_EVAL_GLOBAL
);
211 Tcl_DecrRefCount(pCur
->pList1
);
214 Tcl_DecrRefCount(pCur
->pList2
);
219 pCur
->pList1
= Tcl_GetObjResult(interp
);
220 Tcl_IncrRefCount(pCur
->pList1
);
223 return tclvarNext(pVtabCursor
);
226 static int tclvarColumn(sqlite3_vtab_cursor
*cur
, sqlite3_context
*ctx
, int i
){
231 tclvar_cursor
*pCur
= (tclvar_cursor
*)cur
;
232 Tcl_Interp
*interp
= ((tclvar_vtab
*)cur
->pVtab
)->interp
;
234 Tcl_ListObjIndex(interp
, pCur
->pList1
, pCur
->i1
, &p1
);
235 Tcl_ListObjIndex(interp
, pCur
->pList2
, pCur
->i2
, &p2
);
236 z1
= Tcl_GetString(p1
);
238 z2
= Tcl_GetString(p2
);
242 sqlite3_result_text(ctx
, z1
, -1, SQLITE_TRANSIENT
);
246 sqlite3_result_text(ctx
, z2
, -1, SQLITE_TRANSIENT
);
250 Tcl_Obj
*pVal
= Tcl_GetVar2Ex(interp
, z1
, *z2
?z2
:0, TCL_GLOBAL_ONLY
);
251 sqlite3_result_text(ctx
, Tcl_GetString(pVal
), -1, SQLITE_TRANSIENT
);
258 static int tclvarRowid(sqlite3_vtab_cursor
*cur
, sqlite_int64
*pRowid
){
263 static int tclvarEof(sqlite3_vtab_cursor
*cur
){
264 tclvar_cursor
*pCur
= (tclvar_cursor
*)cur
;
265 return (pCur
->pList2
?0:1);
269 ** If nul-terminated string zStr does not already contain the character
270 ** passed as the second argument, append it and return 0. Or, if there is
271 ** already an instance of x in zStr, do nothing return 1;
273 ** There is guaranteed to be enough room in the buffer pointed to by zStr
274 ** for the new character and nul-terminator.
276 static int tclvarAddToIdxstr(char *zStr
, char x
){
278 for(i
=0; zStr
[i
]; i
++){
279 if( zStr
[i
]==x
) return 1;
287 ** Return true if variable $::tclvar_set_omit exists and is set to true.
290 static int tclvarSetOmit(Tcl_Interp
*interp
){
294 rc
= Tcl_Eval(interp
,
295 "expr {[info exists ::tclvar_set_omit] && $::tclvar_set_omit}"
298 pRes
= Tcl_GetObjResult(interp
);
299 rc
= Tcl_GetBooleanFromObj(0, pRes
, &res
);
301 return (rc
==TCL_OK
&& res
);
305 ** The xBestIndex() method. This virtual table supports the following
308 ** name = ? (omit flag clear)
309 ** name MATCH ? (omit flag set)
310 ** value GLOB ? (omit flag set iff $::tclvar_set_omit)
311 ** value REGEXP ? (omit flag set iff $::tclvar_set_omit)
312 ** value LIKE ? (omit flag set iff $::tclvar_set_omit)
314 ** For each constraint present, the corresponding TCLVAR_XXX character is
315 ** appended to the idxStr value.
317 static int tclvarBestIndex(sqlite3_vtab
*tab
, sqlite3_index_info
*pIdxInfo
){
318 tclvar_vtab
*pTab
= (tclvar_vtab
*)tab
;
320 char *zStr
= sqlite3_malloc(32);
323 if( zStr
==0 ) return SQLITE_NOMEM
;
326 for(ii
=0; ii
<pIdxInfo
->nConstraint
; ii
++){
327 struct sqlite3_index_constraint
const *pCons
= &pIdxInfo
->aConstraint
[ii
];
328 struct sqlite3_index_constraint_usage
*pUsage
;
330 pUsage
= &pIdxInfo
->aConstraintUsage
[ii
];
333 if( pCons
->op
==SQLITE_INDEX_CONSTRAINT_EQ
&& pCons
->iColumn
==0 ){
334 if( 0==tclvarAddToIdxstr(zStr
, TCLVAR_NAME_EQ
) ){
335 pUsage
->argvIndex
= ++iStr
;
341 if( pCons
->op
==SQLITE_INDEX_CONSTRAINT_MATCH
&& pCons
->iColumn
==0 ){
342 if( 0==tclvarAddToIdxstr(zStr
, TCLVAR_NAME_MATCH
) ){
343 pUsage
->argvIndex
= ++iStr
;
349 if( pCons
->op
==SQLITE_INDEX_CONSTRAINT_GLOB
&& pCons
->iColumn
==2 ){
350 if( 0==tclvarAddToIdxstr(zStr
, TCLVAR_VALUE_GLOB
) ){
351 pUsage
->argvIndex
= ++iStr
;
352 pUsage
->omit
= tclvarSetOmit(pTab
->interp
);
357 if( pCons
->op
==SQLITE_INDEX_CONSTRAINT_REGEXP
&& pCons
->iColumn
==2 ){
358 if( 0==tclvarAddToIdxstr(zStr
, TCLVAR_VALUE_REGEXP
) ){
359 pUsage
->argvIndex
= ++iStr
;
360 pUsage
->omit
= tclvarSetOmit(pTab
->interp
);
365 if( pCons
->op
==SQLITE_INDEX_CONSTRAINT_LIKE
&& pCons
->iColumn
==2 ){
366 if( 0==tclvarAddToIdxstr(zStr
, TCLVAR_VALUE_LIKE
) ){
367 pUsage
->argvIndex
= ++iStr
;
368 pUsage
->omit
= tclvarSetOmit(pTab
->interp
);
373 pIdxInfo
->idxStr
= zStr
;
374 pIdxInfo
->needToFreeIdxStr
= 1;
380 ** A virtual table module that provides read-only access to a
381 ** Tcl global variable namespace.
383 static sqlite3_module tclvarModule
= {
390 tclvarOpen
, /* xOpen - open a cursor */
391 tclvarClose
, /* xClose - close a cursor */
392 tclvarFilter
, /* xFilter - configure scan constraints */
393 tclvarNext
, /* xNext - advance a cursor */
394 tclvarEof
, /* xEof - check for end of scan */
395 tclvarColumn
, /* xColumn - read data */
396 tclvarRowid
, /* xRowid - read data */
407 ** Decode a pointer to an sqlite3 object.
409 extern int getDbPointer(Tcl_Interp
*interp
, const char *zA
, sqlite3
**ppDb
);
412 ** Register the echo virtual table module.
414 static int SQLITE_TCLAPI
register_tclvar_module(
415 ClientData clientData
, /* Pointer to sqlite3_enable_XXX function */
416 Tcl_Interp
*interp
, /* The TCL interpreter that invoked this command */
417 int objc
, /* Number of arguments */
418 Tcl_Obj
*CONST objv
[] /* Command arguments */
423 Tcl_WrongNumArgs(interp
, 1, objv
, "DB");
426 if( getDbPointer(interp
, Tcl_GetString(objv
[1]), &db
) ) return TCL_ERROR
;
427 #ifndef SQLITE_OMIT_VIRTUALTABLE
428 sqlite3_create_module(db
, "tclvar", &tclvarModule
, (void*)interp
);
429 rc
= Tcl_Eval(interp
,
430 "proc like {pattern str} {\n"
431 " set p [string map {% * _ ?} $pattern]\n"
432 " string match $p $str\n"
434 "proc tclvar_filter_cmd {eq match glob regexp like} {\n"
437 " if {$pattern=={}} { set pattern $match }\n"
438 " if {$pattern=={}} { set pattern * }\n"
439 " foreach v [uplevel #0 info vars $pattern] {\n"
440 " if {($glob=={} || [string match $glob [uplevel #0 set $v]])\n"
441 " && ($like=={} || [like $like [uplevel #0 set $v]])\n"
442 " && ($regexp=={} || [regexp $regexp [uplevel #0 set $v]])\n"
458 ** Register commands with the TCL interpreter.
460 int Sqlitetesttclvar_Init(Tcl_Interp
*interp
){
461 #ifndef SQLITE_OMIT_VIRTUALTABLE
464 Tcl_ObjCmdProc
*xProc
;
467 { "register_tclvar_module", register_tclvar_module
, 0 },
470 for(i
=0; i
<sizeof(aObjCmd
)/sizeof(aObjCmd
[0]); i
++){
471 Tcl_CreateObjCommand(interp
, aObjCmd
[i
].zName
,
472 aObjCmd
[i
].xProc
, aObjCmd
[i
].clientData
, 0);