JoinTablesRecordIds

Find record ID's for matching JOINed table records.

Constructor

new JoinTablesRecordIds(joinTables)

Source:

JoinTables.js, line 301

Parameters:

Name	Type	Description
`joinTables`	JoinTables

Members

bindVariables

Source:

JoinTables.js, line 317

Properties:

Type	Description
BindData

dataJoin

Source:

JoinTables.js, line 307

Properties:

Type	Description
JoinTables

joinFields

Source:

JoinTables.js, line 311

Properties:

Type	Description
LeftRightJoinFields

joinType

Source:

JoinTables.js, line 327

Properties:

Type	Description
String

leftTableName

Source:

JoinTables.js, line 325

Properties:

Type	Description
String

masterTable

Source:

JoinTables.js, line 321

Properties:

Type	Description
Table

masterTable :Table

Source:

JoinTables.js, line 337

Type:

Table

primaryTableInfo

Source:

JoinTables.js, line 319

Properties:

Type	Description
Table

rightTableName

Source:

JoinTables.js, line 323

Properties:

Type	Description
String

tableFields

Source:

JoinTables.js, line 309

Properties:

Type	Description
TableFields

tableFields

Source:

JoinTables.js, line 313

Properties:

Type	Description
TableFields

tableInfo

Source:

JoinTables.js, line 315

Properties:

Type	Description
Map.<String, Table>

Methods

createKeyFieldRecordMap(rightField) → {Map.<String, Array.<Number>>}

Description:

Find all KEYS in table mapped to an array of record ID's where key is located in table.

Source:

JoinTables.js, line 658

Parameters:

Name	Type	Description
`rightField`	JoinSideInfo

Returns:

Type: Map.<String, Array.<Number>>

getJoinColumnData(fieldInfo, recordNumber) → {String}

Description:

Find (or calculate) the field data for the specified record number.

Source:

JoinTables.js, line 635

Parameters:

Name	Type	Description
`fieldInfo`	JoinSideInfo
`recordNumber`	Number

Returns:

Type: String

getJoinFieldsInfo() → {LeftRightJoinFields}

Source:

JoinTables.js, line 419

Returns:

Type: LeftRightJoinFields

getLeftRightFieldInfo(astJoin) → {LeftRightJoinFields}

Description:

Find the LEFT table and RIGHT table joining fields from AST.

Source:

JoinTables.js, line 441

Parameters:

Name	Type	Description
`astJoin`	Object

Returns:

Type: LeftRightJoinFields

getMatchedRecordIds() → {MatchingJoinRecordIDs}

Description:

Apply JOIN TYPE logic on left and right tables to find the matching record ID's from both left and right tables.

Source:

JoinTables.js, line 559

Returns:

Type: MatchingJoinRecordIDs

getRecordIDs(conditionAst) → {MatchingJoinRecordIDs}

Source:

JoinTables.js, line 335

Parameters:

Name	Type	Description
`conditionAst`	Object

Returns:

Type: MatchingJoinRecordIDs

getReferencedTableInfo(calcField) → {TableField}

Description:

Find the referenced table within the calculated field.

Source:

JoinTables.js, line 496

Parameters:

Name	Type	Description
`calcField`	String

Returns:

Type: TableField

getTableInfoFromCalculatedField(calcField) → {TableField}

Description:

Look for referenced columns in expression to determine table.

Source:

JoinTables.js, line 480

Parameters:

Name	Type	Description
`calcField`	String	Expression to parse.

Returns:

All SQL function parameters found. It will include COLUMN names and constant data.

Type: TableField

leftRightJoin(leftField, rightField, type) → {Array.<Array.<Number>>}

Description:

Returns array of each matching record ID from right table for every record in left table. If the right table entry could NOT be found, -1 is set for that record index.

Source:

JoinTables.js, line 593

Parameters:

Name	Type	Description
`leftField`	JoinSideInfo	left table field
`rightField`	JoinSideInfo	right table field
`type`	String	either 'inner' or 'outer'.

Returns:

first index is record ID of left table, second index is a list of the matching record ID's in right table.

Type: Array.<Array.<Number>>

searchColumnsForTable(calcField, columns) → {Object}

Source:

JoinTables.js, line 533

Parameters:

Name	Type	Description
`calcField`	String
`columns`	Array.<String>

Returns:

Type: Object

setBindVariables(bindVariables) → {JoinTablesRecordIds}

Source:

JoinTables.js, line 370

Parameters:

Name	Type	Description
`bindVariables`	BindData	Bind variable data.

Returns:

Type: JoinTablesRecordIds

setJoinType(joinType) → {JoinTablesRecordIds}

Source:

JoinTables.js, line 400

Parameters:

Name	Type	Description
`joinType`	String

Returns:

Type: JoinTablesRecordIds

setLeftTableName(name) → {JoinTablesRecordIds}

Source:

JoinTables.js, line 390

Parameters:

Name	Type	Description
`name`	String

Returns:

Type: JoinTablesRecordIds

setPrimaryTableInfo(primaryTableInfo) → {JoinTablesRecordIds}

Source:

JoinTables.js, line 410

Parameters:

Name	Type	Description
`primaryTableInfo`	Table

Returns:

Type: JoinTablesRecordIds

setRightTableName(name) → {JoinTablesRecordIds}

Source:

JoinTables.js, line 380

Parameters:

Name	Type	Description
`name`	String

Returns:

Type: JoinTablesRecordIds

setTableFields(tableFields) → {JoinTablesRecordIds}

Source:

JoinTables.js, line 350

Parameters:

Name	Type	Description
`tableFields`	TableFields

Returns:

Type: JoinTablesRecordIds

setTableInfo(tableInfo) → {JoinTablesRecordIds}

Source:

JoinTables.js, line 360

Parameters:

Name	Type	Description
`tableInfo`	Map.<String, Table>	Map of table info.

Returns:

Type: JoinTablesRecordIds