[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_223":224,"_225":226},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_167":-5,"_20":168,"_22":169,"_170":171,"_172":173,"_26":174,"_24":175,"_176":-5,"_177":-5,"_178":55,"_179":180,"_181":55,"_182":-5,"_183":-5,"_184":185},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","Mayuri","name","untitled-9908","branchName","main","version","path","shared","project",{"_34":114,"_13":14,"_47":115,"_116":-5,"_117":55,"_118":119,"_120":119,"_121":-5,"_122":-5,"_123":124,"_125":-5,"_126":55,"_127":-5,"_128":-5,"_129":49,"_130":131,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":137,"_138":137,"_139":140,"_141":140,"_142":140,"_143":137,"_144":137,"_145":146,"_147":148,"_149":150,"_151":55},"tree",[62,63,64],"file",{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":44,"_45":46,"_47":59,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_18":61},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","a2f7bbba-34cd-11f0-adef-9e149126039e","types.ts","fileId","a2f7bc96-34cd-11f0-adef-9e149126039e","parentId","bcdd67a3-6db5-4044-b8ed-4246ca7680ba","branchId","3a1e1184-34cd-11f0-882c-9e149126039e","branchVersion",2,"latest",true,"createdAt",["D",1747671825549],0,"fileType","script","content","// Shared type definitions for the resume screening system\n\nexport interface Resume {\n id?: number;\n name: string;\n content: string;\n uploadDate: string;\n scores?: ResumeScore;\n}\n\nexport interface JobRequirement {\n id?: number;\n title: string;\n description: string;\n requiredSkills: string[];\n preferredSkills: string[];\n creationDate: string;\n}\n\nexport interface ResumeScore {\n overallScore: number;\n skillMatches: {\n skill: string;\n score: number;\n required: boolean;\n }[];\n experienceScore: number;\n educationScore: number;\n relevanceScore: number;\n}\n\nexport interface ScreeningResult {\n resumeId: number;\n resumeName: string;\n jobId: number;\n jobTitle: string;\n scores: ResumeScore;\n rank: number;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}","deleted",false,"label",[19,36],"a2f7da46-34cd-11f0-adef-9e149126039e",["D",1747671825549],"directory",[19],{"_34":81,"_13":82,"_37":83,"_39":-5,"_41":42,"_43":84,"_45":46,"_47":85,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_71":86,"_18":87},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":44,"_45":46,"_47":74,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_71":75,"_18":76},{"_34":65,"_13":66,"_37":67,"_39":-5,"_41":42,"_43":68,"_45":46,"_47":69,"_17":49,"_50":24,"_52":70,"_54":55,"_56":-5,"_71":72,"_18":73},"794fa7aa-34cd-11f0-b031-9e149126039e","README.md","794fa87c-34cd-11f0-b031-9e149126039e",1,["D",1747671755663],"# Resume Screening System\n\nA machine learning-powered resume screening system that uses NLP to match resumes against job requirements.\n\n## Features\n\n- Upload and process resumes in text format\n- Define job requirements and skills\n- Automatically score and rank resumes based on relevance\n- View detailed matching scores for each resume\n\n## Technology Stack\n\n- **Backend**: TypeScript with Hono framework\n- **Frontend**: HTML, CSS (Tailwind), and TypeScript with React\n- **Database**: SQLite for storing resumes and job requirements\n- **NLP/ML**: OpenAI embeddings for semantic matching\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database.ts # SQLite database operations\n│ ├── nlp.ts # NLP processing functions\n│ └── index.ts # Main API entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ ├── JobForm.tsx\n│ │ ├── ResumeUpload.tsx\n│ │ └── Results.tsx\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared type definitions\n```\n\n## How It Works\n\n1. Users upload resumes and define job requirements\n2. The system processes resumes using NLP techniques\n3. Resumes are matched against job requirements using semantic similarity\n4. Results are displayed with matching scores and rankings\n\n## Getting Started\n\nAccess the application at the root URL. No setup required as it runs on Val Town.","children",[],[66],["D",1747671825549],[77],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":78,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_71":79,"_18":80},["D",1747671825549],[],[19,36],"bb661a52-34cd-11f0-ab63-9e149126039e","backend","bbbc8915-d0a7-4537-8983-72d86f1d2d8f",3,["D",1747671866536],[88,89,90],[82],{"_34":107,"_13":108,"_37":109,"_39":83,"_41":42,"_43":84,"_45":46,"_47":110,"_17":49,"_50":51,"_52":111,"_54":55,"_56":-5,"_71":112,"_18":113},{"_34":99,"_13":100,"_37":101,"_39":83,"_41":42,"_43":102,"_45":46,"_47":103,"_17":49,"_50":51,"_52":104,"_54":55,"_56":-5,"_71":105,"_18":106},{"_34":91,"_13":92,"_37":93,"_39":83,"_41":42,"_43":94,"_45":46,"_47":95,"_17":49,"_50":51,"_52":96,"_54":55,"_56":-5,"_71":97,"_18":98},"cb30c7ac-34cd-11f0-ac9b-9e149126039e","nlp.ts","cb30c874-34cd-11f0-ac9b-9e149126039e",4,["D",1747671893035],"import { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { Resume, JobRequirement, ResumeScore } from \"../shared/types.ts\";\n\n// Initialize OpenAI client\nconst openai = new OpenAI();\n\n/**\n * Extract structured information from resume text\n */\nexport async function analyzeResume(resumeText: string): Promise {\n const prompt = `\n Extract the following information from this resume:\n 1. Skills (as a comma-separated list)\n 2. Years of experience (total)\n 3. Education level (highest degree)\n 4. Previous job titles (comma-separated)\n \n Resume:\n ${resumeText}\n \n Format your response as JSON with the following structure:\n {\n \"skills\": [\"skill1\", \"skill2\", ...],\n \"yearsOfExperience\": number,\n \"educationLevel\": \"string\",\n \"previousJobs\": [\"title1\", \"title2\", ...]\n }\n `;\n\n const response = await openai.chat.completions.create({\n model: \"gpt-4o-mini\",\n messages: [{ role: \"user\", content: prompt }],\n response_format: { type: \"json_object\" }\n });\n\n try {\n return JSON.parse(response.choices[0].message.content || \"{}\");\n } catch (error) {\n console.error(\"Error parsing resume analysis:\", error);\n return {\n skills: [],\n yearsOfExperience: 0,\n educationLevel: \"Unknown\",\n previousJobs: []\n };\n }\n}\n\n/**\n * Calculate similarity score between two texts using OpenAI embeddings\n */\nexport async function calculateSimilarity(text1: string, text2: string): Promise {\n const response = await openai.embeddings.create({\n model: \"text-embedding-3-small\",\n input: [text1, text2],\n });\n\n const embedding1 = response.data[0].embedding;\n const embedding2 = response.data[1].embedding;\n\n // Calculate cosine similarity\n let dotProduct = 0;\n let norm1 = 0;\n let norm2 = 0;\n\n for (let i = 0; i < embedding1.length; i++) {\n dotProduct += embedding1[i] * embedding2[i];\n norm1 += embedding1[i] * embedding1[i];\n norm2 += embedding2[i] * embedding2[i];\n }\n\n return dotProduct / (Math.sqrt(norm1) * Math.sqrt(norm2));\n}\n\n/**\n * Score a resume against job requirements\n */\nexport async function scoreResume(resume: Resume, job: JobRequirement): Promise {\n // Analyze resume to extract structured information\n const resumeAnalysis = await analyzeResume(resume.content);\n \n // Calculate skill matches\n const skillMatches = await calculateSkillMatches(\n resumeAnalysis.skills,\n job.requiredSkills,\n job.preferredSkills\n );\n \n // Calculate experience score (0-100)\n const experienceScore = calculateExperienceScore(resumeAnalysis.yearsOfExperience);\n \n // Calculate education score (0-100)\n const educationScore = calculateEducationScore(resumeAnalysis.educationLevel);\n \n // Calculate overall relevance score\n const relevanceScore = await calculateRelevanceScore(resume.content, job.description);\n \n // Calculate overall score (weighted average)\n const overallScore = (\n skillMatches.reduce((sum, match) => sum + match.score, 0) / skillMatches.length * 0.5 +\n experienceScore * 0.2 +\n educationScore * 0.1 +\n relevanceScore * 0.2\n );\n \n return {\n overallScore,\n skillMatches,\n experienceScore,\n educationScore,\n relevanceScore\n };\n}\n\n/**\n * Calculate skill match scores\n */\nasync function calculateSkillMatches(\n resumeSkills: string[],\n requiredSkills: string[],\n preferredSkills: string[]\n): Promise<{ skill: string; score: number; required: boolean }[]> {\n const allSkills = [...new Set([...requiredSkills, ...preferredSkills])];\n const results = [];\n \n for (const skill of allSkills) {\n const isRequired = requiredSkills.includes(skill);\n \n // Check for exact match\n if (resumeSkills.some(s => s.toLowerCase() === skill.toLowerCase())) {\n results.push({\n skill,\n score: 100,\n required: isRequired\n });\n continue;\n }\n \n // Check for semantic similarity\n let bestScore = 0;\n for (const resumeSkill of resumeSkills) {\n const similarity = await calculateSimilarity(skill, resumeSkill);\n bestScore = Math.max(bestScore, similarity * 100);\n }\n \n results.push({\n skill,\n score: bestScore,\n required: isRequired\n });\n }\n \n return results;\n}\n\n/**\n * Calculate experience score based on years of experience\n */\nfunction calculateExperienceScore(yearsOfExperience: number): number {\n // Simple scoring: 0-2 years (0-40), 3-5 years (40-70), 6+ years (70-100)\n if (yearsOfExperience <= 2) {\n return (yearsOfExperience / 2) * 40;\n } else if (yearsOfExperience <= 5) {\n return 40 + ((yearsOfExperience - 2) / 3) * 30;\n } else {\n return Math.min(70 + ((yearsOfExperience - 5) / 5) * 30, 100);\n }\n}\n\n/**\n * Calculate education score based on highest degree\n */\nfunction calculateEducationScore(educationLevel: string): number {\n const level = educationLevel.toLowerCase();\n \n if (level.includes(\"phd\") || level.includes(\"doctorate\")) {\n return 100;\n } else if (level.includes(\"master\")) {\n return 80;\n } else if (level.includes(\"bachelor\") || level.includes(\"bs\") || level.includes(\"ba\")) {\n return 60;\n } else if (level.includes(\"associate\") || level.includes(\"diploma\")) {\n return 40;\n } else if (level.includes(\"certificate\") || level.includes(\"certification\")) {\n return 30;\n } else {\n return 20; // High school or unknown\n }\n}\n\n/**\n * Calculate overall relevance score between resume and job description\n */\nasync function calculateRelevanceScore(resumeText: string, jobDescription: string): Promise {\n // Use semantic similarity between resume and job description\n const similarity = await calculateSimilarity(resumeText, jobDescription);\n return similarity * 100;\n}",[],[82,92],"dfd113c4-34cd-11f0-8dd3-9e149126039e","index.ts","dfd11496-34cd-11f0-8dd3-9e149126039e",5,["D",1747671927639],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { initDatabase, saveResume, getResume, getAllResumes, \n saveJobRequirement, getJobRequirement, getAllJobRequirements,\n saveScreeningResult, getScreeningResults } from \"./database.ts\";\nimport { scoreResume } from \"./nlp.ts\";\nimport { Resume, JobRequirement, ApiResponse } from \"../shared/types.ts\";\n\n// Initialize the app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Add CORS middleware\napp.use(\"*\", cors());\n\n// Initialize database on startup\napp.use(\"*\", async (c, next) => {\n try {\n await initDatabase();\n } catch (error) {\n console.error(\"Database initialization error:\", error);\n }\n await next();\n});\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve the main HTML page with initial data\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n try {\n // Get initial data for bootstrapping the app\n const resumes = await getAllResumes();\n const jobs = await getAllJobRequirements();\n \n // Inject data to avoid extra round-trips\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n } catch (error) {\n console.error(\"Error preparing initial data:\", error);\n }\n \n return c.html(html);\n});\n\n// API Routes\n\n// Resume endpoints\napp.post(\"/api/resumes\", async c => {\n try {\n const data = await c.req.json();\n \n if (!data.name || !data.content) {\n return c.json>({\n success: false,\n error: \"Resume name and content are required\"\n }, 400);\n }\n \n const resume: Resume = {\n name: data.name,\n content: data.content,\n uploadDate: new Date().toISOString()\n };\n \n const id = await saveResume(resume);\n \n return c.json>({\n success: true,\n data: { id }\n }, 201);\n } catch (error) {\n console.error(\"Error saving resume:\", error);\n return c.json>({\n success: false,\n error: \"Failed to save resume\"\n }, 500);\n }\n});\n\napp.get(\"/api/resumes\", async c => {\n try {\n const resumes = await getAllResumes();\n return c.json>({\n success: true,\n data: resumes\n });\n } catch (error) {\n console.error(\"Error fetching resumes:\", error);\n return c.json>({\n success: false,\n error: \"Failed to fetch resumes\"\n }, 500);\n }\n});\n\napp.get(\"/api/resumes/:id\", async c => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const resume = await getResume(id);\n \n if (!resume) {\n return c.json>({\n success: false,\n error: \"Resume not found\"\n }, 404);\n }\n \n return c.json>({\n success: true,\n data: resume\n });\n } catch (error) {\n console.error(\"Error fetching resume:\", error);\n return c.json>({\n success: false,\n error: \"Failed to fetch resume\"\n }, 500);\n }\n});\n\n// Job requirement endpoints\napp.post(\"/api/jobs\", async c => {\n try {\n const data = await c.req.json();\n \n if (!data.title || !data.description) {\n return c.json>({\n success: false,\n error: \"Job title and description are required\"\n }, 400);\n }\n \n const job: JobRequirement = {\n title: data.title,\n description: data.description,\n requiredSkills: data.requiredSkills || [],\n preferredSkills: data.preferredSkills || [],\n creationDate: new Date().toISOString()\n };\n \n const id = await saveJobRequirement(job);\n \n return c.json>({\n success: true,\n data: { id }\n }, 201);\n } catch (error) {\n console.error(\"Error saving job requirement:\", error);\n return c.json>({\n success: false,\n error: \"Failed to save job requirement\"\n }, 500);\n }\n});\n\napp.get(\"/api/jobs\", async c => {\n try {\n const jobs = await getAllJobRequirements();\n return c.json>({\n success: true,\n data: jobs\n });\n } catch (error) {\n console.error(\"Error fetching job requirements:\", error);\n return c.json>({\n success: false,\n error: \"Failed to fetch job requirements\"\n }, 500);\n }\n});\n\napp.get(\"/api/jobs/:id\", async c => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const job = await getJobRequirement(id);\n \n if (!job) {\n return c.json>({\n success: false,\n error: \"Job requirement not found\"\n }, 404);\n }\n \n return c.json>({\n success: true,\n data: job\n });\n } catch (error) {\n console.error(\"Error fetching job requirement:\", error);\n return c.json>({\n success: false,\n error: \"Failed to fetch job requirement\"\n }, 500);\n }\n});\n\n// Screening endpoints\napp.post(\"/api/screen\", async c => {\n try {\n const { resumeId, jobId } = await c.req.json<{ resumeId: number; jobId: number }>();\n \n if (!resumeId || !jobId) {\n return c.json>({\n success: false,\n error: \"Resume ID and Job ID are required\"\n }, 400);\n }\n \n const resume = await getResume(resumeId);\n const job = await getJobRequirement(jobId);\n \n if (!resume || !job) {\n return c.json>({\n success: false,\n error: \"Resume or job not found\"\n }, 404);\n }\n \n // Score the resume against the job requirements\n const scores = await scoreResume(resume, job);\n \n // Save the screening result\n await saveScreeningResult(resumeId, jobId, scores);\n \n return c.json>({\n success: true,\n data: { scores }\n });\n } catch (error) {\n console.error(\"Error screening resume:\", error);\n return c.json>({\n success: false,\n error: \"Failed to screen resume\"\n }, 500);\n }\n});\n\napp.post(\"/api/screen-batch\", async c => {\n try {\n const { resumeIds, jobId } = await c.req.json<{ resumeIds: number[]; jobId: number }>();\n \n if (!resumeIds || !resumeIds.length || !jobId) {\n return c.json>({\n success: false,\n error: \"Resume IDs and Job ID are required\"\n }, 400);\n }\n \n const job = await getJobRequirement(jobId);\n \n if (!job) {\n return c.json>({\n success: false,\n error: \"Job not found\"\n }, 404);\n }\n \n // Process each resume\n for (const resumeId of resumeIds) {\n const resume = await getResume(resumeId);\n \n if (resume) {\n const scores = await scoreResume(resume, job);\n await saveScreeningResult(resumeId, jobId, scores);\n }\n }\n \n // Get all screening results for this job\n const results = await getScreeningResults(jobId);\n \n return c.json>({\n success: true,\n data: { results }\n });\n } catch (error) {\n console.error(\"Error batch screening resumes:\", error);\n return c.json>({\n success: false,\n error: \"Failed to screen resumes\"\n }, 500);\n }\n});\n\napp.get(\"/api/results/:jobId\", async c => {\n try {\n const jobId = parseInt(c.req.param(\"jobId\"));\n const results = await getScreeningResults(jobId);\n \n return c.json>({\n success: true,\n data: results\n });\n } catch (error) {\n console.error(\"Error fetching screening results:\", error);\n return c.json>({\n success: false,\n error: \"Failed to fetch screening results\"\n }, 500);\n }\n});\n\n// Export the app for HTTP val\nexport default app.fetch;",[],[82,100],"bb65f6da-34cd-11f0-ab63-9e149126039e","database.ts","bb65f78e-34cd-11f0-ab63-9e149126039e",["D",1747671866536],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { Resume, JobRequirement, ResumeScore } from \"../shared/types.ts\";\n\n// Table names with versioning to allow for schema changes\nconst RESUMES_TABLE = \"resumes_v1\";\nconst JOB_REQUIREMENTS_TABLE = \"job_requirements_v1\";\nconst SCREENING_RESULTS_TABLE = \"screening_results_v1\";\n\n// Initialize database tables\nexport async function initDatabase() {\n // Create resumes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RESUMES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n content TEXT NOT NULL,\n upload_date TEXT NOT NULL\n )\n `);\n\n // Create job requirements table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${JOB_REQUIREMENTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n required_skills TEXT NOT NULL,\n preferred_skills TEXT NOT NULL,\n creation_date TEXT NOT NULL\n )\n `);\n\n // Create screening results table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SCREENING_RESULTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n resume_id INTEGER NOT NULL,\n job_id INTEGER NOT NULL,\n overall_score REAL NOT NULL,\n skill_matches TEXT NOT NULL,\n experience_score REAL NOT NULL,\n education_score REAL NOT NULL,\n relevance_score REAL NOT NULL,\n screening_date TEXT NOT NULL,\n FOREIGN KEY (resume_id) REFERENCES ${RESUMES_TABLE}(id),\n FOREIGN KEY (job_id) REFERENCES ${JOB_REQUIREMENTS_TABLE}(id)\n )\n `);\n}\n\n// Resume operations\nexport async function saveResume(resume: Resume): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${RESUMES_TABLE} (name, content, upload_date) VALUES (?, ?, ?)`,\n [resume.name, resume.content, resume.uploadDate]\n );\n return result.lastInsertId as number;\n}\n\nexport async function getResume(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${RESUMES_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n const row = result.rows[0];\n return {\n id: row.id as number,\n name: row.name as string,\n content: row.content as string,\n uploadDate: row.upload_date as string\n };\n}\n\nexport async function getAllResumes(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${RESUMES_TABLE} ORDER BY upload_date DESC`);\n \n return result.rows.map(row => ({\n id: row.id as number,\n name: row.name as string,\n content: row.content as string,\n uploadDate: row.upload_date as string\n }));\n}\n\n// Job requirement operations\nexport async function saveJobRequirement(job: JobRequirement): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${JOB_REQUIREMENTS_TABLE} \n (title, description, required_skills, preferred_skills, creation_date) \n VALUES (?, ?, ?, ?, ?)`,\n [\n job.title, \n job.description, \n JSON.stringify(job.requiredSkills), \n JSON.stringify(job.preferredSkills), \n job.creationDate\n ]\n );\n return result.lastInsertId as number;\n}\n\nexport async function getJobRequirement(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${JOB_REQUIREMENTS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n const row = result.rows[0];\n return {\n id: row.id as number,\n title: row.title as string,\n description: row.description as string,\n requiredSkills: JSON.parse(row.required_skills as string),\n preferredSkills: JSON.parse(row.preferred_skills as string),\n creationDate: row.creation_date as string\n };\n}\n\nexport async function getAllJobRequirements(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${JOB_REQUIREMENTS_TABLE} ORDER BY creation_date DESC`\n );\n \n return result.rows.map(row => ({\n id: row.id as number,\n title: row.title as string,\n description: row.description as string,\n requiredSkills: JSON.parse(row.required_skills as string),\n preferredSkills: JSON.parse(row.preferred_skills as string),\n creationDate: row.creation_date as string\n }));\n}\n\n// Screening results operations\nexport async function saveScreeningResult(\n resumeId: number, \n jobId: number, \n scores: ResumeScore\n): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${SCREENING_RESULTS_TABLE} \n (resume_id, job_id, overall_score, skill_matches, experience_score, education_score, relevance_score, screening_date) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n resumeId,\n jobId,\n scores.overallScore,\n JSON.stringify(scores.skillMatches),\n scores.experienceScore,\n scores.educationScore,\n scores.relevanceScore,\n new Date().toISOString()\n ]\n );\n return result.lastInsertId as number;\n}\n\nexport async function getScreeningResults(jobId: number): Promise {\n const result = await sqlite.execute(\n `SELECT sr.*, r.name as resume_name, j.title as job_title\n FROM ${SCREENING_RESULTS_TABLE} sr\n JOIN ${RESUMES_TABLE} r ON sr.resume_id = r.id\n JOIN ${JOB_REQUIREMENTS_TABLE} j ON sr.job_id = j.id\n WHERE sr.job_id = ?\n ORDER BY sr.overall_score DESC`,\n [jobId]\n );\n \n return result.rows.map((row, index) => ({\n resumeId: row.resume_id as number,\n resumeName: row.resume_name as string,\n jobId: row.job_id as number,\n jobTitle: row.job_title as string,\n scores: {\n overallScore: row.overall_score as number,\n skillMatches: JSON.parse(row.skill_matches as string),\n experienceScore: row.experience_score as number,\n educationScore: row.education_score as number,\n relevanceScore: row.relevance_score as number\n },\n rank: index + 1\n }));\n}",[],[82,108],"3a1dd868-34cd-11f0-882c-9e149126039e",["D",1747671649644],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","f3e68930-34cc-11f0-b74d-5f1814b1b3f0","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","17883f6d-139f-477a-934f-f88b892ced2c","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_166":162},"org",{"_11":12,"_160":-5,"_161":162,"_123":124,"_163":164,"_165":55},"branch",{"_17":102,"_13":16,"_34":42,"_152":114,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":14,"_159":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4SzBIdXFGMXhRZ2d3OURWWFFncFd5M1ZIUCJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":114,"_13":14,"_47":219,"_116":-5,"_117":55,"_118":119,"_120":119,"_121":-5,"_122":-5,"_123":124,"_125":-5,"_126":55,"_127":-5,"_128":-5,"_129":49,"_130":131,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":137,"_138":137,"_139":140,"_141":140,"_142":140,"_143":137,"_144":137,"_145":220,"_147":221,"_149":222,"_151":55},[198,202,204],"files",[198,199,200,201,202,203,204],"counts",{"_189":49,"_190":68,"_191":49,"_32":192,"_193":194},[187],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":44,"_45":46,"_47":59,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_18":186},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":188},[19,36],"pulls","branches","forks",{"_195":49,"_197":49},"connections",{"_195":49,"_196":49},"count","unfilledCount","emptyCount",{"_34":81,"_13":82,"_37":83,"_39":-5,"_41":42,"_43":84,"_45":46,"_47":85,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_71":217,"_18":218},{"_34":107,"_13":108,"_37":109,"_39":83,"_41":42,"_43":84,"_45":46,"_47":110,"_17":49,"_50":51,"_52":111,"_54":55,"_56":-5,"_71":215,"_18":216},{"_34":99,"_13":100,"_37":101,"_39":83,"_41":42,"_43":102,"_45":46,"_47":103,"_17":49,"_50":51,"_52":104,"_54":55,"_56":-5,"_71":213,"_18":214},{"_34":91,"_13":92,"_37":93,"_39":83,"_41":42,"_43":94,"_45":46,"_47":95,"_17":49,"_50":51,"_52":96,"_54":55,"_56":-5,"_71":211,"_18":212},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":44,"_45":46,"_47":74,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_71":209,"_18":210},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":78,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_71":207,"_18":208},{"_34":65,"_13":66,"_37":67,"_39":-5,"_41":42,"_43":68,"_45":46,"_47":69,"_17":49,"_50":24,"_52":70,"_54":55,"_56":-5,"_71":205,"_18":206},[],[66],[],[19,36],[203],[19],[],[82,92],[],[82,100],[],[82,108],[199,200,201],[82],["D",1747671649644],{"_11":12,"_166":162},{"_11":12,"_160":-5,"_161":162,"_123":124,"_163":164,"_165":55},{"_17":102,"_13":16,"_34":42,"_152":114,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":14,"_159":12},"ctx",{"_145":-5,"_183":256,"_257":258,"_259":260,"_261":55,"_262":55,"_263":55,"_264":46,"_265":-5,"_266":-7,"_267":-7,"_268":49,"_269":55,"_270":55,"_271":-5,"_272":55,"_273":55,"_274":55,"_275":-5},"ENV",{"_227":228,"_229":230,"_231":16,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]