def test_subset_data_exist(self):
self.assertEqual(dao_util.subset_data_exist(self.table, "1=1"), True)
self.assertEqual(dao_util.subset_data_exist(self.table, "1=2"), False)
self.assertEqual(
dao_util.subset_data_exist(self.table, "TextField='a'"), True)
self.assertEqual(
dao_util.subset_data_exist(self.table, "TextField='e'"), False)
def test_delete_identical_only_keep_min_oid(self):
import datetime
import arcpy
arcpy.env.overwriteOutput = True
arcpy.CopyRows_management(self.table, self.temp_table)
self.assertEqual(int(arcpy.GetCount_management(self.table).getOutput(0)), 4)
with arcpy.da.InsertCursor(self.temp_table, ["TextField", "NumberField", "DateField"]) as iCursor:
iCursor.insertRow(("d", 999, datetime.datetime(2010, 10, 4)))
self.assertEqual(int(arcpy.GetCount_management(self.temp_table).getOutput(0)), 5)
dao_util.delete_identical_only_keep_min_oid(self.temp_table, "TextField")
self.assertEqual(int(arcpy.GetCount_management(self.temp_table).getOutput(0)), 4)
self.assertFalse(dao_util.subset_data_exist(self.temp_table, "NumberField=999"))
def test_delete_subset_data(self):
import datetime
import arcpy
arcpy.env.overwriteOutput = True
arcpy.CopyRows_management(self.table, self.temp_table)
self.assertEqual(
int(arcpy.GetCount_management(self.table).getOutput(0)), 4)
with arcpy.da.InsertCursor(
self.temp_table,
["TextField", "NumberField", "DateField"]) as iCursor:
iCursor.insertRow(("x", 999, datetime.datetime(2010, 10, 4)))
self.assertEqual(
int(arcpy.GetCount_management(self.temp_table).getOutput(0)), 5)
dao_util.delete_subset_data(self.temp_table, "TextField='x'")
self.assertEqual(
int(arcpy.GetCount_management(self.temp_table).getOutput(0)), 4)
self.assertFalse(
dao_util.subset_data_exist(self.temp_table, "TextField='x'"))
def test_subset_data_exist(self):
self.assertEqual(dao_util.subset_data_exist(self.table, "1=1"), True)
self.assertEqual(dao_util.subset_data_exist(self.table, "1=2"), False)
self.assertEqual(dao_util.subset_data_exist(self.table, "TextField='a'"), True)
self.assertEqual(dao_util.subset_data_exist(self.table, "TextField='e'"), False)
