summaryrefslogtreecommitdiff
path: root/ext/sqlite/tests
diff options
context:
space:
mode:
authorIlia Alshanetsky <iliaa@php.net>2003-12-10 18:56:05 +0000
committerIlia Alshanetsky <iliaa@php.net>2003-12-10 18:56:05 +0000
commit9165dc414ecac35784f82082036dc5b3f9e1876a (patch)
treeb45126750cecd2c31f5859b379771da532516f0b /ext/sqlite/tests
parent009e8498c35083d5c707cb4b42cc32b9e70e8f06 (diff)
downloadphp-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-xext/sqlite/tests/sqlite_oo_027.phpt42
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