def query_db()

in scripts/bank_deposit.py [0:0]

• 11 lines of code
• 5 McCabe index (conditional complexity)

def query_db(conn, query, first_row=False):
    results = []
    with conn.cursor() as cur:
        cur.execute(query)
        for r in cur.fetchall():
            row = []
            for i, value in enumerate(r):
                row.append(value)

            results.append(row)
        
        cur.close()
    
    return (results[0] if results else None) if first_row else results