Метод |
Описание |
|
beginTransaction ( ) |
Begin transaction |
|
commit ( ) |
Commit transaction |
|
connection ( ) : object |
Get database connection |
|
count ( Query $query, array $options = [] ) |
*
Count number of rows in source based on conditions |
|
create ( $datasource, array $data, array $options = [] ) |
Create new row object with set properties |
|
createDatabase ( $database ) |
Create a database
Will throw errors if user does not have proper permissions |
|
delete ( $datasource, array $data, array $options = [] ) |
Delete entities matching given conditions |
|
dropDatabase ( $database ) |
Drop a database table
Destructive and dangerous - drops entire table and all data
Will throw errors if user does not have proper permissions |
|
dropDatasource ( $datasource ) |
Drop a database table
Destructive and dangerous - drops entire table and all data |
|
escape ( string $string ) |
Escape/quote direct user input |
|
escapeField ( $field ) |
Escape/quote direct user input |
|
formatMigrateOptions ( array $options ) |
Ensure migration options are full and have all keys required |
|
migrate ( String $table, array $fields, array $options = [] ) |
Migrate table structure changes to database |
|
migrateTableCreate ( String $table, array $formattedFields, array $options = [] ) |
Execute a CREATE TABLE command |
|
migrateTableUpdate ( String $table, array $formattedFields, array $options = [] ) |
Execute an ALTER/UPDATE TABLE command |
|
prepare ( $sql ) |
Prepare an SQL statement |
|
query ( string $sql, array $binds = [] ) |
Find records with custom SQL query |
|
read ( Query $query, array $options = [] ) |
Build a select statement in SQL
Can be overridden by adapters for custom syntax |
|
rollback ( ) |
Rollback transaction |
|
statementBinds ( array $conditions = [], $ci = false ) |
Returns array of binds to pass to query function |
|
statementConditions ( array $conditions = [], $ci ) |
Builds an SQL string given conditions |
|
statementFields ( array $fields = [] ) |
Return fields as a string for a query statement |
|
toCollection ( Query $query, $stmt ) |
Return result set for current query |
|
truncateDatasource ( $datasource ) |
Truncate a database table
Should delete all rows and reset serial/auto_increment keys to 0 |
|
update ( $datasource, array $data, array $where = [], array $options = [] ) |
Update entity |
|