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