From 08e7a82cc7b237e550c0236bebd4f41c3c3f4acf Mon Sep 17 00:00:00 2001 From: marcinzelent Date: Fri, 16 Mar 2018 21:40:28 +0100 Subject: Moved API to separate folder. --- PollutometerWebApi.Tests/SqlOperatorTests.cs | 68 ---------------------------- 1 file changed, 68 deletions(-) delete mode 100644 PollutometerWebApi.Tests/SqlOperatorTests.cs (limited to 'PollutometerWebApi.Tests/SqlOperatorTests.cs') 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 -- cgit v1.2.3