Tkinter child window using Toplevel to execute user entered SQL query on SQLite database and display result

Tkinter child window using Toplevel to execute user entered SQL query on SQLite and display result

Opening Query window

We will use the Query button to execute the function my_child() to open the child window. Inside this function we will display the Text to collect the user entered SQL.

def my_child():
    my_w_child=tk.Toplevel(my_w)
    my_w_child.geometry("400x200")
    my_w_child.title('www.plus2net.com')
    
    l1_q=tk.Label(my_w_child,text='Query')
    l1_q.grid(row=1,column=1)
    t1_child=tk.Text(my_w_child, bg='yellow',height=5,width=45)
    t1_child.grid(row=2,column=1,padx=10,columnspan=2)
    t1_child.insert(tk.END, sql_str.get()) # to retain the query while opening 
    b3=tk.Button(my_w_child,text='Submit', command=lambda:child_close())
    b3.grid(row=3,column=1)
    def child_close():
        sql_str.set(t1_child.get("1.0",'end-1c')) # collect the query
        my_data(t1_child.get("1.0",'end-1c')) # pass the query 
        my_w_child.destroy() # close the child window

On click of submit button on child window, we will execute another function child_close() to close the child window and pass the user entered query to another function my_data(). After sending the data we will close the child window.

Executing the query : my_data()

Our function my_data() will receive the query and first it will delete the previous data if any in our main display Text area . Then set the background to white by using config()

We will find out the type of query user has entered, if SELECT word is present then show all the records.

Using one try except code block run the query and set the result.

Finally we will display the result.

The connection to SQLite ( the connection.py file ) is available in Part -1 of SQlite connector. connector-sqlite-part-2

from sqlalchemy import create_engine
from sqlalchemy.exc import SQLAlchemyError
import tkinter as tk
from tkinter import END
from connection import my_connect
global my_conn
### connect to database ####
def my_connect_p(status):
    global my_conn
    my_conn,my_output,file=my_connect(status) # connection details 
    t1.delete('1.0',END)
    t1.update()
    if(my_conn and my_output=='ok'):
        my_output=''
        r_set=my_conn.execute("SELECT name FROM sqlite_master WHERE type='table'")
        my_list_of_tables=r_set.fetchall() # table list 
        if(len(my_list_of_tables)>0):
            for i in my_list_of_tables:
                my_output=my_output + str(i[0]) + '\n'
        else:
            my_output=" No table found "
        t1.config(bg='white')
        b2.config(state='normal') # query window 
        l1_path.config(text=file)
    else:
        t1.config(bg='red') # background colour for error message 
        b2.config(state='disabled') # query window 
    t1.insert(tk.END,my_output)
## to collect data from database ###
def my_data(query):
    t1.delete('1.0',END) # delete the previous data if any
    t1.update() 
    my_output=''
    t1.config(bg='white') # change background colour 
    try:
        r_set=my_conn.execute(query)
        print(query.lower().find('select')) # Check query type
        if(query.lower().find('select')!=-1): # show records for select query
            for i in r_set:
                my_output=my_output + str(i) +'\n'
        else: # Not a select query so show records affected. 
            my_output="rows affected :" + str(r_set.rowcount)                        
    except SQLAlchemyError as e:  # handle error 
        error = str(e.__dict__['orig'])
        my_output=error
        t1.config(bg='red')
    t1.insert(tk.END,my_output)  # show the output

### layout design of the widgets in window ##
my_w = tk.Tk()
my_w.geometry("590x500") # width & height of window
sql_str=tk.StringVar()
font1=('Times',26,'bold') # higer size font
l0=tk.Label(my_w,text='plus2net.com SQLite Connector',font=font1)
l0.grid(row=0,column=1,columnspan=8)
b1=tk.Button(my_w,text='Browse & Connect',width=20,command=lambda:my_connect_p('existing'))
b1.grid(row=1,column=1)
l1_path=tk.Label(my_w,text='') # to display the path only
l1_path.grid(row=1,column=2)
b2=tk.Button(my_w,text='Query window ',state='disabled',command=lambda:my_child()) # query button 
b2.grid(row=2,column=9)
b3=tk.Button(my_w,text='New Database',command=lambda:my_connect_p('new'))
b3.grid(row=3,column=9)

t1=tk.Text(my_w,height=20,width=40) # Display details 
t1.grid(row=2,column=1,columnspan=8)
#######Opening of child window ########
def my_child():
    my_w_child=tk.Toplevel(my_w)
    my_w_child.geometry("400x200")
    my_w_child.title('www.plus2net.com')
    
    l1_q=tk.Label(my_w_child,text='Query')
    l1_q.grid(row=1,column=1)
    t1_child=tk.Text(my_w_child, bg='yellow',height=5,width=45)
    t1_child.grid(row=2,column=1,padx=10,columnspan=2)
    t1_child.insert(tk.END, sql_str.get()) # to retain the query while opening 
    b3=tk.Button(my_w_child,text='Submit', command=lambda:child_close())
    b3.grid(row=3,column=1)
    def child_close():
        sql_str.set(t1_child.get("1.0",'end-1c')) # collect the query
        my_data(t1_child.get("1.0",'end-1c')) # pass the query 
        my_w_child.destroy() # close the child window
#######
my_w.mainloop()

SQLite Connector Part -1 ( Browse and connect OR create database ) SQLite Connector Part -3 (Run Queries)

Python Tkinter Dictionary Python- Tutorials

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

Subscribe to our YouTube Channel here

Query window & SQLite database

Opening Query window

Executing the query : my_data()

Subhendu Mohapatra