main.py

"""
main (and only) file with
- event-functions on top
- GUI definition below

"""

# install packages
from tkinter import *
import os
import os.path
import sqlite3



# Driver code
if __name__ == "__main__":
    def initDB():
        if not os.path.exists('bdaydb.db'):
            connection=sqlite3.connect('bdaydb.db')
            cursor=connection.cursor()
            cursor.execute('''CREATE TABLE personen (name TEXT, vorname TEXT, birthdate TEXT)''')
            print("Datenbank erstellt")
        else:
            print("Datenbank vorhanden")

    def add_entry():
        connection = sqlite3.connect('bdaydb.db')
        cursor = connection.cursor()
        cursor.execute('''INSERT INTO personen VALUES(:fname,:lname, :bdate)''',
                       {'fname': fname.get(), 'lname': lname.get(), 'bdate': bdate.get()})
        connection.commit()
        connection.close()
        print("Daten geschrieben: " + fname.get() + ", " + lname.get() + ", " + bdate.get())

    def show_entry(): # show-records.button: all collected records are shown
        connection = sqlite3.connect('bdaydb.db')
        cursor = connection.cursor()
        cursor.execute('''SELECT *, oid FROM personen''')
        records = cursor.fetchall()
        print_records = ""
        # Loop through resutls
        for record in records:
            print_records += str(record[0])+ " " + str(record[1]) + ": " + str(record[2]) + "\n"
        # scroll = Scrollbar(frame4, orient=VERTICAL)
        # select = Listbox(frame4, yscrollcommand=scroll.set, height=6)
        # scroll.config(command=select.yview)
        # scroll.pack(side=RIGHT, fill=Y)
        # select.pack(side=LEFT, fill=BOTH, expand=1)
        show_label = Label(frame4, text=print_records) # select
        show_label.grid(row=0, column=1, padx=20, pady=(10,0))
        connection.close()


    def submit(): # submit-button: entries are added either to existing db or a new db is created
        if os.path.exists('bdaydb.db'):
            add_entry()
        else:
            initDB()

        # clear text boxes:
        fname.delete(0, END)
        lname.delete(0, END)
        bdate.delete(0, END)

    def delete(): # delete-button: entries are deleted (by ID-number)
        connection = sqlite3.connect('bdaydb.db')
        cursor = connection.cursor()
        cursor.execute(""" DELETE FROM personen WHERE oid= """ + delete_box.get())
        connection.commit()
        connection.close()


    gui = Tk()  # create a GUI window
    gui.configure(bg="black")  # set the background colour of GUI window
    gui.title("Birthday App")  # set the title of GUI window

    # Descriptive label
    top_label = Label(gui, text="Birthday tracker", font=("Helvetica", 18, 'bold'), bg="black", fg="pink").pack()

    frame1 = Frame(gui)
    frame1.pack(padx=10, pady=10)

    # Label and text entry box for entry points: firstname, lastname, birthdate
    Label(frame1, text="First Name", font=("Helvetica", 14), fg="pink", bg="Black").grid(row=0, column=0, sticky=W)
    fname = Entry(frame1, fg="black", bg="lavenderblush2")
    fname.grid(row=0, column=1, sticky=W)

    Label(frame1, text="Last Name", font=("Helvetica", 14), fg="pink", bg="Black").grid(row=1, column=0, sticky=W)
    lname = Entry(frame1, fg="black", bg="lavenderblush2")
    lname.grid(row=1, column=1, sticky=W)

    Label(frame1, text="Birthdate", font=("Helvetica", 14), fg="pink", bg="Black").grid(row=2, column=0, sticky=W)
    bdate = Entry(frame1, fg="black", bg="lavenderblush2")
    bdate.grid(row=2, column=1, sticky=W)

    frame2 = Frame(gui)  # Row of buttons
    frame2.pack(padx=10, pady=10)

    info_label = Label(frame2, font=("Helvetica", 14), bg="black", fg="pink", pady=15).place()
    # submit button
    b1 = Button(frame2, text=" Add  ", font=("Helvetica", 12), fg="lightcyan2", bg="Black", command=submit)
    b1.pack(side=LEFT)


    # frame3 = Frame(gui)  # Row of buttons (2)
    # frame3.pack(padx=10, pady=10)
    #
    # b6 = Button(frame3, font=("Helvetica", 12), text="Past Birthdays", fg="lightcyan2", bg="black")#command=openFrame
    # b7 = Button(frame3, font=("Helvetica", 12), text="Upcoming Birthdays", fg="lightcyan2", bg="black")  # , command=upcoming_bds
    # b6.pack(side=LEFT)
    # b7.pack(side=LEFT)

    #show records
    show_b = Button(frame2, text=" Show records  ", font=("Helvetica", 12), fg="lightcyan2", bg="Black", command=show_entry)
    show_b.pack(side=LEFT)
    # show records
    frame4 = Frame(gui)  # select of names
    frame4.pack(padx=10, pady=10)

    ###

    # delete record
    frame5 = Frame(gui)  # select of names
    frame5.pack(padx=10, pady=10)
    delete_b = Button(frame5, text=" Delete record  ", font=("Helvetica", 12), fg="lightcyan2", bg="Black", command=delete)
    delete_b.pack(side=RIGHT)
    delete_box = Entry(frame5, width=30)
    delete_box.pack(side=RIGHT, fill=BOTH, expand=1)
    delete_box_label = Label(frame5, text="Delete ID #")
    delete_box_label.pack(side=LEFT, fill=BOTH, expand=1)

    # start the GUI
    gui.mainloop()