ezsystems / ezpublish-kernel

     * @param string $textMD5

     * @param array $values associative array with column names as keys and column values as values

     */

    public function updateRow($parentId, $textMD5, array $values)

    {

        /** @var $query \eZ\Publish\Core\Persistence\Database\UpdateQuery */

        $query = $this->dbHandler->createUpdateQuery();

        $query->update($this->dbHandler->quoteTable('ezurlalias_ml'));

        $this->setQueryValues($query, $values);

        $query->where(

            $query->expr->lAnd(

                $query->expr->eq(

                    $this->dbHandler->quoteColumn('parent'),

                    $query->bindValue($parentId, null, \PDO::PARAM_INT)

                ),

                $query->expr->eq(

                    $this->dbHandler->quoteColumn('text_md5'),

                    $query->bindValue($textMD5, null, \PDO::PARAM_STR)

                )

            )

        );

        $query->prepare()->execute();

    }

    /**

     * Inserts new row in urlalias_ml table.

     *

     * @return array

     */

    public function loadRow($parentId, $textMD5)

    {

        /** @var $query \eZ\Publish\Core\Persistence\Database\SelectQuery */

        $query = $this->dbHandler->createSelectQuery();

        $query->select('*')->from(

            $this->dbHandler->quoteTable('ezurlalias_ml')

        )->where(

            $query->expr->lAnd(

                $query->expr->eq(

                    $this->dbHandler->quoteColumn('parent'),

                    $query->bindValue($parentId, null, \PDO::PARAM_INT)

                ),

                $query->expr->eq(

                    $this->dbHandler->quoteColumn('text_md5'),

                    $query->bindValue($textMD5, null, \PDO::PARAM_STR)

                )

            )

        );

        $statement = $query->prepare();

        $statement->execute();

        return $statement->fetch(\PDO::FETCH_ASSOC);

    }

    /**

     * Loads complete URL alias data by given array of path hashes.