ezsystems / ezpublish-kernel

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

     *

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