data_entry_app.py

from tkinter import *
from tkinter import ttk
from tkinter import messagebox
from widget_formats import universal_format as formats
from backup_database import db_backupper
from split_conversions import split_converter
from time_math import time_addition
from database_operations import db_ops
from os import listdir
# import sqlite3


# Instantiate app
root = Tk()
root.title('Data Entry Tool: Race Results')

# Instantiate notebook
nb = ttk.Notebook(root)
nb.pack(fill='both', expand = 1)

# Database Connection
db_name = db_backupper().db_name
if db_name not in listdir():
    #TODO: run create database 
    pass


# Backup Database
create_backup = db_backupper()
try: 
    create_backup._backup()
    messagebox.showinfo(title = 'Database Updater', message = 'Backup created.')

except:
    override_backup = messagebox.askyesno(title = 'Database Updater', message = 'Recent backup within last 30 days found. Backup database anyway?')
    if override_backup:
        create_backup._backup_override()
    else:
        messagebox.showinfo(title = 'Database Updater', message = 'No backup created.')


#region <Athlete Tab>
athlete_frame = ttk.Frame(nb, padding = formats.frame_padding)
athlete_frame.grid(column = 0, row = 0, sticky = formats.frame_sticky)

def confirm_entries_athlete(*args):
    athlete_info = athlete_name.get()  
    try:
        if athlete_season_year.get() != 0:
            entry_confirmation_athlete.set(f"Submitted {athlete_info}'s \ninformation to the database")
            enter_data_athlete()
        else:
            entry_confirmation_athlete.set(f"Please enter data")
            raise Exception
                
    except ValueError:
        pass

def enter_data_athlete():
    insert_query = '''
    INSERT INTO athletes (
        athlete, 
        season,
        season_year,
        grade,
        sex
    ) VALUES (?, ?, ?, ?, ?)
    '''

    insert_data = (athlete_name.get().lower(), 
                   athlete_season.get(), athlete_season_year.get(),
                   athlete_grade.get(), athlete_sex.get())
    
    db_ops.submit_data(db_name, insert_query, insert_data)

ttk.Label(athlete_frame, text = 'Athlete [first last]').grid(column = 0, row = 0, sticky = formats.label_sticky)
athlete_name = StringVar()
athlete_name_entry = ttk.Entry(athlete_frame, width = 10, textvariable = athlete_name).grid(column = 0, row = 1, sticky = formats.entry_sticky)

ttk.Label(athlete_frame, text = 'Running Season [xc, tf_indoor, tf_outdoor]').grid(column = 1, row = 0, sticky = formats.label_sticky)
athlete_season = StringVar()
athlete_season_entry = ttk.Entry(athlete_frame, width = 10, textvariable = athlete_season).grid(column = 1, row = 1, sticky = formats.entry_sticky)

ttk.Label(athlete_frame, text = 'Season Year [yyyy]').grid(column = 2, row = 0, sticky = formats.label_sticky)
athlete_season_year = IntVar()
athlete_season_year_entry = ttk.Entry(athlete_frame, width = 10, textvariable = athlete_season_year)\
    .grid(column = 2, row = 1, sticky = formats.entry_sticky)

ttk.Label(athlete_frame, text = 'Grade [#, 9-12]').grid(column = 3, row = 0, sticky = formats.label_sticky)
athlete_grade = IntVar()
athlete_grade_entry = ttk.Entry(athlete_frame, width = 10, textvariable = athlete_grade).grid(column = 3, row = 1, sticky = formats.entry_sticky)

ttk.Label(athlete_frame, text = 'Sex [m/f]').grid(column = 4, row = 0, sticky = formats.label_sticky)
athlete_sex = StringVar()
athlete_sex_entry = ttk.Entry(athlete_frame, width = 5, textvariable = athlete_sex).grid(column = 4, row = 1, sticky = formats.entry_sticky)

entry_confirmation_athlete = StringVar()    
ttk.Label(athlete_frame, textvariable = entry_confirmation_athlete).grid(column = 0, row = 2, sticky = formats.label_sticky)
ttk.Button(athlete_frame, text = 'Submit', command = confirm_entries_athlete).grid(column = 5, row = 1, sticky = formats.button_sticky)

for child in athlete_frame.winfo_children():
    child.grid_configure(padx = 5, pady = 5)
#endregion

#region <Splits Tab>  
splits_frame = ttk.Frame(nb, padding = formats.frame_padding)
splits_frame.grid(column = 0, row = 0, sticky = formats.frame_sticky)

def confirm_entries_splits(*args):
    athlete_info = splits_athlete.get()
    
    try:
        enter_data_splits()
        entry_confirmation_splits.set(f"Submitted {athlete_info}'s splits to the database.")
        
    except ValueError:
        pass

def enter_data_splits():
    insert_query = '''
    INSERT INTO race_laps (
        athlete, event_distance_m, date, meet_name, relay_y_n,
        lap_1, lap_2, lap_3, lap_4,
        lap_5, lap_6, lap_7, lap_8,
        total_time
    ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    '''


    converted_splits, total_time = split_converter.split_to_lap([splits_split_1.get(), splits_split_2.get(),
                                                     splits_split_3.get(), splits_split_4.get(),
                                                     splits_split_5.get(), splits_split_6.get(),
                                                     splits_split_7.get(), splits_split_8.get()])
    
    insert_data = (splits_athlete.get().lower(), splits_event.get(), splits_date.get(), splits_meet.get(), splits_relay.get()) + tuple(converted_splits) + tuple(total_time)
                   
    db_ops.submit_data(db_name, insert_query, insert_data)


ttk.Label(splits_frame, text = 'Athlete [first last]').grid(column = 0, row = 0, sticky = formats.label_sticky)
splits_athlete = StringVar()
splits_athlete_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_athlete).grid(column = 0, row = 1, sticky = formats.entry_sticky)

ttk.Label(splits_frame, text = 'Event Distance [#### meters]').grid(column = 1, row = 0, sticky = formats.label_sticky)
splits_event = IntVar()
splits_event_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_event).grid(column = 1, row = 1, sticky = formats.entry_sticky)

ttk.Label(splits_frame, text = 'Date [yyyy-mm-dd]').grid(column = 2, row = 0, sticky = formats.label_sticky)
splits_date = StringVar()
splits_date_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_date).grid(column = 2, row = 1, sticky = formats.entry_sticky)

ttk.Label(splits_frame, text = 'Meet Name [aaa bbb]').grid(column = 3, row = 0, sticky = formats.label_sticky)
splits_meet = StringVar()
splits_meet_list = db_ops.retrieve_meets(db_name)
splits_meet_dropdown = ttk.OptionMenu(splits_frame, splits_meet, splits_meet_list[0], *splits_meet_list)\
    .grid(column = 3, row = 1, sticky = formats.entry_sticky)

ttk.Label(splits_frame, text = 'Relay Split? (y/n) [1/0]').grid(column = 4, row = 0, sticky = formats.label_sticky)
splits_relay = IntVar()
splits_relay_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_relay).grid(column = 4, row = 1, sticky = formats.entry_sticky)

ttk.Label(splits_frame, text = 'Split 1 [mm:ss.dd]').grid(column = 0, row = 2, sticky = formats.label_sticky)
ttk.Label(splits_frame, text = 'Split 2 [mm:ss.dd]').grid(column = 1, row = 2, sticky = formats.label_sticky)
ttk.Label(splits_frame, text = 'Split 3 [mm:ss.dd]').grid(column = 2, row = 2, sticky = formats.label_sticky)
ttk.Label(splits_frame, text = 'Split 4 [mm:ss.dd]').grid(column = 3, row = 2, sticky = formats.label_sticky)
splits_split_1 = StringVar()
splits_split_2 = StringVar()
splits_split_3 = StringVar()
splits_split_4 = StringVar()
splits_split_1_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_split_1).grid(column = 0, row = 3, sticky = formats.entry_sticky)
splits_split_2_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_split_2).grid(column = 1, row = 3, sticky = formats.entry_sticky)
splits_split_3_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_split_3).grid(column = 2, row = 3, sticky = formats.entry_sticky)
splits_split_4_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_split_4).grid(column = 3, row = 3, sticky = formats.entry_sticky)

ttk.Label(splits_frame, text = 'Split 5 [mm:ss.dd]').grid(column = 0, row = 4, sticky = formats.label_sticky)
ttk.Label(splits_frame, text = 'Split 6 [mm:ss.dd]').grid(column = 1, row = 4, sticky = formats.label_sticky)
ttk.Label(splits_frame, text = 'Split 7 [mm:ss.dd]').grid(column = 2, row = 4, sticky = formats.label_sticky)
ttk.Label(splits_frame, text = 'Split 8 [mm:ss.dd]').grid(column = 3, row = 4, sticky = formats.label_sticky)
splits_split_5 = StringVar()
splits_split_6 = StringVar()
splits_split_7 = StringVar()
splits_split_8 = StringVar()
splits_split_5_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_split_5).grid(column = 0, row = 5, sticky = formats.entry_sticky)
splits_split_6_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_split_6).grid(column = 1, row = 5, sticky = formats.entry_sticky)
splits_split_7_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_split_7).grid(column = 2, row = 5, sticky = formats.entry_sticky)
splits_split_8_entry = ttk.Entry(splits_frame, width = 10, textvariable = splits_split_8).grid(column = 3, row = 5, sticky = formats.entry_sticky)

entry_confirmation_splits = StringVar()    
ttk.Label(splits_frame, textvariable = entry_confirmation_splits).grid(column = 4, row = 4, sticky = formats.label_sticky)
ttk.Button(splits_frame, text = 'Submit', command = confirm_entries_splits).grid(column = 4, row = 5, sticky = formats.button_sticky)

for child in splits_frame.winfo_children():
    child.grid_configure(padx = 5, pady = 5)
#endregion

#region <Laps Tab> 
laps_frame = ttk.Frame(nb, padding = formats.frame_padding)
laps_frame.grid(column = 0, row = 0, sticky = formats.frame_sticky)

def confirm_entries_laps(*args):
    athlete_info = laps_athlete.get()
    distance = laps_event.get()
    
    try:
        entry_confirmation_laps.set(f"Submitted {athlete_info}'s {distance}m laps to the database.")
        enter_data_laps()
        
    except ValueError:
        pass

def enter_data_laps():
    insert_query = '''
        INSERT INTO race_laps (
            athlete,
            event_distance_m,
            date,
            meet_name,
            relay_y_n,
            lap_1,
            lap_2,
            lap_3,
            lap_4,
            lap_5,
            lap_6,
            lap_7,
            lap_8,
            total_time
        ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        '''
    
    laps = [laps_lap_1.get(), laps_lap_2.get(), laps_lap_3.get(), laps_lap_4.get(), 
            laps_lap_5.get(), laps_lap_6.get(), laps_lap_7.get(), laps_lap_8.get()]
    
    total_time = time_addition.add_time([i for i in laps if i])

    insert_data = (laps_athlete.get(), laps_event.get(), laps_date.get(), laps_meet.get(), laps_relay.get(),
                   laps_lap_1.get(), laps_lap_2.get(), laps_lap_3.get(), laps_lap_4.get(), 
                   laps_lap_5.get(), laps_lap_6.get(), laps_lap_7.get(), laps_lap_8.get(), 
                   total_time)
    # insert_data = (laps_athlete.get(), laps_event.get(), laps_date.get(), laps_meet.get(), laps_relay.get()) + tuple(laps) + (total_time)


    db_ops.submit_data(db_name, insert_query, insert_data)

ttk.Label(laps_frame, text = 'Athlete [first last]').grid(column = 0, row = 0, sticky = formats.label_sticky)
laps_athlete = StringVar()
laps_athlete_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_athlete).grid(column = 0, row = 1, sticky = formats.entry_sticky)

ttk.Label(laps_frame, text = 'Event Distance [#### meters]').grid(column = 1, row = 0, sticky = formats.label_sticky)
laps_event = IntVar()
laps_event_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_event).grid(column = 1, row = 1, sticky = formats.entry_sticky)

ttk.Label(laps_frame, text = 'Date [yyyy-mm-dd]').grid(column = 2, row = 0, sticky = formats.label_sticky) 
laps_date = StringVar()
laps_date_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_date).grid(column = 2, row = 1, sticky = formats.entry_sticky)

ttk.Label(laps_frame, text = 'Meet Name [aaa bbb]').grid(column = 3, row = 0, sticky = formats.label_sticky)
laps_meet = StringVar()
laps_meet_list = db_ops.retrieve_meets(db_name)
laps_meet_dropdown = ttk.OptionMenu(laps_frame, laps_meet, laps_meet_list[0], *laps_meet_list)\
    .grid(column = 3, row = 1, sticky = formats.entry_sticky)

ttk.Label(laps_frame, text = 'Relay Split? (y/n) [1/0]').grid(column = 4, row = 0, sticky = formats.label_sticky)
laps_relay = IntVar()
laps_relay_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_relay).grid(column = 4, row = 1, sticky = formats.entry_sticky)

ttk.Label(laps_frame, text = 'Lap 1 [mm:ss.dd]').grid(column = 0, row = 2, sticky = formats.label_sticky)
ttk.Label(laps_frame, text = 'Lap 2 [mm:ss.dd]').grid(column = 1, row = 2, sticky = formats.label_sticky)
ttk.Label(laps_frame, text = 'Lap 3 [mm:ss.dd]').grid(column = 2, row = 2, sticky = formats.label_sticky)
ttk.Label(laps_frame, text = 'Lap 4 [mm:ss.dd]').grid(column = 3, row = 2, sticky = formats.label_sticky)
laps_lap_1 = StringVar()
laps_lap_2 = StringVar()
laps_lap_3 = StringVar()
laps_lap_4 = StringVar()
laps_lap_1_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_lap_1).grid(column = 0, row = 3, sticky = formats.entry_sticky)
laps_lap_2_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_lap_2).grid(column = 1, row = 3, sticky = formats.entry_sticky)
laps_lap_3_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_lap_3).grid(column = 2, row = 3, sticky = formats.entry_sticky)
laps_lap_4_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_lap_4).grid(column = 3, row = 3, sticky = formats.entry_sticky)

ttk.Label(laps_frame, text = 'Lap 5 [mm:ss.dd]').grid(column = 0, row = 4, sticky = formats.label_sticky)
ttk.Label(laps_frame, text = 'Lap 6 [mm:ss.dd]').grid(column = 1, row = 4, sticky = formats.label_sticky)
ttk.Label(laps_frame, text = 'Lap 7 [mm:ss.dd]').grid(column = 2, row = 4, sticky = formats.label_sticky)
ttk.Label(laps_frame, text = 'Lap 8 [mm:ss.dd]').grid(column = 3, row = 4, sticky = formats.label_sticky)
laps_lap_5 = StringVar()
laps_lap_6 = StringVar()
laps_lap_7 = StringVar()
laps_lap_8 = StringVar()
laps_lap_5_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_lap_5).grid(column = 0, row = 5, sticky = formats.entry_sticky)
laps_lap_6_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_lap_6).grid(column = 1, row = 5, sticky = formats.entry_sticky)
laps_lap_7_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_lap_7).grid(column = 2, row = 5, sticky = formats.entry_sticky)
laps_lap_8_entry = ttk.Entry(laps_frame, width = 10, textvariable = laps_lap_8).grid(column = 3, row = 5, sticky = formats.entry_sticky)

entry_confirmation_laps = StringVar()    
ttk.Label(laps_frame, textvariable = entry_confirmation_laps).grid(column = 4, row = 4, sticky = formats.label_sticky)
ttk.Button(laps_frame, text = 'Submit', command = confirm_entries_laps).grid(column = 4, row = 5, sticky = formats.button_sticky)

for child in laps_frame.winfo_children():
    child.grid_configure(padx = 5, pady = 5)
#endregion

#region <Meet Info tab> 
meet_frame = ttk.Frame(nb, padding = formats.frame_padding)
meet_frame.grid(column=0, row = 0, sticky = formats.frame_sticky)

def confirm_entries_meet():
    meet_info = meet_name.get().lower()    
    try:
        if meet_date.get():
            entry_confirmation_meet.set(f"Submitted {meet_info}'s \ninformation to the database")
            enter_data_meet()
        else:
            entry_confirmation_meet.set(f"Please enter data")
            raise Exception
                
    except ValueError:
        pass

def enter_data_meet():
    insert_query = '''
        INSERT INTO meet_information (
            name, 
            date,
            host_school,
            physical_location,
            city_state,
            weather_temperature_deg_F,
            weather_clouds,
            weather_precipitation,
            weather_notes
        ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
    '''

    insert_data = (meet_name.get().lower(), meet_date.get(), meet_host.get(), meet_location.get(), meet_city_state.get(), 
                   meet_temp.get(), meet_clouds.get(), meet_precipitation.get(), meet_weather.get())
    
    db_ops.submit_data(db_name, insert_query, insert_data)

ttk.Label(meet_frame, text = 'Meet Name [aaa bbb]').grid(column = 0, row = 0, sticky = formats.label_sticky)
meet_name = StringVar()
meet_name_entry = ttk.Entry(meet_frame, width = 10, textvariable = meet_name).grid(column = 0, row = 1, sticky = formats.entry_sticky)

ttk.Label(meet_frame, text = 'Date [yyyy-mm-dd]').grid(column = 1, row = 0, sticky = formats.label_sticky)
meet_date = StringVar()
meet_date_entry = ttk.Entry(meet_frame, width = 10, textvariable = meet_date).grid(column = 1, row = 1, sticky = formats.entry_sticky)

ttk.Label(meet_frame, text = 'Host [northridge high school]').grid(column = 2, row = 0, sticky = formats.label_sticky)
meet_host = StringVar()
meet_host_entry = ttk.Entry(meet_frame, width = 10, textvariable = meet_host).grid(column = 2, row = 1, sticky = formats.entry_sticky)

ttk.Label(meet_frame, text = 'Location [sokol park]').grid(column = 3, row = 0, sticky = formats.label_sticky)
meet_location = StringVar()
meet_location_entry = ttk.Entry(meet_frame, width = 10, textvariable = meet_location).grid(column = 3, row = 1, sticky = formats.entry_sticky)

ttk.Label(meet_frame, text = 'City, State [tuscaloosa, al]').grid(column = 4, row = 0, sticky = formats.label_sticky)
meet_city_state = StringVar()
meet_city_state_entry = ttk.Entry(meet_frame, width = 15, textvariable = meet_city_state).grid(column = 4, row = 1, sticky = formats.entry_sticky)

ttk.Label(meet_frame, text = 'Mean Temperature (*F) [##]').grid(column = 0, row = 2, sticky = formats.label_sticky)
meet_temp = IntVar()
meet_temp_entry = ttk.Entry(meet_frame, width = 5, textvariable = meet_temp).grid(column = 0, row = 3, sticky = formats.entry_sticky)

ttk.Label(meet_frame, text = 'Cloud Cover [0-2]').grid(column = 1, row = 2, sticky = formats.label_sticky)
meet_clouds = IntVar()
meet_clouds_entry = ttk.Entry(meet_frame, width = 5, textvariable = meet_clouds).grid(column = 1, row = 3, sticky = formats.entry_sticky)

ttk.Label(meet_frame, text = 'Avg. Precipitation [0-3]').grid(column = 2, row = 2, sticky = formats.label_sticky)
meet_precipitation = IntVar()
meet_precipitation_entry = ttk.Entry(meet_frame, width = 5, textvariable = meet_precipitation).grid(column = 2, row = 3, sticky = formats.entry_sticky)

ttk.Label(meet_frame, text = 'Weather Notes [aaa bbb]').grid(column = 3, row = 2, sticky = formats.label_sticky)
meet_weather = StringVar()
meet_weather_entry = ttk.Entry(meet_frame, width = 15, textvariable = meet_weather).grid(column = 3, row = 3, sticky = formats.entry_sticky)

entry_confirmation_meet = StringVar()
ttk.Label(meet_frame, textvariable = entry_confirmation_meet).grid(column = 0, row = 4, sticky = formats.label_sticky)
ttk.Button(meet_frame, text = 'Submit', command = confirm_entries_meet).grid(column = 4, row = 3, sticky = formats.button_sticky)

for child in meet_frame.winfo_children():
    child.grid_configure(padx = 5, pady = 3)
#endregion

#region <Relay Entry>
relay_frame = ttk.Frame(nb, padding = formats.frame_padding)
relay_frame.grid(column = 0, row = 0, sticky = formats.frame_sticky)

def confirm_entries_relay():
    event_info = relay_event.get()
    event_date = relay_date.get()
    
    try:
        entry_confirmation_relay.set(f"Submitted the {event_info} from {event_date} to the database.")
        enter_data_relay()
        
    except ValueError:
        pass


def enter_data_relay():
    insert_query = '''
        INSERT INTO relays (
            meet_name,
            date,
            event,
            sex,
            leg_1,
            leg_2,
            leg_3,
            leg_4,
            time
        ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)'''
    
    insert_data = (relay_meet.get(), relay_date.get(), relay_event.get(), relay_sex.get(),
                   relay_leg_1.get(), relay_leg_2.get(), relay_leg_3.get(), relay_leg_4.get(),
                   relay_time.get())
    
    db_ops.submit_data(db_name, insert_query, insert_data)


ttk.Label(relay_frame, text = 'Meet Name [aaa bbb]').grid(column = 0, row = 0, sticky = formats.label_sticky)
relay_meet = StringVar()
relay_meet_list = db_ops.retrieve_meets(db_name)
relay_meet_dropdown = ttk.OptionMenu(relay_frame, relay_meet, relay_meet_list[0], *relay_meet_list)\
    .grid(column = 0, row = 1, sticky = formats.entry_sticky)

ttk.Label(relay_frame, text = 'Date [yyyy-mm-dd]').grid(column = 1, row = 0, sticky = formats.label_sticky)
ttk.Label(relay_frame, text = 'Relay Event [4x800, dmr, ...]').grid(column = 2, row = 0, sticky = formats.label_sticky)
ttk.Label(relay_frame, text = 'Time [m:ss.dd]').grid(column = 3, row = 0, sticky = formats.label_sticky)
ttk.Label(relay_frame, text = 'Sex [m/f]').grid(column = 4, row = 0, sticky = formats.label_sticky)
relay_date = StringVar()
relay_event = StringVar()
relay_time = StringVar()
relay_sex = StringVar()
relay_date_entry = ttk.Entry(relay_frame, textvariable = relay_date).grid(column = 1, row = 1, sticky = formats.entry_sticky)
relay_event_entry = ttk.Entry(relay_frame, textvariable = relay_event).grid(column = 2, row = 1, sticky = formats.entry_sticky)
relay_time_entry = ttk.Entry(relay_frame, textvariable = relay_time).grid(column = 3, row = 1, sticky = formats.entry_sticky)
relay_sex_entry = ttk.Entry(relay_frame, textvariable = relay_sex).grid(column = 4, row = 1, sticky = formats.entry_sticky)

ttk.Label(relay_frame, text = 'Leg 1 [first last]').grid(column = 0, row = 2, sticky = formats.label_sticky)
ttk.Label(relay_frame, text = 'Leg 2 [first last]').grid(column = 1, row = 2, sticky = formats.label_sticky)
ttk.Label(relay_frame, text = 'Leg 3 [first last]').grid(column = 2, row = 2, sticky = formats.label_sticky)
ttk.Label(relay_frame, text = 'Leg 4 [first last]').grid(column = 3, row = 2, sticky = formats.label_sticky)
relay_leg_1 = StringVar()
relay_leg_2 = StringVar()
relay_leg_3 = StringVar()
relay_leg_4 = StringVar()
relay_leg_1_entry = ttk.Entry(relay_frame, textvariable = relay_leg_1).grid(column = 0, row = 3, sticky = formats.entry_sticky)
relay_leg_2_entry = ttk.Entry(relay_frame, textvariable = relay_leg_2).grid(column = 1, row = 3, sticky = formats.entry_sticky)
relay_leg_3_entry = ttk.Entry(relay_frame, textvariable = relay_leg_3).grid(column = 2, row = 3, sticky = formats.entry_sticky)
relay_leg_4_entry = ttk.Entry(relay_frame, textvariable = relay_leg_4).grid(column = 3, row = 3, sticky = formats.entry_sticky)

entry_confirmation_relay = StringVar()
ttk.Label(relay_frame, textvariable = entry_confirmation_relay).grid(column = 4, row = 2, sticky = formats.label_sticky)
ttk.Button(relay_frame, text = 'Submit', command = confirm_entries_relay).grid(column = 4, row = 3, sticky = formats.button_sticky)


for child in relay_frame.winfo_children():
    child.grid_configure(padx = 3, pady = 5)
#endregion

#region <Season Info>

seasons_frame = ttk.Frame(nb, padding = formats.frame_padding)
seasons_frame.grid(column = 0, row = 0, sticky = formats.frame_sticky)

def confirm_entries_season(*args):
    season_sport_info = season_sport.get()
    season_year_info = season_year.get()
    try:
        if season_year:
            entry_confirmation_season.set(f"Submitted {season_sport_info} \nseason from {season_year_info}")
            enter_data_season()
        else:
            entry_confirmation_season.set(f"Please enter valid data")
            raise Exception
        
    except ValueError:
        pass

def enter_data_season():
    insert_query = '''
    INSERT INTO seasons (
        sport,
        year,
        start,
        end
    ) VALUES (?, ?, ?, ?)
    '''
    insert_data = (season_sport.get(), season_year.get(), 
                   season_start.get(), season_end.get())
    
    db_ops.submit_data(db_name, insert_query, insert_data)

ttk.Label(seasons_frame, text = 'Sport [xc, tf_indoor, tf_outdoor]').grid(column = 0, row = 0, sticky = formats.label_sticky)
ttk.Label(seasons_frame, text = 'Year [yyyy]').grid(column=1, row=0, sticky=formats.label_sticky)
ttk.Label(seasons_frame, text = 'Start Date [yyyy-mm-dd]').grid(column=2, row=0, sticky=formats.label_sticky)
ttk.Label(seasons_frame, text = 'End Date [yyyy-mm-dd]').grid(column=3, row=0, sticky=formats.label_sticky)

season_sport = StringVar()
season_sport_entry = ttk.Entry(seasons_frame, width = 10, textvariable=season_sport).grid(column=0, row = 1,  sticky = formats.entry_sticky)

season_year = StringVar()
season_year_entry = ttk.Entry(seasons_frame, width = 10, textvariable = season_year).grid(column = 1, row = 1, sticky = formats.entry_sticky)

season_start = StringVar()
season_start_entry = ttk.Entry(seasons_frame, width = 10, textvariable = season_start).grid(column = 2, row = 1, sticky=formats.entry_sticky)

season_end = StringVar()
season_end_entry = ttk.Entry(seasons_frame, width = 10, textvariable=season_end).grid(column=3, row = 1, sticky=formats.entry_sticky)

entry_confirmation_season = StringVar()
ttk.Label(seasons_frame, textvariable=entry_confirmation_season).grid(column = 0, row = 3, sticky = formats.label_sticky)
ttk.Button(seasons_frame, text = 'Submit', command = confirm_entries_season).grid(column=3, row = 3, sticky = formats.button_sticky)

for child in seasons_frame.winfo_children():
    child.grid_configure(padx = 5, pady = 5)
#endregion


# Add frames to notebook
nb.add(seasons_frame, text = 'Seasons')
nb.add(meet_frame, text = 'Meet Info')
nb.add(relay_frame, text = 'Relay Entry')
nb.add(athlete_frame, text = 'Athlete Info')
nb.add(splits_frame, text = 'Race Splits')
nb.add(laps_frame, text = 'Lap Splits')

nb.select(athlete_frame)

root.mainloop()