diff options
Diffstat (limited to 'ext/sqlite/tests')
83 files changed, 0 insertions, 4392 deletions
diff --git a/ext/sqlite/tests/blankdb.inc b/ext/sqlite/tests/blankdb.inc deleted file mode 100644 index 43c6ff3582..0000000000 --- a/ext/sqlite/tests/blankdb.inc +++ /dev/null @@ -1,17 +0,0 @@ -<?php #vim:ft=php -$dbname = tempnam(dirname(__FILE__), "phpsql"); -function cleanup() { - $retry = 10; - - if (is_resource($GLOBALS['db'])) { - @sqlite_close($GLOBALS['db']); - } - do { - usleep(500000); - if (@unlink($GLOBALS['dbname'])) - break; - } while (file_exists($GLOBALS['dbname']) && --$retry); -} -register_shutdown_function("cleanup"); -$db = sqlite_open($dbname); -?> diff --git a/ext/sqlite/tests/blankdb_oo.inc b/ext/sqlite/tests/blankdb_oo.inc deleted file mode 100755 index 3bbf4fd0b3..0000000000 --- a/ext/sqlite/tests/blankdb_oo.inc +++ /dev/null @@ -1,11 +0,0 @@ -<?php #vim:ft=php -$dbname = tempnam(dirname(__FILE__), "phpsql"); -function cleanup() { - global $db, $dbname; - $db = NULL; - usleep(500000); - @unlink($dbname); -} -register_shutdown_function("cleanup"); -$db = new SQLiteDatabase($dbname); -?> diff --git a/ext/sqlite/tests/bug26911.phpt b/ext/sqlite/tests/bug26911.phpt deleted file mode 100644 index 74c2167722..0000000000 --- a/ext/sqlite/tests/bug26911.phpt +++ /dev/null @@ -1,12 +0,0 @@ ---TEST-- -Bug #26911 (crash when fetching data from empty queries) ---SKIPIF-- -<?php if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php - $db = sqlite_open(":memory:"); - $a = sqlite_query($db, " "); - echo "I am ok\n"; -?> ---EXPECT-- -I am ok diff --git a/ext/sqlite/tests/bug28112.phpt b/ext/sqlite/tests/bug28112.phpt deleted file mode 100755 index 05c8ff81f3..0000000000 --- a/ext/sqlite/tests/bug28112.phpt +++ /dev/null @@ -1,14 +0,0 @@ ---TEST-- -Bug #28112 (sqlite_query() crashing apache on malformed query) ---FILE-- -<?php - -if (!($db = sqlite_open(":memory:", 666, $error))) die ("Couldn't open the database"); -sqlite_query($db, "create table frob (foo INTEGER PRIMARY KEY, bar text);"); -$res = @sqlite_array_query($db, ""); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -===DONE=== diff --git a/ext/sqlite/tests/pdo/connection.inc b/ext/sqlite/tests/pdo/connection.inc deleted file mode 100755 index 3e0d4446c8..0000000000 --- a/ext/sqlite/tests/pdo/connection.inc +++ /dev/null @@ -1,7 +0,0 @@ -<?php - -$CONNECTION = 'sqlite2::memory:'; - -$PDO_TESTS = dirname(__FILE__) . '/../../../pdo/tests/'; - -?> diff --git a/ext/sqlite/tests/pdo/pdo_001.phpt b/ext/sqlite/tests/pdo/pdo_001.phpt deleted file mode 100755 index e07007b77a..0000000000 --- a/ext/sqlite/tests/pdo/pdo_001.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_ASSOC ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_001.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECT-- -array(3) { - [0]=> - array(2) { - ["id"]=> - string(1) "1" - ["val"]=> - string(1) "A" - } - [1]=> - array(2) { - ["id"]=> - string(1) "2" - ["val"]=> - string(1) "B" - } - [2]=> - array(2) { - ["id"]=> - string(1) "3" - ["val"]=> - string(1) "C" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_002.phpt b/ext/sqlite/tests/pdo/pdo_002.phpt deleted file mode 100755 index 3325320a32..0000000000 --- a/ext/sqlite/tests/pdo/pdo_002.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_NUM ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_002.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECT-- -array(3) { - [0]=> - array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "A" - } - [1]=> - array(2) { - [0]=> - string(1) "2" - [1]=> - string(1) "B" - } - [2]=> - array(2) { - [0]=> - string(1) "3" - [1]=> - string(1) "C" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_003.phpt b/ext/sqlite/tests/pdo/pdo_003.phpt deleted file mode 100755 index d96dbe80ad..0000000000 --- a/ext/sqlite/tests/pdo/pdo_003.phpt +++ /dev/null @@ -1,53 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_BOTH ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_003.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECT-- -array(3) { - [0]=> - array(4) { - ["id"]=> - string(1) "1" - [0]=> - string(1) "1" - ["val"]=> - string(1) "A" - [1]=> - string(1) "A" - } - [1]=> - array(4) { - ["id"]=> - string(1) "2" - [0]=> - string(1) "2" - ["val"]=> - string(1) "B" - [1]=> - string(1) "B" - } - [2]=> - array(4) { - ["id"]=> - string(1) "3" - [0]=> - string(1) "3" - ["val"]=> - string(1) "C" - [1]=> - string(1) "C" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_004.phpt b/ext/sqlite/tests/pdo/pdo_004.phpt deleted file mode 100755 index 2d7279b77b..0000000000 --- a/ext/sqlite/tests/pdo/pdo_004.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_OBJ ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_004.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -array(3) { - [0]=> - object(stdClass)#%d (2) { - ["id"]=> - string(1) "1" - ["val"]=> - string(1) "A" - } - [1]=> - object(stdClass)#%d (2) { - ["id"]=> - string(1) "2" - ["val"]=> - string(1) "B" - } - [2]=> - object(stdClass)#%d (2) { - ["id"]=> - string(1) "3" - ["val"]=> - string(1) "C" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_005.phpt b/ext/sqlite/tests/pdo/pdo_005.phpt deleted file mode 100755 index c8d57da3eb..0000000000 --- a/ext/sqlite/tests/pdo/pdo_005.phpt +++ /dev/null @@ -1,120 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_CLASS ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_005.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -array(3) { - [0]=> - object(stdClass)#%d (3) { - ["id"]=> - string(1) "1" - ["val"]=> - string(1) "A" - ["val2"]=> - string(2) "AA" - } - [1]=> - object(stdClass)#%d (3) { - ["id"]=> - string(1) "2" - ["val"]=> - string(1) "B" - ["val2"]=> - string(2) "BB" - } - [2]=> - object(stdClass)#%d (3) { - ["id"]=> - string(1) "3" - ["val"]=> - string(1) "C" - ["val2"]=> - string(2) "CC" - } -} -array(3) { - [0]=> - object(TestBase)#%d (3) { - ["id"]=> - string(1) "1" - ["val:protected"]=> - string(1) "A" - ["val2:private"]=> - string(2) "AA" - } - [1]=> - object(TestBase)#%d (3) { - ["id"]=> - string(1) "2" - ["val:protected"]=> - string(1) "B" - ["val2:private"]=> - string(2) "BB" - } - [2]=> - object(TestBase)#%d (3) { - ["id"]=> - string(1) "3" - ["val:protected"]=> - string(1) "C" - ["val2:private"]=> - string(2) "CC" - } -} -TestDerived::__construct(0,1) -TestDerived::__construct(1,2) -TestDerived::__construct(2,3) -array(3) { - [0]=> - object(TestDerived)#%d (5) { - ["row:protected"]=> - int(0) - ["id"]=> - string(1) "1" - ["val:protected"]=> - string(1) "A" - ["val2:private"]=> - NULL - ["val2"]=> - string(2) "AA" - } - [1]=> - object(TestDerived)#%d (5) { - ["row:protected"]=> - int(1) - ["id"]=> - string(1) "2" - ["val:protected"]=> - string(1) "B" - ["val2:private"]=> - NULL - ["val2"]=> - string(2) "BB" - } - [2]=> - object(TestDerived)#%d (5) { - ["row:protected"]=> - int(2) - ["id"]=> - string(1) "3" - ["val:protected"]=> - string(1) "C" - ["val2:private"]=> - NULL - ["val2"]=> - string(2) "CC" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_006.phpt b/ext/sqlite/tests/pdo/pdo_006.phpt deleted file mode 100755 index bcfd94aee9..0000000000 --- a/ext/sqlite/tests/pdo/pdo_006.phpt +++ /dev/null @@ -1,64 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_GROUP ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_006.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -array(2) { - ["A"]=> - array(2) { - [0]=> - array(1) { - [0]=> - string(1) "1" - } - [1]=> - array(1) { - [0]=> - string(1) "2" - } - } - ["C"]=> - array(1) { - [0]=> - array(1) { - [0]=> - string(1) "3" - } - } -} -array(2) { - ["A"]=> - array(2) { - [0]=> - array(1) { - ["id"]=> - string(1) "1" - } - [1]=> - array(1) { - ["id"]=> - string(1) "2" - } - } - ["C"]=> - array(1) { - [0]=> - array(1) { - ["id"]=> - string(1) "3" - } - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_007.phpt b/ext/sqlite/tests/pdo/pdo_007.phpt deleted file mode 100755 index f8c5060d08..0000000000 --- a/ext/sqlite/tests/pdo/pdo_007.phpt +++ /dev/null @@ -1,52 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_UNIQUE ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_007.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -array(3) { - ["A"]=> - array(1) { - [0]=> - string(1) "A" - } - ["B"]=> - array(1) { - [0]=> - string(1) "A" - } - ["C"]=> - array(1) { - [0]=> - string(1) "C" - } -} -array(3) { - ["A"]=> - array(1) { - ["val"]=> - string(1) "A" - } - ["B"]=> - array(1) { - ["val"]=> - string(1) "A" - } - ["C"]=> - array(1) { - ["val"]=> - string(1) "C" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_008.phpt b/ext/sqlite/tests/pdo/pdo_008.phpt deleted file mode 100755 index 466c5a28ca..0000000000 --- a/ext/sqlite/tests/pdo/pdo_008.phpt +++ /dev/null @@ -1,30 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_UNIQUE conflict ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_008.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -array(2) { - ["A"]=> - array(1) { - [0]=> - string(1) "B" - } - ["C"]=> - array(1) { - [0]=> - string(1) "C" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_009.phpt b/ext/sqlite/tests/pdo/pdo_009.phpt deleted file mode 100755 index e80805f646..0000000000 --- a/ext/sqlite/tests/pdo/pdo_009.phpt +++ /dev/null @@ -1,89 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_CLASSTYPE ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_009.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -array(4) { - [0]=> - array(3) { - [0]=> - string(8) "stdClass" - [1]=> - string(1) "1" - [2]=> - string(1) "A" - } - [1]=> - array(3) { - [0]=> - string(5) "Test1" - [1]=> - string(1) "2" - [2]=> - string(1) "B" - } - [2]=> - array(3) { - [0]=> - string(5) "Test2" - [1]=> - string(1) "3" - [2]=> - string(1) "C" - } - [3]=> - array(3) { - [0]=> - NULL - [1]=> - string(1) "4" - [2]=> - string(1) "D" - } -} -Test1::__construct() -Test2::__construct() -Test3::__construct() -array(4) { - [0]=> - object(stdClass)#%d (2) { - ["id"]=> - string(1) "1" - ["val"]=> - string(1) "A" - } - [1]=> - object(Test1)#%d (2) { - ["id"]=> - string(1) "2" - ["val"]=> - string(1) "B" - } - [2]=> - object(Test2)#%d (2) { - ["id"]=> - string(1) "3" - ["val"]=> - string(1) "C" - } - [3]=> - object(Test3)#%d (2) { - ["id"]=> - string(1) "4" - ["val"]=> - string(1) "D" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_010.phpt b/ext/sqlite/tests/pdo/pdo_010.phpt deleted file mode 100755 index 1f1e8d9b17..0000000000 --- a/ext/sqlite/tests/pdo/pdo_010.phpt +++ /dev/null @@ -1,76 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_(CLASSTYPE and GROUP/UNIQUE) ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_010.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -Test1::__construct() -Test2::__construct() -Test3::__construct() -array(2) { - ["Group1"]=> - array(2) { - [0]=> - object(stdClass)#%d (2) { - ["id"]=> - string(1) "1" - ["val"]=> - string(1) "A" - } - [1]=> - object(Test1)#%d (2) { - ["id"]=> - string(1) "2" - ["val"]=> - string(1) "B" - } - } - ["Group2"]=> - array(2) { - [0]=> - object(Test2)#%d (2) { - ["id"]=> - string(1) "3" - ["val"]=> - string(1) "C" - } - [1]=> - object(Test3)#%d (2) { - ["id"]=> - string(1) "4" - ["val"]=> - string(1) "D" - } - } -} -Test1::__construct() -Test2::__construct() -Test3::__construct() -array(2) { - ["Group1"]=> - object(Test1)#%d (2) { - ["id"]=> - string(1) "2" - ["val"]=> - string(1) "B" - } - ["Group2"]=> - object(Test3)#%d (2) { - ["id"]=> - string(1) "4" - ["val"]=> - string(1) "D" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_011.phpt b/ext/sqlite/tests/pdo/pdo_011.phpt deleted file mode 100755 index 5823defeb4..0000000000 --- a/ext/sqlite/tests/pdo/pdo_011.phpt +++ /dev/null @@ -1,181 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_FUNC and statement overloading ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_011.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -Test1::__construct(0,0) -test(1,N/A) -test(2,N/A) -test(3,N/A) -test(4,N/A) -array(2) { - ["Group1"]=> - array(2) { - [0]=> - array(1) { - [1]=> - string(3) "N/A" - } - [1]=> - array(1) { - [2]=> - string(3) "N/A" - } - } - ["Group2"]=> - array(2) { - [0]=> - array(1) { - [3]=> - string(3) "N/A" - } - [1]=> - array(1) { - [4]=> - string(3) "N/A" - } - } -} -test(1,A) -test(2,B) -test(3,C) -test(4,D) -array(4) { - [0]=> - array(1) { - [1]=> - string(1) "A" - } - [1]=> - array(1) { - [2]=> - string(1) "B" - } - [2]=> - array(1) { - [3]=> - string(1) "C" - } - [3]=> - array(1) { - [4]=> - string(1) "D" - } -} -Test1::factory(1,A) -Test1::__construct(1,A) -Test1::factory(2,B) -Test1::__construct(2,B) -Test1::factory(3,C) -Test1::__construct(3,C) -Test1::factory(4,D) -Test1::__construct(4,D) -array(4) { - [0]=> - object(Test1)#%d (2) { - ["id"]=> - string(1) "1" - ["val"]=> - string(1) "A" - } - [1]=> - object(Test1)#%d (2) { - ["id"]=> - string(1) "2" - ["val"]=> - string(1) "B" - } - [2]=> - object(Test1)#%d (2) { - ["id"]=> - string(1) "3" - ["val"]=> - string(1) "C" - } - [3]=> - object(Test1)#%d (2) { - ["id"]=> - string(1) "4" - ["val"]=> - string(1) "D" - } -} -Test1::factory(1,A) -Test1::__construct(1,A) -Test1::factory(2,B) -Test1::__construct(2,B) -Test1::factory(3,C) -Test1::__construct(3,C) -Test1::factory(4,D) -Test1::__construct(4,D) -array(4) { - [0]=> - object(Test1)#%d (2) { - ["id"]=> - string(1) "1" - ["val"]=> - string(1) "A" - } - [1]=> - object(Test1)#%d (2) { - ["id"]=> - string(1) "2" - ["val"]=> - string(1) "B" - } - [2]=> - object(Test1)#%d (2) { - ["id"]=> - string(1) "3" - ["val"]=> - string(1) "C" - } - [3]=> - object(Test1)#%d (2) { - ["id"]=> - string(1) "4" - ["val"]=> - string(1) "D" - } -} -DerivedStatement::__construct(Overloaded) -string(16) "DerivedStatement" -DerivedStatement::retrieve(1,A) -DerivedStatement::retrieve(2,B) -DerivedStatement::retrieve(3,C) -DerivedStatement::retrieve(4,D) -array(4) { - [0]=> - array(1) { - [1]=> - string(1) "A" - } - [1]=> - array(1) { - [2]=> - string(1) "B" - } - [2]=> - array(1) { - [3]=> - string(1) "C" - } - [3]=> - array(1) { - [4]=> - string(1) "D" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_012.phpt b/ext/sqlite/tests/pdo/pdo_012.phpt deleted file mode 100755 index ba62f5808a..0000000000 --- a/ext/sqlite/tests/pdo/pdo_012.phpt +++ /dev/null @@ -1,70 +0,0 @@ ---TEST-- -PDO_SQLite2: PDOStatement::setFetchMode ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_012.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -array(2) { - [0]=> - array(2) { - [0]=> - string(1) "A" - [1]=> - string(6) "Group1" - } - [1]=> - array(2) { - [0]=> - string(1) "B" - [1]=> - string(6) "Group2" - } -} -Test::__construct(N/A) -Test::__construct(N/A) -array(2) { - [0]=> - object(Test)#%d (2) { - ["val"]=> - string(1) "A" - ["grp"]=> - string(6) "Group1" - } - [1]=> - object(Test)#%d (2) { - ["val"]=> - string(1) "B" - ["grp"]=> - string(6) "Group2" - } -} -Test::__construct(Changed) -Test::__construct(Changed) -array(2) { - [0]=> - object(Test)#%d (2) { - ["val"]=> - string(1) "A" - ["grp"]=> - string(6) "Group1" - } - [1]=> - object(Test)#%d (2) { - ["val"]=> - string(1) "B" - ["grp"]=> - string(6) "Group2" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_013.phpt b/ext/sqlite/tests/pdo/pdo_013.phpt deleted file mode 100755 index df636efda6..0000000000 --- a/ext/sqlite/tests/pdo/pdo_013.phpt +++ /dev/null @@ -1,58 +0,0 @@ ---TEST-- -PDO_SQLite2: PDOStatement is Traversable ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_013.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -array(2) { - [0]=> - string(1) "A" - [1]=> - string(6) "Group1" -} -array(2) { - [0]=> - string(1) "B" - [1]=> - string(6) "Group2" -} -Test::__construct(N/A) -object(Test)#%d (2) { - ["val"]=> - string(1) "A" - ["grp"]=> - string(6) "Group1" -} -Test::__construct(N/A) -object(Test)#%d (2) { - ["val"]=> - string(1) "B" - ["grp"]=> - string(6) "Group2" -} -Test::__construct(WOW) -object(Test)#%d (2) { - ["val"]=> - string(1) "A" - ["grp"]=> - string(6) "Group1" -} -Test::__construct(WOW) -object(Test)#%d (2) { - ["val"]=> - string(1) "B" - ["grp"]=> - string(6) "Group2" -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_014.phpt b/ext/sqlite/tests/pdo/pdo_014.phpt deleted file mode 100755 index cdea0f8c27..0000000000 --- a/ext/sqlite/tests/pdo/pdo_014.phpt +++ /dev/null @@ -1,50 +0,0 @@ ---TEST-- -PDO_SQLite2: PDOStatement and SPL Iterators ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); -if (!extension_loaded('SPL')) die('skip SPL not available'); -?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_014.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -Test::__construct(WOW) -object(Test)#4 (2) { - ["val"]=> - string(1) "A" - ["grp"]=> - string(6) "Group1" -} -Test::__construct(WOW) -object(Test)#6 (2) { - ["val"]=> - string(1) "B" - ["grp"]=> - string(6) "Group2" -} -NULL -bool(false) -PDOStatementAggregate::__construct -PDOStatementAggregate::getIterator -array(2) { - [0]=> - string(1) "A" - [1]=> - string(6) "Group1" -} -array(2) { - [0]=> - string(1) "B" - [1]=> - string(6) "Group2" -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_015.phpt b/ext/sqlite/tests/pdo/pdo_015.phpt deleted file mode 100755 index c0e8d7ba64..0000000000 --- a/ext/sqlite/tests/pdo/pdo_015.phpt +++ /dev/null @@ -1,76 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_COLUMN ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); -?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_015.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -array(2) { - [0]=> - string(1) "1" - [1]=> - string(1) "2" -} -array(2) { - [0]=> - string(2) "A2" - [1]=> - string(2) "B2" -} -array(2) { - [1]=> - array(1) { - [0]=> - string(1) "A" - } - [2]=> - array(1) { - [0]=> - string(1) "A" - } -} -array(2) { - [1]=> - string(1) "A" - [2]=> - string(1) "A" -} -array(2) { - [1]=> - string(1) "1" - [2]=> - string(1) "2" -} -array(2) { - [1]=> - string(1) "A" - [2]=> - string(1) "A" -} -array(2) { - [1]=> - string(2) "A2" - [2]=> - string(2) "B2" -} -array(1) { - ["A"]=> - array(2) { - [0]=> - string(2) "A2" - [1]=> - string(2) "B2" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_016.phpt b/ext/sqlite/tests/pdo/pdo_016.phpt deleted file mode 100755 index ccd8afa5da..0000000000 --- a/ext/sqlite/tests/pdo/pdo_016.phpt +++ /dev/null @@ -1,117 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_BOUND ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); -?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_016.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -===INIT=== -int(1) -int(1) -int(1) -string(1) "3" -array(3) { - [0]=> - string(7) "String0" - [1]=> - string(7) "String1" - [2]=> - string(7) "String2" -} -===WHILE=== -array(1) { - [0]=> - string(7) "String0" -} -array(1) { - [1]=> - string(7) "String1" -} -array(1) { - [2]=> - string(7) "String2" -} -===ALONE=== -array(1) { - [0]=> - string(7) "String0" -} -bool(true) -bool(true) -bool(true) -bool(true) -array(1) { - [0]=> - string(7) "String0" -} -array(1) { - [1]=> - string(7) "String1" -} -bool(true) -bool(true) -bool(true) -bool(true) -array(1) { - [1]=> - string(7) "String1" -} -array(1) { - [2]=> - string(7) "String2" -} -bool(true) -bool(true) -bool(true) -bool(true) -array(1) { - [2]=> - string(7) "String2" -} -===REBIND/SAME=== -array(1) { - [0]=> - string(7) "String0" -} -bool(true) -bool(true) -string(7) "String0" -bool(true) -bool(true) -string(1) "0" -array(1) { - [1]=> - string(7) "String1" -} -bool(true) -bool(true) -string(7) "String1" -bool(true) -bool(true) -string(1) "1" -array(1) { - [2]=> - string(7) "String2" -} -bool(true) -bool(true) -string(7) "String2" -bool(true) -bool(true) -string(1) "2" -===REBIND/CONFLICT=== -string(7) "String0" -string(7) "String1" -string(7) "String2" -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_017.phpt b/ext/sqlite/tests/pdo/pdo_017.phpt deleted file mode 100755 index 1b712ebe52..0000000000 --- a/ext/sqlite/tests/pdo/pdo_017.phpt +++ /dev/null @@ -1,22 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO::beginTransaction / PDO::rollBack ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); -?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_017.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECT-- -Counted 3 rows after insert. -Counted 0 rows after delete. -Counted 3 rows after rollback. -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_018.phpt b/ext/sqlite/tests/pdo/pdo_018.phpt deleted file mode 100755 index adc54d4a04..0000000000 --- a/ext/sqlite/tests/pdo/pdo_018.phpt +++ /dev/null @@ -1,136 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO Unserializing ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); -if (!interface_exists('Serializable')) die ('skip Interface Serializable does not exist'); -?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_018.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -===INIT=== -int(1) -int(1) -int(1) -string(1) "3" -array(3) { - [0]=> - string(8) "stdClass" - [1]=> - string(8) "TestBase" - [2]=> - string(11) "TestDerived" -} -===TYPES=== -array(4) { - ["stdClass"]=> - string(1) "0" - ["TestBase"]=> - string(1) "1" - ["TestDerived"]=> - string(1) "2" - ["TestLeaf"]=> - NULL -} -===INSERT=== -TestBase::serialize() = 'a:3:{s:7:"BasePub";s:6:"Public";s:7:"BasePro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}' -TestDerived::serialize() -TestBase::serialize() = 'a:4:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";}' -TestDerived::serialize() -TestBase::serialize() = 'a:4:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";}' -===DATA=== -array(4) { - [0]=> - NULL - [1]=> - string(91) "a:3:{s:7:"BasePub";s:6:"Public";s:7:"BasePro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}" - [2]=> - string(144) "a:4:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";}" - [3]=> - string(144) "a:4:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";}" -} -===FAILURE=== -Exception:SQLSTATE[HY000]: General error: cannot unserialize class -===COUNT=== -string(1) "3" -===DATABASE=== -array(3) { - [0]=> - array(2) { - ["name"]=> - string(8) "TestBase" - ["val"]=> - string(91) "a:3:{s:7:"BasePub";s:6:"Public";s:7:"BasePro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}" - } - [1]=> - array(2) { - ["name"]=> - string(11) "TestDerived" - ["val"]=> - string(144) "a:4:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";}" - } - [2]=> - array(2) { - ["name"]=> - NULL - ["val"]=> - string(144) "a:4:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";}" - } -} -===FETCHCLASS=== -TestBase::unserialize[22](a:3:{s:7:"BasePub";s:6:"Public";s:7:"BasePro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}) -TestDerived::unserialize() -TestBase::unserialize[22](a:4:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";}) -TestDerived::unserialize() -TestBase::unserialize[22](a:4:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";}) -array(3) { - [0]=> - object(TestBase)#%d (3) { - ["BasePub"]=> - string(7) "#Public" - ["BasePro:protected"]=> - string(10) "#Protected" - ["BasePri:private"]=> - string(8) "#Private" - } - [1]=> - object(TestDerived)#%d (6) { - ["BasePub"]=> - string(14) "#DerivedPublic" - ["BasePro:protected"]=> - string(17) "#DerivdeProtected" - ["DerivedPub"]=> - string(7) "#Public" - ["DerivedPro:protected"]=> - string(10) "#Protected" - ["DerivedPri:private"]=> - string(7) "Private" - ["BasePri:private"]=> - string(7) "Private" - } - [2]=> - object(TestLeaf)#%d (6) { - ["BasePub"]=> - string(14) "#DerivedPublic" - ["BasePro:protected"]=> - string(17) "#DerivdeProtected" - ["DerivedPub"]=> - string(7) "#Public" - ["DerivedPro:protected"]=> - string(10) "#Protected" - ["DerivedPri:private"]=> - string(7) "Private" - ["BasePri:private"]=> - string(7) "Private" - } -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_019.phpt b/ext/sqlite/tests/pdo/pdo_019.phpt deleted file mode 100755 index 1a79005414..0000000000 --- a/ext/sqlite/tests/pdo/pdo_019.phpt +++ /dev/null @@ -1,52 +0,0 @@ ---TEST-- -PDO_SQLite2: fetch() and while() ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); -?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_019.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -===INIT=== -int(1) -int(1) -int(1) -int(1) -string(1) "4" -array(4) { - [0]=> - string(7) "String0" - [1]=> - string(7) "String1" - [2]=> - string(7) "String2" - [3]=> - string(7) "String3" -} -===WHILE=== -array(1) { - [0]=> - string(7) "String0" -} -array(1) { - [1]=> - string(7) "String1" -} -array(1) { - [2]=> - string(7) "String2" -} -array(1) { - [3]=> - string(7) "String3" -} -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_020.phpt b/ext/sqlite/tests/pdo/pdo_020.phpt deleted file mode 100755 index c419aec14a..0000000000 --- a/ext/sqlite/tests/pdo/pdo_020.phpt +++ /dev/null @@ -1,21 +0,0 @@ ---TEST-- -PDO_SQLite2: PDOStatement::columnCount ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_020.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECT-- -Counted 2 columns after select1. -Counted 3 columns after select2. -Counted 1 columns after select3. -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_021.phpt b/ext/sqlite/tests/pdo/pdo_021.phpt deleted file mode 100755 index d257fcb472..0000000000 --- a/ext/sqlite/tests/pdo/pdo_021.phpt +++ /dev/null @@ -1,20 +0,0 @@ ---TEST-- -PDO_SQLite2: PDOStatement::execute with parameter markers. ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_021.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECT-- -There are 6 rows in the table. -There are 12 rows in the table. -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_022.phpt b/ext/sqlite/tests/pdo/pdo_022.phpt deleted file mode 100755 index b817773ad6..0000000000 --- a/ext/sqlite/tests/pdo/pdo_022.phpt +++ /dev/null @@ -1,29 +0,0 @@ ---TEST-- -PDO_SQLite2: PDOStatement::getColumnMeta ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_022.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -Warning: PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in %spdo_022.inc on line %d -bool(false) - -Warning: PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in %spdo_022.inc on line %d -bool(false) - -Warning: PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in %spdo_022.inc on line %d -bool(false) - -Warning: PDOStatement::getColumnMeta(): SQLSTATE[IM001]: Driver does not support this function: driver doesn't support meta data in %spdo_022.inc on line %d -bool(false) -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_023.phpt b/ext/sqlite/tests/pdo/pdo_023.phpt deleted file mode 100755 index a987c6bd03..0000000000 --- a/ext/sqlite/tests/pdo/pdo_023.phpt +++ /dev/null @@ -1,60 +0,0 @@ ---TEST-- -PDO_SQLite2: Overloading ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_023_def.inc'); - -$DB = NULL; - -$DB = new PDODatabaseX($CONNECTION); -$DB->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_WARNING); - -require_once($PDO_TESTS . 'pdo_023.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -int(1) -int(2) -object(PDODatabaseX)#%d (2) { - ["test1"]=> - int(1) - ["test2"]=> - int(22) -} -PDODatabaseX::query() -PDOStatementX::__construct() -PDOStatementX::__destruct() -PDODatabaseX::query() -PDOStatementX::__construct() -PDOStatementX::__destruct() -PDODatabaseX::query() -PDOStatementX::__construct() -PDOStatementX::__destruct() -PDODatabaseX::query() -PDOStatementX::__construct() -object(PDOStatementX)#%d (3) { - ["test1"]=> - int(1) - ["queryString"]=> - string(24) "SELECT val, id FROM test" - ["test2"]=> - int(22) -} -array(2) { - ["A"]=> - string(1) "0" - ["B"]=> - string(1) "1" -} -PDOStatementX::__destruct() -PDODatabaseX::__destruct() -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_024.phpt b/ext/sqlite/tests/pdo/pdo_024.phpt deleted file mode 100755 index 52a1686250..0000000000 --- a/ext/sqlite/tests/pdo/pdo_024.phpt +++ /dev/null @@ -1,21 +0,0 @@ ---TEST-- -PDO_SQLite2: Bind does not convert NULL ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_024.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -bind: success -bool(true) -NULL -===DONE=== diff --git a/ext/sqlite/tests/pdo/pdo_025.phpt b/ext/sqlite/tests/pdo/pdo_025.phpt deleted file mode 100755 index 1746361dfa..0000000000 --- a/ext/sqlite/tests/pdo/pdo_025.phpt +++ /dev/null @@ -1,68 +0,0 @@ ---TEST-- -PDO_SQLite2: PDO_FETCH_INTO ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_025.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECTF-- -object(Test)#%d (3) { - ["id"]=> - string(2) "10" - ["val"]=> - string(3) "Abc" - ["val2"]=> - string(3) "zxy" -} -object(Test)#%d (3) { - ["id"]=> - string(2) "20" - ["val"]=> - string(3) "Def" - ["val2"]=> - string(3) "wvu" -} -object(Test)#%d (3) { - ["id"]=> - string(2) "30" - ["val"]=> - string(3) "Ghi" - ["val2"]=> - string(3) "tsr" -} -object(Test)#%d (3) { - ["id"]=> - string(2) "40" - ["val"]=> - string(3) "Jkl" - ["val2"]=> - string(3) "qpo" -} -object(Test)#%d (3) { - ["id"]=> - string(2) "50" - ["val"]=> - string(3) "Mno" - ["val2"]=> - string(3) "nml" -} -object(Test)#%d (3) { - ["id"]=> - string(2) "60" - ["val"]=> - string(3) "Pqr" - ["val2"]=> - string(3) "kji" -} -===FAIL=== - -Fatal error: Cannot access protected property Fail::$id in %spdo_025.inc on line %d diff --git a/ext/sqlite/tests/pdo/pdo_026.phpt b/ext/sqlite/tests/pdo/pdo_026.phpt deleted file mode 100755 index 28d21bab2a..0000000000 --- a/ext/sqlite/tests/pdo/pdo_026.phpt +++ /dev/null @@ -1,50 +0,0 @@ ---TEST-- -PDO_SQLite2: Deriving PDO ---SKIPIF-- -<?php # vim:ft=php -require_once('skipif.inc'); ?> ---FILE-- -<?php - -require_once('connection.inc'); -require_once('prepare.inc'); - -require_once($PDO_TESTS . 'pdo_026.inc'); - -?> -===DONE=== -<?php exit(0); ?> ---EXPECT-- -string(11) "PDODatabase" -string(12) "PDOStatement" -PDODatabase::query() -PDOStatementX::__construct() -string(13) "PDOStatementX" -string(11) "PDODatabase" -array(3) { - ["id"]=> - string(2) "10" - ["val"]=> - string(3) "Abc" - ["val2"]=> - string(3) "zxy" -} -array(3) { - ["id"]=> - string(2) "20" - ["val"]=> - string(3) "Def" - ["val2"]=> - string(3) "wvu" -} -array(3) { - ["id"]=> - string(2) "30" - ["val"]=> - string(3) "Ghi" - ["val2"]=> - string(3) "tsr" -} -===DONE=== -PDODatabase::__destruct() -PDOStatementX::__destruct() diff --git a/ext/sqlite/tests/pdo/prepare.inc b/ext/sqlite/tests/pdo/prepare.inc deleted file mode 100755 index 1fb0876f54..0000000000 --- a/ext/sqlite/tests/pdo/prepare.inc +++ /dev/null @@ -1,11 +0,0 @@ -<?php - -require_once('connection.inc'); - -$SQL = array(); - -$DB = new pdo($CONNECTION); - -$DB->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_WARNING); - -?> diff --git a/ext/sqlite/tests/pdo/skipif.inc b/ext/sqlite/tests/pdo/skipif.inc deleted file mode 100755 index 210759a6a2..0000000000 --- a/ext/sqlite/tests/pdo/skipif.inc +++ /dev/null @@ -1,5 +0,0 @@ -<?php - -if (!extension_loaded("sqlite") || !extension_loaded("sqlite")) print "skip"; - -?> diff --git a/ext/sqlite/tests/sqlite_001.phpt b/ext/sqlite/tests/sqlite_001.phpt deleted file mode 100755 index 61d8896570..0000000000 --- a/ext/sqlite/tests/sqlite_001.phpt +++ /dev/null @@ -1,16 +0,0 @@ ---TEST-- -sqlite: sqlite_open/close ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -require_once('blankdb.inc'); -echo "$db\n"; -sqlite_close($db); -echo "Done\n"; -?> ---EXPECTF-- -Resource id #%d -Done diff --git a/ext/sqlite/tests/sqlite_002.phpt b/ext/sqlite/tests/sqlite_002.phpt deleted file mode 100755 index c9fd0e1bca..0000000000 --- a/ext/sqlite/tests/sqlite_002.phpt +++ /dev/null @@ -1,32 +0,0 @@ ---TEST-- -sqlite: Simple insert/select ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))", $db); -sqlite_query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)", $db); -$r = sqlite_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r)); -sqlite_close($db); -?> ---EXPECT-- -array(6) { - [0]=> - string(10) "2002-01-02" - ["c1"]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - ["c2"]=> - string(8) "12:49:00" - [2]=> - NULL - ["c3"]=> - NULL -} diff --git a/ext/sqlite/tests/sqlite_003.phpt b/ext/sqlite/tests/sqlite_003.phpt deleted file mode 100755 index adb891b726..0000000000 --- a/ext/sqlite/tests/sqlite_003.phpt +++ /dev/null @@ -1,52 +0,0 @@ ---TEST-- -sqlite: Simple insert/select, different result represenatation ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))", $db); -sqlite_query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)", $db); -$r = sqlite_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_BOTH)); -$r = sqlite_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_NUM)); -$r = sqlite_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_ASSOC)); -sqlite_close($db); -?> ---EXPECT-- -array(6) { - [0]=> - string(10) "2002-01-02" - ["c1"]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - ["c2"]=> - string(8) "12:49:00" - [2]=> - NULL - ["c3"]=> - NULL -} -array(3) { - [0]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - [2]=> - NULL -} -array(3) { - ["c1"]=> - string(10) "2002-01-02" - ["c2"]=> - string(8) "12:49:00" - ["c3"]=> - NULL -} diff --git a/ext/sqlite/tests/sqlite_004.phpt b/ext/sqlite/tests/sqlite_004.phpt deleted file mode 100644 index 4010066578..0000000000 --- a/ext/sqlite/tests/sqlite_004.phpt +++ /dev/null @@ -1,49 +0,0 @@ ---TEST-- -sqlite: binary encoding ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$strings = array( - "hello", - "hello\x01o", - "\x01hello there", - "hello\x00there", - "" -); - -sqlite_query("CREATE TABLE strings(a)", $db); - -foreach ($strings as $str) { - sqlite_query("INSERT INTO strings VALUES('" . sqlite_escape_string($str) . "')", $db); -} - -$i = 0; -$r = sqlite_query("SELECT * from strings", $db); -while ($row = sqlite_fetch_array($r, SQLITE_NUM)) { - if ($row[0] !== $strings[$i]) { - echo "FAIL!\n"; - var_dump($row[0]); - var_dump($strings[$i]); - } else { - echo "OK!\n"; - } - $i++; -} - -sqlite_close($db); - -echo "DONE!\n"; -?> ---EXPECT-- -OK! -OK! -OK! -OK! -OK! -DONE! diff --git a/ext/sqlite/tests/sqlite_005.phpt b/ext/sqlite/tests/sqlite_005.phpt deleted file mode 100644 index e0eeab5589..0000000000 --- a/ext/sqlite/tests/sqlite_005.phpt +++ /dev/null @@ -1,50 +0,0 @@ ---TEST-- -sqlite: aggregate functions ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('" . sqlite_escape_string($str) . "')", $db); -} - -function cat_step(&$context, $string) -{ - $context .= $string; -} - -function cat_fin(&$context) -{ - return $context; -} - -sqlite_create_aggregate($db, "cat", "cat_step", "cat_fin"); - -$r = sqlite_query("SELECT cat(a) from strings", $db); -while ($row = sqlite_fetch_array($r, SQLITE_NUM)) { - var_dump($row); -} - -sqlite_close($db); - -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(11) "onetwothree" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_006.phpt b/ext/sqlite/tests/sqlite_006.phpt deleted file mode 100644 index 4e6e5f19ed..0000000000 --- a/ext/sqlite/tests/sqlite_006.phpt +++ /dev/null @@ -1,55 +0,0 @@ ---TEST-- -sqlite: regular functions ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - array("one", "uno"), - array("two", "dos"), - array("three", "tres"), - ); - -sqlite_query("CREATE TABLE strings(a,b)", $db); - -function implode_args() -{ - $args = func_get_args(); - $sep = array_shift($args); - return implode($sep, $args); -} - -foreach ($data as $row) { - sqlite_query("INSERT INTO strings VALUES('" . sqlite_escape_string($row[0]) . "','" . sqlite_escape_string($row[1]) . "')", $db); -} - -sqlite_create_function($db, "implode", "implode_args"); - -$r = sqlite_query("SELECT implode('-', a, b) from strings", $db); -while ($row = sqlite_fetch_array($r, SQLITE_NUM)) { - var_dump($row); -} - -sqlite_close($db); - -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(7) "one-uno" -} -array(1) { - [0]=> - string(7) "two-dos" -} -array(1) { - [0]=> - string(10) "three-tres" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_007.phpt b/ext/sqlite/tests/sqlite_007.phpt deleted file mode 100755 index 5a1e536188..0000000000 --- a/ext/sqlite/tests/sqlite_007.phpt +++ /dev/null @@ -1,52 +0,0 @@ ---TEST-- -sqlite: Simple insert/select (unbuffered) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))", $db); -sqlite_query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)", $db); -$r = sqlite_unbuffered_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_BOTH)); -$r = sqlite_unbuffered_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_NUM)); -$r = sqlite_unbuffered_query("SELECT * from foo", $db); -var_dump(sqlite_fetch_array($r, SQLITE_ASSOC)); -sqlite_close($db); -?> ---EXPECT-- -array(6) { - [0]=> - string(10) "2002-01-02" - ["c1"]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - ["c2"]=> - string(8) "12:49:00" - [2]=> - NULL - ["c3"]=> - NULL -} -array(3) { - [0]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - [2]=> - NULL -} -array(3) { - ["c1"]=> - string(10) "2002-01-02" - ["c2"]=> - string(8) "12:49:00" - ["c3"]=> - NULL -} diff --git a/ext/sqlite/tests/sqlite_008.phpt b/ext/sqlite/tests/sqlite_008.phpt deleted file mode 100755 index ee485c76a1..0000000000 --- a/ext/sqlite/tests/sqlite_008.phpt +++ /dev/null @@ -1,46 +0,0 @@ ---TEST-- -sqlite: fetch all (buffered) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a VARCHAR)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('$str')", $db); -} - -$r = sqlite_query("SELECT a from strings", $db); -while ($row = sqlite_fetch_array($r, SQLITE_NUM)) { - var_dump($row); -} - -sqlite_close($db); - -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_009.phpt b/ext/sqlite/tests/sqlite_009.phpt deleted file mode 100755 index bdad770b57..0000000000 --- a/ext/sqlite/tests/sqlite_009.phpt +++ /dev/null @@ -1,46 +0,0 @@ ---TEST-- -sqlite: fetch all (unbuffered) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a VARCHAR)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('$str')", $db); -} - -$r = sqlite_unbuffered_query("SELECT a from strings", $db); -while ($row = sqlite_fetch_array($r, SQLITE_NUM)) { - var_dump($row); -} - -sqlite_close($db); - -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_010.phpt b/ext/sqlite/tests/sqlite_010.phpt deleted file mode 100755 index 152fde4cf0..0000000000 --- a/ext/sqlite/tests/sqlite_010.phpt +++ /dev/null @@ -1,81 +0,0 @@ ---TEST-- -sqlite: fetch all (iterator) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a VARCHAR)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('$str')", $db); -} - -$r = sqlite_unbuffered_query("SELECT a from strings", $db); -while (sqlite_valid($r)) { - var_dump(sqlite_current($r, SQLITE_NUM)); - sqlite_next($r); -} -$r = sqlite_query("SELECT a from strings", $db); -while (sqlite_valid($r)) { - var_dump(sqlite_current($r, SQLITE_NUM)); - sqlite_next($r); -} -sqlite_rewind($r); -while (sqlite_valid($r)) { - var_dump(sqlite_current($r, SQLITE_NUM)); - sqlite_next($r); -} - -sqlite_close($db); - -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_011.phpt b/ext/sqlite/tests/sqlite_011.phpt deleted file mode 100755 index 9c1bf3990f..0000000000 --- a/ext/sqlite/tests/sqlite_011.phpt +++ /dev/null @@ -1,34 +0,0 @@ ---TEST-- -sqlite: returned associative column names ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query("CREATE TABLE foo (c1 char, c2 char, c3 char)", $db); -sqlite_query("CREATE TABLE bar (c1 char, c2 char, c3 char)", $db); -sqlite_query("INSERT INTO foo VALUES ('1', '2', '3')", $db); -sqlite_query("INSERT INTO bar VALUES ('4', '5', '6')", $db); -$r = sqlite_query("SELECT * from foo, bar", $db, SQLITE_ASSOC); -var_dump(sqlite_fetch_array($r)); -sqlite_close($db); -?> ---EXPECT-- -array(6) { - ["foo.c1"]=> - string(1) "1" - ["foo.c2"]=> - string(1) "2" - ["foo.c3"]=> - string(1) "3" - ["bar.c1"]=> - string(1) "4" - ["bar.c2"]=> - string(1) "5" - ["bar.c3"]=> - string(1) "6" -} diff --git a/ext/sqlite/tests/sqlite_012.phpt b/ext/sqlite/tests/sqlite_012.phpt deleted file mode 100755 index 14d9ea4f53..0000000000 --- a/ext/sqlite/tests/sqlite_012.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -sqlite: read field names ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query("CREATE TABLE strings(foo VARCHAR, bar VARCHAR, baz VARCHAR)", $db); - -echo "Buffered\n"; -$r = sqlite_query("SELECT * from strings", $db); -for($i=0; $i<sqlite_num_fields($r); $i++) { - var_dump(sqlite_field_name($r, $i)); -} -echo "Unbuffered\n"; -$r = sqlite_unbuffered_query("SELECT * from strings", $db); -for($i=0; $i<sqlite_num_fields($r); $i++) { - var_dump(sqlite_field_name($r, $i)); -} - -sqlite_close($db); - -echo "DONE!\n"; -?> ---EXPECT-- -Buffered -string(3) "foo" -string(3) "bar" -string(3) "baz" -Unbuffered -string(3) "foo" -string(3) "bar" -string(3) "baz" -DONE! diff --git a/ext/sqlite/tests/sqlite_013.phpt b/ext/sqlite/tests/sqlite_013.phpt deleted file mode 100755 index 95b047a75c..0000000000 --- a/ext/sqlite/tests/sqlite_013.phpt +++ /dev/null @@ -1,78 +0,0 @@ ---TEST-- -sqlite: fetch column ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - array (0 => 'one', 1 => 'two'), - array (0 => 'three', 1 => 'four') - ); - -sqlite_query("CREATE TABLE strings(a VARCHAR, b VARCHAR)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('${str[0]}','${str[1]}')", $db); -} - -echo "====BUFFERED====\n"; -$r = sqlite_query("SELECT a, b from strings", $db); -while (sqlite_valid($r)) { - var_dump(sqlite_current($r, SQLITE_NUM)); - var_dump(sqlite_column($r, 0)); - var_dump(sqlite_column($r, 1)); - var_dump(sqlite_column($r, 'a')); - var_dump(sqlite_column($r, 'b')); - sqlite_next($r); -} -echo "====UNBUFFERED====\n"; -$r = sqlite_unbuffered_query("SELECT a, b from strings", $db); -while (sqlite_valid($r)) { - var_dump(sqlite_column($r, 0)); - var_dump(sqlite_column($r, 'b')); - var_dump(sqlite_column($r, 1)); - var_dump(sqlite_column($r, 'a')); - sqlite_next($r); -} - -sqlite_close($db); - -echo "DONE!\n"; -?> ---EXPECT-- -====BUFFERED==== -array(2) { - [0]=> - string(3) "one" - [1]=> - string(3) "two" -} -string(3) "one" -string(3) "two" -string(3) "one" -string(3) "two" -array(2) { - [0]=> - string(5) "three" - [1]=> - string(4) "four" -} -string(5) "three" -string(4) "four" -string(5) "three" -string(4) "four" -====UNBUFFERED==== -string(3) "one" -string(3) "two" -NULL -NULL -string(5) "three" -string(4) "four" -NULL -NULL -DONE! diff --git a/ext/sqlite/tests/sqlite_014.phpt b/ext/sqlite/tests/sqlite_014.phpt deleted file mode 100755 index 967fcc10fa..0000000000 --- a/ext/sqlite/tests/sqlite_014.phpt +++ /dev/null @@ -1,120 +0,0 @@ ---TEST-- -sqlite: fetch all (fetch_all) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a VARCHAR)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('$str')", $db); -} - -echo "unbuffered twice\n"; -$r = sqlite_unbuffered_query("SELECT a from strings", $db, SQLITE_NUM); -var_dump(sqlite_fetch_all($r)); -var_dump(sqlite_fetch_all($r)); - -echo "unbuffered with fetch_array\n"; -$r = sqlite_unbuffered_query("SELECT a from strings", $db, SQLITE_NUM); -var_dump(sqlite_fetch_array($r)); -var_dump(sqlite_fetch_all($r)); - -echo "buffered\n"; -$r = sqlite_query("SELECT a from strings", $db, SQLITE_NUM); -var_dump(sqlite_fetch_all($r)); -var_dump(sqlite_fetch_array($r)); -var_dump(sqlite_fetch_all($r)); - -sqlite_close($db); - -echo "DONE!\n"; -?> ---EXPECTF-- -unbuffered twice -array(3) { - [0]=> - array(1) { - [0]=> - string(3) "one" - } - [1]=> - array(1) { - [0]=> - string(3) "two" - } - [2]=> - array(1) { - [0]=> - string(5) "three" - } -} - -Warning: sqlite_fetch_all(): One or more rowsets were already returned; returning NULL this time in %ssqlite_014.php on line %d -array(0) { -} -unbuffered with fetch_array -array(1) { - [0]=> - string(3) "one" -} -array(2) { - [0]=> - array(1) { - [0]=> - string(3) "two" - } - [1]=> - array(1) { - [0]=> - string(5) "three" - } -} -buffered -array(3) { - [0]=> - array(1) { - [0]=> - string(3) "one" - } - [1]=> - array(1) { - [0]=> - string(3) "two" - } - [2]=> - array(1) { - [0]=> - string(5) "three" - } -} -bool(false) -array(3) { - [0]=> - array(1) { - [0]=> - string(3) "one" - } - [1]=> - array(1) { - [0]=> - string(3) "two" - } - [2]=> - array(1) { - [0]=> - string(5) "three" - } -} -DONE! diff --git a/ext/sqlite/tests/sqlite_015.phpt b/ext/sqlite/tests/sqlite_015.phpt deleted file mode 100755 index 8de42a84b9..0000000000 --- a/ext/sqlite/tests/sqlite_015.phpt +++ /dev/null @@ -1,49 +0,0 @@ ---TEST-- -sqlite: fetch all (array_query) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a VARCHAR)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('$str')", $db); -} - -$res = sqlite_array_query("SELECT a from strings", $db, SQLITE_NUM); -var_dump($res); - -$db = null; - -echo "DONE!\n"; -?> ---EXPECTF-- -array(3) { - [0]=> - array(1) { - [0]=> - string(3) "one" - } - [1]=> - array(1) { - [0]=> - string(3) "two" - } - [2]=> - array(1) { - [0]=> - string(5) "three" - } -} -DONE! diff --git a/ext/sqlite/tests/sqlite_016.phpt b/ext/sqlite/tests/sqlite_016.phpt deleted file mode 100755 index 9ca9de135f..0000000000 --- a/ext/sqlite/tests/sqlite_016.phpt +++ /dev/null @@ -1,45 +0,0 @@ ---TEST-- -sqlite: fetch single ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - array (0 => 'one', 1 => 'two'), - array (0 => 'three', 1 => 'four') - ); - -sqlite_query("CREATE TABLE strings(a VARCHAR, b VARCHAR)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('${str[0]}','${str[1]}')", $db); -} - -echo "====BUFFERED====\n"; -$r = sqlite_query("SELECT a, b from strings", $db); -while (sqlite_valid($r)) { - var_dump(sqlite_fetch_single($r)); -} -echo "====UNBUFFERED====\n"; -$r = sqlite_unbuffered_query("SELECT a, b from strings", $db); -while (sqlite_valid($r)) { - var_dump(sqlite_fetch_single($r)); -} - -sqlite_close($db); - -echo "DONE!\n"; -?> ---EXPECT-- -====BUFFERED==== -string(3) "one" -string(5) "three" -====UNBUFFERED==== -string(3) "one" -string(5) "three" -DONE! diff --git a/ext/sqlite/tests/sqlite_017.phpt b/ext/sqlite/tests/sqlite_017.phpt deleted file mode 100755 index 9058622f99..0000000000 --- a/ext/sqlite/tests/sqlite_017.phpt +++ /dev/null @@ -1,33 +0,0 @@ ---TEST-- -sqlite: UDF binary handling functions ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php - -$data = array( - "hello there", - "this has a \x00 char in the middle", - "\x01 this has an 0x01 at the start", - "this has \x01 in the middle" - ); - -foreach ($data as $item) { - $coded = sqlite_udf_encode_binary($item); - echo bin2hex($coded) . "\n"; - $decoded = sqlite_udf_decode_binary($coded); - if ($item != $decoded) { - echo "FAIL! $item decoded is $decoded\n"; - } -} - -echo "OK!\n"; - -?> ---EXPECT-- -68656c6c6f207468657265 -0101736768721f6760721f601fff1f626760711f686d1f7367641f6c6863636b64 -0102ff1e726667711e665f711e5f6c1e2e762e2f1e5f721e7266631e71725f7072 -7468697320686173200120696e20746865206d6964646c65 -OK! diff --git a/ext/sqlite/tests/sqlite_018.phpt b/ext/sqlite/tests/sqlite_018.phpt deleted file mode 100755 index 8d80649be8..0000000000 --- a/ext/sqlite/tests/sqlite_018.phpt +++ /dev/null @@ -1,14 +0,0 @@ ---TEST-- -sqlite: crash on bad queries inside sqlite_array_query() ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_array_query($db, "SELECT foo FROM foobar"); -sqlite_close($db); -?> ---EXPECTF-- -Warning: sqlite_array_query(): no such table: foobar in %s on line %d diff --git a/ext/sqlite/tests/sqlite_019.phpt b/ext/sqlite/tests/sqlite_019.phpt deleted file mode 100755 index 74dcff99fa..0000000000 --- a/ext/sqlite/tests/sqlite_019.phpt +++ /dev/null @@ -1,47 +0,0 @@ ---TEST-- -sqlite: single query ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query($db, "CREATE TABLE test_db ( id INTEGER PRIMARY KEY, data VARCHAR(100) )"); -for ($i = 0; $i < 10; $i++) { - sqlite_query($db, "INSERT INTO test_db (data) VALUES('{$i}data')"); -} -sqlite_query($db, "INSERT INTO test_db (data) VALUES(NULL)"); - -var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5")); -var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=4")); -var_dump(sqlite_single_query($db, "SELECT data FROM test_db WHERE id=6")); -var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id < 5")); -var_dump(sqlite_single_query($db, "SELECT * FROM test db WHERE id < 4")); -var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=999999")); -var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5", FALSE)); - -sqlite_close($db); -?> ---EXPECTF-- -string(1) "5" -string(1) "4" -string(5) "5data" -array(4) { - [0]=> - string(1) "1" - [1]=> - string(1) "2" - [2]=> - string(1) "3" - [3]=> - string(1) "4" -} - -Warning: sqlite_single_query(): no such table: test in %s on line %d -bool(false) -NULL -array(1) { - [0]=> - string(1) "5" -} diff --git a/ext/sqlite/tests/sqlite_022.phpt b/ext/sqlite/tests/sqlite_022.phpt deleted file mode 100755 index 76921d56f6..0000000000 --- a/ext/sqlite/tests/sqlite_022.phpt +++ /dev/null @@ -1,101 +0,0 @@ ---TEST-- -sqlite: sqlite_seek ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('$str')", $db); -} - -$res = sqlite_query("SELECT a FROM strings", $db, SQLITE_NUM); -for ($idx = -1; $idx < 4; $idx++) { - echo "====SEEK:$idx====\n"; - sqlite_seek($res, $idx); - var_dump(sqlite_current($res)); -} -echo "====AGAIN====\n"; -for ($idx = -1; $idx < 4; $idx++) { - echo "====SEEK:$idx====\n"; - sqlite_seek($res, $idx); - var_dump(sqlite_current($res)); -} - -sqlite_close($db); - -echo "====DONE!====\n"; -?> ---EXPECTF-- -====SEEK:-1==== - -Warning: sqlite_seek(): row -1 out of range in %ssqlite_022.php on line %d -array(1) { - [0]=> - string(3) "one" -} -====SEEK:0==== -array(1) { - [0]=> - string(3) "one" -} -====SEEK:1==== -array(1) { - [0]=> - string(3) "two" -} -====SEEK:2==== -array(1) { - [0]=> - string(5) "three" -} -====SEEK:3==== - -Warning: sqlite_seek(): row 3 out of range in %ssqlite_022.php on line %d -array(1) { - [0]=> - string(5) "three" -} -====AGAIN==== -====SEEK:-1==== - -Warning: sqlite_seek(): row -1 out of range in %ssqlite_022.php on line %d -array(1) { - [0]=> - string(5) "three" -} -====SEEK:0==== -array(1) { - [0]=> - string(3) "one" -} -====SEEK:1==== -array(1) { - [0]=> - string(3) "two" -} -====SEEK:2==== -array(1) { - [0]=> - string(5) "three" -} -====SEEK:3==== - -Warning: sqlite_seek(): row 3 out of range in %ssqlite_022.php on line %d -array(1) { - [0]=> - string(5) "three" -} -====DONE!==== diff --git a/ext/sqlite/tests/sqlite_023.phpt b/ext/sqlite/tests/sqlite_023.phpt deleted file mode 100644 index fbb8dc8da8..0000000000 --- a/ext/sqlite/tests/sqlite_023.phpt +++ /dev/null @@ -1,105 +0,0 @@ ---TEST-- -sqlite: sqlite_[has_]prev ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query("CREATE TABLE strings(a)", $db); - -foreach ($data as $str) { - sqlite_query("INSERT INTO strings VALUES('$str')", $db); -} - -$r = sqlite_query("SELECT a FROM strings", $db, SQLITE_NUM); - -echo "====TRAVERSE====\n"; -for(sqlite_rewind($r); sqlite_valid($r); sqlite_next($r)) { - var_dump(sqlite_current($r)); - -} -echo "====REVERSE====\n"; -do { - sqlite_prev($r); - var_dump(sqlite_current($r)); -} while(sqlite_has_prev($r)); - -echo "====UNBUFFERED====\n"; - -$r = sqlite_unbuffered_query("SELECT a FROM strings", $db, SQLITE_NUM); - -echo "====TRAVERSE====\n"; -for(sqlite_rewind($r); sqlite_valid($r); sqlite_next($r)) { - var_dump(sqlite_current($r)); - -} -echo "====REVERSE====\n"; -do { - sqlite_prev($r); - var_dump(sqlite_current($r)); -} while(sqlite_has_prev($r)); - -sqlite_close($db); - -echo "====DONE!====\n"; -?> ---EXPECTF-- -====TRAVERSE==== -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -====REVERSE==== -array(1) { - [0]=> - string(5) "three" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(3) "one" -} -====UNBUFFERED==== -====TRAVERSE==== - -Warning: sqlite_rewind(): Cannot rewind an unbuffered result set in %ssqlite_023.php on line %d -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -====REVERSE==== - -Warning: sqlite_prev(): you cannot use sqlite_prev on unbuffered querys in %ssqlite_023.php on line %d -bool(false) - -Warning: sqlite_has_prev(): you cannot use sqlite_has_prev on unbuffered querys in %ssqlite_023.php on line %d -====DONE!==== diff --git a/ext/sqlite/tests/sqlite_024.phpt b/ext/sqlite/tests/sqlite_024.phpt deleted file mode 100755 index b7198c0155..0000000000 --- a/ext/sqlite/tests/sqlite_024.phpt +++ /dev/null @@ -1,76 +0,0 @@ ---TEST-- -sqlite: sqlite_fetch_object ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -class class24 { - function __construct() { - echo __METHOD__ . "\n"; - } -} - -$data = array( - "one", - "two", - "three" - ); - -sqlite_query($db, "CREATE TABLE strings(a)"); - -foreach ($data as $str) { - sqlite_query($db, "INSERT INTO strings VALUES('$str')"); -} - -echo "====class24====\n"; -$res = sqlite_query($db, "SELECT a FROM strings", SQLITE_ASSOC); -while (sqlite_valid($res)) { - var_dump(sqlite_fetch_object($res, 'class24')); -} - -echo "====stdclass====\n"; -$res = sqlite_query($db, "SELECT a FROM strings", SQLITE_ASSOC); -while (sqlite_valid($res)) { - var_dump(sqlite_fetch_object($res)); -} - -sqlite_close($db); - -echo "====DONE!====\n"; -?> ---EXPECTF-- -====class24==== -class24::__construct -object(class24)#%d (1) { - ["a"]=> - string(3) "one" -} -class24::__construct -object(class24)#%d (1) { - ["a"]=> - string(3) "two" -} -class24::__construct -object(class24)#%d (1) { - ["a"]=> - string(5) "three" -} -====stdclass==== -object(stdClass)#%d (1) { - ["a"]=> - string(3) "one" -} -object(stdClass)#%d (1) { - ["a"]=> - string(3) "two" -} -object(stdClass)#%d (1) { - ["a"]=> - string(5) "three" -} -====DONE!==== diff --git a/ext/sqlite/tests/sqlite_025.phpt b/ext/sqlite/tests/sqlite_025.phpt deleted file mode 100755 index 0a257610cc..0000000000 --- a/ext/sqlite/tests/sqlite_025.phpt +++ /dev/null @@ -1,38 +0,0 @@ ---TEST-- -sqlite: sqlite_fetch_object in a loop ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query($db, "CREATE TABLE strings(a)"); - -foreach (array("one", "two", "three") as $str) { - sqlite_query($db, "INSERT INTO strings VALUES('$str')"); -} - -$res = sqlite_query("SELECT * FROM strings", $db); - -while (($obj = sqlite_fetch_object($res))) { - var_dump($obj); -} - -sqlite_close($db); -?> ---EXPECTF-- -object(stdClass)#1 (1) { - ["a"]=> - string(3) "one" -} -object(stdClass)#2 (1) { - ["a"]=> - string(3) "two" -} -object(stdClass)#1 (1) { - ["a"]=> - string(5) "three" -}
\ No newline at end of file diff --git a/ext/sqlite/tests/sqlite_026.phpt b/ext/sqlite/tests/sqlite_026.phpt deleted file mode 100755 index c508979a27..0000000000 --- a/ext/sqlite/tests/sqlite_026.phpt +++ /dev/null @@ -1,27 +0,0 @@ ---TEST-- -sqlite: sqlite_fetch_column_types ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb.inc"; - -sqlite_query($db, "CREATE TABLE strings(a, b INTEGER, c VARCHAR(10), d)"); -sqlite_query($db, "INSERT INTO strings VALUES('1', '2', '3', 'abc')"); - -var_dump(sqlite_fetch_column_types($db, "strings")); - -sqlite_close($db); -?> ---EXPECT-- -array(4) { - ["a"]=> - string(0) "" - ["b"]=> - string(7) "INTEGER" - ["c"]=> - string(11) "VARCHAR(10)" - ["d"]=> - string(0) "" -} diff --git a/ext/sqlite/tests/sqlite_027.phpt b/ext/sqlite/tests/sqlite_027.phpt deleted file mode 100755 index 7919f2c3f7..0000000000 --- a/ext/sqlite/tests/sqlite_027.phpt +++ /dev/null @@ -1,15 +0,0 @@ ---TEST-- -sqlite: crash inside sqlite_escape_string() & sqlite_udf_encode_binary ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---INI-- -memory_limit=-1 ---FILE-- -<?php - var_dump(strlen(sqlite_escape_string(str_repeat("\0", 20000000)))); - var_dump(strlen(sqlite_udf_encode_binary(str_repeat("\0", 20000000)))); -?> ---EXPECT-- -int(20000002) -int(20000002) diff --git a/ext/sqlite/tests/sqlite_oo_001.phpt b/ext/sqlite/tests/sqlite_oo_001.phpt deleted file mode 100755 index 672ddb17b6..0000000000 --- a/ext/sqlite/tests/sqlite_oo_001.phpt +++ /dev/null @@ -1,17 +0,0 @@ ---TEST-- -sqlite-oo: sqlite_open/close ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -require_once('blankdb_oo.inc'); -var_dump($db); -$db = NULL; -echo "Done\n"; -?> ---EXPECTF-- -object(SQLiteDatabase)#%d (0) { -} -Done diff --git a/ext/sqlite/tests/sqlite_oo_002.phpt b/ext/sqlite/tests/sqlite_oo_002.phpt deleted file mode 100755 index 00a568a2a8..0000000000 --- a/ext/sqlite/tests/sqlite_oo_002.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -sqlite-oo: Simple insert/select ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -require_once('blankdb_oo.inc'); -var_dump($db); - -var_dump($db->query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))")); -var_dump($db->query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)")); -$r = $db->query("SELECT * from foo"); -var_dump($r); -var_dump($r->fetch()); -?> ---EXPECTF-- -object(SQLiteDatabase)#%d (0) { -} -object(SQLiteResult)#%d (0) { -} -object(SQLiteResult)#%d (0) { -} -object(SQLiteResult)#%d (0) { -} -array(6) { - [0]=> - string(10) "2002-01-02" - ["c1"]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - ["c2"]=> - string(8) "12:49:00" - [2]=> - NULL - ["c3"]=> - NULL -} diff --git a/ext/sqlite/tests/sqlite_oo_003.phpt b/ext/sqlite/tests/sqlite_oo_003.phpt deleted file mode 100755 index f9ca65c611..0000000000 --- a/ext/sqlite/tests/sqlite_oo_003.phpt +++ /dev/null @@ -1,51 +0,0 @@ ---TEST-- -sqlite-oo: Simple insert/select, different result representation ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$db->query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))"); -$db->query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)"); -$r = $db->query("SELECT * from foo"); -var_dump($r->fetch(SQLITE_BOTH)); -$r = $db->query("SELECT * from foo"); -var_dump($r->fetch(SQLITE_NUM)); -$r = $db->query("SELECT * from foo"); -var_dump($r->fetch(SQLITE_ASSOC)); -?> ---EXPECT-- -array(6) { - [0]=> - string(10) "2002-01-02" - ["c1"]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - ["c2"]=> - string(8) "12:49:00" - [2]=> - NULL - ["c3"]=> - NULL -} -array(3) { - [0]=> - string(10) "2002-01-02" - [1]=> - string(8) "12:49:00" - [2]=> - NULL -} -array(3) { - ["c1"]=> - string(10) "2002-01-02" - ["c2"]=> - string(8) "12:49:00" - ["c3"]=> - NULL -} diff --git a/ext/sqlite/tests/sqlite_oo_008.phpt b/ext/sqlite/tests/sqlite_oo_008.phpt deleted file mode 100755 index 8e99a1deaf..0000000000 --- a/ext/sqlite/tests/sqlite_oo_008.phpt +++ /dev/null @@ -1,43 +0,0 @@ ---TEST-- -sqlite-oo: fetch all (buffered) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$data = array( - "one", - "two", - "three" - ); - -$db->query("CREATE TABLE strings(a VARCHAR)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('$str')"); -} - -$r = $db->query("SELECT a from strings"); -while ($row = $r->fetch(SQLITE_NUM)) { - var_dump($row); -} -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_oo_009.phpt b/ext/sqlite/tests/sqlite_oo_009.phpt deleted file mode 100755 index c2a55556c1..0000000000 --- a/ext/sqlite/tests/sqlite_oo_009.phpt +++ /dev/null @@ -1,43 +0,0 @@ ---TEST-- -sqlite-oo: fetch all (unbuffered) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$data = array( - "one", - "two", - "three" - ); - -$db->query("CREATE TABLE strings(a VARCHAR)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('$str')"); -} - -$r = $db->unbufferedQuery("SELECT a from strings"); -while ($row = $r->fetch(SQLITE_NUM)) { - var_dump($row); -} -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_oo_010.phpt b/ext/sqlite/tests/sqlite_oo_010.phpt deleted file mode 100755 index 8d6f3c0a99..0000000000 --- a/ext/sqlite/tests/sqlite_oo_010.phpt +++ /dev/null @@ -1,44 +0,0 @@ ---TEST-- -sqlite-oo: fetch all (iterator) ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$data = array( - "one", - "two", - "three" - ); - -$db->query("CREATE TABLE strings(a VARCHAR)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('$str')"); -} - -$r = $db->unbufferedQuery("SELECT a from strings", SQLITE_NUM); -while ($row = $r->valid()) { - var_dump($r->current()); - $r->next(); -} -echo "DONE!\n"; -?> ---EXPECT-- -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_oo_011.phpt b/ext/sqlite/tests/sqlite_oo_011.phpt deleted file mode 100755 index 4b5a37044c..0000000000 --- a/ext/sqlite/tests/sqlite_oo_011.phpt +++ /dev/null @@ -1,33 +0,0 @@ ---TEST-- -sqlite-oo: returned associative column names ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$db->query("CREATE TABLE foo (c1 char, c2 char, c3 char)"); -$db->query("CREATE TABLE bar (c1 char, c2 char, c3 char)"); -$db->query("INSERT INTO foo VALUES ('1', '2', '3')"); -$db->query("INSERT INTO bar VALUES ('4', '5', '6')"); -$r = $db->query("SELECT * from foo, bar", SQLITE_ASSOC); -var_dump($r->fetch()); -?> ---EXPECT-- -array(6) { - ["foo.c1"]=> - string(1) "1" - ["foo.c2"]=> - string(1) "2" - ["foo.c3"]=> - string(1) "3" - ["bar.c1"]=> - string(1) "4" - ["bar.c2"]=> - string(1) "5" - ["bar.c3"]=> - string(1) "6" -} diff --git a/ext/sqlite/tests/sqlite_oo_012.phpt b/ext/sqlite/tests/sqlite_oo_012.phpt deleted file mode 100755 index 408feb9d17..0000000000 --- a/ext/sqlite/tests/sqlite_oo_012.phpt +++ /dev/null @@ -1,35 +0,0 @@ ---TEST-- -sqlite-oo: read field names ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$db->query("CREATE TABLE strings(foo VARCHAR, bar VARCHAR, baz VARCHAR)"); - -echo "Buffered\n"; -$r = $db->query("SELECT * from strings"); -for($i=0; $i<$r->numFields(); $i++) { - var_dump($r->fieldName($i)); -} -echo "Unbuffered\n"; -$r = $db->unbufferedQuery("SELECT * from strings"); -for($i=0; $i<$r->numFields(); $i++) { - var_dump($r->fieldName($i)); -} -echo "DONE!\n"; -?> ---EXPECT-- -Buffered -string(3) "foo" -string(3) "bar" -string(3) "baz" -Unbuffered -string(3) "foo" -string(3) "bar" -string(3) "baz" -DONE! diff --git a/ext/sqlite/tests/sqlite_oo_013.phpt b/ext/sqlite/tests/sqlite_oo_013.phpt deleted file mode 100755 index 0c19505f23..0000000000 --- a/ext/sqlite/tests/sqlite_oo_013.phpt +++ /dev/null @@ -1,75 +0,0 @@ ---TEST-- -sqlite-oo: fetch column ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$data = array( - array (0 => 'one', 1 => 'two'), - array (0 => 'three', 1 => 'four') - ); - -$db->query("CREATE TABLE strings(a VARCHAR, b VARCHAR)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('${str[0]}','${str[1]}')"); -} - -echo "====BUFFERED====\n"; -$r = $db->query("SELECT a, b from strings"); -while ($r->valid()) { - var_dump($r->current(SQLITE_NUM)); - var_dump($r->column(0)); - var_dump($r->column(1)); - var_dump($r->column('a')); - var_dump($r->column('b')); - $r->next(); -} -echo "====UNBUFFERED====\n"; -$r = $db->unbufferedQuery("SELECT a, b from strings"); -while ($r->valid()) { - var_dump($r->column(0)); - var_dump($r->column('b')); - var_dump($r->column(1)); - var_dump($r->column('a')); - $r->next(); -} -echo "DONE!\n"; -?> ---EXPECT-- -====BUFFERED==== -array(2) { - [0]=> - string(3) "one" - [1]=> - string(3) "two" -} -string(3) "one" -string(3) "two" -string(3) "one" -string(3) "two" -array(2) { - [0]=> - string(5) "three" - [1]=> - string(4) "four" -} -string(5) "three" -string(4) "four" -string(5) "three" -string(4) "four" -====UNBUFFERED==== -string(3) "one" -string(3) "two" -NULL -NULL -string(5) "three" -string(4) "four" -NULL -NULL -DONE! diff --git a/ext/sqlite/tests/sqlite_oo_014.phpt b/ext/sqlite/tests/sqlite_oo_014.phpt deleted file mode 100755 index 9735a5442c..0000000000 --- a/ext/sqlite/tests/sqlite_oo_014.phpt +++ /dev/null @@ -1,118 +0,0 @@ ---TEST-- -sqlite-oo: fetch all ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$data = array( - "one", - "two", - "three" - ); - -$db->query("CREATE TABLE strings(a VARCHAR)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('$str')"); -} - -echo "unbuffered twice\n"; -$r = $db->unbufferedQuery("SELECT a from strings", SQLITE_NUM); -var_dump($r->fetchAll()); -var_dump($r->fetchAll()); - -echo "unbuffered with fetch_array\n"; -$r = $db->unbufferedQuery("SELECT a from strings", SQLITE_NUM); -var_dump($r->fetch()); -var_dump($r->fetchAll()); - -echo "buffered\n"; -$r = $db->query("SELECT a from strings", SQLITE_NUM); -var_dump($r->fetchAll()); -var_dump($r->fetch()); -var_dump($r->fetchAll()); - -echo "DONE!\n"; -?> ---EXPECTF-- -unbuffered twice -array(3) { - [0]=> - array(1) { - [0]=> - string(3) "one" - } - [1]=> - array(1) { - [0]=> - string(3) "two" - } - [2]=> - array(1) { - [0]=> - string(5) "three" - } -} - -Warning: SQLiteUnbuffered::fetchAll(): One or more rowsets were already returned; returning NULL this time in %ssqlite_oo_014.php on line %d -array(0) { -} -unbuffered with fetch_array -array(1) { - [0]=> - string(3) "one" -} -array(2) { - [0]=> - array(1) { - [0]=> - string(3) "two" - } - [1]=> - array(1) { - [0]=> - string(5) "three" - } -} -buffered -array(3) { - [0]=> - array(1) { - [0]=> - string(3) "one" - } - [1]=> - array(1) { - [0]=> - string(3) "two" - } - [2]=> - array(1) { - [0]=> - string(5) "three" - } -} -bool(false) -array(3) { - [0]=> - array(1) { - [0]=> - string(3) "one" - } - [1]=> - array(1) { - [0]=> - string(3) "two" - } - [2]=> - array(1) { - [0]=> - string(5) "three" - } -} -DONE! diff --git a/ext/sqlite/tests/sqlite_oo_015.phpt b/ext/sqlite/tests/sqlite_oo_015.phpt deleted file mode 100755 index 893e6f14ab..0000000000 --- a/ext/sqlite/tests/sqlite_oo_015.phpt +++ /dev/null @@ -1,47 +0,0 @@ ---TEST-- -sqlite-oo: array_query ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$data = array( - "one", - "two", - "three" - ); - -$db->query("CREATE TABLE strings(a VARCHAR)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('$str')"); -} - -$res = $db->arrayQuery("SELECT a from strings", SQLITE_NUM); -var_dump($res); - -echo "DONE!\n"; -?> ---EXPECTF-- -array(3) { - [0]=> - array(1) { - [0]=> - string(3) "one" - } - [1]=> - array(1) { - [0]=> - string(3) "two" - } - [2]=> - array(1) { - [0]=> - string(5) "three" - } -} -DONE! diff --git a/ext/sqlite/tests/sqlite_oo_016.phpt b/ext/sqlite/tests/sqlite_oo_016.phpt deleted file mode 100755 index d831b48326..0000000000 --- a/ext/sqlite/tests/sqlite_oo_016.phpt +++ /dev/null @@ -1,42 +0,0 @@ ---TEST-- -sqlite-oo: fetch single ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$data = array( - array (0 => 'one', 1 => 'two'), - array (0 => 'three', 1 => 'four') - ); - -$db->query("CREATE TABLE strings(a VARCHAR, b VARCHAR)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('${str[0]}','${str[1]}')"); -} - -echo "====BUFFERED====\n"; -$r = $db->query("SELECT a, b from strings"); -while ($r->valid()) { - var_dump($r->fetchSingle()); -} -echo "====UNBUFFERED====\n"; -$r = $db->unbufferedQuery("SELECT a, b from strings"); -while ($r->valid()) { - var_dump($r->fetchSingle()); -} -echo "DONE!\n"; -?> ---EXPECT-- -====BUFFERED==== -string(3) "one" -string(5) "three" -====UNBUFFERED==== -string(3) "one" -string(5) "three" -DONE! diff --git a/ext/sqlite/tests/sqlite_oo_020.phpt b/ext/sqlite/tests/sqlite_oo_020.phpt deleted file mode 100755 index a855101fbd..0000000000 --- a/ext/sqlite/tests/sqlite_oo_020.phpt +++ /dev/null @@ -1,66 +0,0 @@ ---TEST-- -sqlite-oo: factory and exception ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -$dbname = tempnam(dirname(__FILE__), "phpsql"); -function cleanup() { - global $db, $dbname; - - $db = NULL; - unlink($dbname); -} -register_shutdown_function("cleanup"); - -try { - $db = sqlite_factory(); -} catch(SQLiteException $err) { - echo "Message: ".$err->getMessage()."\n"; - echo "File: ".$err->getFile()."\n"; - //echo "Line: ".$err->getLine()."\n"; - //print_r($err->getTrace()); - //echo "BackTrace: ".$err->getTraceAsString()."\n"; -} - -$db = sqlite_factory($dbname); - -$data = array( - array (0 => 'one', 1 => 'two'), - array (0 => 'three', 1 => 'four') - ); - -$db->query("CREATE TABLE strings(a VARCHAR, b VARCHAR)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('${str[0]}','${str[1]}')"); -} - -$r = $db->unbufferedQuery("SELECT a, b from strings"); -while ($r->valid()) { - var_dump($r->current(SQLITE_NUM)); - $r->next(); -} -$r = null; -$db = null; -echo "DONE!\n"; -?> ---EXPECTF-- -Message: sqlite_factory() expects at least 1 parameter, 0 given -File: %ssqlite_oo_020.php -array(2) { - [0]=> - string(3) "one" - [1]=> - string(3) "two" -} -array(2) { - [0]=> - string(5) "three" - [1]=> - string(4) "four" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_oo_021.phpt b/ext/sqlite/tests/sqlite_oo_021.phpt deleted file mode 100755 index 850e4dc9a3..0000000000 --- a/ext/sqlite/tests/sqlite_oo_021.phpt +++ /dev/null @@ -1,48 +0,0 @@ ---TEST-- -sqlite-oo: single query ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$db->query("CREATE TABLE test_db ( id INTEGER PRIMARY KEY, data VARCHAR(100) )"); -for ($i = 0; $i < 10; $i++) { - $db->query("INSERT INTO test_db (data) VALUES('{$i}data')"); -} -$db->query("INSERT INTO test_db (data) VALUES(NULL)"); - -var_dump($db->singleQuery("SELECT id FROM test_db WHERE id=5")); -var_dump($db->singleQuery("SELECT * FROM test_db WHERE id=4")); -var_dump($db->singleQuery("SELECT data FROM test_db WHERE id=6")); -var_dump($db->singleQuery("SELECT * FROM test_db WHERE id < 5")); -var_dump($db->singleQuery("SELECT * FROM test db WHERE id < 4")); -var_dump($db->singleQuery("SELECT * FROM test_db WHERE id=999999")); -var_dump($db->singleQuery("SELECT id FROM test_db WHERE id=5", FALSE)); - -echo "DONE!\n"; -?> ---EXPECTF-- -string(1) "5" -string(1) "4" -string(5) "5data" -array(4) { - [0]=> - string(1) "1" - [1]=> - string(1) "2" - [2]=> - string(1) "3" - [3]=> - string(1) "4" -} - -Warning: SQLiteDatabase::singleQuery(): no such table: test in %s on line %d -bool(false) -NULL -array(1) { - [0]=> - string(1) "5" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_oo_022.phpt b/ext/sqlite/tests/sqlite_oo_022.phpt deleted file mode 100755 index 988904f774..0000000000 --- a/ext/sqlite/tests/sqlite_oo_022.phpt +++ /dev/null @@ -1,98 +0,0 @@ ---TEST-- -sqlite-oo: sqlite::seek ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$data = array( - "one", - "two", - "three" - ); - -$db->query("CREATE TABLE strings(a)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('$str')"); -} - -$res = $db->query("SELECT a FROM strings", SQLITE_NUM); -for ($idx = -1; $idx < 4; $idx++) { - echo "====SEEK:$idx====\n"; - $res->seek($idx); - var_dump($res->current()); -} -echo "====AGAIN====\n"; -for ($idx = -1; $idx < 4; $idx++) { - echo "====SEEK:$idx====\n"; - $res->seek($idx); - var_dump($res->current()); -} -echo "====DONE!====\n"; -?> ---EXPECTF-- -====SEEK:-1==== - -Warning: SQLiteResult::seek(): row -1 out of range in %ssqlite_oo_022.php on line %d -array(1) { - [0]=> - string(3) "one" -} -====SEEK:0==== -array(1) { - [0]=> - string(3) "one" -} -====SEEK:1==== -array(1) { - [0]=> - string(3) "two" -} -====SEEK:2==== -array(1) { - [0]=> - string(5) "three" -} -====SEEK:3==== - -Warning: SQLiteResult::seek(): row 3 out of range in %ssqlite_oo_022.php on line %d -array(1) { - [0]=> - string(5) "three" -} -====AGAIN==== -====SEEK:-1==== - -Warning: SQLiteResult::seek(): row -1 out of range in %ssqlite_oo_022.php on line %d -array(1) { - [0]=> - string(5) "three" -} -====SEEK:0==== -array(1) { - [0]=> - string(3) "one" -} -====SEEK:1==== -array(1) { - [0]=> - string(3) "two" -} -====SEEK:2==== -array(1) { - [0]=> - string(5) "three" -} -====SEEK:3==== - -Warning: SQLiteResult::seek(): row 3 out of range in %ssqlite_oo_022.php on line %d -array(1) { - [0]=> - string(5) "three" -} -====DONE!==== diff --git a/ext/sqlite/tests/sqlite_oo_024.phpt b/ext/sqlite/tests/sqlite_oo_024.phpt deleted file mode 100755 index f974ad8a8d..0000000000 --- a/ext/sqlite/tests/sqlite_oo_024.phpt +++ /dev/null @@ -1,74 +0,0 @@ ---TEST-- -sqlite-oo: sqlite::fetch_object ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -class class24 { - function __construct() { - echo __METHOD__ . "\n"; - } -} - -$data = array( - "one", - "two", - "three" - ); - -$db->query("CREATE TABLE strings(a)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('$str')"); -} - -echo "====class24====\n"; -$res = $db->query("SELECT a FROM strings", SQLITE_ASSOC); -while ($res->valid()) { - var_dump($res->fetchObject('class24')); -} - -echo "====stdclass====\n"; -$res = $db->query("SELECT a FROM strings", SQLITE_ASSOC); -while ($res->valid()) { - var_dump($res->fetchObject()); -} - -echo "====DONE!====\n"; -?> ---EXPECTF-- -====class24==== -class24::__construct -object(class24)#%d (1) { - ["a"]=> - string(3) "one" -} -class24::__construct -object(class24)#%d (1) { - ["a"]=> - string(3) "two" -} -class24::__construct -object(class24)#%d (1) { - ["a"]=> - string(5) "three" -} -====stdclass==== -object(stdClass)#%d (1) { - ["a"]=> - string(3) "one" -} -object(stdClass)#%d (1) { - ["a"]=> - string(3) "two" -} -object(stdClass)#%d (1) { - ["a"]=> - string(5) "three" -} -====DONE!==== diff --git a/ext/sqlite/tests/sqlite_oo_025.phpt b/ext/sqlite/tests/sqlite_oo_025.phpt deleted file mode 100755 index 3cb42d7647..0000000000 --- a/ext/sqlite/tests/sqlite_oo_025.phpt +++ /dev/null @@ -1,103 +0,0 @@ ---TEST-- -sqlite-oo: sqlite / foreach ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; -?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$data = array( - "one", - "two", - "three" - ); - -$db->query("CREATE TABLE strings(a VARCHAR)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('$str')"); -} - -echo "====UNBUFFERED====\n"; -$r = $db->unbufferedQuery("SELECT a from strings", SQLITE_NUM); -//var_dump(class_implements($r)); -foreach($r as $row) { - var_dump($row); -} -echo "====NO-MORE====\n"; -foreach($r as $row) { - var_dump($row); -} -echo "====DIRECT====\n"; -foreach($db->unbufferedQuery("SELECT a from strings", SQLITE_NUM) as $row) { - var_dump($row); -} -echo "====BUFFERED====\n"; -$r = $db->query("SELECT a from strings", SQLITE_NUM); -//var_dump(class_implements($r)); -foreach($r as $row) { - var_dump($row); -} -foreach($r as $row) { - var_dump($row); -} -echo "DONE!\n"; -?> ---EXPECT-- -====UNBUFFERED==== -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -====NO-MORE==== -====DIRECT==== -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -====BUFFERED==== -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -array(1) { - [0]=> - string(3) "one" -} -array(1) { - [0]=> - string(3) "two" -} -array(1) { - [0]=> - string(5) "three" -} -DONE! diff --git a/ext/sqlite/tests/sqlite_oo_026.phpt b/ext/sqlite/tests/sqlite_oo_026.phpt deleted file mode 100755 index 4beacbb888..0000000000 --- a/ext/sqlite/tests/sqlite_oo_026.phpt +++ /dev/null @@ -1,56 +0,0 @@ ---TEST-- -sqlite-oo: unbuffered ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; -?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$data = array( - "one", - "two", - "three" - ); - -$db->query("CREATE TABLE strings(a VARCHAR)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('$str')"); -} - -echo "====FOREACH====\n"; -$r = $db->unbufferedQuery("SELECT a from strings", SQLITE_NUM); -foreach($r as $idx => $row) { - var_dump($row[0]); - var_dump($row[0]); -} -echo "====FOR====\n"; -$r = $db->unbufferedQuery("SELECT a from strings", SQLITE_NUM); -for(;$r->valid(); $r->next()) { - $v = $r->column(0); - var_dump($v); - $c = $r->column(0); - var_dump(is_null($c) || $c==$v); -} -echo "===DONE===\n"; -?> ---EXPECT-- -====FOREACH==== -string(3) "one" -string(3) "one" -string(3) "two" -string(3) "two" -string(5) "three" -string(5) "three" -====FOR==== -string(3) "one" -bool(true) -string(3) "two" -bool(true) -string(5) "three" -bool(true) -===DONE=== diff --git a/ext/sqlite/tests/sqlite_oo_027.phpt b/ext/sqlite/tests/sqlite_oo_027.phpt deleted file mode 100755 index 069c7c97ea..0000000000 --- a/ext/sqlite/tests/sqlite_oo_027.phpt +++ /dev/null @@ -1,42 +0,0 @@ ---TEST-- -sqlite-oo: changes ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; -?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$data = array("one", "two", "three"); - -$db->query("CREATE TABLE strings(a VARCHAR)"); - -foreach ($data as $str) { - $db->query("INSERT INTO strings VALUES('$str')"); - echo $db->changes() . "\n"; -} - -$db->query("UPDATE strings SET a='foo' WHERE a!='two'"); -echo $db->changes() . "\n"; - -$db->query("DELETE FROM strings WHERE 1"); -echo $db->changes() . "\n"; - -$str = ''; -foreach ($data as $s) { - $str .= "INSERT INTO strings VALUES('".$s."');"; -} -$db->query($str); -echo $db->changes() . "\n"; - -?> ---EXPECT-- -1 -1 -1 -2 -3 -3 diff --git a/ext/sqlite/tests/sqlite_oo_028.phpt b/ext/sqlite/tests/sqlite_oo_028.phpt deleted file mode 100755 index fe7f8c6f68..0000000000 --- a/ext/sqlite/tests/sqlite_oo_028.phpt +++ /dev/null @@ -1,25 +0,0 @@ ---TEST-- -sqlite-oo: sqlite_fetch_column_types ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; ?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$db->query("CREATE TABLE strings(a, b INTEGER, c VARCHAR(10), d)"); -$db->query("INSERT INTO strings VALUES('1', '2', '3', 'abc')"); - -var_dump($db->fetchColumnTypes("strings")); -?> ---EXPECT-- -array(4) { - ["a"]=> - string(0) "" - ["b"]=> - string(7) "INTEGER" - ["c"]=> - string(11) "VARCHAR(10)" - ["d"]=> - string(0) "" -} diff --git a/ext/sqlite/tests/sqlite_oo_029.phpt b/ext/sqlite/tests/sqlite_oo_029.phpt deleted file mode 100755 index 4b2b1992b8..0000000000 --- a/ext/sqlite/tests/sqlite_oo_029.phpt +++ /dev/null @@ -1,53 +0,0 @@ ---TEST-- -sqlite-oo: call method with $this ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; -?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$db->query("CREATE TABLE strings(key VARCHAR(10), var VARCHAR(10))"); -$db->query("INSERT INTO strings VALUES('foo', 'foo')"); - -class sqlite_help -{ - function __construct($db){ - $this->db = $db; - $this->db->createFunction('link_keywords', array(&$this, 'linkers'), 1); - } - - function getSingle($key) - { - return $this->db->singleQuery('SELECT link_keywords(var) FROM strings WHERE key=\''.$key.'\'', 1); - } - - function linkers($str) - { - $str = str_replace('foo', 'bar', $str); - return $str; - } - - function free() - { - unset($this->db); - } - - function __destruct() - { - echo "DESTRUCTED\n"; - } -} - -$obj = new sqlite_help($db); -echo $obj->getSingle('foo')."\n"; -$obj->free(); -unset($obj); - -?> -===DONE=== ---EXPECT-- -bar -===DONE=== -DESTRUCTED diff --git a/ext/sqlite/tests/sqlite_oo_030.phpt b/ext/sqlite/tests/sqlite_oo_030.phpt deleted file mode 100755 index 2155115974..0000000000 --- a/ext/sqlite/tests/sqlite_oo_030.phpt +++ /dev/null @@ -1,42 +0,0 @@ ---TEST-- -sqlite-oo: calling static methods ---INI-- -sqlite.assoc_case=0 ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; -?> ---FILE-- -<?php - -require_once('blankdb_oo.inc'); - -class foo { - static function bar($param = NULL) { - return $param; - } -} - -function baz($param = NULL) { - return $param; -} - -var_dump($db->singleQuery("select php('baz')", 1)); -var_dump($db->singleQuery("select php('baz', 1)", 1)); -var_dump($db->singleQuery("select php('baz', \"PHP\")", 1)); -var_dump($db->singleQuery("select php('foo::bar')", 1)); -var_dump($db->singleQuery("select php('foo::bar', 1)", 1)); -var_dump($db->singleQuery("select php('foo::bar', \"PHP\")", 1)); -var_dump($db->singleQuery("select php('foo::bar(\"PHP\")')", 1)); - -?> -===DONE=== ---EXPECTF-- -NULL -string(1) "1" -string(3) "PHP" -NULL -string(1) "1" -string(3) "PHP" - -Fatal error: Call to undefined method foo::bar("php")() in %ssqlite_oo_030.php on line %d diff --git a/ext/sqlite/tests/sqlite_spl_001.phpt b/ext/sqlite/tests/sqlite_spl_001.phpt deleted file mode 100755 index 4afb8cb712..0000000000 --- a/ext/sqlite/tests/sqlite_spl_001.phpt +++ /dev/null @@ -1,125 +0,0 @@ ---TEST-- -sqlite-spl: Iteration ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; -if (!extension_loaded("spl")) print "skip SPL is not present"; -?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$db->query("CREATE TABLE menu(id_l int PRIMARY KEY, id_r int UNIQUE, key VARCHAR(10))"); -$db->query("INSERT INTO menu VALUES( 1, 12, 'A')"); -$db->query("INSERT INTO menu VALUES( 2, 9, 'B')"); -$db->query("INSERT INTO menu VALUES(10, 11, 'F')"); -$db->query("INSERT INTO menu VALUES( 3, 6, 'C')"); -$db->query("INSERT INTO menu VALUES( 7, 8, 'E')"); -$db->query("INSERT INTO menu VALUES( 4, 5, 'D')"); - -class SqliteNestedsetElement -{ - protected $id_l; - protected $id_r; - protected $key; - - function __construct($db) - { - $this->db = $db; - } - - function getLeft() - { - return $this->id_l; - } - - function getRight() - { - return $this->id_r; - } - - function __toString() - { - return $this->key; - } - - function key() - { - return $this->key; - } -} - -class SqliteNestedset implements RecursiveIterator -{ - protected $id; - protected $id_l; - protected $id_r; - protected $entry; - - function __construct($db, $id_l = 1) - { - $this->db = $db; - $this->id_l = $id_l; - $this->id_r = $this->db->singleQuery('SELECT id_r FROM menu WHERE id_l='.$id_l, 1); - $this->id = $id_l; - } - - function rewind() - { - $this->id = $this->id_l; - $this->fetch(); - } - - function valid() - { - return is_object($this->entry); - } - - function current() - { - return $this->entry->__toString(); - } - - function key() - { - return $this->entry->key();; - } - - function next() - { - $this->id = $this->entry->getRight() + 1; - $this->fetch(); - } - - protected function fetch() - { - $res = $this->db->unbufferedQuery('SELECT * FROM menu WHERE id_l='.$this->id); - $this->entry = $res->fetchObject('SqliteNestedsetElement', array(&$this->db)); - unset($res); - } - - function hasChildren() - { - return $this->entry->getLeft() + 1 < $this->entry->getRight(); - } - - function getChildren() - { - return new SqliteNestedset($this->db, $this->entry->getLeft() + 1, $this->entry->getRight() - 1); - } -} - -$menu_iterator = new RecursiveIteratorIterator(new SqliteNestedset($db), RIT_SELF_FIRST); -foreach($menu_iterator as $entry) { - echo $menu_iterator->getDepth() . $entry . "\n"; -} -?> -===DONE=== ---EXPECT-- -0A -1B -2C -3D -2E -1F -===DONE=== diff --git a/ext/sqlite/tests/sqlite_spl_002.phpt b/ext/sqlite/tests/sqlite_spl_002.phpt deleted file mode 100755 index c60ca01e02..0000000000 --- a/ext/sqlite/tests/sqlite_spl_002.phpt +++ /dev/null @@ -1,29 +0,0 @@ ---TEST-- -sqlite-spl: Countable ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; -if (!extension_loaded("spl")) print "skip SPL is not present"; -?> ---FILE-- -<?php -include "blankdb_oo.inc"; - -$db->query("CREATE TABLE menu(id_l int PRIMARY KEY, id_r int UNIQUE, key VARCHAR(10))"); -$db->query("INSERT INTO menu VALUES( 1, 12, 'A')"); -$db->query("INSERT INTO menu VALUES( 2, 9, 'B')"); -$db->query("INSERT INTO menu VALUES(10, 11, 'F')"); -$db->query("INSERT INTO menu VALUES( 3, 6, 'C')"); -$db->query("INSERT INTO menu VALUES( 7, 8, 'E')"); -$db->query("INSERT INTO menu VALUES( 4, 5, 'D')"); - -$res = $db->query("SELECT * from menu"); - -var_dump($res->count()); -var_dump(count($res)); -?> -===DONE=== ---EXPECT-- -int(6) -int(6) -===DONE=== diff --git a/ext/sqlite/tests/sqlite_spl_003.phpt b/ext/sqlite/tests/sqlite_spl_003.phpt deleted file mode 100755 index 267ceff50c..0000000000 --- a/ext/sqlite/tests/sqlite_spl_003.phpt +++ /dev/null @@ -1,28 +0,0 @@ ---TEST-- -sqlite-spl: Exception ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded("sqlite")) print "skip"; -if (!extension_loaded("spl")) print "skip SPL is not present"; -?> ---FILE-- -<?php - -try -{ - $db = sqlite_factory(); -} -catch(SQLiteException $e) -{ - $parents = class_parents($e); - if (array_key_exists('RuntimeException', $parents)) - { - echo "GOOD\n"; - } -} - -?> -===DONE=== ---EXPECT-- -GOOD -===DONE=== |