I need a nicer abstraction around the concept of filters. It needs to be able to:

convert querystring parameters into filters
convert filters into a querystring
iterate through currently applied filters
convert selected filters into a human description (e.g. for a title)
expand filters that involve a foreign key
add filters
remove filters
define different types of filters

It should replace my current build_where_clauses implementation, in particular this bit:

Lines 38 to 56 in a5881e1

    
           template = { 
        
               'exact': '"{}" = :{}', 
        
               'contains': '"{}" like :{}', 
        
               'endswith': '"{}" like :{}', 
        
               'startswith': '"{}" like :{}', 
        
               'gt': '"{}" > :{}', 
        
               'gte': '"{}" >= :{}', 
        
               'lt': '"{}" < :{}', 
        
               'lte': '"{}" <= :{}', 
        
               'glob': '"{}" glob :{}', 
        
               'like': '"{}" like :{}', 
        
               'isnull': '"{}" is null', 
        
           }[lookup] 
        
           numeric_operators = {'gt', 'gte', 'lt', 'lte'} 
        
           value_convert = { 
        
               'contains': lambda s: '%{}%'.format(s), 
        
               'endswith': lambda s: '%{}'.format(s), 
        
               'startswith': lambda s: '{}%'.format(s), 
        
           }.get(lookup, lambda s: s)

	template = {
	'exact': '"{}" = :{}',
	'contains': '"{}" like :{}',
	'endswith': '"{}" like :{}',
	'startswith': '"{}" like :{}',
	'gt': '"{}" > :{}',
	'gte': '"{}" >= :{}',
	'lt': '"{}" < :{}',
	'lte': '"{}" <= :{}',
	'glob': '"{}" glob :{}',
	'like': '"{}" like :{}',
	'isnull': '"{}" is null',
	}[lookup]
	numeric_operators = {'gt', 'gte', 'lt', 'lte'}
	value_convert = {
	'contains': lambda s: '%{}%'.format(s),
	'endswith': lambda s: '%{}'.format(s),
	'startswith': lambda s: '{}%'.format(s),
	}.get(lookup, lambda s: s)

Uh oh!

Filter UI on table page #86

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions