contrib/sqlite3/shell.c

13439   ShellState *pState,
13443   assert( pState->expert.pExpert );
13445   return sqlite3_expert_sql(pState->expert.pExpert, zSql, pzErr);
13459   ShellState *pState,
13464   sqlite3expert *p = pState->expert.pExpert;
13468     FILE *out = pState->out;
13469     int bVerbose = pState->expert.bVerbose;
13496   pState->expert.pExpert = 0;
13504   ShellState *pState,             /* Current shell tool state */
13513   assert( pState->expert.pExpert==0 );
13514   memset(&pState->expert, 0, sizeof(ExpertInfo));
13522       pState->expert.bVerbose = 1;
13543     pState->expert.pExpert = sqlite3_expert_new(pState->db, &zErr);
13544     if( pState->expert.pExpert==0 ){
13549           pState->expert.pExpert, EXPERT_CONFIG_SAMPLE, iSample
15883   ShellState *pState,             /* Current shell tool state */
15887   sqlite3 *db = pState->db;       /* Database handle to query "main" db of */
15888   FILE *out = pState->out;        /* Stream to write non-error output to */
16059   ShellState *pState,             /* Current shell tool state */
16066   return lintFkeyIndexes(pState, azArg, nArg);
16755   ShellState *pState,          /* Current shell tool state */
16767     cmd.p = pState;
16768     cmd.db = pState->db;
16772       eDbType = pState->openMode;
16794         utf8_printf(pState->out, "-- open database '%s'%s\n", cmd.zFile,
16836         arUsage(pState->out);
16850   if( cmd.db!=pState->db ){
17114   ShellState *pState,             /* Shell state object */
17128   shellPreparePrintf(pState->db, pRc, &pStmt,
17154   ShellState *pState,             /* Shell state object */
17170     shellPrepare(pState->db, pRc,
17201         raw_printf(pState->out,
17206           raw_printf(pState->out, ", c%d", i);
17208         raw_printf(pState->out, ");\n");
17219 ** on stream pState->out.
17221 static int recoverDatabaseCmd(ShellState *pState, int nArg, char **azArg){
17255       showHelp(pState->out, azArg[0]);
17260   shellExecPrintf(pState->db, &rc,
17273     shellExec(pState->db, &rc,
17297   shellExec(pState->db, &rc,
17309   shellExec(pState->db, &rc,
17386     raw_printf(pState->out, "PRAGMA foreign_keys=OFF;\n");
17387     raw_printf(pState->out, "BEGIN;\n");
17388     raw_printf(pState->out, "PRAGMA writable_schema = on;\n");
17389     shellPrepare(pState->db, &rc,
17395       raw_printf(pState->out, "CREATE TABLE IF NOT EXISTS %s;\n",
17404   shellPrepare(pState->db, &rc,
17414   shellPrepare(pState->db, &rc,
17418   shellPrepare(pState->db, &rc,
17428   shellPrepare(pState->db, &rc,
17442     pTab = recoverFindTable(pState, &rc, iRoot, bIntkey, nCol, &bNoop);
17446         pOrphan = recoverOrphanTable(pState, &rc, zLostAndFound, nOrphan);
17453       raw_printf(pState->out, "DELETE FROM sqlite_sequence;\n");
17474             pOrphan = recoverOrphanTable(pState, &rc, zLostAndFound, nOrphan);
17482           raw_printf(pState->out,
17488           raw_printf(pState->out, "INSERT INTO %s(%s) VALUES( %s );\n",
17506     shellPrepare(pState->db, &rc,
17518         raw_printf(pState->out, "%s;\n", zPrint);
17521         raw_printf(pState->out, "%s;\n", zSql);
17528     raw_printf(pState->out, "PRAGMA writable_schema = off;\n");
17529     raw_printf(pState->out, "COMMIT;\n");
17531   sqlite3_exec(pState->db, "DETACH recovery", 0, 0, 0);