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); }