diff options
| author | Nikita Popov <nikita.ppv@gmail.com> | 2017-03-12 17:04:02 +0100 |
|---|---|---|
| committer | Nikita Popov <nikita.ppv@gmail.com> | 2017-03-12 17:04:02 +0100 |
| commit | e31342ef843f98523722b2d37ea23190bf2781af (patch) | |
| tree | 90012a557646b3a69617c1579b4ef0c4463269b4 /ext/pdo_sqlite/tests | |
| parent | 22e6b5ef220345bb187c93a293ee436a80f897d1 (diff) | |
| parent | fbf0e0587f8455525466e6d4ab2c1f0fc24bfe26 (diff) | |
| download | php-git-e31342ef843f98523722b2d37ea23190bf2781af.tar.gz | |
Merge branch 'PHP-7.1'
Diffstat (limited to 'ext/pdo_sqlite/tests')
| -rw-r--r-- | ext/pdo_sqlite/tests/pdo_sqlite_createfunction_with_flags.phpt | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/ext/pdo_sqlite/tests/pdo_sqlite_createfunction_with_flags.phpt b/ext/pdo_sqlite/tests/pdo_sqlite_createfunction_with_flags.phpt new file mode 100644 index 0000000000..4f0b6754a1 --- /dev/null +++ b/ext/pdo_sqlite/tests/pdo_sqlite_createfunction_with_flags.phpt @@ -0,0 +1,38 @@ +--TEST-- +PDO_sqlite: Testing sqliteCreateFunction() with flags +--SKIPIF-- +<?php if (!extension_loaded('pdo_sqlite')) print 'skip not loaded'; ?> +--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); }, 1, PDO::SQLITE_DETERMINISTIC); + + +foreach ($db->query('SELECT testing(name) FROM foobar') as $row) { + var_dump($row); +} + +$db->query('DROP TABLE foobar'); + +?> +--EXPECTF-- +array(2) { + ["testing(name)"]=> + string(3) "php" + [0]=> + string(3) "php" +} +array(2) { + ["testing(name)"]=> + string(4) "php6" + [0]=> + string(4) "php6" +} |
