app.py

from flask import Flask, render_template, request
import os
from openai import OpenAI
from dotenv import load_dotenv
import sqlite3

load_dotenv()

app = Flask(__name__)

# Initialize OpenAI client
client = OpenAI(api_key=os.environ.get("OPENAI_API_KEY"))

def call_openai(prompt):
    system_content = (
        "You are a helpful chatbot for the Ivy Tech School of IT. You assist both current and prospective students. "
        "You can answer questions about Ivy Tech, its School of IT, and how to apply to the college. "
        "If a student asks about a specific class or program, include a helpful link like https://catalog.ivytech.edu/. "
        "If the question is completely unrelated to Ivy Tech, reply with: 'Sorry, that is out of my scope.'"
    )
    
    response = client.chat.completions.create(
        model="gpt-3.5-turbo",
        messages=[
            {"role": "system", "content": system_content},
            {"role": "user", "content": prompt}
        ]
    )
    return response.choices[0].message.content.strip()

def save_to_db(question, answer):
    conn = sqlite3.connect('chatbot.db')
    c = conn.cursor()
    c.execute('INSERT INTO qa_pairs (question, answer) VALUES (?, ?)', (question, answer))
    conn.commit()
    conn.close()

@app.route("/", methods=["GET", "POST"])
def index():
    answer = None
    if request.method == "POST":
        question = request.form.get("question")
        if question:
            answer = call_openai(question)
            save_to_db(question, answer)
    return render_template("index.html", answer=answer)

@app.route("/bot", methods=["GET", "POST"])
def bot():
    answer = None
    if request.method == "POST":
        question = request.form.get("question")
        if question:
            answer = call_openai(question)
            save_to_db(question, answer)
    return render_template("bot.html", answer=answer)

@app.route("/admin", methods=["GET", "POST"])
def admin():
    conn = sqlite3.connect('chatbot.db')
    c = conn.cursor()
    c.execute('SELECT question, answer FROM qa_pairs')
    qa_pairs = c.fetchall()
    conn.close()
    return render_template("admin.html", qa_pairs=qa_pairs)

if __name__ == "__main__":
    app.run(debug=True)