diff options
author | marcinzelent <zelent.marcin@gmail.com> | 2018-03-16 21:40:28 +0100 |
---|---|---|
committer | marcinzelent <zelent.marcin@gmail.com> | 2018-03-16 21:40:28 +0100 |
commit | 08e7a82cc7b237e550c0236bebd4f41c3c3f4acf (patch) | |
tree | 30e2320d62f2bf3981120ad76f2de92efec1e8f5 /PollutometerWebApi.Tests/SqlOperatorTests.cs | |
parent | 9441b9d8b3035dc3142234dd13a1bcea21e72749 (diff) |
Moved API to separate folder.
Diffstat (limited to 'PollutometerWebApi.Tests/SqlOperatorTests.cs')
-rw-r--r-- | PollutometerWebApi.Tests/SqlOperatorTests.cs | 68 |
1 files changed, 0 insertions, 68 deletions
diff --git a/PollutometerWebApi.Tests/SqlOperatorTests.cs b/PollutometerWebApi.Tests/SqlOperatorTests.cs deleted file mode 100644 index 2930679..0000000 --- a/PollutometerWebApi.Tests/SqlOperatorTests.cs +++ /dev/null @@ -1,68 +0,0 @@ -using Microsoft.VisualStudio.TestTools.UnitTesting; -using PollutometerWebApi.Models; -using System; - -namespace PollutometerWebApi.Tests -{ - [TestClass()] - public class SqlOperatorTests - { - [TestMethod()] - public void GetReadingsTest() - { - var readings = SqlOperator.GetReadings("SELECT * FROM Readings"); - Assert.IsTrue(readings.Count >= 1); - } - - [TestMethod()] - public void PostReadingTest() - { - var newReading = new Reading - { - TimeStamp = (int)DateTimeOffset.Now.ToUnixTimeSeconds(), - Co = 0.0, - No = 0.0, - So = 0.0 - }; - SqlOperator.PostReading(newReading); - var command = "SELECT * FROM Readings " + - "WHERE TimeStamp IN(SELECT MAX(TimeStamp) FROM Readings)"; - var latestReading = SqlOperator.GetReadings(command)[0]; - var command2 = $"SELECT * FROM Readings WHERE Id={latestReading.Id}"; - var reading = SqlOperator.GetReadings(command2)[0]; - Assert.AreEqual(newReading.TimeStamp, reading.TimeStamp); - } - - [TestMethod()] - 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); - } - - [TestMethod()] - 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); - } - } -}
\ No newline at end of file |