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 */
decodeVarint(const unsigned char * z,i64 * pVal)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
main(int argc,char ** argv)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 char *z;
122 memcpy(&r, &v, sizeof(r));
123 z = sqlite3_mprintf("%s%!.15g", zSep, r);
124 printf("%s", z);
125 sqlite3_free(z);
126 }else{
127 printf("%s%lld", zSep, v);
128 }
129 }else if( (iVal&1)==0 ){
130 printf("%sx'", zSep);
131 for(j=0; j<sz; j++){
132 printf("%02x", aSample[y+j]);
133 }
134 printf("'");
135 }else{
136 printf("%s'", zSep);
137 for(j=0; j<sz; j++){
138 char c = (char)aSample[y+j];
139 if( ISPRINT(c) ){
140 if( c=='\'' || c=='\\' ) putchar('\\');
141 putchar(c);
142 }else if( c=='\n' ){
143 printf("\\n");
144 }else if( c=='\t' ){
145 printf("\\t");
146 }else if( c=='\r' ){
147 printf("\\r");
148 }else{
149 printf("\\%03o", c);
150 }
151 }
152 printf("'");
153 }
154 zSep = ",";
155 y += sz;
156 }
157 printf("\n");
158 }
159 sqlite3_free(zIdx);
160 sqlite3_finalize(pStmt);
161 sqlite3_close(db);
162 return 0;
163 }
164