importsqlite3defFriendlist():conn=sqlite3.connect("Friend")cur=conn.cursor()cur.execute("create table if not exists friendlist(id integer primary key,name text,facebook text,instagram text,whatsapp text)")conn.commit()conn.close()defadd_friendlist(name,facebook,instagram,whatsapp):conn=sqlite3.connect("Friend")cur=conn.cursor()cur.execute("insert into friendlist values(null,?,?,?,?)",(name,facebook,instagram,whatsapp))conn.commit()conn.close()defview_friendlist():conn=sqlite3.connect("Friend")cur=conn.cursor()cur.execute("select * from friendlist")row=cur.fetchall()conn.close()returnrowdefdelete_friendlist(id):conn=sqlite3.connect("Friend")cur=conn.cursor()cur.execute("delete from friendlist where id=?",(id,))conn.commit()conn.close()defupdate_friendlist(id,name=" ",facebook=" ",whatsapp=" ",instagram=" "):conn=sqlite3.connect("Contact")cur=conn.cursor()cur.execute("select * from friendlist where name=?  or facebook=? or whatsapp=? or instagram=?",(name,facebook,whatsapp,instagram,id))conn.commit()conn.close()Friendlist()

""" This is desktop application for adding friends in database tkinter project """fromtkinterimport*fromtkinterimportttkfromdbimport*importtkinter.messageboxclassFriendList:def__init__(self,root):self.root=rootself.root.title("Friend list")self.root.geometry("400x450")# self.root.iconbitmap("./favicon.ico")self.root.resizable(0,0)#  variable for taking inputs from entrysid=StringVar()name=StringVar()facebook=IntVar()instagram=IntVar()whatsapp=IntVar()# function for button#  for adding data in databasedefadd():try:iffacebook.get()==1:face="present"else:face="not present"ifinstagram.get()==1:insta="present"else:insta="not present"ifwhatsapp.get()==1:whats="present"else:whats="not present"ifname.get()!="":add_friendlist(name.get(),face,insta,whats)show()else:tkinter.messagebox.showerror('Error',"Please Add Your Friend Name")exceptExceptionase:print(e)#  showing data from database to contact_treedefshow():contact_trees.delete(*contact_trees.get_children())forrowinview_friendlist():contact_trees.insert('',END,values=row)#  deleting data from databasedefdelete():delete_friendlist(sid.get())sid.set("")show()#  update databasedefupdate():try:ifsid.get()!="":delete_friendlist(sid.get())ifname.get()!="":iffacebook.get()==1:face="present"else:face="not present"ifinstagram.get()==1:insta="present"else:insta="not present"ifwhatsapp.get()==1:whats="present"else:whats="not present"add_friendlist(name.get(),face,insta,whats)show()else:tkinter.messagebox.showerror("Error","Please Select what you have to update and also write Id")except:pass#   This is for hovering buttondefon_enter1(e):but_add['background']="black"but_add['foreground']="cyan"defon_leave1(e):but_add['background']="SystemButtonFace"but_add['foreground']="SystemButtonText"defon_enter2(e):but_update['background']="black"but_update['foreground']="cyan"defon_leave2(e):but_update['background']="SystemButtonFace"but_update['foreground']="SystemButtonText"defon_enter3(e):but_delete['background']="black"but_delete['foreground']="cyan"defon_leave3(e):but_delete['background']="SystemButtonFace"but_delete['foreground']="SystemButtonText"defon_enter4(e):but_show['background']="black"but_show['foreground']="cyan"defon_leave4(e):but_show['background']="SystemButtonFace"but_show['foreground']="SystemButtonText"#====================frame==============================#mainframe=Frame(self.root,width=400,height=450,relief="ridge",bd=3)mainframe.place(x=0,y=0)firstframe=Frame(mainframe,width=394,height=230,relief="ridge",bd=3)firstframe.place(x=0,y=0)secondframe=Frame(mainframe,width=394,height=214,relief="ridge",bd=3)secondframe.place(x=0,y=230)#======================firstframe========================#lab_name=Label(firstframe,text="Enter Name",font=('times new roman',15))lab_name.place(x=150,y=10)identry=Entry(firstframe,width=3,font=('times new roman',14),relief="ridge",bd=3,textvariable=sid)identry.place(x=27,y=50)ent_name=Entry(firstframe,width=25,font=('times new roman',15),relief='ridge',bd=3,justify="center",textvariable=name)ent_name.place(x=65,y=50)but_show=Button(firstframe,text="List",width=4,font=('times new roman',14),cursor="hand2",command=show)but_show.place(x=325,y=45)but_show.bind("<Enter>",on_enter4)but_show.bind("<Leave>",on_leave4)facebook_cbutton=Checkbutton(firstframe,text="facebook",variable=facebook,font=('times new roman',15),onvalue=1,offvalue=0)facebook_cbutton.place(x=15,y=110)instagram_cbutton=Checkbutton(firstframe,text="Instagram",variable=instagram,font=('times new roman',15),onvalue=1,offvalue=0)instagram_cbutton.place(x=135,y=110)whatsapp_cbutton=Checkbutton(firstframe,text="Whatsapp",variable=whatsapp,font=('times new roman',15),onvalue=1,offvalue=0)whatsapp_cbutton.place(x=255,y=110)but_add=Button(firstframe,text="Add",width=10,font=('times new roman',14),cursor="hand2",command=add)but_add.place(x=10,y=170)but_add.bind("<Enter>",on_enter1)but_add.bind("<Leave>",on_leave1)but_update=Button(firstframe,text="Update",width=10,font=('times new roman',14),cursor="hand2",command=update)but_update.place(x=135,y=170)but_update.bind("<Enter>",on_enter2)but_update.bind("<Leave>",on_leave2)but_delete=Button(firstframe,text="Delete",width=10,font=('times new roman',14),cursor="hand2",command=delete)but_delete.place(x=260,y=170)but_delete.bind("<Enter>",on_enter3)but_delete.bind("<Leave>",on_leave3)#===================================secondframe==================================================#defgame(event):crow=contact_trees.focus()contents=contact_trees.item(crow)row=contents['values']sid.set(row[0])name.set(row[1])scol=Scrollbar(secondframe,orient="vertical")scol.place(relx=1,rely=0,relheight=1,anchor='ne')contact_trees=ttk.Treeview(secondframe,columns=("ID","Name","Facebook","Instagram","Whatsapp"),height=9,yscrollcommand=scol.set)contact_trees.heading("ID",text="ID")contact_trees.heading("Name",text="Name")contact_trees.heading("Facebook",text="Facebook")contact_trees.heading("Instagram",text="Instagram")contact_trees.heading("Whatsapp",text="Whatsapp")contact_trees['show']="headings"contact_trees.column("ID",width=30,minwidth=10)contact_trees.column("Name",width=110,minwidth=40)contact_trees.column("Facebook",width=76,minwidth=40)contact_trees.column("Instagram",width=76,minwidth=40)contact_trees.column("Whatsapp",width=76,minwidth=40)contact_trees.place(x=0,y=0)contact_trees.bind('<ButtonRelease-1>',game)if__name__=="__main__":root=Tk()FriendList(root)root.mainloop()

python app.py