def test_create_script_multiple_tables(self): _main_for_create_doloop_table(['foo_loop', 'bar_loop']) output = sys.stdout.getvalue() self.assertIn('`foo_loop`', output) self.assertIn('`bar_loop`', output) self.assertIn('INT', output) self.assertIn('InnoDB', output) self.assertEqual(output, doloop.sql_for_create('foo_loop') + ';\n\n' + doloop.sql_for_create('bar_loop') + ';\n\n')
def test_create_script_multiple_tables(self): _main_for_create_doloop_table(['foo_loop', 'bar_loop']) output = sys.stdout.getvalue() self.assertIn('`foo_loop`', output) self.assertIn('`bar_loop`', output) self.assertIn('INT', output) self.assertIn('InnoDB', output) self.assertEqual( output, doloop.sql_for_create('foo_loop') + ';\n\n' + doloop.sql_for_create('bar_loop') + ';\n\n')
def test_create_script_engine(self): for opt in ('-e', '--engine'): sys.stdout = StringIO() # use a fresh buffer _main_for_create_doloop_table(['foo_loop', opt, 'MyISAM']) output = sys.stdout.getvalue() self.assertIn('`foo_loop`', output) self.assertIn('INT', output) self.assertIn('MyISAM', output) self.assertEqual( output, doloop.sql_for_create('foo_loop', engine='MyISAM') + ';\n\n')
def test_create_script_id_type(self): for opt in ('-i', '--id-type'): sys.stdout = StringIO() # use a fresh buffer _main_for_create_doloop_table(['foo_loop', opt, 'BIT(8)']) output = sys.stdout.getvalue() self.assertIn('`foo_loop`', output) self.assertIn('BIT(8)', output) self.assertIn('InnoDB', output) self.assertEqual( output, doloop.sql_for_create('foo_loop', id_type='BIT(8)') + ';\n\n')