ezsystems / ezpublish-kernel

     *

     * @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.

     *

     * @param int $id

     */

    public function deleteSection($id)

    {

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

        $query->deleteFrom(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

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

    }

    /**

     * Inserts the assignment of $contentId to $sectionId.

     *

     * @param int $id

     */

    public function deleteLanguage($id)

    {

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

        $query->deleteFrom(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

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

    }

    /**

     * Check whether a language may be deleted.

     *

     * @param int $stateId

     */

    public function deleteObjectStateLinks($stateId)

    {

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

        $query->deleteFrom(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

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

    }

    /**

     * Inserts a new object state group into database.

     *

     * @param mixed $stateId

     */

    protected function deleteObjectStateTranslations($stateId)

    {

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

        $query->deleteFrom(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

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

    }

    /**

     * Inserts object state group translations into database.

     *

     * @param mixed $groupId

     */

    protected function deleteObjectStateGroupTranslations($groupId)

    {

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

        $query->deleteFrom(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

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

    }

    /**

     * Generates language mask from provided language codes

     *

     * @param int $groupId

     */

    public function deleteGroup($groupId)

    {

        $q = $this->dbHandler->createDeleteQuery();

        $q->deleteFrom($this->dbHandler->quoteTable('ezcontentclassgroup'))

            ->where(

                $q->expr->eq(

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

                    $q->bindValue($groupId, null, \PDO::PARAM_INT)

                )

            );

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

    }

    /**

     * Inserts data into contentclass_name.

     *

     * @param mixed $id

     */

    public function deleteUrlWildcard($id)

    {

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

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

        $query->deleteFrom(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

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

    }

    /**

     * Loads an array with data about UrlWildcard with $id.

     *

     * @param int $fieldId

     */

    public function deleteField($fieldId)

    {

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

        $query->deleteFrom(

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

        )->where(

            $query->expr->eq(

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

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

            )

        );

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

    }

    /**

     * Deletes all fields of $contentId in all versions.

     *

     * @param int $contentId

     */

    public function deleteContent($contentId)

    {

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

        $query->deleteFrom('ezcontentobject')

            ->where(

                $query->expr->eq(

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

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

                )

            );

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

    }

    /**

     * Loads relations from $contentId to published content, optionally only from $contentVersionNo.

     * @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.