blob: fecc6ab58c54ba58bfe4abac900a611e20ab5b29 [file] [log] [blame]
drh75897232000-05-29 14:26:00 +00001/*
drhb19a2bc2001-09-16 00:13:26 +00002** 2001 September 15
drh75897232000-05-29 14:26:00 +00003**
drhb19a2bc2001-09-16 00:13:26 +00004** The author disclaims copyright to this source code. In place of
5** a legal notice, here is a blessing:
drh75897232000-05-29 14:26:00 +00006**
drhb19a2bc2001-09-16 00:13:26 +00007** 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.
drh75897232000-05-29 14:26:00 +000010**
11*************************************************************************
12** A TCL Interface to SQLite
13**
drh5e5377f2002-07-07 17:12:36 +000014** $Id: tclsqlite.c,v 1.36 2002/07/07 17:12:36 drh Exp $
drh75897232000-05-29 14:26:00 +000015*/
drh6d313162000-09-21 13:01:35 +000016#ifndef NO_TCL /* Omit this whole file if TCL is unavailable */
17
drh06b27182002-06-26 20:06:05 +000018#include "sqliteInt.h"
drh17a68932001-01-31 13:28:08 +000019#include "tcl.h"
drh75897232000-05-29 14:26:00 +000020#include <stdlib.h>
21#include <string.h>
drhce927062001-11-09 13:41:09 +000022#include <assert.h>
drh75897232000-05-29 14:26:00 +000023
24/*
drh98808ba2001-10-18 12:34:46 +000025** If TCL uses UTF-8 and SQLite is configured to use iso8859, then we
26** have to do a translation when going between the two. Set the
27** UTF_TRANSLATION_NEEDED macro to indicate that we need to do
28** this translation.
29*/
30#if defined(TCL_UTF_MAX) && !defined(SQLITE_UTF8)
31# define UTF_TRANSLATION_NEEDED 1
32#endif
33
34/*
drhbec3f402000-08-04 13:49:02 +000035** There is one instance of this structure for each SQLite database
36** that has been opened by the SQLite TCL interface.
37*/
38typedef struct SqliteDb SqliteDb;
39struct SqliteDb {
40 sqlite *db; /* The "real" database structure */
41 Tcl_Interp *interp; /* The interpreter used for this database */
drh6d313162000-09-21 13:01:35 +000042 char *zBusy; /* The busy callback routine */
drhbec3f402000-08-04 13:49:02 +000043};
44
45/*
drh75897232000-05-29 14:26:00 +000046** An instance of this structure passes information thru the sqlite
47** logic from the original TCL command into the callback routine.
48*/
49typedef struct CallbackData CallbackData;
50struct CallbackData {
51 Tcl_Interp *interp; /* The TCL interpreter */
52 char *zArray; /* The array into which data is written */
drh6d313162000-09-21 13:01:35 +000053 Tcl_Obj *pCode; /* The code to execute for each row */
drhce927062001-11-09 13:41:09 +000054 int once; /* Set for first callback only */
drh960e8c62001-04-03 16:53:21 +000055 int tcl_rc; /* Return code from TCL script */
drh98808ba2001-10-18 12:34:46 +000056 int nColName; /* Number of entries in the azColName[] array */
57 char **azColName; /* Column names translated to UTF-8 */
drh98808ba2001-10-18 12:34:46 +000058};
drh297ecf12001-04-05 15:57:13 +000059
drh6d4abfb2001-10-22 02:58:08 +000060#ifdef UTF_TRANSLATION_NEEDED
drh297ecf12001-04-05 15:57:13 +000061/*
drh75897232000-05-29 14:26:00 +000062** Called for each row of the result.
drh6d4abfb2001-10-22 02:58:08 +000063**
64** This version is used when TCL expects UTF-8 data but the database
65** uses the ISO8859 format. A translation must occur from ISO8859 into
66** UTF-8.
drh75897232000-05-29 14:26:00 +000067*/
68static int DbEvalCallback(
69 void *clientData, /* An instance of CallbackData */
70 int nCol, /* Number of columns in the result */
71 char ** azCol, /* Data for each column */
72 char ** azN /* Name for each column */
73){
74 CallbackData *cbData = (CallbackData*)clientData;
75 int i, rc;
drh297ecf12001-04-05 15:57:13 +000076 Tcl_DString dCol;
drh6d4abfb2001-10-22 02:58:08 +000077 Tcl_DStringInit(&dCol);
drhce927062001-11-09 13:41:09 +000078 if( cbData->azColName==0 ){
79 assert( cbData->once );
80 cbData->once = 0;
81 if( cbData->zArray[0] ){
82 Tcl_SetVar2(cbData->interp, cbData->zArray, "*", "", 0);
drh6d4abfb2001-10-22 02:58:08 +000083 }
drhce927062001-11-09 13:41:09 +000084 cbData->azColName = malloc( nCol*sizeof(char*) );
85 if( cbData->azColName==0 ){ return 1; }
drh6d4abfb2001-10-22 02:58:08 +000086 cbData->nColName = nCol;
87 for(i=0; i<nCol; i++){
88 Tcl_ExternalToUtfDString(NULL, azN[i], -1, &dCol);
drhce927062001-11-09 13:41:09 +000089 cbData->azColName[i] = malloc( Tcl_DStringLength(&dCol) + 1 );
90 if( cbData->azColName[i] ){
91 strcpy(cbData->azColName[i], Tcl_DStringValue(&dCol));
92 }else{
93 return 1;
drh6d4abfb2001-10-22 02:58:08 +000094 }
drhce927062001-11-09 13:41:09 +000095 if( cbData->zArray[0] ){
96 Tcl_SetVar2(cbData->interp, cbData->zArray, "*",
97 Tcl_DStringValue(&dCol), TCL_LIST_ELEMENT|TCL_APPEND_VALUE);
98 }
drh6d4abfb2001-10-22 02:58:08 +000099 Tcl_DStringFree(&dCol);
100 }
drh6d4abfb2001-10-22 02:58:08 +0000101 }
102 if( azCol!=0 ){
103 if( cbData->zArray[0] ){
104 for(i=0; i<nCol; i++){
105 char *z = azCol[i];
106 if( z==0 ) z = "";
107 Tcl_DStringInit(&dCol);
108 Tcl_ExternalToUtfDString(NULL, z, -1, &dCol);
109 Tcl_SetVar2(cbData->interp, cbData->zArray, cbData->azColName[i],
110 Tcl_DStringValue(&dCol), 0);
111 Tcl_DStringFree(&dCol);
112 }
113 }else{
114 for(i=0; i<nCol; i++){
115 char *z = azCol[i];
116 if( z==0 ) z = "";
117 Tcl_DStringInit(&dCol);
118 Tcl_ExternalToUtfDString(NULL, z, -1, &dCol);
119 Tcl_SetVar(cbData->interp, cbData->azColName[i],
120 Tcl_DStringValue(&dCol), 0);
121 Tcl_DStringFree(&dCol);
122 }
123 }
124 }
125 rc = Tcl_EvalObj(cbData->interp, cbData->pCode);
126 if( rc==TCL_CONTINUE ) rc = TCL_OK;
127 cbData->tcl_rc = rc;
128 return rc!=TCL_OK;
129}
130#endif /* UTF_TRANSLATION_NEEDED */
131
132#ifndef UTF_TRANSLATION_NEEDED
133/*
134** Called for each row of the result.
135**
136** This version is used when either of the following is true:
137**
138** (1) This version of TCL uses UTF-8 and the data in the
139** SQLite database is already in the UTF-8 format.
140**
141** (2) This version of TCL uses ISO8859 and the data in the
142** SQLite database is already in the ISO8859 format.
143*/
144static int DbEvalCallback(
145 void *clientData, /* An instance of CallbackData */
146 int nCol, /* Number of columns in the result */
147 char ** azCol, /* Data for each column */
148 char ** azN /* Name for each column */
149){
150 CallbackData *cbData = (CallbackData*)clientData;
151 int i, rc;
drh6a535342001-10-19 16:44:56 +0000152 if( azCol==0 || (cbData->once && cbData->zArray[0]) ){
153 Tcl_SetVar2(cbData->interp, cbData->zArray, "*", "", 0);
154 for(i=0; i<nCol; i++){
155 Tcl_SetVar2(cbData->interp, cbData->zArray, "*", azN[i],
156 TCL_LIST_ELEMENT|TCL_APPEND_VALUE);
157 }
158 cbData->once = 0;
159 }
160 if( azCol!=0 ){
161 if( cbData->zArray[0] ){
drh75897232000-05-29 14:26:00 +0000162 for(i=0; i<nCol; i++){
drh6a535342001-10-19 16:44:56 +0000163 char *z = azCol[i];
164 if( z==0 ) z = "";
drh6a535342001-10-19 16:44:56 +0000165 Tcl_SetVar2(cbData->interp, cbData->zArray, azN[i], z, 0);
drh6a535342001-10-19 16:44:56 +0000166 }
167 }else{
168 for(i=0; i<nCol; i++){
169 char *z = azCol[i];
170 if( z==0 ) z = "";
drh6a535342001-10-19 16:44:56 +0000171 Tcl_SetVar(cbData->interp, azN[i], z, 0);
drh75897232000-05-29 14:26:00 +0000172 }
173 }
drh75897232000-05-29 14:26:00 +0000174 }
drh6d313162000-09-21 13:01:35 +0000175 rc = Tcl_EvalObj(cbData->interp, cbData->pCode);
drh960e8c62001-04-03 16:53:21 +0000176 if( rc==TCL_CONTINUE ) rc = TCL_OK;
177 cbData->tcl_rc = rc;
178 return rc!=TCL_OK;
drh75897232000-05-29 14:26:00 +0000179}
drh6d4abfb2001-10-22 02:58:08 +0000180#endif
drh75897232000-05-29 14:26:00 +0000181
182/*
drh6d313162000-09-21 13:01:35 +0000183** This is an alternative callback for database queries. Instead
184** of invoking a TCL script to handle the result, this callback just
185** appends each column of the result to a list. After the query
186** is complete, the list is returned.
187*/
188static int DbEvalCallback2(
189 void *clientData, /* An instance of CallbackData */
190 int nCol, /* Number of columns in the result */
191 char ** azCol, /* Data for each column */
192 char ** azN /* Name for each column */
193){
194 Tcl_Obj *pList = (Tcl_Obj*)clientData;
195 int i;
drh6a535342001-10-19 16:44:56 +0000196 if( azCol==0 ) return 0;
drh6d313162000-09-21 13:01:35 +0000197 for(i=0; i<nCol; i++){
198 Tcl_Obj *pElem;
199 if( azCol[i] && *azCol[i] ){
drh297ecf12001-04-05 15:57:13 +0000200#ifdef UTF_TRANSLATION_NEEDED
201 Tcl_DString dCol;
202 Tcl_DStringInit(&dCol);
203 Tcl_ExternalToUtfDString(NULL, azCol[i], -1, &dCol);
204 pElem = Tcl_NewStringObj(Tcl_DStringValue(&dCol), -1);
205 Tcl_DStringFree(&dCol);
206#else
drh6d313162000-09-21 13:01:35 +0000207 pElem = Tcl_NewStringObj(azCol[i], -1);
drh297ecf12001-04-05 15:57:13 +0000208#endif
drh6d313162000-09-21 13:01:35 +0000209 }else{
210 pElem = Tcl_NewObj();
211 }
212 Tcl_ListObjAppendElement(0, pList, pElem);
213 }
214 return 0;
215}
216
217/*
drh75897232000-05-29 14:26:00 +0000218** Called when the command is deleted.
219*/
220static void DbDeleteCmd(void *db){
drhbec3f402000-08-04 13:49:02 +0000221 SqliteDb *pDb = (SqliteDb*)db;
222 sqlite_close(pDb->db);
223 if( pDb->zBusy ){
224 Tcl_Free(pDb->zBusy);
225 }
226 Tcl_Free((char*)pDb);
227}
228
229/*
230** This routine is called when a database file is locked while trying
231** to execute SQL.
232*/
233static int DbBusyHandler(void *cd, const char *zTable, int nTries){
234 SqliteDb *pDb = (SqliteDb*)cd;
235 int rc;
236 char zVal[30];
237 char *zCmd;
drhbec3f402000-08-04 13:49:02 +0000238 Tcl_DString cmd;
239
240 Tcl_DStringInit(&cmd);
241 Tcl_DStringAppend(&cmd, pDb->zBusy, -1);
242 Tcl_DStringAppendElement(&cmd, zTable);
243 sprintf(zVal, " %d", nTries);
244 Tcl_DStringAppend(&cmd, zVal, -1);
245 zCmd = Tcl_DStringValue(&cmd);
246 rc = Tcl_Eval(pDb->interp, zCmd);
247 Tcl_DStringFree(&cmd);
248 if( rc!=TCL_OK || atoi(Tcl_GetStringResult(pDb->interp)) ){
249 return 0;
250 }
251 return 1;
drh75897232000-05-29 14:26:00 +0000252}
253
254/*
255** The "sqlite" command below creates a new Tcl command for each
256** connection it opens to an SQLite database. This routine is invoked
257** whenever one of those connection-specific commands is executed
258** in Tcl. For example, if you run Tcl code like this:
259**
260** sqlite db1 "my_database"
261** db1 close
262**
263** The first command opens a connection to the "my_database" database
264** and calls that connection "db1". The second command causes this
265** subroutine to be invoked.
266*/
drh6d313162000-09-21 13:01:35 +0000267static int DbObjCmd(void *cd, Tcl_Interp *interp, int objc,Tcl_Obj *const*objv){
drhbec3f402000-08-04 13:49:02 +0000268 SqliteDb *pDb = (SqliteDb*)cd;
drh6d313162000-09-21 13:01:35 +0000269 int choice;
drh0de8c112002-07-06 16:32:14 +0000270 static const char *DB_strs[] = {
drh411995d2002-06-25 19:31:18 +0000271 "busy", "changes", "close",
272 "complete", "eval", "last_insert_rowid",
273 "open_aux_file", "timeout", 0
drh6d313162000-09-21 13:01:35 +0000274 };
drh411995d2002-06-25 19:31:18 +0000275 enum DB_enum {
276 DB_BUSY, DB_CHANGES, DB_CLOSE,
277 DB_COMPLETE, DB_EVAL, DB_LAST_INSERT_ROWID,
278 DB_OPEN_AUX_FILE, DB_TIMEOUT,
drh6d313162000-09-21 13:01:35 +0000279 };
280
281 if( objc<2 ){
282 Tcl_WrongNumArgs(interp, 1, objv, "SUBCOMMAND ...");
drh75897232000-05-29 14:26:00 +0000283 return TCL_ERROR;
284 }
drh411995d2002-06-25 19:31:18 +0000285 if( Tcl_GetIndexFromObj(interp, objv[1], DB_strs, "option", 0, &choice) ){
drh6d313162000-09-21 13:01:35 +0000286 return TCL_ERROR;
287 }
288
drh411995d2002-06-25 19:31:18 +0000289 switch( (enum DB_enum)choice ){
drh75897232000-05-29 14:26:00 +0000290
drhbec3f402000-08-04 13:49:02 +0000291 /* $db busy ?CALLBACK?
292 **
293 ** Invoke the given callback if an SQL statement attempts to open
294 ** a locked database file.
295 */
drh6d313162000-09-21 13:01:35 +0000296 case DB_BUSY: {
297 if( objc>3 ){
298 Tcl_WrongNumArgs(interp, 2, objv, "CALLBACK");
drhbec3f402000-08-04 13:49:02 +0000299 return TCL_ERROR;
drh6d313162000-09-21 13:01:35 +0000300 }else if( objc==2 ){
drhbec3f402000-08-04 13:49:02 +0000301 if( pDb->zBusy ){
302 Tcl_AppendResult(interp, pDb->zBusy, 0);
303 }
304 }else{
drh6d313162000-09-21 13:01:35 +0000305 char *zBusy;
306 int len;
drhbec3f402000-08-04 13:49:02 +0000307 if( pDb->zBusy ){
308 Tcl_Free(pDb->zBusy);
drhbec3f402000-08-04 13:49:02 +0000309 }
drh6d313162000-09-21 13:01:35 +0000310 zBusy = Tcl_GetStringFromObj(objv[2], &len);
311 if( zBusy && len>0 ){
312 pDb->zBusy = Tcl_Alloc( len + 1 );
313 strcpy(pDb->zBusy, zBusy);
314 }else{
315 pDb->zBusy = 0;
drhbec3f402000-08-04 13:49:02 +0000316 }
317 if( pDb->zBusy ){
318 pDb->interp = interp;
319 sqlite_busy_handler(pDb->db, DbBusyHandler, pDb);
drh6d313162000-09-21 13:01:35 +0000320 }else{
321 sqlite_busy_handler(pDb->db, 0, 0);
drhbec3f402000-08-04 13:49:02 +0000322 }
323 }
drh6d313162000-09-21 13:01:35 +0000324 break;
325 }
drhbec3f402000-08-04 13:49:02 +0000326
drhc8d30ac2002-04-12 10:08:59 +0000327 /*
328 ** $db changes
329 **
330 ** Return the number of rows that were modified, inserted, or deleted by
331 ** the most recent "eval".
332 */
333 case DB_CHANGES: {
334 Tcl_Obj *pResult;
335 int nChange;
336 if( objc!=2 ){
337 Tcl_WrongNumArgs(interp, 2, objv, "");
338 return TCL_ERROR;
339 }
340 nChange = sqlite_changes(pDb->db);
341 pResult = Tcl_GetObjResult(interp);
342 Tcl_SetIntObj(pResult, nChange);
343 break;
344 }
345
drh75897232000-05-29 14:26:00 +0000346 /* $db close
347 **
348 ** Shutdown the database
349 */
drh6d313162000-09-21 13:01:35 +0000350 case DB_CLOSE: {
351 Tcl_DeleteCommand(interp, Tcl_GetStringFromObj(objv[0], 0));
352 break;
353 }
drh75897232000-05-29 14:26:00 +0000354
355 /* $db complete SQL
356 **
357 ** Return TRUE if SQL is a complete SQL statement. Return FALSE if
358 ** additional lines of input are needed. This is similar to the
359 ** built-in "info complete" command of Tcl.
360 */
drh6d313162000-09-21 13:01:35 +0000361 case DB_COMPLETE: {
362 Tcl_Obj *pResult;
363 int isComplete;
364 if( objc!=3 ){
365 Tcl_WrongNumArgs(interp, 2, objv, "SQL");
drh75897232000-05-29 14:26:00 +0000366 return TCL_ERROR;
367 }
drh6d313162000-09-21 13:01:35 +0000368 isComplete = sqlite_complete( Tcl_GetStringFromObj(objv[2], 0) );
369 pResult = Tcl_GetObjResult(interp);
370 Tcl_SetBooleanObj(pResult, isComplete);
371 break;
372 }
drh75897232000-05-29 14:26:00 +0000373
374 /*
375 ** $db eval $sql ?array { ...code... }?
376 **
377 ** The SQL statement in $sql is evaluated. For each row, the values are
drhbec3f402000-08-04 13:49:02 +0000378 ** placed in elements of the array named "array" and ...code... is executed.
drh75897232000-05-29 14:26:00 +0000379 ** If "array" and "code" are omitted, then no callback is every invoked.
380 ** If "array" is an empty string, then the values are placed in variables
381 ** that have the same name as the fields extracted by the query.
382 */
drh6d313162000-09-21 13:01:35 +0000383 case DB_EVAL: {
drh75897232000-05-29 14:26:00 +0000384 CallbackData cbData;
385 char *zErrMsg;
drh6d313162000-09-21 13:01:35 +0000386 char *zSql;
drh75897232000-05-29 14:26:00 +0000387 int rc;
drh297ecf12001-04-05 15:57:13 +0000388#ifdef UTF_TRANSLATION_NEEDED
389 Tcl_DString dSql;
drh6d4abfb2001-10-22 02:58:08 +0000390 int i;
drh297ecf12001-04-05 15:57:13 +0000391#endif
drh75897232000-05-29 14:26:00 +0000392
drh6d313162000-09-21 13:01:35 +0000393 if( objc!=5 && objc!=3 ){
394 Tcl_WrongNumArgs(interp, 2, objv, "SQL ?ARRAY-NAME CODE?");
drh75897232000-05-29 14:26:00 +0000395 return TCL_ERROR;
396 }
drhbec3f402000-08-04 13:49:02 +0000397 pDb->interp = interp;
drh6d313162000-09-21 13:01:35 +0000398 zSql = Tcl_GetStringFromObj(objv[2], 0);
drh297ecf12001-04-05 15:57:13 +0000399#ifdef UTF_TRANSLATION_NEEDED
400 Tcl_DStringInit(&dSql);
401 Tcl_UtfToExternalDString(NULL, zSql, -1, &dSql);
402 zSql = Tcl_DStringValue(&dSql);
403#endif
drh6d313162000-09-21 13:01:35 +0000404 Tcl_IncrRefCount(objv[2]);
405 if( objc==5 ){
drh75897232000-05-29 14:26:00 +0000406 cbData.interp = interp;
drhdcc581c2000-05-30 13:44:19 +0000407 cbData.once = 1;
drh6d313162000-09-21 13:01:35 +0000408 cbData.zArray = Tcl_GetStringFromObj(objv[3], 0);
409 cbData.pCode = objv[4];
drh960e8c62001-04-03 16:53:21 +0000410 cbData.tcl_rc = TCL_OK;
drh6d4abfb2001-10-22 02:58:08 +0000411 cbData.nColName = 0;
412 cbData.azColName = 0;
drh75897232000-05-29 14:26:00 +0000413 zErrMsg = 0;
drh6d313162000-09-21 13:01:35 +0000414 Tcl_IncrRefCount(objv[3]);
415 Tcl_IncrRefCount(objv[4]);
416 rc = sqlite_exec(pDb->db, zSql, DbEvalCallback, &cbData, &zErrMsg);
417 Tcl_DecrRefCount(objv[4]);
418 Tcl_DecrRefCount(objv[3]);
drh960e8c62001-04-03 16:53:21 +0000419 if( cbData.tcl_rc==TCL_BREAK ){ cbData.tcl_rc = TCL_OK; }
drh75897232000-05-29 14:26:00 +0000420 }else{
drh6d313162000-09-21 13:01:35 +0000421 Tcl_Obj *pList = Tcl_NewObj();
drh960e8c62001-04-03 16:53:21 +0000422 cbData.tcl_rc = TCL_OK;
drh6d313162000-09-21 13:01:35 +0000423 rc = sqlite_exec(pDb->db, zSql, DbEvalCallback2, pList, &zErrMsg);
424 Tcl_SetObjResult(interp, pList);
drh75897232000-05-29 14:26:00 +0000425 }
426 if( zErrMsg ){
427 Tcl_SetResult(interp, zErrMsg, TCL_VOLATILE);
428 free(zErrMsg);
drh960e8c62001-04-03 16:53:21 +0000429 rc = TCL_ERROR;
drh6d4abfb2001-10-22 02:58:08 +0000430 }else if( rc!=SQLITE_OK && rc!=SQLITE_ABORT ){
431 Tcl_AppendResult(interp, sqlite_error_string(rc), 0);
432 rc = TCL_ERROR;
drh960e8c62001-04-03 16:53:21 +0000433 }else{
434 rc = cbData.tcl_rc;
drh75897232000-05-29 14:26:00 +0000435 }
drh6d313162000-09-21 13:01:35 +0000436 Tcl_DecrRefCount(objv[2]);
drh297ecf12001-04-05 15:57:13 +0000437#ifdef UTF_TRANSLATION_NEEDED
438 Tcl_DStringFree(&dSql);
drh6d4abfb2001-10-22 02:58:08 +0000439 if( objc==5 && cbData.azColName ){
440 for(i=0; i<cbData.nColName; i++){
441 if( cbData.azColName[i] ) free(cbData.azColName[i]);
442 }
443 free(cbData.azColName);
drhce927062001-11-09 13:41:09 +0000444 cbData.azColName = 0;
drh6d4abfb2001-10-22 02:58:08 +0000445 }
drh297ecf12001-04-05 15:57:13 +0000446#endif
drh75897232000-05-29 14:26:00 +0000447 return rc;
drh6d313162000-09-21 13:01:35 +0000448 }
drhbec3f402000-08-04 13:49:02 +0000449
450 /*
drhaf9ff332002-01-16 21:00:27 +0000451 ** $db last_insert_rowid
452 **
453 ** Return an integer which is the ROWID for the most recent insert.
454 */
455 case DB_LAST_INSERT_ROWID: {
456 Tcl_Obj *pResult;
457 int rowid;
458 if( objc!=2 ){
459 Tcl_WrongNumArgs(interp, 2, objv, "");
460 return TCL_ERROR;
461 }
462 rowid = sqlite_last_insert_rowid(pDb->db);
463 pResult = Tcl_GetObjResult(interp);
464 Tcl_SetIntObj(pResult, rowid);
465 break;
466 }
467
468 /*
drh411995d2002-06-25 19:31:18 +0000469 ** $db open_aux_file FILENAME
470 **
471 ** Begin using FILENAME as the database file used to store temporary
472 ** tables.
473 */
474 case DB_OPEN_AUX_FILE: {
475 const char *zFilename;
476 char *zErrMsg = 0;
477 int rc;
478 if( objc!=3 ){
479 Tcl_WrongNumArgs(interp, 2, objv, "FILENAME");
480 return TCL_ERROR;
481 }
482 zFilename = Tcl_GetStringFromObj(objv[2], 0);
483 rc = sqlite_open_aux_file(pDb->db, zFilename, &zErrMsg);
484 if( rc!=0 ){
485 if( zErrMsg ){
486 Tcl_AppendResult(interp, zErrMsg, 0);
487 free(zErrMsg);
488 }else{
489 Tcl_AppendResult(interp, sqlite_error_string(rc), 0);
490 }
491 return TCL_ERROR;
492 }
493 break;
494 }
495
496 /*
drhbec3f402000-08-04 13:49:02 +0000497 ** $db timeout MILLESECONDS
498 **
499 ** Delay for the number of milliseconds specified when a file is locked.
500 */
drh6d313162000-09-21 13:01:35 +0000501 case DB_TIMEOUT: {
drhbec3f402000-08-04 13:49:02 +0000502 int ms;
drh6d313162000-09-21 13:01:35 +0000503 if( objc!=3 ){
504 Tcl_WrongNumArgs(interp, 2, objv, "MILLISECONDS");
drhbec3f402000-08-04 13:49:02 +0000505 return TCL_ERROR;
506 }
drh6d313162000-09-21 13:01:35 +0000507 if( Tcl_GetIntFromObj(interp, objv[2], &ms) ) return TCL_ERROR;
drhbec3f402000-08-04 13:49:02 +0000508 sqlite_busy_timeout(pDb->db, ms);
drh6d313162000-09-21 13:01:35 +0000509 break;
drh75897232000-05-29 14:26:00 +0000510 }
drh6d313162000-09-21 13:01:35 +0000511 } /* End of the SWITCH statement */
drh75897232000-05-29 14:26:00 +0000512 return TCL_OK;
513}
514
515/*
516** sqlite DBNAME FILENAME ?MODE?
517**
518** This is the main Tcl command. When the "sqlite" Tcl command is
519** invoked, this routine runs to process that command.
520**
521** The first argument, DBNAME, is an arbitrary name for a new
522** database connection. This command creates a new command named
523** DBNAME that is used to control that connection. The database
524** connection is deleted when the DBNAME command is deleted.
525**
526** The second argument is the name of the directory that contains
527** the sqlite database that is to be accessed.
drhfbc3eab2001-04-06 16:13:42 +0000528**
529** For testing purposes, we also support the following:
530**
531** sqlite -encoding
532**
533** Return the encoding used by LIKE and GLOB operators. Choices
534** are UTF-8 and iso8859.
535**
536** sqlite -tcl-uses-utf
537**
538** Return "1" if compiled with a Tcl uses UTF-8. Return "0" if
539** not. Used by tests to make sure the library was compiled
540** correctly.
drh75897232000-05-29 14:26:00 +0000541*/
542static int DbMain(void *cd, Tcl_Interp *interp, int argc, char **argv){
543 int mode;
drhbec3f402000-08-04 13:49:02 +0000544 SqliteDb *p;
drh75897232000-05-29 14:26:00 +0000545 char *zErrMsg;
drh06b27182002-06-26 20:06:05 +0000546 char zBuf[80];
drhfbc3eab2001-04-06 16:13:42 +0000547 if( argc==2 ){
548 if( strcmp(argv[1],"-encoding")==0 ){
549 Tcl_AppendResult(interp,sqlite_encoding,0);
550 return TCL_OK;
551 }
552 if( strcmp(argv[1],"-tcl-uses-utf")==0 ){
553#ifdef TCL_UTF_MAX
554 Tcl_AppendResult(interp,"1",0);
555#else
556 Tcl_AppendResult(interp,"0",0);
557#endif
558 return TCL_OK;
559 }
560 }
drh75897232000-05-29 14:26:00 +0000561 if( argc!=3 && argc!=4 ){
562 Tcl_AppendResult(interp,"wrong # args: should be \"", argv[0],
563 " HANDLE FILENAME ?MODE?\"", 0);
564 return TCL_ERROR;
565 }
566 if( argc==3 ){
drh58b95762000-06-02 01:17:37 +0000567 mode = 0666;
drh75897232000-05-29 14:26:00 +0000568 }else if( Tcl_GetInt(interp, argv[3], &mode)!=TCL_OK ){
569 return TCL_ERROR;
570 }
571 zErrMsg = 0;
drh4cdc9e82000-08-04 14:56:24 +0000572 p = (SqliteDb*)Tcl_Alloc( sizeof(*p) );
drh75897232000-05-29 14:26:00 +0000573 if( p==0 ){
drhbec3f402000-08-04 13:49:02 +0000574 Tcl_SetResult(interp, "malloc failed", TCL_STATIC);
575 return TCL_ERROR;
576 }
577 memset(p, 0, sizeof(*p));
578 p->db = sqlite_open(argv[2], mode, &zErrMsg);
579 if( p->db==0 ){
drh75897232000-05-29 14:26:00 +0000580 Tcl_SetResult(interp, zErrMsg, TCL_VOLATILE);
drhbec3f402000-08-04 13:49:02 +0000581 Tcl_Free((char*)p);
drh75897232000-05-29 14:26:00 +0000582 free(zErrMsg);
583 return TCL_ERROR;
584 }
drh6d313162000-09-21 13:01:35 +0000585 Tcl_CreateObjCommand(interp, argv[1], DbObjCmd, (char*)p, DbDeleteCmd);
drhc22bd472002-05-10 13:14:07 +0000586
drh06b27182002-06-26 20:06:05 +0000587 /* The return value is the value of the sqlite* pointer
588 */
589 sprintf(zBuf, "%p", p->db);
drh5e5377f2002-07-07 17:12:36 +0000590 if( strncmp(zBuf,"0x",2) ){
591 sprintf(zBuf, "0x%p", p->db);
592 }
drh06b27182002-06-26 20:06:05 +0000593 Tcl_AppendResult(interp, zBuf, 0);
594
drhc22bd472002-05-10 13:14:07 +0000595 /* If compiled with SQLITE_TEST turned on, then register the "md5sum"
drh06b27182002-06-26 20:06:05 +0000596 ** SQL function.
drhc22bd472002-05-10 13:14:07 +0000597 */
drh28b4e482002-03-11 02:06:13 +0000598#ifdef SQLITE_TEST
599 {
drhc22bd472002-05-10 13:14:07 +0000600 extern void Md5_Register(sqlite*);
601 Md5_Register(p->db);
drh06b27182002-06-26 20:06:05 +0000602 }
drh28b4e482002-03-11 02:06:13 +0000603#endif
drh75897232000-05-29 14:26:00 +0000604 return TCL_OK;
605}
606
607/*
drh90ca9752001-09-28 17:47:14 +0000608** Provide a dummy Tcl_InitStubs if we are using this as a static
609** library.
610*/
611#ifndef USE_TCL_STUBS
612# undef Tcl_InitStubs
613# define Tcl_InitStubs(a,b,c)
614#endif
615
616/*
drh75897232000-05-29 14:26:00 +0000617** Initialize this module.
618**
619** This Tcl module contains only a single new Tcl command named "sqlite".
620** (Hence there is no namespace. There is no point in using a namespace
621** if the extension only supplies one new name!) The "sqlite" command is
622** used to open a new SQLite database. See the DbMain() routine above
623** for additional information.
624*/
625int Sqlite_Init(Tcl_Interp *interp){
drh90ca9752001-09-28 17:47:14 +0000626 Tcl_InitStubs(interp, "8.0", 0);
627 Tcl_CreateCommand(interp, "sqlite", DbMain, 0, 0);
drh6d4abfb2001-10-22 02:58:08 +0000628 Tcl_PkgProvide(interp, "sqlite", "2.0");
drh90ca9752001-09-28 17:47:14 +0000629 return TCL_OK;
630}
631int Tclsqlite_Init(Tcl_Interp *interp){
632 Tcl_InitStubs(interp, "8.0", 0);
drh75897232000-05-29 14:26:00 +0000633 Tcl_CreateCommand(interp, "sqlite", DbMain, 0, 0);
drh6d4abfb2001-10-22 02:58:08 +0000634 Tcl_PkgProvide(interp, "sqlite", "2.0");
drh75897232000-05-29 14:26:00 +0000635 return TCL_OK;
636}
637int Sqlite_SafeInit(Tcl_Interp *interp){
638 return TCL_OK;
639}
drh90ca9752001-09-28 17:47:14 +0000640int Tclsqlite_SafeInit(Tcl_Interp *interp){
641 return TCL_OK;
642}
drh75897232000-05-29 14:26:00 +0000643
drh3cebbde2000-10-19 14:59:27 +0000644#if 0
drh75897232000-05-29 14:26:00 +0000645/*
646** If compiled using mktclapp, this routine runs to initialize
647** everything.
648*/
649int Et_AppInit(Tcl_Interp *interp){
650 return Sqlite_Init(interp);
651}
drh3cebbde2000-10-19 14:59:27 +0000652#endif
drh348784e2000-05-29 20:41:49 +0000653
654/*
655** If the macro TCLSH is defined and is one, then put in code for the
656** "main" routine that will initialize Tcl.
657*/
658#if defined(TCLSH) && TCLSH==1
659static char zMainloop[] =
660 "set line {}\n"
661 "while {![eof stdin]} {\n"
662 "if {$line!=\"\"} {\n"
663 "puts -nonewline \"> \"\n"
664 "} else {\n"
665 "puts -nonewline \"% \"\n"
666 "}\n"
667 "flush stdout\n"
668 "append line [gets stdin]\n"
669 "if {[info complete $line]} {\n"
670 "if {[catch {uplevel #0 $line} result]} {\n"
671 "puts stderr \"Error: $result\"\n"
672 "} elseif {$result!=\"\"} {\n"
673 "puts $result\n"
674 "}\n"
675 "set line {}\n"
676 "} else {\n"
677 "append line \\n\n"
678 "}\n"
679 "}\n"
680;
681
682#define TCLSH_MAIN main /* Needed to fake out mktclapp */
683int TCLSH_MAIN(int argc, char **argv){
684 Tcl_Interp *interp;
drh297ecf12001-04-05 15:57:13 +0000685 Tcl_FindExecutable(argv[0]);
drh348784e2000-05-29 20:41:49 +0000686 interp = Tcl_CreateInterp();
687 Sqlite_Init(interp);
drhd9b02572001-04-15 00:37:09 +0000688#ifdef SQLITE_TEST
drhd1bf3512001-04-07 15:24:33 +0000689 {
690 extern int Sqlitetest1_Init(Tcl_Interp*);
drh5c4d9702001-08-20 00:33:58 +0000691 extern int Sqlitetest2_Init(Tcl_Interp*);
692 extern int Sqlitetest3_Init(Tcl_Interp*);
drhefc251d2001-07-01 22:12:01 +0000693 extern int Md5_Init(Tcl_Interp*);
drhd1bf3512001-04-07 15:24:33 +0000694 Sqlitetest1_Init(interp);
drh5c4d9702001-08-20 00:33:58 +0000695 Sqlitetest2_Init(interp);
696 Sqlitetest3_Init(interp);
drhefc251d2001-07-01 22:12:01 +0000697 Md5_Init(interp);
drhd1bf3512001-04-07 15:24:33 +0000698 }
699#endif
drh348784e2000-05-29 20:41:49 +0000700 if( argc>=2 ){
701 int i;
702 Tcl_SetVar(interp,"argv0",argv[1],TCL_GLOBAL_ONLY);
703 Tcl_SetVar(interp,"argv", "", TCL_GLOBAL_ONLY);
704 for(i=2; i<argc; i++){
705 Tcl_SetVar(interp, "argv", argv[i],
706 TCL_GLOBAL_ONLY | TCL_LIST_ELEMENT | TCL_APPEND_VALUE);
707 }
708 if( Tcl_EvalFile(interp, argv[1])!=TCL_OK ){
drh0de8c112002-07-06 16:32:14 +0000709 const char *zInfo = Tcl_GetVar(interp, "errorInfo", TCL_GLOBAL_ONLY);
drhc61053b2000-06-04 12:58:36 +0000710 if( zInfo==0 ) zInfo = interp->result;
711 fprintf(stderr,"%s: %s\n", *argv, zInfo);
drh348784e2000-05-29 20:41:49 +0000712 return 1;
713 }
714 }else{
715 Tcl_GlobalEval(interp, zMainloop);
716 }
717 return 0;
718}
719#endif /* TCLSH */
drh6d313162000-09-21 13:01:35 +0000720
721#endif /* !defined(NO_TCL) */