summaryrefslogtreecommitdiff
path: root/ext/pdo_sqlite/tests/pdo_sqlite_createfunction.phpt
diff options
context:
space:
mode:
authorFelipe Pena <felipe@php.net>2008-12-02 21:00:23 +0000
committerFelipe Pena <felipe@php.net>2008-12-02 21:00:23 +0000
commitfbf7cc72aa4a3bb01abdcadab80d4fefec33a088 (patch)
treee7c341f21f07539c9b9b793ca4c05579ed533926 /ext/pdo_sqlite/tests/pdo_sqlite_createfunction.phpt
parent61f0a0ddd4e151be7846f8471fecdae98fd29134 (diff)
downloadphp-git-fbf7cc72aa4a3bb01abdcadab80d4fefec33a088.tar.gz
- Fixed memory leaks
- Added new tests (Coverage++)
Diffstat (limited to 'ext/pdo_sqlite/tests/pdo_sqlite_createfunction.phpt')
-rw-r--r--ext/pdo_sqlite/tests/pdo_sqlite_createfunction.phpt36
1 files changed, 36 insertions, 0 deletions
diff --git a/ext/pdo_sqlite/tests/pdo_sqlite_createfunction.phpt b/ext/pdo_sqlite/tests/pdo_sqlite_createfunction.phpt
new file mode 100644
index 0000000000..8a93002e67
--- /dev/null
+++ b/ext/pdo_sqlite/tests/pdo_sqlite_createfunction.phpt
@@ -0,0 +1,36 @@
+--TEST--
+PDO_sqlite: Testing sqliteCreateFunction()
+--FILE--
+<?php
+
+$db = new pdo('sqlite:memory');
+
+$db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
+
+$db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
+$db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
+
+
+$db->sqliteCreateFunction('testing', function($v) { return strtolower($v); });
+
+
+foreach ($db->query('SELECT testing(name) FROM foobar') as $row) {
+ var_dump($row);
+}
+
+$db->query('DROP TABLE foobar');
+
+?>
+--EXPECTF--
+array(2) {
+ ["testing(name)"]=>
+ %string|unicode%(3) "php"
+ [0]=>
+ %string|unicode%(3) "php"
+}
+array(2) {
+ ["testing(name)"]=>
+ %string|unicode%(4) "php6"
+ [0]=>
+ %string|unicode%(4) "php6"
+}