Multiple rows from MySQL query saved in an array structure
nh.jones01 at gmail.com
Wed Mar 20 13:52:40 CET 2013
I have this Python code:
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.perm3", netid)
for usr in usrs:
self.db.execute("INSERT devices_permissions SET \
user_id=%s, network_id=%s, device_id=%s, perm=%s",\
usr, netid, sensid, perm)
I first do a query to retrieve some user_id from two tables. I want save this user_id in one variable and after do a for loop to insert this records in another table...
This code doesn't work. I obtain this error:
Exception: Multiple rows returned for Database.get() query
How can I retrieve this multiple rows and then process everyone of them at one time?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Python-list