Lines Matching refs:pState
14440 ShellState *pState, in expertHandleSQL() argument
14444 assert( pState->expert.pExpert ); in expertHandleSQL()
14446 return sqlite3_expert_sql(pState->expert.pExpert, zSql, pzErr); in expertHandleSQL()
14460 ShellState *pState, in expertFinish() argument
14465 sqlite3expert *p = pState->expert.pExpert; in expertFinish()
14469 FILE *out = pState->out; in expertFinish()
14470 int bVerbose = pState->expert.bVerbose; in expertFinish()
14497 pState->expert.pExpert = 0; in expertFinish()
14505 ShellState *pState, /* Current shell tool state */ in expertDotCommand() argument
14514 assert( pState->expert.pExpert==0 ); in expertDotCommand()
14515 memset(&pState->expert, 0, sizeof(ExpertInfo)); in expertDotCommand()
14523 pState->expert.bVerbose = 1; in expertDotCommand()
14544 pState->expert.pExpert = sqlite3_expert_new(pState->db, &zErr); in expertDotCommand()
14545 if( pState->expert.pExpert==0 ){ in expertDotCommand()
14550 pState->expert.pExpert, EXPERT_CONFIG_SAMPLE, iSample in expertDotCommand()
16894 ShellState *pState, /* Current shell tool state */ in lintFkeyIndexes() argument
16898 sqlite3 *db = pState->db; /* Database handle to query "main" db of */ in lintFkeyIndexes()
16899 FILE *out = pState->out; /* Stream to write non-error output to */ in lintFkeyIndexes()
17070 ShellState *pState, /* Current shell tool state */ in lintDotCommand() argument
17077 return lintFkeyIndexes(pState, azArg, nArg); in lintDotCommand()
17820 ShellState *pState, /* Current shell tool state */ in arDotCommand() argument
17832 cmd.p = pState; in arDotCommand()
17833 cmd.db = pState->db; in arDotCommand()
17837 eDbType = pState->openMode; in arDotCommand()
17859 utf8_printf(pState->out, "-- open database '%s'%s\n", cmd.zFile, in arDotCommand()
17901 arUsage(pState->out); in arDotCommand()
17919 if( cmd.db!=pState->db ){ in arDotCommand()
18184 ShellState *pState, /* Shell state object */ in recoverFindTable() argument
18198 shellPreparePrintf(pState->db, pRc, &pStmt, in recoverFindTable()
18224 ShellState *pState, /* Shell state object */ in recoverOrphanTable() argument
18240 shellPrepare(pState->db, pRc, in recoverOrphanTable()
18271 raw_printf(pState->out, in recoverOrphanTable()
18276 raw_printf(pState->out, ", c%d", i); in recoverOrphanTable()
18278 raw_printf(pState->out, ");\n"); in recoverOrphanTable()
18291 static int recoverDatabaseCmd(ShellState *pState, int nArg, char **azArg){ in recoverDatabaseCmd() argument
18325 showHelp(pState->out, azArg[0]); in recoverDatabaseCmd()
18330 shellExecPrintf(pState->db, &rc, in recoverDatabaseCmd()
18343 shellExec(pState->db, &rc, in recoverDatabaseCmd()
18367 shellExec(pState->db, &rc, in recoverDatabaseCmd()
18379 shellExec(pState->db, &rc, in recoverDatabaseCmd()
18456 raw_printf(pState->out, "PRAGMA foreign_keys=OFF;\n"); in recoverDatabaseCmd()
18457 raw_printf(pState->out, "BEGIN;\n"); in recoverDatabaseCmd()
18458 raw_printf(pState->out, "PRAGMA writable_schema = on;\n"); in recoverDatabaseCmd()
18459 shellPrepare(pState->db, &rc, in recoverDatabaseCmd()
18465 raw_printf(pState->out, "CREATE TABLE IF NOT EXISTS %s;\n", in recoverDatabaseCmd()
18474 shellPrepare(pState->db, &rc, in recoverDatabaseCmd()
18484 shellPrepare(pState->db, &rc, in recoverDatabaseCmd()
18488 shellPrepare(pState->db, &rc, in recoverDatabaseCmd()
18498 shellPrepare(pState->db, &rc, in recoverDatabaseCmd()
18512 pTab = recoverFindTable(pState, &rc, iRoot, bIntkey, nCol, &bNoop); in recoverDatabaseCmd()
18516 pOrphan = recoverOrphanTable(pState, &rc, zLostAndFound, nOrphan); in recoverDatabaseCmd()
18523 raw_printf(pState->out, "DELETE FROM sqlite_sequence;\n"); in recoverDatabaseCmd()
18544 pOrphan = recoverOrphanTable(pState, &rc, zLostAndFound, nOrphan); in recoverDatabaseCmd()
18552 raw_printf(pState->out, in recoverDatabaseCmd()
18558 raw_printf(pState->out, "INSERT INTO %s(%s) VALUES( %s );\n", in recoverDatabaseCmd()
18576 shellPrepare(pState->db, &rc, in recoverDatabaseCmd()
18588 raw_printf(pState->out, "%s;\n", zPrint); in recoverDatabaseCmd()
18591 raw_printf(pState->out, "%s;\n", zSql); in recoverDatabaseCmd()
18598 raw_printf(pState->out, "PRAGMA writable_schema = off;\n"); in recoverDatabaseCmd()
18599 raw_printf(pState->out, "COMMIT;\n"); in recoverDatabaseCmd()
18601 sqlite3_exec(pState->db, "DETACH recovery", 0, 0, 0); in recoverDatabaseCmd()