Return to pg_update_001.phpt CVS log

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

Annotation of embedaddon/php/ext/pgsql/tests/pg_update_001.phpt, revision 1.1.1.2

1.1       misho       1: --TEST--
                      2: PostgreSQL pg_update() - 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 foo (id INT, id2 INT)');
                     15: pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)');
                     16: 
                     17: 
                     18: pg_insert($conn, 'foo', array('id' => 1, 'id2' => 1));
                     19: pg_insert($conn, 'phptests.foo', array('id' => 1, 'id2' => 2));
                     20: 
                     21: pg_update($conn, 'foo', array('id' => 10), array('id' => 1));
                     22: var_dump(pg_update($conn, 'foo', array('id' => 10), array('id' => 1), PGSQL_DML_STRING));
                     23: 
                     24: pg_update($conn, 'phptests.foo', array('id' => 100), array('id2' => 2));
                     25: var_dump(pg_update($conn, 'phptests.foo', array('id' => 100), array('id2' => 2), PGSQL_DML_STRING));
                     26: 
                     27: $rs = pg_query('SELECT * FROM foo UNION SELECT * FROM phptests.foo');
                     28: while ($row = pg_fetch_assoc($rs)) {
                     29:        var_dump($row);
                     30: }
                     31: 
                     32: pg_query('DROP TABLE foo');
                     33: pg_query('DROP TABLE phptests.foo');
                     34: pg_query('DROP SCHEMA phptests');
                     35: 
                     36: ?>
                     37: --EXPECT--
1.1.1.2 ! misho      38: string(38) "UPDATE "foo" SET "id"=10 WHERE "id"=1;"
        !            39: string(51) "UPDATE "phptests"."foo" SET "id"=100 WHERE "id2"=2;"
1.1       misho      40: array(2) {
                     41:   ["id"]=>
                     42:   string(2) "10"
                     43:   ["id2"]=>
                     44:   string(1) "1"
                     45: }
                     46: array(2) {
                     47:   ["id"]=>
                     48:   string(3) "100"
                     49:   ["id2"]=>
                     50:   string(1) "2"
                     51: }