Property | Type | Description | |
---|---|---|---|
$connection | connection对象实例 | ||
$deleteSql | |||
$exp | 数据库表达式 | ||
$insertAllSql | |||
$insertSql | |||
$query | 查询对象实例 | ||
$selectSql | SQL表达式 | ||
$updateSql |
Method | Description | |
---|---|---|
__construct ( |
架构函数 | |
buildWhere ( mixed $where, array $options ) : string | 生成查询条件SQL | |
delete ( array $options ) : string | 生成delete SQL | |
insert ( array $data, array $options = [], boolean $replace = false ) : string | 生成insert SQL | |
insertAll ( array $dataSet, array $options ) : string | 生成insertall SQL | |
select ( array $options = [] ) : string | 生成查询SQL | |
selectInsert ( array $fields, string $table, array $options ) : string | 生成slectinsert SQL | |
setQuery ( |
设置当前的Query对象实例 | |
update ( $data, array $options ) : string | 生成update SQL |
Method | Description | |
---|---|---|
parseClosure ( $call, $show = true ) | 执行闭包子查询 | |
parseComment ( string $comment ) : string | comment分析 | |
parseData ( array $data, array $options ) : array | 数据分析 | |
parseDateTime ( string $value, string $key, array $options = [], string $bindName = null, integer $bindType = null ) : string | 日期时间条件解析 | |
parseDistinct ( mixed $distinct ) : string | distinct分析 | |
parseField ( mixed $fields, array $options = [] ) : string | field分析 | |
parseForce ( mixed $index ) : string | index分析,可在操作链中指定需要强制使用的索引 | |
parseGroup ( mixed $group ) : string | group分析 | |
parseHaving ( string $having ) : string | having分析 | |
parseJoin ( array $join, array $options = [] ) : string | join分析 | |
parseKey ( string $key, array $options = [] ) : string | 字段名分析 | |
parseLimit ( $limit ) : string | limit分析 | |
parseLock ( $lock = false ) : string | 设置锁机制 | |
parseOrder ( mixed $order, array $options = [] ) : string | order分析 | |
parseSqlTable ( string $sql ) : string | 将SQL语句中的__TABLE_NAME__字符串替换成带前缀的表名(小写) | |
parseTable ( mixed $tables, array $options = [] ) : string | table分析 | |
parseUnion ( mixed $union ) : string | union分析 | |
parseValue ( mixed $value, string $field = '' ) : string | array | value分析 | |
parseWhere ( mixed $where, array $options ) : string | where分析 | |
parseWhereItem ( $field, $val, $rule = '', $options = [], $binds = [], $bindName = null ) | where子单元分析 |
public __construct ( |
||
$connection | 数据库连接对象实例 |
protected parseComment ( string $comment ) : string | ||
$comment | string | |
return | string |
protected parseDistinct ( mixed $distinct ) : string | ||
$distinct | mixed | |
return | string |
protected parseForce ( mixed $index ) : string | ||
$index | mixed | |
return | string |
protected parseGroup ( mixed $group ) : string | ||
$group | mixed | |
return | string |
protected parseHaving ( string $having ) : string | ||
$having | string | |
return | string |
protected parseSqlTable ( string $sql ) : string | ||
$sql | string | sql语句 |
return | string |
protected parseUnion ( mixed $union ) : string | ||
$union | mixed | |
return | string |
protected parseWhereItem ( $field, $val, $rule = '', $options = [], $binds = [], $bindName = null ) |