Searching SQLite database using Python and PySimpleGUI

In this tutorial, we will learn how to search an SQLite database using Python with PySimpleGUI. SQLite is a lightweight database that does not require a separate server process to be run. PySimpleGUI is a Python GUI framework that makes it easy to create simple and user-friendly interfaces.

Before we get started, make sure you have Python and PySimpleGUI installed on your computer. You can install PySimpleGUI using pip by running the following command in your terminal:

pip install PySimpleGUI

Next, we need to create an SQLite database and insert some data into it. We will create a simple database that stores information about students, including their name, age, and grade.

import sqlite3

# Create a connection to the database
conn = sqlite3.connect('students.db')

# Create a cursor object
cursor = conn.cursor()

# Create a table to store the student data
cursor.execute('''CREATE TABLE students
                 (id INTEGER PRIMARY KEY, name TEXT, age INTEGER, grade TEXT)''')

# Insert some data into the table
cursor.execute("INSERT INTO students (name, age, grade) VALUES ('Alice', 18, 'A+'),"
                                                             "('Bob', 20, 'B-'),"
                                                             "('Charlie', 21, 'C')")
conn.commit()

# Close the connection
conn.close()

Now that we have created the database, we can write a Python script to search the database using PySimpleGUI. We will create a simple GUI with an input field where the user can enter a student’s name and a search button to perform the search.

import PySimpleGUI as sg
import sqlite3

# Create a connection to the database
conn = sqlite3.connect('students.db')
cursor = conn.cursor()

# Define the layout of the GUI
layout = [[sg.Text('Enter student name:'), sg.InputText(key='name'), sg.Button('Search')],
          [sg.Text(size=(30, 1), key='output')]]

# Create the window
window = sg.Window('Search Student Database', layout)

# Event loop
while True:
    event, values = window.read()

    if event == sg.WIN_CLOSED:
        break

    name = values['name']

    # Search the database for the student
    cursor.execute("SELECT * FROM students WHERE name=?", (name,))
    result = cursor.fetchone()

    if result is not None:
        output = f"Name: {result[1]}, Age: {result[2]}, Grade: {result[3]}"
    else:
        output = "Student not found"

    window['output'].update(output)

# Close the connection and window
conn.close()
window.close()

In this script, we first create a connection to the SQLite database and define the layout of the GUI using PySimpleGUI. We then create a window with an input field for the user to enter a student’s name and a search button to perform the search.

Inside the event loop, we retrieve the entered name from the input field and search the database for the student using a SQL query. If the student is found, we display their information in the output field; otherwise, we display a message indicating that the student was not found.

Finally, we close the connection to the database and the window when the user closes the window.

That’s it! You have now learned how to search an SQLite database using Python with PySimpleGUI. Feel free to modify the script to customize the GUI or add more advanced search functionality.