Documentation

MariaQueryBuilder extends QueryBuilder
in package

Table of Contents

CONFIG_MAX_LIMIT  = 'entities.query_builder.max_limit'
DEFAULT_MAX_LIMIT  = 1000
INDENTATION  = ' '
SIMPLE_TYPE_MAP  = [\Dynart\Micro\Entities\EntityManager::TYPE_LONG => 'bigint', \Dynart\Micro\Entities\EntityManager::TYPE_INT => 'int', \Dynart\Micro\Entities\EntityManager::TYPE_FLOAT => 'float', \Dynart\Micro\Entities\EntityManager::TYPE_DOUBLE => 'double', \Dynart\Micro\Entities\EntityManager::TYPE_BOOL => 'tinyint(1)', \Dynart\Micro\Entities\EntityManager::TYPE_DATE => 'date', \Dynart\Micro\Entities\EntityManager::TYPE_TIME => 'time', \Dynart\Micro\Entities\EntityManager::TYPE_DATETIME => 'datetime', \Dynart\Micro\Entities\EntityManager::TYPE_BLOB => 'blob']
$currentClassNameForException  : string
$currentColumnNameForException  : string
$db  : Database
$em  : EntityManager
$maxLimit  : int
$subQueryCounter  : int
__construct()  : mixed
columnDefinition()  : string
columnsByTableDescription()  : array<string|int, mixed>
createTable()  : string
describeTable()  : string
fieldNames()  : array<string|int, mixed>
findAll()  : string
findAllCount()  : string
foreignKeyDefinition()  : string
isTableExist()  : string
listTables()  : string
primaryKeyDefinition()  : string
checkArraySize()  : void
checkIntSize()  : void
currentColumn()  : string
groupBy()  : string
isDateType()  : bool
joins()  : string
limit()  : string
orderBy()  : string
select()  : string
sqlAction()  : string
sqlDefaultValue()  : string
sqlType()  : string
where()  : string

Constants

CONFIG_MAX_LIMIT

public mixed CONFIG_MAX_LIMIT = 'entities.query_builder.max_limit'

SIMPLE_TYPE_MAP

public mixed SIMPLE_TYPE_MAP = [\Dynart\Micro\Entities\EntityManager::TYPE_LONG => 'bigint', \Dynart\Micro\Entities\EntityManager::TYPE_INT => 'int', \Dynart\Micro\Entities\EntityManager::TYPE_FLOAT => 'float', \Dynart\Micro\Entities\EntityManager::TYPE_DOUBLE => 'double', \Dynart\Micro\Entities\EntityManager::TYPE_BOOL => 'tinyint(1)', \Dynart\Micro\Entities\EntityManager::TYPE_DATE => 'date', \Dynart\Micro\Entities\EntityManager::TYPE_TIME => 'time', \Dynart\Micro\Entities\EntityManager::TYPE_DATETIME => 'datetime', \Dynart\Micro\Entities\EntityManager::TYPE_BLOB => 'blob']

Properties

$currentClassNameForException

protected string $currentClassNameForException = ''

$currentColumnNameForException

protected string $currentColumnNameForException = ''

$subQueryCounter

private static int $subQueryCounter = 0

Methods

columnDefinition()

public columnDefinition(string $columnName, array<string|int, mixed> $columnData) : string
Parameters
$columnName : string
$columnData : array<string|int, mixed>
Return values
string —

columnsByTableDescription()

public columnsByTableDescription(array<string|int, mixed> $data) : array<string|int, mixed>
Parameters
$data : array<string|int, mixed>
Return values
array<string|int, mixed> —

createTable()

public createTable(string $className[, bool $ifNotExists = false ]) : string
Parameters
$className : string
$ifNotExists : bool = false
Return values
string —

describeTable()

public describeTable(string $className) : string
Parameters
$className : string
Return values
string —

fieldNames()

public fieldNames(array<string|int, mixed> $fields) : array<string|int, mixed>
Parameters
$fields : array<string|int, mixed>
Return values
array<string|int, mixed> —

findAll()

public findAll(Query $query[, array<string|int, mixed> $fields = [] ]) : string
Parameters
$query : Query
$fields : array<string|int, mixed> = []
Return values
string —

findAllCount()

public findAllCount(Query $query) : string
Parameters
$query : Query
Return values
string —

foreignKeyDefinition()

public foreignKeyDefinition(string $columnName, array<string|int, mixed> $columnData) : string
Parameters
$columnName : string
$columnData : array<string|int, mixed>
Return values
string —

isTableExist()

public isTableExist(string $dbNameParam, string $tableNameParam) : string
Parameters
$dbNameParam : string
$tableNameParam : string
Return values
string —

primaryKeyDefinition()

public primaryKeyDefinition(string $className) : string
Parameters
$className : string
Return values
string —

checkArraySize()

protected checkArraySize(mixed $size, int $count) : void
Parameters
$size : mixed
$count : int
Return values
void —

checkIntSize()

protected checkIntSize(mixed $size) : void
Parameters
$size : mixed
Return values
void —

currentColumn()

protected currentColumn() : string
Return values
string —

isDateType()

protected isDateType(string $type) : bool
Parameters
$type : string
Return values
bool —

select()

protected select(Query $query[, array<string|int, mixed> $fields = [] ]) : string
Parameters
$query : Query
$fields : array<string|int, mixed> = []
Return values
string —

sqlAction()

protected sqlAction(string $action) : string
Parameters
$action : string
Return values
string —

sqlDefaultValue()

protected sqlDefaultValue(mixed $value, string $type, int $size) : string
Parameters
$value : mixed
$type : string
$size : int
Return values
string —

sqlType()

protected sqlType(string $type, mixed $size, bool $fixSize) : string
Parameters
$type : string
$size : mixed
$fixSize : bool
Return values
string —

Search results