Skip to main content
Module

x/denodb/lib/query-builder.ts>QueryBuilder

MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
eveningkid/denodb
Go to Latest
class QueryBuilder
import { QueryBuilder } from "https://deno.land/x/denodb@v1.0.40/lib/query-builder.ts";

Create queries descriptions.

Methods

all()
avg(field: string)
count(field: string)
create(values: Values[])
createTable(
fields: ModelFields,
fieldsDefaults: ModelDefaults,
unnamed 2: { withTimestamps: boolean; ifNotExists: boolean; },
)
find(field: string, possibleValues: FieldValue[])
get()
groupBy(field: string)
join(
joinTable: string,
originField: string,
targetField: string,
)
leftJoin(
joinTable: string,
originField: string,
targetField: string,
)
leftOuterJoin(
joinTable: string,
originField: string,
targetField: string,
)
limit(limit: number)
max(field: string)
min(field: string)
offset(offset: number)
orderBy(field: string, orderDirection: OrderDirection)
queryForSchema(schema: ModelSchema): QueryBuilder

Create a fresh new query.

select(...fields: (string | FieldAlias)[])
sum(field: string)
table(table: string)
update(values: Values)
where(
field: string,
operator: Operator,
value: FieldValue,
)