[google-appengine] Re: Query filter using an entity's inline property
Just noticed there is a small typo in the code above, the query should
be hitting WaitingQuestions, not WaitingAnswer.
On Dec 15, 11:00 am, Lenny Rachitsky lenny...@gmail.com wrote:
Does App Engine allow self-referencing queries, where I use a property
of an entity as part of the filter? For example, below I am attempting
to use the question_ttl property to filter questions that are
expired (e.g. older than question_ttl minutes). I'm attempting to
avoid having to iterate through the entire batch. Is this possible? I
attempted to use self below, but that doesn't work.
class WaitingQuestions(db.Model):
question = db.TextProperty()
question_ttl = db.IntegerProperty()
timestamp = db.DateTimeProperty(auto_now=True, auto_now_add=True)
@staticmethod
def get_expired_questions():
return WaitingAnswer.all().filter('timestamp ',
datetime.now() - timedelta(minutes=self.question_ttl))
Any help would be much appreciated. Thank you in advance,
Lenny
--
You received this message because you are subscribed to the Google Groups
Google App Engine group.
To post to this group, send email to google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
Re: [google-appengine] Re: Query filter using an entity's inline property
You want something like (Where N is some number):
Select * from myModel Where Prop1 + Prop2 N
No do that here impossible in GAE.
Just change the question_ttl property into expiration_timestamp (or
maybe us a nice short prop name) and calculate that future expiration date
when the entity is created (and recalculate it if 'question_ttl' ever
changes).
So you just need to query for:
WaitingQuestion.all().filter('expiration_timestamp ', datetime.now())
On Wed, Dec 15, 2010 at 11:04 AM, Lenny Rachitsky lenny...@gmail.comwrote:
Just noticed there is a small typo in the code above, the query should
be hitting WaitingQuestions, not WaitingAnswer.
On Dec 15, 11:00 am, Lenny Rachitsky lenny...@gmail.com wrote:
Does App Engine allow self-referencing queries, where I use a property
of an entity as part of the filter? For example, below I am attempting
to use the question_ttl property to filter questions that are
expired (e.g. older than question_ttl minutes). I'm attempting to
avoid having to iterate through the entire batch. Is this possible? I
attempted to use self below, but that doesn't work.
class WaitingQuestions(db.Model):
question = db.TextProperty()
question_ttl = db.IntegerProperty()
timestamp = db.DateTimeProperty(auto_now=True, auto_now_add=True)
@staticmethod
def get_expired_questions():
return WaitingAnswer.all().filter('timestamp ',
datetime.now() - timedelta(minutes=self.question_ttl))
Any help would be much appreciated. Thank you in advance,
Lenny
--
You received this message because you are subscribed to the Google Groups
Google App Engine group.
To post to this group, send email to google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.comgoogle-appengine%2bunsubscr...@googlegroups.com
.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
--
You received this message because you are subscribed to the Google Groups
Google App Engine group.
To post to this group, send email to google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
[google-appengine] Re: Query filter using an entity's inline property
Good idea! Thank you sir.
On Dec 15, 11:56 am, Eli Jones eli.jo...@gmail.com wrote:
You want something like (Where N is some number):
Select * from myModel Where Prop1 + Prop2 N
No do that here impossible in GAE.
Just change the question_ttl property into expiration_timestamp (or
maybe us a nice short prop name) and calculate that future expiration date
when the entity is created (and recalculate it if 'question_ttl' ever
changes).
So you just need to query for:
WaitingQuestion.all().filter('expiration_timestamp ', datetime.now())
On Wed, Dec 15, 2010 at 11:04 AM, Lenny Rachitsky lenny...@gmail.comwrote:
Just noticed there is a small typo in the code above, the query should
be hitting WaitingQuestions, not WaitingAnswer.
On Dec 15, 11:00 am, Lenny Rachitsky lenny...@gmail.com wrote:
Does App Engine allow self-referencing queries, where I use a property
of an entity as part of the filter? For example, below I am attempting
to use the question_ttl property to filter questions that are
expired (e.g. older than question_ttl minutes). I'm attempting to
avoid having to iterate through the entire batch. Is this possible? I
attempted to use self below, but that doesn't work.
class WaitingQuestions(db.Model):
question = db.TextProperty()
question_ttl = db.IntegerProperty()
timestamp = db.DateTimeProperty(auto_now=True, auto_now_add=True)
@staticmethod
def get_expired_questions():
return WaitingAnswer.all().filter('timestamp ',
datetime.now() - timedelta(minutes=self.question_ttl))
Any help would be much appreciated. Thank you in advance,
Lenny
--
You received this message because you are subscribed to the Google Groups
Google App Engine group.
To post to this group, send email to google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.comgoogle-appengine%2Bunsubscrib
e...@googlegroups.com
.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
--
You received this message because you are subscribed to the Google Groups
Google App Engine group.
To post to this group, send email to google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
