.gitlab-ci.yml

variables:
  DBNAME: "bokeh_build_${CI_BUILD_REF}"
  DBUSER: root
  DBPASS: root

test:
  script:
  - wget http://sandbox.afi-sa.net/databases/default-ci-dump.sql.gz -O default-ci-dump.sql.gz
  - mysql -u$DBUSER -p$DBPASS -e "drop schema if exists ${DBNAME}; create schema ${DBNAME}"
  - zcat default-ci-dump.sql.gz | mysql -u$DBUSER -p$DBPASS $DBNAME
  - mysql -u$DBUSER -p$DBPASS -e "drop trigger if exists ${DBNAME}.datemaj_notices_update;update mysql.proc set definer='${DBUSER}@localhost' where db='${DBNAME}'"
  - nice -n 15 bash build.sh $DBNAME $DBUSER $DBPASS
  - mysql -u$DBUSER -p$DBPASS -e "drop schema if exists ${DBNAME}"