Return to pdo_sqlite_createfunction.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / pdo_sqlite / tests

Annotation of embedaddon/php/ext/pdo_sqlite/tests/pdo_sqlite_createfunction.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: PDO_sqlite: Testing sqliteCreateFunction()
        !             3: --SKIPIF--
        !             4: <?php if (!extension_loaded('pdo_sqlite')) print 'skip not loaded'; ?>
        !             5: --FILE--
        !             6: <?php
        !             7: 
        !             8: $db = new pdo('sqlite::memory:');
        !             9: 
        !            10: $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
        !            11: 
        !            12: $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
        !            13: $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
        !            14: 
        !            15: 
        !            16: $db->sqliteCreateFunction('testing', function($v) { return strtolower($v); });
        !            17: 
        !            18: 
        !            19: foreach ($db->query('SELECT testing(name) FROM foobar') as $row) {
        !            20:        var_dump($row);
        !            21: }
        !            22: 
        !            23: $db->query('DROP TABLE foobar');
        !            24: 
        !            25: ?>
        !            26: --EXPECTF--
        !            27: array(2) {
        !            28:   ["testing(name)"]=>
        !            29:   %string|unicode%(3) "php"
        !            30:   [0]=>
        !            31:   %string|unicode%(3) "php"
        !            32: }
        !            33: array(2) {
        !            34:   ["testing(name)"]=>
        !            35:   %string|unicode%(4) "php6"
        !            36:   [0]=>
        !            37:   %string|unicode%(4) "php6"
        !            38: }