1. class
  2. Nette
  3. \
  4. Database
  5. \
  6. Drivers
  7. \
  8. MySqlDriver

MySqlDriver

class MySqlDriver extends PdoDriver

Supplemental MySQL database driver.

Constants

ErrorAccessDenied

ErrorDuplicateEntry

ErrorDataTruncated

deprecated ERROR_ACCESS_DENIED

deprecated ERROR_DUPLICATE_ENTRY

deprecated ERROR_DATA_TRUNCATED

Methods

void
connect(string $dsn, string|null $user = null, string|null $password = null, array|null $options = null)

Driver options:

string|null
detectExceptionClass(PDOException $e)

No description

string
delimite(string $name)

Delimits identifier for use in SQL statement.

string
formatDateTime(DateTimeInterface $value)

Formats date-time for use in a SQL statement.

string
formatDateInterval(DateInterval $value)

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

string
formatLike(string $value, int $pos)

Encodes string for use in a LIKE statement.

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

Injects LIMIT/OFFSET to the SQL query.

array
getTables()

No description

array
getColumns(string $table)

No description

array
getIndexes(string $table)

No description

array
getForeignKeys(string $table)

No description

array
getColumnTypes(PDOStatement $statement)

No description

array
getResultColumns(PDOStatement $statement)

No description

bool
isSupported(string $item)

Cheks if driver supports specific property

Details

at line 44
void connect(string $dsn, string|null $user = null, string|null $password = null, array|null $options = null)

Driver options:

Parameters

string $dsn
string|null $user
string|null $password
array|null $options

Return Value

void

at line 67
string|null detectExceptionClass(PDOException $e)

No description

Parameters

PDOException $e

Return Value

string|null

at line 91
string delimite(string $name)

Delimits identifier for use in SQL statement.

Parameters

string $name

Return Value

string

at line 98
string formatDateTime(DateTimeInterface $value)

Formats date-time for use in a SQL statement.

Parameters

DateTimeInterface $value

Return Value

string

at line 104
string formatDateInterval(DateInterval $value)

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

Parameters

DateInterval $value

Return Value

string

at line 110
string formatLike(string $value, int $pos)

Encodes string for use in a LIKE statement.

Parameters

string $value
int $pos

Return Value

string

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

Injects LIMIT/OFFSET to the SQL query.

Parameters

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

Return Value

void

at line 134
array getTables()

No description

Return Value

array

at line 148
array getColumns(string $table)

No description

Parameters

string $table

Return Value

array

at line 178
array getIndexes(string $table)

No description

Parameters

string $table

Return Value

array

at line 193
array getForeignKeys(string $table)

No description

Parameters

string $table

Return Value

array

at line 214
array getColumnTypes(PDOStatement $statement)

No description

Parameters

PDOStatement $statement

Return Value

array

at line 235
array getResultColumns(PDOStatement $statement)

No description

Parameters

PDOStatement $statement

Return Value

array

at line 257
bool isSupported(string $item)

Cheks if driver supports specific property

Parameters

string $item

Return Value

bool