scripts/reset_db.sh
author Madhusudan.C.S <madhusudancs@gmail.com>
Thu, 20 Jan 2011 05:59:47 +0530
changeset 484 d2a4fcbe2fae
parent 441 10f16121a46b
permissions -rwxr-xr-x
A python script to load the data of tasks from CSV to database.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
413
49b58b9b10a1 Add reset_db script.
Madhusudan.C.S <madhusudancs@gmail.com>
parents:
diff changeset
     1
#! /bin/bash
49b58b9b10a1 Add reset_db script.
Madhusudan.C.S <madhusudancs@gmail.com>
parents:
diff changeset
     2
49b58b9b10a1 Add reset_db script.
Madhusudan.C.S <madhusudancs@gmail.com>
parents:
diff changeset
     3
sudo -u postgres dropdb pytask
49b58b9b10a1 Add reset_db script.
Madhusudan.C.S <madhusudancs@gmail.com>
parents:
diff changeset
     4
sudo -u postgres createdb -O pytask pytask
416
265dbd81c451 Remove initial south migrations also during reset of the database.
Madhusudan.C.S <madhusudancs@gmail.com>
parents: 413
diff changeset
     5
rm -r pytask/profile/migrations/
265dbd81c451 Remove initial south migrations also during reset of the database.
Madhusudan.C.S <madhusudancs@gmail.com>
parents: 413
diff changeset
     6
rm -r pytask/taskapp/migrations/
265dbd81c451 Remove initial south migrations also during reset of the database.
Madhusudan.C.S <madhusudancs@gmail.com>
parents: 413
diff changeset
     7
./bin/django schemamigration profile --initial
265dbd81c451 Remove initial south migrations also during reset of the database.
Madhusudan.C.S <madhusudancs@gmail.com>
parents: 413
diff changeset
     8
./bin/django schemamigration taskapp --initial
413
49b58b9b10a1 Add reset_db script.
Madhusudan.C.S <madhusudancs@gmail.com>
parents:
diff changeset
     9
./bin/django syncdb
49b58b9b10a1 Add reset_db script.
Madhusudan.C.S <madhusudancs@gmail.com>
parents:
diff changeset
    10
./bin/django migrate profile
49b58b9b10a1 Add reset_db script.
Madhusudan.C.S <madhusudancs@gmail.com>
parents:
diff changeset
    11
./bin/django migrate taskapp
49b58b9b10a1 Add reset_db script.
Madhusudan.C.S <madhusudancs@gmail.com>
parents:
diff changeset
    12
./bin/django loaddata sites_fixture.json 
441
10f16121a46b Update the reset db script to seed profile also.
Madhusudan.C.S <madhusudancs@gmail.com>
parents: 416
diff changeset
    13
./bin/django loaddata profile_fixture.json