08-12 01:37 阅读 78

关注

djangoqbe

versae: django-qbe @ GitHub

django-qbe
by versae

Django implementantion for Query By Example (QBE)

Admin tool in order to get custom reports. The objective of django-qbe is provide a assited and interactive way of making complex queries with no technical knowledge (or minimal) to get custom reports from the objects of Django models. Based on QBE proposal from IBM®, django-qbe is intended to remove the limitations of Django QuerySets objects and to use the whole expresive power of the subjacent SQL.

Features

• Multi-database support.

• View and autodiscover relations among the models in a visual way (ForeignKey fields are green and ManyToMany ones are red).

• Tabular creation of queries with fields to show, criterias, lookups and order (only AND conditions by now).

• Auto adition of right fields when ForeignKey or ManyToMany fields are selected.

• No models in the project, so you can add django-qbe whenever you want with no syncdb.

• Pagination of results.

• Bookmarklet to save and share the queries.

• Export results to .csv, .odt and .xls, but it's extensible by the user.

• Access restricted to users through a customizable function.

• Links to admin views (if available) in the results objects.