private static void Main(string[] args) { CSV_Parser parser = new CSV_Parser("table.csv", ';', "TEST"); Console.WriteLine(parser.TableName + Environment.NewLine + parser.Table); Console.WriteLine(); var res = parser.Table.Find(new string[] { "Address", "Age", "Name" }, new object[] { (object)"Banghok", (object)31, (object)"Bil" }); // res - null exeption on WriteToFile var res2 = parser.Table.Find("Age", (object)"31"); var res3 = parser.Table.Find("Age", (object)31); var res4 = parser.Table.Find("Address", (object)"LA"); //CSV_Table.WriteToFile(res); Console.WriteLine(String.Format("Find result :\n{0}", res)); var res11 = parser.Table.Find("Age", (object)31); var res21 = res11.Find("Address", (object)"LA"); var rowVal = parser.Table.GetColumnsFromRow(18); List <object[]> row = new List <object[]>(); for (int i = 0; i < 4; i++) { row.Add(new object[] { rowVal[i] }); } var head = parser.Table.ColNames; var types = CSV_Table.GetColumnTypesCsvFormat(parser.Table); var res31 = new CSV_Table(head, row, types); CSV_Table.WriteToFile(res31, "OneRowTable"); Console.WriteLine(res31); Console.ReadKey(); }
public void SearchTest() { var test = new CSV_Parser("table.csv", ';'); var res1 = test.Table.Find("Age", (object)31); var res2 = test.Table.Find("Address", (object)"LA"); var rowVal = test.Table.GetColumnsFromRow(18); List <object[]> row = new List <object[]>(); row.Add(rowVal); var head = test.Table.ColNames; var res3 = new CSV_Table(head, row, CSV_Table.GetColumnTypesCsvFormat(test.Table)); Assert.AreEqual(res2, res3); }
public void ladeGrid() { Daten = new ListView(); if (parser == null) { parser = new CSV_Parser(); } for (int i = 0; i <= 410; i++) { Daten.Items.Add(parser.getDaten(i)); } alleDatenPanel.Children.Add(Daten); }
/// <summary> /// Save the read data in a file if data_file is true /// </summary> /// <param name="frame">data read</param> private void WriteData(BITalinoFrame frame) { try { if (dataFile) { if (sw == null) { sw = File.AppendText(dataPath); sw.WriteLine(getChannelsRead()); sw.Flush(); } sw.WriteLine(CSV_Parser.ToCSV((stopWatch.Elapsed.TotalSeconds) + " " + frame.ToString(), manager.AnalogChannels.Length)); sw.Flush(); } } catch (Exception e) { UnityEngine.Debug.Log(e); } }
public void ParseTest() { // Arrange var test1 = new CSV_Parser("table.csv", ';'); //var test2 = new CSV_Parser("test.csv", ';'); // Act var result1 = test1.Table.ColNames; string[] temp = new string[] { "Name", "Address", "BirthDate", "Age" }; // Assert for (int i = 0; i < 4; i++) { Assert.AreEqual(result1[i], temp[i]); } }
public void ladeCustomGrid(String[] neueDaten) { alleDatenPanel.Children.Clear(); ListView DatenNew = new ListView(); if (parser == null) { parser = new CSV_Parser(); } for (int i = 0; i <= 410; i++) { if (neueDaten[i] != null) { DatenNew.Items.Add(neueDaten[i]); } } alleDatenPanel.Children.Add(DatenNew); }
private async void ladeDaten() { try { Uri source = new Uri("https://opendata.arcgis.com/datasets/917fc37a709542548cc3be077a786c17_0.csv", UriKind.Absolute); BackgroundDownloader downloader = new BackgroundDownloader(); Debug.WriteLine(Windows.Storage.ApplicationData.Current.LocalFolder); StorageFile testfile = await folder.CreateFileAsync("data.csv", CreationCollisionOption.ReplaceExisting); DownloadOperation download = downloader.CreateDownload(source, testfile); await download.StartAsync(); await Task.Delay(TimeSpan.FromSeconds(5)); if (parser == null) { parser = new CSV_Parser(); } parser.getDaten(); await Task.Delay(TimeSpan.FromSeconds(5)); int lol = parser.getDatenLange(); Debug.WriteLine(lol); LiveKachelCreator library = new LiveKachelCreator(); library.sendMessage(OldDataService.getOldLandkreis(), parser.getIndex(OldDataService.getOldLandkreis())); try { ladeGrid(); } catch (Exception e) { Debug.WriteLine("Download Error", e); } } catch (Exception ex) { Debug.WriteLine("Download Error", ex); } }