static void Main(string[] args)
{
//using (var db = new MigrationTestContext())
//{
// for (var i = 0; i < 100; i++)
// {
// var newThing = db.MyThings.Add(new MyThing {FirstName = Guid.NewGuid().ToString()});
// Console.WriteLine("added newThing - " + newThing.FirstName);
// }
// db.SaveChanges();
//}
//Console.ReadLine();
ReadWeightsFile();
//Console.ReadLine();
using (var db = new MigrationTestContext())
{
var values = db.WhiskeyTangoFoxtrots
.Select(wtf => wtf)
.OrderBy(wtf => wtf.Date)
.ToList();
foreach (var w in values)
{
Console.WriteLine(w.Date.ToShortDateString() + " - " + w.Weight + " - " + w.Note + " - " + w.Id);
}
}
Console.ReadLine();
}
private static void ReadWeightsFile()
{
var path = @"C:\Users\c-wallas\Desktop\r-and-d\migration_rnd\migration_rnd\measurements-weight-combined.csv";
using (var db = new MigrationTestContext())
{
using (var reader = File.OpenText(path))
{
var skipFirstLine = reader.ReadLine();
string line;
while ((line = reader.ReadLine()) != null)
{
var fields = line.Split(',');
var date = DateTime.Parse(string.Format("{0} {1}", fields[0], fields[1]));
var value = decimal.Parse(fields[2]);
var note = fields[3];
//Console.WriteLine(date.ToShortDateString() + "," + value + "," + note);
db.WhiskeyTangoFoxtrots.AddOrUpdate(
wtf => wtf.Date,
new WhiskeyTangoFoxtrot { Id = Guid.NewGuid(), Date = date, Weight = value, Note = note }
);
}
}
db.SaveChanges();
}
}
