SQLite4
Artifact Content
Not logged in

Artifact 56fe66dad473d8c22ffce1af72f474662863df4a:


# 2008 November 3
#
# 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.  The
# focus of this script is the response of COMMIT and ROLLBACK when
# statements are still pending.
#
# $Id: trans3.test,v 1.2 2008/11/05 16:37:35 drh Exp $
#
set testdir [file dirname $argv0]
source $testdir/tester.tcl
unset -nocomplain ecode

do_test trans3-1.1 {
  db eval {
    CREATE TABLE t1(x);
    INSERT INTO t1 VALUES(1);
    INSERT INTO t1 VALUES(2);
    INSERT INTO t1 VALUES(3);
    SELECT * FROM t1;
  }
} {1 2 3}
do_test trans3-1.2 {
  db eval BEGIN
  db eval {INSERT INTO t1 VALUES(4);}
  set ::ecode {}
  set x [catch {
     db eval {SELECT * FROM t1 LIMIT 1} {
        if {[catch {db eval COMMIT} errmsg]} {
           set ::ecode [sqlite4_extended_errcode db]
           error $errmsg
        }
     }
  } errmsg]
  lappend x $errmsg
} {0 {}}
do_test trans3-1.3 {
  set ::ecode
} {}
do_test trans3-1.3.1 {
  sqlite4_db_transaction_status db
} 0
do_test trans3-1.4 {
  db eval {SELECT * FROM t1}
} {1 2 3 4}
# do_test trans3-1.5 {
#   db eval BEGIN
#   db eval {INSERT INTO t1 VALUES(5);}
#   set ::ecode {}
#   set x [catch {
#      db eval {SELECT * FROM t1} {
#         if {[catch {db eval ROLLBACK} errmsg]} {
#            set ::ecode [sqlite4_errcode db]
#            error $errmsg
#         }
#      }
#   } errmsg]
#   lappend x $errmsg
# } {1 {cannot rollback transaction - SQL statements in progress}}
# do_test trans3-1.6 {
#   set ::ecode
# } {SQLITE4_BUSY}
# do_test trans3-1.7 {
#   db eval COMMIT
#   db eval {SELECT * FROM t1}
# } {1 2 3 4 5}
unset -nocomplain ecode

finish_test