<?php
/*
* OIDplus 2.0
* Copyright 2019 Daniel Marschall, ViaThinkSoft
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
class OIDplusDatabasePluginPgSql extends OIDplusDatabasePlugin {
private $conn;
private $already_prepared;
public static
function getPluginInformation
(): array {
$out['name'] = 'PostgreSQL';
$out['author'] = 'ViaThinkSoft';
$out['version'] = null;
$out['descriptionHTML'] = null;
return $out;
}
public static function name(): string {
return "PgSQL";
}
public function query(string $sql, /*?array*/ $prepared_args=null): OIDplusQueryResult {
if ($res === false) {
throw new OIDplusSQLException($sql, $this->error());
} else {
return new OIDplusQueryResultPgSql($res);
}
} else {
throw new OIDplusException("'prepared_args' must be either NULL or an ARRAY.");
}
// convert ? ? ? to $1 $2 $3
static $i = 0;
$i++;
return '$'.$i;
}, $sql);
$prepare_name = 'OIDPLUS_'.sha1($sql);
if (!in_array($prepare_name, $this->already_prepared)) {
$res = pg_prepare($this->conn, $prepare_name, $sql);
if ($res === false) {
throw new OIDplusSQLException($sql, 'Cannot prepare statement');
}
$this->already_prepared[] = $prepare_name;
}
foreach ($prepared_args as &$value) {
if (is_bool($value)) $value = $value ?
'1' : '0';
}
$ps = pg_execute($this->conn, $prepare_name, $prepared_args);
if ($ps === false) {
throw new OIDplusSQLException($sql, $this->error());
}
return new OIDplusQueryResultPgSql($ps);
}
}
public function insert_id(): int {
return (int)$this->query('select lastval() as id')->fetch_object()->id;
}
public function error(): string {
if (!$err) $err = '';
return $err;
}
protected function doConnect(): void {
// Try connecting to the database
try {
$err = '';
list($hostname, $port) = explode(':', OIDPLUS_PGSQL_HOST
.':5432');
$username = OIDPLUS_PGSQL_USERNAME;
$password = OIDPLUS_PGSQL_PASSWORD;
$dbname = OIDPLUS_PGSQL_DATABASE;
$this->conn = pg_connect("host=$hostname user=$username password=$password port=$port dbname=$dbname");
} finally {
}
if (!$this->conn) {
throw new OIDplusConfigInitializationException
('Connection to the database failed! ' . strip_tags($err));
}
$this->already_prepared = array();
try {
$this->query("SET NAMES 'utf8'");
} catch (Exception $e) {
}
}
protected function doDisconnect(): void {
$this->already_prepared = array();
}
private $intransaction = false;
public function transaction_begin(): void {
$this->query('begin transaction');
$this->intransaction = true;
}
public function transaction_commit(): void {
$this->query('commit');
$this->intransaction = false;
}
public function transaction_rollback(): void {
$this->query('rollback');
$this->intransaction = false;
}
}
class OIDplusQueryResultPgSql extends OIDplusQueryResult {
protected $no_resultset;
protected $res;
public function __construct($res) {
$this->no_resultset = is_bool($res);
if (!$this->no_resultset) {
$this->res = $res;
}
}
public function __destruct() {
}
public function containsResultSet(): bool {
return !$this->no_resultset;
}
public function num_rows(): int {
if ($this->no_resultset) throw new OIDplusException("The query has returned no result set (i.e. it was not a SELECT query)");
}
public function fetch_array()/*: ?array*/ {
if ($this->no_resultset) throw new OIDplusException("The query has returned no result set (i.e. it was not a SELECT query)");
if ($ret === false) $ret = null;
foreach ($ret as $key => &$value){
if ($type == 'bool'){
$value = ($value == 't');
}
}
}
return $ret;
}
public function fetch_object()/*: ?object*/ {
if ($this->no_resultset) throw new OIDplusException("The query has returned no result set (i.e. it was not a SELECT query)");
if ($ret === false) $ret = null;
foreach ($ret as $key => &$value){
if ($type == 'bool'){
$value = ($value == 't');
}
}
}
return $ret;
}
}