class MSSQLEngine implements Engine

MS SQL 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)

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 23
__construct(Connection $connection)

No description

Parameters

Connection $connection

at line 29
bool isSupported(string $feature)

Checks if the engine supports a specific feature.

Parameters

string $feature

Return Value

bool

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

Maps a driver exception to an appropriate exception class.

Parameters

DriverException $e

Return Value

string|null

at line 44
string delimit(string $name)

Escapes an identifier for use in an SQL statement.

Parameters

string $name

Return Value

string

at line 51
string formatDateTime(DateTimeInterface $value)

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

Parameters

DateTimeInterface $value

Return Value

string

at line 57
string formatDateInterval(DateInterval $value)

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

Parameters

DateInterval $value

Return Value

string

at line 63
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 85
array getTables()

Returns a list of all tables in the database.

Return Value

array

at line 100
array getColumns(string $table)

Returns detailed information about columns in a table.

Parameters

string $table

Return Value

array

at line 142
array getIndexes(string $table)

Returns information about indexes in a table.

Parameters

string $table

Return Value

array

at line 177
array getForeignKeys(string $table)

Returns information about foreign keys in a table.

Parameters

string $table

Return Value

array

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