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