default | /src/core/query-builder/DQL/SelectQuery.ts | justaos_orm@v10.1.0

class default

implements IQuery

import { default } from "https://deno.land/x/justaos_orm@v10.1.0/src/core/query-builder/DQL/SelectQuery.ts";

Constructors

new

default()

Methods

andWhere(

columnOrCompoundFunction:

| string

| number

| boolean

| ((where: WhereClause) => void)

operatorOrValue?: TWhereClauseOperator | any,

value?: any,

): SelectQuery

This method is used to set the AND where clause. (same as where)

buildCountQuery(): string

buildQuery(): string

columns(columnNameOrObjectOrArray?: string | string[] | { [key: string]: boolean; }, ...otherColumns: string[]): SelectQuery

This method is used to set the columns for the select query.

from(tableOrTablesArray: string | string[], ...otherTableNames: string[]): SelectQuery

This method is used to set the table or tables for the select query.

groupBy(columnNameOrObjectOrArray?: string | string[] | { [key: string]: boolean; }, ...otherColumns: string[]): SelectQuery

This method is used to set the group by clause for the select query.

limit(limit: number): SelectQuery

This method is used to set the limit for the select query.

offset(offset: number): SelectQuery

This method is used to set the offset for the select query.

orderBy(columnNameOrOrderList?: string | TOrderBy[], direction?: TOrderByDirection): SelectQuery

This method is used to set the order by clause for the select query.

orWhere(

columnOrCompoundFunction:

| string

| number

| boolean

| ((where: WhereClause) => void)

operatorOrValue?: TWhereClauseOperator | any,

value?: any,

): SelectQuery

This method is used to set the or where clause for the select query.

where(

columnOrCompoundFunction:

| string

| number

| boolean

| ((where: WhereClause) => void)

operatorOrValue?: TWhereClauseOperator | any,

value?: any,

): SelectQuery

This method is used to set the where clause for the select query.