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]); }
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]); }
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]); }
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]); }