作者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
1F：推 derekQQ:query1和query2都改成query就行了，query是累加的 06/18 19:06
2F：→ derekQQ:sorry，好像错了，query1结束可以改用query.filter 06/18 19:07
3F：推 derekQQ:query1 = db.GqlQuery.... 06/18 23:33
4F：→ derekQQ:query1 = query1.filter(... 06/18 23:34