1# Val Town Dashboard
2
3A dashboard application for managing Val Town resources including blobs, emails, profiles, SQLite databases, and vals.
4
5## Project Structure
36- **Email Management**: Handle Val Town email functionality
37- **Profile Management**: Manage Val Town user profiles
38- **SQLite Management**: Interact with Val Town SQLite databases
39- **Vals Management**: Manage Val Town vals (functions)
40- **Settings**: User authentication and preferences
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { castVote, getVoteResults, hasUserVoted, getUserVote } from "../database/queries.ts";
3import { CANDIDATES } from "../../shared/types.ts";
4
22 )`);
23
24 console.log('Database migrations completed');
25}
26
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 { getVoteResults, getChatMessages } from "./database/queries.ts";
5import votes from "./routes/votes.ts";
6import chat from "./routes/chat.ts";
13});
14
15// Initialize database on startup
16await runMigrations();
17
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { addChatMessage, getChatMessages, getRecentChatMessages } from "../database/queries.ts";
3
4const chat = new Hono();
1// val type=script
2import { db } from "https://esm.town/v/Sarax201.MyProgress.Database.db.achievements";
3
4export function addAchievement(data: {
1// val type=http
2import { Hono } from "https://deno.land/x/hono/mod.ts";
3import { addAchievement } from "https://esm.town/v/Sarax201.MyProgress.Database.addAchievement";
4import { getAchievements } from "https://esm.town/v/Sarax201.MyProgress.Database.getAchievements";
5
6const app = new Hono();
1// val type=script
2import { Database } from "https://deno.land/x/sqlite/mod.ts";
3
4export const db = new Database();
5
6db.execute(`
135}
136
137// Database Models
138export interface DBThoughtFork extends Omit<ThoughtFork, 'explorations'> {
139 explorations: string; // JSON string
205}
206
207// Database models for user-scoped entities
208export interface DBUserScopedThoughtFork extends Omit<UserScopedThoughtFork, 'explorations'> {
209 explorations: string; // JSON string
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { runMigrations, insertSampleData } from "./database/migrations.ts";
3import auth from "./routes/auth.ts";
4import apartments from "./routes/apartments.ts";
13});
14
15// Initialize database on startup
16let dbInitialized = false;
17async function initializeDatabase() {
18 if (!dbInitialized) {
19 console.log("Initializing Saint Benedict Joseph database...");
20 await runMigrations();
21 await insertSampleData();
22 dbInitialized = true;
23 console.log("Database initialization complete!");
24 }
25}
26
27// Initialize database before handling requests
28app.use("*", async (c, next) => {
29 await initializeDatabase();
30 await next();
31});