Driver
interface Driver
Supplemental database driver.
Constants
| SUPPORT_SEQUENCE |
|
| SUPPORT_SELECT_UNGROUPED_COLUMNS |
|
| SUPPORT_MULTI_INSERT_AS_SELECT |
|
| SUPPORT_MULTI_COLUMN_AS_OR_COND |
|
| SUPPORT_SUBSELECT |
|
| SUPPORT_SCHEMA |
|
Methods
Initializes connection.
No description
No description
No description
No description
Returns the ID of the last inserted row or sequence value.
Delimits string for use in SQL statement.
Delimits identifier for use in SQL statement.
Encodes string for use in a LIKE statement.
Injects LIMIT/OFFSET to the SQL query.
Returns list of tables as tuples [(string) name, (bool) view, [(string) fullName]]
Returns metadata for all columns in a table.
Returns metadata for all indexes in a table.
Returns metadata for all foreign keys in a table.
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.
at line 32
ResultDriver
query(string $queryString, array $params)
No description
at line 34
void
beginTransaction()
No description
at line 36
void
commit()
No description
at line 38
void
rollBack()
No description
at line 43
string
getInsertId(string|null $sequence = null)
Returns the ID of the last inserted row or sequence value.
at line 48
string
quote(string $string)
Delimits string for use in SQL statement.
at line 53
string
delimite(string $name)
Delimits identifier for use in SQL statement.
at line 58
string
formatDateTime(DateTimeInterface $value)
Formats date-time for use in a SQL statement.
at line 63
string
formatDateInterval(DateInterval $value)
Formats date-time interval for use in a SQL statement.
at line 68
string
formatLike(string $value, int $pos)
Encodes string for use in a LIKE statement.
at line 73
void
applyLimit(string $sql, int|null $limit, int|null $offset)
Injects LIMIT/OFFSET to the SQL query.
at line 80
array
getTables()
Returns list of tables as tuples [(string) name, (bool) view, [(string) fullName]]
at line 86
array
getColumns(string $table)
Returns metadata for all columns in a table.
As tuples [(string) name, (string) table, (string) nativetype, (int) size, (bool) nullable, (mixed) default, (bool) autoincrement, (bool) primary, (array) vendor]]
at line 92
array
getIndexes(string $table)
Returns metadata for all indexes in a table.
As tuples [(string) name, (string[]) columns, (bool) unique, (bool) primary]
at line 98
array
getForeignKeys(string $table)
Returns metadata for all foreign keys in a table.
As tuples [(string) name, (string) local, (string) table, (string) foreign]
at line 104
bool
isSupported(string $item)
Cheks if driver supports specific property