PHP Класс Spot\Adapter\PDO\BaseAbstract

Наследование: extends Spot\Adapter\AdapterAbstract, implements Spot\Adapter\AdapterInterface
Показать файл Открыть проект

Защищенные свойства (Protected)

Свойство Тип Описание
$_database

Открытые методы

Метод Описание
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

Защищенные методы

Метод Описание
bindValues ( PDOStatement $stmt, array $binds ) Bind array of field/value data to given statement
shouldUpdateMigrateField ( array $formattedField, array $columnInfo ) : boolean Should we update the field

Описание методов

beginTransaction() публичный Метод

Begin transaction
public beginTransaction ( )

bindValues() защищенный Метод

Bind array of field/value data to given statement
protected bindValues ( PDOStatement $stmt, array $binds )
$stmt PDOStatement
$binds array

commit() публичный Метод

Commit transaction
public commit ( )

connection() публичный Метод

Get database connection
public connection ( ) : object
Результат object PDO

count() публичный Метод

* Count number of rows in source based on conditions
public count ( Query $query, array $options = [] )
$query Spot\Query
$options array

create() публичный Метод

Create new row object with set properties
public create ( $datasource, array $data, array $options = [] )
$data array
$options array

createDatabase() публичный Метод

Create a database Will throw errors if user does not have proper permissions
public createDatabase ( $database )

delete() публичный Метод

Delete entities matching given conditions
public delete ( $datasource, array $data, array $options = [] )
$data array
$options array

dropDatabase() публичный Метод

Drop a database table Destructive and dangerous - drops entire table and all data Will throw errors if user does not have proper permissions
public dropDatabase ( $database )

dropDatasource() публичный Метод

Drop a database table Destructive and dangerous - drops entire table and all data
public dropDatasource ( $datasource )

escape() публичный Метод

Escape/quote direct user input
public escape ( string $string )
$string string

escapeField() публичный Метод

Escape/quote direct user input
public escapeField ( $field )

formatMigrateOptions() публичный Метод

Ensure migration options are full and have all keys required
public formatMigrateOptions ( array $options )
$options array

migrate() публичный Метод

Migrate table structure changes to database
public migrate ( String $table, array $fields, array $options = [] )
$table String Table name
$fields array Fields and their attributes as defined in the mapper
$options array Options that may affect migrations or how tables are setup

migrateTableCreate() публичный Метод

Execute a CREATE TABLE command
public migrateTableCreate ( String $table, array $formattedFields, array $options = [] )
$table String Table name
$formattedFields array
$options array Options that may affect migrations or how tables are setup

migrateTableUpdate() публичный Метод

Execute an ALTER/UPDATE TABLE command
public migrateTableUpdate ( String $table, array $formattedFields, array $options = [] )
$table String Table name
$formattedFields array
$options array Options that may affect migrations or how tables are setup

prepare() публичный Метод

Prepare an SQL statement
public prepare ( $sql )

query() публичный Метод

Find records with custom SQL query
public query ( string $sql, array $binds = [] )
$sql string SQL query to execute
$binds array Array of bound parameters to use as values for query

read() публичный Метод

Build a select statement in SQL Can be overridden by adapters for custom syntax
public read ( Query $query, array $options = [] )
$query Spot\Query
$options array

rollback() публичный Метод

Rollback transaction
public rollback ( )

shouldUpdateMigrateField() защищенный Метод

Should we update the field
protected shouldUpdateMigrateField ( array $formattedField, array $columnInfo ) : boolean
$formattedField array The formatted field
$columnInfo array
Результат boolean

statementBinds() публичный Метод

Returns array of binds to pass to query function
public statementBinds ( array $conditions = [], $ci = false )
$conditions array

statementConditions() публичный Метод

Builds an SQL string given conditions
public statementConditions ( array $conditions = [], $ci )
$conditions array

statementFields() публичный Метод

Return fields as a string for a query statement
public statementFields ( array $fields = [] )
$fields array

toCollection() публичный Метод

Return result set for current query
public toCollection ( Query $query, $stmt )
$query Spot\Query

truncateDatasource() публичный Метод

Truncate a database table Should delete all rows and reset serial/auto_increment keys to 0
public truncateDatasource ( $datasource )

update() публичный Метод

Update entity
public update ( $datasource, array $data, array $where = [], array $options = [] )
$data array
$where array
$options array

Описание свойств

$_database защищенное свойство

protected $_database