from huggingface_hub import InferenceClient

import random

from flask import Flask, request, jsonify, redirect, url_for
from flask_cors import CORS
from flask_jwt_extended import JWTManager, create_access_token
from flask_jwt_extended import jwt_required, get_jwt_identity
from flask_dance.contrib.google import make_google_blueprint, google
from werkzeug.security import generate_password_hash, check_password_hash
import sqlite3

client = InferenceClient("mistralai/Mistral-7B-Instruct-v0.1")

app = Flask(__name__)
CORS(app)

file_path = "mentor.txt"
with open(file_path, "r") as file:
    mentors_data = file.read()

file_path = "temp_mentor.txt"
with open(file_path, "r") as file:
    temp_mentors_data = file.read()
    
@app.route('/')
def home():
    return jsonify({"message": "Welcome to the Recommendation API!"})

app.config['JWT_SECRET_KEY'] = "123456"
jwt = JWTManager(app)

# Setup Google OAuth
app.config["GOOGLE_OAUTH_CLIENT_ID"] = "991031782679-f0fv60jqr9snq5u9cl7j5eimhi1b3ukp.apps.googleusercontent.com"
app.config["GOOGLE_OAUTH_CLIENT_SECRET"] = "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"
google_bp = make_google_blueprint(scope=["profile", "email"])
app.register_blueprint(google_bp, url_prefix="/login")

# Create SQLite database
conn = sqlite3.connect('users.db', check_same_thread=False)
c = conn.cursor()
c.execute('''CREATE TABLE IF NOT EXISTS users
             (id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE, password TEXT)''')

c.execute('''CREATE TABLE IF NOT EXISTS user_details
             (id INTEGER PRIMARY KEY AUTOINCREMENT,
              user_id INTEGER UNIQUE,
              first_name TEXT,
              last_name TEXT,
              school_name TEXT,
              bachelors_degree TEXT,
              masters_degree TEXT,
              certification TEXT,
              activity TEXT,
              country TEXT,
              data_filled BOOLEAN DEFAULT False,
              FOREIGN KEY(user_id) REFERENCES users(id))''')


c.execute('''CREATE TABLE IF NOT EXISTS user_mentor
             (id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER, mentor_name TEXT,
             FOREIGN KEY(user_id) REFERENCES users(id))''')
conn.commit()

@app.route('/register', methods=['POST'])
def register():
    data = request.get_json()
    username = data.get('username')
    password = data.get('password')
    google_token = data.get('google_token')

    print("Type of username:", type(username))


    if google_token:
        # User signing up with Google
        resp = google.get("/oauth2/v2/userinfo")
        if not resp.ok:
            return jsonify({"message": "Failed to fetch Google user info"}), 400
        google_user_info = resp.json()
        google_id = google_user_info["id"]
        username = google_user_info["email"]
        password = None  # No password for Google signup

        # Check if Google user already exists in the database
        existing_user = c.execute("SELECT * FROM users WHERE google_id=?", (google_id,)).fetchone()
        if existing_user:
            access_token = create_access_token(identity=username, expires_delta=False)
            return jsonify({"access_token": access_token}), 200

    # User signing up with username and password
    if not username or not password:
        return jsonify({"message": "Missing username or password"}), 400

    print("Type of username:", type(username))  # Debug print

    hashed_password = generate_password_hash(password)
    try:
        c.execute("INSERT INTO users (username, password) VALUES (?, ?)", (username, hashed_password))
        conn.commit()
        access_token = create_access_token(identity=username, expires_delta=False)
        return jsonify({"access_token": access_token}), 201
    except sqlite3.IntegrityError:
        return jsonify({"message": "Username already exists"}), 400

# Endpoint for user login and Google login
@app.route('/login', methods=['POST'])
def login():
    data = request.get_json()
    username = data.get('username')
    password = data.get('password')
    google_token = data.get('google_token')

    if google_token:
        # User logging in with Google
        resp = google.get("/oauth2/v2/userinfo")
        if not resp.ok:
            return jsonify({"message": "Failed to fetch Google user info"}), 400
        google_user_info = resp.json()
        google_id = google_user_info["id"]

        # Check if Google user exists in the database
        user = c.execute("SELECT * FROM users WHERE google_id=?", (google_id,)).fetchone()
        if user:
            # Retrieve data_filled from user_details table
            user_details = c.execute("SELECT data_filled FROM user_details WHERE user_id=?", (user[0],)).fetchone()
            if user_details:
                data_filled = user_details[0]
            else:
                data_filled = False  # Default value if data not found
            access_token = create_access_token(identity=user[1], expires_delta=False)
            return jsonify({"access_token": access_token, "data_filled": data_filled}), 200
        else:
            return jsonify({"message": "User not found"}), 404

    # User logging in with username and password
    if not username or not password:
        return jsonify({"message": "Missing username or password"}), 400

    user = c.execute("SELECT * FROM users WHERE username=?", (username,)).fetchone()
    print(user)
    if user and check_password_hash(user[2], password):
        # Retrieve data_filled from user_details table
        user_details = c.execute("SELECT data_filled FROM user_details WHERE user_id=?", (user[0],)).fetchone()
        if user_details:
            data_filled = user_details[0]
        else:
            data_filled = False  # Default value if data not found
        access_token = create_access_token(identity=username, expires_delta=False)
        return jsonify({"access_token": access_token, "data_filled": data_filled}), 200
    else:
        return jsonify({"message": "Invalid username or password"}), 401



@app.route('/user_details', methods=['POST'])
@jwt_required()
def add_user_details():
    current_user = get_jwt_identity()
    data = request.get_json()
    first_name = data.get('first_name')
    last_name = data.get('last_name')
    school_name = data.get('school_name')
    bachelors_degree = data.get('bachelors_degree')
    masters_degree = data.get('masters_degree')
    certification = data.get('certification')
    activity = data.get('activity')
    country = data.get('country')

    if not all([first_name, last_name, school_name, bachelors_degree, masters_degree, certification, activity, country]):
        return jsonify({"message": "Missing required fields"}), 400

    user = c.execute("SELECT * FROM users WHERE username=?", (current_user,)).fetchone()
    if not user:
        return jsonify({"message": "User not found"}), 404

    user_id = user[0]
    try:
        c.execute("INSERT INTO user_details (user_id, first_name, last_name, school_name, bachelors_degree, "
                  "masters_degree, certification, activity, country, data_filled) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
                  (user_id, first_name, last_name, school_name, bachelors_degree, masters_degree, certification,
                   activity, country, "True"))  
        conn.commit()
        return jsonify({"message": "User details added successfully"}), 201
    except sqlite3.IntegrityError:
        return jsonify({"message": "User details already exist"}), 400


@app.route('/user_details', methods=['GET'])
@jwt_required()
def get_user_details():
    current_user = get_jwt_identity()

    user = c.execute("SELECT * FROM users WHERE username=?", (current_user,)).fetchone()
    if not user:
        return jsonify({"message": "User not found"}), 404

    user_id = user[0]
    user_details = c.execute("SELECT * FROM user_details WHERE user_id=?", (user_id,)).fetchone()
    if not user_details:
        return jsonify({"message": "User details not found"}), 404

    user_details_dict = {
        "first_name": user_details[2],
        "last_name": user_details[3],
        "school_name": user_details[4],
        "bachelors_degree": user_details[5],
        "masters_degree": user_details[6],
        "certification": user_details[7],
        "activity": user_details[8],
        "country": user_details[9],
        "data_filled": user_details[10]
    }

    return jsonify(user_details_dict), 200



def format_prompt(message):
    # Generate a random user prompt and bot response pair
    user_prompt = "UserPrompt"
    bot_response = "BotResponse"

    return f"<s>[INST] {user_prompt} [/INST] {bot_response}</s> [INST] {message} [/INST]"

@app.route('/add_mentor', methods=['POST'])
def add_mentor():
    data = request.get_json()
    mentor_name = data.get('name')
    skills = data.get('skills')
    qualification = data.get('qualification')
    experience = data.get('experience')

    if not all([mentor_name, skills, qualification, experience]):
        return jsonify({"message": "Missing mentor details"}), 400

    mentor_details = f"\n{mentor_name}\nSkills: {skills}\nQualification: {qualification}\nExperience: {experience}\n"

    try:
        with open("temp_mentor.txt", "a") as file:
            file.write(mentor_details)
        return jsonify({"message": "Mentor will be added after verification"}), 201
    except Exception as e:
        return jsonify({"message": f"Failed to add mentor: {str(e)}"}), 500

@app.route('/verify_mentor', methods=['POST'])
def verify_mentor():
    try:
        with open("temp_mentor.txt", "r") as file:
            mentors = file.readlines()

        if not mentors:
            return jsonify({"message": "No mentors to verify"}), 404

        return jsonify({"mentors": mentors}), 200
    except Exception as e:
        return jsonify({"message": f"Failed to retrieve mentors: {str(e)}"}), 500

@app.route('/add_verified_mentors', methods=['POST'])
def add_verified_mentors():
    try:
        data = request.get_json()

        if 'mentors' not in data:
            return jsonify({"message": "Mentors data not found in request"}), 400

        mentors = data['mentors']

        with open("mentor.txt", "a") as mentor_file:
            for mentor_details in mentors:
                mentor_file.write(mentor_details + '\n')

        open("temp_mentor.txt", "w").close()

        return jsonify({"message": "Mentors added successfully"}), 200
    except Exception as e:
        return jsonify({"message": f"Failed to add mentors: {str(e)}"}), 500

@app.route('/ai_mentor', methods=['POST'])
@jwt_required()
def ai_mentor():
    current_user = get_jwt_identity()
    data = request.get_json()
    message = data.get('message')

    if not message:
        return jsonify({"message": "Missing message"}), 400

    temperature = 0.9
    max_new_tokens = 256
    top_p = 0.95
    repetition_penalty = 1.0

    generate_kwargs = dict(
        temperature=temperature,
        max_new_tokens=max_new_tokens,
        top_p=top_p,
        repetition_penalty=repetition_penalty,
        do_sample=True,
        seed=42,
    )

    # Define prompt for the conversation
    prompt = f""" prompt:
     Act as an mentor
    User: {message}"""

    formatted_prompt = format_prompt(prompt)

    try:
        # Generate response from the Language Model
        response = client.text_generation(formatted_prompt, **generate_kwargs, stream=False, details=False, return_full_text=False)

        return jsonify({"response": response}), 200
    except Exception as e:
        return jsonify({"message": f"Failed to process request: {str(e)}"}), 500


@app.route('/get_course', methods=['POST'])
@jwt_required()
def get_course():
    current_user = get_jwt_identity()
    temperature = 0.9
    max_new_tokens = 256
    top_p = 0.95
    repetition_penalty = 1.0


    content = request.json
    user_degree = content.get('degree')
    user_stream = content.get('stream')
    #user_semester = content.get('semester')

    generate_kwargs = dict(
        temperature=temperature,
        max_new_tokens=max_new_tokens,
        top_p=top_p,
        repetition_penalty=repetition_penalty,
        do_sample=True,
        seed=42,
    )
    prompt = f""" prompt: 
    You need to act like as recommendation engine for course recommendation for a student based on below details.
    Degree: {user_degree}
    Stream: {user_stream}
    Based on above details recommend the courses that relate to the above details 
    Note: Output should be list in below format:
    [course1, course2, course3,...]
    Return only answer not prompt and unnecessary stuff, also dont add any special characters or punctuation marks
    """
    formatted_prompt = format_prompt(prompt)

    stream = client.text_generation(formatted_prompt, **generate_kwargs, stream=False, details=False, return_full_text=False)
    return jsonify({"ans": stream})


@app.route('/get_mentor', methods=['POST'])
@jwt_required()
def get_mentor():
    current_user = get_jwt_identity()
    temperature = 0.9
    max_new_tokens = 256
    top_p = 0.95
    repetition_penalty = 1.0

    content = request.json
    user_degree = content.get('degree')
    user_stream = content.get('stream')
    #user_semester = content.get('semester')
    courses = content.get('courses')

    temperature = float(temperature)
    if temperature < 1e-2:
        temperature = 1e-2
    top_p = float(top_p)

    generate_kwargs = dict(
        temperature=temperature,
        max_new_tokens=max_new_tokens,
        top_p=top_p,
        repetition_penalty=repetition_penalty,
        do_sample=True,
        seed=42,
    )
    prompt = f""" prompt:
    You need to act like as recommendataion engine for mentor recommendation for student based on below details also the list of mentors with their experience is attached.
    Degree: {user_degree}
    Stream: {user_stream}
    courses opted:{courses}
    Mentor list= {mentors_data}
    Based on above details recommend the mentor that realtes to above details 
    Note: Output should be list in below format:
    [mentor1,mentor2,mentor3,...]
    Return only answer not prompt and unnecessary stuff, also dont add any special characters or punctuation marks
    """
    formatted_prompt = format_prompt(prompt)

    stream = client.text_generation(formatted_prompt, **generate_kwargs, stream=False, details=False, return_full_text=False)
    return jsonify({"ans": stream})

@app.route('/select_mentor', methods=['POST'])
@jwt_required()
def select_mentor():
    current_user = get_jwt_identity()
    data = request.get_json()
    mentor_name = data.get('mentor_name')  # Assuming this is the name of the selected mentor

    if not mentor_name:
        return jsonify({"message": "Missing mentor name"}), 400

    # Fetch user details
    user = c.execute("SELECT * FROM users WHERE username=?", (current_user,)).fetchone()
    if not user:
        return jsonify({"message": "User not found"}), 404

    user_id = user[0]

    try:
        # Store selected mentor information in a new table
        c.execute("INSERT INTO user_mentor (user_id, mentor_name) VALUES (?, ?)", (user_id, mentor_name))
        conn.commit()
        return jsonify({"message": "Mentor selected successfully"}), 201
    except sqlite3.IntegrityError:
        return jsonify({"message": "Failed to select mentor"}), 500


@app.route('/users', methods=['GET'])
def get_all_users():
    try:
        users = c.execute("SELECT * FROM users").fetchall()
        users_list = [{"id": user[0], "username": user[1]} for user in users]
        return jsonify({"users": users_list}), 200
    except Exception as e:
        return jsonify({"message": f"Failed to retrieve users: {str(e)}"}), 500

@app.route('/users', methods=['DELETE'])
def delete_all_users():
    try:
        c.execute("DELETE FROM users")
        conn.commit()
        return jsonify({"message": "All users deleted successfully"}), 200
    except Exception as e:
        return jsonify({"message": f"Failed to delete users: {str(e)}"}), 500


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