public function execute($params) { Makiavelo::info("Creating Database..."); $sql_folder_path = ROOT_PATH . Makiavelo::SQL_CREATE_TABLES_FOLDER; Makiavelo::puts("Creating database..."); $conn = DBLayer::connect(); $db_name = DBLayer::getDBName(); $sql = "CREATE DATABASE `{$db_name}`"; if (!mysql_query($sql, $conn)) { Makiavelo::info("ERROR creating db: " . mysql_error()); } //We also have to create the migrations table $sql_migrations = "CREATE TABLE migrations ( migration INT PRIMARY KEY);"; mysql_select_db($db_name); if (!mysql_query($sql_migrations, $conn)) { Makiavelo::info("ERROR creating migrations table:: " . mysql_error()); } DBLayer::disconnect($conn); }
private function loadEntities() { $sql_folder_path = ROOT_PATH . Makiavelo::SQL_CREATE_TABLES_FOLDER; $d = dir($sql_folder_path); while (($item = $d->read()) != false) { if ($item != "create_db.sql" && substr($item, 0, 1) != ".") { $file_path = $sql_folder_path . "/" . $item; $fp = fopen($file_path, "r"); if ($fp) { Makiavelo::puts("Loading entity: {$item} ..."); $conn = DBLayer::connect(); $sql = fread($fp, filesize($file_path)); fclose($fp); $res = mysql_query($sql, $conn); if (!$res && mysql_errno($conn) == 1050) { Makiavelo::puts("---- Entity already loaded, ignoring"); } DBLayer::disconnect($conn); } } } }