Codingo / backend /routes /interview_api.py
husseinelsaadi
Fix interview scoring so strong answers score well
c3ec385
Raw
History Blame Contribute Delete
20.9 kB
import os
import uuid
import json
import logging
from flask import Blueprint, request, jsonify, send_file, url_for, current_app
from flask_login import login_required, current_user
from backend.models.database import db, Job, Application
from backend.services.interview_engine import (
generate_first_question,
generate_next_question,
edge_tts_to_file_sync,
whisper_stt,
evaluate_answer
)
# Additional imports for report generation
from backend.models.database import Application
from backend.services.report_generator import generate_llm_interview_report, create_pdf_report
from flask import abort
interview_api = Blueprint("interview_api", __name__)
@interview_api.route("/start_interview", methods=["POST"])
@login_required
def start_interview():
"""
Start a new interview. Generates the first question based on the user's
resume/profile and the selected job. Always returns a JSON payload
containing the question text and, if available, a URL to an audio
rendition of the question.
"""
try:
data = request.get_json() or {}
job_id = data.get("job_id")
# Validate the job and the user's application
job = Job.query.get_or_404(job_id)
application = Application.query.filter_by(
user_id=current_user.id,
job_id=job_id
).first()
if not application or not application.extracted_features:
return jsonify({"error": "No application/profile data found."}), 400
# Parse the candidate's profile
try:
profile = json.loads(application.extracted_features)
except Exception as e:
logging.error(f"Invalid profile JSON: {e}")
return jsonify({"error": "Invalid profile JSON"}), 500
# Generate the first question using the LLM
question = generate_first_question(profile, job)
if not question:
question = "Tell me about yourself and why you're interested in this position."
# Attempt to generate a TTS audio file for the question
audio_url = None
try:
audio_dir = "/tmp/audio"
os.makedirs(audio_dir, exist_ok=True)
filename = f"q_{uuid.uuid4().hex}.wav"
audio_path = os.path.join(audio_dir, filename)
audio_result = edge_tts_to_file_sync(question, audio_path)
if audio_result and os.path.exists(audio_path) and os.path.getsize(audio_path) > 1000:
audio_url = url_for("interview_api.get_audio", filename=filename)
logging.info(f"Audio generated successfully: {audio_url}")
else:
logging.warning("Audio generation failed or file too small")
except Exception as e:
logging.error(f"Error generating TTS audio: {e}")
audio_url = None
return jsonify({
"question": question,
"audio_url": audio_url
})
except Exception as e:
logging.error(f"Error in start_interview: {e}")
return jsonify({"error": "Internal server error"}), 500
import subprocess
@interview_api.route("/transcribe_audio", methods=["POST"])
@login_required
def transcribe_audio():
"""Transcribe uploaded .webm audio using ffmpeg conversion and Faster-Whisper"""
audio_file = request.files.get("audio")
if not audio_file:
return jsonify({"error": "No audio file received."}), 400
temp_dir = "/tmp/interview_temp"
os.makedirs(temp_dir, exist_ok=True)
original_path = os.path.join(temp_dir, f"user_audio_{uuid.uuid4().hex}.webm")
wav_path = original_path.replace(".webm", ".wav")
audio_file.save(original_path)
# Convert to WAV using ffmpeg
try:
subprocess.run(
["ffmpeg", "-y", "-i", original_path, wav_path],
stdout=subprocess.DEVNULL,
stderr=subprocess.DEVNULL
)
except Exception as e:
logging.error(f"FFmpeg conversion failed: {e}")
return jsonify({"error": "Failed to convert audio"}), 500
# Transcribe
transcript = whisper_stt(wav_path)
# Cleanup
try:
os.remove(original_path)
os.remove(wav_path)
except:
pass
if not transcript or not transcript.strip():
return jsonify({"error": "No speech detected in audio. Please try again."}), 400
return jsonify({"transcript": transcript})
# ----------------------------------------------------------------------------
# Interview report download
#
# Recruiters can download a PDF summarising a candidate's interview performance.
# This route performs several checks: it verifies that the current user has
# recruiter or admin privileges, ensures that the requested application exists
# and belongs to one of the recruiter's jobs, generates a textual report via
# the ``generate_llm_interview_report`` helper, converts it into a PDF, and
# finally sends the PDF as a file attachment. The heavy lifting is
# encapsulated in ``services/report_generator.py`` to keep this route
# lightweight.
@interview_api.route('/download_report/<int:application_id>', methods=['GET'])
@login_required
def download_report(application_id: int):
"""Generate and return a PDF report for a candidate's interview.
The ``application_id`` corresponds to the ID of the Application record
representing a candidate's job application. Only recruiters (or admins)
associated with the job are permitted to access this report.
"""
# Fetch the application or return 404 if not found
application = Application.query.get_or_404(application_id)
# Authorisation: ensure the current user is a recruiter or admin
if current_user.role not in ('recruiter', 'admin'):
# 403 Forbidden if the user lacks permissions
return abort(403)
# Further check that the recruiter owns the job unless admin
job = getattr(application, 'job', None)
if job is None:
return abort(404)
if current_user.role != 'admin' and job.recruiter_id != current_user.id:
return abort(403)
try:
# Generate the textual report using the helper function. At this
# stage, interview answers and evaluations are not stored server‑side,
# so the report focuses on the candidate's application data and
# computed skill match. Should answer/score data be persisted in
# future iterations, ``generate_llm_interview_report`` can be
# extended accordingly without touching this route.
report_text = generate_llm_interview_report(application)
# Convert the text to a PDF. The helper returns a BytesIO buffer
# ready for sending via Flask's ``send_file``. Matplotlib is used
# under the hood to avoid heavy dependencies like reportlab.
pdf_buffer = create_pdf_report(report_text)
pdf_buffer.seek(0)
filename = f"{application.name.replace(' ', '_')}_interview_report.pdf"
return send_file(
pdf_buffer,
download_name=filename,
as_attachment=True,
mimetype='application/pdf'
)
except Exception as exc:
# Log the error for debugging; return a 500 to the client
logging.error(f"Error generating report for application {application_id}: {exc}")
return jsonify({"error": "Failed to generate report"}), 500
@interview_api.route("/process_answer", methods=["POST"])
@login_required
def process_answer():
"""
Process a user's answer and return a follow‑up question along with an
evaluation. Always responds with JSON.
"""
try:
data = request.get_json() or {}
answer = data.get("answer", "").strip()
question_idx = data.get("questionIndex", 0)
# ``job_id`` is required to determine how many total questions are
# expected for this interview. Without it we fall back to a
# three‑question interview.
job_id = data.get("job_id")
if not answer:
return jsonify({"error": "No answer provided."}), 400
# Get the current question for evaluation context
current_question = data.get("current_question", "Tell me about yourself")
# Load the job and the candidate's application up front so we can
# evaluate at the right level and give the next question real memory.
job = None
application = None
try:
if job_id is not None:
job = Job.query.get(int(job_id))
application = Application.query.filter_by(
user_id=current_user.id,
job_id=job_id
).first()
except Exception as load_err:
logging.error(f"Error loading job/application: {load_err}")
job_role = job.role if job else "Software Developer"
seniority = (job.seniority if job and job.seniority else "Mid-level")
# Evaluate the answer calibrated to the real role and seniority
evaluation_result = evaluate_answer(
current_question, answer, job_role=job_role, seniority=seniority
)
# Append this turn to the persisted interview log. The log doubles as
# the report source, the final-score source, and the conversation
# memory passed into the next question.
conversation_log = []
try:
if application:
if application.interview_log:
try:
conversation_log = json.loads(application.interview_log)
except Exception:
conversation_log = []
conversation_log.append({
"question": current_question,
"answer": answer,
"evaluation": evaluation_result
})
application.interview_log = json.dumps(conversation_log, ensure_ascii=False)
db.session.commit()
except Exception as log_err:
logging.error(f"Error saving interview log: {log_err}")
# Determine the number of questions configured for this job
total_questions = 4
if job and job.num_questions and job.num_questions > 0:
total_questions = job.num_questions
# Check completion. ``question_idx`` is zero‑based; the last index
# corresponds to ``total_questions - 1``. When the current index
# reaches or exceeds this value, the interview is complete.
is_complete = question_idx >= (total_questions - 1)
next_question_text = None
audio_url = None
if not is_complete:
next_idx = question_idx + 1
# Determine which question to ask next. If next_idx is the last
# question (i.e. equals total_questions - 1), use the final
# question. Otherwise, select a follow‑up question from the
# bank based on ``next_idx - 1`` (because index 0 is for the
# first follow‑up). If out of range, cycle through the list.
if next_idx == (total_questions - 1):
next_question_text = (
"What are your salary expectations? Are you looking for a full-time or part-time role, "
"and do you prefer remote or on-site work?"
)
else:
# Use the Qdrant-powered, memory-aware next question. The job
# and application were already loaded above, and conversation_log
# holds every prior turn so LUNA can build on the real dialogue.
try:
profile = {}
if application and application.extracted_features:
profile = json.loads(application.extracted_features)
next_question_text = generate_next_question(
profile,
job,
conversation_log,
answer
)
except Exception as e:
logging.error(f"Error generating next question: {e}")
next_question_text = "Could you elaborate more on your last point?"
# Try to generate audio for the next question
try:
audio_dir = "/tmp/audio"
os.makedirs(audio_dir, exist_ok=True)
filename = f"q_{uuid.uuid4().hex}.wav"
audio_path = os.path.join(audio_dir, filename)
audio_result = edge_tts_to_file_sync(next_question_text, audio_path)
if audio_result and os.path.exists(audio_path) and os.path.getsize(audio_path) > 1000:
audio_url = url_for("interview_api.get_audio", filename=filename)
logging.info(f"Next question audio generated: {audio_url}")
except Exception as e:
logging.error(f"Error generating next question audio: {e}")
audio_url = None
return jsonify({
"success": True,
"next_question": next_question_text,
"audio_url": audio_url,
"evaluation": evaluation_result,
"is_complete": is_complete,
"redirect_url": url_for("interview_api.interview_complete") if is_complete else None
})
except Exception as e:
logging.error(f"Error in process_answer: {e}")
return jsonify({"error": "Error processing answer. Please try again."}), 500
@interview_api.route("/audio/<string:filename>", methods=["GET"])
@login_required
def get_audio(filename: str):
"""Serve previously generated TTS audio from the /tmp/audio directory."""
try:
# Sanitize filename to prevent directory traversal
safe_name = os.path.basename(filename)
if not safe_name.endswith('.wav'):
return jsonify({"error": "Invalid audio file format."}), 400
audio_path = os.path.join("/tmp/audio", safe_name)
if not os.path.exists(audio_path):
logging.warning(f"Audio file not found: {audio_path}")
return jsonify({"error": "Audio file not found."}), 404
if os.path.getsize(audio_path) == 0:
logging.warning(f"Audio file is empty: {audio_path}")
return jsonify({"error": "Audio file is empty."}), 404
return send_file(
audio_path,
mimetype="audio/wav",
as_attachment=False,
conditional=True # Enable range requests for better audio streaming
)
except Exception as e:
logging.error(f"Error serving audio file {filename}: {e}")
return jsonify({"error": "Error serving audio file."}), 500
from flask import render_template
@interview_api.route("/interview/complete", methods=["GET"])
@login_required
def interview_complete():
"""
Final interview completion page. After the last question has been
answered, redirect here to show the candidate a brief summary of
their overall performance. The summary consists of a percentage
score and a high‑level label (e.g. "Excellent", "Good"). These
values are derived from the candidate's application data and
interview evaluations.
The calculation mirrors the logic used in the PDF report
generation: the skills match ratio contributes 40% of the final
score while the average of the per‑question evaluation ratings
contributes 60%. If no evaluation data is available, a default
average of 0.5 is used. The resulting number is expressed as a
percentage (e.g. "75%") and mapped to a descriptive label.
"""
score = None
feedback_summary = None
try:
# Attempt to locate the most recent application with interview data
# for the current user. Because the completion route does not
# receive a job ID, we fall back to the latest application that
# contains an interview_log. If none exists, the summary will
# remain empty and the template will render placeholders.
application = (
Application.query
.filter_by(user_id=current_user.id)
.filter(Application.interview_log.isnot(None))
.order_by(Application.id.desc())
.first()
)
if application:
# Parse candidate and job skills from stored JSON. If either
# field is missing or malformed, fall back to empty lists.
try:
candidate_features = json.loads(application.extracted_features) if application.extracted_features else {}
except Exception:
candidate_features = {}
candidate_skills = candidate_features.get('skills', []) or []
job_skills = []
try:
job_skills = json.loads(application.job.skills) if application.job and application.job.skills else []
except Exception:
job_skills = []
# Compute the skills match ratio. Normalise skills to lower
# case and strip whitespace for comparison. Avoid division
# by zero if the job has no listed skills.
candidate_set = {s.strip().lower() for s in candidate_skills}
job_set = {s.strip().lower() for s in job_skills}
common = candidate_set & job_set
ratio = (len(common) / len(job_set)) if job_set else 0.0
# Extract per‑question evaluations from the interview log. The
# interview_log stores a list of dictionaries with keys
# "question", "answer" and "evaluation". Each evaluation is
# expected to include a "score" field containing text such
# as "Poor", "Medium", "Good" or "Excellent". Convert
# these descriptors into numeric values in the range [0.2, 1.0]
# similar to the logic used in report generation.
qa_scores = []
try:
if application.interview_log:
try:
log_data = json.loads(application.interview_log)
except Exception:
log_data = []
for entry in log_data:
score_text = str(entry.get('evaluation', {}).get('score', '')).lower()
# Map textual scores to numerical values
if ('excellent' in score_text) or ('5' in score_text) or ('10' in score_text):
qa_scores.append(1.0)
elif ('good' in score_text) or ('4' in score_text) or ('8' in score_text) or ('9' in score_text):
qa_scores.append(0.85)
elif ('satisfactory' in score_text) or ('medium' in score_text) or ('3' in score_text) or ('6' in score_text) or ('7' in score_text):
qa_scores.append(0.65)
elif ('needs improvement' in score_text) or ('poor' in score_text) or ('2' in score_text):
qa_scores.append(0.4)
else:
qa_scores.append(0.25)
except Exception:
qa_scores = []
# Average the QA scores. If no scores were recorded (e.g. if
# the interview_log is empty or malformed), assume a neutral
# average of 0.5 to avoid penalising the candidate for missing
# data.
qa_average = (sum(qa_scores) / len(qa_scores)) if qa_scores else 0.5
# Weight the interview answers (85%) as the primary signal and the
# skills match (15%) as a minor bonus. The skills ratio relies on
# exact skill-string overlap, which is often near zero even for
# strong candidates, so it must not dominate the final score.
overall = (qa_average * 0.85) + (ratio * 0.15)
percentage = overall * 100.0
# Assign a descriptive label based on the overall score.
if overall >= 0.8:
label = 'Excellent'
elif overall >= 0.65:
label = 'Good'
elif overall >= 0.45:
label = 'Satisfactory'
else:
label = 'Needs Improvement'
# Format the score as a whole‑number percentage. For example
# 0.753 becomes "75%". Note that rounding is applied.
score = f"{percentage:.0f}%"
feedback_summary = label
except Exception as calc_err:
# If any error occurs during calculation, fall back to None values.
logging.error(f"Error computing overall interview score: {calc_err}")
return render_template(
"closing.html",
score=score,
feedback_summary=feedback_summary
)