Debian Codegraph @

ext/intck/test_intck.c

raw
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 }