1/**
2 * Database queries for the email capture system
3 */
4
1/**
2 * Database migrations for the email capture system
3 */
4
10
11/**
12 * Initialize database tables
13 */
14export async function initDatabase() {
15 console.log('Initializing database...');
16
17 // Create projects table
57 `);
58
59 console.log('Database initialized successfully');
60}
61
62// Only run this file when executed directly
63if (import.meta.main) {
64 await initDatabase();
65}
66
1# Email Capture System
2
3A system to capture emails from various landing pages, identify them to projects, and store them in a database.
4
5## Features
6
7- Database for storing emails and projects
8- REST API for email capture and project management
9- Admin panel to manage projects and emails
13## Project Structure
14
15- `backend/`: Server-side code including API routes and database access
16- `frontend/`: Admin panel UI code
17- `shared/`: Shared types and utilities
18- `database/`: Database schema and queries
19
1{
2 "imports": {
3 "@neondatabase/serverless": "npm:@neondatabase/serverless",
4 "drizzle-orm/neon-http": "npm:drizzle-orm/neon-http",
5 "drizzle-kit": "npm:drizzle-kit@^0.30.5",
637
638// --- Server-side logic ---
639// --- REVERTED to match the database interactions of your ORIGINAL code ---
640export default async function server(req: Request): Promise<Response> {
641 const { sqlite } = await import("https://esm.town/v/stevekrouse/sqlite");
16 apiKey: "AIzaSyBRdHIXJcFUMV3h7k2GFg9wY0S_hUttaZU",
17 authDomain: "tommy-ai-image-generator-d2466.firebaseapp.com",
18 databaseURL: "https://tommy-ai-image-generator-d2466-default-rtdb.firebaseio.com",
19 projectId: "tommy-ai-image-generator-d2466",
20 storageBucket: "tommy-ai-image-generator-d2466.firebasestorage.app",
9- The **client-side entrypoint** is `/frontend/index.html`, which in turn imports `/frontend/index.tsx`, which in turn imports the React app from `/frontend/App.tsx`.
10
11[React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a fuller featured example project, with a SQLite database table, queries, client-side CSS and a favicon, and some shared code that runs on both client and server.
9- The **client-side entrypoint** is `/frontend/index.html`, which in turn imports `/frontend/index.tsx`, which in turn imports the React app from `/frontend/components/App.tsx`.
10
11[React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a fuller featured example project, with a SQLite database table, queries, client-side CSS and a favicon, and some shared code that runs on both client and server.
16const CARDS_TABLE = "timeline_cards";
17
18// Sample cards for each set (in a real app, these would be in the database)
19const SAMPLE_CARDS: Record<string, Card[]> = {
20 "random-history": random_history,
208};
209
210// Initialize database
211const initDb = async () => {
212 // Create games table
238};
239
240// Initialize database on startup
241initDb();
242
14const CARDS_TABLE = "timeline_cards";
15
16// Sample cards for each set (in a real app, these would be in the database)
17const SAMPLE_CARDS: Record<string, Card[]> = {
18 "random-history": [
556};
557
558// Initialize database
559const initDb = async () => {
560 // Create games table
586};
587
588// Initialize database on startup
589initDb();
590