/**
* Get the project labels.
*
* @return $this
*
* @since 1.0
*/
protected function processLabels()
{
$this->out(g11n3t('Fetching labels...'), false);
/* @type \Joomla\Database\DatabaseDriver $db */
$db = $this->getContainer()->get('db');
$table = new LabelsTable($db);
$labels = $this->github->issues->labels->getList($this->project->gh_user, $this->project->gh_project);
$names = array();
$cntUpdated = 0;
$cntNew = 0;
foreach ($labels as $label) {
try {
$table->label_id = null;
// Check if the label exists
$table->load(array('project_id' => $this->project->project_id, 'name' => $label->name));
// Values that may have changed
if ($table->color != $label->color) {
$table->color = $label->color;
$table->store();
++$cntUpdated;
}
} catch (\RuntimeException $e) {
// New label
$table->project_id = $this->project->project_id;
$table->name = $label->name;
$table->color = $label->color;
$table->store();
++$cntNew;
}
$names[] = $label->name;
}
// Check for deleted labels
$ids = $db->setQuery($db->getQuery(true)->from($db->quoteName($table->getTableName()))->select('label_id')->where($db->quoteName('project_id') . ' = ' . $this->project->project_id)->where($db->quoteName('name') . ' NOT IN (\'' . implode("', '", $names) . '\')'))->loadColumn();
if ($ids) {
// Kill the orphans
$db->setQuery($db->getQuery(true)->delete($db->quoteName($table->getTableName()))->where($db->quoteName('label_id') . ' IN (' . implode(', ', $ids) . ')'))->execute();
}
$cntDeleted = count($ids);
return $this->out('ok')->logOut(sprintf(g11n3t('Labels: %1$d new, %2$d updated, %3$d deleted.'), $cntNew, $cntUpdated, $cntDeleted));
}
