| 1 |
/* |
| 2 |
** 2010 August 28 |
| 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 all sorts of SQLite interfaces. This code |
| 13 |
** is not included in the SQLite library. |
| 14 |
*/ |
| 15 |
|
| 16 |
#include "sqlite3.h" |
| 17 |
#include "sqlite3intck.h" |
| 18 |
#include "tclsqlite.h" |
| 19 |
#include <string.h> |
| 20 |
#include <assert.h> |
| 21 |
|
| 22 |
/* In test1.c */ |
| 23 |
int getDbPointer(Tcl_Interp *interp, const char *zA, sqlite3 **ppDb); |
| 24 |
const char *sqlite3ErrName(int); |
| 25 |
|
| 26 |
typedef struct TestIntck TestIntck; |
| 27 |
struct TestIntck { |
| 28 |
sqlite3_intck *intck; |
| 29 |
}; |
| 30 |
|
| 31 |
static int testIntckCmd( |
| 32 |
void * clientData, |
| 33 |
Tcl_Interp *interp, |
| 34 |
int objc, |
| 35 |
Tcl_Obj *CONST objv[] |
| 36 |
){ |
| 37 |
struct Subcmd { |
| 38 |
const char *zName; |
| 39 |
int nArg; |
| 40 |
const char *zExpect; |
| 41 |
} aCmd[] = { |
| 42 |
{"close", 0, ""}, /* 0 */ |
| 43 |
{"step", 0, ""}, /* 1 */ |
| 44 |
{"message", 0, ""}, /* 2 */ |
| 45 |
{"error", 0, ""}, /* 3 */ |
| 46 |
{"unlock", 0, ""}, /* 4 */ |
| 47 |
{"test_sql", 1, ""}, /* 5 */ |
| 48 |
{0 , 0} |
| 49 |
}; |
| 50 |
int rc = TCL_OK; |
| 51 |
int iIdx = -1; |
| 52 |
TestIntck *p = (TestIntck*)clientData; |
| 53 |
|
| 54 |
if( objc<2 ){ |
| 55 |
Tcl_WrongNumArgs(interp, 1, objv, "SUB-COMMAND ..."); |
| 56 |
return TCL_ERROR; |
| 57 |
} |
| 58 |
|
| 59 |
rc = Tcl_GetIndexFromObjStruct( |
| 60 |
interp, objv[1], aCmd, sizeof(aCmd[0]), "SUB-COMMAND", 0, &iIdx |
| 61 |
); |
| 62 |
if( rc ) return rc; |
| 63 |
|
| 64 |
if( objc!=2+aCmd[iIdx].nArg ){ |
| 65 |
Tcl_WrongNumArgs(interp, 2, objv, aCmd[iIdx].zExpect); |
| 66 |
return TCL_ERROR; |
| 67 |
} |
| 68 |
|
| 69 |
switch( iIdx ){ |
| 70 |
case 0: assert( 0==strcmp("close", aCmd[iIdx].zName) ); { |
| 71 |
Tcl_DeleteCommand(interp, Tcl_GetStringFromObj(objv[0], 0)); |
| 72 |
break; |
| 73 |
} |
| 74 |
|
| 75 |
case 1: assert( 0==strcmp("step", aCmd[iIdx].zName) ); { |
| 76 |
rc = sqlite3_intck_step(p->intck); |
| 77 |
Tcl_SetObjResult(interp, Tcl_NewStringObj(sqlite3ErrName(rc), -1)); |
| 78 |
break; |
| 79 |
} |
| 80 |
|
| 81 |
case 2: assert( 0==strcmp("message", aCmd[iIdx].zName) ); { |
| 82 |
const char *z = sqlite3_intck_message(p->intck); |
| 83 |
Tcl_SetObjResult(interp, Tcl_NewStringObj(z ? z : "", -1)); |
| 84 |
break; |
| 85 |
} |
| 86 |
|
| 87 |
case 3: assert( 0==strcmp("error", aCmd[iIdx].zName) ); { |
| 88 |
const char *zErr = 0; |
| 89 |
Tcl_Obj *pRes; |
| 90 |
rc = sqlite3_intck_error(p->intck, 0); |
| 91 |
pRes = Tcl_NewObj(); |
| 92 |
Tcl_ListObjAppendElement( |
| 93 |
interp, pRes, Tcl_NewStringObj(sqlite3ErrName(rc), -1) |
| 94 |
); |
| 95 |
sqlite3_intck_error(p->intck, &zErr); |
| 96 |
Tcl_ListObjAppendElement( |
| 97 |
interp, pRes, Tcl_NewStringObj(zErr ? zErr : 0, -1) |
| 98 |
); |
| 99 |
Tcl_SetObjResult(interp, pRes); |
| 100 |
break; |
| 101 |
} |
| 102 |
|
| 103 |
case 4: assert( 0==strcmp("unlock", aCmd[iIdx].zName) ); { |
| 104 |
rc = sqlite3_intck_unlock(p->intck); |
| 105 |
Tcl_SetObjResult(interp, Tcl_NewStringObj(sqlite3ErrName(rc), -1)); |
| 106 |
break; |
| 107 |
} |
| 108 |
|
| 109 |
case 5: assert( 0==strcmp("test_sql", aCmd[iIdx].zName) ); { |
| 110 |
const char *zObj = Tcl_GetString(objv[2]); |
| 111 |
const char *zSql = sqlite3_intck_test_sql(p->intck, zObj[0] ? zObj : 0); |
| 112 |
Tcl_SetObjResult(interp, Tcl_NewStringObj(zSql, -1)); |
| 113 |
break; |
| 114 |
} |
| 115 |
} |
| 116 |
|
| 117 |
return TCL_OK; |
| 118 |
} |
| 119 |
|
| 120 |
/* |
| 121 |
** Destructor for commands created by test_sqlite3_intck(). |
| 122 |
*/ |
| 123 |
static void testIntckFree(void *clientData){ |
| 124 |
TestIntck *p = (TestIntck*)clientData; |
| 125 |
sqlite3_intck_close(p->intck); |
| 126 |
ckfree(p); |
| 127 |
} |
| 128 |
|
| 129 |
/* |
| 130 |
** tclcmd: sqlite3_intck DB DBNAME |
| 131 |
*/ |
| 132 |
static int test_sqlite3_intck( |
| 133 |
void * clientData, |
| 134 |
Tcl_Interp *interp, |
| 135 |
int objc, |
| 136 |
Tcl_Obj *CONST objv[] |
| 137 |
){ |
| 138 |
char zName[64]; |
| 139 |
int iName = 0; |
| 140 |
Tcl_CmdInfo info; |
| 141 |
TestIntck *p = 0; |
| 142 |
sqlite3 *db = 0; |
| 143 |
const char *zDb = 0; |
| 144 |
int rc = SQLITE_OK; |
| 145 |
|
| 146 |
if( objc!=3 ){ |
| 147 |
Tcl_WrongNumArgs(interp, 1, objv, "DB DBNAME"); |
| 148 |
return TCL_ERROR; |
| 149 |
} |
| 150 |
|
| 151 |
p = (TestIntck*)ckalloc(sizeof(TestIntck)); |
| 152 |
memset(p, 0, sizeof(TestIntck)); |
| 153 |
|
| 154 |
if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ){ |
| 155 |
return TCL_ERROR; |
| 156 |
} |
| 157 |
zDb = Tcl_GetString(objv[2]); |
| 158 |
if( zDb[0]=='\0' ) zDb = 0; |
| 159 |
|
| 160 |
rc = sqlite3_intck_open(db, zDb, &p->intck); |
| 161 |
if( rc!=SQLITE_OK ){ |
| 162 |
ckfree(p); |
| 163 |
Tcl_SetObjResult(interp, Tcl_NewStringObj(sqlite3_errstr(rc), -1)); |
| 164 |
return TCL_ERROR; |
| 165 |
} |
| 166 |
|
| 167 |
do { |
| 168 |
sprintf(zName, "intck%d", iName++); |
| 169 |
}while( Tcl_GetCommandInfo(interp, zName, &info)!=0 ); |
| 170 |
Tcl_CreateObjCommand(interp, zName, testIntckCmd, (void*)p, testIntckFree); |
| 171 |
Tcl_SetObjResult(interp, Tcl_NewStringObj(zName, -1)); |
| 172 |
|
| 173 |
return TCL_OK; |
| 174 |
} |
| 175 |
|
| 176 |
/* |
| 177 |
** tclcmd: test_do_intck DB DBNAME |
| 178 |
*/ |
| 179 |
static int test_do_intck( |
| 180 |
void * clientData, |
| 181 |
Tcl_Interp *interp, |
| 182 |
int objc, |
| 183 |
Tcl_Obj *CONST objv[] |
| 184 |
){ |
| 185 |
sqlite3 *db = 0; |
| 186 |
const char *zDb = 0; |
| 187 |
int rc = SQLITE_OK; |
| 188 |
sqlite3_intck *pCk = 0; |
| 189 |
Tcl_Obj *pRet = 0; |
| 190 |
const char *zErr = 0; |
| 191 |
|
| 192 |
if( objc!=3 ){ |
| 193 |
Tcl_WrongNumArgs(interp, 1, objv, "DB DBNAME"); |
| 194 |
return TCL_ERROR; |
| 195 |
} |
| 196 |
if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ){ |
| 197 |
return TCL_ERROR; |
| 198 |
} |
| 199 |
zDb = Tcl_GetString(objv[2]); |
| 200 |
|
| 201 |
pRet = Tcl_NewObj(); |
| 202 |
Tcl_IncrRefCount(pRet); |
| 203 |
|
| 204 |
rc = sqlite3_intck_open(db, zDb, &pCk); |
| 205 |
if( rc==SQLITE_OK ){ |
| 206 |
while( sqlite3_intck_step(pCk)==SQLITE_OK ){ |
| 207 |
const char *zMsg = sqlite3_intck_message(pCk); |
| 208 |
if( zMsg ){ |
| 209 |
Tcl_ListObjAppendElement(interp, pRet, Tcl_NewStringObj(zMsg, -1)); |
| 210 |
} |
| 211 |
} |
| 212 |
rc = sqlite3_intck_error(pCk, &zErr); |
| 213 |
} |
| 214 |
if( rc!=SQLITE_OK ){ |
| 215 |
if( zErr ){ |
| 216 |
Tcl_SetObjResult(interp, Tcl_NewStringObj(zErr, -1)); |
| 217 |
}else{ |
| 218 |
Tcl_SetObjResult(interp, Tcl_NewStringObj(sqlite3ErrName(rc), -1)); |
| 219 |
} |
| 220 |
}else{ |
| 221 |
Tcl_SetObjResult(interp, pRet); |
| 222 |
} |
| 223 |
Tcl_DecrRefCount(pRet); |
| 224 |
sqlite3_intck_close(pCk); |
| 225 |
sqlite3_intck_close(0); |
| 226 |
return rc ? TCL_ERROR : TCL_OK; |
| 227 |
} |
| 228 |
|
| 229 |
int Sqlitetestintck_Init(Tcl_Interp *interp){ |
| 230 |
Tcl_CreateObjCommand(interp, "sqlite3_intck", test_sqlite3_intck, 0, 0); |
| 231 |
Tcl_CreateObjCommand(interp, "test_do_intck", test_do_intck, 0, 0); |
| 232 |
return TCL_OK; |
| 233 |
} |