def test_prints_query_when_cast_to_string(self): query = YQLQuery("SELECT * from foo") self.assertEqual(str(query), "SELECT * from foo")
def test_placeholder_regex_three(self): query = YQLQuery("SELECT * from foo where email=@foo and test=@bar'") placeholders = query.get_placeholder_keys() self.assertEqual(placeholders, ['foo', 'bar'])
def test_placeholder_regex_five(self): query = YQLQuery("""SELECT * from foo where foo='bar' LIMIT @foo""") placeholders = query.get_placeholder_keys() self.assertEqual(placeholders, ['foo'])
def test_requires_substitutions(self): query = YQLQuery("SELECT * from foo where dog=@dog") query.validate()
def test_placeholder_regex_one(self): query = YQLQuery("SELECT * from foo where email='*****@*****.**'") placeholders = query.get_placeholder_keys() self.assertEqual(placeholders, [])
def test_incorrect_type_raises_valueerror(self): query = YQLQuery("SELECT * from foo where dog=@test") params = ('fail') query.validate(params)
def test_unecessary_args_raises_valueerror(self): query = YQLQuery("SELECT * from foo where dog='test'") params = {'test': 'fail'} query.validate(params)
def test_params_raises_when_not_dict(self): query = YQLQuery("SELECT * from foo where dog=@dog") params = ['test'] query.validate(params)
def test_incorrect_args_raises_valueerror(self): query = YQLQuery("SELECT * from foo where dog=@dog") params = {'test': 'fail'} query.validate(params)
def test_empty_args_raises_valueerror(self): query = YQLQuery("SELECT * from foo where dog=@dog") params = {} query.validate(params)