new QueryJoin(tables)
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
tables |
Map.<String, String> |
Methods
getKeyRangeString(tableName, condition) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
tableName |
String | |
condition |
String |
Returns:
- Type
- String
join(ast) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
ast |
Object |
Returns:
- Type
- String
joinCondition(leftTable, selectFields, joinAst, ast) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
leftTable |
String | |
selectFields |
Object | |
joinAst |
Object | |
ast |
Object |
Returns:
- Type
- String
leftSelectFields(ast, leftTable) → {String}
- Description:
Assembled selected fields string for LEFT.
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
ast |
Object | |
leftTable |
String |
Returns:
- Type
- String
rightSelectFields(ast, rightTable) → {String}
- Description:
assemble SELECTED FIELDS string for RIGHT.
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
ast |
Object | |
rightTable |
String |
Returns:
- Type
- String
selectNotInJoin(ast, joinAst, leftTable, rightTable) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
ast |
Object | |
joinAst |
Object | |
leftTable |
String | |
rightTable |
String |
Returns:
- Type
- String
(static) createSelectFieldsString(sortedFields) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
sortedFields |
Array.<JoinSelectField> |
Returns:
- Type
- String
(static) createSelectLabelString(sortedFields) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
sortedFields |
Array.<JoinSelectField> |
Returns:
- Type
- String
(static) getJoinField(joinAst, rightSide, leftSide) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
joinAst |
Object | |
rightSide |
String | |
leftSide |
String |
Returns:
- Type
- String
(static) ifNaResult(ast) → {String}
- Description:
Build a string that will be used in IFNA() when select does not find any records.
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
ast |
Object |
Returns:
- Type
- String
(static) replaceColumn(rowColumn, newColumn) → {String}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
rowColumn |
String | |
newColumn |
String |
Returns:
- Type
- String
(static) sortSelectJoinFields(ast, leftTable) → {Array.<JoinSelectField>}
- Source:
Parameters:
| Name | Type | Description |
|---|---|---|
ast |
Object | |
leftTable |
String |
Returns:
- Type
- Array.<JoinSelectField>