showjournal.c revision 2
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail#pragma ident "%Z%%M% %I% %E% SMI"
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail/*
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail** A utility for printing an SQLite database journal.
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail*/
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail#include <stdio.h>
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail#include <ctype.h>
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail#include <sys/types.h>
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail#include <sys/stat.h>
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail#include <fcntl.h>
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail#include <unistd.h>
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail#include <stdlib.h>
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbailstatic int pagesize = 1024;
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbailstatic int db = -1;
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbailstatic int mxPage = 0;
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbailstatic void out_of_memory(void){
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail fprintf(stderr,"Out of memory...\n");
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail exit(1);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail}
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbailstatic print_page(int iPg){
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail unsigned char *aData;
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail int i, j;
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail aData = malloc(pagesize);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail if( aData==0 ) out_of_memory();
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail read(db, aData, pagesize);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail fprintf(stdout, "Page %d:\n", iPg);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail for(i=0; i<pagesize; i += 16){
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail fprintf(stdout, " %03x: ",i);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail for(j=0; j<16; j++){
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail fprintf(stdout,"%02x ", aData[i+j]);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail }
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail for(j=0; j<16; j++){
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail fprintf(stdout,"%c", isprint(aData[i+j]) ? aData[i+j] : '.');
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail }
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail fprintf(stdout,"\n");
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail }
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail free(aData);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail}
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbailint main(int argc, char **argv){
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail struct stat sbuf;
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail unsigned int u;
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail int rc;
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail unsigned char zBuf[10];
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail unsigned char zBuf2[sizeof(u)];
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail if( argc!=2 ){
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail fprintf(stderr,"Usage: %s FILENAME\n", argv[0]);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail exit(1);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail }
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail db = open(argv[1], O_RDONLY);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail if( db<0 ){
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail fprintf(stderr,"%s: can't open %s\n", argv[0], argv[1]);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail exit(1);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail }
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail read(db, zBuf, 8);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail if( zBuf[7]==0xd6 ){
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail read(db, &u, sizeof(u));
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail printf("Records in Journal: %u\n", u);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail read(db, &u, sizeof(u));
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail printf("Magic Number: 0x%08x\n", u);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail }
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail read(db, zBuf2, sizeof(zBuf2));
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail u = zBuf2[0]<<24 | zBuf2[1]<<16 | zBuf2[2]<<8 | zBuf2[3];
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail printf("Database Size: %u\n", u);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail while( read(db, zBuf2, sizeof(zBuf2))==sizeof(zBuf2) ){
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail u = zBuf2[0]<<24 | zBuf2[1]<<16 | zBuf2[2]<<8 | zBuf2[3];
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail print_page(u);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail if( zBuf[7]==0xd6 ){
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail read(db, &u, sizeof(u));
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail printf("Checksum: 0x%08x\n", u);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail }
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail }
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail close(db);
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail}
6e91bba0d6c6bdabbba62cefae583715a4a58e2aGirish Moodalbail