Post-It Notes Application Python Project

Notes-taking is a method of jotting down important information for reminders, chores, and other purposes. This keeps us informed about what has to be done and prevents us from neglecting critical duties. Let's look at a basic Python version of the Pin Your Note or sticky notes project.

The Python Sticky Notes project requires a database and an optional user interface to be implemented. SQLite3 is a built-in database in Python. As a result, we utilize the package to store and retrieve our notes.

Post-It Notes Application Project Requirements

No other libraries are required for this project. Tkinter is used to create the user interface, and SQlite3 is included.

Project File Structure:

The flow of the python project pin your notes is shown below.

1. Installing the required libraries

2. Establishing a database connection and constructing a table

3. Define functions for taking, editing, viewing, and deleting notes.

4. Creating a user interface is the fourth step.

Source Code for Post-It Notes Application Python Project

 #Pin Your Note -TechVidvan #Import Necessary modules import sqlite3 as sql from tkinter import * from tkinter import messagebox # Create database connection and connect to table try: con = sql.connect('pin_your_note.db') cur = con.cursor() cur.execute('''CREATE TABLE notes_table (date text, notes_title text, notes text)''') except: print("Connected to table of database") # Insert a row of data def add_notes(): #Get input values today = date_entry.get() notes_title = notes_title_entry.get() notes = notes_entry.get("1.0", "end-1c") #Raise a prompt for missing values if (len(today) <=0) & (len(notes_title)<=0) & (len(notes)<=1): messagebox.showerror(message = "ENTER REQUIRED DETAILS" ) else: #Insert into the table cur.execute("INSERT INTO notes_table VALUES ('%s','%s','%s')" %(today, notes_title, notes)) messagebox.showinfo(message="Note added") #Commit to preserve the changes con.commit() #Display all the notes def view_notes(): #Obtain all the user input date = date_entry.get() notes_title = notes_title_entry.get() #If no input is given, retrieve all notes if (len(date) <=0) & (len(notes_title)<=0): sql_statement = "SELECT * FROM notes_table" #Retrieve notes matching a title elif (len(date) <=0) & (len(notes_title)>0): sql_statement = "SELECT * FROM notes_table where notes_title ='%s'" %notes_title #Retrieve notes matching a date elif (len(date) >0) & (len(notes_title)<=0): sql_statement = "SELECT * FROM notes_table where date ='%s'"%date #Retrieve notes matching the date and title else: sql_statement = "SELECT * FROM notes_table where date ='%s' and notes_title ='%s'" %(date, notes_title) #Execute the query cur.execute(sql_statement) #Obtain all the contents of the query row = cur.fetchall() #Check if none was retrieved if len(row)<=0: messagebox.showerror(message="No note found") else: #Print the notes for i in row: messagebox.showinfo(message="Date: "+i[0]+"\nTitle: "+i[1]+"\nNotes: "+i[2]) #Delete the notes def delete_notes(): #Obtain input values date = date_entry.get() notes_title = notes_title_entry.get() #Ask if user wants to delete all notes choice = messagebox.askquestion(message="Do you want to delete all notes?") #If yes is selected, delete all if choice == 'yes': sql_statement = "DELETE FROM notes_table" else: #Delete notes matching a particular date and title if (len(date) <=0) & (len(notes_title)<=0): #Raise error for no inputs messagebox.showerror(message = "ENTER REQUIRED DETAILS" ) return else: sql_statement = "DELETE FROM notes_table where date ='%s' and notes_title ='%s'" %(date, notes_title) #Execute the query cur.execute(sql_statement) messagebox.showinfo(message="Note(s) Deleted") con.commit() #Update the notes def update_notes(): #Obtain user input today = date_entry.get() notes_title = notes_title_entry.get() notes = notes_entry.get("1.0", "end-1c") #Check if input is given by the user if (len(today) <=0) & (len(notes_title)<=0) & (len(notes)<=1): messagebox.showerror(message = "ENTER REQUIRED DETAILS" ) #update the note else: sql_statement = "UPDATE notes_table SET notes = '%s' where date ='%s' and notes_title ='%s'" %(notes, today, notes_title) cur.execute(sql_statement) messagebox.showinfo(message="Note Updated") con.commit() #Invoke call to class to view a window window = Tk() #Set dimensions of window and title window.geometry("500x300") window.title("Pin Your Note -TechVidvan") title_label = Label(window, text="Pin Your Note -TechVidvan").pack() #Read inputs #Date input date_label = Label(window, text="Date:").place(x=10,y=20) date_entry = Entry(window, width=20) date_entry.place(x=50,y=20) #Notes Title input notes_title_label = Label(window, text="Notes title:").place(x=10,y=50) notes_title_entry = Entry(window, width=30) notes_title_entry.place(x=80,y=50) #Notes input notes_label = Label(window, text="Notes:").place(x=10,y=90) notes_entry = Text(window, width=50,height=5) notes_entry.place(x=60,y=90) #Perform notes functions button1 = Button(window,text='Add Notes', bg = 'Turquoise',fg='Red',command=add_notes).place(x=10,y=190) button2 = Button(window,text='View Notes', bg = 'Turquoise',fg='Red',command=view_notes).place(x=110,y=190) button3 = Button(window,text='Delete Notes', bg = 'Turquoise',fg='Red',command=delete_notes).place(x=210,y=190) button4 = Button(window,text='Update Notes', bg = 'Turquoise',fg='Red',command=update_notes).place(x=320,y=190) #close the app window.mainloop() con.close()

Output

Summary

As a result, we were able to create a notes taker in Python. This Python Pin Your Note project is an introduction to SQLite querying and creating a user interface with Tkinter.