Find objects into a list using Django and mongodb

Question

I have used django but I'm a newbie with mongodb. I have the follow model:

class Conversation(models.Model):
    date = models.DateTimeField(auto_now_add=True, db_index=True)
    users = ListField(models.CharField(max_length="64"), editable=False)
    messages = ListField(EmbeddedModelField('Message'), editable=False)

class Message(models.Model):
    user = models.CharField(max_length="64")
    text = models.CharField(max_length="512");
    date = models.DateTimeField(auto_now_add=True, db_index=True)

I already store and show conversations with messages for each user, but now I want to filter conversations by some users like a private chat.

For example, I want to get conversations which users contains ['Dennis','linus','Guido']

How can I do it?

Thanks in advance.

* EDIT *

I got it using Q

django.db.models.Q
Conversation.objects.filter(Q(users = msg['Dennis'])&Q(users = msg['linus']&Q(users = msg['Guido']))

Is there a better approach?

surfeurX · Accepted Answer · 2013-07-16 17:45:15Z

1

I suppose you're using mongoengine?

Conversation.objects.filter(users__all=['Dennis','linus','Guido'])

answered Jul 16, 2013 at 17:45

surfeurX

1,25212 silver badges16 bronze badges

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

10 Comments

karthikr Over a year ago

is __all a valid queryset filter option ? You probably mean __contains

surfeurX Over a year ago

There is an __all option mongoengine-odm.readthedocs.org/en/latest/guide/…

karthikr Over a year ago

Ok.. but does the django orm support that was my question.

karthikr Over a year ago

Exactly.. thats what i m trying to say.

surfeurX Over a year ago

:) if so, use mongoengine to retrieve conversations and the django orm (with mysql or anything) for everything else.

|

Collectives™ on Stack Overflow

Find objects into a list using Django and mongodb

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related