#Main Menu
# Add a new word
# Find the meaning
# Update a word
# Exit
import json #We use json to open the file that contains the data.json stands for JavaScript object notation.
print("Welcome to the directory \nPlease select your choice \n1.Add a Word \n2.Find the meaning \n3.Update the word\n4.Exit")
f = open('word.txt','w')
our_dict = {} #The our_dict is the dictionary of the words user will provide by choosing option 1.
json.dump(our_dict,f) #Then this word is store into the word text file by using fuction dump.
f.close()
while True: #While loop is used to execute a block of code repeatedly until given boolean condition
n = int(input('Enter the choise:')) #We ask for word from user
if n==1:
import json
f=open('word.txt','w') #if user choose 1st option the file word text is open,
word = input("Enter the word:") #Then we ask for word to put in our file
meaning = input("Enter the Meaning:") #Then we asl for meaning of the word to put in our file
our_dict[word] = meaning #Then we add thos words and meaning in our dictionary
json.dump(our_dict,f) #The we dump this dictionary into our sord file
f.close()
elif n == 2:
import json
f=open('word.txt','r+')
dic = json.load(f) #Here we load the dictionary from our word text file to find user word
find= input("Enter the Word to find:")#Find is used to find the word in our word file
if find in our_dict:
print("The meaning is",our_dict.get(find)) #Then we get that word from our file to put its meaning
else:
print("Sorry the word is not found")
json.dump(our_dict,f)
f.close()
elif n==3:
import json
f=open('word.txt','w')
word1 = input("Enter the word:")
update_meaning = input("Enter the Meaning:") #Here we upade the meaning of that word and then store in our word file
our_dict[word1] = update_meaning
json.dump(our_dict,f)
f.close()
elif n==4:
print('Thank You! Have a Peacefull Life....') #After user select the 4th option this message is display
print('*_*'*39)
break
else:
print("Welcome to the directory \nPlease select your choice \n1.Add a Word \n2.Find the meaning \n3.Update the word\n4.Exit")
# 2] Library Book Management System
# Aim: Library Book Management System will be implemented with the front end GUI developed using Tkinter and the backend database implemented in SQLite.
import sqlite3
from tkinter import*
import tkinter.ttk as ttk
import tkinter.messagebox as tkMessageBox
root=Tk()
root.title("Libary Book Management")
bg = PhotoImage(file = "cos.png")
label = Label(root,image = bg)
label.place(x=0,y=0)
def Database():
global conn,cursor
conn = sqlite3.connect('lab.db')
cursor = conn.cursor()
cursor.execute("CREATE TABLE IF NOT EXISTS lab(booktitle TEXT,author TEXT,year TEXT,isbn TEXT)")
def Add():
Database()
if BOOKTITLE.get()=="" or AUTHOR.get()=="" or YEAR.get()==""or ISBN.get()=="":
txt_result.config(text="Please enter all values",fg="red")
else:
cursor.execute("INSERT INTO lab(booktitle,author,year,isbn) values(?,?,?,?)",[str(BOOKTITLE.get()),str(AUTHOR.get()),str(YEAR.get()),str(ISBN.get())])
conn.commit()
BOOKTITLE.set("")
AUTHOR.set("")
YEAR.set("")
ISBN.set("")
cursor.close()
conn.close()
txt_result.config(text="Record Inserted",fg="green")
def Display():
Database()
cursor.execute("SELECT * FROM lab ORDER BY booktitle ASC")
fetch = cursor.fetchall()
for data in fetch:
tree.insert('','end',values=(data[0],data[1],data[2],data[3]))
cursor.close()
txt_result.config(text="Successful fetch data",fg="black")
def Search():
Database()
cursor.execute("SELECT * FROM lab WHERE booktitle = ? or author = ? or year = ? or isbn=? ",[str(BOOKTITLE.get()),str(AUTHOR.get()),str(YEAR.get()),str(ISBN.get())])
rows=cursor.fetchall()
for data in rows:
tree.insert('','end',values=(data[0],data[1],data[2],data[3]))
cursor.close()
def Issue():
Database()
txt_result.config(text="Book is Issue.Thank you",fg = "green")
def Delete():
Database()
cursor.execute("DELETE FROM lab WHERE booktitle = ? or author = ? or year = ? or isbn=? ",[str(BOOKTITLE.get()),str(AUTHOR.get()),str(YEAR.get()),str(ISBN.get())])
cursor.close()
txt_result.config(text="Successfully Deleted!!!",fg="red")
def Exit():
result = tkMessageBox.askquestion('Do you want to exit? (y/n)',icon='warning')
if result == "yes":
root.destroy()
exit()
BOOKTITLE = StringVar()
AUTHOR = StringVar()
YEAR = StringVar()
ISBN = StringVar()
Top = Frame(root,width = 900,height = 50,bd=8,relief = 'raise')
Top.pack(side = TOP)
Left = Frame(root,width = 300,height = 500,bd=8,relief = 'raise')
Left.pack(side = LEFT)
Right = Frame(root,width = 600,height = 500,bd=8,relief = 'raise')
Right.pack(side = RIGHT)
Forms = Frame(Left,width = 300,height = 450)
Forms.pack(side = TOP)
Buttons = Frame(Left,width = 300,height = 100,relief = 'raise')
Buttons.pack(side = BOTTOM)
txt_title = Label(Top,width=900,font=('arial',24),text='Libary Book Management')
txt_title.pack()
txt_booktitle = Label(Forms,font=('arial',16),text='Book Title',bd=15)
txt_booktitle.grid(row=0,stick='e')
txt_author = Label(Forms,font=('arial',16),text='Author',bd=15)
txt_author.grid(row=1,stick='e')
txt_year = Label(Forms,font=('arial',16),text='Year',bd=15)
txt_year.grid(row=2,stick='e')
txt_isbm = Label(Forms,font=('arial',16),text='ISBN',bd=15)
txt_isbm.grid(row=3,stick='e')
txt_result = Label(Buttons)
txt_result.pack(side=TOP)
booktitle = Entry(Forms,textvariable = BOOKTITLE,width=30)
booktitle.grid(row=0,column=1)
author = Entry(Forms,textvariable = AUTHOR,width=30)
author.grid(row=1,column=1)
year = Entry(Forms,textvariable = YEAR,width=30)
year.grid(row=2,column=1)
isbm = Entry(Forms,textvariable = ISBN,width=30)
isbm.grid(row=3,column=1)
but_read = Button(Buttons,width = 10,text = 'Display',command=Display)
but_read.pack(side=LEFT)
but_search = Button(Buttons,width = 10,text = 'Search',command=Search)
but_search.pack(side=LEFT)
but_create = Button(Buttons,width = 10,text = 'Add',command=Add)
but_create.pack(side=LEFT)
but_issue = Button(Buttons,width = 10,text = 'Issue',command=Issue)
but_issue.pack(side=LEFT)
but_delete = Button(Buttons,width = 10,text = 'Delete',command=Delete)
but_delete.pack(side=LEFT)
but_exit = Button(Buttons,width = 10,text = 'Exit',command=Exit)
but_exit.pack(side=LEFT)
scrollbary = Scrollbar(Right,orient=VERTICAL)
scrollbarx = Scrollbar(Right,orient=HORIZONTAL)
tree = ttk.Treeview(Right,columns=("BookTitle","Author","Year","Isbn"))
scrollbary.config(command=tree.yview)
scrollbary.pack(side=RIGHT,fill=Y)
scrollbarx.config(command=tree.xview)
scrollbary.pack(side=BOTTOM,fill=X)
tree.heading('BookTitle',text="Booktitle",anchor=W)
tree.heading('Author',text="Author",anchor=W)
tree.heading('Year',text="Year",anchor=W)
tree.heading('Isbn',text="ISBN",anchor=W)
tree.column("#0",stretch=NO,minwidth=0,width=20)
tree.column("#1",stretch=NO,minwidth=0,width=180)
tree.column("#2",stretch=NO,minwidth=0,width=60)
tree.column("#3",stretch=NO,minwidth=0,width=60)
tree.column("#4",stretch=NO,minwidth=0,width=80)
tree.pack()
if __name__ == "__main__":
root.mainloop()