lechimp-p / dicto.php

     * @param   Variable $var

     * @return  int|null

     */

    protected function variable_id(Variable $var) {

        $res = $this->builder()

            ->select("id")

            ->from("variables")

            ->where($this->builder()->expr()->andX

                ( "name = ?"

                , "meaning = ?"

                ))

            ->setParameter(0, $var->name())

            ->setParameter(1, $var->meaning())

            ->execute()

            ->fetch();

        if ($res) {

            return (int)$res["id"];

        }

        else {

            return null;

        }

    }

    protected function upsert_variable(Variable $var) {

        $var_id = $this->variable_id($var);

     * @param   Violation   $violation

     * @return  int|null

     */

    protected function violation_id(Violation $violation) {

        $res = $this->builder()

            ->select("id")

            ->from("violations")

            ->where($this->builder()->expr()->andX

                ( "rule_id = ?"

                , "file = ?"

                , "line = ?"

                ))

            ->setParameter(0, $this->current_rule_id)

            ->setParameter(1, $violation->filename())

            ->setParameter(2, $violation->line())

            ->execute()

            ->fetch();

        if ($res) {

            return (int)$res["id"];

        }

        else {

            return null;

        }

    }

    // Creation of database.