#!/bin/bash

DATA_DIR='#/initial_data/'
DESCR_FILE='descriptions.sql'
PROGRAMS_FILE='programs.sql'
VERSIONS_FILE='versions.sql'

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

clear

echo 'descriptions ....'

# Truncate descritpions and import initial data
mysql -u''$MYSQL_USERNAME'' -p''$MYSQL_PASSWORD'' -h''$MYSQL_HOST'' $MYSQL_DATABASE -e "TRUNCATE TABLE descriptions;TRUNCATE TABLE logs"
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;"
echo 'done.'

echo 'programs ....'

# 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;"
echo 'done.'

echo 'versions ....'

# 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 'done.'

echo "Initial data loaded successfully"