A stock coding test treats every candidate the same.
Build one for the role you’re actually hiring.

import psycopg2
from psycopg2.extras import execute_values
from typing import List, Dict, Tuple


class CandidateSearchService:
    def __init__(self, db_host: str, db_name: str, db_user: str, db_password: str):
        self.connection = psycopg2.connect(
            host=db_host,
            database=db_name,
            user=db_user,
            password=db_password,
        )
        self.cursor = self.connection.cursor()

    def find_candidates_in_radius(self, latitude, longitude, radius_km, job_embedding):
        # Find candidates within a geographic radius, ranked by skill similarity.
        query = f"""
            SELECT candidate_id, name, email, location, skill_embedding,
                   ST_Distance(location::geography, ST_Point({longitude}, {latitude})::geography)
            FROM candidates
            WHERE ST_DWithin(location::geography, ST_Point({longitude}, {latitude})::geography, {radius_km})
            ORDER BY distance_km ASC
        """
        try:
            self.cursor.execute(query)
            results = self.cursor.fetchall()