Azavea.Open.DAO.Tests.SqlUtilTests.TestMakeWhereClause C# (CSharp) Method

        public void TestMakeWhereClause()
        {
            string where = SqlUtilities.MakeWhereClause(null, null);
            Assert.AreEqual("", where, "Should produce an empty string when given no values.");

            Dictionary<string, object> wheres = new Dictionary<string, object>();
            wheres["blah"] = "five";
            List<object> parms = new List<object>();
            where = SqlUtilities.MakeWhereClause(wheres, parms);
            Assert.AreEqual(" WHERE blah = ?", where,
                "Didn't assemble delete statement with params.");
            Assert.AreEqual(1, parms.Count, "Wrong number of sql parameters generated.");
            Assert.AreEqual("five", parms[0], "Wrong sql parameter value generated.");

            wheres["blah"] = null;
            parms = new List<object>();
            where = SqlUtilities.MakeWhereClause(wheres, parms);
            Assert.AreEqual(" WHERE blah IS NULL", where,
                "Didn't assemble delete statement with params.");
            Assert.AreEqual(0, parms.Count, "Wrong number of sql parameters generated for null.");
        }