MySQLBuilder Class
Aurora\Database\Query\Builder Namespace
Extends
Interfaces
Constructor
__construct
Signature
public function __construct()
Methods
__construct
Signature
public function __construct()
build
Build query
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query blueprint
Return Value
\CompiledQuery
Signature
public function build(Aurora\Database\Query\Blueprint $blueprint): Aurora\Database\Query\CompiledQuery
compileColumns
Compile columns
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query Blueprint -
Aurora\Database\Query\CompiledQuery
$compiled
— Compiled Query -
mixed
$prefix
— Prefix -
mixed
$suffix
— Suffix
Return Value
string
Signature
protected function compileColumns(Aurora\Database\Query\Blueprint $blueprint, Aurora\Database\Query\CompiledQuery $compiled, mixed $prefix, mixed $suffix): string
compileTables
Compile tables
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query Blueprint -
Aurora\Database\Query\CompiledQuery
$compiled
— Compiled Query -
mixed
$prefix
— Prefix -
mixed
$suffix
— Suffix
Return Value
string
Signature
protected function compileTables(Aurora\Database\Query\Blueprint $blueprint, Aurora\Database\Query\CompiledQuery $compiled, mixed $prefix, mixed $suffix): string
compileJoin
Compile JOIN statements
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query Blueprint -
Aurora\Database\Query\CompiledQuery
$compiled
— Compiled Query -
mixed
$prefix
— Prefix -
mixed
$suffix
— Suffix
Return Value
string
Signature
protected function compileJoin(Aurora\Database\Query\Blueprint $blueprint, Aurora\Database\Query\CompiledQuery $compiled, mixed $prefix, mixed $suffix): string
compileWhere
Compile WHERE statements
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query Blueprint -
Aurora\Database\Query\CompiledQuery
$compiled
— Compiled Query -
mixed
$prefix
— Prefix -
mixed
$suffix
— Suffix
Return Value
string
Signature
protected function compileWhere(Aurora\Database\Query\Blueprint $blueprint, Aurora\Database\Query\CompiledQuery $compiled, mixed $prefix, mixed $suffix): string
compileHaving
Compile HAVING statements
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query Blueprint -
Aurora\Database\Query\CompiledQuery
$compiled
— Compiled Query -
mixed
$prefix
— Prefix -
mixed
$suffix
— Suffix
Return Value
string
Signature
protected function compileHaving(Aurora\Database\Query\Blueprint $blueprint, Aurora\Database\Query\CompiledQuery $compiled, mixed $prefix, mixed $suffix): string
compileOrder
Compile ORDER statements
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query Blueprint -
Aurora\Database\Query\CompiledQuery
$compiled
— Compiled Query -
mixed
$prefix
— Prefix -
mixed
$suffix
— Suffix
Return Value
string
Signature
protected function compileOrder(Aurora\Database\Query\Blueprint $blueprint, Aurora\Database\Query\CompiledQuery $compiled, mixed $prefix, mixed $suffix): string
compileGroup
Compile GROUP statements
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query Blueprint -
Aurora\Database\Query\CompiledQuery
$compiled
— Compiled Query -
mixed
$prefix
— Prefix -
mixed
$suffix
— Suffix
Return Value
string
Signature
protected function compileGroup(Aurora\Database\Query\Blueprint $blueprint, Aurora\Database\Query\CompiledQuery $compiled, mixed $prefix, mixed $suffix): string
compileLimit
Compile LIMIT statements
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query Blueprint -
Aurora\Database\Query\CompiledQuery
$compiled
— Compiled Query -
mixed
$prefix
— Prefix -
mixed
$suffix
— Suffix
Return Value
string
Signature
protected function compileLimit(Aurora\Database\Query\Blueprint $blueprint, Aurora\Database\Query\CompiledQuery $compiled, mixed $prefix, mixed $suffix): string
compileUnion
Compile UNION statements
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query Blueprint -
Aurora\Database\Query\CompiledQuery
$compiled
— Compiled Query -
mixed
$prefix
— Prefix -
mixed
$suffix
— Suffix
Return Value
string
Signature
protected function compileUnion(Aurora\Database\Query\Blueprint $blueprint, Aurora\Database\Query\CompiledQuery $compiled, mixed $prefix, mixed $suffix): string
compileInsert
Compile INSERT statements
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query Blueprint -
Aurora\Database\Query\CompiledQuery
$compiled
— Compiled Query -
mixed
$prefix
— Prefix -
mixed
$suffix
— Suffix -
mixed
$upsert
Return Value
string
Signature
protected function compileInsert(Aurora\Database\Query\Blueprint $blueprint, Aurora\Database\Query\CompiledQuery $compiled, mixed $prefix, mixed $suffix, mixed $upsert): string
compileUpdate
Compile UPDATE statements
Parameters
-
Aurora\Database\Query\Blueprint
$blueprint
— Query Blueprint -
Aurora\Database\Query\CompiledQuery
$compiled
— Compiled Query -
mixed
$prefix
— Prefix -
mixed
$suffix
— Suffix
Return Value
string
Signature
protected function compileUpdate(Aurora\Database\Query\Blueprint $blueprint, Aurora\Database\Query\CompiledQuery $compiled, mixed $prefix, mixed $suffix): string