<?php
require_once 'app/config.php';
require_once 'app/src/Database.php';
require_once 'app/src/CommandLine.php';
$database = new Database($config['database']);
$commandLine = new CommandLine($argv);
$database->connect();
switch ($argv[1]) {
case 'migrate':
if (isset($argv[2])) {
if ($argv[2] == "rollback") {
$database->thisConnection()->query("SET foreign_key_checks = 0");
if ($result = $database->thisConnection()->query("SHOW TABLES")) {
while ($row = $result->fetch_array(MYSQLI_NUM)) {
$database->thisConnection()->query("DROP TABLE IF EXISTS {$row[0]}");
}
}
$database->thisConnection()->query("SET foreign_key_checks = 1");
$database->thisConnection()->close();
echo "rollback successful\n";
} else {
if ($argv[2] == "seed") {
$query = file_get_contents($config['sql_seed']);
$database->thisConnection()->multi_query($query);
echo "seed successful\n";
echo $database->thisConnection()->error;
}
}
} else {
$query = file_get_contents($config['sql_file']);
