public void CanGetRowsNotInUUIDList()
{
IFeatureWorkspace ws = OpenTestWorkspace();
ITable tbl = ws.OpenTable("TOPGIS_TLM.TLM_STRASSE");
var nRows = 0;
IQueryFilter filter = new QueryFilterClass();
foreach (
// ReSharper disable once UnusedVariable
IRow row in
GdbQueryUtils.GetRowsNotInList(tbl, filter, true, "UUID",
new[]
{
"{8C5517C9-B19F-4CC1-A6A1-D3DD317BCDD1}"
}))
{
nRows++;
}
filter.WhereClause = "UUID not in ('{8C5517C9-B19F-4CC1-A6A1-D3DD317BCDD1}')";
int n = tbl.RowCount(filter);
Assert.AreEqual(n, nRows, "");
}
public void CanGetRowsNotInStringList()
{
IFeatureWorkspace ws = OpenTestWorkspace();
ITable tbl = ws.OpenTable("TOPGIS_TLM.TLM_STRASSE");
var nRows = 0;
IQueryFilter filter = new QueryFilterClass();
foreach (
// ReSharper disable once UnusedVariable
IRow row in
GdbQueryUtils.GetRowsNotInList(tbl, filter, true, "OPERATEUR",
new[] { "STR_Imp" }))
{
nRows++;
}
filter.WhereClause = "OPERATEUR not in ('STR_Imp')";
int n = tbl.RowCount(filter);
Assert.AreEqual(n, nRows, "");
}
public void CanGetRowsNotInIntList()
{
IFeatureWorkspace ws = OpenTestWorkspace();
ITable tbl = ws.OpenTable("TOPGIS_TLM.TLM_STRASSE");
var nRows = 0;
IQueryFilter filter = new QueryFilterClass();
foreach (
// ReSharper disable once UnusedVariable
IRow row in
GdbQueryUtils.GetRowsNotInList(tbl, filter, true, "OBJEKTART",
new object[] { 1, 2, 3 }))
{
nRows++;
}
filter.WhereClause = "OBJEKTART not in (1, 2, 3)";
int n = tbl.RowCount(filter);
Assert.AreEqual(n, nRows, "");
}
