Val Town Code SearchReturn to Val Town

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { AttendanceQueries, EmployeeQueries } from "../database/queries.ts";
3import type { ApiResponse, EmployeeReport } from "../../shared/types.ts";
4import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
5import { TABLES } from "../database/migrations.ts";
6
7const reports = new Hono();

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { AttendanceQueries, EmployeeQueries } from "../database/queries.ts";
3import type { ClockInRequest, ClockOutRequest, ApiResponse } from "../../shared/types.ts";
4

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { EmployeeQueries } from "../database/queries.ts";
3import type { CreateEmployeeRequest, UpdateEmployeeRequest, ApiResponse } from "../../shared/types.ts";
4

8
9export async function runMigrations() {
10  console.log('Running database migrations...');
11  
12  // Create employees table
66  }
67
68  console.log('Database migrations completed successfully');
69}
70

14```
15├── backend/
16│   ├── database/
17│   │   ├── migrations.ts    # Database schema setup
18│   │   └── queries.ts       # Database query functions
19│   ├── routes/
20│   │   ├── employees.ts     # Employee CRUD operations
59## Getting Started
60
611. The backend will automatically set up the database tables on first run
622. Navigate to the app to start managing employees and tracking attendance
633. Use the attendance tracker to clock employees in and out
67
68- **Backend**: Hono (Express-like framework for Deno)
69- **Database**: SQLite with automatic migrations
70- **Frontend**: TypeScript with React-like components
71- **Styling**: TailwindCSS for responsive design

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { readFile, serveFile } from "https://esm.town/v/std/utils@85-main/index.ts";
3import { runMigrations } from "./database/migrations.ts";
4import jobsRouter from "./routes/jobs.ts";
5import chatRouter from "./routes/chat.ts";
12});
13
14// Initialize database
15await runMigrations();
16

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getChatMessages, createChatMessage } from "../database/queries.ts";
3import type { CreateMessageRequest } from "../../shared/types.ts";
4

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllJobs, createJob } from "../database/queries.ts";
3import type { CreateJobRequest } from "../../shared/types.ts";
4

31  `);
32
33  console.log('Database migrations completed');
34}

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { readFile, serveFile } from "https://esm.town/v/std/utils@85-main/index.ts";
3import { createTables } from "./database/migrations.ts";
4import { getAllItems } from "./database/queries.ts";
5import itemsRouter from "./routes/items.ts";
6
12});
13
14// Initialize database
15await createTables();
16