Docs For Class PGSQLConnection

Description

Habari database specific connection class

Located in /system/schema/pgsql/connection.php (line 8)

DatabaseConnection
   |
   --PGSQLConnection

Method Summary

array dbdelta (queries $queries, [(optional) $execute = true], [(optional) $silent = true], [boolean $doinserts = false])

string replace_concat (array $matches)

string sql_t ($sql $sql)

boolean upgrade (integer $old_version, [ $upgrade_path = ''])

Variables

Inherited Variables

Inherited from DatabaseConnection

DatabaseConnection::$pdo
DatabaseConnection::$prefix

Methods

dbdelta (line 57)

automatic diffing function - used for determining required database upgrades based on Owen Winkler's microwiki upgrade function

return: list of updates made

array dbdelta (queries $queries, [(optional) $execute = true], [(optional) $silent = true], [boolean $doinserts = false])

boolean $doinserts: (optional) Execute all insert queries found, default=false
queries $queries: array of create table and insert statements which constitute a fresh install
(optional) $execute: execute should the queries be executed against the database or just simulated. default = true
(optional) $silent: silent silent running with no messages printed? default = true

Redefinition of:

DatabaseConnection::dbdelta(): Automatic diffing function, used for determining required database upgrades.

replace_concat (line 41)

Replaces the MySQL CONCAT function with PostgreSQL-compatible statements

return: The replacement for the MySQL SQL
see: PGSQLConnection::sql_t()
todo: needs work, kind of sucky conversion

string replace_concat (array $matches)

array $matches: Matches from the regex in sql_t()

sql_t (line 20)

Database specific SQL translation function, loosely modelled on the internationalization _t() function.

Call with a database independent SQL string and it will be translated to a PostgreSQL specific SQL string.

return: translated SQL string
todo: Actually implement this.

string sql_t ($sql $sql)

$sql $sql: database independent SQL

Redefinition of:

DatabaseConnection::sql_t(): Translates the query for the current database engine

upgrade (line 337)

Run all of the upgrades since the last database revision.

return: True on success
access: public

boolean upgrade (integer $old_version, [ $upgrade_path = ''])

integer $old_version: The current version of the database that is being upgraded
$upgrade_path

Redefinition of:

DatabaseConnection::upgrade(): Updates the content of the database between versions.

Inherited Methods

Inherited From DatabaseConnection

DatabaseConnection::begin_transaction()
DatabaseConnection::clear_errors()
DatabaseConnection::commit()
DatabaseConnection::connect()
DatabaseConnection::ConnectionFactory()
DatabaseConnection::dbdelta()
DatabaseConnection::delete()
DatabaseConnection::disconnect()
DatabaseConnection::exec()
DatabaseConnection::execute_procedure()
DatabaseConnection::exists()
DatabaseConnection::filter_tables()
DatabaseConnection::get_column()
DatabaseConnection::get_driver_name()
DatabaseConnection::get_errors()
DatabaseConnection::get_keyvalue()
DatabaseConnection::get_last_error()
DatabaseConnection::get_profiles()
DatabaseConnection::get_results()
DatabaseConnection::get_row()
DatabaseConnection::get_value()
DatabaseConnection::has_errors()
DatabaseConnection::insert()
DatabaseConnection::in_transaction()
DatabaseConnection::is_connected()
DatabaseConnection::last_insert_id()
DatabaseConnection::list_tables()
DatabaseConnection::load_tables()
DatabaseConnection::query()
DatabaseConnection::query_file()
DatabaseConnection::register_table()
DatabaseConnection::rollback()
DatabaseConnection::row_count()
DatabaseConnection::set_fetch_class()
DatabaseConnection::set_fetch_mode()
DatabaseConnection::sql_t()
DatabaseConnection::table()
DatabaseConnection::update()
DatabaseConnection::upgrade()