Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #78515

Re: Using namedtuple with sqlite, surely it can do better than the example

Show all headers | View raw

On 30/09/2014 22:32, cl@isbd.net wrote:
> In the namedtuple documentation there's an example:-
>
>      EmployeeRecord = namedtuple('EmployeeRecord', 'name, age, title, department, paygrade')
>
>      import sqlite3
>      conn = sqlite3.connect('/companydata')
>      cursor = conn.cursor()
>      cursor.execute('SELECT name, age, title, department, paygrade FROM employees')
>      for emp in map(EmployeeRecord._make, cursor.fetchall()):
>          print emp.name, emp.title
>
> (I've deleted the csv bit)
>
> Surely having to match up the "name, age, title, department,
> paygrade" between the tuple and the database can be automated, the
> example is rather pointless otherwise.  At the very least one should
> use the same variable instance for both, but it should be possible to
> get the tuple names from the database.
>

I'm not sure what you're trying to achieve but I've found it easy to use 
the sqlite Row object see 
https://docs.python.org/3/library/sqlite3.html#row-objects

-- 
My fellow Pythonistas, ask not what our language can do for you, ask
what you can do for our language.

Mark Lawrence

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Using namedtuple with sqlite, surely it can do better than the example cl@isbd.net - 2014-09-30 22:32 +0100
  Re: Using namedtuple with sqlite, surely it can do better than the example Peter Otten <__peter__@web.de> - 2014-10-01 01:06 +0200
  Re: Using namedtuple with sqlite, surely it can do better than the example Mark Lawrence <breamoreboy@yahoo.co.uk> - 2014-10-01 00:23 +0100

csiph-web