Class CreateViewBuilder

Implements

Index

Constructors

Methods

$call as columns compile execute ifNotExists materialized orReplace temporary toOperationNode

Constructors

constructor

new CreateViewBuilder(props: CreateViewBuilderProps): CreateViewBuilder
Parameters
- props: CreateViewBuilderProps
Returns CreateViewBuilder
- Defined in schema/create-view-builder.ts:17

Methods

$call

$call<T>(func: (qb: this) => T): T
Simply calls the provided function passing this as the only argument. $call returns what the provided function returns.
Type Parameters
- T
Parameters
- func: (qb: this) => T
Returns T
- Defined in schema/create-view-builder.ts:102

as

as(
query: SelectQueryBuilder<any, any, any> | RawBuilder<any>,
): CreateViewBuilder
Sets the select query or a values statement that creates the view.

WARNING! Some dialects don't support parameterized queries in DDL statements and therefore the query or raw sql expression passed here is interpolated into a single string opening an SQL injection vulnerability. DO NOT pass unchecked user input into the query or raw expression passed to this method!
Parameters
- query: SelectQueryBuilder<any, any, any> | RawBuilder<any>
Returns CreateViewBuilder
- Defined in schema/create-view-builder.ts:83

columns

columns(columns: string[]): CreateViewBuilder
Parameters
- columns: string[]
Returns CreateViewBuilder
- Defined in schema/create-view-builder.ts:65

compile

compile(): CompiledQuery
Returns CompiledQuery
Implementation of Compilable.compile
- Defined in schema/create-view-builder.ts:113

execute

execute(options?: AbortableQueryOptions): Promise<void>
Parameters
- Optionaloptions: AbortableQueryOptions
Returns Promise<void>
- Defined in schema/create-view-builder.ts:120

ifNotExists

ifNotExists(): CreateViewBuilder
Only implemented on some dialects like SQLite. On most dialects, use orReplace.

Returns CreateViewBuilder
- Defined in schema/create-view-builder.ts:47

materialized

materialized(): CreateViewBuilder
Returns CreateViewBuilder
- Defined in schema/create-view-builder.ts:35

orReplace

orReplace(): CreateViewBuilder
Returns CreateViewBuilder
- Defined in schema/create-view-builder.ts:56

temporary

temporary(): CreateViewBuilder
Adds the "temporary" modifier.

Use this to create a temporary view.

Returns CreateViewBuilder
- Defined in schema/create-view-builder.ts:26

toOperationNode

toOperationNode(): CreateViewNode
Returns CreateViewNode
Implementation of OperationNodeSource.toOperationNode
- Defined in schema/create-view-builder.ts:106