Skip to main content
Module

x/cotton/mod.ts>Q

SQL Database Toolkit for Deno
rahmanfadhil/cotton
Latest
class Q
import { Q } from "https://deno.land/x/cotton@v0.7.5/mod.ts";

Query expression builder

Constructors

new
Q(operator: QueryOperator, value: DatabaseValues | DatabaseValues[])

Static Methods

between(value1: DatabaseValues, value2: DatabaseValues): Q

The value (number) is between these numbers

eq(value: DatabaseValues): Q

Is equal to (=)

gt(value: DatabaseValues): Q

Greater than (>)

gte(value: DatabaseValues): Q

Greater than equal (>=)

ilike(value: string): Q

ILIKE (case-insensitive) operator

in(values: DatabaseValues[]): Q

The value is one of the given values

like(value: string): Q

LIKE operator

lt(value: DatabaseValues): Q

Lower than (<)

lte(value: DatabaseValues): Q

Lower than equal (<=)

neq(value: DatabaseValues): Q

Is not equal to (!=)

notBetween(value1: DatabaseValues, value2: DatabaseValues): Q

The value (number) is between these numbers

notIlike(value: string): Q

NOT ILIKE (case-insensitive) operator

notIn(values: DatabaseValues[]): Q

The value is not one of the given values

notLike(value: string): Q

NOT LIKE operator

notNull(): Q

The value is not null

null(): Q

The value is null