def test_create_table(self):
"""Query that modifies database gives 403 status code."""
self.dt.execute('CREATE TABLE important(foo);')
observedCode, observedData = execute_query('DROP TABLE important;', DB)
self.assertEqual(observedData, u'Database error: not authorized')
self.assertEqual(observedCode, 403)
def test_create_table(self):
"""Query that modifies database gives 403 status code."""
self.dt.execute('CREATE TABLE important(foo);')
observedCode, observedData = execute_query('DROP TABLE important;', DB)
self.assertEqual(observedData, u'Database error: not authorized')
self.assertEqual(observedCode, 403)
def test_valid_query(self):
"""Valid query works."""
self.dt.insert({u'name': u'Aidan', u'favorite_color': u'Green'}, 'person')
observedCode, observedData = execute_query('SELECT favorite_color FROM person', DB)
self.assertListEqual(observedData, [{u"favorite_color": u"Green"}])
self.assertEqual(observedCode, 200)
def test_invalid_query(self):
"""SQL Syntax error gives 4xx status code."""
observedCode, observedData = execute_query('chainsaw', DB)
self.assertEqual(observedData,
u'SQL error: near "chainsaw": syntax error')
self.assertEqual(observedCode, 400)
def test_special_type_date(self):
"""Adapters and converters should not be enabled."""
self.dt.execute('CREATE TABLE pork_sales (week date);')
self.dt.execute("INSERT INTO pork_sales VALUES ('2012-10-08')")
observedCode, observedData = execute_query('SELECT week FROM pork_sales', DB)
self.assertListEqual(observedData, [{u"week": u"2012-10-08"}])
self.assertEqual(observedCode, 200)
def test_query_nonexistant(self):
"""No files are created merely by trying to execute a query on a non-existent database."""
observedCode, observedData = execute_query({'q': u'SELECT 3 FROM sqlite_master'}, DB)
# File is not created
self.assertFalse(os.path.isfile(DB))
# All isn't well.
self.assertTrue(observedCode >= 400)
def test_special_type_date(self):
"""Adapters and converters should not be enabled."""
self.dt.execute('CREATE TABLE pork_sales (week date);')
self.dt.execute("INSERT INTO pork_sales VALUES ('2012-10-08')")
observedCode, observedData = execute_query(
'SELECT week FROM pork_sales', DB)
self.assertListEqual(observedData, [{u"week": u"2012-10-08"}])
self.assertEqual(observedCode, 200)
def test_query_nonexistant(self):
"""No files are created merely by trying to execute a query on a non-existent database."""
observedCode, observedData = execute_query(
{'q': u'SELECT 3 FROM sqlite_master'}, DB)
# File is not created
self.assertFalse(os.path.isfile(DB))
# All isn't well.
self.assertTrue(observedCode >= 400)
def test_valid_query(self):
"""Valid query works."""
self.dt.insert({
u'name': u'Aidan',
u'favorite_color': u'Green'
}, 'person')
observedCode, observedData = execute_query(
'SELECT favorite_color FROM person', DB)
self.assertListEqual(observedData, [{u"favorite_color": u"Green"}])
self.assertEqual(observedCode, 200)
def test_null_query(self):
"""Empty query."""
observedCode, observedData = execute_query('', DB)
self.assertEqual(observedData, None)
self.assertEqual(observedCode, 200)
def test_invalid_query(self):
"""SQL Syntax error gives 4xx status code."""
observedCode, observedData = execute_query('chainsaw', DB)
self.assertEqual(observedData, u'SQL error: near "chainsaw": syntax error')
self.assertEqual(observedCode, 400)
def test_null_query(self):
"""Empty query."""
observedCode, observedData = execute_query('', DB)
self.assertEqual(observedData, None)
self.assertEqual(observedCode, 200)
