autocomplete_where.py

where = {}
 
where['adjective'] = 'Lucid' 
# where adjective = 'Lucid'
 
where['adjective'] = ('Warty', 'Dapper')
# where adjective in ('Warty', 'Dapper')
 
# For sequence values, the rules are: a tuple translates 
# to the 'in' operator (as above), a list to a PG array 
# and a set to a conjunction of predicates (see below)
 
where[('version::real', '<=')] = 10.04
# where version::real <= 10.04
 
where[('adjective', 'ilike')] = {'%lucid%', '%lynx%'} 
# where adjective ilike '%lucid%' and adjective ilike '%lynx%'