How to iterate through the columns in a row using sqlite3.Row

Chris Green cl at
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 = ?"
        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