private DatabaseModel()
{
db = new LocalDataContext();
}
public static void EnsureSeedData(this LocalDataContext context)
{
//if (context.Measures.Any())
//{
// context.RemoveRange(context.Measures);
// context.SaveChanges();
//}
if (!context.SensorTypes.Any())
{
context.SensorTypes.Add(new SensorType()
{
Id = 1, name = "pH Sensor", description = "Common values between 6-7"
});
context.SensorTypes.Add(new SensorType()
{
Id = 2, name = "Water Temperature Sensor", description = "Common values between 15-30"
});
context.SensorTypes.Add(new SensorType()
{
Id = 3, name = "Dissolved Oxygen Sensor", description = "Common values between 0-100"
});
context.SensorTypes.Add(new SensorType()
{
Id = 4, name = "ORP sensor", description = "Common values between 300-800"
});
context.SensorTypes.Add(new SensorType()
{
Id = 5, name = "Air Temperature Sensor", description = "Common values between 5-32"
});
context.SensorTypes.Add(new SensorType()
{
Id = 6, name = "Air Humidity Sensor", description = "Common values between 40-80"
});
context.SaveChanges();
}
#if !ARM
//if (!context.Measures.Any())
//{
// var phSensor = context.SensorTypes.Where(s => s.Id == 1).FirstOrDefault();
// var waterTemperatureSensor = context.SensorTypes.Where(s => s.Id == 2).FirstOrDefault();
// var dissolvedOxySensor = context.SensorTypes.Where(s => s.Id == 3).FirstOrDefault();
// var ORPSensor = context.SensorTypes.Where(s => s.Id == 4).FirstOrDefault();
// var airTemperatureSensor = context.SensorTypes.Where(s => s.Id == 5).FirstOrDefault();
// for (int i = 0; i < 100; i++)
// {
// Random rnd = new Random();
// var currentDate = DateTime.Now;
// currentDate = currentDate.AddTicks(-(currentDate.Ticks % TimeSpan.TicksPerSecond)).AddMinutes(-10 * i);
// decimal phValue = Convert.ToDecimal(Math.Round(7 + Math.Sin(0.5 * i) + 0.1 * rnd.Next(-1, 1), 3));
// context.Measures.Add(new Measure() { captureDate = currentDate, value = phValue, sensor = phSensor });
// decimal waterTemperatureValue = Convert.ToDecimal(Math.Round(15 + Math.Sin(0.1 * i) + 0.5 * rnd.Next(-1, 1), 3));
// context.Measures.Add(new Measure() { captureDate = currentDate, value = waterTemperatureValue, sensor = waterTemperatureSensor });
// decimal dissolvedOxyValue = Convert.ToDecimal(Math.Round(250 + Math.Sin(0.01 * i) + 0.5 * rnd.Next(-1, 1), 3));
// context.Measures.Add(new Measure() { captureDate = currentDate, value = dissolvedOxyValue, sensor = dissolvedOxySensor });
// decimal ORPValue = Convert.ToDecimal(Math.Round(150 + Math.Sin(0.01 * i) + 0.7 * rnd.Next(-1, 1), 3));
// context.Measures.Add(new Measure() { captureDate = currentDate, value = ORPValue, sensor = ORPSensor });
// decimal airTemperatureValue = Convert.ToDecimal(Math.Round(20 + Math.Sin(0.001 * i) + 0.5 * rnd.Next(-1, 1), 3));
// context.Measures.Add(new Measure() { captureDate = currentDate, value = airTemperatureValue, sensor = airTemperatureSensor });
// };
// context.SaveChanges();
//}
#endif
}
