backend specific tests

[Dan Davis]

So, the contributor guidelines page about unit tests mentions running database specific tests:

https://docs.djangoproject.com/en/2.1/internals/contributing/writing-code/unit-tests/#testing-other-python-versions-and-database-backends

I am working on ticket 29984, and it seems to me that since the TruncDay is attempting to cast to the timezone on the database level, it is working, and its job is done.  So, the fix should be at the backend level, and the ticket provides one for Postgres.

Following the unit test advice, I created a settings file.   But not using my Postgresql admin user.   I get the following errors:

psycopg2.ProgrammingError: permission denied to create extension "btree_gin"

HINT:  Must be superuser to create this extension.

I'm not going to do that - do you have any list of required extensions?

[Josh Smeaton]

I don't think there's a full list of extensions the test suite uses, but https://docs.djangoproject.com/en/2.1/ref/contrib/postgres/operations/ would be close to a full set I'd imagine.

[Dan Davis]

So, a developer using PostgreSQL doesn't need superuser privileges, but you do to run Django's unit tests, because it will test these contributed postgres operations.

[charettes]

Exactly.

Given you should be running tests against a throwaway or at least non-critical

PostgreSQL cluster anyway I don't think requiring superuser privileges is an

issue.

Simon

[Dan Davis]

What about mysql?   I have 5.7 installed, and tried to run with root privileges, which is what worked for postgresql.  It still failed quite a number of times.

--
You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-develop...@googlegroups.com.
To post to this group, send email to django-d...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-developers.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/d252a3e0-f8f4-4026-b1eb-9dfd79993618%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Tom Forbes]

Hey Dan,

I’ve been working on a project called django_docker_box (https://github.com/orf/django-docker-box) that might help with this. Docker is pretty good at spinning up various databases without needing to clutter your local machine, spend time configuring authentication or dealing with issues like this.

You might find this helps with you. You can run the entire test suite with it, or you can just spin up a Postgres database and connect to it from your local machine (docker-compose run postgres-db) with django:django.

Alternatively you could run:

docker run -p 5432:5432 -e POSTGRES_PASSWORD=django postgres:9.6

And connect to it with postgres:django on localhost:5432

Mysql can be done in the same way:

docker run -p 3306:3306 -e MYSQL_PASSWORD=django mysql:5.7

Hope this helps,

Tom

To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/CAFzonYYhELA0RRpM07KGsYX08CmM09UjeN8vZRovwfmCUTz_2g%40mail.gmail.com.

[Florian Apolloner]

On Wednesday, November 7, 2018 at 12:43:47 AM UTC+1, Dan Davis wrote:

So, a developer using PostgreSQL doesn't need superuser privileges, but you do to run Django's unit tests, because it will test these contributed postgres operations.

 I think one might get away with installing those extensions in the template database and the test code is intelligent enough to only install them if needed (this is just out of my head though).

[Dan Davis]

Tom,

I'm interested in this - I have a software architect's goal of getting our Django systems to go to the cloud with Docker, but for Django development, I am eager to clutter up my local box with these tools.   I know systemctl quite well, and I have no problem changing postgresql and mysql to be services not started by default.   I'm a better postgresql dba than mysql, but I do OK.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/CAFNZOJMt_w9p2XXaZqyyKPDQycsNAurb9RGea09TfsdpJgNfkQ%40mail.gmail.com.