看板 Python 關於我們 聯絡資訊
 我有一個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