Return to pg_select_001.phpt CVS log

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

Annotation of embedaddon/php/ext/pgsql/tests/pg_select_001.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: PostgreSQL pg_select() - basic test using schema
        !             3: --SKIPIF--
        !             4: <?php include("skipif.inc"); ?>
        !             5: --FILE--
        !             6: <?php
        !             7: 
        !             8: include('config.inc');
        !             9: 
        !            10: $conn = pg_connect($conn_str);
        !            11: 
        !            12: pg_query('CREATE SCHEMA phptests');
        !            13: 
        !            14: pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)');
        !            15: pg_query('INSERT INTO phptests.foo VALUES (1,2)');
        !            16: pg_query('INSERT INTO phptests.foo VALUES (2,3)');
        !            17: 
        !            18: pg_query('CREATE TABLE phptests.bar (id4 INT, id3 INT)');
        !            19: pg_query('INSERT INTO phptests.bar VALUES (4,5)');
        !            20: pg_query('INSERT INTO phptests.bar VALUES (6,7)');
        !            21: 
        !            22: /* Inexistent table */
        !            23: var_dump(pg_select($conn, 'foo', array('id' => 1)));
        !            24: 
        !            25: /* Existent column */
        !            26: var_dump(pg_select($conn, 'phptests.foo', array('id' => 1)));
        !            27: 
        !            28: /* Testing with inexistent column */
        !            29: var_dump(pg_select($conn, 'phptests.bar', array('id' => 1)));
        !            30: 
        !            31: /* Existent column */
        !            32: var_dump(pg_select($conn, 'phptests.bar', array('id4' => 4)));
        !            33: 
        !            34: 
        !            35: pg_query('DROP TABLE phptests.foo');
        !            36: pg_query('DROP TABLE phptests.bar');
        !            37: pg_query('DROP SCHEMA phptests');
        !            38: 
        !            39: ?>
        !            40: --EXPECTF--
        !            41: Warning: pg_select(): Table 'foo' doesn't exists in %s on line %d
        !            42: bool(false)
        !            43: array(1) {
        !            44:   [0]=>
        !            45:   array(2) {
        !            46:     ["id"]=>
        !            47:     string(1) "1"
        !            48:     ["id2"]=>
        !            49:     string(1) "2"
        !            50:   }
        !            51: }
        !            52: 
        !            53: Notice: pg_select(): Invalid field name (id) in values in %s on line %d
        !            54: bool(false)
        !            55: array(1) {
        !            56:   [0]=>
        !            57:   array(2) {
        !            58:     ["id4"]=>
        !            59:     string(1) "4"
        !            60:     ["id3"]=>
        !            61:     string(1) "5"
        !            62:   }
        !            63: }