/PHP-8.1/ext/pgsql/tests/ |
H A D | pg_select_001.phpt | 14 pg_query($conn, 'CREATE SCHEMA phptests'); 16 pg_query($conn, 'CREATE TABLE phptests.foo (id INT, id2 INT)'); 17 pg_query($conn, 'INSERT INTO phptests.foo VALUES (1,2)'); 18 pg_query($conn, 'INSERT INTO phptests.foo VALUES (2,3)'); 20 pg_query($conn, 'CREATE TABLE phptests.bar (id4 INT, id3 INT)'); 21 pg_query($conn, 'INSERT INTO phptests.bar VALUES (4,5)'); 22 pg_query($conn, 'INSERT INTO phptests.bar VALUES (6,7)'); 39 pg_query($conn, 'DROP TABLE phptests.foo'); 40 pg_query($conn, 'DROP TABLE phptests.bar'); 41 pg_query($conn, 'DROP SCHEMA phptests');
|
H A D | bug37100.phpt | 16 @pg_query("SET bytea_output = 'escape'"); 18 @pg_query('DROP TABLE test_bug'); 20 pg_query('CREATE TABLE test_bug (binfield byteA) ;'); 21 pg_query("INSERT INTO test_bug VALUES (decode('0103AA000812','hex'))"); 24 $data = pg_query("SELECT binfield FROM test_bug"); 31 $data = pg_query($sql); 40 pg_query('DROP TABLE test_bug');
|
H A D | 01createdb.phpt | 14 if (!($q = @pg_query($db, "SELECT * FROM ".$table_name)) || !@pg_num_rows($q)) 16 pg_query($db,$table_def); // Create table here 18 pg_query($db,"INSERT INTO ".$table_name." VALUES ($i, 'ABC');"); 26 if (version_compare($v['server'], '9.2', '>=') && (!($q = @pg_query($db, "SELECT * FROM ".$table_na… 28 pg_query($db,$table_def_92); // Create table here 35 pg_query($db,$view_def);
|
H A D | bug37100_9.phpt | 17 @pg_query($db, 'DROP TABLE test_bug'); 19 pg_query($db, 'CREATE TABLE test_bug (binfield byteA) ;'); 20 pg_query($db, "INSERT INTO test_bug VALUES (decode('0103AA000812','hex'))"); 23 $data = pg_query($db, "SELECT binfield FROM test_bug"); 30 $data = pg_query($db, $sql); 39 pg_query($db, 'DROP TABLE test_bug');
|
H A D | pg_update_001.phpt | 14 pg_query($conn, 'CREATE SCHEMA phptests'); 16 pg_query($conn, 'CREATE TABLE foo (id INT, id2 INT)'); 17 pg_query($conn, 'CREATE TABLE phptests.foo (id INT, id2 INT)'); 29 $rs = pg_query($conn, 'SELECT * FROM foo UNION SELECT * FROM phptests.foo ORDER BY id'); 34 pg_query($conn, 'DROP TABLE foo'); 35 pg_query($conn, 'DROP TABLE phptests.foo'); 36 pg_query($conn, 'DROP SCHEMA phptests');
|
H A D | 09notice.phpt | 25 $res = pg_query($db, 'SET client_min_messages TO NOTICE;'); 32 pg_query($db, "BEGIN;"); 33 pg_query($db, "BEGIN;"); 34 pg_query($db, "BEGIN;"); 35 pg_query($db, "BEGIN;"); 60 Notice: pg_query(): %s already a transaction in progress in %s on line %d 62 Notice: pg_query(): %s already a transaction in progress in %s on line %d 64 Notice: pg_query(): %s already a transaction in progress in %s on line %d
|
H A D | bug64609.phpt | 17 pg_query($db, "BEGIN"); 18 pg_query($db, "CREATE TYPE t_enum AS ENUM ('ok', 'ko')"); 19 pg_query($db, "CREATE TABLE test_enum (a t_enum)"); 24 pg_query($db, "ROLLBACK");
|
H A D | 06copy_2.phpt | 14 pg_query($db, 'CREATE TABLE test_copy (x int)'); 16 pg_query($db, 'COPY test_copy FROM STDIN'); 23 var_dump(pg_fetch_all_columns(pg_query($db, 'SELECT * FROM test_copy ORDER BY 1'))); 25 pg_query($db, 'DROP TABLE test_copy');
|
H A D | 80_bug24499.phpt | 19 @pg_query($dbh, "DROP SEQUENCE id_id_seq"); 20 @pg_query($dbh, "DROP TABLE id"); 21 pg_query($dbh, "CREATE TABLE id (id SERIAL, t INT)"); 24 pg_query($dbh, "INSERT INTO id (t) VALUES ($i)"); 35 $q = pg_query($dbh, "SELECT id FROM id");
|
H A D | pg_delete_001.phpt | 14 pg_query($conn, 'CREATE SCHEMA phptests'); 16 pg_query($conn, 'CREATE TABLE foo (id INT, id2 INT)'); 17 pg_query($conn, 'CREATE TABLE phptests.foo (id INT, id2 INT)'); 37 var_dump(pg_fetch_all(pg_query($conn, 'SELECT * FROM foo'))); 38 var_dump(pg_fetch_all(pg_query($conn, 'SELECT * FROM phptests.foo'))); 44 pg_query($conn, 'DROP TABLE foo'); 45 pg_query($conn, 'DROP TABLE phptests.foo'); 46 pg_query($conn, 'DROP SCHEMA phptests');
|
H A D | 9999dropdb.phpt | 14 pg_query($db, "DROP VIEW {$view_name}"); 15 pg_query($db, "DROP TABLE ".$table_name); 16 @pg_query($db, "DROP TABLE ".$table_name_92);
|
H A D | 80_bug32223b.phpt | 11 @pg_query($conn, "CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'"); 12 $res = @pg_query($conn, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS ' 35 $res = pg_query($dbh, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS ' 42 $res = pg_query($dbh, 'SET client_min_messages TO NOTICE;'); 46 $res = pg_query($dbh, 'SELECT test_notice()');
|
H A D | 80_bug32223.phpt | 11 @pg_query($conn, "CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'"); 12 $res = @pg_query($conn, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS ' 35 $res = pg_query($dbh, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS ' 42 $res = pg_query($dbh, 'SET client_min_messages TO NOTICE;'); 44 $res = pg_query($dbh, 'SELECT test_notice()');
|
H A D | 80_bug27597.phpt | 19 @pg_query($dbh, "DROP TABLE id"); 20 pg_query($dbh, "CREATE TABLE id (id INT)"); 23 pg_query($dbh, "INSERT INTO id (id) VALUES ($i)"); 31 $res = pg_query($dbh, "SELECT * FROM id");
|
H A D | bug47199.phpt | 16 @pg_query($dbh, "DROP TABLE $tbl_name"); 17 pg_query($dbh, "CREATE TABLE $tbl_name (null_field INT, not_null_field INT NOT NULL)"); 22 var_dump(pg_fetch_all(pg_query($dbh, 'SELECT * FROM '. $tbl_name))); 32 var_dump(pg_fetch_all(pg_query($dbh, 'SELECT * FROM '. $tbl_name))); 34 @pg_query($dbh, "DROP TABLE $tbl_name");
|
H A D | pg_insert_001.phpt | 14 pg_query($conn, 'CREATE SCHEMA phptests'); 15 pg_query($conn, 'CREATE TABLE phptests.foo (id INT, id2 INT)'); 26 pg_query($conn, 'DROP TABLE phptests.foo'); 27 pg_query($conn, 'DROP SCHEMA phptests');
|
H A D | gh8253.phpt | 18 pg_query($db, "DROP TABLE IF EXISTS gh8253"); 19 pg_query($db, "CREATE TABLE gh8253 (bar text);"); 21 $res = pg_query($db, "SELECT * FROM gh8253");
|
H A D | bug65119.phpt | 15 pg_query($connection, "begin"); 16 pg_query($connection, "CREATE TABLE bug65119 (i INTEGER)"); 18 pg_query($connection, "rollback");
|
H A D | 18pg_escape_bytea_esc.phpt | 14 @pg_query($db, "SET bytea_output = 'escape'"); 19 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');'); 20 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
|
H A D | 18pg_escape_bytea_hex.phpt | 17 @pg_query($db, "SET bytea_output = 'hex'"); 22 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');'); 23 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
|
H A D | 80_bug42783.phpt | 19 pg_query($dbh, "CREATE TABLE php_test (id SERIAL PRIMARY KEY, time TIMESTAMP NOT NULL DEFAULT now()… 23 var_dump(pg_fetch_assoc(pg_query($dbh, "SELECT * FROM php_test"))); 25 pg_query($dbh, "DROP TABLE php_test");
|
H A D | pg_meta_data_001.phpt | 14 pg_query($conn, 'CREATE SCHEMA phptests'); 16 pg_query($conn, 'CREATE TABLE phptests.foo (id INT, id2 INT)'); 18 pg_query($conn, 'CREATE TABLE foo (id INT, id3 INT)'); 26 pg_query($conn, 'DROP TABLE foo'); 27 pg_query($conn, 'DROP TABLE phptests.foo'); 28 pg_query($conn, 'DROP SCHEMA phptests');
|
H A D | 18pg_escape_bytea_before.phpt | 17 @pg_query($db, "SET bytea_output = 'escape'"); 19 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, E\''.$esc_image.'\');'); 20 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
|
H A D | gh10672.phpt | 16 pg_query($db, "DROP TABLE IF EXISTS gh10672"); 17 pg_query($db, "CREATE TABLE gh10672 (bar text);"); 20 pg_query($db, 'BEGIN');
|
H A D | 21pg_get_notify.phpt | 14 pg_query($db, 'LISTEN test_msg'); 15 pg_query($db, 'NOTIFY test_msg');
|