public static void Initialize(SensorLoggerContext context)
{
context.Database.EnsureCreated();
if (context.Microcontrollers.Any())
{
return; // DB has been seeded
}
var microcontrollers = new Microcontroller[]
{
new Microcontroller {
MicrocontrollerName = "Controller 1 med temperatur og fugtmaaler"
},
new Microcontroller {
MicrocontrollerName = "Controller 2 med temperaturmaaler"
},
new Microcontroller {
MicrocontrollerName = "Controller 3 med lysmaaler"
}
};
foreach (Microcontroller s in microcontrollers)
{
context.Microcontrollers.Add(s);
}
//context.SaveChanges();
var readings = new Reading[]
{
new Reading {
MicrocontrollerID = 1, ReadingID = 1, Date_time = DateTime.Parse("2020-09-01 7:24:37")
},
new Reading {
MicrocontrollerID = 2, ReadingID = 2, Date_time = DateTime.Parse("2020-12-03 9:11:42")
},
new Reading {
MicrocontrollerID = 2, ReadingID = 3, Date_time = DateTime.Parse("2020-01-11 1:53:26")
},
new Reading {
MicrocontrollerID = 3, ReadingID = 4, Date_time = DateTime.Parse("2020-11-03 3:36:51")
},
new Reading {
MicrocontrollerID = 3, ReadingID = 5, Date_time = DateTime.Parse("2020-03-02 8:34:12")
}
};
foreach (Reading c in readings)
{
context.Readings.Add(c);
}
//context.SaveChanges();
var readingValues = new ReadingValue[]
{
new ReadingValue {
ReadingValueID = 1, ReadingID = 1, Value = 23, ValueType = "C"
},
new ReadingValue {
ReadingValueID = 2, ReadingID = 1, Value = 67, ValueType = "Procent"
},
new ReadingValue {
ReadingValueID = 3, ReadingID = 2, Value = 25, ValueType = "C"
},
new ReadingValue {
ReadingValueID = 4, ReadingID = 3, Value = 21, ValueType = "C"
},
new ReadingValue {
ReadingValueID = 5, ReadingID = 4, Value = 1032, ValueType = "LUX"
},
new ReadingValue {
ReadingValueID = 6, ReadingID = 5, Value = 21032, ValueType = "LUX"
}
};
foreach (ReadingValue e in readingValues)
{
context.ReadingValues.Add(e);
}
//context.SaveChanges();
}
public UserRepository(SensorLoggerContext context)
{
_context = context;
}
