Project 1 - English Dictionary App & Library Book Management System

If you want to be recognized as a professional programmer, you have to practice more and develop applications in Python which you can include in your online portfolio. To achieve this, one such comprehensive project (with two small sub-projects inside it) is added which have to be completed by every student.

1A: English Dictionary App

This project uses the skills learnt from week 1 to week 6. The aim of this project is to create an English Dictionary app that returns definitions of English words.

import json
print('Mainmenu \n\n 1.Add a word \n 2.Find the meaning \n 3.Update a word \n 4.Exit \n')
while True:
    try:
        action=int(input('Please select from the given mainmenu(1,2,3,4):'))
    except ValueError :
        print('!!!!Please enter interger values only!!!')
        print('#'*50)
    else:
        if action==4:
            e=input('Are you sure you want to exit?(yes/no):')
            if e=='Yes' or e=='yes':
                print('Thank you have a nice day!!')
                print('#'*50)
                break
            else:
                continue
        elif action==1:
            word=input('Enter a new word:')
            meaning=input('Enter meaning of the word you entered:')
            add={word:meaning}
            with open('words.txt','a')as f:
                f.write(json.dumps(add))
                f.write('\n')
            print('Word added sucessfully')
            print('#'*50)
        elif action==2:
            find=input('Enter a word to find its meaning:')
            with open ('words.txt','r')as f:
                data=f.read()
                if find in data:
                    print(f'Meaning of the word you entered is : {meaning}')
                    print('#'*50)
                    continue
                else:
                    print('Word not found')
                    print('#'*50)
        elif action==3:
            oldword=input('Enter a word to be updated:')
            with open ('words.txt','r')as f:
                data=f.read()
                if oldword in data:
                    newword=input('Enter new a word:')
                    data = data.replace(oldword,newword)
                    with open("words.txt", "w") as file:
                          file.write(data)
                    print(f'{oldword} has been updated to {newword}')
                    print('#'*50)
                    continue
                else:
                    print('Word not found')
                    print('#'*50)
        else:
            print('!!!Please chose the correct option from the Mainmenu!!!')
            print('#'*50)

1B: Library Book Management System

In this project, a Library Book Management System will be implemented with the front end GUI developed using Tkinter and the backend database implemented in SQLite. It is a single window tkinter GUI application which will implement CRUD( create, read, update, delete) operations on a ‘books’ database, in SQLite. The window will contain text widgets to accept / display book title, author, year of publication, ISBN (optional) and a large text area/ list box to display the records which match the search criteria.

import sqlite3 as sql 
import tkinter as tk
import tkinter.ttk as ttk
import tkinter.messagebox as mb
import tkinter.simpledialog as sd
from tkinter import *


root=Tk()
root.title('.....Library Management Application.....')


def Database():
    global conn,cursor
    conn=sql.connect('simple.db')
    cursor=conn.cursor()
    cursor.execute('CREATE TABLE IF NOT EXISTS Booklibrary(Bookname TEXT,Author TEXT,Year TEXT, ISBN TEXT)')

def create():
    if BOOKNAME.get()=="" or AUTHOR.get()=="" or YEAR.get() =="" or ISBN.get()=="":
        txt_result.config(text='Please Enter all the fields',fd='red')
    else:
        Database()
        cursor.execute('INSERT INTO Booklibrary(Bookname,Author,Year,ISBN)VALUES(?,?,?,?)',(str(BOOKNAME.get()),str(AUTHOR.get()),str(YEAR.get()),str(ISBN.get())))
        conn.commit()
        BOOKNAME.set("")
        AUTHOR.set("")
        YEAR.set("") 
        #ISBN.set("")
        cursor.close()
        conn.close()
        txt_result.config(text='Record Inserted !',fg='green')
def Read():
    tree.delete(*tree.get_children())
    Database()
    cursor.execute('SELECT * FROM Booklibrary ORDER BY Author 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='Successfully fetched data !',fg='black')
def Exit():
    result=mb.askquestion('Do you want to Exit ?(y/n)',icon='warning')
    if result == 'yes':
        root.destroy()
        exit()


#variables..
BOOKNAME=StringVar()
AUTHOR=StringVar()
YEAR=StringVar() 
ISBN=StringVar()



 #FRAMES
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=400,height=1000)
Forms.pack(side="top")

#buttons
Buttons=Frame(Left,width=300,height=100,bd=8,relief='raise')
Buttons.pack(side="bottom")

#Labels
txt_title=Label(Top,width=900,font=('arial',24),text='.....Library Management Application.....')
txt_title.pack()
txt_Bookname=Label(Forms,text='Bookname',font=('arial',16),bd=15)
txt_Bookname.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(side=TOP)

#Entry widgets
Bookname=Entry(Forms,textvariable=BOOKNAME,width=30)
Bookname.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)
ISBN=Entry(Forms,textvariable=ISBN,width=30)
ISBN.grid(row=3,column=1)

#Button widgets
btn_display=Button(Buttons,width=10,text="Display")
btn_display.pack(side="left")
btn_search=Button(Buttons,width=10,text="Search")
btn_search.pack(side="left")
btn_add=Button(Buttons,width=10,text="Add",command=create)
btn_add.pack(side="left")
btn_issue=Button(Buttons,width=10,text="Issue",command=Read)
btn_issue.pack(side="left")                     
btn_delete=Button(Buttons,width=10,text="Delete")
btn_delete.pack(side="left")                     
btn_exit=Button(Buttons,width=10,text="Exit",command=Exit)
btn_exit.pack(side="left")      


#list widgets
scrollbary=Scrollbar(Right,orient=VERTICAL)
scrollbarx=Scrollbar(Left,orient=HORIZONTAL)

tree=ttk.Treeview(Right,columns=('Book','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('Book',text='Book',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=80)
tree.column('#2',stretch=NO,minwidth=0,width=120)
tree.column('#3',stretch=NO,minwidth=0,width=160)
tree.pack()
#instaaliztion
root.mainloop()