How to iterate through the columns in a row using sqlite3.Row
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
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 = ?"
row = self.cursor.fetchone()
I want a for loop which gives me the column names and values.
More information about the Python-list