app.py

from flask import Flask, render_template, request, url_for, jsonify
import sqlite3
import random

DB_PATH = 'emo_track_responses.db'

def connect_to_database(db_path):
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    return conn, cursor

def create_database():
    conn, curr = connect_to_database(DB_PATH)
    table_dont_exist = curr.fetchone() is None 
    if table_dont_exist:
        try:
            curr.execute('''CREATE TABLE emo_track_responses
                    (id INTEGER PRIMARY KEY AUTOINCREMENT, Answer TEXT, Responses TEXT)''')
            conn.commit()
        except Exception as error:
            print(error)
        finally:
            conn.close()

def insert(answer, responses):
    conn, curr = connect_to_database(DB_PATH)
    try:
        curr.execute("INSERT INTO emo_track_responses (Answer, Responses) VALUES (?, ?)", (answer, responses))
        conn.commit()
        print("Created Database!")
    except Exception as error:
        print(error)
    finally:
        conn.close()

# Insert some data into the table
bad_answers = ["It's okay z", 
               "You probably got this z", 
               "love you z", 
               "fear is the mind-killer z", 
               "let go of your earthly tethers z",
               "when we hit our lowest point we are open to greatest change z", 
               "If you look for light you will find it. If you don't all you will see is darkness z", 
               "Don't rush to figure it all out. Let life suprise you"]
bad_str = ', '.join(bad_answers)


good_answers = ["You are doing an amazing job! Keep up the great work. z",
                "You should be proud of yourself for all that you've accomplished today. z",
                "You are making progress and moving forward. Keep going, you're doing great! z",
                "You're doing everything right! Keep it up and keep pushing forward. z",
                "You're really on a roll today! Keep up the momentum. z",
                "Your hard work and effort is paying off. You're doing great! z",
                "I can tell you're putting in a lot of effort and it's really paying off. Keep it up! z",
                "You are doing fantastic today. Keep up the good work and you will achieve great things. z",
                "It's clear that you're making great progress today. Keep up the momentum and you'll go far. z",
                "Your hard work and dedication to your tasks is truly admirable. Keep it up!"]
good_str = ', '.join(good_answers)

mid_answers = ["nice z",
               "alright"]
mid_str = ', '.join(mid_answers)

insert("Bad", bad_str)
insert("Good", good_str)
insert("Neutral", mid_str)

def getResponses(UserInput):

    conn, curr = connect_to_database(DB_PATH)
    try:
        curr.execute("SELECT Responses FROM emo_track_responses WHERE Answer = ?", (UserInput,))
        responses_tuple = curr.fetchone()
        my_string = responses_tuple[0]
        responses_list = my_string.split(" z,")
        random_index = random.randint(0, len(responses_list) - 1)
        response_str = responses_list[random_index]
        print(response_str)  
        return response_str
    except Exception as error:
        print(error)
    finally:
        conn.close()

getResponses("Good")

## Create a new instance of the Flask class
app = Flask(__name__)

## Define a route for submitting the form data
@app.route('/')
def form():
    return render_template('index.html')

@app.route('/submit/<request>', methods=['GET'])
def submit(request):
    response = getResponses(request)
    return jsonify(response)

if __name__ == '__main__':
    app.run(debug=True, port=5005)