Joomla CMS
3.10.11 (avec JPlatform 13.1 inclus)
Documentation des API du CMS Joomla en version 3.10.11 et du framework Joomla Platform intégré
|
Fonctions membres publiques statiques | |
static | test () |
static | isSupported () |
Fonctions membres publiques statiques hérités de FOFDatabaseDriver | |
static | getConnectors () |
static | getInstance ($options=array()) |
static | splitSql ($sql) |
Fonctions membres publiques statiques hérités de FOFDatabase | |
static | getConnectors () |
static | getInstance ($options=array()) |
static | splitSql ($query) |
static | test () |
Champs de données | |
$name = 'postgresql' | |
$serverType = 'postgresql' | |
Champs de données hérités de FOFDatabaseDriver | |
$name | |
$serverType | |
Fonctions membres protégées | |
fetchArray ($cursor=null) | |
fetchAssoc ($cursor=null) | |
fetchObject ($cursor=null, $class='stdClass') | |
freeResult ($cursor=null) | |
getErrorNumber () | |
getErrorMessage ($query) | |
Fonctions membres protégées hérités de FOFDatabaseDriver | |
fetchArray ($cursor=null) | |
fetchAssoc ($cursor=null) | |
fetchObject ($cursor=null, $class='stdClass') | |
freeResult ($cursor=null) | |
getCreateDatabaseQuery ($options, $utf) | |
getDatabase () | |
quoteNameStr ($strArr) | |
Attributs protégés | |
$nameQuote = '"' | |
$nullDate = '1970-01-01 00:00:00' | |
$concat_operator = '||' | |
$queryObject = null | |
Attributs protégés hérités de FOFDatabaseDriver | |
$connection | |
$count = 0 | |
$cursor | |
$debug = false | |
$limit = 0 | |
$log = array() | |
$timings = array() | |
$callStacks = array() | |
$nameQuote | |
$nullDate | |
$offset = 0 | |
$options | |
$sql | |
$tablePrefix | |
$utf = true | |
$utf8mb4 = false | |
$errorNum = 0 | |
$errorMsg | |
$transactionDepth = 0 | |
$disconnectHandlers = array() | |
Attributs protégés statiques | |
static | $dbMinimum = '8.3.18' |
Attributs protégés statiques hérités de FOFDatabaseDriver | |
static | $instances = array() |
static | $dbMinimum |
PostgreSQL database driver
__construct | ( | $options | ) |
Database object constructor
array | $options | List of options used to configure the connection |
Références $options.
__destruct | ( | ) |
Database object destructor
connect | ( | ) |
Connects to the database if needed.
RuntimeException |
connected | ( | ) |
Determines if the connection to the server is active.
disconnect | ( | ) |
dropTable | ( | $tableName, | |
$ifExists = true |
|||
) |
Drops a table from the database.
string | $tableName | The name of the database table to drop. |
boolean | $ifExists | Optionally specify that the table must exist before it is dropped. |
RuntimeException |
escape | ( | $text, | |
$extra = false |
|||
) |
Method to escape a string for usage in an SQL statement.
string | $text | The string to be escaped. |
boolean | $extra | Optional parameter to provide extra escaping. |
Références $text.
execute | ( | ) |
|
protected |
Method to fetch a row from the result set cursor as an array.
mixed | $cursor | The optional result set cursor from which to fetch the row. |
|
protected |
Method to fetch a row from the result set cursor as an associative array.
mixed | $cursor | The optional result set cursor from which to fetch the row. |
|
protected |
Method to fetch a row from the result set cursor as an object.
mixed | $cursor | The optional result set cursor from which to fetch the row. |
string | $class | The class name to use for the returned row object. |
|
protected |
Method to free up the memory used for the result set.
mixed | $cursor | The optional result set cursor from which to fetch the row. |
getAffectedRows | ( | ) |
Get the number of affected rows by the last INSERT, UPDATE, REPLACE or DELETE for the previous executed SQL statement.
getAlterDbCharacterSet | ( | $dbName | ) |
Get the query string to alter the database character set.
string | $dbName | The database name |
Références $query.
getCollation | ( | ) |
Method to get the database collation in use by sampling a text field of a table in the database.
RuntimeException |
getConnectionCollation | ( | ) |
Method to get the database connection collation, as reported by the driver. If the connector doesn't support reporting this value please return an empty string.
getCreateDbQuery | ( | $options, | |
$utf | |||
) |
Get the query string to create new Database in correct PostgreSQL syntax.
object | $options | object coming from "initialise" function to pass user and database name to database driver. |
boolean | $utf | True if the database supports the UTF-8 character set, not used in PostgreSQL "CREATE DATABASE" query. |
|
protected |
Return the actual SQL Error message
string | $query | The SQL Query that fails |
Références $query.
|
protected |
Return the actual SQL Error number
getNumRows | ( | $cur = null | ) |
Get the number of returned rows for the previous executed SQL statement. This command is only valid for statements like SELECT or SHOW that return an actual result set. To retrieve the number of rows affected by a INSERT, UPDATE, REPLACE or DELETE query, use getAffectedRows().
resource | $cur | An optional database cursor resource to extract the row count from. |
Get the current or query, or new FOFDatabaseQuery object.
boolean | $new | False to return the last query set, True to return a new FOFDatabaseQuery object. |
boolean | $asObj | False to return last query as string, true to get FOFDatabaseQueryPostgresql object. |
RuntimeException |
getRandom | ( | ) |
Generate a random value
getStringPositionSql | ( | $substring, | |
$string | |||
) |
getTableColumns | ( | $table, | |
$typeOnly = true |
|||
) |
getTableCreate | ( | $tables | ) |
Shows the table CREATE statement that creates the given tables.
This is unsupported by PostgreSQL.
mixed | $tables | A table name or a list of table names. |
getTableKeys | ( | $table | ) |
Get the details list of keys for a table.
string | $table | The name of the table. |
RuntimeException |
getTableList | ( | ) |
Method to get an array of all tables in the database.
RuntimeException |
Références $query.
getTableSequences | ( | $table | ) |
getVersion | ( | ) |
Get the version of the database connector.
Références $version.
insertid | ( | ) |
insertObject | ( | $table, | |
& | $object, | ||
$key = null |
|||
) |
Inserts a row into a table based on an object's properties.
string | $table | The name of the database table to insert into. |
object | &$object | A reference to an object whose public properties match the table fields. |
string | $key | The name of the primary key. If provided the object property is updated. |
RuntimeException |
|
static |
Test to see if the PostgreSQL connector is available.
Implémente JDatabaseInterface.
lockTable | ( | $tableName | ) |
Locks a table in the database.
string | $tableName | The name of the table to unlock. |
RuntimeException |
releaseTransactionSavepoint | ( | $savepointName | ) |
Method to release a savepoint.
string | $savepointName | Savepoint's name to release |
Renames a table in the database.
string | $oldTable | The name of the table to be renamed |
string | $newTable | The new name for the table. |
string | $backup | Not used by PostgreSQL. |
string | $prefix | Not used by PostgreSQL. |
RuntimeException |
replacePrefix | ( | $query, | |
$prefix = '#__' |
|||
) |
select | ( | $database | ) |
Selects the database, but redundant for PostgreSQL
string | $database | Database name to select. |
setUtf | ( | ) |
Custom settings for UTF support
showTables | ( | ) |
Returns an array containing database's table list.
Références $query.
sqlValue | ( | $columns, | |
$field_name, | |||
$field_value | |||
) |
This function return a field value as a prepared string to be used in a SQL statement.
array | $columns | Array of table's column returned by ::getTableColumns. |
string | $field_name | The table field's name. |
string | $field_value | The variable value to quote and return. |
|
static |
Test to see if the PostgreSQL connector is available
transactionCommit | ( | $toSavepoint = false | ) |
Method to commit a transaction.
boolean | $toSavepoint | If true, commit to the last savepoint. |
RuntimeException |
transactionRollback | ( | $toSavepoint = false | ) |
Method to roll back a transaction.
boolean | $toSavepoint | If true, rollback to the last savepoint. |
RuntimeException |
transactionSavepoint | ( | $savepointName | ) |
Method to create a savepoint.
string | $savepointName | Savepoint's name to create |
transactionStart | ( | $asSavepoint = false | ) |
Method to initialize a transaction.
boolean | $asSavepoint | If true and a transaction is already active, a savepoint will be created. |
RuntimeException |
unlockTables | ( | ) |
Unlocks tables in the database, this command does not exist in PostgreSQL, it is automatically done on commit or rollback.
RuntimeException |
updateObject | ( | $table, | |
& | $object, | ||
$key, | |||
$nulls = false |
|||
) |
Updates a row in a table based on an object's properties.
string | $table | The name of the database table to update. |
object | &$object | A reference to an object whose public properties match the table fields. |
array | $key | The name of the primary key. |
boolean | $nulls | True to update null fields or false to ignore them. |
RuntimeException |
|
protected |
|
staticprotected |
$name = 'postgresql' |
|
protected |
|
protected |
|
protected |
$serverType = 'postgresql' |