xref: /PHP-8.3/ext/pgsql/tests/config.inc (revision 9a90bd70)
1<?php
2
3// These vars are used to connect db and create test table.
4// values can be set to meet your environment with the
5// environment var PGSQL_TEST_CONNSTR
6
7// "test" database must exist. i.e. "createdb test" before testing
8$conn_str = getenv('PGSQL_TEST_CONNSTR') ?: "host=localhost dbname=test port=5432 user=postgres password=postgres";    // connection string
9
10$table_name      = "php_pgsql_test";          // test table that will be created
11$table_name_92   = "php_pgsql_test_92";       // test table that will be created
12$num_test_record = 1000;                      // Number of records to create
13
14// Test view
15$view_name   = "php_pgsql_viewtest";
16$view_def    = "CREATE VIEW {$view_name} AS SELECT * FROM {$table_name};";
17
18// Test table
19$table_def    = "CREATE TABLE {$table_name} (num int, str text, bin bytea);";
20$table_def_92 = "CREATE TABLE {$table_name_92} (textary text[],  jsn json);";
21$field_name = "num";             // For pg_field_num()
22
23?>
24