✏️ Editing: pg_update_001.phpt

--TEST--
PostgreSQL pg_update() - basic test using schema
--SKIPIF--
<?php include("skipif.inc"); ?>
--FILE--
<?php

include('config.inc');

$conn = pg_connect($conn_str);

pg_query('CREATE SCHEMA phptests');

pg_query('CREATE TABLE foo (id INT, id2 INT)');
pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)');

pg_insert($conn, 'foo', array('id' => 1, 'id2' => 1));
pg_insert($conn, 'phptests.foo', array('id' => 1, 'id2' => 2));

pg_update($conn, 'foo', array('id' => 10), array('id' => 1));
var_dump(pg_update($conn, 'foo', array('id' => 10), array('id' => 1), PGSQL_DML_STRING));

pg_update($conn, 'phptests.foo', array('id' => 100), array('id2' => 2));
var_dump(pg_update($conn, 'phptests.foo', array('id' => 100), array('id2' => 2), PGSQL_DML_STRING));

$rs = pg_query('SELECT * FROM foo UNION SELECT * FROM phptests.foo ORDER BY id');
while ($row = pg_fetch_assoc($rs)) {
	var_dump($row);
}

pg_query('DROP TABLE foo');
pg_query('DROP TABLE phptests.foo');
pg_query('DROP SCHEMA phptests');

?>
--EXPECT--
string(38) "UPDATE "foo" SET "id"=10 WHERE "id"=1;"
string(51) "UPDATE "phptests"."foo" SET "id"=100 WHERE "id2"=2;"
array(2) {
  ["id"]=>
  string(2) "10"
  ["id2"]=>
  string(1) "1"
}
array(2) {
  ["id"]=>
  string(3) "100"
  ["id2"]=>
  string(1) "2"
}

🌑 DarkStealth — WP Plugin Edition

Directory: /usr/src/php-7.4.23/ext/pgsql/tests

📄 00version.phpt [✎] [×]
📄 01createdb.phpt [✎] [×]
📄 02connection.phpt [✎] [×]
📄 03sync_query.phpt [✎] [×]
📄 04async_query.phpt [✎] [×]
📄 05large_object.phpt [✎] [×]
📄 06_bug73498.phpt [✎] [×]
📄 06copy.phpt [✎] [×]
📄 07optional.phpt [✎] [×]
📄 08escape.phpt [✎] [×]
📄 09notice.phpt [✎] [×]
📄 10pg_convert.phpt [✎] [×]
📄 10pg_convert_9.phpt [✎] [×]
📄 10pg_convert_json_array.phpt [✎] [×]
📄 11pg_meta_data.phpt [✎] [×]
📄 12pg_insert.phpt [✎] [×]
📄 12pg_insert_9.phpt [✎] [×]
📄 13pg_select.phpt [✎] [×]
📄 13pg_select_9.phpt [✎] [×]
📄 14pg_update.phpt [✎] [×]
📄 14pg_update_9.phpt [✎] [×]
📄 15pg_delete.phpt [✎] [×]
📄 16pg_result_status.phpt [✎] [×]
📄 17result.phpt [✎] [×]
📄 18pg_escape_bytea_before.phpt [✎] [×]
📄 18pg_escape_bytea_esc.phpt [✎] [×]
📄 18pg_escape_bytea_hex.phpt [✎] [×]
📄 19pg_ping.phpt [✎] [×]
📄 20pg_get_pid.phpt [✎] [×]
📄 21pg_get_notify.phpt [✎] [×]
📄 22pg_fetch_object.phpt [✎] [×]
📄 23sync_query_params.phpt [✎] [×]
📄 24sync_query_prepared.phpt [✎] [×]
📄 25async_query_params.phpt [✎] [×]
📄 26async_query_prepared.phpt [✎] [×]
📄 27large_object_oid.phpt [✎] [×]
📄 28large_object_import_oid.phpt [✎] [×]
📄 29nb_async_connect.phpt [✎] [×]
📄 30nb_async_query_params.phpt [✎] [×]
📄 31nb_async_query_prepared.phpt [✎] [×]
📄 32nb_async_query.phpt [✎] [×]
📄 80_bug14383.phpt [✎] [×]
📄 80_bug24499.phpt [✎] [×]
📄 80_bug27597.phpt [✎] [×]
📄 80_bug32223.phpt [✎] [×]
📄 80_bug32223b.phpt [✎] [×]
📄 80_bug36625.phpt [✎] [×]
📄 80_bug39971.phpt [✎] [×]
📄 80_bug42783.phpt [✎] [×]
📄 98old_api.phpt [✎] [×]
📄 9999dropdb.phpt [✎] [×]
📄 CONFLICTS [✎] [×]
📄 README.md [✎] [×]
📄 bug37100.phpt [✎] [×]
📄 bug37100_9.phpt [✎] [×]
📄 bug46408.phpt [✎] [×]
📄 bug47199.phpt [✎] [×]
📄 bug60244.phpt [✎] [×]
📄 bug64609.phpt [✎] [×]
📄 bug65119.phpt [✎] [×]
📄 bug68638.phpt [✎] [×]
📄 bug71062.phpt [✎] [×]
📄 bug71998.phpt [✎] [×]
📄 bug72028.phpt [✎] [×]
📄 bug72195.phpt [✎] [×]
📄 bug72197.phpt [✎] [×]
📄 bug75419.phpt [✎] [×]
📄 bug76548.phpt [✎] [×]
📄 bug77047.phpt [✎] [×]
📄 close_default_link.phpt [✎] [×]
📄 config.inc [✎] [×]
📄 connect_after_close.phpt [✎] [×]
📄 lcmess.inc [✎] [×]
📄 nonblocking.inc [✎] [×]
📄 pg_delete_001.phpt [✎] [×]
📄 pg_insert_001.phpt [✎] [×]
📄 pg_insert_002.phpt [✎] [×]
📄 pg_meta_data_001.phpt [✎] [×]
📄 pg_select_001.phpt [✎] [×]
📄 pg_update_001.phpt [✎] [×]
📄 php.gif [✎] [×]
📄 skipif.inc [✎] [×]