Val Town Code SearchReturn to Val Town

6  updateUser,
7  getUserById 
8} from "../database/queries.ts";
9import type { Session, SchedulingRequest, ApiResponse } from "../../shared/types.ts";
10

68  await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_sessions_user ON sessions (user_id)`);
69
70  console.log("Database migrations completed successfully");
71}

15```
16├── backend/
17│   ├── database/
18│   │   ├── migrations.ts    # Database schema setup
19│   │   └── queries.ts       # Database query functions
20│   ├── routes/
21│   │   ├── auth.ts         # User authentication
40
41- **Backend**: Hono (TypeScript API framework)
42- **Database**: SQLite with Val Town's sqlite service
43- **Frontend**: React with TypeScript
44- **Styling**: TailwindCSS

8  updateMatchStatus,
9  getUserById 
10} from "../database/queries.ts";
11import type { MatchingRequest, MatchingResponse, SkillMatch, ApiResponse } from "../../shared/types.ts";
12

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { createSkill, getUserSkills, getSkillsByName, deleteSkill } from "../database/queries.ts";
3import type { Skill, ApiResponse } from "../../shared/types.ts";
4

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { createUser, getUserById, getUserByEmail, updateUser } from "../database/queries.ts";
3import type { User, ApiResponse } from "../../shared/types.ts";
4

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 formsRouter from "./routes/forms.ts";
5import { getForm } from "./database/queries.ts";
6
7const app = new Hono();
12});
13
14// Initialize database (run in background to not block startup)
15runMigrations().catch(console.error);
16

36    `);
37
38    console.log('Database migrations completed');
39  } catch (error) {
40    console.error('Database migration error:', error);
41    // Don't throw error to allow app to continue
42  }

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getPipelineAnalytics } from "../database/queries.ts";
3
4const analytics = new Hono();

1import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
2
3// Database schema for SkillSwap AI
4// Change table names when modifying schemas (add _2, _3, etc.)
5
126  await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_posts_type ON community_posts_v1 (type, created_at DESC)`);
127
128  console.log("Database migrations completed successfully");
129}