Constants

DELIMITED_IDENTIFIERS

DELIMITED_IDENTIFIERS = '`'

分隔标识符,解决保留字问题

Properties

$query

$query : \Imi\Db\Query\Interfaces\IQuery

IQuery 类

Type

\Imi\Db\Query\Interfaces\IQuery

$params

$params : array

绑定参数

Type

array

Methods

buildSql()

buildSql(\Imi\Db\Query\Interfaces\IQuery  $query, mixed  $args) : string

生成SQL语句

Parameters

\Imi\Db\Query\Interfaces\IQuery $query
mixed $args

Returns

string

__construct()

__construct(\Imi\Db\Query\Interfaces\IQuery  $query) 

Parameters

\Imi\Db\Query\Interfaces\IQuery $query

build()

build(mixed  $args) : string

生成SQL语句

Parameters

mixed $args

Returns

string

parseKeywordText()

parseKeywordText(string  $string) : array

把输入的关键字文本转为数组

Parameters

string $string

Returns

array

parseKeywordToText()

parseKeywordToText(array  $keywords, string|null  $alias = null,   $jsonKeywords = null) : void

从数组拼装为有分隔标识符的关键字

Parameters

array $keywords
string|null $alias
$jsonKeywords

parseKeyword()

parseKeyword(string  $string) : string

处理关键字输入,转为安全的分隔标识符的关键字

Parameters

string $string

Returns

string

parseDistinct()

parseDistinct(boolean  $distinct) : string

distinct

Parameters

boolean $distinct

Returns

string

parseField()

parseField(array  $fields) : string

fields

Parameters

array $fields

Returns

string

parseJoin()

parseJoin(array<mixed,\Imi\Db\Query\Interfaces\IJoin>  $join) : string

join

Parameters

array<mixed,\Imi\Db\Query\Interfaces\IJoin> $join

Returns

string

parseWhere()

parseWhere(array<mixed,\Imi\Db\Query\Interfaces\IBaseWhere>  $where) : string

where

Parameters

array<mixed,\Imi\Db\Query\Interfaces\IBaseWhere> $where

Returns

string

parseLimit()

parseLimit(integer  $offset, integer  $limit) : string

limit

Parameters

integer $offset
integer $limit

Returns

string

parseOrder()

parseOrder(array<mixed,\Imi\Db\Query\Interfaces\IOrder>  $order) : string

order by

Parameters

array<mixed,\Imi\Db\Query\Interfaces\IOrder> $order

Returns

string

parseGroup()

parseGroup(array<mixed,\Imi\Db\Query\Interfaces\IGroup>  $group) : string

group by

Parameters

array<mixed,\Imi\Db\Query\Interfaces\IGroup> $group

Returns

string

parseHaving()

parseHaving(array<mixed,\Imi\Db\Query\Interfaces\IHaving>  $having) : string

having

Parameters

array<mixed,\Imi\Db\Query\Interfaces\IHaving> $having

Returns

string