public function up()
{
$this->addColumn('news', 'unpublishDate', Schema::TYPE_DATETIME);
$this->addColumn('news', 'checkedDate', Schema::TYPE_DATETIME);
$this->addColumn('news', 'checked', Schema::TYPE_INTEGER . ' UNSIGNED NOT NULL DEFAULT 0');
$this->addColumn('news', 'creator', Schema::TYPE_INTEGER . ' UNSIGNED NOT NULL DEFAULT 0');
$this->addColumn('news', 'textPreview', $this->text());
$this->addColumn('news', 'publishTimestamp', $this->integer()->unsigned()->notNull()->defaultValue(0));
$this->createIndex('publishTimestamp', 'news', 'publishTimestamp');
$this->execute("UPDATE `news` SET `publishTimestamp` = UNIX_TIMESTAMP(STR_TO_DATE(`publishDate`, '%Y-%m-%d %H:%i:%s'))");
$this->alterColumn('news', 'author', Schema::TYPE_STRING);
$newsList = new \yii\db\Query();
$newsList = $newsList->from(\Yii::$app->params['oldDb'] . '.joom_content');
$newsListCount = $newsList->count();
echo " > migrating news... Almost have {$newsListCount} news...\r\n";
echo " > prepare news...\r\n";
$i = 0;
foreach ($newsList->each(25) as $news) {
$i++;
echo " > news {$i} from {$newsListCount}... \r\n";
$newNews = new News(['id' => $news['id']]);
$newNews->creator = $news['created_by'];
$newNews->author = $news['created_by_alias'];
$newNews->title = $news['title'];
$newNews->textPreview = $news['introtext'];
$newNews->text = $news['fulltext'];
$newNews->link = $news['alias'];
$newNews->published = $news['access'] == '1' ? 1 : 0;
$newNews->deleted = $news['state'] == '-2' ? 1 : 0;
$newNews->publishDate = $news['publish_up'];
$newNews->favorite = $news['featured'];
$newNews->hits = $news['hits'];
$newNews->meta_description = $news['metadesc'];
$newNews->meta_keywords = $news['metakey'];
$newNews->category = $news['catid'];
$newNews->unpublishDate = $news['publish_down'];
$newNews->checkedDate = $news['checked_out_time'];
$newNews->checked = $news['checked_out'];
$newNews->image = $newNews->getImagePreview();
$newNews->publishTimestamp = $news['publish_up'] ? strtotime($news['publish_up']) : 0;
$newNews->publishTimestamp = $newNews->publishTimestamp < 0 ? 0 : $newNews->publishTimestamp;
$prepared[] = $newNews->attributes;
if (count($prepared) >= 50 || $newsListCount - $i == 0) {
$this->batchInsert(News::tableName(), array_keys($prepared[0]), $prepared);
$prepared = [];
}
}
}
