Skip to content

Instantly share code, notes, and snippets.

@mpampols
Created January 31, 2014 22:10
Show Gist options
  • Save mpampols/8744297 to your computer and use it in GitHub Desktop.
Save mpampols/8744297 to your computer and use it in GitHub Desktop.
#!/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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment