How to iterate through the columns in a row using sqlite3.Row
Chris Green
cl at isbd.net
Mon Mar 13 04:42:22 EDT 2017
Paul Rubin <no.email at nospam.invalid> wrote:
> Chris Green <cl at isbd.net> writes:
> > self.conn = sqlite3.connect(dbname)
> > self.conn.row_factory = sqlite3.Row
> > self.cursor = self.conn.cursor()
> > self.table = table
> > ...
> > ...
> > sql = "SELECT * FROM " + self.table + " WHERE firstName||lastName = ?"
> > self.cursor.execute(sql, (name,))
> > row = self.cursor.fetchone()
>
> untested:
>
> with sqlite3.connect(dbname) as conn:
> sql = "SELECT * FROM " + self.table + " WHERE firstName||lastName = ?"
> cursor = conn.execute(sql, (name,))
> row = cursor.fetchone()
Ay? I've maybe not explained well.
I want to iterate through row *after* the above code such that I can
see the column names as 'keys' and the corresponding values.
--
Chris Green
ยท
More information about the Python-list
mailing list