<?
/*
    PHP Table class - Data aquisition and rendering framework
    Copyright (C) 2002 Richard Clark (rclark@exorsus.net)
    Copyright (C) 2002 Marek 'marx' Grac (xgrac@fi.muni.cz)

    See the GNU General Public License included with this software
    for more details. If none is included you have NO LICENSE to
    operate this software and should contact the author immediately.
 */

require_once('table_data.inc');

class Table_Data_PgSQL extends Table_Data {
	var $dbh;

	function Table_Data_PgSQL($dbh, $query, $fields, $default_orderby="") {

		$this->dbh = $dbh;

		parent::Table_Data($query, $fields, $default_orderby);

		if ($this->orderby && !preg_match('/order by/',$query)) {
			$this->data_source .= " order by ".$this->orderby;
		}
	}

	function aquire() {
		$result = pg_query($this->dbh, $this->data_source);
		$num_rows = pg_num_rows($result);
		if (!($result)) {
			return;
		}

		for ($i=0; $i < $num_rows; $i++) {
			$row = pg_fetch_array($result, $i, PGSQL_ASSOC);
			$this->add_row($row);
		}
	}
}

?>