我目前在教义水合方面遇到了一些问题。我正在使用 ZF2 来构建 API,因此我需要构建一些使用连接的查询。
现在它们看起来有点像这样:
$qb->select(array('r, a'))
->from('ReleaseEntityRelease', 'r')
->leftJoin(
'ArtistEntityArtist', a',
DoctrineORMQueryExprJoin::WITH, 'a.id = r.artist'
)
->orderBy('r.id', 'ASC');
因此,如果我用 AbstractQuery::HYDRATE_ARRAY
水合结果,结果将是每个连接的表/实体的额外数组条目。
Array
(
[0] => Array
(
[id] => 1
[artist] => 1
[title] => A super nice Release
[digital_release] => DateTime Object
(
[date] => 2014-01-25 00:00:00.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
[physical_release] => DateTime Object
(
[date] => 2014-01-25 00:00:00.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
)
[1] => Array
(
[id] => 1
[first_name] => John
[last_name] => Doe
[artist_name] => JD and the Beat-Machines
[created_at] => DateTime Object
(
[date] => 2015-04-17 13:16:18.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
[updated_at] => DateTime Object
(
[date] => 2015-04-17 13:16:18.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
)
[2] => Array
(
[id] => 2
[artist] => 14
[title] => Some other nice album
[digital_release] => DateTime Object
(
[date] => 2014-02-01 00:00:00.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
[physical_release] => DateTime Object
(
[date] => 2014-02-01 00:00:00.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
)
[...]
)
如您所见,相应版本的艺术家 [0] 被存储在数组键 [1] 中。
如果我最终将结果打印为新的JsonModel($result)
这对我来说似乎不是一个可行的方法。
我想要实现的是这样的结果
Array
(
[0] => Array
(
[id] => 1
[artist] => Array
(
[id] => 1
[first_name] => John
[last_name] => Doe
[artist_name] => JD and the Beat-Machines
[created_at] => DateTime Object
(
[date] => 2015-04-17 13:16:18.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
[updated_at] => DateTime Object
(
[date] => 2015-04-17 13:16:18.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
)
[title] => A super nice Release
[digital_release] => DateTime Object
(
[date] => 2014-01-25 00:00:00.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
[physical_release] => DateTime Object
(
[date] => 2014-01-25 00:00:00.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
)
[2] => Array
(
[id] => 2
[artist] => Array
(
[id] => 14
[...]
)
[title] => Some other nice album
[digital_release] => DateTime Object
(
[date] => 2014-02-01 00:00:00.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
[physical_release] => DateTime Object
(
[date] => 2014-02-01 00:00:00.000000
[timezone_type] => 3
[timezone] => Europe/Berlin
)
)
[...]
)
也许有人有一个有用的建议,如何获得这样的输出:)
我已经尝试使用 AbstractQuery::HYDRATE_SCALAR
,它更接近我想要的,但连接表的结果不是连接列的子数组。
提前感谢您提供的每一个有用的提示:)
问候
你的问题是你的映射不好,我认为你在发布和艺术家之间没有关系。
您必须在艺术家和发布之间设置一对多的关系。喜欢这个:
On artist side
/**
* @ORMOneToMany(targetEntity="ReleaseEntityRelease", mappedBy="artist")
*/
protected $release;
And Release side
/**
* @ORMManyToOne(targetEntity="ArtistEntityArtist", inversedBy="release")
* @ORMJoinColumn(name="artist", referencedColumnName="idArtist", onDelete="RESTRICT")
*/
protected $artist;
不要忘记艺术家方面来实例化这样的集合:
public function __construct()
{
$this->release= new ArrayCollection();
}
使用此用途:
use DoctrineCommonCollectionsArrayCollection;
有了这个,您可以设置发布实体并设置艺术家和艺术家对象。你会得到你想要的结果。
$release = new Release;
$artist = new Artist;
$release->setArtist($artist);
编辑拥有数据后,必须用它填充实体。
如果你有一个表单,你必须使用DoctrineHydrator来实现这一点,你的对象将从你的表格中正确水化。这可能需要深入研究教义文档;)如果数据来自其他任何位置,则可以使用实体的资源库填充实体。
例如:
$relaseEntity->setDate($data['date']); // Be carefull to Datetime object for this
$releaseEntity->setName($data['name']);
继续...