Skip to main content

CSV Tools for Django REST Framework

Project description

build status

CSV Tools for Django REST Framework

Installation

$ pip install djangorestframework-csv

Compatibility

  • For compatibility with Python 3 and Django < 3.2, use djangorestframework-csv<3.0.1

  • For compatibility with Python 2.7, use djangorestframework-csv<3

Usage

views.py

from rest_framework.views import APIView
from rest_framework.settings import api_settings
from rest_framework_csv import renderers as r

class MyView (APIView):
    renderer_classes = (r.CSVRenderer, ) + tuple(api_settings.DEFAULT_RENDERER_CLASSES)
    ...

Alternatively, to set CSV as a default rendered format, add the following to the settings.py file:

REST_FRAMEWORK = {
    # specifying the renderers
    'DEFAULT_RENDERER_CLASSES': (
        'rest_framework_csv.renderers.CSVRenderer',
    ),
}

Ordered Fields

By default, a CSVRenderer will output fields in sorted order. To specify an alternative field ordering you can override the header attribute. There are two ways to do this:

  1. Create a new renderer class and override the header attribute directly:

    class MyUserRenderer (CSVRenderer):
        header = ['first', 'last', 'email']
    
    @api_view(['GET'])
    @renderer_classes((MyUserRenderer,))
    def my_view(request):
        users = User.objects.filter(is_active=True)
        content = [{'first': user.first_name,
                    'last': user.last_name,
                    'email': user.email}
                   for user in users]
        return Response(content)
  2. Use the renderer_context to override the field ordering on the fly:

    class MyView (APIView):
        renderer_classes = [CSVRenderer]
    
        def get_renderer_context(self):
            context = super().get_renderer_context()
            context['header'] = (
                self.request.GET['fields'].split(',')
                if 'fields' in self.request.GET else None)
            return context
    
        ...

Labeled Fields

Custom labels can be applied to the CSVRenderer using the labels dict attribute where each key corresponds to the header and the value corresponds to the custom label for that header.

1) Create a new renderer class and override the header and labels attribute directly:

class MyBazRenderer (CSVRenderer):
    header = ['foo.bar']
    labels = {
        'foo.bar': 'baz'
    }

Pagination

Using the renderer with paginated data is also possible with the new PaginatedCSVRenderer class and should be used with views that paginate data

For more information about using renderers with Django REST Framework, see the API Guide or the Tutorial.

Running the tests

To run the tests against the current environment:

$ ./manage.py test

Changelog

3.0.2

  • Fix the project long description metadata

3.0.1

  • Remove Django tests for all but the currently supported Django versions (3.2, 4.1, 4.2). Also only keep tests for Python versions compatible with supported Django versions (3.8 - 3.11).

3.0.0

  • Removed compatibility with Python 2

  • Added compatibility with Django up to 3.2 and 4.2 (thanks to work from @TTycho, @awais786, @arpitjain799, @tirkarthi)

2.1.1

  • Add support for byte order markers (BOM) (thanks @Yaoxin)

  • Documentation updates (thanks @rjemanuele and @coreyshirk)

2.1.0

  • CSVs with no data still output header labels (thanks @travisbloom)

  • Include a paginated renderer as part of the app (thanks @masterfloda)

  • Generators can be used as data sources for CSVStreamingRenderer (thanks @jrzerr)

  • Support for non UTF-8 encoding parsing (thanks @weasellin)

2.0.0

  • Make CSVRenderer.render return bytes, and CSVParser.parse expect a byte stream.

  • Have data-less renders print header row, if header is explicitly supplied

  • Drop Django 1.7 tests and add Django 1.10 tests

  • have CSVRenderer.tableize act as a generator when possible (i.e., when a header is explicitly specified).

  • Add docs for labels thanks to @radyz

  • Fix header rendering in CSVStreamingRenderer thanks to @radialnash

  • Improve unicode handling, thanks to @brandonrobertz

1.4.0/1.4.1

  • Add support for changing field labels in the CSVRenderer, thanks to @soby

  • Add support for setting CSVRenderer headers, labels, and writer_opts as renderer_context parameters.

  • Renamed CSVRenderer.headers to CSVRenderer.header; old spelling is still available for backwards compatibility, but may be removed in the future.

1.3.4

  • Support streaming CSV rendering, via @ivancrneto

  • Improved test configuration and project metadata, via @ticosax

1.3.2/1.3.3

  • Support unicode CSV parsing, and universal newlines, with thanks to @brocksamson

1.3.1

  • Renderer handles case where data is not a list by wrapping data in a list, via pull request from @dougvk

  • Better cross Python version support, via @paurullan and @vishen

1.3.0

  • Support for Python 3, derived from work by @samdobson

1.2.0

  • Support consistent ordering of fields in rendered CSV; thanks to @robguttman

  • Support specifying particular fields/headers in custom CSV renderer by overriding the headers attribute.

1.1.0

  • Support simple CSV parsing; thanks to @sebastibe

1.0.1

  • Add the package manifest

1.0.0

  • Initial release

Project details


Download files

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

Source Distribution

djangorestframework-csv-3.0.2.tar.gz (32.0 kB view details)

Uploaded Source

Built Distribution

djangorestframework_csv-3.0.2-py3-none-any.whl (49.7 kB view details)

Uploaded Python 3

File details

Details for the file djangorestframework-csv-3.0.2.tar.gz.

File metadata

File hashes

Hashes for djangorestframework-csv-3.0.2.tar.gz
Algorithm Hash digest
SHA256 b269b692feda1971e1342f395a21d339c6a16d2961ff64357a9a6188f27af10f
MD5 7e52aa15c42ac860df9a1ae8b8c1cf3e
BLAKE2b-256 3c5dd2862d98a1eaca0d05d0e2d0a4278fbcd8ff8353460edfb18c1d9969036b

See more details on using hashes here.

File details

Details for the file djangorestframework_csv-3.0.2-py3-none-any.whl.

File metadata

File hashes

Hashes for djangorestframework_csv-3.0.2-py3-none-any.whl
Algorithm Hash digest
SHA256 d1bcfbaaeaa5145af6bb0985a36a5bbf2f853d9961c722f69c7b0c9c3bcc269a
MD5 d792d0a4132b17766879274c39edc259
BLAKE2b-256 e0ded063e4e0e0a7225a2a2b8e76fa690b12a9deb0c5c60f73afe0cffe9da38a

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page