1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getChatMessages, createChatMessage } from "../database/queries.ts";
3import type { CreateMessageRequest, ApiResponse } from "../../shared/types.ts";
4
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllJobs, createJob, deleteJob } from "../database/queries.ts";
3import type { CreateJobRequest, ApiResponse } from "../../shared/types.ts";
4
32 `);
33
34 console.log('Database migrations completed');
35}
13```
14โโโ backend/
15โ โโโ database/
16โ โ โโโ migrations.ts # Database schema setup
17โ โ โโโ queries.ts # Database query functions
18โ โโโ routes/
19โ โ โโโ jobs.ts # Job posting API routes
35
36- **Backend**: Hono (TypeScript API framework)
37- **Database**: SQLite
38- **Frontend**: React with TypeScript
39- **Styling**: TailwindCSS
22 id="taskDescription"
23 name="taskDescription"
24 placeholder="e.g., manage my calendar and follow up on emails, research competitors in the fitness industry, organize my customer database..."
25 required
26 ></textarea>
158 "manage my calendar and follow up on emails",
159 "research competitors in the fitness industry",
160 "organize my customer database and create monthly reports",
161 "handle social media posting and customer inquiries",
162 "coordinate meetings and travel arrangements for the team",
2// This sends gentle reminders to users who marked their tasks as incomplete yesterday
3
4import { runMigrations } from "../backend/database/migrations.ts";
5import { getUsersNeedingMorningReminder } from "../backend/database/queries.ts";
6import { sendMorningReminder } from "../backend/services/emailService.ts";
7
10
11 try {
12 // Ensure database is ready
13 await runMigrations();
14
2// This sends check-in emails to users who have tasks for today but haven't responded yet
3
4import { runMigrations } from "../backend/database/migrations.ts";
5import {
6 getUsersNeedingEveningReminder,
7 createTaskCompletion,
8} from "../backend/database/queries.ts";
9import { sendEveningCheckIn } from "../backend/services/emailService.ts";
10
13
14 try {
15 // Ensure database is ready
16 await runMigrations();
17
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 api from "./routes/api.ts";
5
11});
12
13// Initialize database on startup
14await runMigrations();
15
10 getTaskSetById,
11 getTaskSetByUserAndDate,
12} from "../database/queries.ts";
13import { sendCompletionConfirmation } from "../services/emailService.ts";
14
1import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
2
3// Database schema for VA Task Tidy
4// Note: Change table names when modifying schemas
5
9
10export async function runMigrations() {
11 console.log('Running database migrations...');
12
13 // Users table
52 `);
53
54 console.log('Database migrations completed successfully');
55}
56