From 88ef12964b1873b0a35f84f39ca0473fd251abb9 Mon Sep 17 00:00:00 2001
From: Marcus Boerger <helly@php.net>
Date: Sun, 27 Apr 2003 11:29:39 +0000
Subject: Add more tests

---
 ext/sqlite/tests/sqlite_007.phpt | 49 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100755 ext/sqlite/tests/sqlite_007.phpt

(limited to 'ext/sqlite/tests/sqlite_007.phpt')

diff --git a/ext/sqlite/tests/sqlite_007.phpt b/ext/sqlite/tests/sqlite_007.phpt
new file mode 100755
index 0000000000..b6174dbaca
--- /dev/null
+++ b/ext/sqlite/tests/sqlite_007.phpt
@@ -0,0 +1,49 @@
+--TEST--
+sqlite: Simple insert/select (unbuffered)
+--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));
+?>
+--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
+}
-- 
cgit v1.2.1