This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

Export CSV reports of database views.

Project Description

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.
Release History

Release History

This version
History Node

0.7.1

History Node

0.6.1

History Node

0.6.0

History Node

0.5.5

History Node

0.5.4

History Node

0.5.3

History Node

0.5.2

Download Files

Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
django_view_export-0.7.1-py3-none-any.whl (7.7 kB) Copy SHA256 Checksum SHA256 py3 Wheel Feb 7, 2017
django-view-export-0.7.1.tar.gz (4.6 kB) Copy SHA256 Checksum SHA256 Source Feb 7, 2017

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting