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