public async Task <double> SumTheWaterLevel(string endpoint, string database)
{
var influxDbClient = new InfluxDbClient(endpoint, string.Empty, string.Empty, InfluxDbVersion.Latest);
var query = "SELECT water_level FROM h2o_feet";
var response = await influxDbClient.Client.QueryAsync(query, database);
var serie = response.Single();
double total = 0;
foreach (var values in serie.Values)
{
// value type seems to depend if value has decimal places.
switch (values[1])
{
case double water_level:
total += water_level;
break;
case long water_level:
total += water_level;
break;
}
}
return(total);
}
public async Task <BooleanValue <DataTable> > Query(string sql)
{
//string pathAndQuery = string.Format("/query?db={0}&q={1}", this.DataBase, sql);
//string url = _baseAddress + pathAndQuery;
InfluxDbClient client = new InfluxData.Net.InfluxDb.InfluxDbClient(_baseAddress, this._username, this._password, InfluxDbVersion.Latest, QueryLocation.Uri);
var result = await client.Client.QueryAsync(sql, this.DataBase);
//string result = HttpHelper.Get(url, _username, _password);
return(InfluxDataToDatatable(result.ToList()));
}
public InfluxDbProviderV9()
{
_influxDbClient = new InfluxDbClient(_influxDbUri, _influxDbUserName, _influxDbPassword, InfluxDbVersion.v_0_9_6);
}
public async Task <IInfluxDataApiResponse> WriteAsync(string dataBase, List <Point> ps)
{
InfluxDbClient client = new InfluxData.Net.InfluxDb.InfluxDbClient(_baseAddress, this._username, this._password, InfluxDbVersion.Latest, QueryLocation.Uri);
return(await client.Client.WriteAsync(ps, dataBase));
}
