protected function getGerritTrackingIdByIdentifier($changeSetId, $system, $trackingId)
    {
        $dbHandle = $this->getDatabase()->getDatabaseConnection();

        $query = 'SELECT `id`, `changeset`, `system`, `number`
                  FROM ' . Database::TABLE_TRACKING_ID . '
                  WHERE `changeset` = :changeset
                        AND `system` = :system
                        AND `number` = :number';
        $statement = $dbHandle->prepare($query);

        $statement->bindParam(':changeset', $changeSetId, \PDO::PARAM_INT);
        $statement->bindParam(':system', $system, \PDO::PARAM_INT);
        $statement->bindParam(':number', $trackingId, \PDO::PARAM_STR);
        $executeResult = $statement->execute();

        $statement = $this->getDatabase()->checkQueryError($statement, $executeResult);
        return $statement->fetch(\PDO::FETCH_ASSOC);
    }
protected function getGerritTrackingIdByIdentifier($changeSetId, $system, $trackingId)
    {
        $dbHandle = $this->getDatabase()->getDatabaseConnection();

        $query = 'SELECT `id`, `changeset`, `system`, `number`
                  FROM ' . Database::TABLE_TRACKING_ID . '
                  WHERE `changeset` = :changeset
                        AND `system` = :system
                        AND `number` = :number';
        $statement = $dbHandle->prepare($query);

        $statement->bindParam(':changeset', $changeSetId, \PDO::PARAM_INT);
        $statement->bindParam(':system', $system, \PDO::PARAM_INT);
        $statement->bindParam(':number', $trackingId, \PDO::PARAM_STR);
        $executeResult = $statement->execute();

        $statement = $this->getDatabase()->checkQueryError($statement, $executeResult);
        return $statement->fetch(\PDO::FETCH_ASSOC);
    }
protected function getGerritTrackingIdByIdentifier ( $ changeSetId , $ system , $ trackingId ) { $ dbHandle = $ this -> getDatabase ( ) -> getDatabaseConnection ( ) ; $ query = 'SELECT `id`, `changeset`, `system`, `number`
                  FROM ' . Database :: TABLE_TRACKING_ID . '
                  WHERE `changeset` = :changeset
                        AND `system` = :system
                        AND `number` = :number' ; $ statement = $ dbHandle -> prepare ( $ query ) ; $ statement -> bindParam ( ':changeset' , $ changeSetId , \ PDO :: PARAM_INT ) ; $ statement -> bindParam ( ':system' , $ system , \ PDO :: PARAM_INT ) ; $ statement -> bindParam ( ':number' , $ trackingId , \ PDO :: PARAM_STR ) ; $ executeResult = $ statement -> execute ( ) ; $ statement = $ this -> getDatabase ( ) -> checkQueryError ( $ statement , $ executeResult ) ; return $ statement -> fetch ( \ PDO :: FETCH_ASSOC ) ; }
Returns a tracking id by the unique identifier

@param int $changeSetId ID of a record from the changeset table
@param int $system ID of a record from the system table
@param string $trackingId Tracking id
@return mixed
Returns a tracking id by the unique identifier