public IHttpActionResult PutReading(int id, Reading reading)
{
if (reading != null)
{
SqlOperator.PutReading(id, reading);
return(Ok());
}
else
{
return(BadRequest());
}
}
public void PutReadingTest()
{
var newReading = new Reading
{
TimeStamp = (int)DateTimeOffset.Now.ToUnixTimeSeconds(),
Co = 0.5,
No = 0.5,
So = 0.5
};
var command = "SELECT * FROM Readings " +
"WHERE TimeStamp IN(SELECT MAX(TimeStamp) FROM Readings)";
var latestReading = SqlOperator.GetReadings(command)[0];
SqlOperator.PutReading(latestReading.Id, newReading);
var command2 = $"SELECT * FROM Readings WHERE Id={latestReading.Id}";
var reading = SqlOperator.GetReadings(command2)[0];
Assert.AreEqual(newReading.TimeStamp, reading.TimeStamp);
}
