Return to pdo_fetch_func_001.phpt CVS log

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

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

1.1     ! misho       1: --TEST--
        !             2: Testing several callbacks using PDO::FETCH_FUNC
        !             3: --SKIPIF--
        !             4: <?php
        !             5: if (!extension_loaded('pdo_sqlite')) print 'skip not loaded';
        !             6: ?>
        !             7: --FILE--
        !             8: <?php
        !             9: 
        !            10: $db = new PDO('sqlite::memory:');
        !            11: $db->exec('CREATE TABLE testing (id INTEGER , name VARCHAR)');
        !            12: $db->exec('INSERT INTO testing VALUES(1, "php")');
        !            13: $db->exec('INSERT INTO testing VALUES(2, "")');
        !            14: 
        !            15: $st = $db->query('SELECT * FROM testing');
        !            16: $st->fetchAll(PDO::FETCH_FUNC, function($x, $y) use ($st) { var_dump($st); print "data: $x, $y\n"; });
        !            17: 
        !            18: $st = $db->query('SELECT name FROM testing');
        !            19: var_dump($st->fetchAll(PDO::FETCH_FUNC, 'strtoupper'));
        !            20: 
        !            21: $st = $db->query('SELECT * FROM testing');
        !            22: var_dump($st->fetchAll(PDO::FETCH_FUNC, 'nothing'));
        !            23: 
        !            24: $st = $db->query('SELECT * FROM testing');
        !            25: var_dump($st->fetchAll(PDO::FETCH_FUNC, ''));
        !            26: 
        !            27: $st = $db->query('SELECT * FROM testing');
        !            28: var_dump($st->fetchAll(PDO::FETCH_FUNC, NULL));
        !            29: 
        !            30: $st = $db->query('SELECT * FROM testing');
        !            31: var_dump($st->fetchAll(PDO::FETCH_FUNC, 1));
        !            32: 
        !            33: $st = $db->query('SELECT * FROM testing');
        !            34: var_dump($st->fetchAll(PDO::FETCH_FUNC, array('self', 'foo')));
        !            35: 
        !            36: class foo { 
        !            37:        public function foo($x) {
        !            38:                return "--- $x ---";
        !            39:        }
        !            40: }
        !            41: class bar extends foo {
        !            42:        public function __construct($db) {
        !            43:                $st = $db->query('SELECT * FROM testing');
        !            44:                var_dump($st->fetchAll(PDO::FETCH_FUNC, array($this, 'parent::foo')));
        !            45:        }
        !            46:        
        !            47:        static public function test($x, $y) {
        !            48:                return $x .'---'. $y;
        !            49:        }
        !            50:        
        !            51:        private function test2($x, $y) {
        !            52:                return $x;
        !            53:        }
        !            54:        
        !            55:        public function test3($x, $y) {
        !            56:                return $x .'==='. $y;
        !            57:        }
        !            58: }
        !            59: 
        !            60: new bar($db);
        !            61: 
        !            62: $st = $db->query('SELECT * FROM testing');
        !            63: var_dump($st->fetchAll(PDO::FETCH_FUNC, array('bar', 'test')));
        !            64: 
        !            65: $st = $db->query('SELECT * FROM testing');
        !            66: var_dump($st->fetchAll(PDO::FETCH_FUNC, array('bar', 'test2')));
        !            67: 
        !            68: $st = $db->query('SELECT * FROM testing');
        !            69: var_dump($st->fetchAll(PDO::FETCH_FUNC, array('bar', 'test3')));
        !            70: 
        !            71: $st = $db->query('SELECT * FROM testing');
        !            72: var_dump($st->fetchAll(PDO::FETCH_FUNC, array('bar', 'inexistent')));
        !            73: 
        !            74: ?>
        !            75: --EXPECTF--
        !            76: object(PDOStatement)#%d (1) {
        !            77:   [%u|b%"queryString"]=>
        !            78:   %string|unicode%(21) "SELECT * FROM testing"
        !            79: }
        !            80: data: 1, php
        !            81: object(PDOStatement)#%d (1) {
        !            82:   [%u|b%"queryString"]=>
        !            83:   %string|unicode%(21) "SELECT * FROM testing"
        !            84: }
        !            85: data: 2, 
        !            86: array(2) {
        !            87:   [0]=>
        !            88:   %string|unicode%(3) "PHP"
        !            89:   [1]=>
        !            90:   %string|unicode%(0) ""
        !            91: }
        !            92: 
        !            93: Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error: function 'nothing' not found or invalid function name in %s on line %d
        !            94: bool(false)
        !            95: 
        !            96: Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error: function '' not found or invalid function name in %s on line %d
        !            97: bool(false)
        !            98: 
        !            99: Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error: no array or string given in %s on line %d
        !           100: bool(false)
        !           101: 
        !           102: Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error: no array or string given in %s on line %d
        !           103: bool(false)
        !           104: 
        !           105: Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error: cannot access self:: when no class scope is active in %s on line %d
        !           106: bool(false)
        !           107: array(2) {
        !           108:   [0]=>
        !           109:   %string|unicode%(9) "--- 1 ---"
        !           110:   [1]=>
        !           111:   %string|unicode%(9) "--- 2 ---"
        !           112: }
        !           113: array(2) {
        !           114:   [0]=>
        !           115:   %string|unicode%(7) "1---php"
        !           116:   [1]=>
        !           117:   %string|unicode%(4) "2---"
        !           118: }
        !           119: 
        !           120: Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error: cannot access private method bar::test2() in %s on line %d
        !           121: bool(false)
        !           122: array(2) {
        !           123:   [0]=>
        !           124:   %string|unicode%(7) "1===php"
        !           125:   [1]=>
        !           126:   %string|unicode%(4) "2==="
        !           127: }
        !           128: 
        !           129: Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error: class 'bar' does not have a method 'inexistent' in %s on line %d
        !           130: bool(false)