[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_202":203,"_204":205},"routes/_app.x.$handle.$name",{"_101":100,"_32":50,"_109":91,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_21":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":25,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_48":49,"_32":50,"_36":51,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":-5,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",4,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","backend","latestPath","fileId","9934e3a7-9096-4288-9aec-48ac6f40309b","name","fileType","directory","content","createdAt",["D",1747300109087],"branchVersion","branchId","feeba1da-316b-11f0-bbde-569c3dd06744",{"_30":43,"_32":44,"_33":45,"_35":46,"_36":47,"_38":14,"_39":40,"_24":25},"backend/database.ts","2ab17f88-316c-11f0-9caa-569c3dd06744","database.ts","script","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { Resume, JobRequirement, ParsedResumeData } from \"../shared/types\";\n\n// Table names - use versioning for schema changes\nconst RESUMES_TABLE = \"resume_screening_resumes_v1\";\nconst JOB_REQUIREMENTS_TABLE = \"resume_screening_jobs_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 candidateName TEXT NOT NULL,\n email TEXT NOT NULL,\n phone TEXT,\n resumeText TEXT NOT NULL,\n parsedData TEXT,\n score REAL,\n createdAt 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 requiredSkills TEXT NOT NULL,\n preferredSkills TEXT NOT NULL,\n minimumExperience INTEGER,\n createdAt TEXT NOT NULL\n )\n `);\n}\n\n// Resume operations\nexport async function saveResume(resume: Resume): Promise {\n const { candidateName, email, phone, resumeText, parsedData, score, createdAt } = resume;\n \n const result = await sqlite.execute(\n `INSERT INTO ${RESUMES_TABLE} \n (candidateName, email, phone, resumeText, parsedData, score, createdAt) \n VALUES (?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n candidateName,\n email,\n phone || null,\n resumeText,\n parsedData ? JSON.stringify(parsedData) : null,\n score || null,\n createdAt\n ]\n );\n \n return result.rows[0].id 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,\n candidateName: row.candidateName,\n email: row.email,\n phone: row.phone,\n resumeText: row.resumeText,\n parsedData: row.parsedData ? JSON.parse(row.parsedData) : undefined,\n score: row.score,\n createdAt: row.createdAt\n };\n}\n\nexport async function getAllResumes(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${RESUMES_TABLE} ORDER BY createdAt DESC`);\n \n return result.rows.map(row => ({\n id: row.id,\n candidateName: row.candidateName,\n email: row.email,\n phone: row.phone,\n resumeText: row.resumeText,\n parsedData: row.parsedData ? JSON.parse(row.parsedData) : undefined,\n score: row.score,\n createdAt: row.createdAt\n }));\n}\n\nexport async function updateResumeScore(id: number, score: number): Promise {\n await sqlite.execute(\n `UPDATE ${RESUMES_TABLE} SET score = ? WHERE id = ?`,\n [score, id]\n );\n}\n\nexport async function updateParsedData(id: number, parsedData: ParsedResumeData): Promise {\n await sqlite.execute(\n `UPDATE ${RESUMES_TABLE} SET parsedData = ? WHERE id = ?`,\n [JSON.stringify(parsedData), id]\n );\n}\n\n// Job requirement operations\nexport async function saveJobRequirement(job: JobRequirement): Promise {\n const { title, description, requiredSkills, preferredSkills, minimumExperience, createdAt } = job;\n \n const result = await sqlite.execute(\n `INSERT INTO ${JOB_REQUIREMENTS_TABLE} \n (title, description, requiredSkills, preferredSkills, minimumExperience, createdAt) \n VALUES (?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n title,\n description,\n JSON.stringify(requiredSkills),\n JSON.stringify(preferredSkills),\n minimumExperience || null,\n createdAt\n ]\n );\n \n return result.rows[0].id 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,\n title: row.title,\n description: row.description,\n requiredSkills: JSON.parse(row.requiredSkills),\n preferredSkills: JSON.parse(row.preferredSkills),\n minimumExperience: row.minimumExperience,\n createdAt: row.createdAt\n };\n}\n\nexport async function getAllJobRequirements(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${JOB_REQUIREMENTS_TABLE} ORDER BY createdAt DESC`);\n \n return result.rows.map(row => ({\n id: row.id,\n title: row.title,\n description: row.description,\n requiredSkills: JSON.parse(row.requiredSkills),\n preferredSkills: JSON.parse(row.preferredSkills),\n minimumExperience: row.minimumExperience,\n createdAt: row.createdAt\n }));\n}",["D",1747300109087],"id","feeb4794-316b-11f0-bbde-569c3dd06744","Akash",["D",1747300035655],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","7cf973e0-f526-11ef-a409-85fb41e7ab54","pinnedFileId","5b6019e6-316c-11f0-9b15-569c3dd06744","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","d88a0c8d-5a02-479a-8fe1-02a12d784bd7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_108":104},"org",{"_101":100,"_102":-5,"_103":104,"_18":59,"_105":106,"_107":25},"branch",{"_13":90,"_32":91,"_48":40,"_92":49,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":50,"_99":100},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Akashashn","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ0ZERXOGZzV0tuS0RBWklTTHg4eFBSNG4ydCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_32":50,"_36":198,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":-5,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":199,"_85":200,"_87":201,"_89":25},"tree",[163,165,168],"files",[163,164,165,166,167,168],"counts",{"_153":67,"_154":138,"_155":67,"_156":157,"_158":159},"contents",[131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":150,"_32":28,"_30":31,"_137":-5,"_39":40,"_38":14,"_139":63,"_36":151,"_13":67,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":152},{"_48":144,"_32":145,"_30":146,"_137":-5,"_39":40,"_38":147,"_139":63,"_36":148,"_13":67,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":149},{"_48":134,"_32":135,"_30":136,"_137":-5,"_39":40,"_38":138,"_139":63,"_36":140,"_13":67,"_33":21,"_35":141,"_24":25,"_142":-5,"_27":143},"1562d028-316c-11f0-a9ad-569c3dd06744","README.md","1562d0d2-316c-11f0-a9ad-569c3dd06744","parentId",1,"latest",["D",1747300073314],"# AI-Based Resume Screening System\n\nThis project implements an AI-based resume screening system using NLP and machine learning techniques. The system analyzes resume text, extracts key information, and ranks candidates based on job requirements.\n\n## Features\n\n- Resume text analysis using OpenAI's GPT models\n- Keyword extraction and skills matching\n- Candidate scoring and ranking\n- Simple web interface for uploading resumes and viewing results\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main API entry point with Hono\n│ ├── parser.ts # Resume parsing logic\n│ ├── scorer.ts # Candidate scoring algorithms\n│ └── database.ts # SQLite database operations\n├── frontend/\n│ ├── index.html # Main HTML template\n│ ├── app.tsx # Frontend React application\n│ └── components/ # UI components\n│ ├── ResumeUpload.tsx # Resume upload component\n│ ├── JobForm.tsx # Job requirements input form\n│ └── Results.tsx # Results display component\n└── shared/\n ├── types.ts # Shared type definitions\n └── utils.ts # Utility functions\n```\n\n## How It Works\n\n1. Users upload resume text or paste it directly\n2. Users define job requirements and skills\n3. The system processes the resume using NLP techniques\n4. Candidates are scored based on matching with job requirements\n5. Results are displayed with highlighted matching skills and experience\n\n## Technologies Used\n\n- OpenAI API for natural language processing\n- SQLite for data storage\n- Hono for backend API\n- React for frontend UI\n- TailwindCSS for styling","label",[135],"199ae69e-316c-11f0-8adb-569c3dd06744","shared","f568ab83-0c46-4080-9f0d-87776cf5cd2b",2,["D",1747300080419],[145],"2ab1a6f2-316c-11f0-9caa-569c3dd06744",["D",1747300109087],[28],"pulls","branches","forks","envVars",{"_160":67,"_162":67},"connections",{"_160":67,"_161":67},"count","unfilledCount","emptyCount",{"_48":150,"_32":28,"_30":31,"_137":-5,"_39":40,"_38":14,"_139":63,"_36":195,"_13":67,"_33":34,"_35":-5,"_24":25,"_142":-5,"_170":196,"_27":197},{"_48":191,"_32":44,"_30":43,"_137":31,"_39":40,"_38":14,"_139":63,"_36":192,"_13":67,"_33":45,"_35":46,"_24":25,"_142":-5,"_170":193,"_27":194},{"_48":144,"_32":145,"_30":146,"_137":-5,"_39":40,"_38":147,"_139":63,"_36":188,"_13":67,"_33":34,"_35":-5,"_24":25,"_142":-5,"_170":189,"_27":190},{"_48":181,"_32":182,"_30":183,"_137":146,"_39":40,"_38":147,"_139":63,"_36":184,"_13":67,"_33":45,"_35":185,"_24":25,"_142":-5,"_170":186,"_27":187},{"_48":173,"_32":174,"_30":175,"_137":146,"_39":40,"_38":176,"_139":63,"_36":177,"_13":67,"_33":45,"_35":178,"_24":25,"_142":-5,"_170":179,"_27":180},{"_48":134,"_32":135,"_30":136,"_137":-5,"_39":40,"_38":138,"_139":63,"_36":169,"_13":67,"_33":21,"_35":141,"_24":25,"_142":-5,"_170":171,"_27":172},["D",1747300073314],"children",[],[135],"1f3a5eb8-316c-11f0-b149-569c3dd06744","utils.ts","1f3a5fa8-316c-11f0-b149-569c3dd06744",3,["D",1747300089857],"// Shared utility functions for both frontend and backend\n\n/**\n * Calculates the similarity score between two strings\n * Simple implementation for demonstration purposes\n */\nexport function calculateSimilarity(str1: string, str2: string): number {\n const s1 = str1.toLowerCase();\n const s2 = str2.toLowerCase();\n \n // Count matching words\n const words1 = new Set(s1.split(/\\s+/).filter(w => w.length > 2));\n const words2 = new Set(s2.split(/\\s+/).filter(w => w.length > 2));\n \n let matchCount = 0;\n for (const word of words1) {\n if (words2.has(word)) {\n matchCount++;\n }\n }\n \n const totalUniqueWords = new Set([...words1, ...words2]).size;\n return totalUniqueWords > 0 ? matchCount / totalUniqueWords : 0;\n}\n\n/**\n * Formats a date string to a readable format\n */\nexport function formatDate(dateString: string): string {\n if (!dateString) return '';\n \n try {\n const date = new Date(dateString);\n return date.toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric'\n });\n } catch (e) {\n return dateString;\n }\n}\n\n/**\n * Validates an email address\n */\nexport function isValidEmail(email: string): boolean {\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n return emailRegex.test(email);\n}\n\n/**\n * Extracts skills from text based on common skill keywords\n * This is a simple implementation - in production, you'd use NLP\n */\nexport function extractSkills(text: string, skillsList: string[]): string[] {\n const textLower = text.toLowerCase();\n return skillsList.filter(skill => \n textLower.includes(skill.toLowerCase())\n );\n}\n\n/**\n * Truncates text to a specified length\n */\nexport function truncateText(text: string, maxLength: number): string {\n if (text.length <= maxLength) return text;\n return text.substring(0, maxLength) + '...';\n}",[],[145,174],"199ac77c-316c-11f0-8adb-569c3dd06744","types.ts","199ac844-316c-11f0-8adb-569c3dd06744",["D",1747300080419],"// Shared type definitions for the resume screening system\n\nexport interface Resume {\n id?: number;\n candidateName: string;\n email: string;\n phone?: string;\n resumeText: string;\n parsedData?: ParsedResumeData;\n score?: number;\n createdAt: string;\n}\n\nexport interface ParsedResumeData {\n skills: string[];\n experience: Experience[];\n education: Education[];\n summary?: string;\n highlights?: string[];\n}\n\nexport interface Experience {\n company: string;\n title: string;\n startDate?: string;\n endDate?: string;\n description: string;\n highlights?: string[];\n}\n\nexport interface Education {\n institution: string;\n degree: string;\n field?: string;\n graduationDate?: string;\n}\n\nexport interface JobRequirement {\n id?: number;\n title: string;\n description: string;\n requiredSkills: string[];\n preferredSkills: string[];\n minimumExperience?: number;\n createdAt: string;\n}\n\nexport interface ScoringResult {\n resumeId: number;\n candidateName: string;\n score: number;\n skillMatches: {\n matched: string[];\n missing: string[];\n };\n experienceRelevance: number;\n educationRelevance: number;\n highlights: string[];\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}",[],[145,182],["D",1747300080419],[166,167],[145],"2ab17ede-316c-11f0-9caa-569c3dd06744",["D",1747300109087],[],[28,44],["D",1747300109087],[164],[28],["D",1747300035655],{"_101":100,"_108":104},{"_101":100,"_102":-5,"_103":104,"_18":59,"_105":106,"_107":25},{"_13":90,"_32":91,"_48":40,"_92":49,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":50,"_99":100},"ctx",{"_83":-5,"_128":235,"_236":237,"_238":239,"_240":25,"_241":25,"_242":25,"_243":63,"_244":-5,"_245":-7,"_246":-7,"_247":67,"_248":25,"_249":25,"_250":-5,"_251":25,"_252":25,"_253":25,"_254":-5},"ENV",{"_206":207,"_208":209,"_210":91,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","81405aa0531e90dfbb71a5bf473aaa0cf4c8702f","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"]

Diff · v4