#!/bin/bash

DATA_DIR='/home/contentp/public_html/initial_data/'
DESCR_FILE='descriptions.sql'
PROGRAMS_FILE='programs.sql'
VERSIONS_FILE='versions.sql'

MYSQL_USERNAME='contentp'
MYSQL_PASSWORD='##########'
MYSQL_HOST='localhost'
MYSQL_DATABASE='contentp_content'

# Truncate descritpions and import initial data
mysql -u''$MYSQL_USERNAME'' -p''$MYSQL_PASSWORD'' -h''$MYSQL_HOST'' $MYSQL_DATABASE -e "TRUNCATE TABLE descriptions;"
mysql -u''$MYSQL_USERNAME'' -p''$MYSQL_PASSWORD'' -h''$MYSQL_HOST'' $MYSQL_DATABASE < $DATA_DIR""$DESCR_FILE
mysql -u''$MYSQL_USERNAME'' -p''$MYSQL_PASSWORD'' -h''$MYSQL_HOST'' $MYSQL_DATABASE -e "SELECT count(id) as ImportedDescriptions FROM descriptions;"

# Truncate prorgams and import initial data
mysql -u''$MYSQL_USERNAME'' -p''$MYSQL_PASSWORD'' -h''$MYSQL_HOST'' $MYSQL_DATABASE -e "TRUNCATE TABLE programs;"
mysql -u''$MYSQL_USERNAME'' -p''$MYSQL_PASSWORD'' -h''$MYSQL_HOST'' $MYSQL_DATABASE < $DATA_DIR""$PROGRAMS_FILE
mysql -u''$MYSQL_USERNAME'' -p''$MYSQL_PASSWORD'' -h''$MYSQL_HOST'' $MYSQL_DATABASE -e "SELECT count(id) as ImportedPrograms FROM programs;"

# Truncate versions and import initial data
mysql -u''$MYSQL_USERNAME'' -p''$MYSQL_PASSWORD'' -h''$MYSQL_HOST'' $MYSQL_DATABASE -e "TRUNCATE TABLE versions;"
mysql -u''$MYSQL_USERNAME'' -p''$MYSQL_PASSWORD'' -h''$MYSQL_HOST'' $MYSQL_DATABASE < $DATA_DIR""$VERSIONS_FILE
mysql -u''$MYSQL_USERNAME'' -p''$MYSQL_PASSWORD'' -h''$MYSQL_HOST'' $MYSQL_DATABASE -e "SELECT count(id) as ImportedVersions FROM versions;"

echo "\n\n Initial data loaded successfully \n\n "