private function downloadPhrasesVoice($name, $force) { $params = array(); if ($force) { $sql = "SELECT * FROM phrases WHERE 1 = 1"; } else { $sql = "SELECT * FROM phrases WHERE (voice IS NULL or voice = '')"; } if ($name != null) { $sql .= ' AND name = :name'; $params['name'] = $name; } $sql .= " AND voice not like '%/%'"; $handle = $this->db->executeQuery($sql, $params); while ($row = $handle->fetch()) { $entity = new PhrasesEntity(); $entity->fromArray($row); try { $this->updatePhrase($entity, $force); } catch (\Exception $e) { $this->output->writeln(sprintf("phrase [%s] update failed, error info: %s", $entity->getName(), $e->getMessage())); } } }