public QueryRoot HandleQuery(string db, string query, IDbManagement dbm) { var root = new QueryRoot(); var result = new QueryResult(); var serie = new QuerySerie(); if (query.ToLower() == "show measurements") { serie.name = "measurements"; serie.columns.Add("name"); var myDb = dbm.GetDb(db); serie.values.AddRange(myDb.GetMeasurementNames().Select(i => new List<object> {i})); result.series.Add(serie); root.results.Add(result); return root; } var dbInstance = dbm.GetDb(db); var scriptingEngine = new ScriptingEngine(dbInstance, query); var res = scriptingEngine.Execute(); foreach (var s in res.Result.Series.OrderByDescending(i => i.FullName)) { QuerySerie querySerie = new QuerySerie(); CreateSingleResult(querySerie, s, result); } root.results.Add(result); return root; }
public App() { diContainer = BuildContainer(); dbManagement = DbManagement.CreateAsSingleton(); logger = diContainer.Resolve <ILogger>(); InitializeComponent(); MainPage = new NavigationPage(new MainPage()) { BarBackgroundColor = Color.LightGray, BarTextColor = Color.Black }; }
public QueryRoot HandleQuery(string db, string query, IDbManagement dbm) { var root = new QueryRoot(); var result = new QueryResult(); var serie = new QuerySerie(); if (query.ToLower().StartsWith("show measurements")) { serie.name = "measurements"; serie.columns.Add("name"); var myDb = dbm.GetDb(db); serie.values.AddRange(myDb.GetMeasurementNames().Select(i => new List <object> { i })); result.series.Add(serie); root.results.Add(result); return(root); } var dbInstance = dbm.GetDb(db); var queries = query.Split(new[] { ";" }, StringSplitOptions.RemoveEmptyEntries); foreach (var subQuery in queries) { var scriptingEngine = new ScriptingEngine(dbInstance, subQuery); var res = scriptingEngine.Execute(); foreach (var s in res.Result.Series.OrderByDescending(i => i.FullName)) { QuerySerie querySerie = new QuerySerie(); CreateSingleResult(querySerie, s, result); } } root.results.Add(result); return(root); }
public AppTests() { dbManagement = DbManagement.CreateAsSingleton(); }