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