public void DeleteReadingTest()
{
var command = "SELECT * FROM Readings " +
"WHERE TimeStamp IN(SELECT MAX(TimeStamp) FROM Readings)";
var latestReading = SqlOperator.GetReadings(command)[0];
SqlOperator.DeleteReading(latestReading.Id);
var command2 = $"SELECT * FROM Readings WHERE Id={latestReading.Id}";
var readings = SqlOperator.GetReadings(command2);
Assert.IsTrue(readings.Count == 0);
}
public IHttpActionResult DeleteReading(int id)
{
var command = $"SELECT * FROM Readings WHERE Id={id}";
var readings = SqlOperator.GetReadings(command);
if (readings.Count == 0)
{
return(NotFound());
}
SqlOperator.DeleteReading(id);
return(Ok(readings[0]));
}
public IHttpActionResult GetAllReadings()
{
var command = "SELECT * FROM Readings";
var readings = SqlOperator.GetReadings(command);
if (readings.Count > 0)
{
return(Ok(readings));
}
else
{
return(NotFound());
}
}
public IHttpActionResult GetLatestReading()
{
var command = "SELECT * FROM Readings " +
"WHERE TimeStamp IN(SELECT MAX(TimeStamp) FROM Readings)";
var reading = SqlOperator.GetReadings(command)[0];
if (reading != null)
{
return(Ok(reading));
}
else
{
return(NotFound());
}
}
public IHttpActionResult GetReadingsFromLastWeek()
{
var timeNow = DateTimeOffset.Now.ToUnixTimeSeconds();
var command = "SELECT * FROM Readings " +
$"WHERE TimeStamp BETWEEN {timeNow-7*24*3600} AND {timeNow}";
var readings = SqlOperator.GetReadings(command);
if (readings.Count > 0)
{
return(Ok(readings));
}
else
{
return(NotFound());
}
}
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);
}
public void GetReadingsTest()
{
var readings = SqlOperator.GetReadings("SELECT * FROM Readings");
Assert.IsTrue(readings.Count >= 1);
}
