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]); } }