Lines Matching refs:pStmt
1549 sqlite3_stmt *pStmt = 0; in shellFakeSchema() local
1559 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in shellFakeSchema()
1570 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in shellFakeSchema()
1571 const char *zCol = (const char*)sqlite3_column_text(pStmt, 1); in shellFakeSchema()
1580 sqlite3_finalize(pStmt); in shellFakeSchema()
3048 sqlite3_stmt *pStmt = 0; in sha3QueryFunc() local
3070 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zSql); in sha3QueryFunc()
3074 sqlite3_finalize(pStmt); in sha3QueryFunc()
3079 if( !sqlite3_stmt_readonly(pStmt) ){ in sha3QueryFunc()
3080 char *zMsg = sqlite3_mprintf("non-query: [%s]", sqlite3_sql(pStmt)); in sha3QueryFunc()
3081 sqlite3_finalize(pStmt); in sha3QueryFunc()
3086 nCol = sqlite3_column_count(pStmt); in sha3QueryFunc()
3087 z = sqlite3_sql(pStmt); in sha3QueryFunc()
3095 while( SQLITE_ROW==sqlite3_step(pStmt) ){ in sha3QueryFunc()
3098 sha3UpdateFromValue(&cx, sqlite3_column_value(pStmt,i)); in sha3QueryFunc()
3101 sqlite3_finalize(pStmt); in sha3QueryFunc()
3475 sqlite3_stmt *pStmt = 0; in sha1QueryFunc() local
3488 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zSql); in sha1QueryFunc()
3492 sqlite3_finalize(pStmt); in sha1QueryFunc()
3497 if( !sqlite3_stmt_readonly(pStmt) ){ in sha1QueryFunc()
3498 char *zMsg = sqlite3_mprintf("non-query: [%s]", sqlite3_sql(pStmt)); in sha1QueryFunc()
3499 sqlite3_finalize(pStmt); in sha1QueryFunc()
3504 nCol = sqlite3_column_count(pStmt); in sha1QueryFunc()
3505 z = sqlite3_sql(pStmt); in sha1QueryFunc()
3511 while( SQLITE_ROW==sqlite3_step(pStmt) ){ in sha1QueryFunc()
3514 switch( sqlite3_column_type(pStmt,i) ){ in sha1QueryFunc()
3523 sqlite3_int64 v = sqlite3_column_int64(pStmt,i); in sha1QueryFunc()
3537 double r = sqlite3_column_double(pStmt,i); in sha1QueryFunc()
3548 int n2 = sqlite3_column_bytes(pStmt, i); in sha1QueryFunc()
3549 const unsigned char *z2 = sqlite3_column_text(pStmt, i); in sha1QueryFunc()
3555 int n2 = sqlite3_column_bytes(pStmt, i); in sha1QueryFunc()
3556 const unsigned char *z2 = sqlite3_column_blob(pStmt, i); in sha1QueryFunc()
3564 sqlite3_finalize(pStmt); in sha1QueryFunc()
9089 sqlite3_stmt *pStmt; /* Current statement */ member
9189 sqlite3_finalize(pCur->pStmt); pCur->pStmt = 0; in completionCursorReset()
9234 if( pCur->pStmt==0 ){ in completionNext()
9236 &pCur->pStmt, 0); in completionNext()
9243 if( pCur->pStmt==0 ){ in completionNext()
9259 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0); in completionNext()
9267 if( pCur->pStmt==0 ){ in completionNext()
9285 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0); in completionNext()
9297 if( sqlite3_step(pCur->pStmt)==SQLITE_ROW ){ in completionNext()
9299 pCur->zCurrentRow = (const char*)sqlite3_column_text(pCur->pStmt, iCol); in completionNext()
9300 pCur->szRow = sqlite3_column_bytes(pCur->pStmt, iCol); in completionNext()
9303 sqlite3_finalize(pCur->pStmt); in completionNext()
9304 pCur->pStmt = 0; in completionNext()
13433 static void idxFinalize(int *pRc, sqlite3_stmt *pStmt){ in idxFinalize() argument
13434 int rc = sqlite3_finalize(pStmt); in idxFinalize()
13946 IdxStatement *pStmt; in idxFindIndexes() local
13953 for(pStmt=p->pStatement; rc==SQLITE_OK && pStmt; pStmt=pStmt->pNext){ in idxFindIndexes()
13958 "EXPLAIN QUERY PLAN %s", pStmt->zSql in idxFindIndexes()
13996 pStmt->zEQP = idxAppendText(&rc, pStmt->zEQP, "%s\n", zDetail); in idxFindIndexes()
14001 pStmt->zIdx = idxAppendText(&rc, pStmt->zIdx, "%s;\n", pEntry->zKey); in idxFindIndexes()
14695 sqlite3_stmt *pStmt; in registerUDFs() local
14699 "WHERE builtin==0", -1, &pStmt, 0); in registerUDFs()
14701 while( SQLITE_ROW==(rc = sqlite3_step(pStmt)) ){ in registerUDFs()
14702 int nargs = sqlite3_column_int(pStmt,3); in registerUDFs()
14703 int flags = sqlite3_column_int(pStmt,4); in registerUDFs()
14704 const char *name = (char*)sqlite3_column_text(pStmt,0); in registerUDFs()
14705 const char *type = (char*)sqlite3_column_text(pStmt,1); in registerUDFs()
14706 const char *enc = (char*)sqlite3_column_text(pStmt,2); in registerUDFs()
14731 sqlite3_finalize(pStmt); in registerUDFs()
14859 sqlite3_stmt *pStmt = 0; in sqlite3_expert_sql() local
14861 rc = idxPrepareStmt(p->db, &pStmt, pzErr, zStmt); in sqlite3_expert_sql()
14863 sqlite3_finalize(pStmt); in sqlite3_expert_sql()
14864 rc = sqlite3_prepare_v2(p->dbv, zStmt, -1, &pStmt, &zStmt); in sqlite3_expert_sql()
14866 if( pStmt ){ in sqlite3_expert_sql()
14868 const char *z = sqlite3_sql(pStmt); in sqlite3_expert_sql()
14878 sqlite3_finalize(pStmt); in sqlite3_expert_sql()
14951 IdxStatement *pStmt; in sqlite3_expert_report() local
14954 for(pStmt=p->pStatement; pStmt && pStmt->iId!=iStmt; pStmt=pStmt->pNext); in sqlite3_expert_report()
14957 if( pStmt ) zRet = pStmt->zSql; in sqlite3_expert_report()
14960 if( pStmt ) zRet = pStmt->zIdx; in sqlite3_expert_report()
14963 if( pStmt ) zRet = pStmt->zEQP; in sqlite3_expert_report()
15284 static void intckFinalize(sqlite3_intck *p, sqlite3_stmt *pStmt){ in intckFinalize() argument
15285 int rc = sqlite3_finalize(pStmt); in intckFinalize()
15295 static int intckStep(sqlite3_intck *p, sqlite3_stmt *pStmt){ in intckStep() argument
15297 return sqlite3_step(pStmt); in intckStep()
15306 sqlite3_stmt *pStmt = 0; in intckExec() local
15307 pStmt = intckPrepare(p, zSql); in intckExec()
15308 intckStep(p, pStmt); in intckExec()
15309 intckFinalize(p, pStmt); in intckExec()
15340 sqlite3_stmt *pStmt = 0; in intckSaveKey() local
15417 pStmt = intckPrepare(p, zSql); in intckSaveKey()
15420 sqlite3_bind_value(pStmt, ii+1, sqlite3_column_value(p->pCheck, ii+1)); in intckSaveKey()
15422 if( SQLITE_ROW==sqlite3_step(pStmt) ){ in intckSaveKey()
15423 p->zKey = intckMprintf(p,"%s",(const char*)sqlite3_column_text(pStmt, 0)); in intckSaveKey()
15425 intckFinalize(p, pStmt); in intckSaveKey()
15438 sqlite3_stmt *pStmt = 0; in intckFindObject() local
15445 pStmt = intckPrepareFmt(p, in intckFindObject()
15459 sqlite3_bind_text(pStmt, 1, zPrev, -1, SQLITE_TRANSIENT); in intckFindObject()
15460 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in intckFindObject()
15461 p->zObj = intckMprintf(p,"%s",(const char*)sqlite3_column_text(pStmt, 0)); in intckFindObject()
15464 intckFinalize(p, pStmt); in intckFindObject()
15637 sqlite3_stmt *pStmt = 0; in intckGetAutoIndex() local
15638 pStmt = intckPrepare(p, "PRAGMA automatic_index"); in intckGetAutoIndex()
15639 if( SQLITE_ROW==intckStep(p, pStmt) ){ in intckGetAutoIndex()
15640 bRet = sqlite3_column_int(pStmt, 0); in intckGetAutoIndex()
15642 intckFinalize(p, pStmt); in intckGetAutoIndex()
15651 sqlite3_stmt *pStmt = 0; in intckIsIndex() local
15652 pStmt = intckPrepareFmt(p, in intckIsIndex()
15656 if( p->rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(pStmt) ){ in intckIsIndex()
15659 intckFinalize(p, pStmt); in intckIsIndex()
15680 sqlite3_stmt *pStmt = 0; in intckCheckObjectSql() local
15797 pStmt = intckPrepareFmt(p, in intckCheckObjectSql()
15851 pStmt = intckPrepareFmt(p, in intckCheckObjectSql()
15931 while( p->rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(pStmt) ){ in intckCheckObjectSql()
15932 zRet = intckMprintf(p, "%s", (const char*)sqlite3_column_text(pStmt, 0)); in intckCheckObjectSql()
15934 *pnKeyVal = sqlite3_column_int(pStmt, 1); in intckCheckObjectSql()
15937 intckFinalize(p, pStmt); in intckCheckObjectSql()
17787 sqlite3_stmt *pStmt; /* For fetching database pages */ member
17814 sqlite3_stmt *pStmt; /* For fetching database pages */ member
17908 sqlite3_finalize(pTab->pStmt); in dbdataDisconnect()
17998 if( pTab->pStmt==0 ){ in dbdataResetCursor()
17999 pTab->pStmt = pCsr->pStmt; in dbdataResetCursor()
18001 sqlite3_finalize(pCsr->pStmt); in dbdataResetCursor()
18003 pCsr->pStmt = 0; in dbdataResetCursor()
18055 sqlite3_stmt *pStmt = pCsr->pStmt; in dbdataLoadPage() local
18060 sqlite3_bind_int64(pStmt, 2, pgno); in dbdataLoadPage()
18061 if( SQLITE_ROW==sqlite3_step(pStmt) ){ in dbdataLoadPage()
18062 int nCopy = sqlite3_column_bytes(pStmt, 0); in dbdataLoadPage()
18069 const u8 *pCopy = sqlite3_column_blob(pStmt, 0); in dbdataLoadPage()
18077 rc2 = sqlite3_reset(pStmt); in dbdataLoadPage()
18481 sqlite3_stmt *pStmt = 0; in dbdataDbsize() local
18490 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pStmt, 0); in dbdataDbsize()
18492 if( rc==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in dbdataDbsize()
18493 pCsr->szDb = sqlite3_column_int(pStmt, 0); in dbdataDbsize()
18495 rc2 = sqlite3_finalize(pStmt); in dbdataDbsize()
18548 if( pTab->pStmt ){ in dbdataFilter()
18549 pCsr->pStmt = pTab->pStmt; in dbdataFilter()
18550 pTab->pStmt = 0; in dbdataFilter()
18556 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pCsr->pStmt, 0); in dbdataFilter()
18562 &pCsr->pStmt, 0 in dbdataFilter()
18567 rc = sqlite3_bind_text(pCsr->pStmt, 1, zSchema, -1, SQLITE_TRANSIENT); in dbdataFilter()
19171 sqlite3_stmt *pStmt = 0; in recoverPrepare() local
19173 if( sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0) ){ in recoverPrepare()
19177 return pStmt; in recoverPrepare()
19196 sqlite3_stmt *pStmt = 0; in recoverPreparePrintf() local
19206 pStmt = recoverPrepare(p, db, z); in recoverPreparePrintf()
19210 return pStmt; in recoverPreparePrintf()
19222 static sqlite3_stmt *recoverReset(sqlite3_recover *p, sqlite3_stmt *pStmt){ in recoverReset() argument
19223 int rc = sqlite3_reset(pStmt); in recoverReset()
19225 recoverDbError(p, sqlite3_db_handle(pStmt)); in recoverReset()
19227 return pStmt; in recoverReset()
19236 static void recoverFinalize(sqlite3_recover *p, sqlite3_stmt *pStmt){ in recoverFinalize() argument
19237 sqlite3 *db = sqlite3_db_handle(pStmt); in recoverFinalize()
19238 int rc = sqlite3_finalize(pStmt); in recoverFinalize()
19270 sqlite3_stmt *pStmt, in recoverBindValue() argument
19275 int rc = sqlite3_bind_value(pStmt, iBind, pVal); in recoverBindValue()
19321 sqlite3_stmt *pStmt = 0; in recoverPageCount() local
19322 pStmt = recoverPreparePrintf(p, p->dbIn, "PRAGMA %Q.page_count", p->zDb); in recoverPageCount()
19323 if( pStmt ){ in recoverPageCount()
19324 sqlite3_step(pStmt); in recoverPageCount()
19325 nPg = sqlite3_column_int64(pStmt, 0); in recoverPageCount()
19327 recoverFinalize(p, pStmt); in recoverPageCount()
19408 sqlite3_stmt *pStmt = 0; in recoverGetPage() local
19417 pStmt = p->pGetPage = recoverPreparePrintf( in recoverGetPage()
19421 pStmt = p->pGetPage; in recoverGetPage()
19424 if( pStmt ){ in recoverGetPage()
19425 sqlite3_bind_int64(pStmt, 1, pgno); in recoverGetPage()
19426 if( SQLITE_ROW==sqlite3_step(pStmt) ){ in recoverGetPage()
19430 aPg = sqlite3_column_blob(pStmt, 0); in recoverGetPage()
19431 nPg = sqlite3_column_bytes(pStmt, 0); in recoverGetPage()
19437 recoverReset(p, pStmt); in recoverGetPage()
19764 sqlite3_stmt *pStmt = recoverPreparePrintf(p, p->dbOut, in recoverAddTable() local
19768 if( pStmt ){ in recoverAddTable()
19775 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in recoverAddTable()
19777 nByte += (sqlite3_column_bytes(pStmt, 1)+1); in recoverAddTable()
19780 recoverReset(p, pStmt); in recoverAddTable()
19794 for(i=0; sqlite3_step(pStmt)==SQLITE_ROW; i++){ in recoverAddTable()
19795 int iPKF = sqlite3_column_int(pStmt, 5); in recoverAddTable()
19796 int n = sqlite3_column_bytes(pStmt, 1); in recoverAddTable()
19797 const char *z = (const char*)sqlite3_column_text(pStmt, 1); in recoverAddTable()
19798 const char *zType = (const char*)sqlite3_column_text(pStmt, 2); in recoverAddTable()
19799 int eHidden = sqlite3_column_int(pStmt, 6); in recoverAddTable()
19824 recoverFinalize(p, pStmt); in recoverAddTable()
19826 pStmt = recoverPreparePrintf(p, p->dbOut, "PRAGMA index_xinfo(%Q)", zName); in recoverAddTable()
19827 while( pStmt && sqlite3_step(pStmt)==SQLITE_ROW ){ in recoverAddTable()
19828 int iField = sqlite3_column_int(pStmt, 0); in recoverAddTable()
19829 int iCol = sqlite3_column_int(pStmt, 1); in recoverAddTable()
19837 recoverFinalize(p, pStmt); in recoverAddTable()
20571 sqlite3_stmt *pStmt = 0; in recoverLostAndFound1Init() local
20581 pStmt = recoverPrepare( in recoverLostAndFound1Init()
20611 if( pStmt ) sqlite3_bind_int(pStmt, 1, p->bFreelistCorrupt); in recoverLostAndFound1Init()
20612 pLaf->pUsedPages = pStmt; in recoverLostAndFound1Init()
21723 sqlite3_stmt *pStmt; /* Current statement if any. */ member
22955 if( i==iIndent && p->aiIndent && p->pStmt ){ in shell_callback()
23171 double r = sqlite3_column_double(p->pStmt, i); in shell_callback()
23187 }else if( aiType && aiType[i]==SQLITE_BLOB && p->pStmt ){ in shell_callback()
23188 const void *pBlob = sqlite3_column_blob(p->pStmt, i); in shell_callback()
23189 int nBlob = sqlite3_column_bytes(p->pStmt, i); in shell_callback()
23217 double r = sqlite3_column_double(p->pStmt, i); in shell_callback()
23228 }else if( aiType && aiType[i]==SQLITE_BLOB && p->pStmt ){ in shell_callback()
23229 const void *pBlob = sqlite3_column_blob(p->pStmt, i); in shell_callback()
23230 int nBlob = sqlite3_column_bytes(p->pStmt, i); in shell_callback()
23264 double r = sqlite3_column_double(p->pStmt, i); in shell_callback()
23267 }else if( aiType && aiType[i]==SQLITE_BLOB && p->pStmt ){ in shell_callback()
23268 const void *pBlob = sqlite3_column_blob(p->pStmt, i); in shell_callback()
23269 int nBlob = sqlite3_column_bytes(p->pStmt, i); in shell_callback()
23609 if( pArg->pStmt && pArg->statsOn==2 ){ in display_stats()
23611 sqlite3_stmt *pStmt = pArg->pStmt; in display_stats() local
23613 nCol = sqlite3_column_count(pStmt); in display_stats()
23617 sqlite3_fprintf(out, "%-36s %s\n", z, sqlite3_column_name(pStmt,i)); in display_stats()
23620 sqlite3_fprintf(out, "%-36s %s\n", z, sqlite3_column_decltype(pStmt, i)); in display_stats()
23625 sqlite3_column_database_name(pStmt,i)); in display_stats()
23627 sqlite3_fprintf(out, "%-36s %s\n", z, sqlite3_column_table_name(pStmt,i)); in display_stats()
23629 sqlite3_fprintf(out, "%-36s %s\n", z,sqlite3_column_origin_name(pStmt,i)); in display_stats()
23635 if( pArg->pStmt ){ in display_stats()
23636 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_VM_STEP,bReset); in display_stats()
23711 if( pArg->pStmt ){ in display_stats()
23713 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_FULLSCAN_STEP, in display_stats()
23717 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_SORT, bReset); in display_stats()
23720 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_AUTOINDEX,bReset); in display_stats()
23723 iHit = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_FILTER_HIT, in display_stats()
23725 iMiss = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_FILTER_MISS, in display_stats()
23731 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_VM_STEP, bReset); in display_stats()
23734 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_REPREPARE,bReset); in display_stats()
23737 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_RUN, bReset); in display_stats()
23740 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_MEMUSED, bReset); in display_stats()
23789 sqlite3_stmt *p = pArg->pStmt; in display_explain_scanstats()
23993 sqlite3_stmt *pStmt = 0; in display_scanstats()
23994 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in display_scanstats()
23996 sqlite3_stmt *pSave = pArg->pStmt; in display_scanstats()
23997 pArg->pStmt = pStmt; in display_scanstats()
23998 sqlite3_bind_pointer(pStmt, 1, pSave, "stmt-pointer", 0); in display_scanstats()
24002 explain_data_prepare(pArg, pStmt); in display_scanstats()
24003 exec_prepared_stmt(pArg, pStmt); in display_scanstats()
24006 sqlite3_finalize(pStmt); in display_scanstats()
24007 pArg->pStmt = pSave; in display_scanstats()
24062 static void bind_prepared_stmt(ShellState *pArg, sqlite3_stmt *pStmt){ in bind_prepared_stmt() argument
24068 nVar = sqlite3_bind_parameter_count(pStmt); in bind_prepared_stmt()
24081 const char *zVar = sqlite3_bind_parameter_name(pStmt, i); in bind_prepared_stmt()
24088 sqlite3_bind_value(pStmt, i, sqlite3_column_value(pQ, 0)); in bind_prepared_stmt()
24091 sqlite3_bind_double(pStmt, i, NAN); in bind_prepared_stmt()
24095 sqlite3_bind_double(pStmt, i, INFINITY); in bind_prepared_stmt()
24098 sqlite3_bind_int(pStmt, i, atoi(&zVar[5])); in bind_prepared_stmt()
24104 sqlite3_bind_text64(pStmt, i, zBuf, szVar-6, sqlite3_free, SQLITE_UTF8); in bind_prepared_stmt()
24107 sqlite3_bind_null(pStmt, i); in bind_prepared_stmt()
24339 static char *quoted_column(sqlite3_stmt *pStmt, int i){ in quoted_column() argument
24340 switch( sqlite3_column_type(pStmt, i) ){ in quoted_column()
24346 return sqlite3_mprintf("%s",sqlite3_column_text(pStmt,i)); in quoted_column()
24349 const unsigned char *zText = sqlite3_column_text(pStmt,i); in quoted_column()
24355 const unsigned char *a = sqlite3_column_blob(pStmt,i); in quoted_column()
24356 int n = sqlite3_column_bytes(pStmt,i); in quoted_column()
24380 sqlite3_stmt *pStmt /* Statement to run */ in exec_prepared_stmt_columnar() argument
24402 rc = sqlite3_step(pStmt); in exec_prepared_stmt_columnar()
24404 nColumn = sqlite3_column_count(pStmt); in exec_prepared_stmt_columnar()
24440 uz = (const unsigned char*)sqlite3_column_name(pStmt,i); in exec_prepared_stmt_columnar()
24468 azQuoted[i] = quoted_column(pStmt,i); in exec_prepared_stmt_columnar()
24471 uz = (const unsigned char*)sqlite3_column_text(pStmt,i); in exec_prepared_stmt_columnar()
24482 }while( bNextLine || sqlite3_step(pStmt)==SQLITE_ROW ); in exec_prepared_stmt_columnar()
24609 sqlite3_stmt *pStmt /* Statement to run */ in exec_prepared_stmt() argument
24619 exec_prepared_stmt_columnar(pArg, pStmt); in exec_prepared_stmt()
24626 rc = sqlite3_step(pStmt); in exec_prepared_stmt()
24630 int nCol = sqlite3_column_count(pStmt); in exec_prepared_stmt()
24642 azCols[i] = (char *)sqlite3_column_name(pStmt, i); in exec_prepared_stmt()
24648 aiTypes[i] = x = sqlite3_column_type(pStmt, i); in exec_prepared_stmt()
24655 azVals[i] = (char*)sqlite3_column_text(pStmt, i); in exec_prepared_stmt()
24669 rc = sqlite3_step(pStmt); in exec_prepared_stmt()
24836 sqlite3_stmt *pStmt = NULL; /* Statement to execute. */ in shell_exec() local
24855 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover); in shell_exec()
24861 if( !pStmt ){ in shell_exec()
24867 zStmtSql = sqlite3_sql(pStmt); in shell_exec()
24873 pArg->pStmt = pStmt; in shell_exec()
24878 if( pArg && pArg->autoEQP && sqlite3_stmt_isexplain(pStmt)==0 ){ in shell_exec()
24886 pExplain = pStmt; in shell_exec()
24917 sqlite3_reset(pStmt); in shell_exec()
24918 sqlite3_stmt_explain(pStmt, 0); in shell_exec()
24923 int bIsExplain = (sqlite3_stmt_isexplain(pStmt)==1); in shell_exec()
24929 if( sqlite3_stmt_isexplain(pStmt)==2 ){ in shell_exec()
24937 explain_data_prepare(pArg, pStmt); in shell_exec()
24941 bind_prepared_stmt(pArg, pStmt); in shell_exec()
24942 exec_prepared_stmt(pArg, pStmt); in shell_exec()
24959 rc2 = sqlite3_finalize(pStmt); in shell_exec()
24970 pArg->pStmt = NULL; in shell_exec()
25005 sqlite3_stmt *pStmt; in tableColumnList() local
25016 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in tableColumnList()
25019 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in tableColumnList()
25025 azCol[++nCol] = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 1)); in tableColumnList()
25027 if( sqlite3_column_int(pStmt, 5) ){ in tableColumnList()
25030 && sqlite3_stricmp((const char*)sqlite3_column_text(pStmt,2), in tableColumnList()
25039 sqlite3_finalize(pStmt); in tableColumnList()
25061 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in tableColumnList()
25067 rc = sqlite3_step(pStmt); in tableColumnList()
25068 sqlite3_finalize(pStmt); in tableColumnList()
25098 sqlite3_stmt *pStmt = 0; in toggleSelectOrder() local
25101 sqlite3_prepare_v2(db, "PRAGMA reverse_unordered_selects", -1, &pStmt, 0); in toggleSelectOrder()
25102 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in toggleSelectOrder()
25103 iSetting = sqlite3_column_int(pStmt, 0); in toggleSelectOrder()
25105 sqlite3_finalize(pStmt); in toggleSelectOrder()
26176 static sqlite3_stmt *pStmt = 0; in readline_completion_generator() local
26180 sqlite3_finalize(pStmt); in readline_completion_generator()
26184 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0); in readline_completion_generator()
26187 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in readline_completion_generator()
26188 const char *z = (const char*)sqlite3_column_text(pStmt,0); in readline_completion_generator()
26191 sqlite3_finalize(pStmt); in readline_completion_generator()
26192 pStmt = 0; in readline_completion_generator()
26218 sqlite3_stmt *pStmt = 0; in linenoise_completion() local
26235 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0); in linenoise_completion()
26238 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in linenoise_completion()
26239 const char *zCompletion = (const char*)sqlite3_column_text(pStmt, 0); in linenoise_completion()
26240 int nCompletion = sqlite3_column_bytes(pStmt, 0); in linenoise_completion()
26246 sqlite3_finalize(pStmt); in linenoise_completion()
26394 sqlite3_stmt *pStmt; in sql_trace_callback() local
26405 pStmt = (sqlite3_stmt*)pP; in sql_trace_callback()
26408 zSql = sqlite3_expanded_sql(pStmt); in sql_trace_callback()
26413 zSql = sqlite3_normalized_sql(pStmt); in sql_trace_callback()
26418 zSql = sqlite3_sql(pStmt); in sql_trace_callback()
26915 sqlite3_stmt *pStmt; in db_int() local
26922 sqlite3_prepare_v2(db, z, -1, &pStmt, 0); in db_int()
26923 if( pStmt && sqlite3_step(pStmt)==SQLITE_ROW ){ in db_int()
26924 res = sqlite3_column_int(pStmt,0); in db_int()
26926 sqlite3_finalize(pStmt); in db_int()
26978 sqlite3_stmt *pStmt = 0; in shell_dbinfo_command() local
26984 -1, &pStmt, 0); in shell_dbinfo_command()
26987 sqlite3_finalize(pStmt); in shell_dbinfo_command()
26990 sqlite3_bind_text(pStmt, 1, zDb, -1, SQLITE_STATIC); in shell_dbinfo_command()
26991 if( sqlite3_step(pStmt)==SQLITE_ROW in shell_dbinfo_command()
26992 && sqlite3_column_bytes(pStmt,0)>100 in shell_dbinfo_command()
26994 const u8 *pb = sqlite3_column_blob(pStmt,0); in shell_dbinfo_command()
26997 sqlite3_finalize(pStmt); in shell_dbinfo_command()
27000 sqlite3_finalize(pStmt); in shell_dbinfo_command()
27046 sqlite3_stmt *pStmt = 0; in shell_dbtotxt_command() local
27060 rc = sqlite3_prepare_v2(p->db, "PRAGMA page_size", -1, &pStmt, 0); in shell_dbtotxt_command()
27063 if( sqlite3_step(pStmt)!=SQLITE_ROW ) goto dbtotxt_error; in shell_dbtotxt_command()
27064 pgSz = sqlite3_column_int(pStmt, 0); in shell_dbtotxt_command()
27065 sqlite3_finalize(pStmt); in shell_dbtotxt_command()
27066 pStmt = 0; in shell_dbtotxt_command()
27068 rc = sqlite3_prepare_v2(p->db, "PRAGMA page_count", -1, &pStmt, 0); in shell_dbtotxt_command()
27071 if( sqlite3_step(pStmt)!=SQLITE_ROW ) goto dbtotxt_error; in shell_dbtotxt_command()
27072 nPage = sqlite3_column_int64(pStmt, 0); in shell_dbtotxt_command()
27073 sqlite3_finalize(pStmt); in shell_dbtotxt_command()
27074 pStmt = 0; in shell_dbtotxt_command()
27076 rc = sqlite3_prepare_v2(p->db, "PRAGMA databases", -1, &pStmt, 0); in shell_dbtotxt_command()
27078 if( sqlite3_step(pStmt)!=SQLITE_ROW ){ in shell_dbtotxt_command()
27081 const char *zFilename = (const char*)sqlite3_column_text(pStmt, 2); in shell_dbtotxt_command()
27092 sqlite3_finalize(pStmt); in shell_dbtotxt_command()
27093 pStmt = 0; in shell_dbtotxt_command()
27095 "SELECT pgno, data FROM sqlite_dbpage ORDER BY pgno", -1, &pStmt, 0); in shell_dbtotxt_command()
27097 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in shell_dbtotxt_command()
27098 sqlite3_int64 pgno = sqlite3_column_int64(pStmt, 0); in shell_dbtotxt_command()
27099 const u8 *aData = sqlite3_column_blob(pStmt, 1); in shell_dbtotxt_command()
27119 sqlite3_finalize(pStmt); in shell_dbtotxt_command()
27128 sqlite3_finalize(pStmt); in shell_dbtotxt_command()
27613 sqlite3_stmt *pStmt in shellFinalize() argument
27615 if( pStmt ){ in shellFinalize()
27616 sqlite3 *db = sqlite3_db_handle(pStmt); in shellFinalize()
27617 int rc = sqlite3_finalize(pStmt); in shellFinalize()
27636 sqlite3_stmt *pStmt in shellReset() argument
27638 int rc = sqlite3_reset(pStmt); in shellReset()
27641 sqlite3 *db = sqlite3_db_handle(pStmt); in shellReset()
28660 sqlite3_stmt *pStmt = 0; in zAutoColumn() local
28676 rc = sqlite3_prepare_v2(*pDb, zTabFill, -1, &pStmt, 0); in zAutoColumn()
28678 rc = sqlite3_bind_text(pStmt, 1, zColNew, -1, 0); in zAutoColumn()
28680 rc = sqlite3_step(pStmt); in zAutoColumn()
28682 sqlite3_finalize(pStmt); in zAutoColumn()
28698 rc = sqlite3_prepare_v2(*pDb, zRenameRank, -1, &pStmt, 0); in zAutoColumn()
28700 sqlite3_bind_int(pStmt, 1, nDigits); in zAutoColumn()
28701 rc = sqlite3_step(pStmt); in zAutoColumn()
28702 sqlite3_finalize(pStmt); in zAutoColumn()
28706 rc = sqlite3_prepare_v2(*pDb, zCollectVar, -1, &pStmt, 0); in zAutoColumn()
28708 rc = sqlite3_step(pStmt); in zAutoColumn()
28710 zColsSpec = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0)); in zAutoColumn()
28717 sqlite3_finalize(pStmt); in zAutoColumn()
28718 if( SQLITE_OK==sqlite3_prepare_v2(*pDb, zRenamesDone, -1, &pStmt, 0) in zAutoColumn()
28719 && SQLITE_ROW==sqlite3_step(pStmt) ){ in zAutoColumn()
28720 *pzRenamed = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0)); in zAutoColumn()
28725 sqlite3_finalize(pStmt); in zAutoColumn()
28742 sqlite3_stmt *pStmt = 0; in outputDumpWarning() local
28743 shellPreparePrintf(p->db, &rc, &pStmt, in outputDumpWarning()
28747 if( rc==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in outputDumpWarning()
28753 shellFinalize(&rc, pStmt); in outputDumpWarning()
29100 sqlite3_stmt *pStmt; in do_meta_command() local
29103 rc = sqlite3_prepare_v2(p->db, "PRAGMA database_list", -1, &pStmt, 0); in do_meta_command()
29108 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
29109 const char *zSchema = (const char *)sqlite3_column_text(pStmt,1); in do_meta_command()
29110 const char *zFile = (const char*)sqlite3_column_text(pStmt,2); in do_meta_command()
29119 sqlite3_finalize(pStmt); in do_meta_command()
29568 sqlite3_stmt *pStmt; in do_meta_command() local
29572 -1, &pStmt, 0); in do_meta_command()
29574 doStats = sqlite3_step(pStmt)==SQLITE_ROW; in do_meta_command()
29575 sqlite3_finalize(pStmt); in do_meta_command()
29617 sqlite3_stmt *pStmt = NULL; /* A statement */ in do_meta_command() local
29815 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
29819 if (pStmt) sqlite3_finalize(pStmt); in do_meta_command()
29825 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
29826 nCol = sqlite3_column_int(pStmt, 0); in do_meta_command()
29830 sqlite3_finalize(pStmt); in do_meta_command()
29831 pStmt = 0; in do_meta_command()
29860 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
29865 if (pStmt) sqlite3_finalize(pStmt); in do_meta_command()
29895 sqlite3_bind_text(pStmt, i+1, z, -1, SQLITE_TRANSIENT); in do_meta_command()
29901 while( i<=nCol ){ sqlite3_bind_null(pStmt, i); i++; } in do_meta_command()
29914 sqlite3_step(pStmt); in do_meta_command()
29915 rc = sqlite3_reset(pStmt); in do_meta_command()
29927 sqlite3_finalize(pStmt); in do_meta_command()
29941 sqlite3_stmt *pStmt; in do_meta_command() local
29979 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
29981 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
29982 tnum = sqlite3_column_int(pStmt, 0); in do_meta_command()
29983 isWO = sqlite3_column_int(pStmt, 1); in do_meta_command()
29985 sqlite3_finalize(pStmt); in do_meta_command()
29987 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
29990 while( rc==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
29992 const char *zCol = (const char*)sqlite3_column_text(pStmt,2); in do_meta_command()
29995 if( sqlite3_column_int(pStmt,1)==-1 ){ in do_meta_command()
30002 if( isWO && lenPK==0 && sqlite3_column_int(pStmt,5)==0 && zCollist ){ in do_meta_command()
30011 sqlite3_finalize(pStmt); in do_meta_command()
30639 sqlite3_stmt *pStmt = 0; in do_meta_command() local
30644 "FROM temp.sqlite_parameters;", -1, &pStmt, 0); in do_meta_command()
30645 if( rx==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
30646 len = sqlite3_column_int(pStmt, 0); in do_meta_command()
30649 sqlite3_finalize(pStmt); in do_meta_command()
30650 pStmt = 0; in do_meta_command()
30654 "FROM temp.sqlite_parameters;", -1, &pStmt, 0); in do_meta_command()
30655 while( rx==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
30657 "%-*s %s\n", len, sqlite3_column_text(pStmt,0), in do_meta_command()
30658 sqlite3_column_text(pStmt,1)); in do_meta_command()
30660 sqlite3_finalize(pStmt); in do_meta_command()
30681 sqlite3_stmt *pStmt; in do_meta_command() local
30689 pStmt = 0; in do_meta_command()
30690 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
30693 sqlite3_finalize(pStmt); in do_meta_command()
30694 pStmt = 0; in do_meta_command()
30699 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
30703 sqlite3_finalize(pStmt); in do_meta_command()
30704 pStmt = 0; in do_meta_command()
30708 bind_prepared_stmt(p, pStmt); in do_meta_command()
30709 sqlite3_step(pStmt); in do_meta_command()
30710 sqlite3_finalize(pStmt); in do_meta_command()
30978 sqlite3_stmt *pStmt = 0; in do_meta_command() local
30980 -1, &pStmt, 0); in do_meta_command()
30983 sqlite3_finalize(pStmt); in do_meta_command()
30989 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
30990 const char *zDb = (const char*)sqlite3_column_text(pStmt, 0); in do_meta_command()
31009 sqlite3_finalize(pStmt); in do_meta_command()
31302 sqlite3_stmt *pStmt = 0; /* Query against the SELFTEST table */ in do_meta_command() local
31338 -1, &pStmt, 0); in do_meta_command()
31343 -1, &pStmt, 0); in do_meta_command()
31348 sqlite3_finalize(pStmt); in do_meta_command()
31351 for(i=1; sqlite3_step(pStmt)==SQLITE_ROW; i++){ in do_meta_command()
31352 int tno = sqlite3_column_int(pStmt, 0); in do_meta_command()
31353 const char *zOp = (const char*)sqlite3_column_text(pStmt, 1); in do_meta_command()
31354 const char *zSql = (const char*)sqlite3_column_text(pStmt, 2); in do_meta_command()
31355 const char *zAns = (const char*)sqlite3_column_text(pStmt, 3); in do_meta_command()
31395 sqlite3_finalize(pStmt); in do_meta_command()
31423 sqlite3_stmt *pStmt; /* For querying tables names */ in do_meta_command() local
31473 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
31478 while( SQLITE_ROW==sqlite3_step(pStmt) ){ in do_meta_command()
31479 const char *zTab = (const char*)sqlite3_column_text(pStmt,0); in do_meta_command()
31507 sqlite3_finalize(pStmt); in do_meta_command()
31556 lrc = sqlite3_prepare_v2(p->db, zRevText, -1, &pStmt, 0); in do_meta_command()
31562 if( zLike ) sqlite3_bind_text(pStmt,1,zLike,-1,SQLITE_STATIC); in do_meta_command()
31563 lrc = SQLITE_ROW==sqlite3_step(pStmt); in do_meta_command()
31565 const char *zGenQuery = (char*)sqlite3_column_text(pStmt,0); in do_meta_command()
31583 sqlite3_finalize(pStmt); in do_meta_command()
31694 sqlite3_stmt *pStmt; in do_meta_command() local
31701 rc = sqlite3_prepare_v2(p->db, "PRAGMA database_list", -1, &pStmt, 0); in do_meta_command()
31703 sqlite3_finalize(pStmt); in do_meta_command()
31713 sqlite3_finalize(pStmt); in do_meta_command()
31716 for(ii=0; sqlite3_step(pStmt)==SQLITE_ROW; ii++){ in do_meta_command()
31717 const char *zDbName = (const char*)sqlite3_column_text(pStmt, 1); in do_meta_command()
31738 rc = sqlite3_finalize(pStmt); in do_meta_command()
31741 rc = sqlite3_prepare_v2(p->db, s.z, -1, &pStmt, 0); in do_meta_command()
31751 sqlite3_bind_text(pStmt, 1, azArg[1], -1, SQLITE_TRANSIENT); in do_meta_command()
31753 sqlite3_bind_text(pStmt, 1, "%", -1, SQLITE_STATIC); in do_meta_command()
31755 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
31764 azResult[nRow] = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0)); in do_meta_command()
31768 if( sqlite3_finalize(pStmt)!=SQLITE_OK ){ in do_meta_command()
32628 sqlite3_stmt *pStmt = 0; in doAutoDetectRestore() local
32631 shellPrepare(p->db, &rc, zQuery, &pStmt); in doAutoDetectRestore()
32632 if( rc==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in doAutoDetectRestore()
32635 shellFinalize(&rc, pStmt); in doAutoDetectRestore()