dev-chiefworks
26 lines
1.2 KiB
PHP
26 lines
1.2 KiB
PHP
<?php
|
|
require '../backend.php';
|
|
|
|
$httpAuthToken = $savvyext->cfgReadChar('system.oauth2_token');
|
|
$oauth_api = $savvyext->cfgReadChar('system.oauth2_url');
|
|
|
|
$db_host = $savvyext->cfgReadChar('database.host');
|
|
$db_name = $savvyext->cfgReadChar('database.name');
|
|
$db_user = $savvyext->cfgReadChar('database.user');
|
|
$db_pass = $savvyext->cfgReadChar('database.pass');
|
|
$db_port = $savvyext->cfgReadLong('database.port');
|
|
$connstr = "host=${db_host} port=${db_port} dbname=${db_name} user=${db_user} password=${db_pass}";
|
|
$conn = pg_connect($connstr);
|
|
|
|
// Create readOnlyReplicaConn for readonly database
|
|
$db_read_only_host = $savvyext->cfgReadChar('database_replica.host');
|
|
$db_read_only_name = $savvyext->cfgReadChar('database_replica.name');
|
|
$db_read_only_user = $savvyext->cfgReadChar('database_replica.user');
|
|
$db_read_only_pass = $savvyext->cfgReadChar('database_replica.pass');
|
|
$db_read_only_port = $savvyext->cfgReadLong('database_replica.port');
|
|
$readonlyconnstr = "host=${db_read_only_host} port=${db_read_only_port} dbname=${db_read_only_name} user=${db_read_only_user} password=${db_read_only_pass}";
|
|
$readOnlyReplicaConn = pg_connect($readonlyconnstr);
|
|
|
|
$city_keywords = ["city", "province", "capital", "town"];
|
|
|