1 /* 2 ** This utility program decodes and displays the content of the 3 ** sqlite_stat4 table in the database file named on the command 4 ** line. 5 */ 6 #include <stdio.h> 7 #include <string.h> 8 #include <stdlib.h> 9 #include <ctype.h> 10 #include "sqlite3.h" 11 12 #define ISPRINT(X) isprint((unsigned char)(X)) 13 14 typedef sqlite3_int64 i64; /* 64-bit signed integer type */ 15 16 17 /* 18 ** Convert the var-int format into i64. Return the number of bytes 19 ** in the var-int. Write the var-int value into *pVal. 20 */ 21 static int decodeVarint(const unsigned char *z, i64 *pVal){ 22 i64 v = 0; 23 int i; 24 for(i=0; i<8; i++){ 25 v = (v<<7) + (z[i]&0x7f); 26 if( (z[i]&0x80)==0 ){ *pVal = v; return i+1; } 27 } 28 v = (v<<8) + (z[i]&0xff); 29 *pVal = v; 30 return 9; 31 } 32 33 34 35 int main(int argc, char **argv){ 36 sqlite3 *db; 37 sqlite3_stmt *pStmt; 38 char *zIdx = 0; 39 int rc, j, x, y, mxHdr; 40 const unsigned char *aSample; 41 int nSample; 42 i64 iVal; 43 const char *zSep; 44 int iRow = 0; 45 46 if( argc!=2 ){ 47 fprintf(stderr, "Usage: %s DATABASE-FILE\n", argv[0]); 48 exit(1); 49 } 50 rc = sqlite3_open(argv[1], &db); 51 if( rc!=SQLITE_OK || db==0 ){ 52 fprintf(stderr, "Cannot open database file [%s]\n", argv[1]); 53 exit(1); 54 } 55 rc = sqlite3_prepare_v2(db, 56 "SELECT tbl||'.'||idx, nEq, nLT, nDLt, sample " 57 "FROM sqlite_stat4 ORDER BY 1", -1, 58 &pStmt, 0); 59 if( rc!=SQLITE_OK || pStmt==0 ){ 60 fprintf(stderr, "%s\n", sqlite3_errmsg(db)); 61 sqlite3_close(db); 62 exit(1); 63 } 64 while( SQLITE_ROW==sqlite3_step(pStmt) ){ 65 if( zIdx==0 || strcmp(zIdx, (const char*)sqlite3_column_text(pStmt,0))!=0 ){ 66 if( zIdx ) printf("\n**************************************" 67 "**************\n\n"); 68 sqlite3_free(zIdx); 69 zIdx = sqlite3_mprintf("%s", sqlite3_column_text(pStmt,0)); 70 iRow = 0; 71 } 72 printf("%s sample %d ------------------------------------\n", zIdx, ++iRow); 73 printf(" nEq = %s\n", sqlite3_column_text(pStmt,1)); 74 printf(" nLt = %s\n", sqlite3_column_text(pStmt,2)); 75 printf(" nDLt = %s\n", sqlite3_column_text(pStmt,3)); 76 printf(" sample = x'"); 77 aSample = sqlite3_column_blob(pStmt,4); 78 nSample = sqlite3_column_bytes(pStmt,4); 79 for(j=0; j<nSample; j++) printf("%02x", aSample[j]); 80 printf("'\n "); 81 zSep = " "; 82 x = decodeVarint(aSample, &iVal); 83 if( iVal<x || iVal>nSample ){ 84 printf(" <error>\n"); 85 continue; 86 } 87 y = mxHdr = (int)iVal; 88 while( x<mxHdr ){ 89 int sz; 90 i64 v; 91 x += decodeVarint(aSample+x, &iVal); 92 if( x>mxHdr ) break; 93 if( iVal<0 ) break; 94 switch( iVal ){ 95 case 0: sz = 0; break; 96 case 1: sz = 1; break; 97 case 2: sz = 2; break; 98 case 3: sz = 3; break; 99 case 4: sz = 4; break; 100 case 5: sz = 6; break; 101 case 6: sz = 8; break; 102 case 7: sz = 8; break; 103 case 8: sz = 0; break; 104 case 9: sz = 0; break; 105 case 10: 106 case 11: sz = 0; break; 107 default: sz = (int)(iVal-12)/2; break; 108 } 109 if( y+sz>nSample ) break; 110 if( iVal==0 ){ 111 printf("%sNULL", zSep); 112 }else if( iVal==8 || iVal==9 ){ 113 printf("%s%d", zSep, ((int)iVal)-8); 114 }else if( iVal<=7 ){ 115 v = (signed char)aSample[y]; 116 for(j=1; j<sz; j++){ 117 v = (v<<8) + aSample[y+j]; 118 } 119 if( iVal==7 ){ 120 double r; 121 memcpy(&r, &v, sizeof(r)); 122 printf("%s%#g", zSep, r); 123 }else{ 124 printf("%s%lld", zSep, v); 125 } 126 }else if( (iVal&1)==0 ){ 127 printf("%sx'", zSep); 128 for(j=0; j<sz; j++){ 129 printf("%02x", aSample[y+j]); 130 } 131 printf("'"); 132 }else{ 133 printf("%s\"", zSep); 134 for(j=0; j<sz; j++){ 135 char c = (char)aSample[y+j]; 136 if( ISPRINT(c) ){ 137 if( c=='"' || c=='\\' ) putchar('\\'); 138 putchar(c); 139 }else if( c=='\n' ){ 140 printf("\\n"); 141 }else if( c=='\t' ){ 142 printf("\\t"); 143 }else if( c=='\r' ){ 144 printf("\\r"); 145 }else{ 146 printf("\\%03o", c); 147 } 148 } 149 printf("\""); 150 } 151 zSep = ","; 152 y += sz; 153 } 154 printf("\n"); 155 } 156 sqlite3_free(zIdx); 157 sqlite3_finalize(pStmt); 158 sqlite3_close(db); 159 return 0; 160 } 161