def getSomeData(curs):         # case 1: pass in a cursor,which is generally
    curs.execute('select ...') #         reused across queries
    return curs.fetchall()

def getSomeData(conn):         # case 2: pass in a connection,allocate
    curs=conn.cursor()         #         a cursor for this query
    curs.execute('select ...')
    return curs.fetchall()

当然,这两种方法都返回相同的数据.

两种方法之间的折衷是什么？是一个或多或少的效率？在许多查询中重用光标是否有潜在的缺陷？