Create GQL with "IN" Query for ReferenceProperty

Question

class Message (db.Model):

user = db.ReferenceProperty(User, required=True, collection_name='Message_set')  
text = db.TextProperty(required=True)

I tried this, but get a BadValueError in the gql statement.

users = []

users.append (USERA)

users.append (UserB)

users.append (userC)

messages = Message.gql ('Where user In: users', users = users) .fetch (100)

Answer 1

It's hard to say without a full stacktrace (please?), But I would suggest that IN does not like to pass entities, not keys. Try the following:

users = [userA.key(), userB.key(), userC.key()]
messages = Message.gql("WHERE user in :users", users=users).fetch(100

Answer 2

IN GQL Python , = - , , ( ). , API Python ( , Java API), . (Btw, != ).

, , , , - , datastore.MultiQuery, datastore.Query - , Python , Python, GAE? SDK google/appengine/api/datastore.py, MultiQuery - ( , , , t, , ).

Answer 3

:

class MyUsuario(db.Model):
    nombre=db.StringProperty(required=True)

class Message(db.Model):
    MyUsuario = db.ReferenceProperty(MyUsuario, required=True, collection_name='Message_set')  
    text = db.StringProperty(required=True)

:

from modelos import MyUsuario, Message
from google.appengine.ext import db

usuarios=MyUsuario.all()

userA=usuarios[0]
userB=usuarios[1]
userC=usuarios[2]

usuarios= []

usuarios.append(userA.key())
usuarios.append(userB.key())
usuarios.append(userC.key())

messages = db.GqlQuery('select * from Message Where MyUsuario In :usuari', usuari=usuarios)

for message in messages:
    print message.text

awnser google

Answer 4

, ? users.append(userA.key()). .