Database
class Database
Manages database connection and executes SQL queries.
Constants
private Drivers |
|
private TypeConverterOptions |
|
Properties
$onConnect | |||
$onQuery |
Methods
No description
No description
No description
No description
Disconnects and connects to database again.
Disconnects from database.
No description
No description
No description
No description
No description
No description
No description
No description
No description
Quotes string for use in SQL.
Starts a transaction.
Commits current transaction.
Rolls back current transaction.
Executes callback inside a transaction.
No description
No description
No description
No description
No description
No description
Shortcut for query()->fetch()
Shortcut for query()->fetchAssoc()
Shortcut for query()->fetchField()
Shortcut for query()->fetchList()
Shortcut for query()->fetchList()
Shortcut for query()->fetchPairs()
Shortcut for query()->fetchAll()
Creates SQL literal value.
No description
No description
No description
Details
at line 52
static Database
createFromParameters(...$params)
No description
at line 85
static Database
createFromDsn(string $dsn, string|null $username = null, string|null $password = null, array $options = [])
No description
at line 105
__construct(Driver|string $driver)
No description
at line 121
void
connect()
No description
at line 143
void
reconnect()
Disconnects and connects to database again.
at line 153
void
disconnect()
Disconnects from database.
at line 159
string
getDsn()
No description
at line 166
PDO
getPdo()
No description
at line 174
Connection
getConnection()
No description
at line 181
Connection
getSupplementalDriver()
No description
at line 189
Engine
getDatabaseEngine()
No description
at line 195
string
getServerVersion()
No description
at line 201
Reflection
getReflection()
No description
at line 207
TypeConverter
getTypeConverter()
No description
at line 213
Database
setRowNormalizer(callable|null $normalizer)
No description
at line 220
int|string
getInsertId(string|null $sequence = null)
No description
at line 233
string
quote(string $string)
Quotes string for use in SQL.
at line 243
void
beginTransaction()
Starts a transaction.
at line 259
void
commit()
Commits current transaction.
at line 279
void
rollBack()
Rolls back current transaction.
at line 298
mixed
transaction(callable $callback)
Executes callback inside a transaction.
at line 312
void
setAutoCommit(bool $state)
No description
at line 333
void
createSavepoint(int $level)
No description
at line 339
void
releaseSavepoint(int $level)
No description
at line 349
Result
query(string $sql, ...$params)
Generates and executes SQL query.
at line 359
Result
queryArgs(string $sql, array $params)
No description
at line 371
array
preprocess(string $sql, ...$params)
No description
at line 399
SqlLiteral|null
getLastQuery()
No description
at line 405
string|null
getLastQueryString()
No description
at line 427
Row|null
fetch(string $sql, ...$params)
Shortcut for query()->fetch()
at line 437
array|null
fetchAssoc(string $sql, ...$params)
Shortcut for query()->fetchAssoc()
at line 447
mixed
fetchField(string $sql, ...$params)
Shortcut for query()->fetchField()
at line 457
array|null
fetchList(string $sql, ...$params)
Shortcut for query()->fetchList()
at line 467
array|null
fetchFields(string $sql, ...$params)
Shortcut for query()->fetchList()
at line 477
array
fetchPairs(string $sql, ...$params)
Shortcut for query()->fetchPairs()
at line 487
array
fetchAll(string $sql, ...$params)
Shortcut for query()->fetchAll()
at line 496
static SqlLiteral
literal(string $value, ...$params)
Creates SQL literal value.
at line 505
Selection
table(string $table)
No description
at line 511
Database
setCache(Cache $cache)
No description
at line 522
Cache|null
getCache()
internal |
No description
at line 528
Database
setConventions(Conventions $conventions)
No description
at line 539
Conventions
getConventions()
internal |
No description
at line 546
Structure
getStructure()
internal |
No description