assigning variables from list data
benjamin.kaplan at case.edu
Thu Aug 5 16:54:50 CEST 2010
On Thu, Aug 5, 2010 at 7:26 AM, Chris Hare <chare at labr.net> wrote:
> I have a database query result (see code below). In PHP, I would have said
> list(var1,var2,var) = $result
> and each element in the list would be assigned to each of the named variables. I have my data coming out of the database, and I can see it is a list. so my question is, instead of having to do the variable assignment as I have it here, is there a way more like PHP or am I stuck with it?
> import sqlite3 as sqlite
> print "connecting to disk db ..."
> conn = sqlite.connect("netcomm.db")
> print "oops"
> print "retrieving data"
> cursor = conn.cursor()
> cursor.execute('select * from net where NetNumber > 0')
> list = cursor.fetchone()
> print list
> print len(list)
> for item in list:
> print item
> netNumber = list
> netType = list
> netConditions = list
> netStartLocal = list
> NCS = list
> NCS1 = list
> RADAR = list
> NetFreq = list
> Repeater = list
> Notes = list
netNumber, netType, netConditions, netStartLocal, NCS, NCS1, RADAR,
NetFreq, Repeater, Notes = list
by the way, don't call the list "list". It will hide the built-in with
the same name.
More information about the Python-list