Cannot query using IDs - Django MongoDB Engine

Question

I am using django-nonrel and django-mongodb-engine

I have a Django model stored on PostgreSQL:

class Author(models.Model):
    name = models.CharField(max_length=100)
    created = models.DateTimeField(auto_now_add=True)

I have a MongoDB stored model:

class Post(models.Model):
    title = models.CharField(max_length=100)
    body = models.TextField()
    created = models.DateTimeField(auto_now_add=True)

    author = models.ForeignKey(Author)

Whenever I try to filter posts by author id:

posts = Post.objects.filter(author__id=1)

I get the following error:

/usr/local/lib/python2.6/dist-packages/bson/objectid.pyc in __validate(self, oid)
    158                     raise InvalidId("%s is not a valid ObjectId" % oid)
    159             else:
--> 160                 raise InvalidId("%s is not a valid ObjectId" % oid)
    161         else:
    162             raise TypeError("id must be an instance of (str, ObjectId), "

InvalidId: 1 is not a valid ObjectId

In [22]: Post.objects.filter(author__id=1)

Any ideas?

Marcus Blankenship · Accepted Answer · 2011-01-31 19:15:08Z

2

I believe the "mongo way" would be to embed the author details in the post, as well as all comments, in Embedded Documents. Having multiple related collections (tables) isn't the best way to solve this problem in your case.

Reduce your foreignKey usage as much as possible, and just embed the data. I believe MongoEngine has a Document and EmbeddedDocument class you can inherit from.

Why do you want to use mongodb vs. mysql? You must have a HUGE blog... ;-)

answered Jan 31, 2011 at 19:15

Marcus Blankenship

5211 gold badge5 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

RadiantHex Over a year ago

fair enough, I changed the foreign-keys to simple integers for now. The blog is not the final app unfortunately :)

moskrc · Accepted Answer · 2011-01-31 19:58:04Z

0

May be:

author = Author.objects.get(pk=1)
posts = author.post_set.all()

answered Jan 31, 2011 at 19:58

moskrc

1,2361 gold badge12 silver badges23 bronze badges

Comments

deleted77 · Accepted Answer · 2011-02-05 21:21:14Z

-1

It's impossible to mix those two engines. The simplest explanation for this is that MongoDB primary keys are string-like objects and *SQL pks are integers. You can't use both, chose one.

answered Feb 5, 2011 at 21:21

deleted77

1471 silver badge5 bronze badges

Collectives™ on Stack Overflow

Cannot query using IDs - Django MongoDB Engine

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related