From ae19eb5334adc842c14e44e7779569b8b3b3bb2c Mon Sep 17 00:00:00 2001 From: Marcus Boerger Date: Wed, 9 Jul 2003 16:55:07 +0000 Subject: [PATCH] Add oo version of test --- ext/sqlite/tests/sqlite_oo_022.phpt | 98 +++++++++++++++++++++++++++++ 1 file changed, 98 insertions(+) create mode 100755 ext/sqlite/tests/sqlite_oo_022.phpt diff --git a/ext/sqlite/tests/sqlite_oo_022.phpt b/ext/sqlite/tests/sqlite_oo_022.phpt new file mode 100755 index 0000000000..e82cc83f69 --- /dev/null +++ b/ext/sqlite/tests/sqlite_oo_022.phpt @@ -0,0 +1,98 @@ +--TEST-- +sqlite-oo: sqlite::seek +--INI-- +sqlite.assoc_case=0 +--SKIPIF-- + +--FILE-- +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: 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: seek(): row 3 out of range in %ssqlite_oo_022.php on line %d +array(1) { + [0]=> + string(5) "three" +} +====AGAIN==== +====SEEK:-1==== + +Warning: 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: seek(): row 3 out of range in %ssqlite_oo_022.php on line %d +array(1) { + [0]=> + string(5) "three" +} +====DONE!==== -- 2.40.0