Lines Matching refs:pStmt
1997 sqlite3_stmt *pStmt = 0; in shellFakeSchema() local
2007 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in shellFakeSchema()
2018 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in shellFakeSchema()
2019 const char *zCol = (const char*)sqlite3_column_text(pStmt, 1); in shellFakeSchema()
2028 sqlite3_finalize(pStmt); in shellFakeSchema()
3422 sqlite3_stmt *pStmt = 0; in sha3QueryFunc() local
3444 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zSql); in sha3QueryFunc()
3448 sqlite3_finalize(pStmt); in sha3QueryFunc()
3453 if( !sqlite3_stmt_readonly(pStmt) ){ in sha3QueryFunc()
3454 char *zMsg = sqlite3_mprintf("non-query: [%s]", sqlite3_sql(pStmt)); in sha3QueryFunc()
3455 sqlite3_finalize(pStmt); in sha3QueryFunc()
3460 nCol = sqlite3_column_count(pStmt); in sha3QueryFunc()
3461 z = sqlite3_sql(pStmt); in sha3QueryFunc()
3469 while( SQLITE_ROW==sqlite3_step(pStmt) ){ in sha3QueryFunc()
3472 switch( sqlite3_column_type(pStmt,i) ){ in sha3QueryFunc()
3481 sqlite3_int64 v = sqlite3_column_int64(pStmt,i); in sha3QueryFunc()
3495 double r = sqlite3_column_double(pStmt,i); in sha3QueryFunc()
3506 int n2 = sqlite3_column_bytes(pStmt, i); in sha3QueryFunc()
3507 const unsigned char *z2 = sqlite3_column_text(pStmt, i); in sha3QueryFunc()
3513 int n2 = sqlite3_column_bytes(pStmt, i); in sha3QueryFunc()
3514 const unsigned char *z2 = sqlite3_column_blob(pStmt, i); in sha3QueryFunc()
3522 sqlite3_finalize(pStmt); in sha3QueryFunc()
8260 sqlite3_stmt *pStmt; /* Current statement */ member
8360 sqlite3_finalize(pCur->pStmt); pCur->pStmt = 0; in completionCursorReset()
8405 if( pCur->pStmt==0 ){ in completionNext()
8407 &pCur->pStmt, 0); in completionNext()
8414 if( pCur->pStmt==0 ){ in completionNext()
8430 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0); in completionNext()
8438 if( pCur->pStmt==0 ){ in completionNext()
8456 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0); in completionNext()
8468 if( sqlite3_step(pCur->pStmt)==SQLITE_ROW ){ in completionNext()
8470 pCur->zCurrentRow = (const char*)sqlite3_column_text(pCur->pStmt, iCol); in completionNext()
8471 pCur->szRow = sqlite3_column_bytes(pCur->pStmt, iCol); in completionNext()
8474 sqlite3_finalize(pCur->pStmt); in completionNext()
8475 pCur->pStmt = 0; in completionNext()
12594 static void idxFinalize(int *pRc, sqlite3_stmt *pStmt){ in idxFinalize() argument
12595 int rc = sqlite3_finalize(pStmt); in idxFinalize()
13107 IdxStatement *pStmt; in idxFindIndexes() local
13114 for(pStmt=p->pStatement; rc==SQLITE_OK && pStmt; pStmt=pStmt->pNext){ in idxFindIndexes()
13119 "EXPLAIN QUERY PLAN %s", pStmt->zSql in idxFindIndexes()
13157 pStmt->zEQP = idxAppendText(&rc, pStmt->zEQP, "%s\n", zDetail); in idxFindIndexes()
13162 pStmt->zIdx = idxAppendText(&rc, pStmt->zIdx, "%s;\n", pEntry->zKey); in idxFindIndexes()
13781 sqlite3_stmt *pStmt; in registerUDFs() local
13785 "WHERE builtin==0", -1, &pStmt, 0); in registerUDFs()
13787 while( SQLITE_ROW==(rc = sqlite3_step(pStmt)) ){ in registerUDFs()
13788 int nargs = sqlite3_column_int(pStmt,3); in registerUDFs()
13789 int flags = sqlite3_column_int(pStmt,4); in registerUDFs()
13790 const char *name = (char*)sqlite3_column_text(pStmt,0); in registerUDFs()
13791 const char *type = (char*)sqlite3_column_text(pStmt,1); in registerUDFs()
13792 const char *enc = (char*)sqlite3_column_text(pStmt,2); in registerUDFs()
13817 sqlite3_finalize(pStmt); in registerUDFs()
13939 sqlite3_stmt *pStmt = 0; in sqlite3_expert_sql() local
13941 rc = idxPrepareStmt(p->db, &pStmt, pzErr, zStmt); in sqlite3_expert_sql()
13943 sqlite3_finalize(pStmt); in sqlite3_expert_sql()
13944 rc = sqlite3_prepare_v2(p->dbv, zStmt, -1, &pStmt, &zStmt); in sqlite3_expert_sql()
13946 if( pStmt ){ in sqlite3_expert_sql()
13948 const char *z = sqlite3_sql(pStmt); in sqlite3_expert_sql()
13958 sqlite3_finalize(pStmt); in sqlite3_expert_sql()
14031 IdxStatement *pStmt; in sqlite3_expert_report() local
14034 for(pStmt=p->pStatement; pStmt && pStmt->iId!=iStmt; pStmt=pStmt->pNext); in sqlite3_expert_report()
14037 if( pStmt ) zRet = pStmt->zSql; in sqlite3_expert_report()
14040 if( pStmt ) zRet = pStmt->zIdx; in sqlite3_expert_report()
14043 if( pStmt ) zRet = pStmt->zEQP; in sqlite3_expert_report()
14365 static void intckFinalize(sqlite3_intck *p, sqlite3_stmt *pStmt){ in intckFinalize() argument
14366 int rc = sqlite3_finalize(pStmt); in intckFinalize()
14376 static int intckStep(sqlite3_intck *p, sqlite3_stmt *pStmt){ in intckStep() argument
14378 return sqlite3_step(pStmt); in intckStep()
14387 sqlite3_stmt *pStmt = 0; in intckExec() local
14388 pStmt = intckPrepare(p, zSql); in intckExec()
14389 intckStep(p, pStmt); in intckExec()
14390 intckFinalize(p, pStmt); in intckExec()
14421 sqlite3_stmt *pStmt = 0; in intckSaveKey() local
14498 pStmt = intckPrepare(p, zSql); in intckSaveKey()
14501 sqlite3_bind_value(pStmt, ii+1, sqlite3_column_value(p->pCheck, ii+1)); in intckSaveKey()
14503 if( SQLITE_ROW==sqlite3_step(pStmt) ){ in intckSaveKey()
14504 p->zKey = intckMprintf(p,"%s",(const char*)sqlite3_column_text(pStmt, 0)); in intckSaveKey()
14506 intckFinalize(p, pStmt); in intckSaveKey()
14519 sqlite3_stmt *pStmt = 0; in intckFindObject() local
14526 pStmt = intckPrepareFmt(p, in intckFindObject()
14540 sqlite3_bind_text(pStmt, 1, zPrev, -1, SQLITE_TRANSIENT); in intckFindObject()
14541 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in intckFindObject()
14542 p->zObj = intckMprintf(p,"%s",(const char*)sqlite3_column_text(pStmt, 0)); in intckFindObject()
14545 intckFinalize(p, pStmt); in intckFindObject()
14718 sqlite3_stmt *pStmt = 0; in intckGetAutoIndex() local
14719 pStmt = intckPrepare(p, "PRAGMA automatic_index"); in intckGetAutoIndex()
14720 if( SQLITE_ROW==intckStep(p, pStmt) ){ in intckGetAutoIndex()
14721 bRet = sqlite3_column_int(pStmt, 0); in intckGetAutoIndex()
14723 intckFinalize(p, pStmt); in intckGetAutoIndex()
14732 sqlite3_stmt *pStmt = 0; in intckIsIndex() local
14733 pStmt = intckPrepareFmt(p, in intckIsIndex()
14737 if( p->rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(pStmt) ){ in intckIsIndex()
14740 intckFinalize(p, pStmt); in intckIsIndex()
14761 sqlite3_stmt *pStmt = 0; in intckCheckObjectSql() local
14878 pStmt = intckPrepareFmt(p, in intckCheckObjectSql()
14932 pStmt = intckPrepareFmt(p, in intckCheckObjectSql()
15012 while( p->rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(pStmt) ){ in intckCheckObjectSql()
15013 zRet = intckMprintf(p, "%s", (const char*)sqlite3_column_text(pStmt, 0)); in intckCheckObjectSql()
15015 *pnKeyVal = sqlite3_column_int(pStmt, 1); in intckCheckObjectSql()
15018 intckFinalize(p, pStmt); in intckCheckObjectSql()
15554 sqlite3_stmt *pStmt; /* For fetching database pages */ member
15581 sqlite3_stmt *pStmt; /* For fetching database pages */ member
15675 sqlite3_finalize(pTab->pStmt); in dbdataDisconnect()
15765 if( pTab->pStmt==0 ){ in dbdataResetCursor()
15766 pTab->pStmt = pCsr->pStmt; in dbdataResetCursor()
15768 sqlite3_finalize(pCsr->pStmt); in dbdataResetCursor()
15770 pCsr->pStmt = 0; in dbdataResetCursor()
15822 sqlite3_stmt *pStmt = pCsr->pStmt; in dbdataLoadPage() local
15827 sqlite3_bind_int64(pStmt, 2, pgno); in dbdataLoadPage()
15828 if( SQLITE_ROW==sqlite3_step(pStmt) ){ in dbdataLoadPage()
15829 int nCopy = sqlite3_column_bytes(pStmt, 0); in dbdataLoadPage()
15836 const u8 *pCopy = sqlite3_column_blob(pStmt, 0); in dbdataLoadPage()
15844 rc2 = sqlite3_reset(pStmt); in dbdataLoadPage()
16247 sqlite3_stmt *pStmt = 0; in dbdataDbsize() local
16256 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pStmt, 0); in dbdataDbsize()
16258 if( rc==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in dbdataDbsize()
16259 pCsr->szDb = sqlite3_column_int(pStmt, 0); in dbdataDbsize()
16261 rc2 = sqlite3_finalize(pStmt); in dbdataDbsize()
16314 if( pTab->pStmt ){ in dbdataFilter()
16315 pCsr->pStmt = pTab->pStmt; in dbdataFilter()
16316 pTab->pStmt = 0; in dbdataFilter()
16322 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pCsr->pStmt, 0); in dbdataFilter()
16328 &pCsr->pStmt, 0 in dbdataFilter()
16333 rc = sqlite3_bind_text(pCsr->pStmt, 1, zSchema, -1, SQLITE_TRANSIENT); in dbdataFilter()
16921 sqlite3_stmt *pStmt = 0; in recoverPrepare() local
16923 if( sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0) ){ in recoverPrepare()
16927 return pStmt; in recoverPrepare()
16946 sqlite3_stmt *pStmt = 0; in recoverPreparePrintf() local
16956 pStmt = recoverPrepare(p, db, z); in recoverPreparePrintf()
16960 return pStmt; in recoverPreparePrintf()
16972 static sqlite3_stmt *recoverReset(sqlite3_recover *p, sqlite3_stmt *pStmt){ in recoverReset() argument
16973 int rc = sqlite3_reset(pStmt); in recoverReset()
16975 recoverDbError(p, sqlite3_db_handle(pStmt)); in recoverReset()
16977 return pStmt; in recoverReset()
16986 static void recoverFinalize(sqlite3_recover *p, sqlite3_stmt *pStmt){ in recoverFinalize() argument
16987 sqlite3 *db = sqlite3_db_handle(pStmt); in recoverFinalize()
16988 int rc = sqlite3_finalize(pStmt); in recoverFinalize()
17020 sqlite3_stmt *pStmt, in recoverBindValue() argument
17025 int rc = sqlite3_bind_value(pStmt, iBind, pVal); in recoverBindValue()
17071 sqlite3_stmt *pStmt = 0; in recoverPageCount() local
17072 pStmt = recoverPreparePrintf(p, p->dbIn, "PRAGMA %Q.page_count", p->zDb); in recoverPageCount()
17073 if( pStmt ){ in recoverPageCount()
17074 sqlite3_step(pStmt); in recoverPageCount()
17075 nPg = sqlite3_column_int64(pStmt, 0); in recoverPageCount()
17077 recoverFinalize(p, pStmt); in recoverPageCount()
17158 sqlite3_stmt *pStmt = 0; in recoverGetPage() local
17167 pStmt = p->pGetPage = recoverPreparePrintf( in recoverGetPage()
17171 pStmt = p->pGetPage; in recoverGetPage()
17174 if( pStmt ){ in recoverGetPage()
17175 sqlite3_bind_int64(pStmt, 1, pgno); in recoverGetPage()
17176 if( SQLITE_ROW==sqlite3_step(pStmt) ){ in recoverGetPage()
17180 aPg = sqlite3_column_blob(pStmt, 0); in recoverGetPage()
17181 nPg = sqlite3_column_bytes(pStmt, 0); in recoverGetPage()
17187 recoverReset(p, pStmt); in recoverGetPage()
17514 sqlite3_stmt *pStmt = recoverPreparePrintf(p, p->dbOut, in recoverAddTable() local
17518 if( pStmt ){ in recoverAddTable()
17525 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in recoverAddTable()
17527 nByte += (sqlite3_column_bytes(pStmt, 1)+1); in recoverAddTable()
17530 recoverReset(p, pStmt); in recoverAddTable()
17544 for(i=0; sqlite3_step(pStmt)==SQLITE_ROW; i++){ in recoverAddTable()
17545 int iPKF = sqlite3_column_int(pStmt, 5); in recoverAddTable()
17546 int n = sqlite3_column_bytes(pStmt, 1); in recoverAddTable()
17547 const char *z = (const char*)sqlite3_column_text(pStmt, 1); in recoverAddTable()
17548 const char *zType = (const char*)sqlite3_column_text(pStmt, 2); in recoverAddTable()
17549 int eHidden = sqlite3_column_int(pStmt, 6); in recoverAddTable()
17574 recoverFinalize(p, pStmt); in recoverAddTable()
17576 pStmt = recoverPreparePrintf(p, p->dbOut, "PRAGMA index_xinfo(%Q)", zName); in recoverAddTable()
17577 while( pStmt && sqlite3_step(pStmt)==SQLITE_ROW ){ in recoverAddTable()
17578 int iField = sqlite3_column_int(pStmt, 0); in recoverAddTable()
17579 int iCol = sqlite3_column_int(pStmt, 1); in recoverAddTable()
17587 recoverFinalize(p, pStmt); in recoverAddTable()
18319 sqlite3_stmt *pStmt = 0; in recoverLostAndFound1Init() local
18329 pStmt = recoverPrepare( in recoverLostAndFound1Init()
18359 if( pStmt ) sqlite3_bind_int(pStmt, 1, p->bFreelistCorrupt); in recoverLostAndFound1Init()
18360 pLaf->pUsedPages = pStmt; in recoverLostAndFound1Init()
19453 sqlite3_stmt *pStmt; /* Current statement if any. */ member
20570 if( i==iIndent && p->aiIndent && p->pStmt ){ in shell_callback()
20752 double r = sqlite3_column_double(p->pStmt, i); in shell_callback()
20768 }else if( aiType && aiType[i]==SQLITE_BLOB && p->pStmt ){ in shell_callback()
20769 const void *pBlob = sqlite3_column_blob(p->pStmt, i); in shell_callback()
20770 int nBlob = sqlite3_column_bytes(p->pStmt, i); in shell_callback()
20798 double r = sqlite3_column_double(p->pStmt, i); in shell_callback()
20809 }else if( aiType && aiType[i]==SQLITE_BLOB && p->pStmt ){ in shell_callback()
20810 const void *pBlob = sqlite3_column_blob(p->pStmt, i); in shell_callback()
20811 int nBlob = sqlite3_column_bytes(p->pStmt, i); in shell_callback()
20845 double r = sqlite3_column_double(p->pStmt, i); in shell_callback()
20848 }else if( aiType && aiType[i]==SQLITE_BLOB && p->pStmt ){ in shell_callback()
20849 const void *pBlob = sqlite3_column_blob(p->pStmt, i); in shell_callback()
20850 int nBlob = sqlite3_column_bytes(p->pStmt, i); in shell_callback()
21186 if( pArg->pStmt && pArg->statsOn==2 ){ in display_stats()
21188 sqlite3_stmt *pStmt = pArg->pStmt; in display_stats() local
21190 nCol = sqlite3_column_count(pStmt); in display_stats()
21194 oputf("%-36s %s\n", z, sqlite3_column_name(pStmt,i)); in display_stats()
21197 oputf("%-36s %s\n", z, sqlite3_column_decltype(pStmt, i)); in display_stats()
21201 oputf("%-36s %s\n", z, sqlite3_column_database_name(pStmt,i)); in display_stats()
21203 oputf("%-36s %s\n", z, sqlite3_column_table_name(pStmt,i)); in display_stats()
21205 oputf("%-36s %s\n", z, sqlite3_column_origin_name(pStmt,i)); in display_stats()
21211 if( pArg->pStmt ){ in display_stats()
21212 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_VM_STEP,bReset); in display_stats()
21276 if( pArg->pStmt ){ in display_stats()
21278 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_FULLSCAN_STEP, in display_stats()
21281 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_SORT, bReset); in display_stats()
21283 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_AUTOINDEX,bReset); in display_stats()
21285 iHit = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_FILTER_HIT, in display_stats()
21287 iMiss = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_FILTER_MISS, in display_stats()
21292 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_VM_STEP, bReset); in display_stats()
21294 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_REPREPARE,bReset); in display_stats()
21296 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_RUN, bReset); in display_stats()
21298 iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_MEMUSED, bReset); in display_stats()
21346 sqlite3_stmt *p = pArg->pStmt; in display_explain_scanstats()
21544 sqlite3_stmt *pStmt = 0; in display_scanstats()
21545 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in display_scanstats()
21547 sqlite3_stmt *pSave = pArg->pStmt; in display_scanstats()
21548 pArg->pStmt = pStmt; in display_scanstats()
21549 sqlite3_bind_pointer(pStmt, 1, pSave, "stmt-pointer", 0); in display_scanstats()
21553 explain_data_prepare(pArg, pStmt); in display_scanstats()
21554 exec_prepared_stmt(pArg, pStmt); in display_scanstats()
21557 sqlite3_finalize(pStmt); in display_scanstats()
21558 pArg->pStmt = pSave; in display_scanstats()
21613 static void bind_prepared_stmt(ShellState *pArg, sqlite3_stmt *pStmt){ in bind_prepared_stmt() argument
21619 nVar = sqlite3_bind_parameter_count(pStmt); in bind_prepared_stmt()
21632 const char *zVar = sqlite3_bind_parameter_name(pStmt, i); in bind_prepared_stmt()
21639 sqlite3_bind_value(pStmt, i, sqlite3_column_value(pQ, 0)); in bind_prepared_stmt()
21642 sqlite3_bind_double(pStmt, i, NAN); in bind_prepared_stmt()
21646 sqlite3_bind_double(pStmt, i, INFINITY); in bind_prepared_stmt()
21649 sqlite3_bind_null(pStmt, i); in bind_prepared_stmt()
21821 static char *quoted_column(sqlite3_stmt *pStmt, int i){ in quoted_column() argument
21822 switch( sqlite3_column_type(pStmt, i) ){ in quoted_column()
21828 return sqlite3_mprintf("%s",sqlite3_column_text(pStmt,i)); in quoted_column()
21831 return sqlite3_mprintf("%Q",sqlite3_column_text(pStmt,i)); in quoted_column()
21836 const unsigned char *a = sqlite3_column_blob(pStmt,i); in quoted_column()
21837 int n = sqlite3_column_bytes(pStmt,i); in quoted_column()
21861 sqlite3_stmt *pStmt /* Statement to run */ in exec_prepared_stmt_columnar() argument
21883 rc = sqlite3_step(pStmt); in exec_prepared_stmt_columnar()
21885 nColumn = sqlite3_column_count(pStmt); in exec_prepared_stmt_columnar()
21921 uz = (const unsigned char*)sqlite3_column_name(pStmt,i); in exec_prepared_stmt_columnar()
21948 azQuoted[i] = quoted_column(pStmt,i); in exec_prepared_stmt_columnar()
21951 uz = (const unsigned char*)sqlite3_column_text(pStmt,i); in exec_prepared_stmt_columnar()
21962 }while( bNextLine || sqlite3_step(pStmt)==SQLITE_ROW ); in exec_prepared_stmt_columnar()
22087 sqlite3_stmt *pStmt /* Statement to run */ in exec_prepared_stmt() argument
22097 exec_prepared_stmt_columnar(pArg, pStmt); in exec_prepared_stmt()
22104 rc = sqlite3_step(pStmt); in exec_prepared_stmt()
22108 int nCol = sqlite3_column_count(pStmt); in exec_prepared_stmt()
22120 azCols[i] = (char *)sqlite3_column_name(pStmt, i); in exec_prepared_stmt()
22126 aiTypes[i] = x = sqlite3_column_type(pStmt, i); in exec_prepared_stmt()
22133 azVals[i] = (char*)sqlite3_column_text(pStmt, i); in exec_prepared_stmt()
22147 rc = sqlite3_step(pStmt); in exec_prepared_stmt()
22309 sqlite3_stmt *pStmt = NULL; /* Statement to execute. */ in shell_exec() local
22328 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover); in shell_exec()
22334 if( !pStmt ){ in shell_exec()
22340 zStmtSql = sqlite3_sql(pStmt); in shell_exec()
22346 pArg->pStmt = pStmt; in shell_exec()
22351 if( pArg && pArg->autoEQP && sqlite3_stmt_isexplain(pStmt)==0 ){ in shell_exec()
22359 pExplain = pStmt; in shell_exec()
22388 sqlite3_reset(pStmt); in shell_exec()
22389 sqlite3_stmt_explain(pStmt, 0); in shell_exec()
22394 int bIsExplain = (sqlite3_stmt_isexplain(pStmt)==1); in shell_exec()
22400 if( sqlite3_stmt_isexplain(pStmt)==2 ){ in shell_exec()
22408 explain_data_prepare(pArg, pStmt); in shell_exec()
22412 bind_prepared_stmt(pArg, pStmt); in shell_exec()
22413 exec_prepared_stmt(pArg, pStmt); in shell_exec()
22430 rc2 = sqlite3_finalize(pStmt); in shell_exec()
22441 pArg->pStmt = NULL; in shell_exec()
22476 sqlite3_stmt *pStmt; in tableColumnList() local
22487 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in tableColumnList()
22490 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in tableColumnList()
22496 azCol[++nCol] = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 1)); in tableColumnList()
22498 if( sqlite3_column_int(pStmt, 5) ){ in tableColumnList()
22501 && sqlite3_stricmp((const char*)sqlite3_column_text(pStmt,2), in tableColumnList()
22510 sqlite3_finalize(pStmt); in tableColumnList()
22532 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in tableColumnList()
22538 rc = sqlite3_step(pStmt); in tableColumnList()
22539 sqlite3_finalize(pStmt); in tableColumnList()
22569 sqlite3_stmt *pStmt = 0; in toggleSelectOrder() local
22572 sqlite3_prepare_v2(db, "PRAGMA reverse_unordered_selects", -1, &pStmt, 0); in toggleSelectOrder()
22573 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in toggleSelectOrder()
22574 iSetting = sqlite3_column_int(pStmt, 0); in toggleSelectOrder()
22576 sqlite3_finalize(pStmt); in toggleSelectOrder()
23597 static sqlite3_stmt *pStmt = 0; in readline_completion_generator() local
23601 sqlite3_finalize(pStmt); in readline_completion_generator()
23605 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0); in readline_completion_generator()
23608 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in readline_completion_generator()
23609 const char *z = (const char*)sqlite3_column_text(pStmt,0); in readline_completion_generator()
23612 sqlite3_finalize(pStmt); in readline_completion_generator()
23613 pStmt = 0; in readline_completion_generator()
23632 sqlite3_stmt *pStmt = 0; in linenoise_completion() local
23646 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0); in linenoise_completion()
23649 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in linenoise_completion()
23650 const char *zCompletion = (const char*)sqlite3_column_text(pStmt, 0); in linenoise_completion()
23651 int nCompletion = sqlite3_column_bytes(pStmt, 0); in linenoise_completion()
23657 sqlite3_finalize(pStmt); in linenoise_completion()
23804 sqlite3_stmt *pStmt; in sql_trace_callback() local
23815 pStmt = (sqlite3_stmt*)pP; in sql_trace_callback()
23818 zSql = sqlite3_expanded_sql(pStmt); in sql_trace_callback()
23823 zSql = sqlite3_normalized_sql(pStmt); in sql_trace_callback()
23828 zSql = sqlite3_sql(pStmt); in sql_trace_callback()
24310 sqlite3_stmt *pStmt; in db_int() local
24312 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in db_int()
24313 if( pStmt && sqlite3_step(pStmt)==SQLITE_ROW ){ in db_int()
24314 res = sqlite3_column_int(pStmt,0); in db_int()
24316 sqlite3_finalize(pStmt); in db_int()
24367 sqlite3_stmt *pStmt = 0; in shell_dbinfo_command() local
24373 -1, &pStmt, 0); in shell_dbinfo_command()
24376 sqlite3_finalize(pStmt); in shell_dbinfo_command()
24379 sqlite3_bind_text(pStmt, 1, zDb, -1, SQLITE_STATIC); in shell_dbinfo_command()
24380 if( sqlite3_step(pStmt)==SQLITE_ROW in shell_dbinfo_command()
24381 && sqlite3_column_bytes(pStmt,0)>100 in shell_dbinfo_command()
24383 const u8 *pb = sqlite3_column_blob(pStmt,0); in shell_dbinfo_command()
24386 sqlite3_finalize(pStmt); in shell_dbinfo_command()
24389 sqlite3_finalize(pStmt); in shell_dbinfo_command()
24902 sqlite3_stmt *pStmt in shellFinalize() argument
24904 if( pStmt ){ in shellFinalize()
24905 sqlite3 *db = sqlite3_db_handle(pStmt); in shellFinalize()
24906 int rc = sqlite3_finalize(pStmt); in shellFinalize()
24925 sqlite3_stmt *pStmt in shellReset() argument
24927 int rc = sqlite3_reset(pStmt); in shellReset()
24930 sqlite3 *db = sqlite3_db_handle(pStmt); in shellReset()
25945 sqlite3_stmt *pStmt = 0; in zAutoColumn() local
25961 rc = sqlite3_prepare_v2(*pDb, zTabFill, -1, &pStmt, 0); in zAutoColumn()
25963 rc = sqlite3_bind_text(pStmt, 1, zColNew, -1, 0); in zAutoColumn()
25965 rc = sqlite3_step(pStmt); in zAutoColumn()
25967 sqlite3_finalize(pStmt); in zAutoColumn()
25983 rc = sqlite3_prepare_v2(*pDb, zRenameRank, -1, &pStmt, 0); in zAutoColumn()
25985 sqlite3_bind_int(pStmt, 1, nDigits); in zAutoColumn()
25986 rc = sqlite3_step(pStmt); in zAutoColumn()
25987 sqlite3_finalize(pStmt); in zAutoColumn()
25991 rc = sqlite3_prepare_v2(*pDb, zCollectVar, -1, &pStmt, 0); in zAutoColumn()
25993 rc = sqlite3_step(pStmt); in zAutoColumn()
25995 zColsSpec = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0)); in zAutoColumn()
26002 sqlite3_finalize(pStmt); in zAutoColumn()
26003 if( SQLITE_OK==sqlite3_prepare_v2(*pDb, zRenamesDone, -1, &pStmt, 0) in zAutoColumn()
26004 && SQLITE_ROW==sqlite3_step(pStmt) ){ in zAutoColumn()
26005 *pzRenamed = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0)); in zAutoColumn()
26010 sqlite3_finalize(pStmt); in zAutoColumn()
26027 sqlite3_stmt *pStmt = 0; in outputDumpWarning() local
26028 shellPreparePrintf(p->db, &rc, &pStmt, in outputDumpWarning()
26032 if( rc==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in outputDumpWarning()
26037 shellFinalize(&rc, pStmt); in outputDumpWarning()
26392 sqlite3_stmt *pStmt; in do_meta_command() local
26395 rc = sqlite3_prepare_v2(p->db, "PRAGMA database_list", -1, &pStmt, 0); in do_meta_command()
26400 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
26401 const char *zSchema = (const char *)sqlite3_column_text(pStmt,1); in do_meta_command()
26402 const char *zFile = (const char*)sqlite3_column_text(pStmt,2); in do_meta_command()
26411 sqlite3_finalize(pStmt); in do_meta_command()
26848 sqlite3_stmt *pStmt; in do_meta_command() local
26852 -1, &pStmt, 0); in do_meta_command()
26854 doStats = sqlite3_step(pStmt)==SQLITE_ROW; in do_meta_command()
26855 sqlite3_finalize(pStmt); in do_meta_command()
26897 sqlite3_stmt *pStmt = NULL; /* A statement */ in do_meta_command() local
27087 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
27091 if (pStmt) sqlite3_finalize(pStmt); in do_meta_command()
27097 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
27098 nCol = sqlite3_column_int(pStmt, 0); in do_meta_command()
27102 sqlite3_finalize(pStmt); in do_meta_command()
27103 pStmt = 0; in do_meta_command()
27132 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
27137 if (pStmt) sqlite3_finalize(pStmt); in do_meta_command()
27167 sqlite3_bind_text(pStmt, i+1, z, -1, SQLITE_TRANSIENT); in do_meta_command()
27173 while( i<=nCol ){ sqlite3_bind_null(pStmt, i); i++; } in do_meta_command()
27185 sqlite3_step(pStmt); in do_meta_command()
27186 rc = sqlite3_reset(pStmt); in do_meta_command()
27198 sqlite3_finalize(pStmt); in do_meta_command()
27211 sqlite3_stmt *pStmt; in do_meta_command() local
27249 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
27251 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
27252 tnum = sqlite3_column_int(pStmt, 0); in do_meta_command()
27253 isWO = sqlite3_column_int(pStmt, 1); in do_meta_command()
27255 sqlite3_finalize(pStmt); in do_meta_command()
27257 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
27260 while( rc==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
27262 const char *zCol = (const char*)sqlite3_column_text(pStmt,2); in do_meta_command()
27265 if( sqlite3_column_int(pStmt,1)==-1 ){ in do_meta_command()
27272 if( isWO && lenPK==0 && sqlite3_column_int(pStmt,5)==0 && zCollist ){ in do_meta_command()
27281 sqlite3_finalize(pStmt); in do_meta_command()
27828 sqlite3_stmt *pStmt = 0; in do_meta_command() local
27833 "FROM temp.sqlite_parameters;", -1, &pStmt, 0); in do_meta_command()
27834 if( rx==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
27835 len = sqlite3_column_int(pStmt, 0); in do_meta_command()
27838 sqlite3_finalize(pStmt); in do_meta_command()
27839 pStmt = 0; in do_meta_command()
27843 "FROM temp.sqlite_parameters;", -1, &pStmt, 0); in do_meta_command()
27844 while( rx==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
27845 oputf("%-*s %s\n", len, sqlite3_column_text(pStmt,0), in do_meta_command()
27846 sqlite3_column_text(pStmt,1)); in do_meta_command()
27848 sqlite3_finalize(pStmt); in do_meta_command()
27869 sqlite3_stmt *pStmt; in do_meta_command() local
27877 pStmt = 0; in do_meta_command()
27878 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
27881 sqlite3_finalize(pStmt); in do_meta_command()
27882 pStmt = 0; in do_meta_command()
27887 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
27891 sqlite3_finalize(pStmt); in do_meta_command()
27892 pStmt = 0; in do_meta_command()
27896 sqlite3_step(pStmt); in do_meta_command()
27897 sqlite3_finalize(pStmt); in do_meta_command()
28163 sqlite3_stmt *pStmt = 0; in do_meta_command() local
28165 -1, &pStmt, 0); in do_meta_command()
28168 sqlite3_finalize(pStmt); in do_meta_command()
28174 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
28175 const char *zDb = (const char*)sqlite3_column_text(pStmt, 0); in do_meta_command()
28194 sqlite3_finalize(pStmt); in do_meta_command()
28481 sqlite3_stmt *pStmt = 0; /* Query against the SELFTEST table */ in do_meta_command() local
28516 -1, &pStmt, 0); in do_meta_command()
28521 -1, &pStmt, 0); in do_meta_command()
28526 sqlite3_finalize(pStmt); in do_meta_command()
28529 for(i=1; sqlite3_step(pStmt)==SQLITE_ROW; i++){ in do_meta_command()
28530 int tno = sqlite3_column_int(pStmt, 0); in do_meta_command()
28531 const char *zOp = (const char*)sqlite3_column_text(pStmt, 1); in do_meta_command()
28532 const char *zSql = (const char*)sqlite3_column_text(pStmt, 2); in do_meta_command()
28533 const char *zAns = (const char*)sqlite3_column_text(pStmt, 3); in do_meta_command()
28572 sqlite3_finalize(pStmt); in do_meta_command()
28600 sqlite3_stmt *pStmt; /* For querying tables names */ in do_meta_command() local
28649 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
28654 while( SQLITE_ROW==sqlite3_step(pStmt) ){ in do_meta_command()
28655 const char *zTab = (const char*)sqlite3_column_text(pStmt,0); in do_meta_command()
28683 sqlite3_finalize(pStmt); in do_meta_command()
28732 lrc = sqlite3_prepare_v2(p->db, zRevText, -1, &pStmt, 0); in do_meta_command()
28738 if( zLike ) sqlite3_bind_text(pStmt,1,zLike,-1,SQLITE_STATIC); in do_meta_command()
28739 lrc = SQLITE_ROW==sqlite3_step(pStmt); in do_meta_command()
28741 const char *zGenQuery = (char*)sqlite3_column_text(pStmt,0); in do_meta_command()
28758 sqlite3_finalize(pStmt); in do_meta_command()
28867 sqlite3_stmt *pStmt; in do_meta_command() local
28874 rc = sqlite3_prepare_v2(p->db, "PRAGMA database_list", -1, &pStmt, 0); in do_meta_command()
28876 sqlite3_finalize(pStmt); in do_meta_command()
28886 sqlite3_finalize(pStmt); in do_meta_command()
28889 for(ii=0; sqlite3_step(pStmt)==SQLITE_ROW; ii++){ in do_meta_command()
28890 const char *zDbName = (const char*)sqlite3_column_text(pStmt, 1); in do_meta_command()
28911 rc = sqlite3_finalize(pStmt); in do_meta_command()
28914 rc = sqlite3_prepare_v2(p->db, s.z, -1, &pStmt, 0); in do_meta_command()
28924 sqlite3_bind_text(pStmt, 1, azArg[1], -1, SQLITE_TRANSIENT); in do_meta_command()
28926 sqlite3_bind_text(pStmt, 1, "%", -1, SQLITE_STATIC); in do_meta_command()
28928 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in do_meta_command()
28937 azResult[nRow] = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0)); in do_meta_command()
28941 if( sqlite3_finalize(pStmt)!=SQLITE_OK ){ in do_meta_command()
29750 sqlite3_stmt *pStmt = 0; in doAutoDetectRestore() local
29753 shellPrepare(p->db, &rc, zQuery, &pStmt); in doAutoDetectRestore()
29754 if( rc==SQLITE_OK && sqlite3_step(pStmt)==SQLITE_ROW ){ in doAutoDetectRestore()
29757 shellFinalize(&rc, pStmt); in doAutoDetectRestore()