Project 1 - English Dictionary App & Library Book Management System
project 1 is done
## ENGLISH DICTINORY APP
import os
import json
def saveDictionary(tmp_dict):
try:
with open('word.txt','w') as dictionary:
json.dump(tmp_dict,dictionary)
print('Successfully entered')
except Exception as e:
print(f"ERROR:{e}")
def getDictionary():
try:
with open('word.txt','r') as dictionary:
tmp_dict=json.load(dictionary)
print('Successfully Read')
return tmp_dict
except Exception as e:
print(f"ERROR:{e}")
def addnewWord():
print('*'*20)
print("New Word Adder:")
print('*'*20)
print('Enter a word')
word=input("->")
print(f"Enter the meaning of {word} to add")
meaning=input("->")
dictionary=getDictionary()
dictionary[word]=meaning
saveDictionary(dictionary)
main_menu()
def findmeaning():
print('*'*20)
print(" Word Finder:")
print('*'*20)
print('Enter a word')
word=input("->").lower()
dictionary=getDictionary()
if word in dictionary:
print(f"Found : [{word} :{dictionary[word]}]")
else:
print("The word doesn't exist!..")
main_menu()
def updateWord():
print('*'*20)
print(" Word Updater:")
print('*'*20)
print('Enter a word to edit')
word=input("->")
dictionary=getDictionary()
if word in dictionary:
print(f"Enter a new meaning [{word} :{dictionary[word]}]")
new_meaning=input("->")
dictionary[word]=new_meaning
saveDictionary(dictionary)
print(f"Successfully Updated [{word} :{dictionary[word]}]")
else:
print("The word doesn't exist!..")
updateWord()
main_menu()
def main_menu():
if not os.path.exists(os.path.join("dictionary.json")):
try:
with open('word.txt','w') as dictionary:
json.dump({},dictionary)
print('Successfully Entered')
except Exception as e:
print(f"Error :{e}")
print("____________")
print("ENGLISH DICTIONARY APP")
print("____________")
print("1. Add a new word")
print("2. Find a new meaning")
print("3. update word")
print("4. Exit")
print("____________")
print('*'*10,'Enter 1 for Addnew word','*'*10)
print('*'*10,'Enter 2 for Find the meaning','*'*10)
print('*'*10,'Enter 3 for Update','*'*10)
print('*'*10,'Enter 4 for Exit','*'*10)
n=int(input("Enter the the Input ="))
if n==1:
addnewWord()
elif n==2:
findmeaning()
elif n==3:
updateWord()
elif n==4:
exit()
else:
print('Please Enter the correct digit according to the menu')
main_menu()
## LIBRARY BOOK MANAGEMENT SYSTEM
import tkinter
from tkinter import *
import sqlite3 as sq
import tkinter.ttk as ttk
from tkinter import messagebox
root = Tk()
root.title('A Library Application')
root.geometry('1200x800')
#****************************METHODS***************************
def Database():
global conn,cursor
conn = sq.connect('books.db')
cursor = conn.cursor()
cursor.execute("CREATE TABLE IF NOT EXISTS mybooks(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,title TEXT,author TEXT,year INTEGER,isbn INTEGER)")
def Add():
if TITLE.get()=='' or AUTHOR.get()=='' or YEAR.get()=='':
txt_result.config(text="Please Enter all the fields",fg='red')
else:
Database()
cursor.execute("INSERT INTO mybooks(title,author,year,isbn) VALUES(?,?,?,?)",(TITLE.get(),AUTHOR.get(),YEAR.get(),ISBN.get()))
conn.commit()
TITLE.set('')
AUTHOR.set('')
YEAR.set('')
ISBN.set('')
cursor.close()
conn.close()
txt_result.config(text="Record Added !",fg="green")
def Search():
if TITLE.get()=='' and AUTHOR.get()=='' and YEAR.get()=='' and ISBN.get()=='':
txt_result.config(text="Please Enter any of the details to search",fg='red')
else:
tree.delete(*tree.get_children())
Database()
cursor.execute('SELECT * FROM mybooks WHERE title=? OR author=? OR year=? OR isbn=?',(TITLE.get(),AUTHOR.get(),str(YEAR.get()),str(ISBN.get())))
rows = cursor.fetchall()
for data in rows:
tree.insert("",'end',values=(data[1],data[2],data[3],data[4]))
TITLE.set('')
AUTHOR.set('')
YEAR.set('')
ISBN.set('')
cursor.close()
txt_result.config(text="Search completed and results displayed !",fg='green')
def Display():
tree.delete(*tree.get_children())
Database()
cursor.execute('SELECT * FROM mybooks')
fetch = cursor.fetchall()
for data in fetch:
tree.insert("",'end',values=(data[1],data[2],data[3],data[4]))
cursor.close()
txt_result.config(text="Successfully fetched data !",fg='green')
def Exit():
if messagebox.askokcancel("Quit", "Do you want to Exit?"):
root.destroy()
exit()
def Delete():
if TITLE.get()=='' and AUTHOR.get()=='' and YEAR.get()=='' and ISBN.get()=='':
txt_result.config(text="Please Enter any of the details to delete",fg='red')
else:
Database()
cursor.execute('DELETE FROM mybooks WHERE title=? OR author=? OR year=? OR isbn=?',(TITLE.get(),AUTHOR.get(),YEAR.get(),str(ISBN.get())))
conn.commit()
TITLE.set('')
AUTHOR.set('')
YEAR.set('')
ISBN.set('')
cursor.close()
conn.close()
txt_result.config(text="Successfully deleted data and removed completely from the system !",fg='red')
def Issue():
if TITLE.get()=='' or AUTHOR.get()=='' or YEAR.get()=='':
txt_result.config(text="Please Enter all the fields",fg='red')
else:
TITLE.set('')
AUTHOR.set('')
YEAR.set('')
ISBN.set('')
txt_result.config(text="Successfully Issued the Book...!",fg="black")
#*********************************VARIABLE DECLARATION**********************************
TITLE = StringVar()
AUTHOR = StringVar()
YEAR = StringVar()
ISBN = StringVar()
#***********************************FRAME*************************************
Top = Frame(root,width=1200,height=100,bg='blue', bd=8, relief='raise')
Top.pack(side=TOP)
Left = Frame(root, width=1000, height=800,bg='red', bd=8, relief='raise')
Left.pack(side=LEFT)
Right = Frame(root,width=300,height=800,bg='yellow', bd=8,relief='raise')
Right.pack(side=RIGHT)
Forms = Frame(Left,width=1000,height=800)
Forms.pack(side=TOP)
Buttons = Frame(Left,width=1000,height=100,bd=8,relief='raise')
Buttons.pack(side=BOTTOM)
# **************************** LABEL WIDGET ****************************
main_title =Label(Top,width=1000,font=('arial',24),text=".....Library Management Application.....",bg='blue')
main_title.pack()
txt_title = Label(Forms, text="Booktitle:",font=('arial',16),bd=15)
txt_title.grid(row=0, stick="e")
txt_author = Label(Forms, text="Author:",font=('arial',16),bd=15)
txt_author.grid(row=1, stick="e")
txt_year = Label(Forms, text="Year:",font=('arial',16),bd=15)
txt_year.grid(row=2, stick="e")
txt_isbn = Label(Forms, text="ISBN:",font=('arial',16),bd=15)
txt_isbn.grid(row=3, stick="e")
txt_result = Label(Buttons)
txt_result.pack()
# *******************************ENTRY WIDGET****************************************
title = Entry(Forms,textvariable=TITLE, width=100)
title.grid(row=0,column=1)
author = Entry(Forms,textvariable=AUTHOR, width=100)
author.grid(row=1,column=1)
year = Entry(Forms,textvariable=YEAR, width=100)
year.grid(row=2,column=1)
isbn = Entry(Forms,textvariable=ISBN, width=100)
isbn.grid(row=3,column=1)
#*********************************** BUTTONS WIDGET *********************************
btn_display = Button(Buttons, width=10, text="Display", command=Display)
btn_display.pack(side=LEFT)
btn_search = Button(Buttons,width=10,text='Search', command=Search)
btn_search.pack(side=LEFT)
btn_add = Button(Buttons, width=10, text="Add",command=Add)
btn_add.pack(side=LEFT)
btn_issue = Button(Buttons, width=10, text ="Issue",command=Issue)
btn_issue.pack(side=LEFT)
btn_delete = Button(Buttons,width=10,text='Delete',command=Delete)
btn_delete.pack(side=LEFT)
btn_exit = Button(Buttons,width=10,text='Exit',command = Exit)
btn_exit.pack(side=LEFT)
# ************************** LIST WIDGET *************************************
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)
scrollbarx.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=0)
tree.column('#1', stretch=NO, minwidth=0, width=200)
tree.column('#2', stretch=NO, minwidth=0, width=100)
tree.column('#3', stretch=NO, minwidth=0, width=50)
tree.column('#4', stretch=NO, minwidth=0, width=100)
tree.pack()
# **************************** INITIALIZATION **********************************
if __name__=='__main__':
root.mainloop()