# 2007 April 6

#

# The author disclaims copyright to this source code.  In place of

# a legal notice, here is a blessing:

#

#    May you do good and not evil.

#    May you find forgiveness for yourself and forgive others.

#    May you share freely, never taking more than you give.

#

#***********************************************************************

# This file implements regression tests for SQLite library.

#

# This file implements tests to verify database file format.

#

# $Id: filefmt.test,v 1.2 2007/04/06 21:42:22 drh Exp $

set testdir [file dirname $argv0]

source $testdir/tester.tcl

db close

file delete -force test.db test.db-journal

# Database begins with valid 16-byte header string.

#

do_test filefmt-1.1 {

  sqlite3 db test.db

  db eval {CREATE TABLE t1(x)}

  db close

  hexio_read test.db 0 16

} {53514C69746520666F726D6174203300}

# If the 16-byte header is changed, the file will not open

#

do_test filefmt-1.2 {

  hexio_write test.db 0 54

  set x [catch {sqlite3 db test.db} err]

  lappend x $err

} {0 {}}

do_test filefmt-1.3 {

  catchsql {

    SELECT count(*) FROM sqlite_master

  }

} {1 {file is encrypted or is not a database}}

do_test filefmt-1.4 {

  db close

  hexio_write test.db 0 53

  sqlite3 db test.db

  catchsql {

    SELECT count(*) FROM sqlite_master

  }

} {0 1}

# The page-size is stored at offset 16

#

ifcapable pager_pragmas {

  foreach pagesize {512 1024 2048 4096 8192 16384 32768} {

     if {[info exists SQLITE_MAX_PAGE_SIZE]

          && $pagesize>$SQLITE_MAX_PAGE_SIZE} continue

     do_test filefmt-1.5.$pagesize.1 {

       db close

       file delete -force test.db

       sqlite3 db test.db

       db eval "PRAGMA auto_vacuum=OFF"

       db eval "PRAGMA page_size=$pagesize"

       db eval {CREATE TABLE t1(x)}

       file size test.db

     } [expr $pagesize*2]

     do_test filefmt-1.5.$pagesize.2 {

       hexio_get_int [hexio_read test.db 16 2]

     } $pagesize

  }

}

# The page-size must be a power of 2

#

do_test filefmt-1.6 {

  db close

  hexio_write test.db 16 [hexio_render_int16 1025]

  sqlite3 db test.db

  catchsql {

     SELECT count(*) FROM sqlite_master

  }

} {1 {file is encrypted or is not a database}}

# The page-size must be at least 512 bytes

#

do_test filefmt-1.7 {

  db close

  hexio_write test.db 16 [hexio_render_int16 256]

  sqlite3 db test.db

  catchsql {

     SELECT count(*) FROM sqlite_master

  }

} {1 {file is encrypted or is not a database}}

# Usable space per page (page-size minus unused space per page)

# must be at least 500 bytes

#

ifcapable pager_pragmas {

  do_test filefmt-1.8 {

    db close

    file delete -force test.db

    sqlite3 db test.db

    db eval {PRAGMA page_size=512; CREATE TABLE t1(x)}

    db close

    hexio_write test.db 20 10

    sqlite3 db test.db

    catchsql {

       SELECT count(*) FROM sqlite_master

    }

  } {1 {file is encrypted or is not a database}}

}

finish_test