}
}
$result = array();
while (($row = mysql_fetch_array($query)) != false) {
$result[] = $row;
}
mysql_free_result($query);
return $result;
}
function create_version()
{
simple_query("CREATE TABLE IF NOT EXISTS `version` (`id` INT AUTO_INCREMENT PRIMARY KEY, `applied_script` VARCHAR(127) UNIQUE)");
}
echo "DB updater started\n";
$factory = new GlobalFactory();
$connection = $factory->getEntityManager()->getConnection();
$host = $connection->getHost();
$user = $connection->getUsername();
$password = $connection->getPassword();
$database = $connection->getDatabase();
$scriptPath = PROJECT_ROOT . 'database/updates';
echo "host: {$host}", PHP_EOL, "user: {$user}", PHP_EOL, "database: {$database}", PHP_EOL;
echo "connect to db...\n";
$link = mysql_connect($host, $user, $password);
mysql_select_db($database, $link);
echo "create version table\n";
create_version();
echo "get actual version\n";
$result = simple_query("select id, applied_script from version");
$applied = array();
foreach ($result as $row) {
