sqlalchemy joined table 查询必须不使用with_entities

sqlalchemy joined table

sqlalchemy针对 joined table 表对象执行查询时,不能用with_entities。其返回的查询结果集中每个元素是数据库中一条记录,访问该记录每个字段时,用字段名访问。

...
if self.searchview().canbeInput:
for i in resultDicLists:
out = """<tr class="text-left">
<td class="col-md-1 text-left">%(guojia)s</td>
<td class="col-md-2">%(sheng)s</td>
<td class="col-md-2">%(shi)s</td>
<td class="col-md-5">%(jiedao)s</td>
<td class="col-md-1 text-center">
<a href="%(edit_url)s" title="edit">
<span class="glyphicon glyphicon-pencil" aria-hidden="true">
</span>
</a>
</td>
<td class="col-md-1 text-center">
<a href="%(delete_url)s" title="delete">
<span class="glyphicon glyphicon-trash" aria-hidden="true">
</span>
</a>
</td>
</tr> """% dict(
guojia=i.guojia,
sheng= i.sheng,
shi= i.shi,
jiedao= i.jiedao,
edit_url="%s/@@update_gerendizhi/%s" % (contexturl,i.id),
delete_url="%s/@@delete_gerendizhi/%s" % (contexturl,i.id))
outhtml = "%s%s" %(outhtml ,out)
...

 

设置