Lines Matching refs:db
86 ** Interpret the given string as a temp db location. Return 1 for file
109 sqlite3 *db = pParse->db;
110 if( db->aDb[1].pBt!=0 ){
111 if( !db->autoCommit || sqlite3BtreeIsInReadTrans(db->aDb[1].pBt) ){
116 sqlite3BtreeClose(db->aDb[1].pBt);
117 db->aDb[1].pBt = 0;
118 sqlite3ResetInternalSchema(db, -1);
132 sqlite3 *db = pParse->db;
133 if( db->temp_store==ts ) return SQLITE_OK;
137 db->temp_store = (u8)ts;
148 i64 *pI64 = sqlite3DbMallocRaw(pParse->db, sizeof(value));
161 ** or changes one of the flags in db->flags. Return 1 if so and 0 if not.
167 int mask; /* Mask for the db->flags value */
207 sqlite3 *db = pParse->db;
213 returnSingleInt(pParse, p->zName, (db->flags & p->mask)!=0 );
216 if( db->autoCommit==0 ){
223 db->flags |= mask;
225 db->flags &= ~mask;
313 sqlite3 *db = pParse->db;
315 Vdbe *v = pParse->pVdbe = sqlite3VdbeCreate(db);
321 ** index of the database this pragma is being applied to in db.aDb[]. */
324 pDb = &db->aDb[iDb];
333 zLeft = sqlite3NameFromToken(db, pId);
336 zRight = sqlite3MPrintf(db, "-%T", pValue);
338 zRight = sqlite3NameFromToken(db, pValue);
391 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
416 db->nextPagesize = sqlite3Atoi(zRight);
417 if( SQLITE_NOMEM==sqlite3BtreeSetPageSize(pBt, db->nextPagesize, -1, 0) ){
418 db->mallocFailed = 1;
440 for(ii=0; ii<db->nDb; ii++){
441 sqlite3BtreeSecureDelete(db->aDb[ii].pBt, b);
491 eMode = db->dfltLockMode;
497 ** set on all attached databases, as well as the main db file.
504 assert(pDb==&db->aDb[0]);
505 for(ii=2; ii<db->nDb; ii++){
506 pPager = sqlite3BtreePager(db->aDb[ii].pBt);
509 db->dfltLockMode = (u8)eMode;
564 for(ii=db->nDb-1; ii>=0; ii--){
565 if( db->aDb[ii].pBt && (ii==iDb || pId2->n==0) ){
617 db->nextAutovac = (u8)eAuto;
622 ** as an auto-vacuum capable db.
694 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
717 returnSingleInt(pParse, "temp_store", db->temp_store);
747 rc = sqlite3OsAccess(db->pVfs, zRight, SQLITE_ACCESS_READWRITE, &res);
754 || (SQLITE_TEMP_STORE==1 && db->temp_store<=1)
755 || (SQLITE_TEMP_STORE==2 && db->temp_store==1)
833 if( !db->autoCommit ){
866 pTab = sqlite3FindTable(db, zRight, zDb);
905 pIdx = sqlite3FindIndex(db, zRight, zDb);
929 pTab = sqlite3FindTable(db, zRight, zDb);
960 for(i=0; i<db->nDb; i++){
961 if( db->aDb[i].pBt==0 ) continue;
962 assert( db->aDb[i].zName!=0 );
964 sqlite3VdbeAddOp4(v, OP_String8, 0, 2, 0, db->aDb[i].zName, 0);
966 sqlite3BtreeGetFilename(db->aDb[i].pBt), 0);
978 for(p=sqliteHashFirst(&db->aCollSeq); p; p=sqliteHashNext(p)){
992 pTab = sqlite3FindTable(db, zRight, zDb);
1050 sqlite3RegisterLikeFunctions(db, getBoolean(zRight));
1098 for(i=0; i<db->nDb; i++){
1115 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
1116 pTbls = &db->aDb[i].pSchema->tblHash;
1138 sqlite3MPrintf(db, "*** in database %s ***\n", db->aDb[i].zName),
1269 sqlite3VdbeChangeP4(v, -1, encnames[ENC(pParse->db)].zName, P4_STATIC);
1278 !(DbHasProperty(db, 0, DB_SchemaLoaded)) ||
1279 DbHasProperty(db, 0, DB_Empty)
1283 ENC(pParse->db) = pEnc->enc ? pEnc->enc : SQLITE_UTF16NATIVE;
1425 sqlite3_wal_autocheckpoint(db, sqlite3Atoi(zRight));
1428 db->xWalCallback==sqlite3WalDefaultHook ?
1429 SQLITE_PTR_TO_INT(db->pWalArg) : 0);
1446 for(i=0; i<db->nDb; i++){
1451 if( db->aDb[i].zName==0 ) continue;
1452 sqlite3VdbeAddOp4(v, OP_String8, 0, 1, 0, db->aDb[i].zName, P4_STATIC);
1453 pBt = db->aDb[i].pBt;
1456 }else if( sqlite3_file_control(db, i ? db->aDb[i].zName : 0,
1469 sqlite3_key(db, zRight, sqlite3Strlen30(zRight));
1472 sqlite3_rekey(db, zRight, sqlite3Strlen30(zRight));
1484 sqlite3_key(db, zKey, i/2);
1486 sqlite3_rekey(db, zKey, i/2);
1513 if( db->autoCommit ){
1515 (db->flags&SQLITE_FullFSync)!=0,
1516 (db->flags&SQLITE_CkptFullFSync)!=0);
1520 sqlite3DbFree(db, zLeft);
1521 sqlite3DbFree(db, zRight);