from databaseinterface import DatabaseInterface from databasequeries import DatabaseQueries as Dbq import configparser config = configparser.ConfigParser() config.read('config.ini') dbi = DatabaseInterface(config.get('DATABASE', 'database'), config.get('DATABASE', 'username'), config.get('DATABASE', 'password'), config.get('DATABASE', 'ip_address')) def store_recipe(data): print(data) # actual functionality to transplant to app.py function # check drink names and look for match drink = data["name"] drinks = dict(dbi.read_query(Dbq.ALL_DRINKS)) print(drinks) # select right method # TODO: remove duplicate lines if drink in drinks.values(): print('Update Recipe') # nuke old recipe update_id = dbi.read_query(Dbq.GET_DRINK_ID, (data["name"],))[0][0] dbi.execute_query(Dbq.DELETE_RECIPE, (update_id,)) # iterate over recipe and store to database for ingredient, quantity in data["ingredients"].items():