作者amorr (喵喵)
看板Python
標題gae撈出的query要怎麼比較?
時間Tue Jun 15 16:04:49 2010
我有一個GAE 資料庫的class包含:
author = db.StringProperty()
content = db.StringProperty(multiline=True)
lonx = db.FloatProperty()
lony = db.FloatProperty()
因為GAE好像不行過濾兩個變數:
query = db.GqlQuery("SELECT * FROM Greeting where lonx >= :1 and lonx <= :2
and lony>=:3 and lony<=:4"
, (float(self.request.get('x')) - 0.0001), (float(self.request.get('x')) +
0.0001),(float(self.request.get('y')) - 0.0001), (float(self.request.get('y')) +
0.0001) )
所以我把它寫成
query1 = db.GqlQuery("SELECT * FROM Greeting where lonx >= :1 and lonx <= :2"
, (float(self.request.get('x')) - 0.0001), (float(self.request.get('x')) +
0.0001) )
query2 = db.GqlQuery("SELECT * FROM Greeting where lony >= :1 and lony <= :2"
, (float(self.request.get('y')) - 0.0001), (float(self.request.get('y')) +
0.0001) )
可是卻不知道怎麼取query1和query2交集
不知道板上的各位大大有沒有什麼辦法?
謝謝!!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.115.227.157
推 derekQQ:query1和query2都改成query就行了,query是累加的 06/18 19:06
→ derekQQ:sorry,好像錯了,query1結束可以改用query.filter 06/18 19:07
推 derekQQ:query1 = db.GqlQuery.... 06/18 23:33
→ derekQQ:query1 = query1.filter(... 06/18 23:34