gae撈出的query要怎麼比較?
我有一個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
推
06/18 19:06, , 1F
06/18 19:06, 1F
→
06/18 19:07, , 2F
06/18 19:07, 2F
推
06/18 23:33, , 3F
06/18 23:33, 3F
→
06/18 23:34, , 4F
06/18 23:34, 4F
Python 近期熱門文章
PTT數位生活區 即時熱門文章
