Project 1 - English Dictionary App & Library Book Management System

from sys import builtin_module_names
from tkinter import *
from PyDictionary import PyDictionary

dictionary = PyDictionary
root=Tk()

root.geometry("600x600")
def dict():
meaning.config(text=dictionary.meaning(word.get())['Noun'][0])
upadate.config(text=dictionary.update(word.get()))
exist.config(text=dictionary.exist(word.get()))

Label(root,text='Dictionary',font=('Helvetica 20 bold'),fg='Blue').pack(pady=10)

# Frame1

frame = Frame(root)
Label(frame,text='Enter Word',font=('Helvetica 15 bold')).pack(side=LEFT)
word=Entry(frame,font=('Helvetica 15 bold'))
word.pack()
frame.pack(pady=10)

# Frame2

frame1 = Frame(root)
Label(frame1,text='meaning:-',font=('Helvetica 10 bold')).pack(side=LEFT)
meaning=Label(frame1,text="",font=('Helvetica 10 '))
meaning.pack()
frame1.pack(pady=10)

# Frame 3

frame2 = Frame(root)
Label(frame2,text='update:-',font=('Helvetica 10 bold')).pack(side=LEFT)
update=Label(frame1,text="",font=('Helvetica 10 '))
update.pack()
frame2.pack(pady=10)

# Frame 4

frame3 = Frame(root)
Label(frame3,text='exist:-',font=('Helvetica 10 bold')).pack(side=LEFT)
exist=Label(frame1,text="",font=('Helvetica 10 '))
exist.pack()
frame3.pack(pady=10)

Button(root,text='Submit',font=('Helvetica 15 bold'),command=dict).pack()

root.mainloop()

2.

# Libraries

from tkinter import *
import sqlite3
import tkinter.ttk as ttk
import tkinter.messagebox as tkMessageBox

root = Tk()
root.title('A Simple CRUD application')

# Methods

def Database():
global conn,cursor
conn = sqlite3.connect('simple.dp')
cursor = conn.cursor()
cursor.execute("CREATE TABLE IF NOT EXIST member(mem_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, booktitle TEXT, author TEXT, year INTEGER, ISBN INTEGER)")

def Create():
if BOOKTITLE.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 member(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 Read():
tree.delete(*tree.get_children)
Database()
cursor.execute("SELECT * FROM member ORDER BY lastname ASC")
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="black")

def Exit():
result=tkMessageBox.askquestion('Do you want to exit ? (y/n)',icon='warning')
if result == 'yes':
root.destroy()
exis()

# Variable decalration

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,bd=8,relief='raise')
Buttons.pack(side=BOTTOM)

# Labels

txt_title=Label(Top,width=900,text='A Simple CRUD application')
if __name__=='__main__':
root.mainloop()