<?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']);