Class: Select

optimizeComparing~Select()

new Select()

A class representing a single sql select command
Source:

Members

alias

Properties:
Name Type Description
alias string | null
Source:

columns

string containing the list of all columns to read, usually comma separated
Properties:
Name Type Description
Select.columns String
Source:

filter

Properties:
Name Type Description
filter sqlFun | null
Source:

isOptimized

States if a Select is 'optimized', i.e. it is attached to a multicomparator. A select attached to a manual filter is considered not-optimized
Properties:
Name Type Description
isOptimized boolean
Source:

(protected) myTop

Properties:
Name Type Description
myTop string | null
Source:

omc

Properties:
Name Type Description
omc OptimizedMultiCompare | null
Source:

staticF

Properties:
Name Type Description
staticF sqlFun | null
Source:

tableName

Table to which this select is applied
Properties:
Name Type Description
tableName string | null
Source:

Methods

staticFilter(filter) → {Select}

Sets a static filter for this condition
Parameters:
Name Type Description
filter sqlFun
Source:
Returns:
this
Type
Select

optimizeComparing~Select(columnList)

new Select(columnList)

Creates a select providing an optional column list
Parameters:
Name Type Description
columnList string
Source:

Members

alias

Properties:
Name Type Description
alias string | null
Source:

columns

string containing the list of all columns to read, usually comma separated
Properties:
Name Type Description
Select.columns String
Source:

filter

Properties:
Name Type Description
filter sqlFun | null
Source:

isOptimized

States if a Select is 'optimized', i.e. it is attached to a multicomparator. A select attached to a manual filter is considered not-optimized
Properties:
Name Type Description
isOptimized boolean
Source:

(protected) myTop

Properties:
Name Type Description
myTop string | null
Source:

omc

Properties:
Name Type Description
omc OptimizedMultiCompare | null
Source:

staticF

Properties:
Name Type Description
staticF sqlFun | null
Source:

tableName

Table to which this select is applied
Properties:
Name Type Description
tableName string | null
Source:

Methods

staticFilter(filter) → {Select}

Sets a static filter for this condition
Parameters:
Name Type Description
filter sqlFun
Source:
Returns:
this
Type
Select