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

Go to top