1
2#pragma ident	"%Z%%M%	%I%	%E% SMI"
3
4/*
5** A utility for printing all or part of an SQLite database file.
6*/
7#include <stdio.h>
8#include <ctype.h>
9#include <sys/types.h>
10#include <sys/stat.h>
11#include <fcntl.h>
12#include <unistd.h>
13#include <stdlib.h>
14
15
16static int pagesize = 1024;
17static int db = -1;
18static int mxPage = 0;
19
20static void out_of_memory(void){
21  fprintf(stderr,"Out of memory...\n");
22  exit(1);
23}
24
25static print_page(int iPg){
26  unsigned char *aData;
27  int i, j;
28  aData = malloc(pagesize);
29  if( aData==0 ) out_of_memory();
30  lseek(db, (iPg-1)*pagesize, SEEK_SET);
31  read(db, aData, pagesize);
32  fprintf(stdout, "Page %d:\n", iPg);
33  for(i=0; i<pagesize; i += 16){
34    fprintf(stdout, " %03x: ",i);
35    for(j=0; j<16; j++){
36      fprintf(stdout,"%02x ", aData[i+j]);
37    }
38    for(j=0; j<16; j++){
39      fprintf(stdout,"%c", isprint(aData[i+j]) ? aData[i+j] : '.');
40    }
41    fprintf(stdout,"\n");
42  }
43  free(aData);
44}
45
46int main(int argc, char **argv){
47  struct stat sbuf;
48  if( argc<2 ){
49    fprintf(stderr,"Usage: %s FILENAME ?PAGE? ...\n", argv[0]);
50    exit(1);
51  }
52  db = open(argv[1], O_RDONLY);
53  if( db<0 ){
54    fprintf(stderr,"%s: can't open %s\n", argv[0], argv[1]);
55    exit(1);
56  }
57  fstat(db, &sbuf);
58  mxPage = sbuf.st_size/pagesize + 1;
59  if( argc==2 ){
60    int i;
61    for(i=1; i<=mxPage; i++) print_page(i);
62  }else{
63    int i;
64    for(i=2; i<argc; i++){
65      int iStart, iEnd;
66      char *zLeft;
67      iStart = strtol(argv[i], &zLeft, 0);
68      if( zLeft && strcmp(zLeft,"..end")==0 ){
69        iEnd = mxPage;
70      }else if( zLeft && zLeft[0]=='.' && zLeft[1]=='.' ){
71        iEnd = strtol(&zLeft[2], 0, 0);
72      }else{
73        iEnd = iStart;
74      }
75      if( iStart<1 || iEnd<iStart || iEnd>mxPage ){
76        fprintf(stderr,
77          "Page argument should be LOWER?..UPPER?.  Range 1 to %d\n",
78          mxPage);
79        exit(1);
80      }
81      while( iStart<=iEnd ){
82        print_page(iStart);
83        iStart++;
84      }
85    }
86  }
87  close(db);
88}
89