public void DatasetManager_GetScalarData_AuthenticationLog_Username_Field_FailedLogin() { //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 = "Authenticated"; qf.Operator = "="; qf.Value = "0"; 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 Date range query filter qf = new QueryFilter(); qf.Field = "AuthenticationDate"; qf.Operator = "BETWEEN"; qf.Type = "sql"; //tell the parser is a sql query qf.Value = DateTime.UtcNow.AddMonths(-1).AddDays(-1).ToShortDateString(); qf.Order = 0; //this is the first part of the between statement qf.Junction = "AND"; filters.Add(qf); qf = new QueryFilter(); qf.Field = "AuthenticationDate"; qf.Operator = "BETWEEN"; qf.Type = "sql"; //tell the parser is a sql query qf.Value = DateTime.UtcNow.AddMonths(-1).AddDays(1).ToShortDateString(); qf.Order = 1; //second part of the between statement qf.Junction = "AND"; filters.Add(qf); #endregion qf = new QueryFilter(); qf.Field = "UserName"; qf.Operator = "="; qf.Type = "sql";//tell the parser is a sql query qf.Value = "beta_fail_login"; filters.Add(qf); DatasetManager dm = new DatasetManager(new TreeMonDbContext(connectionKey)); DataPoint dp = dm.GetScalarData("AuthenticationLog", "UserName", filters);//get usernames in AuthenticationLog Assert.AreEqual(dp.ValueType.ToUpper(), "STRING"); Assert.AreEqual(dp.Value, "beta_fail_login"); }
public void DatasetManager_GetScalarData_AuthenticationLog_Username_Field() { //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(); filters.Add(qf); //List<QueryFilter> filters = JsonConvert.DeserializeObject<List<QueryFilter>>(body); DatasetManager dm = new DatasetManager(new TreeMonDbContext(connectionKey)); DataPoint dp = dm.GetScalarData("AuthenticationLog", "UserName", null);//get usernames in AuthenticationLog Assert.AreEqual(dp.ValueType.ToUpper(), "STRING"); Assert.AreEqual(dp.Value.ToUpper(), "ALPHA"); }