Lines Matching refs:pStmt
514 sqlite3_stmt *pStmt; in blobListLoadFromDb() local
524 rc = sqlite3_prepare_v2(db, z2, -1, &pStmt, 0); in blobListLoadFromDb()
529 while( SQLITE_ROW==sqlite3_step(pStmt) ){ in blobListLoadFromDb()
530 int sz = sqlite3_column_bytes(pStmt, 1); in blobListLoadFromDb()
532 pNew->id = sqlite3_column_int(pStmt, 0); in blobListLoadFromDb()
536 memcpy(pNew->a, sqlite3_column_blob(pStmt,1), sz); in blobListLoadFromDb()
541 sqlite3_finalize(pStmt); in blobListLoadFromDb()
976 sqlite3_stmt *pStmt, /* Test statement stopped on an SQLITE_ROW */
1033 sqlite3_stmt *pStmt; in runDbSql() local
1042 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in runDbSql()
1045 while( (rc = sqlite3_step(pStmt))==SQLITE_ROW ){ in runDbSql()
1049 for(j=0; j<sqlite3_column_count(pStmt); j++){ in runDbSql()
1051 switch( sqlite3_column_type(pStmt, j) ){ in runDbSql()
1058 printf("%s", sqlite3_column_text(pStmt, j)); in runDbSql()
1062 int n = sqlite3_column_bytes(pStmt, j); in runDbSql()
1065 a = (const unsigned char*)sqlite3_column_blob(pStmt, j); in runDbSql()
1074 int n = sqlite3_column_bytes(pStmt, j); in runDbSql()
1077 a = (const unsigned char*)sqlite3_column_blob(pStmt, j); in runDbSql()
1097 && !sqlite3_stmt_isexplain(pStmt) in runDbSql()
1101 sqlite3_reset(pStmt); in runDbSql()
1102 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in runDbSql()
1106 rc = fuzz_invariant(db, pStmt, iCnt, iRow, nRow, in runDbSql()
1128 return sqlite3_finalize(pStmt); in runDbSql()
1563 sqlite3_stmt *pStmt; in runSql() local
1567 pStmt = 0; in runSql()
1568 sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zMore); in runSql()
1577 if( pStmt==0 ){ in runSql()
1584 if( pStmt ){ in runSql()
1586 while( SQLITE_ROW==sqlite3_step(pStmt) ){} in runSql()
1589 while( SQLITE_ROW==sqlite3_step(pStmt) ){ in runSql()
1592 nCol = sqlite3_column_count(pStmt); in runSql()
1597 int eType = sqlite3_column_type(pStmt,i); in runSql()
1598 printf("%s = ", sqlite3_column_name(pStmt,i)); in runSql()
1605 printf("INT %s\n", sqlite3_column_text(pStmt,i)); in runSql()
1609 printf("FLOAT %s\n", sqlite3_column_text(pStmt,i)); in runSql()
1613 printf("TEXT [%s]\n", sqlite3_column_text(pStmt,i)); in runSql()
1617 printf("BLOB (%d bytes)\n", sqlite3_column_bytes(pStmt,i)); in runSql()
1624 sqlite3_finalize(pStmt); in runSql()
1781 sqlite3_stmt *pStmt; /* A prepared statement */ in main() local
2038 sqlite3_prepare_v2(db, "SELECT msg FROM readme", -1, &pStmt, 0); in main()
2039 if( pStmt && sqlite3_step(pStmt)==SQLITE_ROW ){ in main()
2040 printf("%s: %s", zDbName, sqlite3_column_text(pStmt,0)); in main()
2044 sqlite3_finalize(pStmt); in main()
2045 sqlite3_prepare_v2(db, "SELECT count(*) FROM db", -1, &pStmt, 0); in main()
2046 if( pStmt in main()
2047 && sqlite3_step(pStmt)==SQLITE_ROW in main()
2048 && (n = sqlite3_column_int(pStmt,0))>0 in main()
2052 sqlite3_finalize(pStmt); in main()
2053 sqlite3_prepare_v2(db, "SELECT count(*) FROM xsql", -1, &pStmt, 0); in main()
2054 if( pStmt in main()
2055 && sqlite3_step(pStmt)==SQLITE_ROW in main()
2056 && (n = sqlite3_column_int(pStmt,0))>0 in main()
2060 sqlite3_finalize(pStmt); in main()
2090 rc = sqlite3_prepare_v2(db, zInsSql, -1, &pStmt, 0); in main()
2093 sqlite3_bind_text(pStmt, 1, zRawData, nRawData, SQLITE_STATIC); in main()
2094 sqlite3_step(pStmt); in main()
2095 rc = sqlite3_reset(pStmt); in main()
2097 sqlite3_finalize(pStmt); in main()
2109 -1, &pStmt, 0); in main()
2112 while( SQLITE_ROW==sqlite3_step(pStmt) ){ in main()
2113 const char *zName = (const char *)sqlite3_column_text(pStmt,0); in main()
2116 ossFuzzThisDb = sqlite3_column_int(pStmt,1); in main()
2120 nMemThisDb = sqlite3_column_int(pStmt,1); in main()
2124 sqlite3_finalize(pStmt); in main()
2134 rc = sqlite3_prepare_v2(db, zInsSql, -1, &pStmt, 0); in main()
2146 sqlite3_bind_text(pStmt, 1, zLine, (int)kk, SQLITE_STATIC); in main()
2148 sqlite3_step(pStmt); in main()
2149 rc = sqlite3_reset(pStmt); in main()
2153 sqlite3_bind_text(pStmt, 1, argv[i], -1, SQLITE_STATIC); in main()
2155 sqlite3_step(pStmt); in main()
2156 rc = sqlite3_reset(pStmt); in main()
2160 sqlite3_finalize(pStmt); in main()
2178 rc = sqlite3_prepare_v2(db, zExDb, -1, &pStmt, 0); in main()
2181 sqlite3_bind_text64(pStmt, 1, zExpDb, strlen(zExpDb), in main()
2183 sqlite3_bind_int(pStmt, 2, onlyDbid); in main()
2184 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in main()
2186 sqlite3_column_int(pStmt,1), in main()
2187 sqlite3_column_int(pStmt,3), in main()
2188 sqlite3_column_text(pStmt,2)); in main()
2190 sqlite3_finalize(pStmt); in main()
2197 rc = sqlite3_prepare_v2(db, zExSql, -1, &pStmt, 0); in main()
2200 sqlite3_bind_text64(pStmt, 1, zExpSql, strlen(zExpSql), in main()
2202 sqlite3_bind_int(pStmt, 2, onlySqlid); in main()
2203 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in main()
2205 sqlite3_column_int(pStmt,1), in main()
2206 sqlite3_column_int(pStmt,3), in main()
2207 sqlite3_column_text(pStmt,2)); in main()
2209 sqlite3_finalize(pStmt); in main()
2238 sqlite3_prepare_v2(db, "SELECT msg FROM readme", -1, &pStmt, 0); in main()
2239 if( pStmt && sqlite3_step(pStmt)==SQLITE_ROW ){ in main()
2240 printf("%s: %s\n", zDbName, sqlite3_column_text(pStmt,0)); in main()
2242 sqlite3_finalize(pStmt); in main()