Helper extends Common
FinalYes
Table of Contents
Methods
- addAutoIncrement() : mixed
- checkColumnExists() : mixed
- checkIndexNameExists() : mixed
- checkIsType() : mixed
- checkTableExists() : mixed
- createIndex() : mixed
- dropIndexByName() : mixed
- dropTable() : mixed
- getAutoIncrementSql() : mixed
- getDataTypeSql() : mixed
- getMaxTransferUnit() : mixed
- getTemporaryTableNameSql() : mixed
- getTemporaryTableSubQuerySql() : mixed
- getTruncateTextFunction() : mixed
- insertBatch() : mixed
- Inserts rows in batch mode.
- makeFilter() : array<string|int, mixed>
- todo: this function was tested only on trivial filters todo: this function does not support nested filters
- mergeTables() : mixed
- parseFilter() : mixed
- truncateTable() : mixed
- wrapColumnWithFunction() : mixed
Methods
addAutoIncrement()
public
static addAutoIncrement() : mixed
checkColumnExists()
public
static checkColumnExists(mixed $tableName, mixed $columnName) : mixed
Parameters
- $tableName : mixed
- $columnName : mixed
checkIndexNameExists()
public
static checkIndexNameExists(mixed $indexName, mixed $tableName) : mixed
Parameters
- $indexName : mixed
- $tableName : mixed
checkIsType()
public
static checkIsType(mixed $type) : mixed
Parameters
- $type : mixed
checkTableExists()
public
static checkTableExists(mixed $tableName) : mixed
Parameters
- $tableName : mixed
createIndex()
public
static createIndex(mixed $tableName, mixed $ixNamePostfix[, mixed $columns = array() ][, mixed $unique = false ]) : mixed
Parameters
- $tableName : mixed
- $ixNamePostfix : mixed
- $columns : mixed = array()
- $unique : mixed = false
dropIndexByName()
public
static dropIndexByName(mixed $indexName, mixed $tableName) : mixed
Parameters
- $indexName : mixed
- $tableName : mixed
dropTable()
public
static dropTable(mixed $tableName) : mixed
Parameters
- $tableName : mixed
getAutoIncrementSql()
public
static getAutoIncrementSql() : mixed
getDataTypeSql()
public
static getDataTypeSql(mixed $type[, mixed $len = 0 ]) : mixed
Parameters
- $type : mixed
- $len : mixed = 0
getMaxTransferUnit()
public
static getMaxTransferUnit() : mixed
getTemporaryTableNameSql()
public
static getTemporaryTableNameSql() : mixed
getTemporaryTableSubQuerySql()
public
static getTemporaryTableSubQuerySql(mixed $selectSql, mixed $columnName) : mixed
Parameters
- $selectSql : mixed
- $columnName : mixed
getTruncateTextFunction()
public
static getTruncateTextFunction(mixed $columnName) : mixed
Parameters
- $columnName : mixed
insertBatch()
Inserts rows in batch mode.
public
static insertBatch(mixed $tableName, array<string|int, mixed> $items[, bool $ignore = false ]) : mixed
Parameters
- $tableName : mixed
- $items : array<string|int, mixed>
-
todo: refactor this, get rid of 'if condition'
- $ignore : bool = false
makeFilter()
todo: this function was tested only on trivial filters todo: this function does not support nested filters
public
static makeFilter(array<string|int, mixed> $conditions) : array<string|int, mixed>
Parameters
- $conditions : array<string|int, mixed>
Return values
array<string|int, mixed>mergeTables()
public
static mergeTables(mixed $toTable, mixed $fromTable, mixed $fldMap, mixed $fldCondition) : mixed
Parameters
- $toTable : mixed
- $fromTable : mixed
- $fldMap : mixed
- $fldCondition : mixed
parseFilter()
public
static parseFilter(array<string|int, mixed> $filter) : mixed
Parameters
- $filter : array<string|int, mixed>
truncateTable()
public
static truncateTable(mixed $tableName) : mixed
Parameters
- $tableName : mixed
wrapColumnWithFunction()
public
static wrapColumnWithFunction(mixed $columnName[, mixed $functions = array() ]) : mixed
Parameters
- $columnName : mixed
- $functions : mixed = array()