// Initialize a table.
// @param table table entity
// @return initialized table entity
public static StagingTable initTable(StagingTable table)
{
HashSet <String> extraInputs = new HashSet <String>();
List <List <String> > pTableRawRows = table.getRawRows();
// empty out the parsed rows
List <ITableRow> newTableRows = new List <ITableRow>();
if (pTableRawRows != null)
{
newTableRows.Capacity = pTableRawRows.Count;
}
table.setTableRows(newTableRows);
if (pTableRawRows != null)
{
foreach (List <String> row in pTableRawRows)
{
StagingTableRow tableRowEntity = new StagingTableRow();
// make sure the number of cells in the row matches the number of columns defined
if (table.getColumnDefinitions().Count != row.Count)
{
throw new System.InvalidOperationException("Table '" + table.getId() + "' has a row with " + row.Count + " values but should have " + table.getColumnDefinitions().Count + ": " + row);
}
// loop over the column definitions in order since the data needs to be retrieved by array position
for (int i = 0; i < table.getColumnDefinitions().Count; i++)
{
StagingColumnDefinition col = (StagingColumnDefinition)(table.getColumnDefinitions()[i]);
String cellValue = row[i];
switch (col.getType())
{
case ColumnType.INPUT:
// if there are no ranges in the list, that means the cell was "blank" and is not needed in the table row
List <Range> ranges = splitValues(cellValue);
if (!(ranges.Count == 0))
{
tableRowEntity.addInput(col.getKey(), ranges);
// if there are key references used (values that reference other inputs) like {{key}}, then add them to the extra inputs list
foreach (StagingRange range in ranges)
{
if (DecisionEngineFuncs.isReferenceVariable(range.getLow()))
{
extraInputs.Add(DecisionEngineFuncs.trimBraces(range.getLow()));
}
if (DecisionEngineFuncs.isReferenceVariable(range.getHigh()))
{
extraInputs.Add(DecisionEngineFuncs.trimBraces(range.getHigh()));
}
}
}
break;
case ColumnType.ENDPOINT:
StagingEndpoint endpoint = parseEndpoint(cellValue);
endpoint.setResultKey(col.getKey());
tableRowEntity.addEndpoint(endpoint);
// if there are key references used (values that reference other inputs) like {{key}}, then add them to the extra inputs list
if (EndpointType.VALUE == endpoint.getType() && DecisionEngineFuncs.isReferenceVariable(endpoint.getValue()))
{
extraInputs.Add(DecisionEngineFuncs.trimBraces(endpoint.getValue()));
}
break;
case ColumnType.DESCRIPTION:
// do nothing
break;
default:
throw new System.InvalidOperationException("Table '" + table.getId() + " has an unknown column type: '" + col.getType() + "'");
}
}
tableRowEntity.ConvertColumnInput();
newTableRows.Add(tableRowEntity);
}
}
// add extra inputs, if any; do not include context variables since they are not user input
foreach (String s in Staging.CONTEXT_KEYS)
{
extraInputs.Remove(s);
}
table.setExtraInput(extraInputs.Count == 0 ? null : extraInputs);
table.GenerateInputColumnDefinitions();
return(table);
}