tkinter query.py

import tkinter as tk
import mysql.connector as mydb
from tabulate import tabulate
con = mydb.connect(
	host = "localhost",
	user = 'TBA',
	password="1234",
	database = "py")
cursor= con.cursor()
# Create the main window
window = tk.Tk()
def comit():
	global op
	cursor.execute(q)
	op = (cursor.rowcount,"rows affected")
	con.commit()
def show():
	global op
	head=[]
	cursor.execute(q)
	column=(cursor.description)
	for i in column :
		head.append(i[0])
	op=(tabulate(cursor,headers=head,tablefmt="grid"))

# Create a function to get input from the user
def get_input():
    global q
    global op
    # Get the input from the input field
    input_text = input_field.get()
    try:
	    q=input_text#(input ("ENTER YOUR QUERY :  "))
	    #print(q)
	    b=(q.lower()).split()
	    if "show" in b[0] or "select" in b[0] or "desc" in b[0] :
	    	show()
	    elif "delete" in b[0] or "update" in b[0] or "insert" in b[0] or "drop" in b[0] :
	    	comit()
	    elif q == "STOP":
	    	window.destroy()
	    else:
	    	cursor.execute(q)
    except Exception as e :
    	con.rollback()
    	op = (e)
    
    # Display the input in a label widget
 #   output_label['text'] = "{}".format(op)
    text.configure(state="normal")
    text.delete(1.0,tk.END)
    text.insert(tk.END,op)
    text.configure(state="disabled")

# Create an input field
output_label = tk.Label(window, text='Welcome to\nQueries from python')
output_label.pack()
input_field = tk.Entry(window)
input_field.pack()

# Create a button to get the input
get_input_button = tk.Button(window, text='Submit Query', command=get_input)
get_input_button.pack()

# Create a label to display the output
#output_label = tk.Label(window, text='Output will appear here',justify="left")
#output_label.pack()
text = tk.Text(window,height=39, width=43) 
text.pack()

quit_button=tk.Button(window,text="Quit",command=window.destroy)
quit_button.pack()
# Run the Tkinter event loop
window.mainloop()