Django postgresql drop all tables and syncdb

Question

I have database in PostgreSql named "tests". And i want to write sh script to syncdb it with django, run tests and then drop all tables. Can anyone suggest a proper solution? A bit of script:

DJANGO_DATABASE='tests' bin/django-admin.py syncdb  
bin/django-admin.py test MyApplication #tests will use "tests" db
sudo su postgres
psql tests
drop schema public; #i think i can drop schema and then syncdb.. or i'm wrong.
exit

mo. · Accepted Answer · 2014-02-21 15:18:35Z

3

As far as i know, django can do this for you. <-- outdated

Actually, it changed a bit :). But it's still possible:

#!/usr/bin/env sh
./manage.py sqlclear | ./manage.py dbshell
./manage.py syncdb

this will pipe, the output of sqlclear management-command into the dbshell. which will in turn execute it.

sqlclear will output DROP TABLE ... sql-statements.

edited Feb 21, 2014 at 15:18

answered Sep 5, 2012 at 6:45

mo.

3,5941 gold badge26 silver badges20 bronze badges

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

1 Comment

tadasajon Over a year ago

Great! Can you explain how?

Collectives™ on Stack Overflow

Django postgresql drop all tables and syncdb

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related