def f_pg(): nonlocal create_loop, ferm_cr, screen, add_prompt, fadd_head create_loop = True can_write = ferm_cr.get_grav() misc.cls() if can_write: screen = format_list(fadd_head, ferm_cr.body, add_prompt) else: screen = format_list('Potential/Specific Gravity Requires a Type', ferm_cr.body, add_prompt)
def f_pc(): nonlocal create_loop, ferm_cr, screen, add_prompt, fadd_head create_loop = True can_write = ferm_cr.get_pc() misc.cls() if can_write: screen = format_list(fadd_head, ferm_cr.body, add_prompt) else: screen = format_list( 'Protein Content Requires Type "Base Malt", "Specialty Malt", or "Adjunct"', ferm_cr.body, add_prompt)
def m_up(): nonlocal next_screen, hs_db, raw_data misc.cls() add_val = input("Additional Quantity: ") add_val = Decimal(add_val) new_val = add_val + raw_data[5] next_screen = raw_data db_curs = hs_db.cursor() db_curs.execute( 'UPDATE misc SET misc_qty = {} WHERE misc_id = {}'.format( new_val, next_screen[0])) hs_db.commit() db_curs.close()
def m_save(): nonlocal create_loop, msc_cr, screen, hs_db, next_screen, add_prompt success = msc_cr.save(hs_db) if success[0]: create_loop = False next_screen = 'msc' else: create_loop = True if success[1] == 'name': temp_head = 'Name Required' else: temp_head = 'Invalid data. Double check price and quantity.' misc.cls() screen = format_list(temp_head, msc_cr.body, add_prompt)
def w_save(): nonlocal create_loop, wat_cr, screen, hs_db, next_screen, add_prompt success = wat_cr.save(hs_db) if success[0]: create_loop = False next_screen = 'wat' else: create_loop = True if success[1] == 'name': temp_head = 'Name Required' else: temp_head = 'Invalid data. Double check all values.' misc.cls() screen = format_list(temp_head, wat_cr.body, add_prompt)
def f_save(): nonlocal create_loop, ferm_cr, screen, hs_db, next_screen, add_prompt success = ferm_cr.save(hs_db) if success[0]: create_loop = False next_screen = 'ferm' else: create_loop = True if success[1] == 'name': temp_head = 'Name Required' else: temp_head = 'Invalid data. Double check potential/specific gravity, colour, diastatic power, protein content, price, and quantity.' misc.cls() screen = format_list(temp_head, ferm_cr.body, add_prompt)
def m_notes(): nonlocal create_loop, msc_cr, screen, add_prompt, madd_head create_loop = True msc_cr.get_notes() misc.cls() screen = format_list(madd_head, msc_cr.body, add_prompt)
def w_notes(): nonlocal create_loop, wat_cr, screen, add_prompt, wadd_head create_loop = True wat_cr.get_notes() misc.cls() screen = format_list(wadd_head, wat_cr.body, add_prompt)
def f_notes(): nonlocal create_loop, ferm_cr, screen, add_prompt, fadd_head create_loop = True ferm_cr.get_notes() misc.cls() screen = format_list(fadd_head, ferm_cr.body, add_prompt)
def y_notes(): nonlocal create_loop, yst_cr, screen, add_prompt, yadd_head create_loop = True yst_cr.get_notes() misc.cls() screen = format_list(yadd_head, yst_cr.body, add_prompt)
def h_notes(): nonlocal create_loop, hop_cr, screen, add_prompt, hadd_head create_loop = True hop_cr.get_notes() misc.cls() screen = format_list(hadd_head, hop_cr.body, add_prompt)
next_screen, det_head, next_det, '1. Return\n2. Add Inventory\n3. Delete\n\nSelect Option: ' ] # main program db_con = None outer_loop = True cur_screen = 'main' cur_head = 'Main Menu' cur_body = [(None, 'Inventory'), (None, 'Recipes'), (None, 'Shopping Lists'), (None, 'Ingredients'), (None, 'Log Out'), (None, 'Exit')] cur_prompt = 'Select Menu: ' while outer_loop == True: misc.cls() username = '******' #input("Enter Username: "******"Enter Password: "******"Unable to Connect: {}".format(e)) for i in range(3): time.sleep(1) print(".")
def get_next(current, selection, list_lngth, raw, cur_data): if current == 'main': if selection == '1': go_next = 'inv' elif selection == '2': go_next = 'rec' elif selection == '3': go_next = 'shop' elif selection == '4': go_next = 'ing' elif selection == '5': go_next = 'log' elif selection == '6': go_next = 'exit' else: misc.cls() go_next = None elif current == 'ing': if selection == '1': go_next = 'hop' elif selection == '2': go_next = 'yst' elif selection == '3': go_next = 'ferm' elif selection == '4': go_next = 'wat' elif selection == '5': go_next = 'msc' elif selection == '6': go_next = 'main' else: misc.cls() go_next = None elif current == 'hop': try: if int(selection) <= (list_lngth - 4) and int(selection) > 0: go_next = [raw[int(selection) - 1][0]] elif int(selection) == list_lngth - 3: go_next = 'ing' elif int(selection) == list_lngth - 2: go_next = 'main' elif int(selection) == list_lngth - 1: go_next = 'hop_add' elif int(selection) == list_lngth: go_next = 'hop_srch' else: misc.cls() go_next = None except ValueError: misc.cls() go_next = None elif current == 'hop_srch': if int(selection) <= (list_lngth - 3) and int(selection) > 0: go_next = [raw[int(selection) - 1][0]] elif int(selection) == list_lngth - 2: go_next = 'ing' elif int(selection) == list_lngth - 1: go_next = 'main' elif int(selection) == list_lngth: go_next = 'hop' else: misc.cls() go_next = None elif current == 'hop_det': if selection == '1': go_next = 'hop' elif selection == '2': go_next = 'hop_update' elif selection == '3': misc.cls() loop = True while loop == True: misc.cls() print("Delete " + raw[1] + "? Y/N") verify = input() if verify.lower() == 'y': go_next = 'hop_del' loop = False elif verify.lower() == 'n': go_next = [raw[0]] loop = False else: loop = True else: misc.cls() go_next = None elif current == 'hop_add': if selection == '1': go_next = 'hop_name' elif selection == '2': go_next = 'hop_origin' elif selection == '3': go_next = 'hop_type' elif selection == '4': go_next = 'hop_alpha' elif selection == '5': go_next = 'hop_beta' elif selection == '6': go_next = 'hop_price' elif selection == '7': go_next = 'hop_qty' elif selection == '8': go_next = 'hop_notes' elif selection == '9': go_next = 'hop_save' elif selection == '10': go_next = 'hop' else: misc.cls() go_next = None elif current == 'yst': try: if int(selection) <= (list_lngth - 4) and int(selection) > 0: go_next = [raw[int(selection) - 1][0]] elif int(selection) == list_lngth - 3: go_next = 'ing' elif int(selection) == list_lngth - 2: go_next = 'main' elif int(selection) == list_lngth - 1: go_next = 'yst_add' elif int(selection) == list_lngth: go_next = 'yst_srch' else: misc.cls() go_next = None except ValueError: misc.cls() go_next = None elif current == 'yst_srch': if int(selection) <= (list_lngth - 3) and int(selection) > 0: go_next = [raw[int(selection) - 1][0]] elif int(selection) == list_lngth - 2: go_next = 'ing' elif int(selection) == list_lngth - 1: go_next = 'main' elif int(selection) == list_lngth: go_next = 'yst' else: misc.cls() go_next = None elif current == 'yst_det': if selection == '1': go_next = 'yst' elif selection == '2': go_next = 'yst_update' elif selection == '3': misc.cls() loop = True while loop == True: misc.cls() print("Delete " + raw[1] + "? Y/N") verify = input() if verify.lower() == 'y': go_next = 'yst_del' loop = False elif verify.lower() == 'n': go_next = [raw[0]] loop = False else: loop = True else: misc.cls() go_next = None elif current == 'yst_add': if selection == '1': go_next = 'yst_name' elif selection == '2': go_next = 'yst_ar' elif selection == '3': go_next = 'yst_prid' elif selection == '4': go_next = 'yst_lab' elif selection == '5': go_next = 'yst_type' elif selection == '6': go_next = 'yst_alc' elif selection == '7': go_next = 'yst_floc' elif selection == '8': go_next = 'yst_minatt' elif selection == '9': go_next = 'yst_maxatt' elif selection == '10': go_next = 'yst_mintmp' elif selection == '11': go_next = 'yst_maxtmp' elif selection == '12': go_next = 'yst_price' elif selection == '13': go_next = 'yst_qty' elif selection == '14': go_next = 'yst_notes' elif selection == '15': go_next = 'yst_save' elif selection == '16': go_next = 'yst' else: misc.cls() go_next = None elif current == 'ferm': try: if int(selection) <= (list_lngth - 4) and int(selection) > 0: go_next = [raw[int(selection) - 1][0]] elif int(selection) == list_lngth - 3: go_next = 'ing' elif int(selection) == list_lngth - 2: go_next = 'main' elif int(selection) == list_lngth - 1: go_next = 'ferm_add' elif int(selection) == list_lngth: go_next = 'ferm_srch' else: misc.cls() go_next = None except ValueError: misc.cls() go_next = None elif current == 'ferm_srch': if int(selection) <= (list_lngth - 3) and int(selection) > 0: go_next = [raw[int(selection) - 1][0]] elif int(selection) == list_lngth - 2: go_next = 'ing' elif int(selection) == list_lngth - 1: go_next = 'main' elif int(selection) == list_lngth: go_next = 'ferm' else: misc.cls() go_next = None elif current == 'ferm_det': if selection == '1': go_next = 'ferm' elif selection == '2': go_next = 'ferm_update' elif selection == '3': misc.cls() loop = True while loop == True: misc.cls() print("Delete " + raw[1] + "? Y/N") verify = input() if verify.lower() == 'y': go_next = 'ferm_del' loop = False elif verify.lower() == 'n': go_next = [raw[0]] loop = False else: loop = True else: misc.cls() go_next = None elif current == 'ferm_add': if selection == '1': go_next = 'ferm_name' elif selection == '2': go_next = 'ferm_origin' elif selection == '3': go_next = 'ferm_type' elif selection == '4': go_next = 'ferm_pg' elif selection == '5': go_next = 'ferm_col' elif selection == '6': go_next = 'ferm_dp' elif selection == '7': go_next = 'ferm_pc' elif selection == '8': go_next = 'ferm_price' elif selection == '9': go_next = 'ferm_qty' elif selection == '10': go_next = 'ferm_notes' elif selection == '11': go_next = 'ferm_save' elif selection == '12': go_next = 'ferm' else: misc.cls() go_next = None elif current == 'wat': try: if int(selection) <= (list_lngth - 4) and int(selection) > 0: go_next = [raw[int(selection) - 1][0]] elif int(selection) == list_lngth - 3: go_next = 'ing' elif int(selection) == list_lngth - 2: go_next = 'main' elif int(selection) == list_lngth - 1: go_next = 'wat_add' elif int(selection) == list_lngth: go_next = 'wat_srch' else: misc.cls() go_next = None except ValueError: misc.cls() go_next = None elif current == 'wat_srch': if int(selection) <= (list_lngth - 3) and int(selection) > 0: go_next = [raw[int(selection) - 1][0]] elif int(selection) == list_lngth - 2: go_next = 'ing' elif int(selection) == list_lngth - 1: go_next = 'main' elif int(selection) == list_lngth: go_next = 'wat' else: misc.cls() go_next = None elif current == 'wat_det': if selection == '1': go_next = 'wat' elif selection == '2': go_next = 'wat_update' elif selection == '3': misc.cls() loop = True while loop == True: misc.cls() print("Delete " + raw[1] + "? Y/N") verify = input() if verify.lower() == 'y': go_next = 'wat_del' loop = False elif verify.lower() == 'n': go_next = [raw[0]] loop = False else: loop = True else: misc.cls() go_next = None elif current == 'wat_add': if selection == '1': go_next = 'wat_name' elif selection == '2': go_next = 'wat_ph' elif selection == '3': go_next = 'wat_ca' elif selection == '4': go_next = 'wat_mg' elif selection == '5': go_next = 'wat_na' elif selection == '6': go_next = 'wat_so4' elif selection == '7': go_next = 'wat_cl' elif selection == '8': go_next = 'wat_hco3' elif selection == '9': go_next = 'wat_price' elif selection == '10': go_next = 'wat_qty' elif selection == '11': go_next = 'wat_notes' elif selection == '12': go_next = 'wat_save' elif selection == '13': go_next = 'wat' else: misc.cls() go_next = None elif current == 'msc': try: if int(selection) <= (list_lngth - 4) and int(selection) > 0: go_next = [raw[int(selection) - 1][0]] elif int(selection) == list_lngth - 3: go_next = 'ing' elif int(selection) == list_lngth - 2: go_next = 'main' elif int(selection) == list_lngth - 1: go_next = 'msc_add' elif int(selection) == list_lngth: go_next = 'msc_srch' else: misc.cls() go_next = None except ValueError: misc.cls() go_next = None elif current == 'msc_srch': if int(selection) <= (list_lngth - 3) and int(selection) > 0: go_next = [raw[int(selection) - 1][0]] elif int(selection) == list_lngth - 2: go_next = 'ing' elif int(selection) == list_lngth - 1: go_next = 'main' elif int(selection) == list_lngth: go_next = 'msc' else: misc.cls() go_next = None elif current == 'msc_det': if selection == '1': go_next = 'msc' elif selection == '2': go_next = 'msc_update' elif selection == '3': misc.cls() loop = True while loop == True: misc.cls() print("Delete " + raw[1] + "? Y/N") verify = input() if verify.lower() == 'y': go_next = 'msc_del' loop = False elif verify.lower() == 'n': go_next = [raw[0]] loop = False else: loop = True else: misc.cls() go_next = None elif current == 'msc_add': if selection == '1': go_next = 'msc_name' elif selection == '2': go_next = 'msc_unit' elif selection == '3': go_next = 'msc_type' elif selection == '4': go_next = 'msc_price' elif selection == '5': go_next = 'msc_qty' elif selection == '6': go_next = 'msc_notes' elif selection == '7': go_next = 'msc_save' elif selection == '8': go_next = 'msc' else: misc.cls() go_next = None return go_next