Lines Matching refs:i
39 int i; in sqliteBeginParse() local
48 for(i=0; i<db->nDb; i++){ in sqliteBeginParse()
49 DbClearProperty(db, i, DB_Locked); in sqliteBeginParse()
50 if( !db->aDb[i].inTrans ){ in sqliteBeginParse()
51 DbClearProperty(db, i, DB_Cookie); in sqliteBeginParse()
107 int i; in sqliteFindTable() local
108 for(i=0; i<db->nDb; i++){ in sqliteFindTable()
109 int j = (i<2) ? i^1 : i; /* Search TEMP before MAIN */ in sqliteFindTable()
159 int i; in sqliteFindIndex() local
160 for(i=0; i<db->nDb; i++){ in sqliteFindIndex()
161 int j = (i<2) ? i^1 : i; /* Search TEMP before MAIN */ in sqliteFindIndex()
222 int i, j; in sqliteResetInternalSchema() local
226 for(i=iDb; i<db->nDb; i++){ in sqliteResetInternalSchema()
227 Db *pDb = &db->aDb[i]; in sqliteResetInternalSchema()
244 DbClearProperty(db, i, DB_SchemaLoaded); in sqliteResetInternalSchema()
256 for(i=0; i<db->nDb; i++){ in sqliteResetInternalSchema()
257 struct Db *pDb = &db->aDb[i]; in sqliteResetInternalSchema()
263 for(i=j=2; i<db->nDb; i++){ in sqliteResetInternalSchema()
264 struct Db *pDb = &db->aDb[i]; in sqliteResetInternalSchema()
270 if( j<i ){ in sqliteResetInternalSchema()
271 db->aDb[j] = db->aDb[i]; in sqliteResetInternalSchema()
319 int i; in sqliteDeleteTable() local
346 for(i=0; i<pTable->nCol; i++){ in sqliteDeleteTable()
347 sqliteFree(pTable->aCol[i].zName); in sqliteDeleteTable()
348 sqliteFree(pTable->aCol[i].zDflt); in sqliteDeleteTable()
349 sqliteFree(pTable->aCol[i].zType); in sqliteDeleteTable()
364 int i = p->iDb; in sqliteUnlinkAndDeleteTable() local
366 pOld = sqliteHashInsert(&db->aDb[i].tblHash, p->zName, strlen(p->zName)+1, 0); in sqliteUnlinkAndDeleteTable()
370 pF2 = sqliteHashFind(&db->aDb[i].aFKey, pF1->zTo, nTo); in sqliteUnlinkAndDeleteTable()
372 sqliteHashInsert(&db->aDb[i].aFKey, pF1->zTo, nTo, pF1->pNextTo); in sqliteUnlinkAndDeleteTable()
558 int i; in sqliteAddColumn() local
565 for(i=0; i<p->nCol; i++){ in sqliteAddColumn()
566 if( sqliteStrICmp(z, p->aCol[i].zName)==0 ){ in sqliteAddColumn()
593 int i; in sqliteAddNotNull() local
595 i = p->nCol-1; in sqliteAddNotNull()
596 if( i>=0 ) p->aCol[i].notNull = onError; in sqliteAddNotNull()
610 int i, j; in sqliteAddColumnType() local
615 i = p->nCol-1; in sqliteAddColumnType()
616 if( i<0 ) return; in sqliteAddColumnType()
617 pCol = &p->aCol[i]; in sqliteAddColumnType()
623 for(i=j=0; z[i]; i++){ in sqliteAddColumnType()
624 int c = z[i]; in sqliteAddColumnType()
646 int i; in sqliteAddDefaultValue() local
649 i = p->nCol-1; in sqliteAddDefaultValue()
650 if( i<0 ) return; in sqliteAddDefaultValue()
651 pz = &p->aCol[i].zDflt; in sqliteAddDefaultValue()
683 int iCol = -1, i; in sqliteAddPrimaryKey() local
695 for(i=0; i<pList->nId; i++){ in sqliteAddPrimaryKey()
697 if( sqliteStrICmp(pList->a[i].zName, pTab->aCol[iCol].zName)==0 ) break; in sqliteAddPrimaryKey()
729 int i; in sqliteCollateType() local
730 for(i=0; i<nType-3; i++){ in sqliteCollateType()
753 int i; in sqliteAddCollateType() local
755 i = p->nCol-1; in sqliteAddCollateType()
756 if( i>=0 ) p->aCol[i].sortOrder = collType; in sqliteAddCollateType()
806 int i, j, needQuote; in identPut() local
807 i = *pIdx; in identPut()
813 if( needQuote ) z[i++] = '\''; in identPut()
815 z[i++] = zIdent[j]; in identPut()
816 if( zIdent[j]=='\'' ) z[i++] = '\''; in identPut()
818 if( needQuote ) z[i++] = '\''; in identPut()
819 z[i] = 0; in identPut()
820 *pIdx = i; in identPut()
829 int i, k, n; in createTableStmt() local
833 for(i=0; i<p->nCol; i++){ in createTableStmt()
834 n += identLength(p->aCol[i].zName); in createTableStmt()
853 for(i=0; i<p->nCol; i++){ in createTableStmt()
857 identPut(zStmt, &k, p->aCol[i].zName); in createTableStmt()
1126 int i; in sqliteViewResetColumnNames() local
1129 for(i=0, pCol=pTable->aCol; i<pTable->nCol; i++, pCol++){ in sqliteViewResetColumnNames()
1143 HashElem *i; in sqliteViewResetAll() local
1145 for(i=sqliteHashFirst(&db->aDb[idx].tblHash); i; i=sqliteHashNext(i)){ in sqliteViewResetAll()
1146 Table *pTab = sqliteHashData(i); in sqliteViewResetAll()
1311 int i, n; in sqliteAddIdxKeyType() local
1317 for(i=0; i<n; i++){ in sqliteAddIdxKeyType()
1318 int iCol = pIdx->aiColumn[i]; in sqliteAddIdxKeyType()
1321 zType[i] = 't'; in sqliteAddIdxKeyType()
1323 zType[i] = 'n'; in sqliteAddIdxKeyType()
1358 int i; in sqliteCreateForeignKey() local
1385 for(i=0; i<pToCol->nId; i++){ in sqliteCreateForeignKey()
1386 nByte += strlen(pToCol->a[i].zName) + 1; in sqliteCreateForeignKey()
1405 for(i=0; i<nCol; i++){ in sqliteCreateForeignKey()
1408 if( sqliteStrICmp(p->aCol[j].zName, pFromCol->a[i].zName)==0 ){ in sqliteCreateForeignKey()
1409 pFKey->aCol[i].iFrom = j; in sqliteCreateForeignKey()
1416 pFromCol->a[i].zName); in sqliteCreateForeignKey()
1422 for(i=0; i<nCol; i++){ in sqliteCreateForeignKey()
1423 int n = strlen(pToCol->a[i].zName); in sqliteCreateForeignKey()
1424 pFKey->aCol[i].zCol = z; in sqliteCreateForeignKey()
1425 memcpy(z, pToCol->a[i].zName, n); in sqliteCreateForeignKey()
1484 int i, j; in sqliteCreateIndex() local
1573 i = SQLITE_CREATE_INDEX; in sqliteCreateIndex()
1574 if( isTemp ) i = SQLITE_CREATE_TEMP_INDEX; in sqliteCreateIndex()
1575 if( sqliteAuthCheck(pParse, i, zName, pTab->zName, zDb) ){ in sqliteCreateIndex()
1611 for(i=0; i<pList->nId; i++){ in sqliteCreateIndex()
1613 if( sqliteStrICmp(pList->a[i].zName, pTab->aCol[j].zName)==0 ) break; in sqliteCreateIndex()
1617 pTab->zName, pList->a[i].zName); in sqliteCreateIndex()
1621 pIndex->aiColumn[i] = j; in sqliteCreateIndex()
1684 int i; in sqliteCreateIndex() local
1719 for(i=0; i<pIndex->nColumn; i++){ in sqliteCreateIndex()
1720 int iCol = pIndex->aiColumn[i]; in sqliteCreateIndex()
1722 sqliteVdbeAddOp(v, OP_Dup, i, 0); in sqliteCreateIndex()
1951 int i; in sqliteSrcListAssignCursors() local
1952 for(i=0; i<pList->nSrc; i++){ in sqliteSrcListAssignCursors()
1953 if( pList->a[i].iCursor<0 ){ in sqliteSrcListAssignCursors()
1954 pList->a[i].iCursor = pParse->nTab++; in sqliteSrcListAssignCursors()
1964 int i = pList->nSrc - 1; in sqliteSrcListAddAlias() local
1965 sqliteSetNString(&pList->a[i].zAlias, pToken->z, pToken->n, 0); in sqliteSrcListAddAlias()
1966 sqliteDequote(pList->a[i].zAlias); in sqliteSrcListAddAlias()
1974 int i; in sqliteIdListDelete() local
1976 for(i=0; i<pList->nId; i++){ in sqliteIdListDelete()
1977 sqliteFree(pList->a[i].zName); in sqliteIdListDelete()
1988 int i; in sqliteIdListIndex() local
1990 for(i=0; i<pList->nId; i++){ in sqliteIdListIndex()
1991 if( sqliteStrICmp(pList->a[i].zName, zName)==0 ) return i; in sqliteIdListIndex()
2000 int i; in sqliteSrcListDelete() local
2002 for(i=0; i<pList->nSrc; i++){ in sqliteSrcListDelete()
2003 sqliteFree(pList->a[i].zDatabase); in sqliteSrcListDelete()
2004 sqliteFree(pList->a[i].zName); in sqliteSrcListDelete()
2005 sqliteFree(pList->a[i].zAlias); in sqliteSrcListDelete()
2006 if( pList->a[i].pTab && pList->a[i].pTab->isTransient ){ in sqliteSrcListDelete()
2007 sqliteDeleteTable(0, pList->a[i].pTab); in sqliteSrcListDelete()
2009 sqliteSelectDelete(pList->a[i].pSelect); in sqliteSrcListDelete()
2010 sqliteExprDelete(pList->a[i].pOn); in sqliteSrcListDelete()
2011 sqliteIdListDelete(pList->a[i].pUsing); in sqliteSrcListDelete()
