11632   ShellState *pState,   in expertHandleSQL()  argument
11636   assert( pState->expert.pExpert );  in expertHandleSQL()
11638   return sqlite3_expert_sql(pState->expert.pExpert, zSql, pzErr);  in expertHandleSQL()
11652   ShellState *pState,  in expertFinish()  argument
11657   sqlite3expert *p = pState->expert.pExpert;  in expertFinish()
11661     FILE *out = pState->out;  in expertFinish()
11662     int bVerbose = pState->expert.bVerbose;  in expertFinish()
11689   pState->expert.pExpert = 0;  in expertFinish()
11697   ShellState *pState,             /* Current shell tool state */  in expertDotCommand()  argument
11706   assert( pState->expert.pExpert==0 );  in expertDotCommand()
11707   memset(&pState->expert, 0, sizeof(ExpertInfo));  in expertDotCommand()
11715       pState->expert.bVerbose = 1;  in expertDotCommand()
11736     pState->expert.pExpert = sqlite3_expert_new(pState->db, &zErr);  in expertDotCommand()
11737     if( pState->expert.pExpert==0 ){  in expertDotCommand()
11742           pState->expert.pExpert, EXPERT_CONFIG_SAMPLE, iSample  in expertDotCommand()
14029   ShellState *pState,             /* Current shell tool state */  in lintFkeyIndexes()  argument
14033   sqlite3 *db = pState->db;       /* Database handle to query "main" db of */  in lintFkeyIndexes()
14034   FILE *out = pState->out;        /* Stream to write non-error output to */  in lintFkeyIndexes()
14205   ShellState *pState,             /* Current shell tool state */  in lintDotCommand()  argument
14212   return lintFkeyIndexes(pState, azArg, nArg);  in lintDotCommand()
14901   ShellState *pState,          /* Current shell tool state */  in arDotCommand()  argument
14913     cmd.p = pState;  in arDotCommand()
14914     cmd.db = pState->db;  in arDotCommand()
14918       eDbType = pState->openMode;  in arDotCommand()
14940         utf8_printf(pState->out, "-- open database '%s'%s\n", cmd.zFile,  in arDotCommand()
14982         arUsage(pState->out);  in arDotCommand()
14996   if( cmd.db!=pState->db ){  in arDotCommand()
15260   ShellState *pState,             /* Shell state object */  in recoverFindTable()  argument
15274   shellPreparePrintf(pState->db, pRc, &pStmt,  in recoverFindTable()
15300   ShellState *pState,             /* Shell state object */  in recoverOrphanTable()  argument
15316     shellPrepare(pState->db, pRc,  in recoverOrphanTable()
15347         raw_printf(pState->out,   in recoverOrphanTable()
15352           raw_printf(pState->out, ", c%d", i);  in recoverOrphanTable()
15354         raw_printf(pState->out, ");\n");  in recoverOrphanTable()
15367 static int recoverDatabaseCmd(ShellState *pState, int nArg, char **azArg){  in recoverDatabaseCmd()  argument
15401       showHelp(pState->out, azArg[0]);  in recoverDatabaseCmd()
15406   shellExecPrintf(pState->db, &rc,  in recoverDatabaseCmd()
15419     shellExec(pState->db, &rc,  in recoverDatabaseCmd()
15443   shellExec(pState->db, &rc,   in recoverDatabaseCmd()
15455   shellExec(pState->db, &rc,   in recoverDatabaseCmd()
15532     raw_printf(pState->out, "PRAGMA foreign_keys=OFF;\n");  in recoverDatabaseCmd()
15533     raw_printf(pState->out, "BEGIN;\n");  in recoverDatabaseCmd()
15534     raw_printf(pState->out, "PRAGMA writable_schema = on;\n");  in recoverDatabaseCmd()
15535     shellPrepare(pState->db, &rc,  in recoverDatabaseCmd()
15541       raw_printf(pState->out, "CREATE TABLE IF NOT EXISTS %s;\n",   in recoverDatabaseCmd()
15550   shellPrepare(pState->db, &rc,   in recoverDatabaseCmd()
15560   shellPrepare(pState->db, &rc,  in recoverDatabaseCmd()
15564   shellPrepare(pState->db, &rc,  in recoverDatabaseCmd()
15574   shellPrepare(pState->db, &rc,   in recoverDatabaseCmd()
15588     pTab = recoverFindTable(pState, &rc, iRoot, bIntkey, nCol, &bNoop);  in recoverDatabaseCmd()
15592         pOrphan = recoverOrphanTable(pState, &rc, zLostAndFound, nOrphan);  in recoverDatabaseCmd()
15599       raw_printf(pState->out, "DELETE FROM sqlite_sequence;\n");  in recoverDatabaseCmd()
15620             pOrphan = recoverOrphanTable(pState, &rc, zLostAndFound, nOrphan);  in recoverDatabaseCmd()
15628           raw_printf(pState->out,   in recoverDatabaseCmd()
15634           raw_printf(pState->out, "INSERT INTO %s(%s) VALUES( %s );\n",   in recoverDatabaseCmd()
15652     shellPrepare(pState->db, &rc,   in recoverDatabaseCmd()
15664         raw_printf(pState->out, "%s;\n", zPrint);  in recoverDatabaseCmd()
15667         raw_printf(pState->out, "%s;\n", zSql);  in recoverDatabaseCmd()
15674     raw_printf(pState->out, "PRAGMA writable_schema = off;\n");  in recoverDatabaseCmd()
15675     raw_printf(pState->out, "COMMIT;\n");  in recoverDatabaseCmd()
15677   sqlite3_exec(pState->db, "DETACH recovery", 0, 0, 0);  in recoverDatabaseCmd()