def test_sync_dropped_column(self): """Test: dest table has columns not in src table (ignore Column COMMENT)""" saved = self.src.columns['staff_id'] pos = self.src.columns.index('staff_id') del self.src.columns['staff_id'] for i, (p,r) in enumerate(syncdb.sync_dropped_columns(self.src.columns, self.dest.columns, sync_comments=False)): self.assertEqual(p, "DROP COLUMN `staff_id`") self.assertEqual(r, "ADD COLUMN `staff_id` TINYINT(3) UNSIGNED NOT NULL AFTER `return_date`") self.assertEqual(i, 0)
def test_sync_dropped_column_with_comment(self): """Test: dest table has columns not in src table (include Column COMMENT)""" saved = self.src.columns['staff_id'] pos = self.src.columns.index('staff_id') del self.src.columns['staff_id'] self.dest.columns['staff_id'].comment = "hello world" for i, (p,r) in enumerate(syncdb.sync_dropped_columns(self.src.columns, self.dest.columns, sync_comments=True)): self.assertEqual(p, "DROP COLUMN `staff_id`") self.assertEqual(r, "ADD COLUMN `staff_id` TINYINT(3) UNSIGNED NOT NULL COMMENT 'hello world' AFTER `return_date`") self.assertEqual(i, 0)
def test_sync_dropped_column(self): """Test: dest table has columns not in src table (ignore Column COMMENT)""" saved = self.src.columns['staff_id'] pos = self.src.columns.index('staff_id') del self.src.columns['staff_id'] for i, (p, r) in enumerate( syncdb.sync_dropped_columns(self.src.columns, self.dest.columns, sync_comments=False)): self.assertEqual(p, "DROP COLUMN `staff_id`") self.assertEqual( r, "ADD COLUMN `staff_id` TINYINT(3) UNSIGNED NOT NULL AFTER `return_date`" ) self.assertEqual(i, 0)
def test_sync_dropped_column_with_comment(self): """Test: dest table has columns not in src table (include Column COMMENT)""" saved = self.src.columns['staff_id'] pos = self.src.columns.index('staff_id') del self.src.columns['staff_id'] self.dest.columns['staff_id'].comment = "hello world" for i, (p, r) in enumerate( syncdb.sync_dropped_columns(self.src.columns, self.dest.columns, sync_comments=True)): self.assertEqual(p, "DROP COLUMN `staff_id`") self.assertEqual( r, "ADD COLUMN `staff_id` TINYINT(3) UNSIGNED NOT NULL COMMENT 'hello world' AFTER `return_date`" ) self.assertEqual(i, 0)