python_projects/tkinter_gui_for_postgresql.py at main · ozgurk33/python_projects · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
from tkinter import *
from tkinter import ttk
from tkinter import messagebox
import psycopg2


def run_query(query, parameters = ()):
    #Collect these informations from your own database
    conn = psycopg2.connect(dbname = "", user = "", password = "", host = "", port = "")
    cur = conn.cursor()
    query_result = None
    try:
        cur.execute(query, parameters)
        if query.lower().startswith("select"):
            query_result = cur.fetchall()
        conn.commit()
    except psycopg2.Error as e:
        messagebox.showerror("Database Error", str(e))

    finally:
        cur.close()
        conn.close()

    return query_result

def refresh_treeview():
    for item in tree.get_children():
        tree.delete(item)
    records = run_query("select * from students;")
    for record in records:
        tree.insert('',END,values = record)

def insert_data():
    query = "insert into students(name, address, age, number) values(%s,%s,%s,%s)"
    parameters = (name_entry.get(), address_entry.get(), age_entry.get(), phone_entry.get())
    run_query(query, parameters)
    messagebox.showinfo("Information", "Data inserted successfully")
    refresh_treeview()

def delete_data():
    selected_item = tree.selection()[0]
    student_id = tree.item(selected_item)['values'][0]
    query = "delete from students where student_id=%s"
    parameters = (student_id,)
    run_query(query, parameters)
    messagebox.showinfo("Information", "Data deleted successfully!")
    refresh_treeview()

def update_data():
    selected_item = tree.selection()[0]
    student_id = tree.item(selected_item)['values'][0]
    query = "update students set name=%s, address=%s, age=%s, number=%s where student_id=%s"
    parameters = (name_entry.get(), address_entry.get(), age_entry.get(), phone_entry.get(), student_id)
    run_query(query, parameters)
    messagebox.showinfo("Information", "Data updated successfully!")
    refresh_treeview()

def create_table():
    query = "create table if not exists students(student_id serial primary key, name text, address text, age int, number text);"
    run_query(query)
    messagebox("Information", "Table created")
    refresh_treeview()

root = Tk()
root.title("Student Management System")

frame = LabelFrame(root, text = "Student Data")
frame.grid(row = 0, column = 0, padx = 10, pady = 10, sticky = "ew")

Label(frame, text = "Name:").grid(row = 0, column = 0, padx = 2, sticky = "w")
name_entry = Entry(frame)
name_entry.grid(row = 0, column = 1, pady = 2, sticky = "ew")

Label(frame, text = "Address:").grid(row = 1, column = 0, padx = 2, sticky = "w")
address_entry = Entry(frame)
address_entry.grid(row = 1, column = 1, pady = 2, sticky = "ew")

Label(frame, text = "Age:").grid(row = 2, column = 0, padx = 2, sticky = "w")
age_entry = Entry(frame)
age_entry.grid(row = 2, column = 1, pady = 2, sticky = "ew")

Label(frame, text = "Phone number:").grid(row = 3, column = 0, padx = 2, sticky = "w")
phone_entry = Entry(frame)
phone_entry.grid(row = 3, column = 1, pady = 2, sticky = "ew")

button_frame = Frame(root)
button_frame.grid(row = 1, column = 0, pady = 5, sticky = "ew")

Button(button_frame, text = "Create Table", command = create_table).grid(row = 0, column = 0, padx = 5)
Button(button_frame, text = "Add Data", command = insert_data).grid(row = 0, column = 1, padx = 5)
Button(button_frame, text = "Update Data", command = update_data).grid(row = 0, column = 2, padx = 5)
Button(button_frame, text = "Delete Data", command = delete_data).grid(row = 0, column = 3, padx = 5)

tree_frame = Frame(root)
tree_frame.grid(row = 2, column = 0, padx = 10, sticky = "nsew")

tree_scroll = Scrollbar(tree_frame)
tree_scroll.pack(side = RIGHT, fill = Y)

tree = ttk.Treeview(tree_frame, yscrollcommand= tree_scroll.set, selectmode = "browse")
tree.pack()
tree_scroll.config(command = tree.yview)

tree['columns'] = ("student_id", "name", "address", "age", "number")
tree.column("#0", width = 0, stretch= NO)
tree.column("student_id", anchor = CENTER, width = 80)
tree.column("name", anchor = CENTER, width = 120)
tree.column("address", anchor = CENTER, width = 120)
tree.column("age", anchor = CENTER, width = 50)
tree.column("number", anchor = CENTER, width = 120)

tree.heading("student_id", text = "ID", anchor = CENTER)
tree.heading("name", text = "Name", anchor = CENTER)
tree.heading("address", text = "Address", anchor = CENTER)
tree.heading("age", text = "Age", anchor = CENTER)
tree.heading("number", text = "Phone Number", anchor = CENTER)

refresh_treeview()

root.mainloop()