QueryBuilder

Methods

setReservedWords

public setReservedWords(array $words): void

Parameters

Parameter	Type	Description
$words	array

create

public create(string $name, string $type, bool $ifNotExists): string

Parameters

Parameter	Type	Description
$name	string
$type	string
$ifNotExists	bool

insert

public insert(mixed $fields): self

Parameters

Parameter	Type	Description
$fields	mixed

update

public update(array $fields): self

Parameters

Parameter	Type	Description
$fields	array

delete

public delete(): self

truncate

public truncate(bool $cascade): self

Parameters

Parameter	Type	Description
$cascade	bool

count

public count(): string

exists

public exists(string $table, mixed $criteria): string

Parameters

Parameter	Type	Description
$table	string
$criteria	mixed

select

public select(mixed $columns): self

Parameters

Parameter	Type	Description
$columns	mixed

distinct

public distinct(string $columns): self

Parameters

Parameter	Type	Description
$columns	string

table

public table(string $table, ?string $alias): self

Parameters

Parameter	Type	Description
$table	string
$alias	string

from

public from(string $table, ?string $alias): self

Parameters

Parameter	Type	Description
$table	string
$alias	string

where

public where(string $criteria): self

Parameters

Parameter	Type	Description
$criteria	string

group

public group(string $column): self

Parameters

Parameter	Type	Description
$column	string

having

public having(string $columns): self

Parameters

Parameter	Type	Description
$columns	string

window

public window(string $name, string $partitionBy, string $orderBy): self

Parameters

Parameter	Type	Description
$name	string
$partitionBy	string
$orderBy	string

join

Join a table to the current query using the provided join criteria.

public join(string $references, string $on, ?string $alias, string $type = 'INNER'): self

Parameters

Parameter	Type	Description
$references	string
$on	string
$alias	string
$type	string

order

public order(string $columns, int $sortDirection = 'SORT_ASC'): self

Parameters

Parameter	Type	Description
$columns	string
$sortDirection	int

limit

public limit(int $limit): self

Parameters

Parameter	Type	Description
$limit	int

offset

public offset(int $offset): self

Parameters

Parameter	Type	Description
$offset	int

toString

public toString(): string

getSchemaName

public getSchemaName(): ?string

parseSchemaName

public parseSchemaName(string $tableName): void

Parameters

Parameter	Type	Description
$tableName	string

schemaName

public schemaName(string $tableName): string

Parameters

Parameter	Type	Description
$tableName	string

quoteSpecial

public quoteSpecial(mixed $value): mixed

Parameters

Parameter	Type	Description
$value	mixed

field

public field(string $string): string

Parameters

Parameter	Type	Description
$string	string

prepareFields

public prepareFields(mixed $fields, array $exclude, array $tables): string

Parameters

Parameter	Type	Description
$fields	mixed
$exclude	array
$tables	array

prepareValue

public prepareValue(string $key, mixed $value): mixed

Parameters

Parameter	Type	Description
$key	string
$value	mixed

prepareArrayAliases

public prepareArrayAliases(array $array): void

Parameters

Parameter	Type	Description
$array	array

prepareCriteria

public prepareCriteria(string $criteria, string $bindType = 'AND', string $tissue = '=', ?string $parentRef, bool $setKey = true): string

Parameters

Parameter	Type	Description
$criteria	string
$bindType	string
$tissue	string
$parentRef	string
$setKey	bool

reset

public reset(): self

getCriteriaValues

public getCriteriaValues(): void

returning

public returning(mixed $columns): self

Parameters

Parameter	Type	Description
$columns	mixed

onConflict

public onConflict(string $target, bool $update): self

Parameters

Parameter	Type	Description
$target	string
$update	bool

---

Generated by Hazaar API Doc Generator