Class QueryBuilder

Index

Constructors

Methods

select where andWhere orWhere orderBy limit offset join leftJoin rightJoin fullJoin groupBy having insert update delete build

Constructors

constructor

new QueryBuilder(options): QueryBuilder
Parameters
- options: QueryBuilderOptions
Returns QueryBuilder
- Defined in core/query-builder.ts:50

Methods

select

select(columns): this
Add SELECT columns
Parameters
- columns: string[]
Returns this
- Defined in core/query-builder.ts:69

where

where(condition): this
Add WHERE conditions
Parameters
- condition: WhereCondition
Returns this
- Defined in core/query-builder.ts:77

andWhere

andWhere(condition): this
Add AND WHERE conditions
Parameters
- condition: WhereCondition
Returns this
- Defined in core/query-builder.ts:85

orWhere

orWhere(condition): this
Add OR WHERE conditions
Parameters
- condition: WhereCondition
Returns this
- Defined in core/query-builder.ts:97

orderBy

orderBy(orderBy): this
Add ORDER BY clause
Parameters
- orderBy: OrderByCondition
Returns this
- Defined in core/query-builder.ts:109

limit

limit(count): this
Add LIMIT clause
Parameters
- count: number
Returns this
- Defined in core/query-builder.ts:117

offset

offset(count): this
Add OFFSET clause
Parameters
- count: number
Returns this
- Defined in core/query-builder.ts:125

join

join(table, alias, on): this
Add JOIN clause
Parameters
- table: string
- alias: string
- on: string
Returns this
- Defined in core/query-builder.ts:133

leftJoin

leftJoin(table, alias, on): this
Add LEFT JOIN clause
Parameters
- table: string
- alias: string
- on: string
Returns this
- Defined in core/query-builder.ts:142

rightJoin

rightJoin(table, alias, on): this
Add RIGHT JOIN clause
Parameters
- table: string
- alias: string
- on: string
Returns this
- Defined in core/query-builder.ts:151

fullJoin

fullJoin(table, alias, on): this
Add FULL JOIN clause
Parameters
- table: string
- alias: string
- on: string
Returns this
- Defined in core/query-builder.ts:160

groupBy

groupBy(columns): this
Add GROUP BY clause
Parameters
- columns: string[]
Returns this
- Defined in core/query-builder.ts:169

having

having(condition): this
Add HAVING clause
Parameters
- condition: WhereCondition
Returns this
- Defined in core/query-builder.ts:177

insert

insert(values): this
Convert to INSERT query
Parameters
- values: Record<string, any>
Returns this
- Defined in core/query-builder.ts:185

update

update(set): this
Convert to UPDATE query
Parameters
- set: Record<string, any>
Returns this
- Defined in core/query-builder.ts:194

delete

delete(): this
Convert to DELETE query

Returns this
- Defined in core/query-builder.ts:203

build

build(): {
sql: string;
parameters: any[];
}
Build the final SQL query

Returns {
sql: string;
parameters: any[];
}
- sql: string
- parameters: any[]
- Defined in core/query-builder.ts:211