FROM       debian:wheezy
MAINTAINER Pierre-Olivier Mercier <nemunaire@nemunai.re>

# Install packages ####################################################

RUN apt-get -y update && \
    apt-get install -y \
	    mysql-client \
    && \
    apt-get clean && rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*

# Copying files #######################################################

WORKDIR /var/www/fic-server

COPY fic2014.sql /var/www/fic-server/db/
COPY feed.sql /var/www/fic-server/db/

# Import DB ###########################################################

CMD echo "CREATE DATABASE IF NOT EXISTS $DB_ENV_MYSQL_DATABASE;" | mysql -h $DB_PORT_3306_TCP_ADDR -u root --password=$DB_ENV_MYSQL_ROOT_PASSWORD && \
    cat /var/www/fic-server/db/fic2014.sql | mysql -h $DB_PORT_3306_TCP_ADDR -u root --password=$DB_ENV_MYSQL_ROOT_PASSWORD $DB_ENV_MYSQL_DATABASE && \
    cat /var/www/fic-server/db/feed.sql | mysql -h $DB_PORT_3306_TCP_ADDR -u $DB_ENV_MYSQL_USER --password=$DB_ENV_MYSQL_PASSWORD $DB_ENV_MYSQL_DATABASE && \
    echo "Import ok"
