protected function getGerritFileCommentByIdentifier($patchSetId, $file, $line, $reviewer, $messageCrc32)
    {
        $dbHandle = $this->getDatabase()->getDatabaseConnection();

        $query = 'SELECT `id`, `patchset`, `file`, `line`, `reviewer`, `message`
                  FROM ' . Database::TABLE_FILE_COMMENTS . '
                  WHERE `patchset` = :patchset
                        AND `file` = :file
                        AND `line` = :line
                        AND `reviewer` = :reviewer
                        AND `message_crc32` = :message_crc32';
        $statement = $dbHandle->prepare($query);

        $statement->bindParam(':patchset', $patchSetId, \PDO::PARAM_INT);
        $statement->bindParam(':file', $file, \PDO::PARAM_INT);
        $statement->bindParam(':line', $line, \PDO::PARAM_INT);
        $statement->bindParam(':reviewer', $reviewer, \PDO::PARAM_INT);
        $statement->bindParam(':message_crc32', $messageCrc32, \PDO::PARAM_INT);
        $executeResult = $statement->execute();

        $statement = $this->getDatabase()->checkQueryError($statement, $executeResult);
        return $statement->fetch(\PDO::FETCH_ASSOC);
    }
protected function getGerritFileCommentByIdentifier($patchSetId, $file, $line, $reviewer, $messageCrc32)
    {
        $dbHandle = $this->getDatabase()->getDatabaseConnection();

        $query = 'SELECT `id`, `patchset`, `file`, `line`, `reviewer`, `message`
                  FROM ' . Database::TABLE_FILE_COMMENTS . '
                  WHERE `patchset` = :patchset
                        AND `file` = :file
                        AND `line` = :line
                        AND `reviewer` = :reviewer
                        AND `message_crc32` = :message_crc32';
        $statement = $dbHandle->prepare($query);

        $statement->bindParam(':patchset', $patchSetId, \PDO::PARAM_INT);
        $statement->bindParam(':file', $file, \PDO::PARAM_INT);
        $statement->bindParam(':line', $line, \PDO::PARAM_INT);
        $statement->bindParam(':reviewer', $reviewer, \PDO::PARAM_INT);
        $statement->bindParam(':message_crc32', $messageCrc32, \PDO::PARAM_INT);
        $executeResult = $statement->execute();

        $statement = $this->getDatabase()->checkQueryError($statement, $executeResult);
        return $statement->fetch(\PDO::FETCH_ASSOC);
    }
protected function getGerritFileCommentByIdentifier ( $ patchSetId , $ file , $ line , $ reviewer , $ messageCrc32 ) { $ dbHandle = $ this -> getDatabase ( ) -> getDatabaseConnection ( ) ; $ query = 'SELECT `id`, `patchset`, `file`, `line`, `reviewer`, `message`
                  FROM ' . Database :: TABLE_FILE_COMMENTS . '
                  WHERE `patchset` = :patchset
                        AND `file` = :file
                        AND `line` = :line
                        AND `reviewer` = :reviewer
                        AND `message_crc32` = :message_crc32' ; $ statement = $ dbHandle -> prepare ( $ query ) ; $ statement -> bindParam ( ':patchset' , $ patchSetId , \ PDO :: PARAM_INT ) ; $ statement -> bindParam ( ':file' , $ file , \ PDO :: PARAM_INT ) ; $ statement -> bindParam ( ':line' , $ line , \ PDO :: PARAM_INT ) ; $ statement -> bindParam ( ':reviewer' , $ reviewer , \ PDO :: PARAM_INT ) ; $ statement -> bindParam ( ':message_crc32' , $ messageCrc32 , \ PDO :: PARAM_INT ) ; $ executeResult = $ statement -> execute ( ) ; $ statement = $ this -> getDatabase ( ) -> checkQueryError ( $ statement , $ executeResult ) ; return $ statement -> fetch ( \ PDO :: FETCH_ASSOC ) ; }
Returns a file comment by unique identifier

@param int $patchSetId Unique identifier of a patchset
@param int $file Unique identifier of a file
@param int $line Line no of file
@param int $reviewer Unique identifier of the reviewer (person)
@param int $messageCrc32 CRC32 of the comment
@return mixed
Returns a file comment by unique identifier