def test_complex_query(self):
query = ProjectsNameFilter.make_query(
Project, '"test" or ("lit_%" and !"lit_unknown")')
self.assertEqual(
'SELECT id FROM project_project WHERE name LIKE %s or (name LIKE %s and name NOT LIKE %s);',
query.query.sql)
self.assertEqual(['test', 'lit_%', 'lit_unknown'], query.query.params)
def test_simple_query(self):
query = ProjectsNameFilter.make_query(Project, 'lit_%')
self.assertEqual('SELECT id FROM project_project WHERE name LIKE %s;',
query.query.sql)
self.assertEqual(['lit_%'], query.query.params)