QueryBuilder

class QueryBuilder {}

Constructors

this
this(DBType dbType)
Undocumented in source.

Members

Functions

crossJoin
QueryBuilder crossJoin(string table, string tableAlias)
Undocumented in source. Be warned that the author may not have intended to support it.
crossJoin
QueryBuilder crossJoin(string table)
Undocumented in source. Be warned that the author may not have intended to support it.
del
QueryBuilder del(string table, string _alias)
Undocumented in source. Be warned that the author may not have intended to support it.
descTable
QueryBuilder descTable(string tableName)
Undocumented in source. Be warned that the author may not have intended to support it.
escapeLiteral
string escapeLiteral(string str)
Undocumented in source. Be warned that the author may not have intended to support it.
escapeWithQuotes
string escapeWithQuotes(string str)
Undocumented in source. Be warned that the author may not have intended to support it.
formatOption
FormatOption formatOption()
Undocumented in source. Be warned that the author may not have intended to support it.
formatOption
void formatOption(FormatOption value)
Undocumented in source. Be warned that the author may not have intended to support it.
from
QueryBuilder from(string table, string _alias)
Undocumented in source. Be warned that the author may not have intended to support it.
fullJoin
QueryBuilder fullJoin(string table, string tableAlias, string joinWhere)
Undocumented in source. Be warned that the author may not have intended to support it.
fullJoin
QueryBuilder fullJoin(string table, string joinWhere)
Undocumented in source. Be warned that the author may not have intended to support it.
getAutoIncrease
string getAutoIncrease()
Undocumented in source. Be warned that the author may not have intended to support it.
getDistinct
bool getDistinct()
Undocumented in source. Be warned that the author may not have intended to support it.
groupBy
QueryBuilder groupBy(string expression)
Undocumented in source. Be warned that the author may not have intended to support it.
having
QueryBuilder having(string expression)
Undocumented in source. Be warned that the author may not have intended to support it.
innerJoin
QueryBuilder innerJoin(string table, string tablealias, string joinWhere)
Undocumented in source. Be warned that the author may not have intended to support it.
innerJoin
QueryBuilder innerJoin(string table, string joinWhere)
Undocumented in source. Be warned that the author may not have intended to support it.
insert
QueryBuilder insert(string table)
Undocumented in source. Be warned that the author may not have intended to support it.
join
QueryBuilder join(JoinMethod joinMethod, string table, string tablealias, string joinWhere)
Undocumented in source. Be warned that the author may not have intended to support it.
join
QueryBuilder join(JoinMethod joinMethod, string table, string joinWhere)
Undocumented in source. Be warned that the author may not have intended to support it.
leftJoin
QueryBuilder leftJoin(string table, string tableAlias, string joinWhere)
Undocumented in source. Be warned that the author may not have intended to support it.
leftJoin
QueryBuilder leftJoin(string table, string joinWhere)
Undocumented in source. Be warned that the author may not have intended to support it.
limit
QueryBuilder limit(int limit)
Undocumented in source. Be warned that the author may not have intended to support it.
offset
QueryBuilder offset(int offset)
Undocumented in source. Be warned that the author may not have intended to support it.
orderBy
QueryBuilder orderBy(string column)
Undocumented in source. Be warned that the author may not have intended to support it.
orderBy
QueryBuilder orderBy(string[] columns)
Undocumented in source. Be warned that the author may not have intended to support it.
parameterized
string parameterized(string sql, Variant[string] params)
Undocumented in source. Be warned that the author may not have intended to support it.
rightJoin
QueryBuilder rightJoin(string table, string tableAlias, string joinWhere)
Undocumented in source. Be warned that the author may not have intended to support it.
rightJoin
QueryBuilder rightJoin(string table, string joinWhere)
Undocumented in source. Be warned that the author may not have intended to support it.
select
QueryBuilder select(string[] column)
Undocumented in source. Be warned that the author may not have intended to support it.
set
QueryBuilder set(string fieldName, string columnName, string tableName, R param)
Undocumented in source. Be warned that the author may not have intended to support it.
setAutoIncrease
QueryBuilder setAutoIncrease(string key)
Undocumented in source. Be warned that the author may not have intended to support it.
setDistinct
QueryBuilder setDistinct(bool b)
Undocumented in source. Be warned that the author may not have intended to support it.
setParameter
QueryBuilder setParameter(string key, R param)
Undocumented in source. Be warned that the author may not have intended to support it.
showTables
QueryBuilder showTables()
Undocumented in source. Be warned that the author may not have intended to support it.
toString
string toString()
Undocumented in source. Be warned that the author may not have intended to support it.
update
QueryBuilder update(string table, string _alias)
Undocumented in source. Be warned that the author may not have intended to support it.
values
QueryBuilder values(Variant[string] arr)
Undocumented in source. Be warned that the author may not have intended to support it.
where
QueryBuilder where(Comparison!T comExpr)
Undocumented in source. Be warned that the author may not have intended to support it.
where
QueryBuilder where(string expression)
Undocumented in source. Be warned that the author may not have intended to support it.
whereAnd
QueryBuilder whereAnd(Comparison!T comExpr)
Undocumented in source. Be warned that the author may not have intended to support it.
whereAnd
QueryBuilder whereAnd(string expression)
Undocumented in source. Be warned that the author may not have intended to support it.
whereOr
QueryBuilder whereOr(Comparison!T comExpr)
Undocumented in source. Be warned that the author may not have intended to support it.
whereOr
QueryBuilder whereOr(string expression)
Undocumented in source. Be warned that the author may not have intended to support it.

Meta