79251051

Date: 2024-12-04 11:58:02
Score: 1
Natty:
Report link

Changed my code to open close a connection every time a query is made

def get_results(seasonID):
    global odbc_str
    connection = pyodbc.connect(odbc_str, readonly=True)
    cursor_conn = connection.cursor()
    resultsQuery = "SELECT * FROM season_view"
    execute_qry = cursor_conn.execute(resultsQuery).fetchall()
    cursor_conn.close()
    connection.close()
    return execute_qry
Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: AlbertoN