| OLD | NEW |
|---|
| (Empty) |
| 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 } | |
| OLD | NEW |
|---|
Chromium Code Reviews
Issue 2846743003:
[sql] Remove SQLite 3.10.2 reference directory. (Closed)
