コード例 #1
0
        public void AddFilterStatement_ThereAreIdAndParentFieldNamesNoIds()
        {
            var actual = FingerprintRepository.AddFilterStatement("ID", "PARENT_ID", new FingerprintEntityTypeSettings(), new[] { "1:{0}", "2:{0}" }).ToArray();

            Assert.AreEqual(2, actual.Length);
            Assert.AreEqual("1: ", actual[0]);
            Assert.AreEqual("2: ", actual[1]);
        }
コード例 #2
0
        public void AddFilterStatement_ThereAreOnlyParentIdFieldNameOnlyExceptedParentIds()
        {
            var actual = FingerprintRepository.AddFilterStatement("ID", "PARENT_ID", new FingerprintEntityTypeSettings
            {
                ExceptedParentIDs = new[] { 30, 40 }
            }, new[] { "1:{0}", "2:{0}" }).ToArray();

            Assert.AreEqual(2, actual.Length);
            Assert.AreEqual("1: WHERE PARENT_ID NOT IN (30,40) ", actual[0]);
            Assert.AreEqual("2: WHERE PARENT_ID NOT IN (30,40) ", actual[1]);
        }
コード例 #3
0
        public void AddFilterStatement_ThereAreOnlyIdFieldNamesIncludedAndExceptedIdsAndParentIdsAddWereIsFalse()
        {
            var actual = FingerprintRepository.AddFilterStatement("ID", null, new FingerprintEntityTypeSettings
            {
                IncludedIDs       = new[] { 1, 2 },
                ExceptedIDs       = new[] { 10, 20 },
                IncludedParentIDs = new[] { 3, 4 },
                ExceptedParentIDs = new[] { 30, 40 }
            }, new[] { "1:{0}", "2:{0}" }, false).ToArray();

            Assert.AreEqual(2, actual.Length);
            Assert.AreEqual("1: AND ID IN (1,2) ", actual[0]);
            Assert.AreEqual("2: AND ID IN (1,2) ", actual[1]);
        }
コード例 #4
0
        public void AddFilterStatement_ThereAreIdAndParentFieldNamesIncludedAndExceptedIdsAndParentIds()
        {
            var actual = FingerprintRepository.AddFilterStatement("ID", "PARENT_ID", new FingerprintEntityTypeSettings
            {
                IncludedIDs       = new[] { 1, 2 },
                ExceptedIDs       = new[] { 10, 20 },
                IncludedParentIDs = new[] { 3, 4 },
                ExceptedParentIDs = new[] { 30, 40 }
            }, new[] { "1:{0}", "2:{0}" }).ToArray();

            Assert.AreEqual(2, actual.Length);
            Assert.AreEqual("1: WHERE ID IN (1,2) AND PARENT_ID IN (3,4) ", actual[0]);
            Assert.AreEqual("2: WHERE ID IN (1,2) AND PARENT_ID IN (3,4) ", actual[1]);
        }