Yproximite / PRReviewWatcher

     *

     * @return \Doctrine\DBAL\Driver\Statement|mixed

     */

    public function findToken($repoHook, $branchHook)

    {

        if ($branchHook == null) {

            $sql    = "SELECT token FROM credential AS c JOIN project AS P ON c.idcred = p.credential WHERE p.name = :name AND p.branch = 'all';";

            $result = $this->db->prepare($sql);

            $result->bindValue(':name', $repoHook);

        } else {

            $sql    = "SELECT token FROM credential AS c JOIN project AS P ON c.idcred = p.credential WHERE p.name = :name AND p.branch = :branch;";

            $result = $this->db->prepare($sql);

            $result->bindValue(':name', $repoHook);

            $result->bindValue(':branch', $branchHook);

        }

        $result->execute();

        $result = $result->fetch();

        $result = $result['token'];

        return $result;

    }

    /**

     * @param $repoHook

     *

     * @return \Doctrine\DBAL\Driver\Statement|mixed

     */

    public function findComment($repoHook, $branchHook)

    {

        if ($branchHook == null) {

            $sql    = 'SELECT comment FROM project WHERE name = :name AND alive = 1;';

            $result = $this->db->prepare($sql);

            $result->bindValue(':name', $repoHook);

        } else {

            $sql    = 'SELECT comment FROM project WHERE name = :name AND branch = :branch AND alive = 1';

            $result = $this->db->prepare($sql);

            $result->bindValue(':name', $repoHook);

            $result->bindValue(':branch', $branchHook);

        }

        $result->execute();

        $result = $result->fetch();

        $result = $result['comment'];

        return $result;

    }

    /**

     * @param $repoHook

     *

     * @return \Doctrine\DBAL\Driver\Statement|mixed

     */

    public function findId($repoHook, $branchHook)

    {

        if ($branchHook == null) {

            $sql    = "SELECT id FROM project AS p , credential AS c WHERE name = :name AND branch = 'all';";

            $result = $this->db->prepare($sql);

            $result->bindValue(':name', $repoHook);

        } else {

            $sql    = "SELECT id FROM project AS p , credential AS c WHERE name = :name AND branch = :branch;";

            $result = $this->db->prepare($sql);

            $result->bindValue(':name', $repoHook);

            $result->bindValue(':branch', $branchHook);

        }

        $result->execute();

        $result = $result->fetch();

        $result = $result['id'];

        return $result;

    }

    /**

     * @param $id