#!/usr/bin/env bash
mkdir ~/.matplotlib
echo 'backend: tkagg' > ~/.matplotlib/matplotlibrc
python $TRAVIS_BUILD_DIR/bin/get_test_data.py
wget --quiet -O $HOME/sas/travis_mangadb.sql https://sas.sdss.org/marvin/data/travis_mangadb.sql
createdb -U postgres -T template0 manga
createuser -U postgres -d -l -r -s Brian
createuser -U postgres -d -l -r utahuser
createuser -U postgres -g utahuser manga
createuser -U postgres -g utahuser sdss
createuser -U postgres -g utahuser u0857802
createuser -U postgres -g utahuser u0707758
createuser -U postgres -g utahuser u0931042
psql -U postgres -d manga -c "set shared_buffers to '1792MB';" -c "set default_statistics_target to 100;"
psql -U postgres -d manga -c "set effective_cache_size to '5376MB';" -c "set work_mem to '9175kB';"
psql -U postgres -d manga -c "set maintenance_work_mem to '448MB';"
pg_restore -Fc -j 8 -U postgres -d manga $HOME/sas/travis_mangadb.sql
psql -d manga -c "select count(c.pk) from mangadatadb.cube as c;"
exit 0
