function insertKeyword($keyword)
{
global $keywordInsertStmt;
$existingKeywordId = getKeywordId($keyword);
if ($existingKeywordId != null) {
return $existingKeywordId;
}
$keywordInsertStmt->bind_param("s", $keyword);
$keywordInsertStmt->execute();
return getLastInsertedId();
}
/**
* Adds keywords to the keyword table and links the new commit
* with the keywords
*
* @param array $arKeywords Array of keywords
* @param integer $nCommitId Database ID of the commit
* @param PDO $db Database connection object
*
* @return void
*/
function linkKeywordsAndCommit($arKeywords, $nCommitId, $db)
{
if (count($arKeywords) == 0) {
return;
}
foreach ($arKeywords as $keyword) {
$nKeywordId = getKeywordId($keyword, $db);
$numAffected = $db->exec('INSERT INTO keywords_commits' . ' SET k_id = ' . (int) $nKeywordId . ' , c_id = ' . (int) $nCommitId);
if ($numAffected === false) {
handleError($db);
}
}
}
