/*

** A utility for printing the differences between two SQLite database files.

*/

#include <stdio.h>

#include <ctype.h>

#include <sys/types.h>

#include <sys/stat.h>

#include <fcntl.h>

#include <unistd.h>

#include <stdlib.h>

#define PAGESIZE 1024

static int db1 = -1;

static int db2 = -1;

int main(int argc, char **argv){

int iPg;

unsigned char a1[PAGESIZE], a2[PAGESIZE];

if( argc!=3 ){

fprintf(stderr,"Usage: %s FILENAME FILENAME\n", argv[0]);

exit(1);

}

db1 = open(argv[1], O_RDONLY);

if( db1<0 ){

fprintf(stderr,"%s: can't open %s\n", argv[0], argv[1]);

exit(1);

}

db2 = open(argv[2], O_RDONLY);

if( db2<0 ){

fprintf(stderr,"%s: can't open %s\n", argv[0], argv[2]);

exit(1);

}

iPg = 1;

while( read(db1, a1, PAGESIZE)==PAGESIZE && read(db2,a2,PAGESIZE)==PAGESIZE ){

if( memcmp(a1,a2,PAGESIZE) ){

printf("Page %d\n", iPg);

}

iPg++;

}

printf("%d pages checked\n", iPg-1);

close(db1);

close(db2);

}