Lines Matching refs:db
32 static int execSql(sqlite3 *db, char **pzErrMsg, const char *zSql){ in execSql() argument
37 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in execSql()
50 rc = execSql(db, pzErrMsg, zSubSql); in execSql()
57 sqlite3SetString(pzErrMsg, db, sqlite3_errmsg(db)); in execSql()
62 static int execSqlF(sqlite3 *db, char **pzErrMsg, const char *zSql, ...){ in execSqlF() argument
67 z = sqlite3VMPrintf(db, zSql, ap); in execSqlF()
70 rc = execSql(db, pzErrMsg, z); in execSqlF()
71 sqlite3DbFree(db, z); in execSqlF()
122 iDb = sqlite3FindDb(pParse->db, pNm); in sqlite3Vacuum()
136 sqlite3ExprDelete(pParse->db, pInto); in sqlite3Vacuum()
145 sqlite3 *db, /* Database connection */ in sqlite3RunVacuum() argument
166 if( !db->autoCommit ){ in sqlite3RunVacuum()
167 sqlite3SetString(pzErrMsg, db, "cannot VACUUM from within a transaction"); in sqlite3RunVacuum()
170 if( db->nVdbeActive>1 ){ in sqlite3RunVacuum()
171 sqlite3SetString(pzErrMsg, db,"cannot VACUUM - SQL statements in progress"); in sqlite3RunVacuum()
174 saved_openFlags = db->openFlags; in sqlite3RunVacuum()
177 sqlite3SetString(pzErrMsg, db, "non-text filename"); in sqlite3RunVacuum()
181 db->openFlags &= ~SQLITE_OPEN_READONLY; in sqlite3RunVacuum()
182 db->openFlags |= SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE; in sqlite3RunVacuum()
190 saved_flags = db->flags; in sqlite3RunVacuum()
191 saved_mDbFlags = db->mDbFlags; in sqlite3RunVacuum()
192 saved_nChange = db->nChange; in sqlite3RunVacuum()
193 saved_nTotalChange = db->nTotalChange; in sqlite3RunVacuum()
194 saved_mTrace = db->mTrace; in sqlite3RunVacuum()
195 db->flags |= SQLITE_WriteSchema | SQLITE_IgnoreChecks; in sqlite3RunVacuum()
196 db->mDbFlags |= DBFLAG_PreferBuiltin | DBFLAG_Vacuum; in sqlite3RunVacuum()
197 db->flags &= ~(u64)(SQLITE_ForeignKeys | SQLITE_ReverseOrder in sqlite3RunVacuum()
199 db->mTrace = 0; in sqlite3RunVacuum()
201 zDbMain = db->aDb[iDb].zDbSName; in sqlite3RunVacuum()
202 pMain = db->aDb[iDb].pBt; in sqlite3RunVacuum()
219 nDb = db->nDb; in sqlite3RunVacuum()
220 rc = execSqlF(db, pzErrMsg, "ATTACH %Q AS vacuum_db", zOut); in sqlite3RunVacuum()
221 db->openFlags = saved_openFlags; in sqlite3RunVacuum()
223 assert( (db->nDb-1)==nDb ); in sqlite3RunVacuum()
224 pDb = &db->aDb[nDb]; in sqlite3RunVacuum()
232 sqlite3SetString(pzErrMsg, db, "output file already exists"); in sqlite3RunVacuum()
235 db->mDbFlags |= DBFLAG_VacuumInto; in sqlite3RunVacuum()
240 pgflags = db->aDb[iDb].safety_level | (db->flags & PAGER_FLAGS_MASK); in sqlite3RunVacuum()
244 sqlite3BtreeSetCacheSize(pTemp, db->aDb[iDb].pSchema->cache_size); in sqlite3RunVacuum()
252 rc = execSql(db, pzErrMsg, "BEGIN"); in sqlite3RunVacuum()
262 db->nextPagesize = 0; in sqlite3RunVacuum()
266 || (!isMemDb && sqlite3BtreeSetPageSize(pTemp, db->nextPagesize, nRes, 0)) in sqlite3RunVacuum()
267 || NEVER(db->mallocFailed) in sqlite3RunVacuum()
274 sqlite3BtreeSetAutoVacuum(pTemp, db->nextAutovac>=0 ? db->nextAutovac : in sqlite3RunVacuum()
281 db->init.iDb = nDb; /* force new CREATE statements into vacuum_db */ in sqlite3RunVacuum()
282 rc = execSqlF(db, pzErrMsg, in sqlite3RunVacuum()
289 rc = execSqlF(db, pzErrMsg, in sqlite3RunVacuum()
295 db->init.iDb = 0; in sqlite3RunVacuum()
301 rc = execSqlF(db, pzErrMsg, in sqlite3RunVacuum()
308 assert( (db->mDbFlags & DBFLAG_Vacuum)!=0 ); in sqlite3RunVacuum()
309 db->mDbFlags &= ~DBFLAG_Vacuum; in sqlite3RunVacuum()
317 rc = execSqlF(db, pzErrMsg, in sqlite3RunVacuum()
383 db->init.iDb = 0; in sqlite3RunVacuum()
384 db->mDbFlags = saved_mDbFlags; in sqlite3RunVacuum()
385 db->flags = saved_flags; in sqlite3RunVacuum()
386 db->nChange = saved_nChange; in sqlite3RunVacuum()
387 db->nTotalChange = saved_nTotalChange; in sqlite3RunVacuum()
388 db->mTrace = saved_mTrace; in sqlite3RunVacuum()
398 db->autoCommit = 1; in sqlite3RunVacuum()
408 sqlite3ResetAllSchemasOfConnection(db); in sqlite3RunVacuum()