Python db-api: fetchone vs fetchmany vs . fetchall

I just had a discussion today with some coworkers about python's db-api fetchone vs fetchmany vs fetchall.I just had a discussion today with some coworke