| OLD | NEW |
| (Empty) |
| 1 /* | |
| 2 ** A utility for printing an SQLite database journal. | |
| 3 */ | |
| 4 #include <stdio.h> | |
| 5 #include <ctype.h> | |
| 6 #include <stdlib.h> | |
| 7 #include <string.h> | |
| 8 | |
| 9 /* | |
| 10 ** state information | |
| 11 */ | |
| 12 static int pageSize = 1024; | |
| 13 static int sectorSize = 512; | |
| 14 static FILE *db = 0; | |
| 15 static int fileSize = 0; | |
| 16 static unsigned cksumNonce = 0; | |
| 17 | |
| 18 /* Report a memory allocation error */ | |
| 19 static void out_of_memory(void){ | |
| 20 fprintf(stderr,"Out of memory...\n"); | |
| 21 exit(1); | |
| 22 } | |
| 23 | |
| 24 /* | |
| 25 ** Read N bytes of memory starting at iOfst into space obtained | |
| 26 ** from malloc(). | |
| 27 */ | |
| 28 static unsigned char *read_content(int N, int iOfst){ | |
| 29 int got; | |
| 30 unsigned char *pBuf = malloc(N); | |
| 31 if( pBuf==0 ) out_of_memory(); | |
| 32 fseek(db, iOfst, SEEK_SET); | |
| 33 got = fread(pBuf, 1, N, db); | |
| 34 if( got<0 ){ | |
| 35 fprintf(stderr, "I/O error reading %d bytes from %d\n", N, iOfst); | |
| 36 memset(pBuf, 0, N); | |
| 37 }else if( got<N ){ | |
| 38 fprintf(stderr, "Short read: got only %d of %d bytes from %d\n", | |
| 39 got, N, iOfst); | |
| 40 memset(&pBuf[got], 0, N-got); | |
| 41 } | |
| 42 return pBuf; | |
| 43 } | |
| 44 | |
| 45 /* Print a line of decode output showing a 4-byte integer. | |
| 46 */ | |
| 47 static unsigned print_decode_line( | |
| 48 const unsigned char *aData, /* Content being decoded */ | |
| 49 int ofst, int nByte, /* Start and size of decode */ | |
| 50 const char *zMsg /* Message to append */ | |
| 51 ){ | |
| 52 int i, j; | |
| 53 unsigned val = aData[ofst]; | |
| 54 char zBuf[100]; | |
| 55 sprintf(zBuf, " %05x: %02x", ofst, aData[ofst]); | |
| 56 i = strlen(zBuf); | |
| 57 for(j=1; j<4; j++){ | |
| 58 if( j>=nByte ){ | |
| 59 sprintf(&zBuf[i], " "); | |
| 60 }else{ | |
| 61 sprintf(&zBuf[i], " %02x", aData[ofst+j]); | |
| 62 val = val*256 + aData[ofst+j]; | |
| 63 } | |
| 64 i += strlen(&zBuf[i]); | |
| 65 } | |
| 66 sprintf(&zBuf[i], " %10u", val); | |
| 67 printf("%s %s\n", zBuf, zMsg); | |
| 68 return val; | |
| 69 } | |
| 70 | |
| 71 /* | |
| 72 ** Read and print a journal header. Store key information (page size, etc) | |
| 73 ** in global variables. | |
| 74 */ | |
| 75 static unsigned decode_journal_header(int iOfst){ | |
| 76 unsigned char *pHdr = read_content(64, iOfst); | |
| 77 unsigned nPage; | |
| 78 printf("Header at offset %d:\n", iOfst); | |
| 79 print_decode_line(pHdr, 0, 4, "Header part 1 (3654616569)"); | |
| 80 print_decode_line(pHdr, 4, 4, "Header part 2 (547447767)"); | |
| 81 nPage = | |
| 82 print_decode_line(pHdr, 8, 4, "page count"); | |
| 83 cksumNonce = | |
| 84 print_decode_line(pHdr, 12, 4, "chksum nonce"); | |
| 85 print_decode_line(pHdr, 16, 4, "initial database size in pages"); | |
| 86 sectorSize = | |
| 87 print_decode_line(pHdr, 20, 4, "sector size"); | |
| 88 pageSize = | |
| 89 print_decode_line(pHdr, 24, 4, "page size"); | |
| 90 print_decode_line(pHdr, 28, 4, "zero"); | |
| 91 print_decode_line(pHdr, 32, 4, "zero"); | |
| 92 print_decode_line(pHdr, 36, 4, "zero"); | |
| 93 print_decode_line(pHdr, 40, 4, "zero"); | |
| 94 free(pHdr); | |
| 95 return nPage; | |
| 96 } | |
| 97 | |
| 98 static void print_page(int iOfst){ | |
| 99 unsigned char *aData; | |
| 100 char zTitle[50]; | |
| 101 aData = read_content(pageSize+8, iOfst); | |
| 102 sprintf(zTitle, "page number for page at offset %d", iOfst); | |
| 103 print_decode_line(aData-iOfst, iOfst, 4, zTitle); | |
| 104 free(aData); | |
| 105 } | |
| 106 | |
| 107 int main(int argc, char **argv){ | |
| 108 int nPage, cnt; | |
| 109 int iOfst; | |
| 110 if( argc!=2 ){ | |
| 111 fprintf(stderr,"Usage: %s FILENAME\n", argv[0]); | |
| 112 exit(1); | |
| 113 } | |
| 114 db = fopen(argv[1], "rb"); | |
| 115 if( db==0 ){ | |
| 116 fprintf(stderr,"%s: can't open %s\n", argv[0], argv[1]); | |
| 117 exit(1); | |
| 118 } | |
| 119 fseek(db, 0, SEEK_END); | |
| 120 fileSize = ftell(db); | |
| 121 printf("journal file size: %d bytes\n", fileSize); | |
| 122 fseek(db, 0, SEEK_SET); | |
| 123 iOfst = 0; | |
| 124 while( iOfst<fileSize ){ | |
| 125 cnt = nPage = (int)decode_journal_header(iOfst); | |
| 126 if( cnt==0 ){ | |
| 127 cnt = (fileSize - sectorSize)/(pageSize+8); | |
| 128 } | |
| 129 iOfst += sectorSize; | |
| 130 while( cnt && iOfst<fileSize ){ | |
| 131 print_page(iOfst); | |
| 132 iOfst += pageSize+8; | |
| 133 } | |
| 134 iOfst = (iOfst/sectorSize + 1)*sectorSize; | |
| 135 } | |
| 136 fclose(db); | |
| 137 return 0; | |
| 138 } | |
| OLD | NEW |