var gulp = require('gulp'),
        shell = require('shelljs');

var config = {
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'mydatabase',
    commands: {
        mysql: 'mysql',
        mysqldump: 'mysqldump',
    },
    dumpFilePath: './/installation//dump.sql'
};

gulp.task('mysql:exportSqlDump', function () {
    var command = config.commands.mysqldump + ' -u ' + config.user + ' ' + config.database + ' > ' + config.dumpFilePath;
    console.log(command);
    var result = shell.exec(command);
    if (result.code !== 0) {
        console.error('MySQL dump export failed');
    } else {
        console.log('MySQL dump successful exported');
    }
    shell.exit(1);
});

gulp.task('mysql:importSqlDump', function () {
    var command = config.commands.mysql + ' -u ' + config.user + ' ' + config.database + ' < ' + config.dumpFilePath;
    console.log(command);
    var result = shell.exec(command);
    if (result.code !== 0) {
        console.error('MySQL dump import failed');
    } else {
        console.log('MySQL dump successful imported');
    }
    shell.exit(1);
});

gulp.task('mysql:cleanDatabase', function () {
    var command = config.commands.mysql + ' -u ' + config.user + ' -Bse "' +
            'DROP DATABASE `' + config.database + '`;' +
            'CREATE DATABASE `' + config.database + '` CHARACTER SET utf8 COLLATE utf8_bin;"';
    console.log(command);
    var result = shell.exec(command);
    if (result.code !== 0) {
        console.error('MySQL clean database failed');
    } else {
        console.log('MySQL database successful cleaned');
    }
    shell.exit(1);
});