public void Setup() { _dbm = new DbManagement(true); _dbm.DetachAllDbs(); _unitUnderTest = (Db)_dbm.CreateDb(DbRootDir, TestDbName); _unitUnderTest.DeleteAllMeasurements(); }
public static KendoSiteInputMapping GetAllSite() { // AddUpdateSiteAsync("https://acpol2.army.mil/vacancy/vacancy_list.asp", 24); var siteElems = DbManagement.SiteAllRow(); return(new KendoSiteInputMapping(siteElems.ToList())); }
public void Deserialize() { _unitUnderTest.CreateDb(DbRootDir, TestDbName); var secondManagement = new DbManagement(true); secondManagement.GetDbNames().Count.Should().Be(1); }
public void MultipleAbsoluteHumidityTableGroups() { var db = new DbManagement().GetDb("f*x"); var result = db.GetTable <float>("Innen.(?<g>.*).(?<k>Temperatur|Feuchtigkeit)$", "time > now() - 1M") .Transform(g => g.Group(i => i.ByTime.Hours(1).ExpandTimeRangeByFactor(7).Aggregate(o => o.Mean()))) .GroupSeries().Transform(t => t.AbsoluteHumidity("Temperatur", "Feuchtigkeit")).MergeTables(); }
public void DewPointTest() { var db = new DbManagement().GetDb("f*x"); var queryTable = db.GetTable <float>("Aussen.Wetterstation.(?<k>.*?)$", "time > now() - 1y"); var result = queryTable .Transform(i => i.GroupByHours(1, o => o.Mean())) .DewPoint("Temperatur", "Feuchtigkeit", "Taupunkt"); }
public void MultipleTableGroups() { var db = new DbManagement().GetDb("f*x"); var queryTable = db.GetTable <float>("Innen.(?<g>.*).(?<k>Temperatur|Feuchtigkeit)$", "time > now() - 1M"); var result = queryTable .Transform(i => i.GroupByHours(1, o => o.Mean())) .ZipToNew("Sum", t => t.Temperatur + t.Feuchtigkeit); }
private void btn_LoadData_Click(object sender, RoutedEventArgs e) { var db = new DbManagement(); string sdate = start_date.SelectedDate.Value.ToShortDateString(); string edate = end_date.SelectedDate.Value.ToShortDateString(); grid_History_stock.ItemsSource = db.GetDataHistoryStock(sdate, edate).DefaultView; }
//update stock quantity private void updateStockQuant() { var db = new DbManagement(); for (int i = 0; i < db.searchCart(txt_transaction.Text).Rows.Count; i++) { db.UpdateQuantStock(db.searchCart(txt_transaction.Text).Rows[i][2].ToString(), Convert.ToInt32(db.searchCart(txt_transaction.Text).Rows[i][4].ToString())); } }
public void DynamicTableInScript() { var db = new DbManagement().GetDb("f*x"); var result = new ScriptingEngine(db, @"db.GetTable<float>(""Aussen.Wetterstation.(?<k>[TF]).*?$"", ""time > now() - 1M"") .Transform(i => i.GroupByHours(1, o => o.Mean())) .ZipAndAdd(""Sum"", t => t.T + t.F)").Execute(); }
public void AddAliasesTest() { var dbm = new DbManagement(); var db = dbm.GetDb("Haus"); var sw = Stopwatch.StartNew(); db.AddAliasToMeasurements("OpenHAB.out.(.*).state", "$1"); sw.Stop(); }
private void DoWork(object state) { if (lastDay != DateTime.Now.Day) { lastDay = DateTime.Now.Day; lottoData.downloadAllLotto(); DbManagement.DsSiteLoad(); } PingMe();//if i don't do it the sise go down }
// POST api/values public void Post(User user) { try { DbManagement.InsertNewUser(user); } catch (Exception) { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occurred")); } }
public void RecreateFuxDb() { var dbm = new DbManagement(); var dbName = "f*x"; if (dbm.GetDbNames().Contains(dbName)) { dbm.DeleteDb(dbName); } dbm.CreateDb(@"c:\DBs\SharpTsdb", dbName); }
public void AllMeasurementNamesTest() { var dbm = new DbManagement(); var db = dbm.GetDb("Haus"); var sw = Stopwatch.StartNew(); var measurements = db.GetMeasurements(".*"); var names = measurements.SelectMany(i => i.NameAndAliases).OrderBy(i => i).ToList(); var nameString = string.Join("\r\n", names); var measurement = db.GetMeasurement("HmWetterstationSunshineduration"); sw.Stop(); }
public void GetMeasurementsTest() { var dbm = new DbManagement(); var db = dbm.GetDb("Haus"); var sw = Stopwatch.StartNew(); for (int i = 0; i < 100; i++) { var ms = db.GetMeasurements("a"); } sw.Stop(); }
public void FixFromTo() { var dbm = new DbManagement(); var db = dbm.GetDb("f*x"); var sw = Stopwatch.StartNew(); var mix = db.Collect(db.GetSerie <float>("Aussen.Wetterstation.Temperatur", "time > now() - 2d") .GroupBy("6h", a => a.Mean()), db.GetTable <float>(".*Feuchtigkeit", "time > now() - 2d")); sw.Stop(); }
public void MovingAverage() { var db = new DbManagement().GetDb("f*x"); var time = "time < now() - 14d and time > now() - 21d"; var serie = db.GetSerie <float>("Aussen.Wetterstation.Temperatur", time) .Group( g => g.ByTime.Minutes(10) .TimeStampIsMiddle() .ExpandTimeRangeByFactor(20) .Aggregate(a => a.MeanByTime())); }
public void MeasurementExistingInSecondInstance() { _unitUnderTest.CreateMeasurement(TestMeasName, typeof(float)); var measurement = _unitUnderTest.GetMeasurement(TestMeasName); var binName = measurement.BinaryFilePath; var dbm = new DbManagement(true); var db = dbm.GetDb(TestDbName); var m = db.GetMeasurement(TestMeasName); m.BinaryFilePath.Should().Be(binName); }
public void AllCalcTempValuesTest() { var db = new DbManagement().GetDb("f*x"); var queryTable = db.GetTable <float>("Aussen.Wetterstation.(?<k>.*?)$", "time > now() - 1M"); var result = queryTable .Transform(i => i.GroupByHours(1, o => o.Mean())) .AddDewPoint("Temperatur", "Feuchtigkeit") .AddAbsoluteHumidity("Temperatur", "Feuchtigkeit") .AddHumidex("Temperatur", "Feuchtigkeit") .AddHeatIndex("Temperatur", "Feuchtigkeit") .AddSleetLine("Temperatur", "Feuchtigkeit", 440) .AddSnowLine("Temperatur", "Feuchtigkeit", 440) .RemoveSerie("Feuchtigkeit"); }
public void DynamicWithRealDb() { var db = new DbManagement().GetDb("f*x"); var queryTable = db.GetTable <float>("Aussen.Wetterstation.(?<k>[TF]).*?$", "time > now() - 1M"); var result = queryTable .Group(g => g.ByTime.Hours(1).Aggregate(o => o.Mean())) .Calc(t => t.Sum = t.T + t.F); result.Series.Count().Should().Be(3); result = result.RemoveDbSeries(); result.Series.Count().Should().Be(1); }
public static bool AddSite(SiteInputMapping elem) { try { SiteRow row = DbManagement.DsSiteData_newRow(elem); DbManagement.LottoDs_addRow(row); DbManagement.SiteAllRow(); return(true); } catch (Exception EX) { throw EX; } }
public App() { diContainer = BuildContainer(); dbManagement = DbManagement.CreateAsSingleton(); logger = diContainer.Resolve <ILogger>(); InitializeComponent(); MainPage = new NavigationPage(new MainPage()) { BarBackgroundColor = Color.LightGray, BarTextColor = Color.Black }; }
private void ListDescrip() { var db = new DbManagement(); list_descrption.Items.Clear(); list_discount.Items.Clear(); list_price.Items.Clear(); list_quant.Items.Clear(); for (int i = 0; i < db.getCartProductName(tranId).Rows.Count; i++) { list_descrption.Items.Add(db.getCartProductName(tranId).Rows[i][1].ToString()); list_price.Items.Add(db.getCartProductName(tranId).Rows[i][2].ToString()); list_discount.Items.Add(db.getCartProductName(tranId).Rows[i][3].ToString()); list_quant.Items.Add(db.getCartProductName(tranId).Rows[i][4].ToString()); } }
//login data private void login() { var db = new DbManagement(); //db.checkConnect(); //this.; db.Login(txt_User_login.Text, HasScrip(txt_password_login.Password)); // MessageBox.Show(db.CheckLogin()+""); if (db.CheckLogin() == true) { // Application.Current.Shutdown(); this.Dispatcher.BeginInvoke(new Action(() => { this.Close(); })); } }
private void btn_restor_data_Click(object sender, RoutedEventArgs e) { try { var db = new DbManagement(); db.InsertStock(sid, cateId, proId, unit, date, quantity, emid, bal); db.RemoveHistoryStock(sid); notify.Title = "Stock Management Form"; notify.Message = "Restore Products Successful..."; notify.ShowNotfySucess(); } catch (Exception ex) { MessageBox.Show(ex.Message + ""); } }
private void getPname() { try { // MessageBox.Show(pId,tranNO); var db = new DbManagement(); var Pname = db.getSearchProductName(pId).Rows[0][2].ToString(); string p = db.getSearchProductName(pId).Rows[0][7].ToString(); txt_product_name.Text = Pname; price = Convert.ToDouble(p); } catch (Exception ex) { MessageBox.Show(ex.Message + "Not find Product Id"); this.Dispatcher.BeginInvoke((Action)(() => { this.Close(); })); } }
private void getImageUser() { try { var db = new DbManagement(); if (string.IsNullOrEmpty(db.getIconUser())) { } else { image_user.Source = new BitmapImage(new Uri(db.getIconUser().ToString())); } } catch (Exception ex) { MessageBox.Show(ex.GetType().Name + ""); } }
private void LoadDatarefresh() { try { // grid_cart.ItemsSource = ""; DbManagement db = new DbManagement(); if (grid_cart != null) { grid_cart.ItemsSource = db.DataCart().DefaultView; } //grid_cart.DataContext = db.BrandData().ToList<BrandEntry>(); } catch (Exception ex) { MessageBox.Show(ex.Message + "Grid"); } }
private void checkStock() { var db = new DbManagement(); int quantStock = db.numnerQutStock(pId); if (quantStock <= 10) { MessageBox.Show("this Product quantity min...."); } if (quantStock == 0) { MessageBox.Show("Not Product in Stock"); } else { SaveOrderCart(); } }
private void Form1_FormClosing(object sender, FormClosingEventArgs e) { if (string.IsNullOrEmpty(_therapist.SqlbackupFolder)) { return; } var loaderFrm = new UI.Globals.Loader("Attendere il salvataggio del database"); loaderFrm.Show(); var file = Path.Combine(_therapist.SqlbackupFolder, $"pisioHelp_{DateTime.Today.ToString("yyyyMMdd")}.sql"); DbManagement.PostgreSqlDump(file); DriveManagement.DeleteInFolder("Database_Backup", DataModels.Enums.FileType.sql, 7); DriveManagement.InsertFile(file, new List <string> { "Database_Backup" }, DataModels.Enums.FileType.sql); }