public void RefreshTableViz(Visual visual)
{
DataTable table = GetTableFromParameter("statResult");
string testPerformed = "";
if (table != null)
{
visual.As <TablePlot>().Data.DataTableReference = table;
TablePlot tablePlot = visual.As <TablePlot>();
DataColumnCollection dfColumns = visual.As <TablePlot>().Data.DataTableReference.Columns;
List <DataColumn> listOfCols = new List <DataColumn>();
DataValueCursor dv = DataValueCursor.CreateFormatted(table.Columns["test"]);
foreach (DataRow row in table.GetRows(dv))
{
testPerformed = dv.CurrentDataValue.ValidValue.ToString();
break;
}
for (int i = 0; i < dfColumns.Count(); i++)
{
if (!(dfColumns[i].Name == "W" && testPerformed == "t test") && !(dfColumns[i].Name == "t" && testPerformed == "Mann-Withney test") && !(dfColumns[i].Name == "degree_of_freedom" && testPerformed == "Mann-Withney test"))
{
listOfCols.Add(dfColumns[i]);
}
}
visual.As <TablePlot>().TableColumns.Clear();
visual.As <TablePlot>().TableColumns.AddRange(listOfCols);
}
}
public LmiDataRowReader(LmiHandler lmiHandler)
{
this.lmiHandler = lmiHandler;
initQuery();
resultProperties = new ResultProperties();
resultProperties.SetProperty("Host", lmiHandler.Host);
resultProperties.SetProperty("UserName", lmiHandler.UserName);
resultProperties.SetProperty("Query", lmiHandler.Query);
if (lmiHandler.QueryId != null)
{
resultProperties.SetProperty("QueryID", lmiHandler.QueryId);
}
if (lmiHandler.IsCorrelation)
{
resultProperties.SetProperty("Correlation", "true");
}
else
{
resultProperties.SetProperty("Correlation", "false");
}
columns = new DataRowReaderColumn[queryDesc.columns.Length];
cursors = new DataValueCursor[queryDesc.columns.Length];
int i = 0;
foreach (ColumnDesc column in queryDesc.columns)
{
switch (column.type)
{
case "TIMESTAMP":
cursors[i] = DataValueCursor.CreateMutableCursor(DataType.DateTime);
columns[i] = new DataRowReaderColumn(column.name, DataType.DateTime, cursors[i]);
break;
case "INT":
cursors[i] = DataValueCursor.CreateMutableCursor(DataType.Integer);
columns[i] = new DataRowReaderColumn(column.name, DataType.Integer, cursors[i]);
break;
case "LONG":
cursors[i] = DataValueCursor.CreateMutableCursor(DataType.LongInteger);
columns[i] = new DataRowReaderColumn(column.name, DataType.LongInteger, cursors[i]);
break;
case "DOUBLE":
cursors[i] = DataValueCursor.CreateMutableCursor(DataType.Real);
columns[i] = new DataRowReaderColumn(column.name, DataType.Real, cursors[i]);
break;
case "BOOLEAN":
cursors[i] = DataValueCursor.CreateMutableCursor(DataType.Boolean);
columns[i] = new DataRowReaderColumn(column.name, DataType.Boolean, cursors[i]);
break;
//case "INET_ADDR":
default:
cursors[i] = (MutableValueCursor <string>)DataValueCursor.CreateMutableCursor(DataType.String);
columns[i] = new DataRowReaderColumn(column.name, DataType.String, cursors[i]);
break;
}
i++;
}
}
