dbref $id persisted as string instead of objectid

[gwilym]

I've noticed this when playing around with the sandbox and references:

(output of mongo shell)

db.testcollection.findOne().references[0]
{ "$ref" : "testreference", "$id" : "4c3f0b456cc8849c17ab0000" }

The $id of the dbref here is a string, but I would expect it to be an ObejctId (a MongoId in PHP), like so:

db.testcollection.findOne().references[0]
{ "$ref" : "testreference", "$id" : ObjectId("4c3f0b456cc8849c17ab0000") }

This allows for...

db.testcollection.findOne().references[0].fetch()
{ ... referenced document here ... }

I couldn't find a note if this was intended by the odm or not, but an ObjectId is the proper format, here:

http://www.mongodb.org/display/DOCS/Database+References

[avalanche123]

will look into it, thanks

[jwage]

Can you create the issue in jira?

http://www.doctrine-project.org/jira

[avalanche123]

done http://www.doctrine-project.org/jira/browse/MODM-32

[hex337]

So I just pulled this, and now I have an issue.

In my query, I do this:
$this->createQuery('Message')->field('sender.$id')->equals($userId)

I get nothing as the response. I can't find anything in the query docs to see how to build my query to make this work.

[avalanche123]

Try ...->equals(new \MongoId($userId));
Also please gist what you're doing so that we could see the exact code.

[hex337]

What does gist mean? Sorry, new to a lot of this.

[jwage]

This should be fixed. The $id is stored as a MongoId properly now.

[epicwhale]

Besides the identify field of the document, how do you store a MongoId in some other field? in cases where I'm manually referencing documents. I don't want to store them as strings. I've explained my issue here: http://stackoverflow.com/questions/6644033/how-do-you-store-an-objectid-while-using-doctrine-mongodb-odm