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