Подключение к БД

import sqlConnect
import  mysql.connector
conn = mysql.connector.connect(
         user='testconn',
         password='1233214',
         host='ip',
         port='1221',
         database='teka')
print('win')
cur = conn.cursor()
query = ("SELECT TOP (10) [DivLabel]      ,[ProductLabel]      ,[BonusPercent]      ,[Min]      ,[KNorma]      ,[Id]  FROM [teka].[dbo].[List]")
cur.execute(query)
for (DivLabel, ProductLabel, BonusPercent, Min) in cur:
  print("{}, {}, {}, {}".format(DivLabel, ProductLabel,BonusPercent,Min))
cur.close()
conn.close()

import pyodbc
from tkinter import *
 
root = Tk()
 
 
 
 
DP = ''
 
 
def Path(dir_path):
    global DP
    from tkinter.filedialog import askdirectory
    Tk().withdraw()
    dir_path = DP = askdirectory()
    return dir_path
 
def End(event):
    query = "Нужный запрос" 
 
 
 
 
 
    server = 'tcp:ip'
    database = 'teka'
    username = 'usertest'
    password = '4162'
    cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
    cursor = cnxn.cursor()
 
 
    #f = open("Zapros1.sql","r")
    #ff = f.read()
    g = open(DP+'\\'+"NewFile.csv","w")
    #print(ff)
    #Sample select query
    query = (query)
 
    cursor.execute(query)
    row = cursor.fetchone()
    e = []
 
    while row:
        #print (row)
        row = cursor.fetchone()
        e.append(str(row).split(','))
    print(len(e))
 
    count=0
    for ep in e:
        t=str(e[count]).replace(',',';')
        #print(t)
        tt = t.replace('"','').replace("'",'').replace('(','').replace(')','').replace(']','').replace('[','')
        gg = g.write(tt+'\n')
        count +=1
    print('End')
    exit(0)
 
 
 
BtnPath = Button(root, text='папка')
BtnFile = Button(root, text='Фаил')
BtnEnd = Button(root, text='Выполнить')
 
BtnPath.pack(side='left')
BtnPath.bind("<Button-1>", Path)
 
BtnEnd.pack(side='left', fill='both', expand=1)
BtnEnd.bind("<Button-1>", End)
 
root.mainloop()

import pyodbc
conn=pyodbc.connect(driver='{SQL Server}', server='(local)', database='dbtest', uid='', pwd='')
cursor=conn.cursor()
for row in cursor.execute("select * from proba"):
    print(row[0])
    print(row.tetx)