php - Doctrine :多重 inversedBy 关系

Question

我有以下关系表:

我的目标是从表 [Resident] 中检索所有居民。以下是我的代码:

public function getAllResidents(){
    $all_resident = $this->resident_repo->getAll(); //!!error thrown from here!!
}

public function getAll(){
    return $this->findAll();
}

我得到的错误信息是:

A PHP Error was encountered
Severity: Warning

Message: 
 require(/Applications/MAMP/htdocs/Final_Project/a18ux06/application/models/Proxies/__CG__EntityDoctor.php):
 failed to open stream: No such file or directory

 Filename: Proxy/AbstractProxyFactory.php

 Line Number: 209

 Backtrace:

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php
 Line: 209 Function: _error_handler

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php
 Line: 209 Function: require

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php
 Line: 119 Function: getProxyDefinition

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php
 Line: 2707 Function: getProxy

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/SimpleObjectHydrator.php
 Line: 147 Function: createEntity

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/SimpleObjectHydrator.php
 Line: 69 Function: hydrateRowData

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/AbstractHydrator.php
 Line: 150 Function: hydrateAllData

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php
 Line: 888 Function: hydrateAll

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php
 Line: 181 Function: loadAll

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php
 Line: 164 Function: findBy

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/application/models/Repository/ResidentRepository.php
 Line: 13 Function: findAll

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/application/controllers/ModelTest.php
 Line: 69 Function: getAllResident

 File:
 /Applications/MAMP/htdocs/Final_Project/a18ux06/application/controllers/ModelTest.php
 Line: 21 Function: getAllResidents

 File: /Applications/MAMP/htdocs/Final_Project/a18ux06/index.php Line:
 315 Function: require_once


 Fatal error: require(): Failed opening required
 '/Applications/MAMP/htdocs/Final_Project/a18ux06/application/models/Proxies/__CG__EntityDoctor.php'
 (include_path='.:/Applications/MAMP/bin/php/php7.2.8/lib/php') in
 /Applications/MAMP/htdocs/Final_Project/a18ux06/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php
 on line 209 A PHP Error was encountered

 Severity: Compile Error

 Message: require(): Failed opening required
 '/Applications/MAMP/htdocs/Final_Project/a18ux06/application/models/Proxies/__CG__EntityDoctor.php'
 (include_path='.:/Applications/MAMP/bin/php/php7.2.8/lib/php')

 Filename: Proxy/AbstractProxyFactory.php

 Line Number: 209

 Backtrace:

我不确定问题出在哪里 - 我刚开始学习 Doctrine 。是因为我的 [Resident] 表与表 [building and doctor] 有 [2 many to one] 关系又名 [2 inversedBy] 吗？

我已经卡在这里一整天了!快速帮助或引用我可以做什么将非常有帮助。如果需要额外的东西，请告诉我。

Answer 1

似乎 Doctrin 的默认查询函数在它们可以做的事情上是有限的。所以我不得不编写自己的自定义低级 SQL 查询，而不是尝试使用 Doctrine 默认的 find、find_by 等。

有些地方我使用了 QueryBuilder，有些地方使用了普通的 SQL 查询。