1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
<?php
/**
* Optimize Database Tables Task.
*
* @package Silla.IO
* @subpackage Core\CLI
* @author Plamen Nikolov <plamen@athlonsofia.com>
* @copyright Copyright (c) 2015, Silla.io
* @license http://opensource.org/licenses/GPL-3.0 GNU General Public License, version 3.0 (GPLv3)
*/
namespace Tasks\DB;
use Core;
/**
* Class Create Task definition.
*/
final class Create extends Core\Base\Task
{
/**
* Imports database dump file.
*
* @param array $params Additional command line parameters.
*
* @throws \InvalidArgumentException When missing dump file is passed.
* @throws \LogicException When cannot execute queries.
*
* @example ./silla tasks:db:create resources/db/mysql/dump.mysql.sql
*
* @return void
*/
public static function run(array $params = array())
{
$filename = isset($params[0]) && is_file($params[0]) ? $params[0] : null;
if (!$filename) {
throw new \InvalidArgumentException('The passed dump file cannot be found!');
}
$tempLine = '';
$lines = file($filename);
$queriesCount = 0;
foreach ($lines as $line) {
if (substr($line, 0, 2) == '--' || $line == '') {
continue;
}
$tempLine .= $line;
if (substr(trim($line), -1, 1) == ';') {
Core\DB()->query($tempLine);
$tempLine = '';
$queriesCount++;
}
}
echo $queriesCount . ' Queries imported successfully!' . PHP_EOL;
}
}