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.
WARNING: Be sure to retain the “staff only” restriction in place on views.csv_view_export to reduce the risk of SQL injection attack.
Include the gifts URLconf in your project urls.py like this:
Create an SQL view in your database:
=> CREATE VIEW v_staff 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.
Start the development server and visit http://127.0.0.1:8000/reports/staff/ or http://127.0.0.1:8000/reports/v_staff/ 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.
- Update documentation.
- Rename PyPI package to django-view-export.
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size django_view_export-0.5.3-py2-none-any.whl (5.9 kB)||File type Wheel||Python version py2||Upload date||Hashes View|
|Filename, size django-view-export-0.5.3.tar.gz (3.6 kB)||File type Source||Python version None||Upload date||Hashes View|
Hashes for django_view_export-0.5.3-py2-none-any.whl