PHP 클래스 Spot\Query\Resolver

보호된 프로퍼티들

프로퍼티	타입	설명
$_noQuote
$mapper	Spot\Mapper

공개 메소드들

메소드	설명
__construct ( Mapper $mapper )	Constructor Method
create ( string $table, array $data )	Create new row object with set properties
dataWithFieldAliasMappings ( array $data )	Taken given field name/value inputs and map them to their aliased names
dropTable ( string $table ) : boolean	Drop Table
escapeIdentifier ( string $identifier ) : string	Escape/quote identifier
exec ( Query $query ) : Doctrine\DBAL\Driver\Statement \| integer	Execute provided query and return result
migrate ( ) : boolean	Migrate table structure changes to database
migrateCreateSchema ( ) : Doctrine\DBAL\Schema\Schema	Migrate create schema
noQuote ( boolean $noQuote = true )	Set field and value quoting on/off - maily used for testing output SQL since quoting is different per platform
read ( Query $query ) : Collection	Find records with custom SQL query
trimSchemaName ( string $identifier ) : string	Trim a leading schema name separated by a dot if present
truncate ( string $table, boolean $cascade = false )	Truncate Table
update ( string $table, array $data, array $where )	Update

보호된 메소드들

메소드	설명
addForeignKeys ( Doctrine\DBAL\Schema\Table $table ) : Doctrine\DBAL\Schema\Table	Add foreign keys from BelongsTo relations to the table schema

메소드 상세

__construct() 공개 메소드

Constructor Method

public __construct ( Mapper $mapper )
$mapper	Spot\Mapper

addForeignKeys() 보호된 메소드

Add foreign keys from BelongsTo relations to the table schema

protected addForeignKeys ( Doctrine\DBAL\Schema\Table $table ) : Doctrine\DBAL\Schema\Table
$table	Doctrine\DBAL\Schema\Table
리턴	Doctrine\DBAL\Schema\Table

create() 공개 메소드

Create new row object with set properties

public create ( string $table, array $data )
$table	string	Table name
$data	array	Array of data to save in 'field' => 'value' format

dataWithFieldAliasMappings() 공개 메소드

Taken given field name/value inputs and map them to their aliased names

public dataWithFieldAliasMappings ( array $data )
$data	array

dropTable() 공개 메소드

Drop Table

public dropTable ( string $table ) : boolean
$table	string	Table name
리턴	boolean

escapeIdentifier() 공개 메소드

Escape/quote identifier

public escapeIdentifier ( string $identifier ) : string
$identifier	string
리턴	string

exec() 공개 메소드

Execute provided query and return result

public exec ( Query $query ) : Doctrine\DBAL\Driver\Statement \| integer
$query	Spot\Query	SQL query to execute
리턴	Doctrine\DBAL\Driver\Statement \| integer

migrate() 공개 메소드

Migrate table structure changes to database

public migrate ( ) : boolean
리턴	boolean

migrateCreateSchema() 공개 메소드

Migrate create schema

public migrateCreateSchema ( ) : Doctrine\DBAL\Schema\Schema
리턴	Doctrine\DBAL\Schema\Schema

noQuote() 공개 메소드

Set field and value quoting on/off - maily used for testing output SQL since quoting is different per platform

public noQuote ( boolean $noQuote = true )
$noQuote	boolean

read() 공개 메소드

Find records with custom SQL query

public read ( Query $query ) : Collection
$query	Spot\Query	SQL query to execute
리턴	Spot\Entity\Collection

trimSchemaName() 공개 메소드

Trim a leading schema name separated by a dot if present

public trimSchemaName ( string $identifier ) : string
$identifier	string
리턴	string

truncate() 공개 메소드

Truncate Table

public truncate ( string $table, boolean $cascade = false )
$table	string	Table name
$cascade	boolean

update() 공개 메소드

Update

public update ( string $table, array $data, array $where )
$table	string	Table name
$data	array	Array of data for WHERE clause in 'field' => 'value' format
$where	array

프로퍼티 상세

$_noQuote 보호되어 있는 프로퍼티

protected $_noQuote

$mapper 보호되어 있는 프로퍼티

protected Mapper,Spot $mapper
리턴	Spot\Mapper