@when 'mysql.available' 'apt.mysql-client.installed'
@when_not 'mysql-config.done'
function config_db(mysql) {

if [ ! -d $CHARM_DIR/files/archives/dbschema ]; then
     cd $CHARM_DIR/files/archives
     mkdir dbschema
     cd dbschema
     tar -xvf $CHARM_DIR/files/archives/pcc-*dbschema.tar
fi
juju-log "IBM PAC: Extracted files from dbschema package successfully."

juju-log "IBM PAC: Logging into mysql console."
mysql_password=`sudo cat /var/lib/mysql/mysql.passwd`
set +e
result=`mysqlshow -h ${mysql.host()}:${mysql.port()} -u ${mysql.username()} -p${mysql.password()} pac | grep -o pac`
set -e
if [ "$result" == "pac" ]; then
        juju-log "IBM PAC Helper: pac database already exists. connecting to pac database."
else
        mysql -h ${mysql.host()}:${mysql.port()} -u ${mysql.username()} -p${mysql.password()} << EOF
        create database pac default character set utf8 default collate utf8_bin;
        CREATE USER 'pacuser'@'%' IDENTIFIED BY 'pacuser';
        GRANT ALL PRIVILEGES ON pac.* to pacuser@'%' IDENTIFIED BY 'pacuser';
        GRANT ALL PRIVILEGES ON pac.* to pacuser@'localhost' IDENTIFIED BY 'pacuser';
        use pac;
        source $CHARM_DIR/files/archives/dbschema/DBschema/MySQL/egodata.sql;
        source $CHARM_DIR/files/archives/dbschema/DBschema/MySQL/lsfdata.sql;
        source $CHARM_DIR/files/archives/dbschema/DBschema/MySQL/lsf_sql.sql;
        source $CHARM_DIR/files/archives/dbschema/DBschema/MySQL/create_schema.sql;
        source $CHARM_DIR/files/archives/dbschema/DBschema/MySQL/create_pac_schema.sql;
        source $CHARM_DIR/files/archives/dbschema/DBschema/MySQL/init.sql;
EOF
fi

set_state 'mysql-config.done'

}