def test_table_options(self):
"""Test: src and dest table have different options"""
self.src.tables['address'].options['engine'].value = "MyISAM"
p,r = syncdb.sync_table_options(self.src.tables['address'], self.dest.tables['address'], sync_auto_inc=False, sync_comments=False)
self.assertEqual(p, "ENGINE=MyISAM")
self.assertEqual(r, "ENGINE=InnoDB")
def test_table_options_with_comment(self):
"""Test: src and dest table have different options (include table COMMENT)"""
self.src.tables['address'].options['engine'].value = "MyISAM"
self.src.tables['address'].options['comment'].value = "hello world"
p,r = syncdb.sync_table_options(self.src.tables['address'], self.dest.tables['address'], sync_auto_inc=False, sync_comments=True)
self.assertEqual(p, "ENGINE=MyISAM COMMENT='hello world'")
self.assertEqual(r, "ENGINE=InnoDB COMMENT=''" )
def test_table_options_with_auto_inc(self):
"""Test: src and dest table have different options (include AUTO_INCREMENT value)"""
self.src.tables['address'].options['engine'].value = "MyISAM"
self.src.tables['address'].options['auto_increment'].value = 11
p,r = syncdb.sync_table_options(self.src.tables['address'], self.dest.tables['address'], sync_auto_inc=True, sync_comments=False)
self.assertEqual(p, "ENGINE=MyISAM AUTO_INCREMENT=11")
self.assertEqual(r, "ENGINE=InnoDB AUTO_INCREMENT=1")
def test_table_options(self):
"""Test: src and dest table have different options"""
self.src.tables['address'].options['engine'].value = "MyISAM"
p, r = syncdb.sync_table_options(self.src.tables['address'],
self.dest.tables['address'],
sync_auto_inc=False,
sync_comments=False)
self.assertEqual(p, "ENGINE=MyISAM")
self.assertEqual(r, "ENGINE=InnoDB")
def test_table_options_with_auto_inc(self):
"""Test: src and dest table have different options (include AUTO_INCREMENT value)"""
self.src.tables['address'].options['engine'].value = "MyISAM"
self.src.tables['address'].options['auto_increment'].value = 11
p, r = syncdb.sync_table_options(self.src.tables['address'],
self.dest.tables['address'],
sync_auto_inc=True,
sync_comments=False)
self.assertEqual(p, "ENGINE=MyISAM AUTO_INCREMENT=11")
self.assertEqual(r, "ENGINE=InnoDB AUTO_INCREMENT=1")
def test_table_options_with_comment(self):
"""Test: src and dest table have different options (include table COMMENT)"""
self.src.tables['address'].options['engine'].value = "MyISAM"
self.src.tables['address'].options['comment'].value = "hello world"
p, r = syncdb.sync_table_options(self.src.tables['address'],
self.dest.tables['address'],
sync_auto_inc=False,
sync_comments=True)
self.assertEqual(p, "ENGINE=MyISAM COMMENT='hello world'")
self.assertEqual(r, "ENGINE=InnoDB COMMENT=''")