Back to Pocketbase

Interface SqliteQueryBuilder

static/jsvm/interfaces/dbx.SqliteQueryBuilder.html

latest4.3 KB
Original Source

Interface SqliteQueryBuilder

SqliteQueryBuilder is the query builder for SQLite databases.

Hierarchy

Index

Methods

buildFrombuildGroupBybuildHavingbuildJoinbuildLimitbuildOrderBybuildOrderByAndLimitbuildSelectbuildUnionbuildWherecombineUniondb

Methods

buildFrom

  • buildFrom(tables): string

BuildFrom generates a FROM clause from the given tables.

Parameters

tables: string[]

Returns string

buildGroupBy

  • buildGroupBy(cols): string

BuildGroupBy generates a GROUP BY clause from the given group-by columns.

Parameters

cols: string[]

Returns string

buildHaving

  • buildHaving(e, params): string

BuildHaving generates a HAVING clause from the given expression.

Parameters

e: Expression
params: Params

Returns string

buildJoin

  • buildJoin(joins, params): string

BuildJoin generates a JOIN clause from the given join information.

Parameters

joins: JoinInfo[]
params: Params

Returns string

buildLimit

  • buildLimit(limit, offset): string

BuildLimit generates the LIMIT clause.

Parameters

limit: number
offset: number

Returns string

buildOrderBy

  • buildOrderBy(cols): string

BuildOrderBy generates the ORDER BY clause.

Parameters

cols: string[]

Returns string

buildOrderByAndLimit

  • buildOrderByAndLimit(sql, cols, limit, offset): string

BuildOrderByAndLimit generates the ORDER BY and LIMIT clauses.

Parameters

sql: string
cols: string[]
limit: number
offset: number

Returns string

buildSelect

  • buildSelect(cols, distinct, option): string

BuildSelect generates a SELECT clause from the given selected column names.

Parameters

cols: string[]
distinct: boolean
option: string

Returns string

buildUnion

  • buildUnion(unions, params): string

BuildUnion generates a UNION clause from the given union information.

This is similar to BaseQueryBuilder.BuildUnion but without the parenthesis wrapping.

Parameters

unions: UnionInfo[]
params: Params

Returns string

buildWhere

  • buildWhere(e, params): string

BuildWhere generates a WHERE clause from the given expression.

Parameters

e: Expression
params: Params

Returns string

combineUnion

  • combineUnion(sql, unionClause): string

CombineUnion combines the nonempty unionClause with the provided sql string.

This is similar to BaseQueryBuilder.CombineUnion but without the parenthesis wrapping.

Parameters

sql: string
unionClause: string

Returns string

db

DB returns the DB instance associated with the query builder.

Returns dbx.DB

Settings

Member Visibility

  • Inherited

Theme

OSLightDark

On This Page

Generated using TypeDoc