| OLD | NEW |
| 1 /* | 1 /* |
| 2 ** 2009 November 10 | 2 ** 2009 November 10 |
| 3 ** | 3 ** |
| 4 ** The author disclaims copyright to this source code. In place of | 4 ** The author disclaims copyright to this source code. In place of |
| 5 ** a legal notice, here is a blessing: | 5 ** a legal notice, here is a blessing: |
| 6 ** | 6 ** |
| 7 ** May you do good and not evil. | 7 ** May you do good and not evil. |
| 8 ** May you find forgiveness for yourself and forgive others. | 8 ** May you find forgiveness for yourself and forgive others. |
| 9 ** May you share freely, never taking more than you give. | 9 ** May you share freely, never taking more than you give. |
| 10 ** | 10 ** |
| (...skipping 19 matching lines...) Expand all Loading... |
| 30 struct sqlite3_intarray { | 30 struct sqlite3_intarray { |
| 31 int n; /* Number of elements in the array */ | 31 int n; /* Number of elements in the array */ |
| 32 sqlite3_int64 *a; /* Contents of the array */ | 32 sqlite3_int64 *a; /* Contents of the array */ |
| 33 void (*xFree)(void*); /* Function used to free a[] */ | 33 void (*xFree)(void*); /* Function used to free a[] */ |
| 34 }; | 34 }; |
| 35 | 35 |
| 36 /* Objects used internally by the virtual table implementation */ | 36 /* Objects used internally by the virtual table implementation */ |
| 37 typedef struct intarray_vtab intarray_vtab; | 37 typedef struct intarray_vtab intarray_vtab; |
| 38 typedef struct intarray_cursor intarray_cursor; | 38 typedef struct intarray_cursor intarray_cursor; |
| 39 | 39 |
| 40 /* A intarray table object */ | 40 /* An intarray table object */ |
| 41 struct intarray_vtab { | 41 struct intarray_vtab { |
| 42 sqlite3_vtab base; /* Base class */ | 42 sqlite3_vtab base; /* Base class */ |
| 43 sqlite3_intarray *pContent; /* Content of the integer array */ | 43 sqlite3_intarray *pContent; /* Content of the integer array */ |
| 44 }; | 44 }; |
| 45 | 45 |
| 46 /* A intarray cursor object */ | 46 /* An intarray cursor object */ |
| 47 struct intarray_cursor { | 47 struct intarray_cursor { |
| 48 sqlite3_vtab_cursor base; /* Base class */ | 48 sqlite3_vtab_cursor base; /* Base class */ |
| 49 int i; /* Current cursor position */ | 49 int i; /* Current cursor position */ |
| 50 }; | 50 }; |
| 51 | 51 |
| 52 /* | 52 /* |
| 53 ** None of this works unless we have virtual tables. | 53 ** None of this works unless we have virtual tables. |
| 54 */ | 54 */ |
| 55 #ifndef SQLITE_OMIT_VIRTUALTABLE | 55 #ifndef SQLITE_OMIT_VIRTUALTABLE |
| 56 | 56 |
| (...skipping 152 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 209 ** Invoke this routine to create a specific instance of an intarray object. | 209 ** Invoke this routine to create a specific instance of an intarray object. |
| 210 ** The new intarray object is returned by the 3rd parameter. | 210 ** The new intarray object is returned by the 3rd parameter. |
| 211 ** | 211 ** |
| 212 ** Each intarray object corresponds to a virtual table in the TEMP table | 212 ** Each intarray object corresponds to a virtual table in the TEMP table |
| 213 ** with a name of zName. | 213 ** with a name of zName. |
| 214 ** | 214 ** |
| 215 ** Destroy the intarray object by dropping the virtual table. If not done | 215 ** Destroy the intarray object by dropping the virtual table. If not done |
| 216 ** explicitly by the application, the virtual table will be dropped implicitly | 216 ** explicitly by the application, the virtual table will be dropped implicitly |
| 217 ** by the system when the database connection is closed. | 217 ** by the system when the database connection is closed. |
| 218 */ | 218 */ |
| 219 int sqlite3_intarray_create( | 219 SQLITE_API int sqlite3_intarray_create( |
| 220 sqlite3 *db, | 220 sqlite3 *db, |
| 221 const char *zName, | 221 const char *zName, |
| 222 sqlite3_intarray **ppReturn | 222 sqlite3_intarray **ppReturn |
| 223 ){ | 223 ){ |
| 224 int rc = SQLITE_OK; | 224 int rc = SQLITE_OK; |
| 225 #ifndef SQLITE_OMIT_VIRTUALTABLE | 225 #ifndef SQLITE_OMIT_VIRTUALTABLE |
| 226 sqlite3_intarray *p; | 226 sqlite3_intarray *p; |
| 227 | 227 |
| 228 *ppReturn = p = sqlite3_malloc( sizeof(*p) ); | 228 *ppReturn = p = sqlite3_malloc( sizeof(*p) ); |
| 229 if( p==0 ){ | 229 if( p==0 ){ |
| (...skipping 13 matching lines...) Expand all Loading... |
| 243 return rc; | 243 return rc; |
| 244 } | 244 } |
| 245 | 245 |
| 246 /* | 246 /* |
| 247 ** Bind a new array array of integers to a specific intarray object. | 247 ** Bind a new array array of integers to a specific intarray object. |
| 248 ** | 248 ** |
| 249 ** The array of integers bound must be unchanged for the duration of | 249 ** The array of integers bound must be unchanged for the duration of |
| 250 ** any query against the corresponding virtual table. If the integer | 250 ** any query against the corresponding virtual table. If the integer |
| 251 ** array does change or is deallocated undefined behavior will result. | 251 ** array does change or is deallocated undefined behavior will result. |
| 252 */ | 252 */ |
| 253 int sqlite3_intarray_bind( | 253 SQLITE_API int sqlite3_intarray_bind( |
| 254 sqlite3_intarray *pIntArray, /* The intarray object to bind to */ | 254 sqlite3_intarray *pIntArray, /* The intarray object to bind to */ |
| 255 int nElements, /* Number of elements in the intarray */ | 255 int nElements, /* Number of elements in the intarray */ |
| 256 sqlite3_int64 *aElements, /* Content of the intarray */ | 256 sqlite3_int64 *aElements, /* Content of the intarray */ |
| 257 void (*xFree)(void*) /* How to dispose of the intarray when done */ | 257 void (*xFree)(void*) /* How to dispose of the intarray when done */ |
| 258 ){ | 258 ){ |
| 259 if( pIntArray->xFree ){ | 259 if( pIntArray->xFree ){ |
| 260 pIntArray->xFree(pIntArray->a); | 260 pIntArray->xFree(pIntArray->a); |
| 261 } | 261 } |
| 262 pIntArray->n = nElements; | 262 pIntArray->n = nElements; |
| 263 pIntArray->a = aElements; | 263 pIntArray->a = aElements; |
| 264 pIntArray->xFree = xFree; | 264 pIntArray->xFree = xFree; |
| 265 return SQLITE_OK; | 265 return SQLITE_OK; |
| 266 } | 266 } |
| 267 | 267 |
| 268 | 268 |
| 269 /***************************************************************************** | 269 /***************************************************************************** |
| 270 ** Everything below is interface for testing this module. | 270 ** Everything below is interface for testing this module. |
| 271 */ | 271 */ |
| 272 #ifdef SQLITE_TEST | 272 #ifdef SQLITE_TEST |
| 273 #include <tcl.h> | 273 #include <tcl.h> |
| 274 | 274 |
| 275 /* | 275 /* |
| 276 ** Routines to encode and decode pointers | 276 ** Routines to encode and decode pointers |
| 277 */ | 277 */ |
| 278 extern int getDbPointer(Tcl_Interp *interp, const char *zA, sqlite3 **ppDb); | 278 extern int getDbPointer(Tcl_Interp *interp, const char *zA, sqlite3 **ppDb); |
| 279 extern void *sqlite3TestTextToPtr(const char*); | 279 extern void *sqlite3TestTextToPtr(const char*); |
| 280 extern int sqlite3TestMakePointerStr(Tcl_Interp*, char *zPtr, void*); | 280 extern int sqlite3TestMakePointerStr(Tcl_Interp*, char *zPtr, void*); |
| 281 extern const char *sqlite3TestErrorName(int); | 281 extern const char *sqlite3ErrName(int); |
| 282 | 282 |
| 283 /* | 283 /* |
| 284 ** sqlite3_intarray_create DB NAME | 284 ** sqlite3_intarray_create DB NAME |
| 285 ** | 285 ** |
| 286 ** Invoke the sqlite3_intarray_create interface. A string that becomes | 286 ** Invoke the sqlite3_intarray_create interface. A string that becomes |
| 287 ** the first parameter to sqlite3_intarray_bind. | 287 ** the first parameter to sqlite3_intarray_bind. |
| 288 */ | 288 */ |
| 289 static int test_intarray_create( | 289 static int test_intarray_create( |
| 290 ClientData clientData, /* Not used */ | 290 ClientData clientData, /* Not used */ |
| 291 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ | 291 Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ |
| (...skipping 10 matching lines...) Expand all Loading... |
| 302 Tcl_WrongNumArgs(interp, 1, objv, "DB"); | 302 Tcl_WrongNumArgs(interp, 1, objv, "DB"); |
| 303 return TCL_ERROR; | 303 return TCL_ERROR; |
| 304 } | 304 } |
| 305 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; | 305 if( getDbPointer(interp, Tcl_GetString(objv[1]), &db) ) return TCL_ERROR; |
| 306 zName = Tcl_GetString(objv[2]); | 306 zName = Tcl_GetString(objv[2]); |
| 307 #ifndef SQLITE_OMIT_VIRTUALTABLE | 307 #ifndef SQLITE_OMIT_VIRTUALTABLE |
| 308 rc = sqlite3_intarray_create(db, zName, &pArray); | 308 rc = sqlite3_intarray_create(db, zName, &pArray); |
| 309 #endif | 309 #endif |
| 310 if( rc!=SQLITE_OK ){ | 310 if( rc!=SQLITE_OK ){ |
| 311 assert( pArray==0 ); | 311 assert( pArray==0 ); |
| 312 Tcl_AppendResult(interp, sqlite3TestErrorName(rc), (char*)0); | 312 Tcl_AppendResult(interp, sqlite3ErrName(rc), (char*)0); |
| 313 return TCL_ERROR; | 313 return TCL_ERROR; |
| 314 } | 314 } |
| 315 sqlite3TestMakePointerStr(interp, zPtr, pArray); | 315 sqlite3TestMakePointerStr(interp, zPtr, pArray); |
| 316 Tcl_AppendResult(interp, zPtr, (char*)0); | 316 Tcl_AppendResult(interp, zPtr, (char*)0); |
| 317 return TCL_OK; | 317 return TCL_OK; |
| 318 } | 318 } |
| 319 | 319 |
| 320 /* | 320 /* |
| 321 ** sqlite3_intarray_bind INTARRAY ?VALUE ...? | 321 ** sqlite3_intarray_bind INTARRAY ?VALUE ...? |
| 322 ** | 322 ** |
| (...skipping 16 matching lines...) Expand all Loading... |
| 339 } | 339 } |
| 340 pArray = (sqlite3_intarray*)sqlite3TestTextToPtr(Tcl_GetString(objv[1])); | 340 pArray = (sqlite3_intarray*)sqlite3TestTextToPtr(Tcl_GetString(objv[1])); |
| 341 n = objc - 2; | 341 n = objc - 2; |
| 342 #ifndef SQLITE_OMIT_VIRTUALTABLE | 342 #ifndef SQLITE_OMIT_VIRTUALTABLE |
| 343 a = sqlite3_malloc( sizeof(a[0])*n ); | 343 a = sqlite3_malloc( sizeof(a[0])*n ); |
| 344 if( a==0 ){ | 344 if( a==0 ){ |
| 345 Tcl_AppendResult(interp, "SQLITE_NOMEM", (char*)0); | 345 Tcl_AppendResult(interp, "SQLITE_NOMEM", (char*)0); |
| 346 return TCL_ERROR; | 346 return TCL_ERROR; |
| 347 } | 347 } |
| 348 for(i=0; i<n; i++){ | 348 for(i=0; i<n; i++){ |
| 349 a[i] = 0; | 349 Tcl_WideInt x = 0; |
| 350 Tcl_GetWideIntFromObj(0, objv[i+2], &a[i]); | 350 Tcl_GetWideIntFromObj(0, objv[i+2], &x); |
| 351 a[i] = x; |
| 351 } | 352 } |
| 352 rc = sqlite3_intarray_bind(pArray, n, a, sqlite3_free); | 353 rc = sqlite3_intarray_bind(pArray, n, a, sqlite3_free); |
| 353 if( rc!=SQLITE_OK ){ | 354 if( rc!=SQLITE_OK ){ |
| 354 Tcl_AppendResult(interp, sqlite3TestErrorName(rc), (char*)0); | 355 Tcl_AppendResult(interp, sqlite3ErrName(rc), (char*)0); |
| 355 return TCL_ERROR; | 356 return TCL_ERROR; |
| 356 } | 357 } |
| 357 #endif | 358 #endif |
| 358 return TCL_OK; | 359 return TCL_OK; |
| 359 } | 360 } |
| 360 | 361 |
| 361 /* | 362 /* |
| 362 ** Register commands with the TCL interpreter. | 363 ** Register commands with the TCL interpreter. |
| 363 */ | 364 */ |
| 364 int Sqlitetestintarray_Init(Tcl_Interp *interp){ | 365 int Sqlitetestintarray_Init(Tcl_Interp *interp){ |
| 365 static struct { | 366 static struct { |
| 366 char *zName; | 367 char *zName; |
| 367 Tcl_ObjCmdProc *xProc; | 368 Tcl_ObjCmdProc *xProc; |
| 368 void *clientData; | 369 void *clientData; |
| 369 } aObjCmd[] = { | 370 } aObjCmd[] = { |
| 370 { "sqlite3_intarray_create", test_intarray_create, 0 }, | 371 { "sqlite3_intarray_create", test_intarray_create, 0 }, |
| 371 { "sqlite3_intarray_bind", test_intarray_bind, 0 }, | 372 { "sqlite3_intarray_bind", test_intarray_bind, 0 }, |
| 372 }; | 373 }; |
| 373 int i; | 374 int i; |
| 374 for(i=0; i<sizeof(aObjCmd)/sizeof(aObjCmd[0]); i++){ | 375 for(i=0; i<sizeof(aObjCmd)/sizeof(aObjCmd[0]); i++){ |
| 375 Tcl_CreateObjCommand(interp, aObjCmd[i].zName, | 376 Tcl_CreateObjCommand(interp, aObjCmd[i].zName, |
| 376 aObjCmd[i].xProc, aObjCmd[i].clientData, 0); | 377 aObjCmd[i].xProc, aObjCmd[i].clientData, 0); |
| 377 } | 378 } |
| 378 return TCL_OK; | 379 return TCL_OK; |
| 379 } | 380 } |
| 380 | 381 |
| 381 #endif /* SQLITE_TEST */ | 382 #endif /* SQLITE_TEST */ |
| OLD | NEW |