general_helpers.py

from sqlalchemy import create_engine, insert, text
from ratings import percentage_rating
from telegram import InlineKeyboardButton, InlineKeyboardMarkup, Update, ParseMode
from telegram.ext import Updater, CommandHandler, MessageHandler, Filters, CallbackContext


engine = create_engine('sqlite:///ingredient_list.db')      # Access ingredient list

def start(update: Update, context: CallbackContext) -> None:
    """Send a message when the command /start is issued."""
    name = update.message.chat.first_name
    intro = f"Right, hello, {name}. <b>Ramsii</b> here, the best chef <s>companion</s> in the world, if I do say so myself. " \
            f"\n\nMissing an ingredient for your recipe? What ingredient are you having a hard time finding? Type it in the chat below to look it up." \
            f"\n\n\n---------------------------\n\nIf you need help, use /help, you donkey!"

    return update.message.reply_text(text=intro, parse_mode= ParseMode.HTML)


def user_search(user_input):
    with engine.connect() as connection:
        # Searches each row of the db to access the relevant data
        result = connection.execute("select * from ingredient_substitution")
        # search_failure = True

        CS = ""     # Close substitutes
        SP = ""     # Self-produce
        ALT = ""    # Alternatives
        VEG = ""    # Is Vegan

        for row in result:
            if user_input.lower() == row['ing_input']:				
                # search_failure = False
                TITLE = "<b><u>" + row['full_ing'].upper() + "</u></b>"
                PERCENTAGE = percentage_rating(user_input)
                PERCENTAGE_RATING = str(PERCENTAGE)
                SEPARATOR = "\n\n\n---------------------\n\n"
                USER_RATING = ""

                # Case where ingredient has no ratings yet
                if PERCENTAGE_RATING == "0":
                    USER_RATING = "No users found this information useful."
                elif PERCENTAGE_RATING == "0.0":
                    USER_RATING = "No users found this information useful."
                else:
                    USER_RATING = "<b>" + PERCENTAGE_RATING + "%</b> of users found this information useful."

                # Check close subs
                if row['ing_cs'] == "NIL":
                    CS = ""
                else:
                    CS = "\n\nYou can closely substitute " + str(row['orig_unit']) + " " + row['ing_input'] + " with <b>" + row['ing_cs'] + "</b>."
                
                # Check self prod
                if row['ing_sp'] == "NIL":
                    SP = ""
                else:
                    SP = "\n\nYou can make " + str(row['orig_unit']) + " " + row['ing_input'] + " with <b>" + row['ing_sp'] + "</b>."
                
                # Check alts
                if row['ing_alt'] == "NIL":
                    ALT = ""
                else:
                    ALT = "\n\nYou can entirely replace " + str(row['orig_unit']) + " " + row['ing_input'] + " with <b>" + row['ing_alt'] + "</b>."
                
                # Check if vegan (Consider: https://is-vegan.netlify.app/ to access a larger database)
                if row['isVegan'] == 'Yes':
                    VEG = "\n<i>Vegan</i>"
                elif row['isVegan'] == 'No':
                    VEG = "\n<i>Non-vegan</i>"
                else:
                    VEG = "\n<i>May or may not be vegan</i>"

                return TITLE + VEG + CS + SP + ALT + SEPARATOR + USER_RATING

        # if search_failure:
        # return "Ingredient cannot be found! Please try again."
        return ""


# TODO: suggestions at failure state and not useful state
# def suggestion(user_id, category, user_suggestion):
#     with engine.connect() as connection:
#         suggestion_entry = {"id": user_id, "category": category, "suggestions": user_suggestion}
#         ins_statement = text("""insert into suggestions(id, category, suggestions) values(:id, :category, :suggestions)""")
#         connection.execute(ins_statement, **suggestion_entry)