class Types (View source)

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[]
getUUIDOperators()

UUID 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.

array
getColumns()

Returns array of all column types available.

string[]
getIntegerTypes()

Returns an array of integer types

array
getFloatTypes()

Returns an array of float types

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

Returns the min and max values of a given integer type

Details

__construct(DatabaseInterface $dbi)

No description

Parameters

DatabaseInterface $dbi

Database interface instance

string[] getUnaryOperators()

Returns list of unary operators.

Return Value

string[]

bool isUnaryOperator(string $op)

Check whether operator is unary.

Parameters

string $op

operator name

Return Value

bool

string[] getNullOperators()

Returns list of operators checking for NULL.

Return Value

string[]

string[] getEnumOperators()

ENUM search operators

Return Value

string[]

string[] getTextOperators()

TEXT search operators

Return Value

string[]

string[] getNumberOperators()

Number search operators

Return Value

string[]

string[] getUUIDOperators()

UUID search operators

Return Value

string[]

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[]

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

string getTypeDescription(string $type)

Returns the data type description.

Parameters

string $type

The data type to get a description.

Return Value

string

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

string[] getFunctionsClass(string $class)

Returns array of functions available for a class.

Parameters

string $class

The class to get function list.

Return Value

string[]

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[]

string[] getAllFunctions()

Returns array of all functions available.

Return Value

string[]

string[] getAttributes()

Returns array of all attributes available.

Return Value

string[]

array getColumns()

Returns array of all column types available.

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

Return Value

array

string[] getIntegerTypes()

Returns an array of integer types

Return Value

string[]

integer types

array getFloatTypes()

Returns an array of float types

Return Value

array

float types

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