在单一查询中如何使用原则获取整个树？ [英] How can I fetch the entire tree in a single query with doctrine?

问题描述

此代码段来自官方网站按预期工作：

This snippet from official website works as expected:

$treeObject = Doctrine::getTable('Category')->getTree();
$rootColumnName = $treeObject->getAttribute('rootColumnName');

foreach ($treeObject->fetchRoots() as $root) {
  $options = array(
      'root_id' => $root->$rootColumnName
  );
  foreach($treeObject->fetchTree($options) as $node) {
    echo str_repeat(' ', $node['level']) . $node['name'] . "\n";
  }
}

但是我看到有数十个查询发送到数据库

But I see there are dozens of queries sent to database.

如何做到这一点？

推荐答案

尝试这样：

Doctrine_Core::getTable('YourTableWithTree')->createQuery('tree')
    ->addOrderBy('tree.root_id ASC')
    ->addOrderBy('tree.lft ASC');

这篇关于在单一查询中如何使用原则获取整个树？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！