public async Task TestDropDatabaseAsync()
{
var db = "hara-kiri";
var client = new InfluxDBClient(influxUrl, dbUName, dbpwd);
var r = await client.CreateDatabaseAsync(db);
Assert.IsTrue(r, "CreateDatabaseAsync retunred false");
var d = new InfluxDatabase(db);
r = await client.DropDatabaseAsync(d);
Assert.IsTrue(r && d.Deleted, "DropDatabaseAsync retunred false");
}
private List <GenericColumn> FilterGenericColumns(List <GenericColumn> columns, List <GenericColumn> filterColumns, InfluxDatabase dbStructure)
{
switch (settings.GenericFile.Filter)
{
case Filters.Measurement:
return(columns.Where(p => dbStructure.Measurements.Any(m => m.Name == settings.InfluxDB.Measurement)).ToList());
case Filters.Field:
return(columns.Where(p => dbStructure.Measurements.Any(m => m.Name == settings.InfluxDB.Measurement) &&
(dbStructure.Measurements.FirstOrDefault(m => m.Name == settings.InfluxDB.Measurement).Tags.Contains(p.ColumnHeader) ||
dbStructure.Measurements.FirstOrDefault(m => m.Name == settings.InfluxDB.Measurement).Fields.Contains(p.ColumnHeader))).ToList());
case Filters.Columns:
return(columns.Where(p => filterColumns.Any(f => f.ColumnHeader == p.ColumnHeader)).ToList());
}
return(columns);
}
public InfluxMetricDataProcessor(InfluxDatabase db)
{
this.db = db;
}
async public static Task Init()
{
int count2 = dataClass.countOfElements / 100;
int count = ((dataClass.countOfDays + 100) / 100);
//====================================================================================Коннект в бд============
string nameDB = "Process";
InfluxDBClient client = new InfluxDBClient("http://localhost:8086", "root", "root");
await client.CreateDatabaseAsync(nameDB);
InfluxDatabase name = new InfluxDatabase(nameDB);
var m = await client.DropDatabaseAsync(name);
await client.CreateDatabaseAsync(nameDB);
for (int i = 0; i < dataClass.countOfDays; i++)
{
var valMixed1 = new InfluxDatapoint <InfluxValueField>();
var valMixed2 = new InfluxDatapoint <InfluxValueField>();
var valMixed3 = new InfluxDatapoint <InfluxValueField>();
var valMixed4 = new InfluxDatapoint <InfluxValueField>();
var valMixed5 = new InfluxDatapoint <InfluxValueField>();
valMixed1.UtcTimestamp = rmseClass.rmseDates[i].ToUniversalTime();
valMixed2.UtcTimestamp = rmseClass.rmseDates[i].ToUniversalTime();
valMixed3.UtcTimestamp = rmseClass.rmseDates[i].ToUniversalTime();
valMixed4.UtcTimestamp = rmseClass.rmseDates[i].ToUniversalTime();
valMixed5.UtcTimestamp = rmseClass.rmseDates[i].ToUniversalTime();
valMixed1.MeasurementName = "RmseValuesForAlgOne";
valMixed2.MeasurementName = "RmseValuesForAlgTwo";
valMixed3.MeasurementName = "RmseValuesForAlgThree";
valMixed4.MeasurementName = "RmseValuesForAlgFour";
valMixed5.MeasurementName = "RmseValuesForAlgFive";
double[] values = new double[5];
values[0] = rmseClass.ValuesRMSE1[i];
values[1] = rmseClass.ValuesRMSE2[i];
values[2] = rmseClass.ValuesRMSE3[i];
values[3] = rmseClass.ValuesRMSE4[i];
values[4] = rmseClass.ValuesRMSE5[i];
valMixed1.Fields.Add("value", new InfluxValueField(values[0]));
valMixed2.Fields.Add("value", new InfluxValueField(values[1]));
valMixed3.Fields.Add("value", new InfluxValueField(values[2]));
valMixed4.Fields.Add("value", new InfluxValueField(values[3]));
valMixed5.Fields.Add("value", new InfluxValueField(values[4]));
var r = await client.PostPointAsync(nameDB, valMixed1);
var s = await client.PostPointAsync(nameDB, valMixed2);
var t = await client.PostPointAsync(nameDB, valMixed3);
var u = await client.PostPointAsync(nameDB, valMixed4);
var f = await client.PostPointAsync(nameDB, valMixed5);
label.Text = $"Запись значений RMSE (Выполнено {i/count}%)";
}
for (int i = 0; i < dataClass.countOfElements; i++)
{
var valMixed6 = new InfluxDatapoint <InfluxValueField>();
var valMixed7 = new InfluxDatapoint <InfluxValueField>();
var valMixed8 = new InfluxDatapoint <InfluxValueField>();
var valMixed9 = new InfluxDatapoint <InfluxValueField>();
var valMixed10 = new InfluxDatapoint <InfluxValueField>();
var valMixed11 = new InfluxDatapoint <InfluxValueField>();
valMixed6.UtcTimestamp = dataClass.famousDates[i].ToUniversalTime();
valMixed7.UtcTimestamp = dataClass.famousDates[i].ToUniversalTime();
valMixed8.UtcTimestamp = dataClass.famousDates[i].ToUniversalTime();
valMixed9.UtcTimestamp = dataClass.famousDates[i].ToUniversalTime();
valMixed10.UtcTimestamp = dataClass.famousDates[i].ToUniversalTime();
valMixed11.UtcTimestamp = dataClass.famousDates[i].ToUniversalTime();
valMixed6.MeasurementName = "ValuesOne";
valMixed7.MeasurementName = "ValuesTwo";
valMixed8.MeasurementName = "ValuesThree";
valMixed9.MeasurementName = "ValuesFour";
valMixed10.MeasurementName = "ValuesFive";
valMixed11.MeasurementName = "FamousValues";
double[] values1 = new double[6];
values1[0] = logicClass.ValuesLog1[i];
values1[1] = logicClass.ValuesLog2[i];
values1[2] = logicClass.ValuesLog3[i];
values1[3] = logicClass.ValuesLog4[i];
values1[4] = logicClass.ValuesLog5[i];
values1[5] = dataClass.famousValues[i];
valMixed6.Fields.Add("value", new InfluxValueField(values1[0]));
valMixed7.Fields.Add("value", new InfluxValueField(values1[1]));
valMixed8.Fields.Add("value", new InfluxValueField(values1[2]));
valMixed9.Fields.Add("value", new InfluxValueField(values1[3]));
valMixed10.Fields.Add("value", new InfluxValueField(values1[4]));
valMixed11.Fields.Add("value", new InfluxValueField(values1[5]));
var r1 = await client.PostPointAsync(nameDB, valMixed6);
var s1 = await client.PostPointAsync(nameDB, valMixed7);
var t1 = await client.PostPointAsync(nameDB, valMixed8);
var u1 = await client.PostPointAsync(nameDB, valMixed9);
var f1 = await client.PostPointAsync(nameDB, valMixed10);
var f2 = await client.PostPointAsync(nameDB, valMixed11);
label.Text = $"Запись значений алгоритмов (Выполнено {i/count2}%)";
}
}
private List <PerfmonCounter> FilterPerfmonLogColumns(List <PerfmonCounter> columns, List <PerfmonCounter> filterColumns, InfluxDatabase dbStructure)
{
switch (settings.PerfmonFile.Filter)
{
case Filters.Measurement:
return(columns.Where(p => dbStructure.Measurements.Any(m => m.Name == p.PerformanceObject)).ToList());
case Filters.Field:
return(columns.Where(p => dbStructure.Measurements.Any(m => m.Name == p.PerformanceObject) && dbStructure.Measurements.FirstOrDefault(m => m.Name == p.PerformanceObject).Fields.Any(f => f == p.CounterName)).ToList());
case Filters.Columns:
return(columns.Where(p => filterColumns.Any(f => p.PerformanceObject == f.PerformanceObject && p.CounterName == f.CounterName)).ToList());
}
return(columns);
}
