def test_validate_wrong_problem(self):
""" Test to validate with DES a wrong SelectProblem """
problem = SelectProblem(create_sql='CREATE TABLE t(age int)',
insert_sql='',
solution='SELECT * FROM table')
problem2 = SelectProblem(create_sql='CREATE TABLE t(age int)',
insert_sql='',
solution='SELECT * FRO t')
with self.assertRaises(ValidationError) as ctx:
problem.validate_des()
self.assertIn("Unknown table or view 'table'", ctx.exception.message)
with self.assertRaises(ValidationError) as ctx:
problem2.validate_des()
self.assertIn("Expected FROM clause", ctx.exception.message)
def test_validate_correct_problem(self):
""" Test to validate with DES a correct SelectProblem """
problem = SelectProblem(create_sql='CREATE TABLE t(age int)',
insert_sql='',
solution='SELECT * FROM t')
self.assertIsNone(problem.validate_des())