1. interface
  2. Nette
  3. \
  4. Database
  5. \
  6. Driver

Driver

interface Driver

Supplemental database driver.

Constants

SupportSequence

SupportSelectUngroupedColumns

SupportMultiInsertAsSelect

SupportMultiColumnAsOrCond

SupportSubselect

SupportSchema

Methods

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

Initializes connection.

ResultDriver
query(string $queryString, array $params)

No description

void
beginTransaction()

No description

void
commit()

No description

void
rollBack()

No description

string
getInsertId(string|null $sequence = null)

Returns the ID of the last inserted row or sequence value.

string
quote(string $string)

Delimits string for use in SQL statement.

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

bool
isSupported(string $item)

Cheks if driver supports specific property

Details

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

Initializes connection.

Parameters

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

Return Value

void

Exceptions

ConnectionException

at line 32
ResultDriver query(string $queryString, array $params)

No description

Parameters

string $queryString
array $params

Return Value

ResultDriver

at line 34
void beginTransaction()

No description

Return Value

void

at line 36
void commit()

No description

Return Value

void

at line 38
void rollBack()

No description

Return Value

void

at line 43
string getInsertId(string|null $sequence = null)

Returns the ID of the last inserted row or sequence value.

Parameters

string|null $sequence

Return Value

string

at line 48
string quote(string $string)

Delimits string for use in SQL statement.

Parameters

string $string

Return Value

string

at line 53
string delimite(string $name)

Delimits identifier for use in SQL statement.

Parameters

string $name

Return Value

string

at line 58
string formatDateTime(DateTimeInterface $value)

Formats date-time for use in a SQL statement.

Parameters

DateTimeInterface $value

Return Value

string

at line 63
string formatDateInterval(DateInterval $value)

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

Parameters

DateInterval $value

Return Value

string

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

Encodes string for use in a LIKE statement.

Parameters

string $value
int $pos

Return Value

string

at line 73
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 78
array getTables()

No description

Return Value

array

at line 81
array getColumns(string $table)

No description

Parameters

string $table

Return Value

array

at line 84
array getIndexes(string $table)

No description

Parameters

string $table

Return Value

array

at line 87
array getForeignKeys(string $table)

No description

Parameters

string $table

Return Value

array

at line 93
bool isSupported(string $item)

Cheks if driver supports specific property

Parameters

string $item

Return Value

bool