コード例 #1
0
        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);
        }
コード例 #2
0
        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);
        }
コード例 #3
0
        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);
        }
コード例 #4
0
        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);
        }