ezsystems / ezpublish-kernel

     * @param mixed $typeId

     * @param int $status

     */

    public function deleteGroupAssignment($groupId, $typeId, $status)

    {

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

        $q->deleteFrom(

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

        )->where(

            $q->expr->lAnd(

                $q->expr->eq(

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

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

                ),

                $q->expr->eq(

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

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

                ),

                $q->expr->eq(

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

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

                )

            )

        );

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

    }

    /**

     * Loads data about Group with $groupId.

     * @param int $status

     * @param mixed $fieldDefinitionId

     */

    public function deleteFieldDefinition($typeId, $status, $fieldDefinitionId)

    {

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

        $q->deleteFrom(

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

        )->where(

            $q->expr->lAnd(

                $q->expr->eq(

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

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

                ),

                $q->expr->eq(

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

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

                ),

                // @todo FIXME: Actually not needed

                $q->expr->eq(

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

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

                )

            )

        );

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

    }

    /**

     * Updates a $fieldDefinition for $typeId.

     * @param \eZ\Publish\SPI\Persistence\Content\Type\FieldDefinition $fieldDefinition

     * @param \eZ\Publish\Core\Persistence\Legacy\Content\StorageFieldDefinition $storageFieldDef

     */

    public function updateFieldDefinition(

        $typeId,

        $status,

        FieldDefinition $fieldDefinition,

        StorageFieldDefinition $storageFieldDef

    ) {

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

        $q

            ->update(

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

            )->where(

                $q->expr->eq(

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

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

                ),

                $q->expr->eq(

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

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

                ),

                // @todo FIXME: Actually not needed

                $q->expr->eq(

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

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

                )

            );

        $this->setCommonFieldColumns($q, $fieldDefinition, $storageFieldDef);

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

    }

    /**

     * Deletes all name data for $typeId in $typeStatus.

     * @param mixed $oldParentId

     * @param mixed $newParentId

     */

    public function reparent($oldParentId, $newParentId)

    {

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

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

        $query->update(

            $this->dbHandler->quoteTable($this->table)

        )->set(

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

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

        )->where(

            $query->expr->lAnd(

                $query->expr->eq(

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

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

                ),

                $query->expr->eq(

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

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

                )

            )

        );

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

    }

    /**

     * Updates single row data matched by composite primary key.

     *

     * @return bool

     */

    public function removeCustomAlias($parentId, $textMD5)

    {

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

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

        $query->deleteFrom(

            $this->dbHandler->quoteTable($this->table)

        )->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->expr->eq(

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

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

                )

            )

        );

        $statement = $query->prepare();

        $statement->execute();

        return $statement->rowCount() === 1 ?: false;

    }

    /**

     * Deletes all rows with given $action and optionally $id.

     *

     * @return bool

     */

    public function remove($action, $id = null)

    {

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

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

        $query->deleteFrom(

            $this->dbHandler->quoteTable($this->table)

        )->where(

            $query->expr->eq(

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

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

            )

        );

        if ($id !== null) {

            $query->where(

                $query->expr->lAnd(

                    $query->expr->eq(

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

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

                    ),

                    $query->expr->eq(

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

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

                    )

                )

            );

        }

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

    }

    /**

     * Loads all autogenerated entries with given $parentId with optionally included history entries.