<?php

header('Content-Type: text/plain');

$cfg = array(

    'dsn' => 'mysql:host=localhost;',

    'config' => array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'),

    'username' => 'root',

    'password' => '',

);

require_once '../config/config.php';

use bfw\database\Database;

$db = Database::getInstance($cfg);

$dropSQLStatements = array(

    "DROP USER 'bfw'@'localhost'",

    "DROP DATABASE IF EXISTS bfw;",

);

$createSQLStatements = array(

    "CREATE DATABASE bfw CHARACTER SET utf8 COLLATE utf8_unicode_ci;",

    "CREATE USER 'bfw'@'localhost' IDENTIFIED BY 'bfw';",

    "GRANT ALL PRIVILEGES ON bfw.* TO 'bfw'@'localhost' WITH GRANT OPTION;",

);

foreach ($dropSQLStatements as $statement) {

    $status = $db->execute($statement);

    echo sprintf("%s\n", $statement);

}

foreach ($createSQLStatements as $statement) {

    $status = $db->execute($statement);

    echo sprintf("%s\n", $statement);

}

$handle = fopen(BFW_PATH . '/sql/init.sql', 'r');

$sql = "USE bfw;\n\n";

while (!feof($handle)) {

    $sql .= fgets($handle);

}

fclose($handle);

if ($db->execute($sql) == 0) {

    echo sprintf("%s", $sql);

    header('Location: /');

}