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