首页 > 解决方案 > 注意:Symfony 中的数组到字符串的转换

问题描述

我的代码有问题。我有一个实体:

    namespace CP\API\Entity;

    use CP\Model\Configuration;
    use CP\Model\Content;
    use CP\Model\Language;
    use CP\Model\MenuTranslation;
    use CP\RestBundle\Model\Locator;
    use Doctrine\ORM\Mapping as ORM;
    use Doctrine\Common\Collections\ArrayCollection;


    /**
     * @ORM\HasLifecycleCallbacks()
     * @ORM\Table(name="cp_menu")
     * @ORM\Entity(repositoryClass="CP\API\Repository\MenuRepository")
     */
    class Menu
    {
        /**
         * @var int
         *
         * @ORM\Id()
         * @ORM\Column(type="integer")
         * @ORM\GeneratedValue(strategy="AUTO")
         */
        protected $id;

        /**
         * @var Locator
         *
         * @ORM\ManyToOne(targetEntity="Locator", cascade={"persist"})
         * @ORM\JoinColumn(name="locator_id", referencedColumnName="id", onDelete="SET NULL")
         */
        protected $locator;

        /**
         * Parent Menu
         *
         * @ORM\ManyToOne(targetEntity="Menu", inversedBy="children", cascade={"persist"})
         * @ORM\JoinColumn(name="parent_id", referencedColumnName="id", onDelete="SET NULL")
         */
        protected $parent;

        /**
         * @ORM\ManyToOne(targetEntity="DataPool",cascade={"persist"})
         * @ORM\JoinColumn(name="datapool_id", referencedColumnName="id", onDelete="SET NULL")
         */
        protected $dataPool;

        /**
         * @ORM\ManyToOne(targetEntity="Product")
         * @ORM\JoinColumn(name="product_id", referencedColumnName="id", nullable=true)
         */
        protected $product;

        /**
         * @var string
         *
         * @ORM\Column(name="identifier", type="string", nullable=true)
         */
        protected $identifier;

        /**
         * @var array
         *
         * @ORM\Column(name="data", type="text", length=65535)
         */
        protected $data = [];

        /**
         * @var boolean
         *
         * @ORM\Column(name="display", type="boolean")
         */
        protected $display;

        /**
         * @var boolean
         *
         * @ORM\Column(name="display_children", type="boolean")
         */
        protected $displayChildren;

        /**
         * @var string
         *
         * @ORM\Column(name="path_string", type="string", nullable=false)
         */
        protected $pathString;

        /**
         * @var int
         *
         * @ORM\Column(name="priority", type="integer")
         */
        protected $priority;

        /**
         * @var int
         *
         * @ORM\Column(name="status", type="smallint", length=1)
         */
        protected $status;

        /**
         * @var boolean
         *
         * @ORM\Column(name="produce", type="boolean")
         */
        protected $produce = false;

        /**
         * @var int
         *
         * @ORM\Column(name="inheritance_priority", type="integer", nullable=false, options={"default" : 0})
         */
        protected $inheritancePriority;

        /** @var DateTime */
        protected $creation;

        /** @var DateTime */
        protected $modification;

        /**
         * @return int
         */
        public function getId(): int
        {
            return $this->id;
        }

        /**
         * @param int $id
         */
        public function setId(int $id): void
        {
            $this->id = $id;
        }

        /**
         * @return Locator
         */
        public function getLocator(): Locator
        {
            return $this->locator;
        }

        /**
         * @param Locator $locator
         */
        public function setLocator(Locator $locator): void
        {
            $this->locator = $locator;
        }

        /**
         * @return mixed
         */
        public function getParent()
        {
            return $this->parent;
        }

        /**
         * @param mixed $parent
         */
        public function setParent($parent): void
        {
            $this->parent = $parent;
        }

        /**
         * @return mixed
         */
        public function getDataPool()
        {
            return $this->dataPool;
        }

        /**
         * @param mixed $dataPool
         */
        public function setDataPool($dataPool): void
        {
            $this->dataPool = $dataPool;
        }

        /**
         * @return mixed
         */
        public function getProduct()
        {
            return $this->product;
        }

        /**
         * @param mixed $product
         */
        public function setProduct($product): void
        {
            $this->product = $product;
        }

        /**
         * @return string
         */
        public function getIdentifier(): string
        {
            return $this->identifier;
        }

        /**
         * @param string $identifier
         */
        public function setIdentifier(string $identifier): void
        {
            $this->identifier = $identifier;
        }

        /**
         * @return array
         */
        public function getData(): array
        {
            return $this->data;
        }

        /**
         * @param array $data
         */
        public function setData(array $data)
        {
            $this->data = $data;
        }

        /**
         * @return bool
         */
        public function isDisplay(): bool
        {
            return $this->display;
        }

        /**
         * @param bool $display
         */
        public function setDisplay(bool $display): void
        {
            $this->display = $display;
        }

        /**
         * @return bool
         */
        public function isDisplayChildren(): bool
        {
            return $this->displayChildren;
        }

        /**
         * @param bool $displayChildren
         */
        public function setDisplayChildren(bool $displayChildren): void
        {
            $this->displayChildren = $displayChildren;
        }

        /**
         * @return string
         */
        public function getPathString(): string
        {
            return $this->pathString;
        }

        /**
         * @param string $pathString
         */
        public function setPathString(string $pathString): void
        {
            $this->pathString = $pathString;
        }

        /**
         * @return int
         */
        public function getPriority(): int
        {
            return $this->priority;
        }

        /**
         * @param int $priority
         */
        public function setPriority(int $priority): void
        {
            $this->priority = $priority;
        }

        /**
         * @return int
         */
        public function getStatus(): int
        {
            return $this->status;
        }

        /**
         * @param int $status
         */
        public function setStatus(int $status): void
        {
            $this->status = $status;
        }

        /**
         * @return bool
         */
        public function isProduce(): bool
        {
            return $this->produce;
        }

        /**
         * @param bool $produce
         */
        public function setProduce(bool $produce): void
        {
            $this->produce = $produce;
        }

        /**
         * @return int
         */
        public function getInheritancePriority(): int
        {
            return $this->inheritancePriority;
        }

        /**
         * @param int $inheritancePriority
         */
        public function setInheritancePriority(int $inheritancePriority): void
        {
            $this->inheritancePriority = $inheritancePriority;
        }

        /**
         * @return DateTime
         */
        public function getCreation(): DateTime
        {
            return $this->creation;
        }

        /**
         * @param DateTime $creation
         */
        public function setCreation(DateTime $creation): void
        {
            $this->creation = $creation;
        }

        /**
         * @return DateTime
         */
        public function getModification(): DateTime
        {
            return $this->modification;
        }

        /**
         * @param DateTime $modification
         */
        public function setModification(DateTime $modification): void
        {
            $this->modification = $modification;
        }


    }

和我的方法MenuRepository

    /**
         * @param Menu $menu
         * @return mixed
         */
        public function addMenu(Menu $menu)
        {
            try {

                $this->getEntityManager()->beginTransaction(); // suspend auto-commit
                $this->getEntityManager()->persist($menu);
                $this->getEntityManager()->flush($menu);
                $this->getEntityManager()->commit();


                $this->getEntityManager()->detach($menu);


                return $menu;
            } catch (\Exception $e) {
                throw new RepositoryException($e->getMessage());
            }

当我向数据库添加新记录时,出现错误:

在 MenuRepository.php 第 79 行:
注意:数组到字符串的转换

第 79 行是:

    throw new RepositoryException($e->getMessage());

我添加新记录的命令代码:

    $menuData = new Menu();
    $menuData->setStatus(1);
    $menuData->setData([]);
    $dataPool = new DataPoolEntity();
    $dataPool->setIsReadonly(true);
    $dataPool->setName("qwerty");
    $dataPool->setDescription("tester");
    $dataPool->setChildren(null);
    $menuData->setDataPool($dataPool);
    $menuData->setPathString('qwertty');
    $menuData->setPriority(1);
    $menuData->setDisplayChildren(true);
    $menuData->setDisplay(true);
    $menuData->setIdentifier("qwery");
    $menuData->setInheritancePriority(1);

在我的 var.log 我有这个消息:

[2019-12-21T20:35:49.313897+01:00] console.ERROR:运行命令“sdk:menu:create -vvvvv”时抛出错误。消息:“注意:数组到字符串的转换”{“异常”:“[object](CP\Model\Exception\RepositoryException(代码:0):注意:数组到字符串的转换在 C:\Users\rever\PhpstormProjects\cp -base\vendor\cp\web-core\src\Model\Repository\MenuRepository.php:79)","command":"sdk:menu:create -vvvvv","message":"注意:数组到字符串的转换"} []

我不知道我的代码有什么问题:( 几个小时以来,我一直在寻找错误的原因,但我无法处理它,这就是我写的原因。我已经尝试过严格地添加一些价值,但它会给出同样的问题。

标签: phpsymfonysymfony4

解决方案


您的数据在您的实体中定义如下:

/**
 * @var array
 *
 * @ORM\Column(name="data", type="text", length=65535)
 */
protected $data = [];

但是在您@var指定的 中array,因此您可以将列类型更改为array

/**
 *
 * @ORM\Column(name="data", type="array")
 */
protected $data = [];

这将产生一个带有注释“(DC2Type:array)”的长文本字段,因此 Doctrine 知道如何处理它。它将存储一个序列化的数组。


推荐阅读