Пример #1
0
 public function run()
 {
     $config = $this->app->database;
     $dsn = sprintf('%s:host=%s;port=%s', $config['type'], $config['host'], $config['port']);
     $pdo = new PDO($dsn, $config['username'], $config['password'], $config['options']);
     try {
         if ($this->params['force']) {
             // Force create database
             $pdo->exec('DROP DATABASE `' . $config['dbname'] . '`');
             $pdo->exec('CREATE DATABASE `' . $config['dbname'] . '` DEFAULT CHARACTER SET `utf8`;');
         } else {
             // Try to create database
             $pdo->exec('CREATE DATABASE IF NOT EXISTS `' . $config['dbname'] . '` DEFAULT CHARACTER SET `utf8`;');
         }
         $pdo->exec("USE `{$config['dbname']}`");
         $sql = file_get_contents(APP_DIR . '/migrations/schema.sql');
         $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
         $pdo->exec($sql);
         if ($this->params['data']) {
             $sql = file_get_contents(APP_DIR . '/migrations/data.sql');
             $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
             $pdo->exec($sql);
         }
     } catch (\PDOException $e) {
         print Cli::text('Create database error: ' . $e->getMessage() . PHP_EOL, 'red');
         $this->output->end();
     }
     print Cli::text('Init database ok' . PHP_EOL, 'green');
 }
Пример #2
0
 public function run()
 {
     $articles = Model::factory('Article')->find_many();
     foreach ($articles as $article) {
         $article->comments_count = $article->comments()->count();
         $article->digg_count = Model::factory('UserDigg')->where('article_id', $article->id)->count();
         $article->save();
     }
     print Cli::text('Update article count ok' . PHP_EOL, 'green');
 }
Пример #3
0
 public function run()
 {
     $users = Model::factory('User')->find_many();
     foreach ($users as $user) {
         $user->posts_count = $user->articles()->where('status', Article::OK)->count();
         $user->digged_count = 0;
         foreach ($user->articles()->where('status', Article::OK)->find_many() as $article) {
             $user->digged_count += $article->digg_count;
         }
         $user->save();
     }
     print Cli::text('Update user count ok' . PHP_EOL, 'green');
 }
Пример #4
0
 public function run()
 {
     $model = Model::factory('Article');
     if (!$this->params['all']) {
         $model->where_gte('created_at', date('Y-m-d', strtotime('-1 month')));
     }
     /** @var $articles \Model\Article[] */
     $articles = $model->find_many();
     foreach ($articles as $article) {
         $article->digg_count = $article->diggs()->count();
         $article->comments_count = $article->comments()->count();
         $article->point = $article->analysisPoint();
         $article->save();
     }
     print Cli::text('Analysis article point ok' . PHP_EOL, 'green');
 }
Пример #5
0
Файл: Init.php Проект: pagon/app
 public function run()
 {
     $pdo = $this->app->pdo;
     $config = $this->app->get("database");
     try {
         if ($this->params['force']) {
             // Force create database
             $pdo->exec('DROP DATABASE `' . $config['dbname'] . '`');
             $pdo->exec('CREATE DATABASE `' . $config['dbname'] . '` DEFAULT CHARACTER SET `utf8`;');
         } else {
             // Try to create database
             $pdo->exec('CREATE DATABASE IF NOT EXISTS `' . $config['dbname'] . '` DEFAULT CHARACTER SET `utf8`;');
         }
         $pdo->exec("USE `{$config['dbname']}`");
         $sql = file_get_contents(APP_DIR . '/migrations/schema.sql');
         if (!$sql) {
             print Cli::text('migrations/schema.sql is empty' . PHP_EOL, 'red');
         } else {
             $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
             $pdo->exec($sql);
         }
         if ($this->params['data'] && is_file(APP_DIR . '/migrations/data.sql')) {
             $sql = file_get_contents(APP_DIR . '/migrations/data.sql');
             if (!$sql) {
                 print Cli::text('migrations/data.sql is empty' . PHP_EOL, 'red');
             } else {
                 $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
                 $pdo->exec($sql);
             }
         }
     } catch (\PDOException $e) {
         print Cli::text('Create database error: ' . $e->getMessage() . PHP_EOL, 'red');
         $this->output->end();
     }
     print Cli::text('Init database ok' . PHP_EOL, 'green');
 }
Пример #6
0
 public function run()
 {
     $post = Model::factory('Article')->find_one($this->params['id']);
     if (!$post) {
         echo Cli::text('Article is not exists' . PHP_EOL, 'red');
     }
     echo 'Article is ' . PHP_EOL . PHP_EOL . "\t" . Cli::text($post->title, 'green') . PHP_EOL . PHP_EOL;
     switch ($this->input->param('action')) {
         case 'delete':
             if (!Cli::confirm('Do you want to delete')) {
                 return;
             }
             $post->status = Article::DELETED;
             $post->save();
             break;
         case 'revert':
             $post->status = Article::OK;
             $post->save();
             break;
         default:
             echo Cli::text('Error action!', 'red') . PHP_EOL;
     }
     echo 'Action done!' . PHP_EOL;
 }