我正在努力学习 Symfony。今天我正在关注关联教程。我决定制作一个小应用程序,包括房屋、厨房、卧室和橱柜。我(尝试;-))使用draw.io制作一个小的类图,以便为您提供更好的想法。
所以基本上一栋房子可以有多个卧室和多个厨房。每个厨房可以有多个橱柜。 House 有一个 id 和一个名称。卧室和厨房也是如此。柜子有 id、shopUrl,也通过外键链接(account_id
) 到其父厨房。
我还使用外键将厨房和卧室链接到房子(house_id
)。所以我按照教程创建了House
entity:
<?php
namespace App\Entity;
use Doctrine\ORM\Mapping as ORM;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\Common\Collections\Collection;
/**
* @ORM\Entity(repositoryClass="App\Repository\HouseRepository")
*/
class House implements \JsonSerializable
{
/**
* @ORM\OneToMany(targetEntity="App\Entity\Kitchen", mappedBy="house")
*/
private $kitchen;
/**
* @ORM\OneToMany(targetEntity="App\Entity\Bedroom", mappedBy="house")
*/
private $bedroom;
/**
* House constructor
*/
public function __construct()
{
$this->kitchen = new ArrayCollection();
$this->bedroom = new ArrayCollection();
}
/**
* @return Collection|Kitchen[]
*/
public function getKitchen(): Collection
{
return $this->kitchen;
}
/**
* @return Collection|Bedroom[]
*/
public function getBedroom(): Collection
{
return $this->bedroom;
}
/**
* @ORM\Id()
* @ORM\GeneratedValue()
* @ORM\Column(type="integer")
*/
private $id;
/**
* @ORM\Column(type="string", length=255)
*/
private $name;
public function getId(): ?int
{
return $this->id;
}
public function getName(): ?string
{
return $this->name;
}
public function setName(string $name): self
{
$this->name = $name;
return $this;
}
public function jsonSerialize()
{
return get_object_vars($this);
}
}
House 存储库是空的(又名:仅包含 Symfony 自动生成的代码):
<?php
namespace App\Repository;
use App\Entity\House;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Symfony\Bridge\Doctrine\RegistryInterface;
/**
* @method House|null find($id, $lockMode = null, $lockVersion = null)
* @method House|null findOneBy(array $criteria, array $orderBy = null)
* @method House[] findAll()
* @method House[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
*/
class HouseRepository extends ServiceEntityRepository
{
public function __construct(RegistryInterface $registry)
{
parent::__construct($registry, House::class);
}
}
The Bedroom
实体是这样的:
<?php
namespace App\Entity;
use Doctrine\ORM\Mapping as ORM;
/**
* @ORM\Entity(repositoryClass="App\Repository\BedroomRepository")
*/
class Bedroom implements \JsonSerializable
{
/**
* @ORM\ManyToOne(targetEntity="App\Entity\House", inversedBy="bedroom")
*/
private $house;
public function getHouse(): House
{
return $this->house;
}
public function setHouse(House $house): self
{
$this->house = $house;
return $this;
}
/**
* @ORM\Id()
* @ORM\GeneratedValue()
* @ORM\Column(type="integer")
*/
private $id;
/**
* @ORM\Column(type="string", length=255)
*/
private $name;
public function getId(): ?int
{
return $this->id;
}
public function getName(): ?string
{
return $this->name;
}
public function setName(string $name): self
{
$this->name = $name;
return $this;
}
public function jsonSerialize()
{
return get_object_vars($this);
}
}
卧室存储库也是空的。
The Kitchen
实体有以下代码:
<?php
namespace App\Entity;
use Doctrine\ORM\Mapping as ORM;
/**
* @ORM\Entity(repositoryClass="App\Repository\KitchenRepository")
*/
class Kitchen implements \JsonSerializable
{
/**
* @ORM\OneToMany(targetEntity="App\Entity\Cabinet", mappedBy="kitchen")
*/
private $cabinet;
/**
* Kitchen constructor
*/
public function __construct()
{
$this->cabinet= new ArrayCollection();
}
/**
* @return Collection|Cabinet[]
*/
public function getCabinet(): Collection
{
return $this->cabinet;
}
/**
* @ORM\ManyToOne(targetEntity="App\Entity\House", inversedBy="kitchen")
*/
private $house;
public function getHouse(): House
{
return $this->house;
}
public function setHouse(House $house): self
{
$this->house = $house;
return $this;
}
/**
* @ORM\Id()
* @ORM\GeneratedValue(strategy="UUID")
* @ORM\Column(type="integer")
*/
private $id;
/**
* @ORM\Column(type="string", length=255)
*/
private $name;
public function getId(): int
{
return $this->id;
}
public function getName(): string
{
return $this->name;
}
public function setName(string $name): self
{
$this->name = $name;
return $this;
}
public function jsonSerialize()
{
return get_object_vars($this);
}
}
厨房存储库也是空的。
最后,cabinet
由以下部分组成:
<?php
namespace App\Entity;
use DateTime;
use Doctrine\ORM\Mapping as ORM;
/**
* @ORM\Entity(repositoryClass="App\Repository\CabinetRepository")
*/
class Cabinet
{
/**
* @ORM\Id()
* @ORM\GeneratedValue()
* @ORM\Column(type="integer")
*/
private $id;
/**
* @ORM\Column(type="string", length=255)
*/
private $shopUrl;
private $account_id;
/**
* @ORM\ManyToOne(targetEntity="Kitchen", inversedBy="cabinet")
*/
private $kitchen;
/**
* Cabinet constructor.
* @param string $shopUrl
* @param Kitchen $kitchen
* @param int $id
*/
public function __construct(string $shopUrl, Kitchen $kitchen = null, int $id = null)
{
$this->shopUrl = $shopUrl;
$this->kitchen = $kitchen;
$this->id = $id;
}
public function setId(int $id): self
{
$this->id = $id;
return $this;
}
public function getId(): int
{
return $this->id;
}
public function getShopUrl(): string
{
return $this->shopUrl;
}
public function getKitchen(): Kitchen
{
return $this->kitchen;
}
public function setKitchen(Kitchen $kitchen): self
{
$this->kitchen = $kitchen;
$this->account_id = $kitchen->getId();
return $this;
}
public function setAccount_id(int $account_id): self
{
$this->account_id = $account_id;
return $this;
}
public function getAccount_id(): int
{
return $this->account_id;
}
}
与其他实体相比,内阁有一些逻辑(这是我真正需要帮助的地方)。由于卧室和厨房与房屋相关联,我想给出一个卧室,然后查找与卧室相同的房屋关联的所有厨房,然后返回这些厨房拥有的所有橱柜。我知道这可能看起来不合逻辑,但我发现这一点为时已晚,无法提出另一个概念。我当前的代码不起作用,因为我不确定这是否可能,而且因为它对我来说有点太复杂了,目前无法掌握。但我将其作为内阁回购的内容:
<?php
namespace App\Repository;
use App\Entity\Bedroom;
use App\Entity\House;
use App\Entity\Cabinet;
use App\Entity\Kitchen;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Symfony\Bridge\Doctrine\RegistryInterface;
/**
* @method Cabinet|null find($id, $lockMode = null, $lockVersion = null)
* @method Cabinet|null findOneBy(array $criteria, array $orderBy = null)
* @method Cabinet[] findAll()
* @method Cabinet[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
*/
class CabinetRepository extends ServiceEntityRepository
{
public function __construct(RegistryInterface $registry)
{
parent::__construct($registry, Cabinet::class);
}
public function findByBedroom(Bedroom $bedroom) //use joins??
{
return $this->createQueryBuilder('cabinet')
->join('cabinet.bedroom', 'bedroom')
->join('cabinet.kitchen', 'kitchen')
->addSelect('cabinet')
->andWhere('cabinet.bedroom = :idBedroom')
->setParameter('idBedroom', $bedroom->getId())
->orderBy('time', 'ASC')
->getQuery()
->getResult();
}
}
我正在使用 PHPStorm,并且没有任何错误显示,但是当然,查询生成器不会返回任何内容。我该如何修复它?我找不到任何试图实现我想做的事情的问题。
我手动将数据添加到数据库中,所以里面有数据。使用 Sequel Pro 我可以看到这些关系。数据(就我而言)很好。 queryBuilder 就是错误所在。
带有一些数据的演示示例:
这是卧室数据:
id name house_id
325 bigBedroomOne 1666
815 smallBedroomOne 555
902 bigBedroomTwo 1666
这是众议院数据:
id name
1666 bigHouse
555 smallHouse
这是厨房数据:
id name house_id
1 bigKitchen 1666
2 smallKitchen 555
55 mediumKitchen 555
最后,这是机柜数据:
id shopUrl account_id
1 ur.l 55
88 co.m 2
33 ne.t 1
所以在这个例子中我想插入卧室 ID815
与 house_id 相关联555
。然后从那里应该选择与该 house_id 关联的所有厨房,所以2
and 55
。最后,带有 id 的柜子1
and 88
应该被退回。
编辑:运行时bin/console doc:sch:val
我得到这个回来:
`Mapping
[确定] 映射文件正确。
Database
[确定] 数据库架构与映射文件同步。