Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!ecngs!feeder2.ecngs.de!newsfeed.freenet.ag!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Date: Wed, 20 Mar 2013 12:52:40 +0000
To: python-list@python.org
From: Norah Jones <nh.jones01@gmail.com>
Subject: Multiple rows from MySQL query saved in an array structure
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="b1_afd57caadf8e7c7c1888a7f71f578186"
Precedence: list
Reply-To: Norah Jones <nh.jones01@gmail.com>
Newsgroups: comp.lang.python
Message-ID: <mailman.3560.1363783972.2939.python-list@python.org>
Lines: 68
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:41585


--b1_afd57caadf8e7c7c1888a7f71f578186
Content-Type: text/plain; charset = "iso-8859-1"
Content-Transfer-Encoding: 8bit

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)
    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();

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?


--b1_afd57caadf8e7c7c1888a7f71f578186
Content-Type: text/html; charset = "iso-8859-1"
Content-Transfer-Encoding: 8bit

I  have this Python code:<br />
<br />
<br />
    self.lock_tables("read", ['nets_permissions as n', 'devices_permissions as d'])<br />
    usrs = self.db.get("SELECT n.user_id FROM nets_permissions as n \<br />
                        left join devices_permissions as d \<br />
                        on n.user_id = d.user_id \<br />
                        where d.user_id is null \<br />
                        and n.network_id=%s and n.perm<>3", netid)<br />
    self.unlock_tables()<br />
    <br />
    for usr in usrs:<br />
        self.lock_tables("write", ['devices_permissions'])<br />
        self.db.execute("INSERT devices_permissions SET \<br />
                         user_id=%s, network_id=%s, device_id=%s, perm=%s",\<br />
                         usr, netid, sensid, perm)<br />
        self.unlock_tables();<br />
<br />
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...<br />
<br />
<br />
    This code doesn't work. I obtain this error:    <br />
    Exception: Multiple rows returned for Database.get() query<br />
<br />
How can I retrieve this multiple rows and then process everyone of them at one time?<br />
<br />



--b1_afd57caadf8e7c7c1888a7f71f578186--