rebuild_sqlite.sh

# Delete uploaded data files.
rm array_data/*
rm raw_data/*
rm datasets/*

# Delete databases.
mkdir -p db
rm db/*.sqlite3

set -e

export DB_VENDOR=sqlite
export DJANGO_SETTINGS_MODULE=biodb.settings.dev

# Collect all static files to be served.
# NOTE: `manage.py runserver` does this automatically, however, serving from gunicorn obviously doesn't.
python manage.py collectstatic --clear --noinput

# Create migrations for any model changes.
python manage.py makemigrations

# Create and/or migrate DBs.
python manage.py migrate
python manage.py migrate --database=bsr

# Load initial data fixtures.
python manage.py loaddata centers queries
python manage.py loaddata --database=bsr centers observables instruments qcannotators biosampletypes arraymeasurementtypes

# Update SQL views.
python manage.py update_sql_views flat_view

# Clean up orphaned files.
python manage.py prune_files

# Creat superuser.
# Note: This center ID is that for the jhu and the default password is "admin".
DJANGO_SUPERUSER_PASSWORD="${DJANGO_SUPERUSER_PASSWORD:-admin}" python manage.py createsuperuser --noinput --username=admin --email=admin@jhu.edu --center=16721944-ff91-4adf-8fb3-323b99aba801