def test_infile(self):
"""Tests reading statements from file"""
self.assertEqual(
0,
executer.main([
'dbnav.sqlite/user',
SELECT_1
])
)
def test_writer(self):
"""Tests the writer"""
import sys
sys.argv = ['']
self.assertRaises(
SystemExit,
mute_stderr(executer.main)
)
self.assertEqual(
0,
executer.main(['dbnav.sqlite/user?id=1', '-s', 'select 1'])
)
self.assertEqual(
-1,
executer.main(
['dbnav.sqlite/user?id=1', '-s', 'select * from unknown'])
)
def test_empty_statements(self):
"""Tests empty statements"""
self.assertEqual(
0,
executer.main([
'dbnav.sqlite/user',
'-s',
' '
])
)
self.assertEqual(
0,
executer.main([
'dbnav.sqlite/user',
'-s',
'',
'-n'
])
)
def test_isolation(self):
"""Tests the --isolate-statements option"""
self.assertEqual(
0,
executer.main([
'dbnav.sqlite/user',
'--isolate-statements',
'--mute-errors',
'-s',
'select blub; select 1;'
])
)
self.assertEqual(
0,
mute_stderr(executer.main)([
'dbnav.sqlite/user',
'--isolate-statements',
'-s',
'select blub; select 1;'
])
)
