8
9/**
10 * Retrieves previously generated fun facts from the memories database
11 * @returns Array of previous fun facts
12 */
47
48/**
49 * Inserts a fun fact into the memories database
50 * @param date Date for the fun fact in ISO format
51 * @param factText The fun fact text
208```
209โโโ backend/
210โ โโโ database/
211โ โ โโโ migrations.ts # Schema definitions
212โ โ โโโ queries.ts # DB query functions
270- Handle API calls properly with proper error catching
271
272### Database Patterns
273- Run migrations on startup or comment out for performance
274- Change table names when modifying schemas rather than altering
8
9/**
10 * Retrieves previously generated fun facts from the memories database
11 * @returns Array of previous fun facts
12 */
47
48/**
49 * Inserts a fun fact into the memories database
50 * @param date Date for the fun fact in ISO format
51 * @param factText The fun fact text
126 }
127
128 console.log(`Weather forecast updated in the database.`);
129 return summary;
130}
486}
487
488// Setup required database tables
489async function setupDatabase() {
490 // Create vote_sessions table if it doesn't exist
491 await sqlite.execute(`
525 `);
526
527 console.log("โ
Database setup complete");
528}
529
534
535 try {
536 // Setup database tables
537 await setupDatabase();
538
539 // Load configurations
802export async function getPreviousVoteResults(limit: number = 5) {
803 try {
804 await setupDatabase();
805
806 const results = await sqlite.execute({
50 const now = Math.floor(Date.now() / 1000);
51
52 // Get the token from the database
53 const { rows } = await sqlite.execute(
54 `SELECT email, expires_at FROM ${MAGIC_LINKS_TABLE} WHERE token = ?`,
2
3This app is a port of the iClickWolf Next.js application to Val Town, using
4SQLite for database storage.
5
6## Project Structure
8- **Backend**: `/backend/index.ts` - The main HTTP server that serves the
9 frontend and API endpoints
10 - `/backend/database/` - Contains SQLite database setup and queries
11 - `/backend/routes/` - API routes for checkout, webhook, and items
12
20- Stripe integration for payments
21- Email notifications for order confirmations
22- SQLite database for storing items and preorders
23
24## Environment Variables
37- If Stripe is not configured (missing API keys), appropriate error messages are
38 shown
39- If the database fails to load items, default values are used as a fallback
40- All API errors are properly logged and user-friendly messages are displayed
41- Form validation prevents submission of invalid data
42
43## Database
44
45The application uses Val Town's SQLite database with the following tables:
46
47- `iclickwolf_items_v1` - Stores product information
43 email,
44 pickupLocation,
45 productID: 1, // We'll get the actual ID from the database on the server
46 }),
47 });
8import webhookRoutes from "./routes/webhook.ts";
9import itemsRoutes from "./routes/items.ts";
10import { runMigrations } from "./database/migrations.ts";
11
12// Initialize the app
19try {
20 await runMigrations();
21 console.log("Database migrations completed successfully");
22} catch (error) {
23 console.error("Database migration error:", error);
24}
25
2import { ITEMS_TABLE, PREORDERS_TABLE } from "./migrations.ts";
3
4// Types matching our database schema
5export interface Item {
6 id: number;