ezsystems / ezpublish-kernel

     * @param mixed $contentId

     * @param mixed $versionNo

     */

    public function updateLocationsContentVersionNo($contentId, $versionNo)

    {

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

        $query->update(

            $this->handler->quoteTable('ezcontentobject_tree')

        )->set(

            $this->handler->quoteColumn('contentobject_version'),

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

        )->where(

            $query->expr->eq(

                $this->handler->quoteColumn('contentobject_id'),

                $contentId

            )

        );

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

    }

    /**

     * Searches for the main nodeId of $contentId in $versionId.

     *

     * @return string[][]

     */

    public function loadAllSectionData()

    {

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

        $query->select(

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

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

            $this->dbHandler->quoteColumn('name')

        )->from(

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

        );

        $statement = $query->prepare();

        $statement->execute();

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

    }

    /**

     * Loads data for section with $identifier.