本文整理汇总了Python中query.Query.setVariable方法的典型用法代码示例。如果您正苦于以下问题:Python Query.setVariable方法的具体用法?Python Query.setVariable怎么用?Python Query.setVariable使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类query.Query
的用法示例。
在下文中一共展示了Query.setVariable方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: DatabasePolygonMap
# 需要导入模块: from query import Query [as 别名]
# 或者: from query.Query import setVariable [as 别名]
class DatabasePolygonMap(PolygonMap):
def __init__(self, mapSource, connection, subset):
PolygonMap.__init__(self, mapSource, subset)
self._connection = connection
self._matchQuery = None
def load(self):
query = Query(self._connection)
query.SELECT("gid", self.name)
query.SELECT("the_geom", self.name, "AsText")
query.SELECT(self._primary, self.name)
for key, gen in self._fields:
query.SELECT(key, self.name)
whereList = []
try:
for entry in self._subset:
item = self.name + "." + self._primary + "='" + entry + "'"
whereList.append(item)
query.where = " OR ".join(whereList)
except TypeError:
pass
polyDict = PolygonDictionary()
pairs = []
for entry in query:
d = []
for key, gen in self._fields:
d.append((gen, entry[key]))
data = Dictionary()
data.update(d)
p = GeneralizedPolygon(enum.ABSTRACT, entry["gid"], entry["the_geom"], data, self)
polyKey = keygen(entry[self._primary])
pairs.append((polyKey, p))
polyDict.update(pairs)
return polyDict
def loadMatchingPolygonData(self, mapName, fieldID):
if not self._matchQuery:
self._matchQuery = Query(self._connection)
self._matchQuery.FROM("%(mapName)s")
for key, gen in self._fields:
self._matchQuery.SELECT(key, self.name)
self._matchQuery.where = "%(mapName)s.gid=%(fieldID)s AND ST_Equals"
self._matchQuery.where += "(%(mapName)s.the_geom," + self.name
self._matchQuery.where += ".the_geom);"
self._matchQuery.SELECT
self._matchQuery.setVariable("mapName", mapName)
self._matchQuery.setVariable("fieldID", fieldID)
data = []
for entry in self._matchQuery:
for key, gen in self._fields:
data.append((gen, entry[key]))
return data