public function up()
{
$comments = new \yii\db\Query();
$comments = $comments->from(\Yii::$app->params['oldDb'] . '.joom_jcomments');
$commentsCount = $comments->count();
echo " > migrating comments... Almost have {$commentsCount} comments...\r\n";
echo " > prepare comments...\r\n";
$i = 0;
$prepared = [];
foreach ($comments->each() as $comment) {
$i++;
echo " > comment {$i} from {$commentsCount}... \r\n";
$commentModel = new Comment(['newsID' => $comment['object_id'], 'author' => $comment['name'], 'email' => $comment['email'], 'text' => $comment['comment'], 'date' => strtotime($comment['date']), 'isGood' => $comment['isgood'], 'isBad' => $comment['ispoor'], 'published' => $comment['published'], 'deleted' => $comment['deleted'], 'id' => $comment['id']]);
$commentModel->setIp($comment['ip']);
if (!empty($commentModel->ip) && mb_strlen($commentModel->author, 'utf8') < 64 && $commentModel->date > 0 && $commentModel->date < time() + 86400) {
$prepared[] = $commentModel->attributes;
}
if (count($prepared) >= 100 || $commentsCount - $i == 0) {
$this->batchInsert(Comment::tableName(), array_keys($prepared[0]), $prepared);
$prepared = [];
}
}
}
