Python GUI Dbase Sys: 4/9

Python GUI Dbase Sys: 4/9

I'll put in the code for both files as a first comment
Here, I put in the: List Records button

[MaxGoddur]

Explaining how the "be.view" function works was extremely helpful.

[hassanramazan]

it was really great and useful, thanks dear George Boole

[hobokengar]

Here is the code for the FE and BE file...for this lesson, 4/9:
from tkinter import *
import be # backend.py for him


rt=Tk()
rt.wm_title("Personnel Management System.")


def view_command():
lb1.delete(0, END)
for row in be.view():
lb1.insert(END, row)

def add_command():
if(len(fn.get())!=0):
be.addrec(fn.get(), ln.get(), dpt.get(), sal.get())
# now insert that record
# into the listbox
lb1.delete(0, END)
lb1.insert(END, (fn.get(), ln.get(), dpt.get(), sal.get()))


for Variables
r=2
# rt=Tk()
l0=Label(rt, text="")
l0.grid(row=r-1, column=0)
l1=Label(rt, text="F.Name")
l1.grid(row=r, column=0)

l2=Label(rt, text="L.Name")
l2.grid(row=r+1, column=0)

l3=Label(rt, text="Dept")
l3.grid(row=r+2, column=0)

l4=Label(rt, text="Salary")
l4.grid(row=r+3, column=0)

Entry Variables
fn=StringVar()
e1=Entry(rt, textvariable=fn)
e1.grid(row=r, column=1)

ln=StringVar()
e2=Entry(rt, textvariable=ln)
e2.grid(row=r+1, column=1)

dpt=StringVar()
e3=Entry(rt, textvariable=dpt)
e3.grid(row=r+2, column=1)

sal=StringVar()
e4=Entry(rt, textvariable=sal)
e4.grid(row=r+3, column=1)


lb1=Listbox(rt, height=6, width = 60)
lb1.grid(row=8, column=0, rowspan=6, \
columnspan=6)

sb=Scrollbar(rt)
sb.grid(row=7, column=5, rowspan=7)






b1=Button(rt, text="List Recs", width=25, \
command=view_command)
b1.grid(row=0, column=0)

b2=Button(rt, text="Add Recs", width=25, \
command=add_command)
b2.grid(row=0, column=1)

#
rt.mainloop()
# end of FE.PY



# Here is the code for BE.py:

import sqlite3

def konnect():

cur=con.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS emp \
(id INTEGER PRIMARY KEY, \
fn text, ln text, dept text, sal integer)")
con.commit()
con.close()

def addrec(fn, ln, dept, sal):

cur=con.cursor()
cur.execute("INSERT INTO emp VALUES(NULL, ?, ?, ?, ?)", (fn, ln, dept, sal))
con.commit()
con.close()

def view():

cur=con.cursor()
cur.execute("SELECT * FROM emp")
rows=cur.fetchall()
con.close()
return rows


konnect()

[helmuta]

Dear Sir,
many thanks for instruction. Please allow me a question:
Why is there no con.commit() in view() - as in konnect() and addrec()
Is there no commitment necessary?
Greetings from the Rhine River (DE)
Helmut

[MaxGoddur]

Looking forward to edit, search and delete parts of the DB interface.

[sohomtirthabanerjee]

Sir, Please share the code in text format.Thank you.

[hassanramazan]

dear George Boole I want to make a dictionary in two or three languages (Persian, English and my own language) that should work on multi platform, could you please assist me in this case?
best of lucks