public void TestReadRoomToSql() { var sql = ""; var data = new RoomData(); 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, "Kaffemaskiner" } }); crud.Read(data.Rooms.First()); Assert.AreEqual("SELECT Equipment.Id, Equipment.Name FROM Equipment JOIN Room ON Equipment.Id = Room.EquipmentId WHERE Room.Id = 1;", sql); }
public void TestReadRoom() { var data = new RoomData(); 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, "Kaffemaskiner" } }); var equipments = crud.Read(data.Rooms.First()); Assert.AreEqual(1, equipments.First().Id); Assert.AreEqual("Kaffemaskiner", equipments.First().Name); }