How to run tests in django using database with data?

Question

I want to test my views using data from postgres localhost database (with already loaded data). I'm using tox with pytest and pytest-django.

My question: How to set up / connect to local database to get all the data model schema and data itself? Or maybe it is better to use factory_boy? Or to load whole data from .sql script (if yes, how)?

Example of my test:

def test_foo_view(custom_client_login):
    response = custom_client_login.get('/foo/bar/123/')

    assert response.status_code == 200
    assert 'Transaction no. 123' in response.content

But instead of getting status code 200 I get 404, which points that no data is in test database. But when I lunch runserver and go to that view ('localhost:8000/foo/bar/123/') I will get status 200 and html webpage with some data.

Please help!

I'm using:

Django==1.7.11
pytest==3.0.6
pytest-django==3.1.2
tox==2.6.0

Use the test runner setup (def setUp) and create a site to use within your view test — Jingo
– Jingo, Commented Mar 2, 2017 at 15:17
@Jingo could you please elaborate a little bit more about your answer? isn't def setUp using with unittest? — MichalTHEDUDE
– MichalTHEDUDE, Commented Mar 2, 2017 at 15:21
docs.djangoproject.com/en/1.10/topics/testing/overview have a look at that — Jingo
– Jingo, Commented Mar 2, 2017 at 15:22
@Jingo I see. But I wanted to avoid creating objects (and creating whole database structure) and just use my local db. Any thoughts? — MichalTHEDUDE
– MichalTHEDUDE, Commented Mar 2, 2017 at 15:23
maybe you are looking for fixtures then... django-testing-docs.readthedocs.io/en/latest/fixtures.html — Jingo
– Jingo, Commented Mar 2, 2017 at 17:31

MichalTHEDUDE · Accepted Answer · 2017-03-03 13:33:36Z

5

Just found a way! It was simpler then I thought! Without writing any custom TestRunners etc.

The answer is in pytest-django docs in Chapter 5 -> Examples -> Use a read only database.

Check out other examples, which are really handy in such situations.

Thanks!

answered Mar 3, 2017 at 13:33

MichalTHEDUDE

1216 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to run tests in django using database with data?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related