Cursor.fetchall

Fetch all (remaining) rows of a query result.

For an overview see page Python Cursor Class

Prototype

 
    Cursor.fetchall()
 

Arguments

Description

This method returns all (remaining) rows of a query result, returning a list. This is a DB API compliant call. An empty list is returned when no rows are available. Note that the cursor’s arraysize attribute can affect the performance of this operation.

Returns

Example

     
    conn = db.connect()
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM Metatable WHERE TableName='%s'" % clsname)
    res = cursor.fetchall()
    ...
    cursor.close()
    conn.rollback()