public static void insertAllStats()
{
String message = "Inserting all stats from " + start + " to " + end;
log.Info(message);
if (MainApp.GetConsole())
{
MessageBox.Show(message);
}
InfluxdbClient.dropDB();
InfluxdbClient.createDB();
//System.Threading.Thread.Sleep(2000);
insertInvoiceStats();
log.Info("Finished invoices.");
insertWorkOrderStats();
log.Info("Finished wo.");
insertProposalStats();
log.Info("Finished props.");
insertPurchaseOrders();
log.Info("Finished po.");
insertPayrollStats();
log.Info("Finished pay.");
insertARStats();
log.Info("Finished ar.");
insertItems();
log.Info("Finished items.");
}
protected static void updateWIPStats(DataTable dataTable, String dateColumn, List <String> fieldColumns, List <String> tagColumns, String measurement)
{
List <Measurement> measurements = new List <Measurement>();
DateTime timestamp = DateTime.Now;
// Create Measurement per row
foreach (DataRow row in dataTable.Rows)
{
Dictionary <string, object> fields = new Dictionary <string, object>();
Dictionary <string, string> tags = new Dictionary <string, string>();
foreach (DataColumn dc in dataTable.Columns)
{
object value = row[dc.ColumnName.ToString()];
if (value == null || value == DBNull.Value)
{
continue;
}
if (isField(fieldColumns, dc.ColumnName))
{
fields.Add(dc.ColumnName.ToString(), Convert.ToSingle(row[dc.ColumnName.ToString()]));
}
else if (isField(tagColumns, dc.ColumnName))
{
String tValue = row[dc.ColumnName.ToString()].ToString().Trim().Replace(" ", "_");
tags.Add(dc.ColumnName.ToString(), tValue);
}
else if (tagColumns != null)
{
// Everything else should be treated as a string value
String tValue = row[dc.ColumnName.ToString()].ToString().Trim().Replace(" ", "_");
fields.Add(dc.ColumnName.ToString(), tValue);
}
else
{
String tValue = row[dc.ColumnName.ToString()].ToString().Trim().Replace(" ", "_");
tags.Add(dc.ColumnName.ToString(), tValue);
}
}
String convDate = row[dateColumn].ToString();
if (!String.IsNullOrEmpty(convDate) && !String.IsNullOrWhiteSpace(convDate))
{
timestamp = Convert.ToDateTime(convDate);
}
measurements.Add(InfluxdbClient.buildMeasurement(measurement, fields, tags, timestamp));
if (measurements.Count == BATCH_SIZE)
{
InfluxdbClient.WriteBulkMeasurements(measurements);
measurements.Clear();
System.Threading.Thread.Sleep(1000);
}
}
// Bulk write out the stats
InfluxdbClient.WriteBulkMeasurements(measurements);
}
private void dropDBToolStripMenuItem_Click(object sender, EventArgs e)
{
InfluxdbClient.dropDB();
}
private void pongTestToolStripMenuItem_Click(object sender, EventArgs e)
{
InfluxdbClient.testInfluxDBClient();
}
