#!/bin/sh
echo '0) drop all tables'
php app/console doctrine:schema:drop -q --force --env=test

echo '1) fixtures schema'
php app/console doctrine:query:sql -q --env=test " $(cat ./app/Resources/dbupdate/starter.sql)"
php app/console doctrine:query:sql -q --env=test " $(cat ./app/Resources/dbupdate/starter2.sql)"


echo '3) db version update'
php app/console es:db:update --env=test

echo '4a) fixtures data - SQL'
php app/console doctrine:query:sql -q  --env=test " $(cat ./test/fixtures/data.sql)" --depth=7

echo '4b) fixtures data - doctrine'
php app/console  doctrine:fixtures:load --append --env=test 

echo '5) create admin'
php app/console fos:user:create --super-admin admin admin@e-surf.pl Admin12346 --env=test
php app/console fos:user:promote --super admin --env=test