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); }