protected function run8($stage)
{
if ($this->getCountOfAccountTagValues(TagEntity::TAG_ID_PROJECT) && $this->console->confirm('Would you like to remove old projects from account_tag_values?')) {
$this->console->out("Removing old projects");
$this->db->Execute("DELETE FROM account_tag_values WHERE tag_id = ?", array(TagEntity::TAG_ID_PROJECT));
}
$this->console->out('Populating projects to the dictionary');
foreach (ProjectEntity::all() as $projectEntity) {
/* @var $projectEntity ProjectEntity */
$this->db->Execute("\n INSERT IGNORE `account_tag_values` (`account_id`, `tag_id`, `value_id`, `value_name`)\n VALUES (?, ?, ?, ?)\n ", [$projectEntity->accountId ?: 0, TagEntity::TAG_ID_PROJECT, $projectEntity->projectId, $projectEntity->name]);
}
}
