import { QueryBuilder } from "https://deno.land/x/denodb_esgi@1.0.15.1/lib/query-builder.ts";
Create queries descriptions.
Properties
_query: QueryDescription
Methods
all()
avg(field: string)
count(field: string)
createTable()
fields: ModelFields,
fieldsDefaults: ModelDefaults,
unnamed 2: { withTimestamps: boolean; ifNotExists: boolean; },
delete()
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.
schema(schema: ModelSchema)
select(...fields: (string | FieldAlias)[])
sum(field: string)
table(table: string)
where()