sl@0: # 2008 June 28
sl@0: #
sl@0: # The author disclaims copyright to this source code.  In place of
sl@0: # a legal notice, here is a blessing:
sl@0: #
sl@0: #    May you do good and not evil.
sl@0: #    May you find forgiveness for yourself and forgive others.
sl@0: #    May you share freely, never taking more than you give.
sl@0: #
sl@0: #***********************************************************************
sl@0: # This file implements regression tests for SQLite library.  The
sl@0: # focus of this script is database locks.
sl@0: #
sl@0: # $Id: lock5.test,v 1.3 2008/09/24 09:12:47 danielk1977 Exp $
sl@0: 
sl@0: set testdir [file dirname $argv0]
sl@0: source $testdir/tester.tcl
sl@0: 
sl@0: # This file is only run if using the unix backend compiled with the
sl@0: # SQLITE_ENABLE_LOCKING_STYLE macro.
sl@0: db close
sl@0: if {[catch {sqlite3 db test.db -vfs unix-none} msg]} {
sl@0:   finish_test
sl@0:   return
sl@0: }
sl@0: db close
sl@0: 
sl@0: do_test lock5-dotfile.1 {
sl@0:   sqlite3 db test.db -vfs unix-dotfile
sl@0:   execsql {
sl@0:     BEGIN;
sl@0:     CREATE TABLE t1(a, b);
sl@0:   }
sl@0: } {}
sl@0: 
sl@0: do_test lock5-dotfile.2 {
sl@0:   file exists test.db.lock
sl@0: } {1}
sl@0: 
sl@0: do_test lock5-dotfile.3 {
sl@0:   execsql COMMIT
sl@0:   file exists test.db.lock
sl@0: } {0}
sl@0: 
sl@0: do_test lock5-dotfile.4 {
sl@0:   sqlite3 db2 test.db -vfs unix-dotfile
sl@0:   execsql {
sl@0:     INSERT INTO t1 VALUES('a', 'b');
sl@0:     SELECT * FROM t1;
sl@0:   } db2
sl@0: } {a b}
sl@0: 
sl@0: do_test lock5-dotfile.5 {
sl@0:   execsql {
sl@0:     BEGIN;
sl@0:     SELECT * FROM t1;
sl@0:   } db2
sl@0: } {a b}
sl@0: 
sl@0: do_test lock5-dotfile.6 {
sl@0:   file exists test.db.lock
sl@0: } {1}
sl@0: 
sl@0: do_test lock5-dotfile.7 {
sl@0:   catchsql { SELECT * FROM t1; }
sl@0: } {1 {database is locked}}
sl@0: 
sl@0: do_test lock5-dotfile.8 {
sl@0:   execsql {
sl@0:     SELECT * FROM t1;
sl@0:     ROLLBACK;
sl@0:   } db2
sl@0: } {a b}
sl@0: 
sl@0: do_test lock5-dotfile.9 {
sl@0:   catchsql { SELECT * FROM t1; }
sl@0: } {0 {a b}}
sl@0: 
sl@0: do_test lock5-dotfile.10 {
sl@0:   file exists test.db.lock
sl@0: } {0}
sl@0: 
sl@0: do_test lock5-dotfile.X {
sl@0:   db2 close
sl@0:   execsql {BEGIN EXCLUSIVE}
sl@0:   db close
sl@0:   file exists test.db.lock
sl@0: } {0}
sl@0: 
sl@0: #####################################################################
sl@0: 
sl@0: file delete -force test.db
sl@0: 
sl@0: do_test lock5-flock.1 {
sl@0:   sqlite3 db test.db -vfs unix-flock
sl@0:   execsql {
sl@0:     CREATE TABLE t1(a, b);
sl@0:     BEGIN;
sl@0:     INSERT INTO t1 VALUES(1, 2);
sl@0:   }
sl@0: } {}
sl@0: 
sl@0: # Make sure we are not accidentally using the dotfile locking scheme.
sl@0: do_test lock5-flock.2 {
sl@0:   file exists test.db.lock
sl@0: } {0}
sl@0: 
sl@0: do_test lock5-flock.3 {
sl@0:   sqlite3 db2 test.db -vfs unix-flock
sl@0:   catchsql { SELECT * FROM t1 } db2
sl@0: } {1 {database is locked}}
sl@0: 
sl@0: do_test lock5-flock.4 {
sl@0:   execsql COMMIT
sl@0:   catchsql { SELECT * FROM t1 } db2
sl@0: } {0 {1 2}}
sl@0: 
sl@0: do_test lock5-flock.5 {
sl@0:   execsql BEGIN
sl@0:   catchsql { SELECT * FROM t1 } db2
sl@0: } {0 {1 2}}
sl@0: 
sl@0: do_test lock5-flock.6 {
sl@0:   execsql {SELECT * FROM t1}
sl@0:   catchsql { SELECT * FROM t1 } db2
sl@0: } {1 {database is locked}}
sl@0: 
sl@0: do_test lock5-flock.7 {
sl@0:   db close
sl@0:   catchsql { SELECT * FROM t1 } db2
sl@0: } {0 {1 2}}
sl@0: 
sl@0: do_test lock5-flock.8 {
sl@0:   db2 close
sl@0: } {}
sl@0: 
sl@0: #####################################################################
sl@0: 
sl@0: do_test lock5-none.1 {
sl@0:   sqlite3 db test.db -vfs unix-none
sl@0:   sqlite3 db2 test.db -vfs unix-none
sl@0:   execsql {
sl@0:     BEGIN;
sl@0:     INSERT INTO t1 VALUES(3, 4);
sl@0:   }
sl@0: } {}
sl@0: do_test lock5-none.2 {
sl@0:   execsql { SELECT * FROM t1 }
sl@0: } {1 2 3 4}
sl@0: do_test lock5-flock.3 {
sl@0:   execsql { SELECT * FROM t1 } db2
sl@0: } {1 2}
sl@0: do_test lock5-none.4 {
sl@0:   execsql { 
sl@0:     BEGIN;
sl@0:     SELECT * FROM t1;
sl@0:   } db2
sl@0: } {1 2}
sl@0: do_test lock5-none.5 {
sl@0:   execsql COMMIT
sl@0:   execsql {SELECT * FROM t1} db2
sl@0: } {1 2}
sl@0: 
sl@0: ifcapable memorymanage {
sl@0:   do_test lock5-none.6 {
sl@0:     sqlite3_release_memory 1000000
sl@0:     execsql {SELECT * FROM t1} db2
sl@0:   } {1 2 3 4}
sl@0: }
sl@0: 
sl@0: do_test lock5-flock.X {
sl@0:   db close
sl@0:   db2 close
sl@0: } {}
sl@0: 
sl@0: finish_test