django-view-export 0.7.1

Export CSV reports of database views.

Generate CSV reports by simply creating SQL views.

Authenticated staff members can then directly download these reports as CSV. It’s a nice agile way to deal with the changing requirements for reports.

Quick start

1. Include the URLconf in your project urls.py like this:

   url(r'^reports/', include('view_export.urls')),

2. Create an SQL view in your database:

   => CREATE VIEW v_staff_names AS (
   ->      SELECT first_name, last_name FROM auth_user
   ->      WHERE is_staff = TRUE);

   You’ll probably want to record this SQL in a file such as reports.sql or even better, add it to a Django migration.

3. Start the development server and visit http://127.0.0.1:8000/reports/view-export/staff_names/ or http://127.0.0.1:8000/reports/view-export/v_staff_names/ to download the SQL view named v_staff as a CSV file.

No settings are required by default and there’s no need to add the package to Django’s INSTALLED_APPS. Staff login access is required, so you may wish to set the LOGIN_URL setting to /admin/login/ initially.

Release History

0.7.1 (2017-02-07)

• remove patterns URLconf function per deprecation in Django 1.8

• fix example URLs in README

• provide example view with underscores

• document staff-only access and LOGIN_URL setting

0.6.2 (2015-09-04)

Bugfixes

• Fix installation error due to HISTORY.rst not being present in source.

0.6.1 (2015-08-25)

Improvements

• Switch to Python 3 only, factor out CSV and report filename generation.

0.5.5 (2015-08-25)

Bugfixes

• Fix installation error due to HISTORY.rst not being present in source.

0.5.4 (2015-08-09)

Bugfixes

• Fix SQL injection vulnerability relating to “view” argument.

0.5.3 (2015-08-05)

Improvements

• Update documentation.

• Rename PyPI package to django-view-export.