import pandas as pd
import pandas.io.sql
import pymssql
from tkinter import *
import time

master = Tk()

Label(master, text="Query").grid(row=2, column=1)
Label(master, text="File Name").grid(row=4, column=1)

e = Text(master, height=2, width=50)
e.grid(row=3, column=1)
e2 = Entry(master)
e2.grid(row=5, column=1)
e.focus_set()

conn = pymssql.connect(
    host=r"host",
    user=r"user",
    password="password",
    database="database"
)

pd.options.display.max_rows = 10000

#shortcut key commands
def status(self):
    global top
    top = Toplevel()
    top.title('Running')
    msg = Message(top, text="Running Query...                     ", width=750)
    msg.grid(row=0, column=1)

def run(self):
    time.sleep(10)
    try:
        sql = e.get('1.0', END)
        filename = e2.get()
        if filename == '':
            global top
            top = Toplevel()
            top.title('Error')
            msg = Message(top, text="Please Provide File Name         ", width=750)
            msg.grid(row=0, column=1)
        else:
            df = pandas.io.sql.read_sql(sql, conn)
            df.to_csv("C:/Desktop/" + filename + ".csv", index=False)
            top = Toplevel()
            top.title('Finished')
            msg = Message(top, text="Query Executed Successfully         ", width=750)
            msg.grid(row=0, column=1)
    except:
        top = Toplevel()
        top.title('Error')
        msg = Message(top, text="SQL Error! Please check your query             ", width=750)
        msg.grid(row=0, column=1)

def comb(self):
    status(self)
    run(self)

master.bind('<F5>', comb)
master.title("Query")
master.minsize(width=250, height=100)
mainloop()