Method run

compatibility/pg/php/pg_test.php:84–123

($conn)

    }

    public function run($conn) {
        try {
            echo "Running test: " . $this->query . "\n";
            $st = $conn->prepare($this->query);
            $st->execute();
            if ($st->columnCount() == 0) {
                if (count($this->expectedResults) != 0) {
                    echo "Expected " . count($this->expectedResults) . " rows, got 0\n";
                    return false;
                }
                echo "Returns 0 rows\n";
                return true;
            }
            $rows = $st->fetchAll(PDO::FETCH_NUM);
            if (count($rows[0]) != count($this->expectedResults[0])) {
                echo "Expected " . count($this->expectedResults[0]) . " columns, got " . count($rows[0]) . "\n";
                return false;
            }
            foreach ($rows as $i => $row) {
                $row = array_map('strval', $row);
                foreach ($row as $j => $value) {
                    $value = trim($value);
                    $expectedValue = trim($this->expectedResults[$i][$j]);
                    if ($value !== $expectedValue) {
                        echo "Expected: " . $expectedValue . ", got: " . $value . "\n";
                        return false;
                    }
                }
            }
            echo "Returns " . count($rows) . " rows\n";
            if (count($rows) != count($this->expectedResults)) {
                echo "Expected " . count($this->expectedResults) . " rows\n";
                return false;
            }
            return true;
        } catch (PDOException $e) {
            echo $e->getMessage() . "\n";
            return false;
        }
    }
}

PGTest::main(array_slice($argv, 1));