Val Town Code SearchReturn to Val Town

1// Database migrations for Xplicit E-learning Platform
2
3import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
29
30export async function runMigrations() {
31  console.log('Running database migrations...');
32
33  // Users table (main authentication table)
525  await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_teacher_hours_date ON ${TABLES.TEACHER_HOURS}(date)`);
526
527  console.log('Database migrations completed successfully');
528}
529}

11│   │   ├── api.ts          # API endpoints
12│   │   └── static.ts       # Static file serving
13│   └── database/
14│       ├── migrations.ts    # Database setup
15│       └── queries.ts       # Database operations
16├── frontend/
17│   ├── index.html          # Main HTML template
60- **Backend**: Hono framework on Deno
61- **Styling**: TailwindCSS
62- **Database**: SQLite
63- **Storage**: Val Town Blob storage
64- **External**: Google Workspace APIs

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { runMigrations } from "./database/migrations.ts";
3import auth from "./routes/auth.ts";
4import leads from "./routes/leads.ts";
12});
13
14// Initialize database on startup
15await runMigrations();
16

8  updateLeadContact,
9  addNote 
10} from "../database/queries.ts";
11import { requireAuth } from "./auth.ts";
12

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { setCookie, getCookie } from "https://esm.sh/hono@3.11.7/cookie";
3import { createSession, validateSession, deleteExpiredSessions } from "../database/queries.ts";
4
5const auth = new Hono();

33```
34├── backend/
35│   ├── database/
36│   │   ├── migrations.ts    # Schema do banco
37│   │   └── queries.ts       # Funções de consulta

4import { cors } from "https://esm.sh/hono@3.11.7/middleware";
5import type { ApiResponse } from '../../shared/types.ts';
6import * as queries from '../database/queries.ts';
7
8const api = new Hono();

1// Database query functions for Xplicit E-learning Platform
2
3import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";

264      apiKey: "AIzaSyBvqyvSJeFEDcjA3mOhIgwuEt_53X9Fsn0",
265      authDomain: "cbtwebsite-8333c.firebaseapp.com",
266      databaseURL: "https://cbtwebsite-8333c-default-rtdb.europe-west1.firebasedatabase.app",
267      projectId: "cbtwebsite-8333c",
268      storageBucket: "cbtwebsite-8333c.firebasestorage.app",

80    const project = await c.req.json();
81    
82    // In a real implementation, save to database
83    return c.json({
84      success: true,