ILIAS
release_5-3 Revision v5.3.23-19-g915713cf615
|
Class ilDBPdoPostgreSQL. More...
Public Member Functions | ||||||||||
generateDSN () | ||||||||||
connect ($return_false_for_error=false) | ||||||||||
initHelpers () | ||||||||||
getPrimaryKeyIdentifier () | ||||||||||
Primary key identifier. More... | ||||||||||
supportsFulltext () | ||||||||||
supportsTransactions () | ||||||||||
constraintName ($a_table, $a_constraint) | ||||||||||
getIndexName ($index_name_base) | ||||||||||
replace ($a_table, $a_pk_columns, $a_other_columns) | ||||||||||
lockTables ($a_tables) | ||||||||||
unlockTables () | ||||||||||
getStorageEngine () | ||||||||||
setStorageEngine ($storage_engine) | ||||||||||
nextId ($table_name) | ||||||||||
dropTable ($table_name, $error_if_not_existing=false) | ||||||||||
quoteIdentifier ($identifier, $check_option=false) | ||||||||||
tableExists ($table_name) | ||||||||||
tableColumnExists ($table_name, $column_name) | ||||||||||
renameTable ($a_name, $a_new_name) | ||||||||||
createSequence ($table_name, $start=1) | ||||||||||
createTable ($table_name, $fields, $drop_table=false, $ignore_erros=false) | ||||||||||
addPrimaryKey ($table_name, $primary_keys) | ||||||||||
addIndex ($table_name, $fields, $index_name='', $fulltext=false) | ||||||||||
addUniqueConstraint ($table, $fields, $name="con") | ||||||||||
dropPrimaryKey ($table_name) | ||||||||||
Public Member Functions inherited from ilDBPdo | ||||||||||
connect ($return_false_for_error=false) | ||||||||||
initHelpers () | ||||||||||
getFieldDefinition () | ||||||||||
setFieldDefinition ($field_definition) | ||||||||||
createDatabase ($a_name, $a_charset="utf8", $a_collation="") | ||||||||||
getLastErrorCode () | ||||||||||
initFromIniFile ($tmpClientIniFile=null) | ||||||||||
generateDSN () | ||||||||||
quoteIdentifier ($identifier, $check_option=false) | ||||||||||
nextId ($table_name) | ||||||||||
createTable ($table_name, $fields, $drop_table=false, $ignore_erros=false) | ||||||||||
checkColumnName ($a_name) | ||||||||||
addPrimaryKey ($table_name, $primary_keys) | ||||||||||
dropIndexByFields ($table_name, $fields) | ||||||||||
getPrimaryKeyIdentifier () | ||||||||||
createSequence ($table_name, $start=1) | ||||||||||
tableExists ($table_name) | ||||||||||
tableColumnExists ($table_name, $column_name) | ||||||||||
addTableColumn ($table_name, $column_name, $attributes) | ||||||||||
dropTable ($table_name, $error_if_not_existing=true) | ||||||||||
query ($query) | ||||||||||
dropSequence ($table_name) | ||||||||||
dropTableColumn ($table_name, $column_name) | ||||||||||
renameTableColumn ($table_name, $column_old_name, $column_new_name) | ||||||||||
insert ($table_name, $values) | ||||||||||
fetchObject ($query_result) | ||||||||||
update ($table_name, $columns, $where) | ||||||||||
manipulate ($query) | ||||||||||
fetchAssoc ($query_result) | ||||||||||
numRows ($query_result) | ||||||||||
quote ($value, $type=null) | ||||||||||
indexExistsByFields ($table_name, $fields) | ||||||||||
addIndex ($table_name, $fields, $index_name='', $fulltext=false) | ||||||||||
addFulltextIndex ($a_table, $a_fields, $a_name="in") | ||||||||||
dropFulltextIndex ($a_table, $a_name) | ||||||||||
Drop fulltext index. More... | ||||||||||
isFulltextIndex ($a_table, $a_name) | ||||||||||
Is index a fulltext index? More... | ||||||||||
getIndexName ($index_name_base) | ||||||||||
getSequenceName ($table_name) | ||||||||||
constraintName ($a_table, $a_constraint) | ||||||||||
Determine contraint name by table name and constraint name. More... | ||||||||||
getDSN () | ||||||||||
getDBType () | ||||||||||
setDBType ($type) | ||||||||||
lockTables ($tables) | ||||||||||
unlockTables () | ||||||||||
in ($field, $values, $negate=false, $type="") | ||||||||||
queryF ($query, $types, $values) | ||||||||||
manipulateF ($query, $types, $values) | ||||||||||
useSlave ($bool) | ||||||||||
setLimit ($limit, $offset=0) | ||||||||||
Set the Limit for the next Query. More... | ||||||||||
like ($column, $type, $value="?", $case_insensitive=true) | ||||||||||
now () | ||||||||||
replace ($table, $primaryKeys, $otherColumns) | ||||||||||
Replace into method. More... | ||||||||||
equals ($columns, $value, $type, $emptyOrNull=false) | ||||||||||
getHost () | ||||||||||
setHost ($host) | ||||||||||
getDbname () | ||||||||||
setDbname ($dbname) | ||||||||||
getCharset () | ||||||||||
setCharset ($charset) | ||||||||||
getUsername () | ||||||||||
setUsername ($username) | ||||||||||
getPassword () | ||||||||||
setPassword ($password) | ||||||||||
getPort () | ||||||||||
setPort ($port) | ||||||||||
setDBUser ($user) | ||||||||||
setDBPort ($port) | ||||||||||
setDBPassword ($password) | ||||||||||
setDBHost ($host) | ||||||||||
upper ($a_exp) | ||||||||||
lower ($a_exp) | ||||||||||
substr ($a_exp, $a_pos=1, $a_len=-1) | ||||||||||
prepareManip ($query, $types=null) | ||||||||||
prepare ($query, $types=null, $result_types=null) | ||||||||||
enableResultBuffering ($a_status) | ||||||||||
supportsSlave () | ||||||||||
supportsFulltext () | ||||||||||
supportsTransactions () | ||||||||||
supports ($feature) | ||||||||||
listTables () | ||||||||||
loadModule ($module) | ||||||||||
getAllowedAttributes () | ||||||||||
| ||||||||||
sequenceExists ($sequence) | ||||||||||
listSequences () | ||||||||||
concat (array $values, $allow_null=true) | ||||||||||
locate ($a_needle, $a_string, $a_start_pos=1) | ||||||||||
modifyTableColumn ($table, $a_column, $a_attributes) | ||||||||||
renameTable ($a_name, $a_new_name) | ||||||||||
checkTableName ($a_name) | ||||||||||
beginTransaction () | ||||||||||
commit () | ||||||||||
rollback () | ||||||||||
dropIndex ($a_table, $a_name="i1") | ||||||||||
setStorageEngine ($storage_engine) | ||||||||||
getStorageEngine () | ||||||||||
queryCol ($query, $type=PDO::FETCH_ASSOC, $colnum=0) | ||||||||||
queryRow ($query, $types=null, $fetchmode=ilDBConstants::FETCHMODE_DEFAULT) | ||||||||||
getServerVersion ($native=false) | ||||||||||
escape ($value, $escape_wildcards=false) | ||||||||||
escapePattern ($text) | ||||||||||
migrateAllTablesToEngine ($engine=ilDBConstants::MYSQL_ENGINE_INNODB) | ||||||||||
migrateAllTablesToCollation ($collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4) | ||||||||||
supportsCollationMigration () | ||||||||||
supportsEngineMigration () | ||||||||||
checkIndexName ($name) | ||||||||||
addUniqueConstraint ($table, $fields, $name="con") | ||||||||||
dropUniqueConstraint ($a_table, $a_name="con") | ||||||||||
dropUniqueConstraintByFields ($a_table, $a_fields) | ||||||||||
getLastInsertId () | ||||||||||
buildAtomQuery () | ||||||||||
uniqueConstraintExists ($table, array $fields) | ||||||||||
dropPrimaryKey ($table_name) | ||||||||||
executeMultiple ($stmt, $a_data) | ||||||||||
fromUnixtime ($a_expr, $a_to_text=true) | ||||||||||
unixTimestamp () | ||||||||||
autoExecute ($tablename, $fields, $mode=ilDBConstants::MDB2_AUTOQUERY_INSERT, $where=false) | ||||||||||
Generate an insert, update or delete query and call prepare() and execute() on it. More... | ||||||||||
getDBVersion () | ||||||||||
sanitizeMB4StringIfNotSupported ($query) | ||||||||||
| ||||||||||
doesCollationSupportMB4Strings () | ||||||||||
groupConcat ($a_field_name, $a_seperator=",", $a_order=null) | ||||||||||
| ||||||||||
cast ($a_field_name, $a_dest_type) | ||||||||||
| ||||||||||
Public Member Functions inherited from ilDBInterface | ||||||||||
fetchAll ($query_result, $fetch_mode=ilDBConstants::FETCHMODE_ASSOC) | ||||||||||
substr ($a_exp) | ||||||||||
execute ($stmt, $data=array()) | ||||||||||
free ($a_st) | ||||||||||
Data Fields | |
const | POSTGRE_STD_PORT = 5432 |
Data Fields inherited from ilDBPdo | |
const | FEATURE_TRANSACTIONS = 'transactions' |
const | FEATURE_FULLTEXT = 'fulltext' |
const | FEATURE_SLAVE = 'slave' |
Protected Member Functions | |
getAdditionalAttributes () | |
appendLimit ($query) | |
Protected Member Functions inherited from ilDBPdo | |
initSQLMode () | |
getAttributes () | |
getAdditionalAttributes () | |
checkTableColumns ($a_cols) | |
checkColumn ($a_col, $a_def) | |
checkColumnDefinition ($a_def, $a_modify_mode=false) | |
appendLimit ($query) | |
autoPrepare ($table, $table_fields, $mode=ilDBConstants::MDB2_AUTOQUERY_INSERT, $where=false, $types=null, $result_types=ilDBConstants::MDB2_PREPARE_MANIP) | |
buildManipSQL ($table, $table_fields, $mode, $where=false) | |
Protected Attributes | |
$port = self::POSTGRE_STD_PORT | |
$storage_engine = null | |
$manager | |
Protected Attributes inherited from ilDBPdo | |
$host = '' | |
$dbname = '' | |
$charset = 'utf8' | |
$username = '' | |
$password = '' | |
$port = 3306 | |
$pdo | |
$manager | |
$reverse | |
$limit = null | |
$offset = null | |
$storage_engine = 'MyISAM' | |
$dsn = '' | |
$attributes | |
$db_type = '' | |
$error_code = 0 | |
$field_definition | |
Additional Inherited Members | |
Static Public Member Functions inherited from ilDBPdo | |
static | isReservedWord ($a_word) |
Static Public Member Functions inherited from ilDBInterface | |
static | getReservedWords () |
Get reserved words. More... | |
Class ilDBPdoPostgreSQL.
Definition at line 13 of file class.ilDBPdoPostgreSQL.php.
ilDBPdoPostgreSQL::addIndex | ( | $table_name, | |
$fields, | |||
$index_name = '' , |
|||
$fulltext = false |
|||
) |
$table_name | ||
$fields | ||
string | $index_name | |
bool | $fulltext |
Implements ilDBInterface.
Definition at line 435 of file class.ilDBPdoPostgreSQL.php.
References constraintName().
ilDBPdoPostgreSQL::addPrimaryKey | ( | $table_name, | |
$primary_keys | |||
) |
string | $table_name | |
array | $primary_keys |
Implements ilDBInterface.
Definition at line 420 of file class.ilDBPdoPostgreSQL.php.
ilDBPdoPostgreSQL::addUniqueConstraint | ( | $table, | |
$fields, | |||
$name = "con" |
|||
) |
$table | ||
$fields | ||
string | $name |
Implements ilDBPdoInterface.
Definition at line 449 of file class.ilDBPdoPostgreSQL.php.
|
protected |
$query |
Definition at line 322 of file class.ilDBPdoPostgreSQL.php.
References ilDBPdo\$offset, and $query.
ilDBPdoPostgreSQL::connect | ( | $return_false_for_error = false | ) |
bool | $return_false_for_error |
Implements ilDBInterface.
Definition at line 45 of file class.ilDBPdoPostgreSQL.php.
References generateDSN(), ilDBPdo\getAttributes(), ilDBPdo\getDSN(), ilDBPdo\getPassword(), ilDBPdo\getUsername(), and initHelpers().
ilDBPdoPostgreSQL::constraintName | ( | $a_table, | |
$a_constraint | |||
) |
$a_table | |
$a_constraint |
Implements ilDBInterface.
Definition at line 111 of file class.ilDBPdoPostgreSQL.php.
Referenced by addIndex().
ilDBPdoPostgreSQL::createSequence | ( | $table_name, | |
$start = 1 |
|||
) |
$table_name | ||
int | $start |
Implements ilDBInterface.
Definition at line 381 of file class.ilDBPdoPostgreSQL.php.
ilDBPdoPostgreSQL::createTable | ( | $table_name, | |
$fields, | |||
$drop_table = false , |
|||
$ignore_erros = false |
|||
) |
$table_name | ||
$fields | ||
bool | $drop_table | |
bool | $ignore_erros |
Implements ilDBInterface.
Definition at line 402 of file class.ilDBPdoPostgreSQL.php.
References tableExists().
ilDBPdoPostgreSQL::dropPrimaryKey | ( | $table_name | ) |
$table_name |
Implements ilDBPdoInterface.
Definition at line 462 of file class.ilDBPdoPostgreSQL.php.
ilDBPdoPostgreSQL::dropTable | ( | $table_name, | |
$error_if_not_existing = false |
|||
) |
$table_name | ||
bool | $error_if_not_existing |
Implements ilDBInterface.
Definition at line 273 of file class.ilDBPdoPostgreSQL.php.
ilDBPdoPostgreSQL::generateDSN | ( | ) |
Definition at line 30 of file class.ilDBPdoPostgreSQL.php.
References ilDBPdo\getDbname(), ilDBPdo\getHost(), ilDBPdo\getPassword(), ilDBPdo\getPort(), ilDBPdo\getUsername(), and ilDBPdo\setPort().
Referenced by connect().
|
protected |
ilDBPdoPostgreSQL::getIndexName | ( | $index_name_base | ) |
$index_name_base |
Definition at line 123 of file class.ilDBPdoPostgreSQL.php.
ilDBPdoPostgreSQL::getPrimaryKeyIdentifier | ( | ) |
Primary key identifier.
Implements ilDBInterface.
Definition at line 82 of file class.ilDBPdoPostgreSQL.php.
ilDBPdoPostgreSQL::getStorageEngine | ( | ) |
ilDBPdoPostgreSQL::initHelpers | ( | ) |
Definition at line 71 of file class.ilDBPdoPostgreSQL.php.
Referenced by connect().
ilDBPdoPostgreSQL::lockTables | ( | $a_tables | ) |
array | $a_tables |
Implements ilDBInterface.
Definition at line 192 of file class.ilDBPdoPostgreSQL.php.
References $counter, $ilLog, $table, array, ilDBPdo\beginTransaction(), ilDBConstants\LOCK_READ, ilDBConstants\LOCK_WRITE, and ilDBPdo\query().
ilDBPdoPostgreSQL::nextId | ( | $table_name | ) |
string | $table_name |
Implements ilDBInterface.
Definition at line 257 of file class.ilDBPdoPostgreSQL.php.
References $data, $query, $result, and ilDBPdo\query().
ilDBPdoPostgreSQL::quoteIdentifier | ( | $identifier, | |
$check_option = false |
|||
) |
$identifier | ||
bool | $check_option |
Implements ilDBInterface.
Definition at line 294 of file class.ilDBPdoPostgreSQL.php.
ilDBPdoPostgreSQL::renameTable | ( | $a_name, | |
$a_new_name | |||
) |
$a_name | |
$a_new_name |
Implements ilDBInterface.
Definition at line 354 of file class.ilDBPdoPostgreSQL.php.
References array, ilDBPdo\checkTableName(), and tableExists().
ilDBPdoPostgreSQL::replace | ( | $a_table, | |
$a_pk_columns, | |||
$a_other_columns | |||
) |
$a_table | |
$a_pk_columns | |
$a_other_columns |
Implements ilDBInterface.
Definition at line 136 of file class.ilDBPdoPostgreSQL.php.
References array, ilDBPdo\insert(), ilDBPdo\manipulate(), and ilDBPdo\quote().
ilDBPdoPostgreSQL::setStorageEngine | ( | $storage_engine | ) |
$storage_engine |
Implements ilDBInterface.
Definition at line 243 of file class.ilDBPdoPostgreSQL.php.
ilDBPdoPostgreSQL::supportsFulltext | ( | ) |
ilDBPdoPostgreSQL::supportsTransactions | ( | ) |
ilDBPdoPostgreSQL::tableColumnExists | ( | $table_name, | |
$column_name | |||
) |
$table_name | string |
$column_name | string |
Implements ilDBInterface.
Definition at line 342 of file class.ilDBPdoPostgreSQL.php.
ilDBPdoPostgreSQL::tableExists | ( | $table_name | ) |
string | $table_name |
Implements ilDBInterface.
Definition at line 304 of file class.ilDBPdoPostgreSQL.php.
References ilDBPdo\listTables().
Referenced by createTable(), and renameTable().
ilDBPdoPostgreSQL::unlockTables | ( | ) |
Implements ilDBInterface.
Definition at line 231 of file class.ilDBPdoPostgreSQL.php.
References ilDBPdo\commit().
|
protected |
Definition at line 27 of file class.ilDBPdoPostgreSQL.php.
|
protected |
Definition at line 19 of file class.ilDBPdoPostgreSQL.php.
|
protected |
Definition at line 23 of file class.ilDBPdoPostgreSQL.php.
const ilDBPdoPostgreSQL::POSTGRE_STD_PORT = 5432 |
Definition at line 15 of file class.ilDBPdoPostgreSQL.php.