Class SqlBuilder

Hierarchy

SqlBuilder

Index

Constructors

Properties

joins params placeholderStrategy platform rootConverter? sqlSelect

Methods

appendHavingSQL appendJoinSQL appendWhereSQL build buildConverter convertRows select selectColumns selectColumnsWithJoins update

Constructors

constructor

new SqlBuilder(platform: DefaultPlatform, params?: string[]): SqlBuilder
Parameters
- platform: DefaultPlatform
- params: string[] = []
Returns SqlBuilder
- Defined in packages/sql/src/sql-builder.ts:46

Properties

`Protected` joins

joins: {
    converter: ConvertDataToDict;
    forJoinIndex: number;
    join: DatabaseJoinModel<any, any>;
    startIndex: number;
}[] = []

params

params: string[] = []

`Protected` placeholderStrategy

placeholderStrategy: SqlPlaceholderStrategy

`Protected` platform

platform: DefaultPlatform

`Optional` rootConverter

rootConverter?: ConvertDataToDict

`Protected` sqlSelect

sqlSelect: string[] = []

Methods

`Protected` appendHavingSQL

appendHavingSQL(sql: Sql, schema: ReflectionClass<any>, model: DatabaseQueryModel<any, FilterQuery<any>, Sort<any, any>>, tableName: string): void
Parameters
- sql: Sql
- schema: ReflectionClass<any>
- model: DatabaseQueryModel<any, FilterQuery<any>, Sort<any, any>>
- tableName: string
Returns void
- Defined in packages/sql/src/sql-builder.ts:83

`Protected` appendJoinSQL

appendJoinSQL<T>(sql: Sql, model: SQLQueryModel<T>, parentName: string, prefix?: string): void
Type Parameters
- T extends OrmEntity
Parameters
- sql: Sql
- model: SQLQueryModel<T>
- parentName: string
- prefix: string = ''
Returns void
- Defined in packages/sql/src/sql-builder.ts:259

`Protected` appendWhereSQL

appendWhereSQL(sql: Sql, schema: ReflectionClass<any>, model: SQLQueryModel<any>, tableName?: string, prefix?: string): void
Parameters
- sql: Sql
- schema: ReflectionClass<any>
- model: SQLQueryModel<any>
- Optional tableName: string
- prefix: string = 'WHERE'
Returns void
- Defined in packages/sql/src/sql-builder.ts:51

build

build<T>(schema: ReflectionClass<any>, model: SQLQueryModel<T>, head: string): Sql
Type Parameters
- T extends OrmEntity
Parameters
- schema: ReflectionClass<any>
- model: SQLQueryModel<T>
- head: string
Returns Sql
- Defined in packages/sql/src/sql-builder.ts:324

`Protected` buildConverter

buildConverter(schema: ReflectionClass<any>, model: SQLQueryModel<any>, startIndex: number, fields: ReflectionProperty[]): ConvertDataToDict
Parameters
- schema: ReflectionClass<any>
- model: SQLQueryModel<any>
- startIndex: number
- fields: ReflectionProperty[]
Returns ConvertDataToDict
- Defined in packages/sql/src/sql-builder.ts:227

convertRows

convertRows(schema: ReflectionClass<any>, model: SQLQueryModel<any>, rows: any[]): any[]
Parameters
- schema: ReflectionClass<any>
- model: SQLQueryModel<any>
- rows: any[]
Returns any[]
- Defined in packages/sql/src/sql-builder.ts:170

select

select(schema: ReflectionClass<any>, model: SQLQueryModel<any>, options?: {
select?: string[];
}): Sql
Parameters
- schema: ReflectionClass<any>
- model: SQLQueryModel<any>
- options: {
  select?: string[];
  } = {}
  - Optional select?: string[]
Returns Sql
- Defined in packages/sql/src/sql-builder.ts:384

`Protected` selectColumns

selectColumns(schema: ReflectionClass<any>, model: SQLQueryModel<any>): void
Parameters
- schema: ReflectionClass<any>
- model: SQLQueryModel<any>
Returns void
- Defined in packages/sql/src/sql-builder.ts:98

`Protected` selectColumnsWithJoins

selectColumnsWithJoins(schema: ReflectionClass<any>, model: SQLQueryModel<any>, refName?: string): {
fields: ReflectionProperty[];
startIndex: number;
}
Parameters
- schema: ReflectionClass<any>
- model: SQLQueryModel<any>
- refName: string = ''
Returns {
fields: ReflectionProperty[];
startIndex: number;
}
- fields: ReflectionProperty[]
- startIndex: number
- Defined in packages/sql/src/sql-builder.ts:127

update

update<T>(schema: ReflectionClass<any>, model: SQLQueryModel<T>, set: string[]): Sql
Type Parameters
- T extends OrmEntity
Parameters
- schema: ReflectionClass<any>
- model: SQLQueryModel<T>
- set: string[]
Returns Sql
- Defined in packages/sql/src/sql-builder.ts:376

Generated using TypeDoc