class MySQLEngine implements Engine

MySQL-like database platform.

Methods

__construct(Connection $connection)

No description

bool
isSupported(string $feature)

Checks if the engine supports a specific feature.

string|null
classifyException(DriverException $e)

Maps a driver exception to an appropriate exception class.

string
delimit(string $name)

Adds delimiters around database identifier.

string
formatDateTime(DateTimeInterface $value)

Formats a date-time value for use in an SQL statement.

string
formatDateInterval(DateInterval $value)

Formats a date-time interval for use in an SQL statement.

string
applyLimit(string $sql, int|null $limit, int|null $offset)

Applies LIMIT and OFFSET clauses to an SQL query.

array
getTables()

Returns a list of all tables in the database.

array
getColumns(string $table)

Returns metadata for all columns in a table.

array
getIndexes(string $table)

Returns metadata for all indexes in a table.

array
getForeignKeys(string $table)

Returns metadata for all foreign keys in a table.

mixed
convertToPhp(mixed $value, array $meta, TypeConverter $converter)

Converts a value from the database to a PHP value.

Details

at line 24
__construct(Connection $connection)

No description

Parameters

Connection $connection

at line 30
bool isSupported(string $feature)

Checks if the engine supports a specific feature.

Parameters

string $feature

Return Value

bool

at line 40
string|null classifyException(DriverException $e)

Maps a driver exception to an appropriate exception class.

Parameters

DriverException $e

Return Value

string|null

at line 56
string delimit(string $name)

Adds delimiters around database identifier.

Parameters

string $name

Return Value

string

at line 63
string formatDateTime(DateTimeInterface $value)

Formats a date-time value for use in an SQL statement.

Parameters

DateTimeInterface $value

Return Value

string

at line 69
string formatDateInterval(DateInterval $value)

Formats a date-time interval for use in an SQL statement.

Parameters

DateInterval $value

Return Value

string

at line 75
string applyLimit(string $sql, int|null $limit, int|null $offset)

Applies LIMIT and OFFSET clauses to an SQL query.

Parameters

string $sql
int|null $limit
int|null $offset

Return Value

string

at line 93
array getTables()

Returns a list of all tables in the database.

Return Value

array

at line 115
array getColumns(string $table)

Returns metadata for all columns in a table.

Parameters

string $table

Return Value

array

at line 141
array getIndexes(string $table)

Returns metadata for all indexes in a table.

Parameters

string $table

Return Value

array

at line 157
array getForeignKeys(string $table)

Returns metadata for all foreign keys in a table.

Parameters

string $table

Return Value

array

at line 180
mixed convertToPhp(mixed $value, array $meta, TypeConverter $converter)

Converts a value from the database to a PHP value.

Parameters

mixed $value
array $meta
TypeConverter $converter

Return Value

mixed