diff options
Diffstat (limited to 'ext/sqlite/tests')
-rwxr-xr-x | ext/sqlite/tests/sqlite_oo_027.phpt | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/ext/sqlite/tests/sqlite_oo_027.phpt b/ext/sqlite/tests/sqlite_oo_027.phpt new file mode 100755 index 0000000000..069c7c97ea --- /dev/null +++ b/ext/sqlite/tests/sqlite_oo_027.phpt @@ -0,0 +1,42 @@ +--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 |