Return to pg_insert_001.phpt CVS log

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

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

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: pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)');
                     14: 
                     15: 
                     16: pg_insert($conn, 'foo', array('id' => 1, 'id2' => 1));
                     17: 
                     18: pg_insert($conn, 'phptests.foo', array('id' => 1, 'id2' => 2));
                     19: 
                     20: var_dump(pg_insert($conn, 'phptests.foo', array('id' => 1, 'id2' => 2), PGSQL_DML_STRING));
                     21: 
                     22: var_dump(pg_select($conn, 'phptests.foo', array('id' => 1)));
                     23: 
                     24: pg_query('DROP TABLE phptests.foo');
                     25: pg_query('DROP SCHEMA phptests');
                     26: 
                     27: ?>
                     28: --EXPECTF--
                     29: 
                     30: Warning: pg_insert(): Table 'foo' doesn't exists in %s on line %d
1.1.1.2 ! misho      31: string(55) "INSERT INTO "phptests"."foo" ("id","id2") VALUES (1,2);"
1.1       misho      32: array(1) {
                     33:   [0]=>
                     34:   array(2) {
                     35:     ["id"]=>
                     36:     string(1) "1"
                     37:     ["id2"]=>
                     38:     string(1) "2"
                     39:   }
                     40: }