1import { Hono } from "https://esm.sh/hono@3.12.6";
2import { getChatMessages, createChatMessage } from "../database/queries.ts";
3import type { ChatMessage } from "../../shared/types.ts";
4
1import { Hono } from "https://esm.sh/hono@3.12.6";
2import { getAllJobPostings, createJobPosting } from "../database/queries.ts";
3import type { JobPosting } from "../../shared/types.ts";
4
6
7/**
8 * Initialize database tables
9 */
10export async function initializeDatabase() {
11 // Create job postings table
12 await sqlite.execute(`
31 `);
32
33 console.log("Database initialized successfully");
34}
17```
18โโโ backend/
19โ โโโ database/
20โ โ โโโ migrations.ts # Schema definitions
21โ โ โโโ queries.ts # DB query functions
38
39- Backend: Hono (API framework)
40- Database: SQLite
41- Frontend: HTML, JavaScript, Tailwind CSS
42- Real-time updates: Polling (for simplicity)
1import { Hono } from "https://esm.sh/hono@3.12.6";
2import { cors } from "https://esm.sh/@hono/cors@0.0.8";
3import { runMigrations } from "./database/migrations.ts";
4import jobRoutes from "./routes/jobs.ts";
5import chatRoutes from "./routes/chat.ts";
18app.use("*", cors());
19
20// Run database migrations on startup
21app.use("*", async (c, next) => {
22 try {
1import { Hono } from "https://esm.sh/hono@3.12.6";
2import { createChatMessage, getChatMessages, getRecentChatMessages } from "../database/queries.ts";
3import { ChatMessage } from "../../shared/types.ts";
4
1import { Hono } from "https://esm.sh/hono@3.12.6";
2import { createJob, getJob, getJobs } from "../database/queries.ts";
3import { JobPosting } from "../../shared/types.ts";
4
6
7/**
8 * Run database migrations to set up the schema
9 */
10export async function runMigrations() {
17```
18โโโ backend/
19โ โโโ database/
20โ โ โโโ migrations.ts # Schema definitions
21โ โ โโโ queries.ts # DB query functions
39
40- Backend: Hono (API framework)
41- Database: SQLite
42- Frontend: HTML, JavaScript, Tailwind CSS
43- Real-time updates: Polling for chat messages
6
7- `index.ts` - Main API entry point with Hono framework (HTTP trigger)
8- `database.ts` - SQLite database operations for storing resumes and job requirements
9- `parser.ts` - Resume parsing logic using OpenAI's GPT models
10- `scorer.ts` - Candidate scoring algorithms and feedback generation
29- `POST /api/score/batch` - Score multiple resumes against a job requirement
30
31## Database Schema
32
33The system uses SQLite with the following tables: