Where | /where.ts | sql_builder@v1.9.2

class Where

import { Where } from "https://deno.land/x/sql_builder@v1.9.2/where.ts";

Where sub sql builder

Constructors

new

Where(expr: string, params: any[])

private

expr: string

private

params: any[]

readonly

value: string

toString(): string

and(...expr: (null | undefined | Where)[]): Where

field: string,

startValue: any,

endValue: any,

)

eq(field: string, value: any)

expr(expr: string, ...params: any[]): Where

field(name: string)

from(data: any): Where

eq from object

gt(field: string, value: any)

gte(field: string, value: any)

in(field: string, ...values: any[])

isNotNull(field: string)

isNull(field: string)

like(field: string, value: any)

lt(field: string, value: any)

lte(field: string, value: any)

ne(field: string, value: any)

notIn(field: string, ...values: any[])

or(...expr: (null | undefined | Where)[]): Where