database_test.py

import pyodbc 
from secrets import database, server, username, password

def get_dogs():
    cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
    cursor = cnxn.cursor()
    cursor.execute('SELECT * FROM Dogs')
    return [row for row in cursor]



# conn_string = """Driver={ODBC Driver for SQL Server 17};Server=tcp:dogchatserver.database.windows.net,1433;Initial Catalog=dogchat;Persist Security Info=False;User ID=dogchatadmin;Password=R0ver123$;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"""
# conn = pyodbc.connect(conn_string)
# # conn = pyodbc.connect('Driver={SQL Server};'
# #                       'Server=dogchatserver.database.windows.net;'
# #                       'Database=dogchat;'
# #                       'Password=R0ver123$;'
# #                       'Trusted_Connection=yes;')

# cursor = conn.cursor()