Hi Mike, I responded to your earlier, identical thread.
-Nick Johnson On Sun, May 17, 2009 at 9:19 PM, Mike Cantelon <[email protected]> wrote: > > Hi all, > > I'm running into a strange issue with the Python datastore API where > using a ">" or "<" operator to filter a DateTimeProperty property > gives me an "Error: Server Error". > > Here is the working code (using the "=" operator on the "created" > property): > > class Session(db.Model): > fcid = db.StringProperty() > name = db.StringProperty() > #authenticated = db.StringProperty() > created = db.DateTimeProperty(auto_now_add=True) > > def test_case(): > # kill existing sessions > q = db.GqlQuery("SELECT __key__ FROM Session") > results = q.fetch(10) > db.delete(results) > > # make new session > session = Session() > session.fcid = 'mike' > session.name = 'Mike Cantelon' > session.put() > > # so now if we get all sessions with a created greater than an hour > ago > # we should get one > hour = datetime.timedelta(hours=1) > date_hour_ago = datetime.datetime.today() - hour > sessions = Session.all() > sessions.filter("fcid =", 'mike') > sessions.filter("created =", date_hour_ago) > > for session in sessions: > print session.name > print session.created > > Here is the code that results in the error (the only difference is > using a ">" or "<" filter operator on the "created" property): > > class Session(db.Model): > fcid = db.StringProperty() > name = db.StringProperty() > #authenticated = db.StringProperty() > created = db.DateTimeProperty(auto_now_add=True) > > def test_case(): > # kill existing sessions > q = db.GqlQuery("SELECT __key__ FROM Session") > results = q.fetch(10) > db.delete(results) > > # make new session > session = Session() > session.fcid = 'mike' > session.name = 'Mike Cantelon' > session.put() > > # so now if we get all sessions with a created greater than an hour > ago > # we should get one > hour = datetime.timedelta(hours=1) > date_hour_ago = datetime.datetime.today() - hour > sessions = Session.all() > sessions.filter("fcid =", 'mike') > sessions.filter("created >", date_hour_ago) > > for session in sessions: > print session.name > print session.created > > Any advice on the underlying issue would be appreciated! > > Cheers, > Mike > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
