public void TestCreateReturn() { var equipment = new Equipment("Kaffemaskine"); var mock = new Mock<DatabaseConnection>(); var crud = new SqliteEquipmentCrud(mock.Object); mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Returns(() => new object[][] { new object[] { 1 } }); crud.Create(equipment); Assert.AreEqual(1, equipment.Id); }
public void TestDelete() { var sql = ""; var equipment = new Equipment("Kaffemaskine") { Id = 1 }; var mock = new Mock<DatabaseConnection>(); var crud = new SqliteEquipmentCrud(mock.Object); mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s); crud.Delete(equipment); Assert.AreEqual("DELETE FROM Equipment WHERE Id = 1;", sql); }
public void TestCreateToSql() { var sql = ""; var equipment = new Equipment("Kaffemaskine"); var mock = new Mock<DatabaseConnection>(); var crud = new SqliteEquipmentCrud(mock.Object); mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s).Returns(() => new object[][] { new object[] { 1 } }); crud.Create(equipment); Assert.AreEqual("INSERT INTO Equipment (Name) VALUES ('Kaffemaskine'); SELECT MAX(Id) FROM Equipment;", sql); }
public void TestUpdate() { var sql = ""; var equipment = new Equipment("F16 Fighting Falcon"); var mock = new Mock<DatabaseConnection>(); var crud = new SqliteEquipmentCrud(mock.Object); mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s); crud.Update(equipment); Assert.AreEqual("UPDATE Equipment SET Name = 'F16 Fighting Falcon';", sql); }