Lines Matching defs:iDb

184   pOld = sqliteHashInsert(&db->aDb[p->iDb].idxHash, p->zName,
187 sqliteHashInsert(&db->aDb[p->iDb].idxHash, pOld->zName,
217 ** If iDb<=0 then reset the internal schema tables for all database
218 ** files. If iDb>=2 then reset the internal schema for only the
221 void sqliteResetInternalSchema(sqlite *db, int iDb){
227 assert( iDb>=0 && iDb<db->nDb );
229 for(i=iDb; i<db->nDb; i++){
248 if( iDb>0 ) return;
250 assert( iDb==0 );
332 assert( pIndex->iDb==pTable->iDb || (pTable->iDb==0 && pIndex->iDb==1) );
341 assert( pTable->iDb<db->nDb );
342 assert( sqliteHashFind(&db->aDb[pTable->iDb].aFKey,
367 int i = p->iDb;
438 int iDb;
443 if( db->init.iDb==1 ) isTemp = 1;
503 iDb = isTemp ? 1 : db->init.iDb;
504 if( pTable!=0 && (pTable->iDb==iDb || !db->init.busy) ){
510 (pIdx->iDb==0 || !db->init.busy) ){
525 pTable->iDb = iDb;
852 strcpy(zStmt, p->iDb==1 ? "CREATE TEMP TABLE " : "CREATE TABLE ");
933 sqliteVdbeOp3(v, OP_CreateTable, 0, p->iDb, (char*)&p->tnum, P3_POINTER);
957 if( !p->iDb ){
962 sqliteVdbeAddOp(v, OP_Integer, p->iDb, 0);
975 pOld = sqliteHashInsert(&db->aDb[p->iDb].tblHash,
983 pFKey->pNextTo = sqliteHashFind(&db->aDb[p->iDb].aFKey, pFKey->zTo, nTo);
984 sqliteHashInsert(&db->aDb[p->iDb].aFKey, pFKey->zTo, nTo, pFKey);
1014 if( sqliteFixInit(&sFix, pParse, p->iDb, "view", pName)
1109 DbSetProperty(pParse->db, pTable->iDb, DB_UnresetViews);
1183 int iDb;
1188 iDb = pTable->iDb;
1189 assert( iDb>=0 && iDb<db->nDb );
1193 const char *zTab = SCHEMA_TABLE(pTable->iDb);
1194 const char *zDb = db->aDb[pTable->iDb].zName;
1199 if( iDb==1 ){
1205 if( iDb==1 ){
1250 sqliteBeginWriteOperation(pParse, 0, pTable->iDb);
1255 assert( pTrigger->iDb==pTable->iDb || pTrigger->iDb==1 );
1265 sqliteOpenMasterTable(v, pTable->iDb);
1270 if( pTable->iDb!=1 ){
1276 if( pTable->iDb==0 ){
1281 sqliteVdbeAddOp(v, OP_Destroy, pTable->tnum, pTable->iDb);
1283 sqliteVdbeAddOp(v, OP_Destroy, pIdx->tnum, pIdx->iDb);
1298 sqliteViewResetAll(db, iDb);
1495 && sqliteFixInit(&sFix, pParse, db->init.iDb, "index", pName)
1517 if( pTab->iDb>=2 && db->init.busy==0 ){
1525 isTemp = pTab->iDb==1;
1570 const char *zDb = db->aDb[pTab->iDb].zName;
1572 assert( pTab->iDb==db->init.iDb || isTemp );
1608 pIndex->iDb = isTemp ? 1 : db->init.iDb;
1632 p = sqliteHashInsert(&db->aDb[pIndex->iDb].idxHash,
1717 sqliteVdbeAddOp(v, OP_Integer, pTab->iDb, 0);
1777 if( pIndex->iDb>1 ){
1786 const char *zDb = db->aDb[pIndex->iDb].zName;
1787 const char *zTab = SCHEMA_TABLE(pIndex->iDb);
1791 if( pIndex->iDb ) code = SQLITE_DROP_TEMP_INDEX;
1814 sqliteBeginWriteOperation(pParse, 0, pIndex->iDb);
1815 sqliteOpenMasterTable(v, pIndex->iDb);
1818 if( pIndex->iDb==0 ){
1822 sqliteVdbeAddOp(v, OP_Destroy, pIndex->tnum, pIndex->iDb);
2089 void sqliteCodeVerifySchema(Parse *pParse, int iDb){
2092 assert( iDb>=0 && iDb<db->nDb );
2093 assert( db->aDb[iDb].pBt!=0 );
2094 if( iDb!=1 && !DbHasProperty(db, iDb, DB_Cookie) ){
2095 sqliteVdbeAddOp(v, OP_VerifyCookie, iDb, db->aDb[iDb].schema_cookie);
2096 DbSetProperty(db, iDb, DB_Cookie);
2113 ** Only database iDb and the temp database are made writable by this call.
2114 ** If iDb==0, then the main and temp databases are made writable. If
2115 ** iDb==1 then only the temp database is made writable. If iDb>1 then the
2118 void sqliteBeginWriteOperation(Parse *pParse, int setCheckpoint, int iDb){
2121 if( DbHasProperty(db, iDb, DB_Locked) ) return;
2124 if( !db->aDb[iDb].inTrans ){
2125 sqliteVdbeAddOp(v, OP_Transaction, iDb, 0);
2126 DbSetProperty(db, iDb, DB_Locked);
2127 sqliteCodeVerifySchema(pParse, iDb);
2128 if( iDb!=1 ){
2132 sqliteVdbeAddOp(v, OP_Checkpoint, iDb, 0);
2133 DbSetProperty(db, iDb, DB_Locked);