Class SQLFilterBuilder

Hierarchy

SQLFilterBuilder

Index

Constructors

Properties

params placeholderStrategy quoteId quoteValue schema serializer tableName

Methods

bindValue condition conditions conditionsArray convert getDeepColumnAccessor isNull quoteIdWithTable regexpComparator requiresJson splitDeepFieldPath

Constructors

constructor

new SQLFilterBuilder(schema: ReflectionClass<any>, tableName: string, serializer: Serializer, placeholderStrategy: SqlPlaceholderStrategy, quoteValue: ((v: any) => string), quoteId: ((v: string) => string)): SQLFilterBuilder
Parameters
- schema: ReflectionClass<any>
- tableName: string
- serializer: Serializer
- placeholderStrategy: SqlPlaceholderStrategy
- quoteValue: ((v: any) => string)
  - - (v: any): string
    - Parameters
      
      v: any
      
      Returns string
- quoteId: ((v: string) => string)
  - - (v: string): string
    - Parameters
      
      v: string
      
      Returns string
Returns SQLFilterBuilder
- Defined in packages/sql/src/sql-filter-builder.ts:20

Properties

params

params: any[] = []

placeholderStrategy

placeholderStrategy: SqlPlaceholderStrategy

`Protected` quoteId

quoteId: ((v: string) => string)

Type declaration

- (v: string): string
- Parameters
  - v: string
  Returns string

`Protected` quoteValue

quoteValue: ((v: any) => string)

Type declaration

- (v: any): string
- Parameters
  - v: any
  Returns string

`Protected` schema

schema: ReflectionClass<any>

`Protected` serializer

serializer: Serializer

`Protected` tableName

tableName: string

Methods

`Protected` bindValue

bindValue(value: any): any
Normalizes values necessary for the conection driver to bind parameters for prepared statements. E.g. SQLite does not support boolean, so we convert boolean to number.
Parameters
- value: any
Returns any
- Defined in packages/sql/src/sql-filter-builder.ts:46

`Protected` condition

condition(fieldName: undefined | string, value: any, comparison: string): string
Parameters
- fieldName: undefined | string
- value: any
- comparison: string
Returns string
- Defined in packages/sql/src/sql-filter-builder.ts:72

`Protected` conditions

conditions(filter: Filter, fieldName?: string): string
Parameters
- filter: Filter
- Optional fieldName: string
Returns string
- Defined in packages/sql/src/sql-filter-builder.ts:151

`Protected` conditionsArray

conditionsArray(filters: Filter[], join: "AND" | "OR"): string
Parameters
- filters: Filter[]
- join: "AND" | "OR"
Returns string
- Defined in packages/sql/src/sql-filter-builder.ts:52

convert

convert(filter: Filter): string
Parameters
- filter: Filter
Returns string
- Defined in packages/sql/src/sql-filter-builder.ts:38

`Protected` getDeepColumnAccessor

getDeepColumnAccessor(table: string, column: string, path: string): string
Parameters
- table: string
- column: string
- path: string
Returns string
- Defined in packages/sql/src/sql-filter-builder.ts:141

isNull

isNull(): string
Returns string
- Defined in packages/sql/src/sql-filter-builder.ts:30

`Protected` quoteIdWithTable

quoteIdWithTable(id: string): string
Parameters
- id: string
Returns string
- Defined in packages/sql/src/sql-filter-builder.ts:63

regexpComparator

regexpComparator(): string
Returns string
- Defined in packages/sql/src/sql-filter-builder.ts:34

requiresJson

requiresJson(type: Type): boolean
Parameters
- type: Type
Returns boolean
- Defined in packages/sql/src/sql-filter-builder.ts:68

`Protected` splitDeepFieldPath

splitDeepFieldPath(path: string): [column: string, path: string]
Parameters
- path: string
Returns [column: string, path: string]
- Defined in packages/sql/src/sql-filter-builder.ts:145

Generated using TypeDoc