def test_create_script_one_table(self):
_main_for_create_doloop_table(['foo_loop'])
output = sys.stdout.getvalue()
self.assertIn('`foo_loop`', output)
self.assertIn('INT', output)
self.assertIn('InnoDB', output)
self.assertEqual(output, doloop.sql_for_create('foo_loop') + ';\n\n')
def test_create_script_one_table(self):
_main_for_create_doloop_table(['foo_loop'])
output = sys.stdout.getvalue()
self.assertIn('`foo_loop`', output)
self.assertIn('INT', output)
self.assertIn('InnoDB', output)
self.assertEqual(output,
doloop.sql_for_create('foo_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')
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')
