Return to pg_delete_001.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: PostgreSQL pg_delete() - 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: pg_insert($conn, 'foo', array('id' => 1, 'id2' => 1));
                     18: pg_insert($conn, 'foo', array('id' => 1, 'id2' => 2));
                     19: pg_insert($conn, 'foo', array('id' => 1, 'id2' => 2));
                     20: pg_insert($conn, 'foo', array('id' => 3, 'id2' => 3));
                     21: 
                     22: pg_insert($conn, 'phptests.foo', array('id' => 1, 'id2' => 1));
                     23: pg_insert($conn, 'phptests.foo', array('id' => 1, 'id2' => 2));
                     24: pg_insert($conn, 'phptests.foo', array('id' => 2, 'id2' => 3));
                     25: pg_insert($conn, 'phptests.foo', array('id' => 2, 'id2' => 3));
                     26: 
                     27: pg_delete($conn, 'foo', array('id' => 1, 'id2' => 0));
                     28: pg_delete($conn, 'foo', array('id' => 1, 'id2' => 2));
                     29: var_dump(pg_delete($conn, 'foo', array('id' => 1, 'id2' => 2), PGSQL_DML_STRING));
                     30: 
                     31: pg_delete($conn, 'phptests.foo', array('id' => 2, 'id2' => 1));
                     32: pg_delete($conn, 'phptests.foo', array('id' => 2, 'id2' => 3));
                     33: var_dump(pg_delete($conn, 'phptests.foo', array('id' => 2, 'id2' => 3), PGSQL_DML_STRING));
                     34: 
                     35: var_dump(pg_fetch_all(pg_query('SELECT * FROM foo')));
                     36: var_dump(pg_fetch_all(pg_query('SELECT * FROM phptests.foo')));
                     37: 
                     38: /* Inexistent */
                     39: pg_delete($conn, 'bar', array('id' => 1, 'id2' => 2));
                     40: var_dump(pg_delete($conn, 'bar', array('id' => 1, 'id2' => 2), PGSQL_DML_STRING));
                     41: 
                     42: pg_query('DROP TABLE foo');
                     43: pg_query('DROP TABLE phptests.foo');
                     44: pg_query('DROP SCHEMA phptests');
                     45: 
                     46: ?>
                     47: --EXPECTF--
1.1.1.2 ! misho      48: string(43) "DELETE FROM "foo" WHERE "id"=1 AND "id2"=2;"
        !            49: string(54) "DELETE FROM "phptests"."foo" WHERE "id"=2 AND "id2"=3;"
1.1       misho      50: array(2) {
                     51:   [0]=>
                     52:   array(2) {
                     53:     ["id"]=>
                     54:     string(1) "1"
                     55:     ["id2"]=>
                     56:     string(1) "1"
                     57:   }
                     58:   [1]=>
                     59:   array(2) {
                     60:     ["id"]=>
                     61:     string(1) "3"
                     62:     ["id2"]=>
                     63:     string(1) "3"
                     64:   }
                     65: }
                     66: array(2) {
                     67:   [0]=>
                     68:   array(2) {
                     69:     ["id"]=>
                     70:     string(1) "1"
                     71:     ["id2"]=>
                     72:     string(1) "1"
                     73:   }
                     74:   [1]=>
                     75:   array(2) {
                     76:     ["id"]=>
                     77:     string(1) "1"
                     78:     ["id2"]=>
                     79:     string(1) "2"
                     80:   }
                     81: }
                     82: 
                     83: Warning: pg_delete(): Table 'bar' doesn't exists in %s on line %d
                     84: 
                     85: Warning: pg_delete(): Table 'bar' doesn't exists in %s on line %d
                     86: bool(false)