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 JDatabaseDriver | |
static | getConnectors () |
static | getInstance ($options=array()) |
static | splitSql ($sql) |
Fonctions membres publiques statiques hérités de JDatabase | |
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 JDatabaseDriver | |
$name | |
$serverType | |
Fonctions membres protégées | |
fetchArray ($cursor=null) | |
fetchAssoc ($cursor=null) | |
fetchObject ($cursor=null, $class='stdClass') | |
freeResult ($cursor=null) | |
getErrorNumber () | |
getErrorMessage () | |
getCreateDatabaseQuery ($options, $utf) | |
Fonctions membres protégées hérités de JDatabaseDriver | |
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 JDatabaseDriver | |
$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 JDatabaseDriver | |
static | $instances = array() |
static | $dbMinimum |
Fonctions membres privées | |
getDefaultSchema () | |
__construct | ( | $options | ) |
connect | ( | ) |
Connects to the database if needed.
RuntimeException |
Références $tmp.
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.
getAlterTableCharacterSet | ( | $tableName | ) |
Get the query strings to alter the character set and collation of a table.
string | $tableName | The name of the table |
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.
|
protected |
Return the query string to create new Database. Each database driver, other than MySQL, need to override this member to return correct string.
stdClass | $options | Object used to pass user and database name to database driver. This object must have "db_name" and "db_user" set. |
boolean | $utf | True if the database supports the UTF-8 character set. |
Références $options.
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. |
|
private |
Internal function to get the name of the default schema for the current PostgreSQL connection. That is the schema where tables are created by Joomla.
|
protected |
Return the actual SQL Error message
|
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 an 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 JDatabaseQuery object.
boolean | $new | False to return the last query set, True to return a new JDatabaseQuery object. |
boolean | $asObj | False to return last query as string, true to get JDatabaseQueryPostgresql object. |
RuntimeException |
getRandom | ( | ) |
Generate a random value
getStringPositionSql | ( | $substring, | |
$string | |||
) |
getTableColumns | ( | $table, | |
$typeOnly = true |
|||
) |
Retrieves field information about a given table.
string | $table | The name of the database table. For PostgreSQL may start with a schema. |
boolean | $typeOnly | True to only return field types. |
RuntimeException |
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 |
quoteBinary | ( | $data | ) |
Quotes a binary string to database requirements for use in database queries.
mixed | $data | A binary string to quote. |
Références $data.
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, | |
$fieldName, | |||
$fieldValue | |||
) |
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 | $fieldName | The table field's name. |
string | $fieldValue | The variable value to quote and return. |
Références $columns, $fieldValue, et elseif.
|
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' |