Doctrine MongoDB 按 id 查找

2022-01-03 00:00:00 mongodb php symfony doctrine-orm

我正在使用 odm mongo 学说，我必须记录类

I'm using odm mongo doctrine and I have to document-classes

class Thing
{
/**
 * @MongoDBId
 */
protected $id;

 /**
  * @MongoDBReferenceOne(targetDocument="Bundle1:Other")
  */
protected $other;
}

和

class Other
{
/**
 * @MongoDBId
 */
protected $id;
}

所以在数据库中的东西看起来像:

so in the database a thing looks like : 

{
  "_id":ObjectId("43z758634875adf"),
  "other":ObjectId("38z287348d8se")
}

我现在如何查询 other 是给定 id 的东西?

How can I now query for things where other is a given id ? 

    $dm=$this->mongo->getManager();
            $answers=$dm
                ->createQueryBuilder('Bundle1:Thing')
                ->field('other')->equals("ObjectId(516c0061975a299edc44b419)")  // <-- ?
                ->getQuery()
                ->execute()->count();

这会产生错误的 mongo 查询

This produces a wrong mongo query

MongoDB 查询:{"find":true,"query":{"other":"ObjectId(516c0061975a299edc44b419)"},"fields":[],"db":"maself","collection":"thing"}[] []

MongoDB query: {"find":true,"query":{"other":"ObjectId(516c0061975a299edc44b419)"},"fields":[],"db":"maself","collection":"thing"} [] []

当我使用

->field('other')->equals("516c0061975a299edc44b419")

->field('other')->equals("516c0061975a299edc44b419")

查询也是错误的

MongoDB 查询:{"find":true,"query":{"other":"516c0061975a299edc44b419"},"fields":[],"db":"maself","collection":"thing"}[] []

MongoDB query: {"find":true,"query":{"other":"516c0061975a299edc44b419"},"fields":[],"db":"maself","collection":"thing"} [] []

那么我如何搜索其他 id 等于 objectId 的东西?

So how can I search for thing where other id equals an objectId ?

推荐答案

尝试 

->field('other')->equals(new MongoId("516c0061975a299edc44b419"))

ObjectId 是 Mongo 的内部类型，PHP 中用 MongoId() 表示

ObjectId is the internal type for Mongo, represented by MongoId() in PHP

(但我也在第一个主题中回答了)

( But i have also answered in the first topic )

相关文章