Inheritance diagram for PGSQLConnection:
Collaboration diagram for PGSQLConnection:
Public Member Functions | |
| connect ($connect_string, $db_user, $db_pass) | |
| sql_t ($sql) | |
| replace_concat ($matches) | |
| dbdelta ($queries, $execute=true, $silent=true, $doinserts=false) | |
| upgrade_pre ($old_version, $upgrade_path= '') | |
| upgrade_post ($old_version, $upgrade_path= '') | |
Detailed Description
Definition at line 8 of file connection.php.
Member Function Documentation
| PGSQLConnection::connect | ( | $ | connect_string, | |
| $ | db_user, | |||
| $ | db_pass | |||
| ) |
Extends default connection method. It will be useful in order to allow accents and other DB-centric global commands.
- Parameters:
-
string $connect_string a PDO connection string string $db_user the database user name string $db_pass the database user password
- Returns:
- boolean true on success, false on error
Reimplemented from DatabaseConnection.
Definition at line 19 of file connection.php.
| PGSQLConnection::dbdelta | ( | $ | queries, | |
| $ | execute = true, |
|||
| $ | silent = true, |
|||
| $ | doinserts = false | |||
| ) |
automatic diffing function - used for determining required database upgrades based on Owen Winkler's microwiki upgrade function
- Parameters:
-
queries array of create table and insert statements which constitute a fresh install (optional) execute should the queries be executed against the database or just simulated. default = true (optional) silent silent running with no messages printed? default = true boolean $doinserts (optional) Execute all insert queries found, default=false
- Returns:
- array list of updates made
Definition at line 77 of file connection.php.
| PGSQLConnection::replace_concat | ( | $ | matches | ) |
Replaces the MySQL CONCAT function with PostgreSQL-compatible statements
- Todo:
- needs work, kind of sucky conversion
- Parameters:
-
array $matches Matches from the regex in sql_t()
- Returns:
- string The replacement for the MySQL SQL
- See also:
- PGSQLConnection::sql_t()
Definition at line 61 of file connection.php.
| PGSQLConnection::sql_t | ( | $ | sql | ) |
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.
- Parameters:
-
$sql database independent SQL
- Returns:
- string translated SQL string
Reimplemented from DatabaseConnection.
Definition at line 38 of file connection.php.
| PGSQLConnection::upgrade_post | ( | $ | old_version, | |
| $ | upgrade_path = '' | |||
| ) |
Run all of the upgrades slated for post-dbdelta since the last database revision.
- Parameters:
-
integer $old_version The current version of the database that is being upgraded
- Returns:
- boolean True on success
Definition at line 368 of file connection.php.
| PGSQLConnection::upgrade_pre | ( | $ | old_version, | |
| $ | upgrade_path = '' | |||
| ) |
Run all of the upgrades slated for pre-dbdelta since the last database revision.
- Parameters:
-
integer $old_version The current version of the database that is being upgraded
- Returns:
- boolean True on success
Definition at line 357 of file connection.php.
The documentation for this class was generated from the following file:
- system/schema/pgsql/connection.php
