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)