Lines Matching defs:iDb
42 int iDb; /* The database containing the table to be locked */
51 ** The table to be locked has root page iTab and is found in database iDb.
60 int iDb, /* Index of the database containing the table to lock */
69 assert( iDb>=0 );
73 if( p->iDb==iDb && p->iTab==iTab ){
84 p->iDb = iDb;
107 int p1 = p->iDb;
152 int iDb;
154 for(iDb=0, mask=1; iDb<db->nDb; mask<<=1, iDb++){
156 sqlite3VdbeUsesBtree(v, iDb);
157 sqlite3VdbeAddOp2(v,OP_Transaction, iDb, (mask & pParse->writeMask)!=0);
159 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
161 iDb, pParse->cookieValue[iDb],
162 db->aDb[iDb].pSchema->iGeneration);
366 ** For the index called zIdxName which is found in the database iDb,
371 void sqlite3UnlinkAndDeleteIndex(sqlite3 *db, int iDb, const char *zIdxName){
376 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
377 pHash = &db->aDb[iDb].pSchema->idxHash;
405 ** If iDb<0 then reset the internal schema tables for all database
406 ** files. If iDb>=0 then reset the internal schema for only the
409 void sqlite3ResetInternalSchema(sqlite3 *db, int iDb){
411 assert( iDb<db->nDb );
413 if( iDb>=0 ){
414 /* Case 1: Reset the single schema identified by iDb */
415 Db *pDb = &db->aDb[iDb];
416 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
424 if( iDb!=1 ){
433 assert( iDb<0 );
554 void sqlite3UnlinkAndDeleteTable(sqlite3 *db, int iDb, const char *zTabName){
559 assert( iDb>=0 && iDb<db->nDb );
561 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
563 pDb = &db->aDb[iDb];
595 ** Open the sqlite_master table stored in database number iDb for
598 void sqlite3OpenMasterTable(Parse *p, int iDb){
600 sqlite3TableLock(p, iDb, MASTER_ROOT, 1, SCHEMA_TABLE(iDb));
601 sqlite3VdbeAddOp3(v, OP_OpenWrite, 0, MASTER_ROOT, iDb);
666 int iDb; /* Database holding the object */
676 iDb = sqlite3FindDb(db, pName1);
677 if( iDb<0 ){
683 assert( db->init.iDb==0 || db->init.busy );
684 iDb = db->init.iDb;
687 return iDb;
736 int iDb; /* Database number to create the table in */
752 ** pName2) that stores the unqualified table name. The variable iDb is
756 iDb = sqlite3TwoPartName(pParse, pName1, pName2, &pName);
757 if( iDb<0 ) return;
758 if( !OMIT_TEMPDB && isTemp && pName2->n>0 && iDb!=1 ){
764 if( !OMIT_TEMPDB && isTemp ) iDb = 1;
772 if( db->init.iDb==1 ) isTemp = 1;
777 char *zDb = db->aDb[iDb].zName;
808 char *zDb = db->aDb[iDb].zName;
818 sqlite3CodeVerifySchema(pParse, iDb);
837 pTable->pSchema = db->aDb[iDb].pSchema;
849 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
866 sqlite3BeginWriteOperation(pParse, 0, iDb);
880 sqlite3VdbeAddOp3(v, OP_ReadCookie, iDb, reg3, BTREE_FILE_FORMAT);
881 sqlite3VdbeUsesBtree(v, iDb);
886 sqlite3VdbeAddOp3(v, OP_SetCookie, iDb, BTREE_FILE_FORMAT, reg3);
888 sqlite3VdbeAddOp3(v, OP_SetCookie, iDb, BTREE_TEXT_ENCODING, reg3);
906 sqlite3VdbeAddOp2(v, OP_CreateTable, iDb, reg2);
908 sqlite3OpenMasterTable(pParse, iDb);
1306 void sqlite3ChangeCookie(Parse *pParse, int iDb){
1310 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
1311 sqlite3VdbeAddOp2(v, OP_Integer, db->aDb[iDb].pSchema->schema_cookie+1, r1);
1312 sqlite3VdbeAddOp3(v, OP_SetCookie, iDb, BTREE_SCHEMA_VERSION, r1);
1465 int iDb;
1475 iDb = sqlite3SchemaToIndex(db, p->pSchema);
1560 sqlite3VdbeAddOp3(v, OP_OpenWrite, 1, pParse->regRoot, iDb);
1596 db->aDb[iDb].zName, SCHEMA_TABLE(iDb),
1605 sqlite3ChangeCookie(pParse, iDb);
1612 Db *pDb = &db->aDb[iDb];
1613 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
1624 sqlite3VdbeAddOp4(v, OP_ParseSchema, iDb, 0, 0,
1634 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
1680 int iDb;
1695 iDb = sqlite3SchemaToIndex(db, p->pSchema);
1696 if( sqlite3FixInit(&sFix, pParse, iDb, "view", pName)
1859 ** root-page of a table or index in database iDb has changed from iFrom
1874 void sqlite3RootPageMoved(sqlite3 *db, int iDb, int iFrom, int iTo){
1879 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
1880 pDb = &db->aDb[iDb];
1899 ** Write code to erase the table with root-page iTable from database iDb.
1904 static void destroyRootPage(Parse *pParse, int iTable, int iDb){
1907 sqlite3VdbeAddOp3(v, OP_Destroy, iTable, r1, iDb);
1921 pParse->db->aDb[iDb].zName, SCHEMA_TABLE(iDb), iTable, r1, r1);
1935 int iDb = sqlite3SchemaToIndex(pParse->db, pTab->pSchema);
1936 destroyRootPage(pParse, pTab->tnum, iDb);
1938 destroyRootPage(pParse, pIdx->tnum, iDb);
1977 int iDb = sqlite3SchemaToIndex(pParse->db, pTab->pSchema);
1978 destroyRootPage(pParse, iLargest, iDb);
1993 int iDb;
2009 iDb = sqlite3SchemaToIndex(db, pTab->pSchema);
2010 assert( iDb>=0 && iDb<db->nDb );
2021 const char *zTab = SCHEMA_TABLE(iDb);
2022 const char *zDb = db->aDb[iDb].zName;
2028 if( !OMIT_TEMPDB && iDb==1 ){
2039 if( !OMIT_TEMPDB && iDb==1 ){
2078 Db *pDb = &db->aDb[iDb];
2079 sqlite3BeginWriteOperation(pParse, 1, iDb);
2123 pDb->zName, SCHEMA_TABLE(iDb), pTab->zName);
2126 if( sqlite3FindTable(db, "sqlite_stat1", db->aDb[iDb].zName) ){
2140 sqlite3VdbeAddOp4(v, OP_VDestroy, iDb, 0, 0, pTab->zName, 0);
2142 sqlite3VdbeAddOp4(v, OP_DropTable, iDb, 0, 0, pTab->zName, 0);
2143 sqlite3ChangeCookie(pParse, iDb);
2145 sqliteViewResetAll(db, iDb);
2320 int iDb = sqlite3SchemaToIndex(db, pIndex->pSchema);
2324 db->aDb[iDb].zName ) ){
2330 sqlite3TableLock(pParse, iDb, pTab->tnum, 1, pTab->zName);
2338 sqlite3VdbeAddOp2(v, OP_Clear, tnum, iDb);
2341 sqlite3VdbeAddOp4(v, OP_OpenWrite, iIdx, tnum, iDb,
2346 sqlite3OpenTable(pParse, iTab, iDb, pTab, OP_OpenRead);
2416 int iDb; /* Index of the database that is being written */
2442 iDb = sqlite3TwoPartName(pParse, pName1, pName2, &pName);
2443 if( iDb<0 ) goto exit_create_index;
2453 iDb = 1;
2458 if( sqlite3FixInit(&sFix, pParse, iDb, "index", pName) &&
2468 assert( db->aDb[iDb].pSchema==pTab->pSchema );
2473 iDb = sqlite3SchemaToIndex(db, pTab->pSchema);
2475 pDb = &db->aDb[iDb];
2527 sqlite3CodeVerifySchema(pParse, iDb);
2546 if( sqlite3AuthCheck(pParse, SQLITE_INSERT, SCHEMA_TABLE(iDb), 0, zDb) ){
2550 if( !OMIT_TEMPDB && iDb==1 ) i = SQLITE_CREATE_TEMP_INDEX;
2613 pIndex->pSchema = db->aDb[iDb].pSchema;
2614 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
2785 sqlite3BeginWriteOperation(pParse, 1, iDb);
2786 sqlite3VdbeAddOp2(v, OP_CreateIndex, iDb, iMem);
2808 db->aDb[iDb].zName, SCHEMA_TABLE(iDb),
2821 sqlite3ChangeCookie(pParse, iDb);
2822 sqlite3VdbeAddOp4(v, OP_ParseSchema, iDb, 0, 0,
2907 int iDb;
2932 iDb = sqlite3SchemaToIndex(db, pIndex->pSchema);
2937 const char *zDb = db->aDb[iDb].zName;
2938 const char *zTab = SCHEMA_TABLE(iDb);
2942 if( !OMIT_TEMPDB && iDb ) code = SQLITE_DROP_TEMP_INDEX;
2952 sqlite3BeginWriteOperation(pParse, 1, iDb);
2955 db->aDb[iDb].zName, SCHEMA_TABLE(iDb),
2958 if( sqlite3FindTable(db, "sqlite_stat1", db->aDb[iDb].zName) ){
2961 db->aDb[iDb].zName, pIndex->zName
2964 sqlite3ChangeCookie(pParse, iDb);
2965 destroyRootPage(pParse, pIndex->tnum, iDb);
2966 sqlite3VdbeAddOp4(v, OP_DropIndex, iDb, 0, 0, pIndex->zName, 0);
3481 ** If iDb<0 then code the OP_Goto only - don't set flag to verify the
3485 void sqlite3CodeVerifySchema(Parse *pParse, int iDb){
3493 if( iDb>=0 ){
3497 assert( iDb<db->nDb );
3498 assert( db->aDb[iDb].pBt!=0 || iDb==1 );
3499 assert( iDb<SQLITE_MAX_ATTACHED+2 );
3500 assert( sqlite3SchemaMutexHeld(db, iDb, 0) );
3501 mask = ((yDbMask)1)<<iDb;
3504 pToplevel->cookieValue[iDb] = db->aDb[iDb].pSchema->schema_cookie;
3505 if( !OMIT_TEMPDB && iDb==1 ){
3540 void sqlite3BeginWriteOperation(Parse *pParse, int setStatement, int iDb){
3542 sqlite3CodeVerifySchema(pParse, iDb);
3543 pToplevel->writeMask |= ((yDbMask)1)<<iDb;
3622 int iDb = sqlite3SchemaToIndex(pParse->db, pTab->pSchema);
3623 sqlite3BeginWriteOperation(pParse, 0, iDb);
3638 int iDb; /* The database index number */
3644 for(iDb=0, pDb=db->aDb; iDb<db->nDb; iDb++, pDb++){
3674 int iDb; /* The database index number */
3700 iDb = sqlite3TwoPartName(pParse, pName1, pName2, &pObjName);
3701 if( iDb<0 ) return;
3704 zDb = db->aDb[iDb].zName;
3714 sqlite3BeginWriteOperation(pParse, 0, iDb);