diff options
author | Ilia Alshanetsky <iliaa@php.net> | 2003-12-10 18:56:05 +0000 |
---|---|---|
committer | Ilia Alshanetsky <iliaa@php.net> | 2003-12-10 18:56:05 +0000 |
commit | 9165dc414ecac35784f82082036dc5b3f9e1876a (patch) | |
tree | b45126750cecd2c31f5859b379771da532516f0b /ext/sqlite/tests | |
parent | 009e8498c35083d5c707cb4b42cc32b9e70e8f06 (diff) | |
download | php-git-9165dc414ecac35784f82082036dc5b3f9e1876a.tar.gz |
The changes() method should be that of the database object not that of
a result.
Added a test case for this bug.
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 |