我有这个Python代码:self.lock_tables("read", ['nets_permissions as n', 'devices_permissions as d'])
usrs = self.db.get("SELECT n.user_id FROM nets_permissions as n \
left join devices_permissions as d \
on n.user_id = d.user_id \
where d.user_id is null \
and n.network_id=%s and n.perm<>3", netid)
self.unlock_tables()
for usr in usrs:
self.lock_tables("write", ['devices_permissions'])
self.db.execute("INSERT devices_permissions SET \
user_id=%s, network_id=%s, device_id=%s, perm=%s",\
usr, netid, sensid, perm)
self.unlock_tables();
我首先执行一个查询,从两个表中检索一些user_id。我想把这个用户的id保存在一个变量中,然后在执行for循环之后将这些记录插入另一个表中。。。在
这个代码行不通。我得到这个错误:Exception: Multiple rows returned for Database.get() query
如何检索这多行,然后一次处理所有行?在
谢谢大家。在