tri.query 2.2.0

tri.query is a library to define queries

tri.query

tri.query makes it easy to implement searching and filtering in your Django app.

Major features:

• Generate simple filtering GUIs easily while at the same time:

• Supply your views with advanced query languages

• Query language can be used stand alone without the GUI parts

• Highly customizable GUI based on tri.form

Example

Simple view that allows the user to search for a car by choosing the make from a drop down, and search for specific model in the advanced mode:

class CarQuery(Query):
    make = Variable.choice(
        choices=['Toyota', 'Volvo', 'Ford'],
        form_field__show=True)  # Display this field in the simple style GUI
    model = Variable.text()

def cars(request):
    query = CarQuery()
    cars_query_set = query.request_to_q(request)
    form = query.form()
    return render(
        template_name='cars.html',
        context_instance=RequestContext(request, {'query_form': form, 'cars': cars_query_set}))

<!-- cars.html -->
{% include "tri_query/form.html" with form=query_form %}

<ul>
    {% for car in cars %}
        <li>{{ car }}</li>
    {% endfor %}
</ul>

After switching to the advanced mode:

Programmatically call the search API:

query = CarQuery()
cars_query_set = query.parse('make=Toyota and (make=1991 or make=1992)')

Running tests

You need tox installed then just make test.

License

BSD

Documentation

http://triquery.readthedocs.org

Changelog

2.2.0 (2016-08-16)

• Variable.choice_queryset handles the string “null” the same way as everything else

• Queries that have multi-select inputs now work

2.1.1 (2016-08-08)

• Report invalid operators for choice queryset as errors instead of crashing

2.1.0 (2016-07-12)

• Check for dates that are out of range

2.0.0 (2016-06-02)

• Cache form on Query

• Render global form errors

• Query.form() no longer takes a request parameter, since it was redundant anyway. This is a potential breaking change.

• Correctly dispatch attr to underlying tri.form

• Support for ajax backend. New parameter to Query: endpoint_dispatch_prefix.

1.11.0 (2016-04-25)

• Minor bugfix for variable-from-model handling of auto fields

1.10.0 (2016-04-21)

• Fix over-eager assert not allowing variable-less Query objects.

1.9.0 (2016-04-21)

• Enable mixing variable definitions in both declared variables and class meta.

• Added after attribute on Variable to enable custom variable ordering (See tri.declarative.sort_after())

• Added Variable.from_model, Query.from_model

1.8.0 (2016-04-19)

• Added robustness in when arguments are passed as dict(foo=dict(bar=17)) or foo__bar=17

1.7.0 (2016-04-08)

• Add python 3 support

1.6.0 (2016-03-03)

• Variable.float shortcut added

• Add support for Django 1.7 and 1.8.