class Types

Class holding type definitions for MySQL and MariaDB.

Methods

__construct(DatabaseInterface $dbi)

No description

string[]
getUnaryOperators()

Returns list of unary operators.

bool
isUnaryOperator(string $op)

Check whether operator is unary.

string[]
getNullOperators()

Returns list of operators checking for NULL.

string[]
getEnumOperators()

ENUM search operators

string[]
getTextOperators()

TEXT search operators

string[]
getNumberOperators()

Number search operators

string[]
getTypeOperators(string $type, bool $null)

Returns operators for given type

string
getTypeOperatorsHtml(string $type, bool $null, string $selectedOperator = null)

Returns operators for given type as html options

string
getTypeDescription(string $type)

Returns the data type description.

string
getTypeClass(string $type)

Returns class of a type, used for functions available for type or default values.

string[]
getFunctionsClass(string $class)

Returns array of functions available for a class.

string[]
getFunctions(string $type)

Returns array of functions available for a type.

string[]
getAllFunctions()

Returns array of all functions available.

string[]
getAttributes()

Returns array of all attributes available.

string[]
getColumns()

Returns array of all column types available.

string[]
getIntegerTypes()

Returns an array of integer types

string[]
getIntegerRange(string $type, bool $signed = true)

Returns the min and max values of a given integer type

Details

at line 29
__construct(DatabaseInterface $dbi)

Parameters

DatabaseInterface $dbi Database interface instance

at line 39
string[] getUnaryOperators()

Returns list of unary operators.

Return Value

string[]

at line 56
bool isUnaryOperator(string $op)

Check whether operator is unary.

Parameters

string $op operator name

Return Value

bool

at line 66
string[] getNullOperators()

Returns list of operators checking for NULL.

Return Value

string[]

at line 79
string[] getEnumOperators()

ENUM search operators

Return Value

string[]

at line 92
string[] getTextOperators()

TEXT search operators

Return Value

string[]

at line 117
string[] getNumberOperators()

Number search operators

Return Value

string[]

at line 144
string[] getTypeOperators(string $type, bool $null)

Returns operators for given type

Parameters

string $type Type of field
bool $null Whether field can be NULL

Return Value

string[]

at line 173
string getTypeOperatorsHtml(string $type, bool $null, string $selectedOperator = null)

Returns operators for given type as html options

Parameters

string $type Type of field
bool $null Whether field can be NULL
string $selectedOperator Option to be selected

Return Value

string Generated Html

at line 198
string getTypeDescription(string $type)

Returns the data type description.

Parameters

string $type The data type to get a description.

Return Value

string

at line 405
string getTypeClass(string $type)

Returns class of a type, used for functions available for type or default values.

Parameters

string $type The data type to get a class.

Return Value

string

at line 470
string[] getFunctionsClass(string $class)

Returns array of functions available for a class.

Parameters

string $class The class to get function list.

Return Value

string[]

at line 657
string[] getFunctions(string $type)

Returns array of functions available for a type.

Parameters

string $type The data type to get function list.

Return Value

string[]

at line 668
string[] getAllFunctions()

Returns array of all functions available.

Return Value

string[]

at line 685
string[] getAttributes()

Returns array of all attributes available.

Return Value

string[]

at line 704
string[] getColumns()

Returns array of all column types available.

VARCHAR, TINYINT, TEXT and DATE are listed first, based on estimated popularity.

Return Value

string[]

at line 791
string[] getIntegerTypes()

Returns an array of integer types

Return Value

string[] integer types

at line 810
string[] getIntegerRange(string $type, bool $signed = true)

Returns the min and max values of a given integer type

Parameters

string $type integer type
bool $signed whether signed

Return Value

string[] min and max values