django_droptable_sync_import

#!/bin/sh
# This script deletes an entire Django database, calls syncdb, and imports data tables

# Drop all tables in cascade
psql tablename << EOF
DROP SCHEMA public CASCADE;
CREATE SCHEMA "public" AUTHORIZATION "postgres";
EOF

# Syncdb
python manage.py syncdb --noinput

# Import dumps into database
psql tablename << EOF
\i ./folder/dump_file_1;
\i ./folder/dump_file_2;
EOF