DBConnTest.php

<?php

$sharedLibrary = "/var/www/html/shared/library";
require_once("$sharedLibrary/hcuCommon.i");
require_once("$sharedLibrary/hcuEnv.i");
require_once("$sharedLibrary/db.postgres.i");

use PHPUnit\Framework\TestCase;

class DBConnTest extends TestCase
{
    protected static $conn;

    protected function setUp() {
        $dbInfo = HCU_array_key_value("db", LoadSystemEnv("banking"));
        self::$conn = db_connect($dbInfo);
    }

    protected function tearDown() {
        pg_close(self::$conn);
    }

    public function test_db_connection() {
        $this->assertNotFalse(self::$conn);
        $query_result = db_query("select 1", self::$conn);
        $result = (int)pg_fetch_result($query_result, 0, 0);
        $this->assertEquals(1, $result);
    }

    public function test_db_connection_again() {
        $this->assertNotFalse(self::$conn);
        $query_result = db_query("select 2", self::$conn);
        $result = (int)pg_fetch_result($query_result, 0, 0);
        $this->assertEquals(2, $result);
    }
}