How to iterate through the columns in a row using sqlite3.Row
Chris Green
cl at isbd.net
Sun Mar 12 18:44:20 EDT 2017
This should be simple but I can't manage it at the moment! :-)
I have opened a database connection and have set the row_factory to
sqlite3.Row.
So how do I actually iterate through a row of data having used
fetchone to read a row.
I.e. I have:-
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()
I want a for loop which gives me the column names and values.
--
Chris Green
ยท
More information about the Python-list
mailing list