public void DatasetManager_GetSeriesData_Measurements_()
{
DatasetManager dm = new DatasetManager(new TreeMonDbContext(connectionKey));
List <DataPoint> series = dm.GetSeriesData("MeasurementLog", "Measure", null);
Assert.IsTrue(series.Count > 0);
}
public void DatasetManager_GetSeriesData_Measurements_QueryFilters()
{
//the getfilters function gets distinct values from a table field that will
//used to build the query to get the dataset. Controler only pulling from fireincidents for now. need to make it dynamic.
List <QueryFilter> filters = new List <QueryFilter>();
QueryFilter qf = new QueryFilter();
qf.Field = "UnitOfMeasure";
qf.Operator = "=";
qf.Value = "centimeters";
qf.Type = "sql"; //tell the parser is a sql query
qf.Junction = "AND"; //since more filters are to follow add a conjunction.
filters.Add(qf);
//#region range query filter
qf = new QueryFilter();
qf.Field = "Measure";
qf.Operator = "BETWEEN";
qf.Type = "sql"; //tell the parser is a sql query
qf.Value = "20";
qf.Order = 0; //this is the first part of the between statement
qf.Junction = "AND";
filters.Add(qf);
qf = new QueryFilter();
qf.Field = "Measure";
qf.Operator = "BETWEEN";
qf.Type = "sql"; //tell the parser is a sql query
qf.Value = "50";
qf.Order = 1; //second part of the between statement
filters.Add(qf);
//#endregion
DatasetManager dm = new DatasetManager(new TreeMonDbContext(connectionKey));
List <DataPoint> series = dm.GetSeriesData("MeasurementLog", "Measure", null);
Assert.IsTrue(series.Count > 0);
}
