Import SQLite 3.10.2.

third_party/sqlite/src/tool/showstat4.c

 /*
 ** This utility program decodes and displays the content of the
 ** sqlite_stat4 table in the database file named on the command
 ** line.
 */
 #include <stdio.h>
 #include <string.h>
 #include <stdlib.h>
 #include <ctype.h>
 #include "sqlite3.h"
 
+#define ISPRINT(X)  isprint((unsigned char)(X))
+
 typedef sqlite3_int64 i64;   /* 64-bit signed integer type */
 
 
 /*
 ** Convert the var-int format into i64.  Return the number of bytes
 ** in the var-int.  Write the var-int value into *pVal.
 */
 static int decodeVarint(const unsigned char *z, i64 *pVal){
   i64 v = 0;
   int i;
@@ skipping 10 matching lines @@
 
 int main(int argc, char **argv){
   sqlite3 *db;
   sqlite3_stmt *pStmt;
   char *zIdx = 0;
   int rc, j, x, y, mxHdr;
   const unsigned char *aSample;
   int nSample;
   i64 iVal;
   const char *zSep;
+  int iRow = 0;
 
   if( argc!=2 ){
     fprintf(stderr, "Usage: %s DATABASE-FILE\n", argv[0]);
     exit(1);
   }
   rc = sqlite3_open(argv[1], &db);
   if( rc!=SQLITE_OK || db==0 ){
     fprintf(stderr, "Cannot open database file [%s]\n", argv[1]);
     exit(1);
   }
   rc = sqlite3_prepare_v2(db,
         "SELECT tbl||'.'||idx, nEq, nLT, nDLt, sample "
         "FROM sqlite_stat4 ORDER BY 1", -1,
         &pStmt, 0);
   if( rc!=SQLITE_OK || pStmt==0 ){
     fprintf(stderr, "%s\n", sqlite3_errmsg(db));
     sqlite3_close(db);
     exit(1);
   }
   while( SQLITE_ROW==sqlite3_step(pStmt) ){
     if( zIdx==0 || strcmp(zIdx, (const char*)sqlite3_column_text(pStmt,0))!=0 ){
-      if( zIdx ) printf("\n");
+      if( zIdx ) printf("\n**************************************"
+                        "**************\n\n");
       sqlite3_free(zIdx);
       zIdx = sqlite3_mprintf("%s", sqlite3_column_text(pStmt,0));
-      printf("%s:\n", zIdx);
-    }else{
-      printf("  -----------------------------------------------------------\n");
+      iRow = 0;
     }
+    printf("%s sample %d ------------------------------------\n", zIdx, ++iRow);
     printf("  nEq    = %s\n", sqlite3_column_text(pStmt,1));
     printf("  nLt    = %s\n", sqlite3_column_text(pStmt,2));
     printf("  nDLt   = %s\n", sqlite3_column_text(pStmt,3));
     printf("  sample = x'");
     aSample = sqlite3_column_blob(pStmt,4);
     nSample = sqlite3_column_bytes(pStmt,4);
     for(j=0; j<nSample; j++) printf("%02x", aSample[j]);
     printf("'\n          ");
     zSep = " ";
     x = decodeVarint(aSample, &iVal);
@@ skipping 43 matching lines @@
       }else if( (iVal&1)==0 ){
         printf("%sx'", zSep);
         for(j=0; j<sz; j++){
           printf("%02x", aSample[y+j]);
         }
         printf("'");
       }else{
         printf("%s\"", zSep);
         for(j=0; j<sz; j++){
           char c = (char)aSample[y+j];
-          if( isprint(c) ){
+          if( ISPRINT(c) ){
             if( c=='"' || c=='\\' ) putchar('\\');
             putchar(c);
           }else if( c=='\n' ){
             printf("\\n");
           }else if( c=='\t' ){
             printf("\\t");
           }else if( c=='\r' ){
             printf("\\r");
           }else{
             printf("\\%03o", c);
           }
         }
         printf("\"");
       }
       zSep = ",";
       y += sz;
     }
     printf("\n");
   }
   sqlite3_free(zIdx);
   sqlite3_finalize(pStmt);
   sqlite3_close(db);
   return 0;
 }