public void ReadLines_Basic() { Avocado.CsvReader csv; PlainObj1[] objs; string data; data = "Roger Ramjet, 47, 170.11, 13/11/1971\n" + "Yank, 27, 160.22, 1/1/1991\n" + "Doodle, 26, 150.33, 2/2/1992\n" + "Dan, 25, 140.44, 3/3/1993"; csv = new Avocado.CsvReader(data); objs = csv.ReadLines <PlainObj1>(); Assert.IsNotNull(objs); Assert.AreEqual(4, objs.Length); Assert.AreEqual("Roger Ramjet", objs[0].name); Assert.AreEqual(47, objs[0].age); Assert.AreEqual(170.11f, objs[0].height); Assert.AreEqual(new System.DateTime(1971, 11, 13), objs[0].dob); Assert.AreEqual("Yank", objs[1].name); Assert.AreEqual(27, objs[1].age); Assert.AreEqual(160.22f, objs[1].height); Assert.AreEqual(new System.DateTime(1991, 1, 1), objs[1].dob); }
public async System.Threading.Tasks.Task SaveToDb() { Avocado.CsvReader csv; System.IO.StreamReader file; UnitTests.domain.Person[] persons; UnitTests.data.AvocadoDb db; System.Data.Entity.Infrastructure.DbRawSqlQuery query; System.Collections.Generic.List <object> people; file = new System.IO.StreamReader("data//sample1.csv"); csv = new Avocado.CsvReader(file); persons = csv.ReadLines <UnitTests.domain.Person>(); db = new data.AvocadoDb(); db.Database.ExecuteSqlCommand("delete from people"); foreach (UnitTests.domain.Person person in persons) { db.People.Add(person); } db.SaveChanges(); query = db.Database.SqlQuery(typeof(UnitTests.domain.Person), "select * from people"); people = await query.ToListAsync(); Assert.IsNotNull(people); Assert.AreEqual(4, people.Count); }
public void ReadLine_Basic() { Avocado.CsvReader csv; PlainObj1 obj; csv = new Avocado.CsvReader("Roger Ramjet, 47, 170.12, 13/11/1971"); obj = csv.ReadLine <PlainObj1>(); Assert.AreEqual("Roger Ramjet", obj.name); Assert.AreEqual(47, obj.age); Assert.AreEqual(170.12f, obj.height); Assert.AreEqual(new System.DateTime(1971, 11, 13), obj.dob); }
public void ReadLines_FromFile_AsEFObj() { Avocado.CsvReader csv; EFObj1[] objs; System.IO.StreamReader file; file = new System.IO.StreamReader("data\\sample1.csv"); csv = new Avocado.CsvReader(file); objs = csv.ReadLines <EFObj1>(); Assert.IsNotNull(objs); Assert.AreEqual(4, objs.Length); Assert.AreEqual("Roger Ramjet", objs[0].name); Assert.AreEqual(new System.DateTime(1971, 11, 13), objs[0].dob); Assert.AreEqual("Yank", objs[1].name); Assert.AreEqual(new System.DateTime(1991, 1, 1), objs[1].dob); }
public void ReadLines_FromFileLarge() { Avocado.CsvReader csv; PlainObj2[] objs; System.IO.StreamReader file; file = new System.IO.StreamReader("data\\sample2.csv"); csv = new Avocado.CsvReader(file); csv.hasTitleRow = true; objs = csv.ReadLines <PlainObj2>(); Assert.IsNotNull(objs); Assert.AreEqual(36634, objs.Length); Assert.AreEqual("119736", objs[0].policyID); Assert.AreEqual(498960f, objs[0].eq_site_limit); Assert.AreEqual("398149", objs[36633].policyID); Assert.AreEqual(373488.3f, objs[36633].eq_site_limit); }