class SQLiteEngine implements Engine

SQLite database platform.

Properties

$formatDateTime

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)

Escapes an identifier for use in an SQL statement.

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 detailed information about columns in a table.

array
getIndexes(string $table)

Returns information about indexes in a table.

array
getForeignKeys(string $table)

Returns information about 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 27
__construct(Connection $connection)

No description

Parameters

Connection $connection

at line 33
bool isSupported(string $feature)

Checks if the engine supports a specific feature.

Parameters

string $feature

Return Value

bool

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

Maps a driver exception to an appropriate exception class.

Parameters

DriverException $e

Return Value

string|null

at line 73
string delimit(string $name)

Escapes an identifier for use in an SQL statement.

Parameters

string $name

Return Value

string

at line 79
string formatDateTime(DateTimeInterface $value)

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

Parameters

DateTimeInterface $value

Return Value

string

at line 85
string formatDateInterval(DateInterval $value)

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

Parameters

DateInterval $value

Return Value

string

at line 91
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 108
array getTables()

Returns a list of all tables in the database.

Return Value

array

at line 133
array getColumns(string $table)

Returns detailed information about columns in a table.

Parameters

string $table

Return Value

array

at line 169
array getIndexes(string $table)

Returns information about indexes in a table.

Parameters

string $table

Return Value

array

at line 216
array getForeignKeys(string $table)

Returns information about foreign keys in a table.

Parameters

string $table

Return Value

array

at line 235
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