Skip to main content

This allows you to use a spreadsheet to define Django units tests that make requests to the Django testing client.

Project description

This allows you to use a spreadsheet to define Django units tests that make requests to the Django testing client. Inspired by Robot Framework.


To get the latest stable release from PyPi

pip install django_csv_tests

Install the app



Create a CSV file with the headers “test name”, “expect failure”, “login as”, “url”, “method”, “querystring”, “post body”, “expect status”, “expect header”. Then create a test file like:

import os

from django.contrib.auth import get_user_model
from django.test import TestCase

from django_csv_tests import generate_tests

class TheTestCase(TestCase):
    def setUp(self):
        self.user = get_user_model().objects.create_user(username='john.doe',

csv_path = os.path.join(os.path.dirname(__file__), 'tests.csv')
generate_tests(csv_path, TheTestCase)

You can define tests as a sequence of requests with associated assertions. A test is defined with a test name and one or more rows that describe requests to make. If a row does not have a test name it indicates that the request defined on that row is part of the last named test.

Column values

test name

A string used to name the test.

expect failure

A boolean used to indicated whether the test is expected to fail. Any non-zero length string indicates True. An easy way is enter this in a spreadsheet is as “x”.

login as

A JSON encoded string that provides the username and password of the user to log in as. This is passed as keyword arguments to django.contrib.auth.authenticate(). Example: {“username”: “john.doe”, “password”: “password”}.


The URL that the request should be made to.


An HTTP method. GET and POST are supported.


A JSON encoded string that contains querystring keys and values. This becomes request.GET.

post body

A JSON encoded string that contains data to submit in a POST request. This is used only if the method is POST. This becomes request.POST.

expect status

The HTTP status code expected for the response.

expect header

A JSON encoded string that contains header keys and values expected in the response. Example: A redirect response could have the header {“Location”: “http://testserver/new_location/”}


  • Implement “expect context”, “expect session”, and “expect” directives.

Run Tests

source venv/bin/activate
python django_csv_tests/tests/ test

Project details

Download files

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

Files for django_csv_tests, version 0.1.5
Filename, size File type Python version Upload date Hashes
Filename, size django_csv_tests-0.1.5.tar.gz (6.1 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page