NodeQuery

Class for connection management

new NodeQuery(config: object)
Parameters
config (object) connection parameters
Instance Members
getQuery()

QueryBuilder

Main object that builds SQL queries.

new QueryBuilder(Driver: Driver, Adapter: Adapter)

Extends QueryBuilderBase

Parameters
Driver (Driver) The syntax driver for the database
Adapter (Adapter) The database module adapter for running queries
Instance Members
queryFile(file, separator)
query(sql, params?)
resetQuery()
truncate(table)
end()
select(fields)
from(tableName)
like(field, val, pos)
notLike(field, val, pos)
orLike(field, val, pos)
orNotLike(field, val, pos)
having(key, val = null)
orHaving(key, val = null)
where(key, val?)
orWhere(key, val?)
whereIsNull(field)
whereIsNotNull(field)
orWhereIsNull(field)
orWhereIsNotNull(field)
whereIn(key, values)
orWhereIn(key, values)
whereNotIn(key, values)
orWhereNotIn(key, values)
set(key, val?)
join(table, cond, type)
groupBy(field)
orderBy(field, type)
limit(limit, offset?)
groupStart()
orGroupStart()
orNotGroupStart()
groupEnd()
get(table?, limit?, offset?)
insert(table, data?)
insertBatch(table, data)
update(table, data?)
updateBatch(table, data, updateKey)
delete(table, where?)
getCompiledSelect(table?, reset)
getCompiledInsert(table, reset)
getCompiledUpdate(table, reset)
getCompiledDelete(table, reset)

Result

Query result object

new Result(rows: Array, columns: Array)
Parameters
rows (Array = []) the data rows of the result
columns (Array = []) the column names in the result
Instance Members
rowCount()
columnCount()