Lines Matching refs:pStmt
389 sqlite3_stmt *pStmt; in statMain() local
418 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in statMain()
421 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in statMain()
422 printf("Number of entries: %8d\n", sqlite3_column_int(pStmt, 0)); in statMain()
423 printf("Average value size: %8d\n", sqlite3_column_int(pStmt, 3)); in statMain()
424 printf("Minimum value size: %8d\n", sqlite3_column_int(pStmt, 1)); in statMain()
425 printf("Maximum value size: %8d\n", sqlite3_column_int(pStmt, 2)); in statMain()
429 sqlite3_finalize(pStmt); in statMain()
431 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in statMain()
434 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in statMain()
435 printf("Page-size: %8d\n", sqlite3_column_int(pStmt, 0)); in statMain()
437 sqlite3_finalize(pStmt); in statMain()
439 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in statMain()
442 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in statMain()
443 printf("Page-count: %8d\n", sqlite3_column_int(pStmt, 0)); in statMain()
445 sqlite3_finalize(pStmt); in statMain()
447 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in statMain()
450 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in statMain()
451 printf("Freelist-count: %8d\n", sqlite3_column_int(pStmt, 0)); in statMain()
453 sqlite3_finalize(pStmt); in statMain()
454 rc = sqlite3_prepare_v2(db, "PRAGMA integrity_check(10)", -1, &pStmt, 0); in statMain()
456 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in statMain()
457 printf("Integrity-check: %s\n", sqlite3_column_text(pStmt, 0)); in statMain()
459 sqlite3_finalize(pStmt); in statMain()
502 sqlite3_stmt *pStmt; in exportMain() local
536 rc = sqlite3_prepare_v2(db, "SELECT k, v FROM kv ORDER BY k", -1, &pStmt, 0); in exportMain()
546 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in exportMain()
547 int iKey = sqlite3_column_int(pStmt, 0); in exportMain()
548 sqlite3_int64 nData = sqlite3_column_bytes(pStmt, 1); in exportMain()
549 const void *pData = sqlite3_column_blob(pStmt, 1); in exportMain()
570 sqlite3_finalize(pStmt); in exportMain()
806 sqlite3_stmt *pStmt = 0; /* Prepared statement for SQL access */ in runMain() local
930 pStmt = 0; in runMain()
931 sqlite3_prepare_v2(db, "PRAGMA page_size", -1, &pStmt, 0); in runMain()
932 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in runMain()
933 iPagesize = sqlite3_column_int(pStmt, 0); in runMain()
935 sqlite3_finalize(pStmt); in runMain()
936 sqlite3_prepare_v2(db, "PRAGMA cache_size", -1, &pStmt, 0); in runMain()
937 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in runMain()
938 iCache = sqlite3_column_int(pStmt, 0); in runMain()
942 sqlite3_finalize(pStmt); in runMain()
943 pStmt = 0; in runMain()
952 sqlite3_prepare_v2(db, "PRAGMA journal_mode", -1, &pStmt, 0); in runMain()
953 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in runMain()
954 zJMode = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0)); in runMain()
958 sqlite3_finalize(pStmt); in runMain()
960 sqlite3_prepare_v2(db, "SELECT max(k) FROM kv", -1, &pStmt, 0); in runMain()
961 if( sqlite3_step(pStmt)==SQLITE_ROW ){ in runMain()
962 iMax = sqlite3_column_int(pStmt, 0); in runMain()
964 sqlite3_finalize(pStmt); in runMain()
966 pStmt = 0; in runMain()
1024 if( pStmt==0 ){ in runMain()
1031 " WHERE k=?1", -1, &pStmt, 0); in runMain()
1032 sqlite3_bind_int64(pStmt, 2, SQLITE_PTR_TO_INT(&nData)); in runMain()
1035 "SELECT v FROM kv WHERE k=?1", -1, &pStmt, 0); in runMain()
1041 sqlite3_reset(pStmt); in runMain()
1043 sqlite3_bind_int(pStmt, 1, iKey); in runMain()
1045 rc = sqlite3_step(pStmt); in runMain()
1047 nData = sqlite3_column_bytes(pStmt, 0); in runMain()
1048 pData = (unsigned char*)sqlite3_column_blob(pStmt, 0); in runMain()
1064 if( pStmt ) sqlite3_finalize(pStmt); in runMain()
1088 sqlite3_prepare_v2(db, "PRAGMA integrity_check", -1, &pStmt, 0); in runMain()
1089 while( sqlite3_step(pStmt)==SQLITE_ROW ){ in runMain()
1090 printf("integrity-check: %s\n", sqlite3_column_text(pStmt, 0)); in runMain()
1092 sqlite3_finalize(pStmt); in runMain()