personalShopperindex.ts3 matches
25updateUserLocation,26updateUserTokens,27} from "./database/krogerQueries.ts";28import { runMigrations } from "./database/migrations.ts";29// import { KrogerAuthService } from "./services/krogerAuth.ts";30import { MockKrogerAuthService } from "./services/fakeKrogerAuth.ts";34const app = new Hono();3536// Initialize database on startup37await runMigrations();38
reactHonoStarterREADME.md1 match
21## Further resources2223- [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a bigger example project, with a SQLite database table, queries, client-side CSS, a favicon, and shared code that runs on both client and server.
SocialArchetypeQuizindex.ts6 matches
802import { email } from "https://esm.town/v/std/email";803804// Database setup805const TABLE_NAME = 'archetype_quiz_results_v1';806807async function initDatabase() {808await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (809id INTEGER PRIMARY KEY AUTOINCREMENT,818819async function saveQuizResult(userEmail: string, calculatedArchetype: string, chosenArchetype: string, scores: any, answers: any) {820await initDatabase();821await sqlite.execute(822`INSERT INTO ${TABLE_NAME} (email, calculated_archetype, chosen_archetype, scores, answers) VALUES (?, ?, ?, ?, ?)`,826827async function getQuizResults(limit = 50, offset = 0) {828await initDatabase();829try {830const results = await sqlite.execute(849850async function getQuizStats() {851await initDatabase();852try {1015const { email, calculatedArchetype, chosenArchetype, scores, answers } = await req.json();1016// Save to database1018await saveQuizResult(email, calculatedArchetype, chosenArchetype, scores, answers);1019
SocialArchetypeQuizREADME.md3 matches
9- **Confetti Animations**: Celebratory confetti on every button click10- **Iridescent Design**: Purple, blue, and pink gradient theme with glassmorphism effects11- **Backend Storage**: SQLite database stores quiz results and user choices12- **User Choice**: Users can choose their preferred archetype after seeing results13- **Mobile Responsive**: Works perfectly on all device sizes91- Timestamp of completion9293Database table: `archetype_quiz_results_v1`9495## 🛠 Technical Stack99- **Animations**: Canvas Confetti library100- **Icons**: Font Awesome 6.4.0101- **Backend**: Val Town SQLite database102- **Platform**: Val Town serverless103
ssscQuizadmin.http.ts8 matches
12const TABLE_NAME = 'sssc_quiz_submissions_v1'; // Must match the table name in index.http.ts13// Database initialization - ensure table exists15async function initDatabase() {16await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (17id INTEGER PRIMARY KEY AUTOINCREMENT,33}34// Initialize database on startup36await initDatabase();37// Main admin dashboard route94<body>95<div style="padding: 2rem; text-align: center;">96<h1>⚠️ Database Error</h1>97<p>Unable to load dashboard data. Please check if the database is initialized.</p>98<a href="/" style="color: #4361ee;">← Back to Quiz</a>99</div>204});205// Debug endpoint to check database contents207app.get("/api/debug", async c => {208try {527<p>Total Submissions: <strong>${total}</strong></p>528<p style="font-size: 0.9rem; opacity: 0.8;">529<a href="/api/debug" style="color: rgba(255,255,255,0.8); text-decoration: none;">🔍 Debug Database</a>530</p>531</div>
10- **Personality Analysis**: Advanced algorithm determining primary social archetype11- **Email Delivery**: Automated email with detailed results and insights12- **Data Persistence**: All submissions stored in SQLite database13### Enhanced Features61- **Backend**: Hono web framework on Deno62- **Frontend**: React 18 with TypeScript63- **Database**: Val Town SQLite64- **Email**: Val Town email service65- **Styling**: CSS with custom properties and responsive design91- Primary HTTP val that users visit92- Hono web server with comprehensive error handling93- SQLite database with optimized schema and indexing94- Enhanced email system with HTML/text templates95- API endpoints for quiz submission and analytics107### Backend (Hono)108- RESTful API with proper error handling109- SQLite database with structured schema and indexes110- Email automation with professional HTML templates111- Admin analytics with real-time data120- Progressive enhancement121### Database Schema123```sql124CREATE TABLE sssc_quiz_submissions (180- **Email Validation**: Client and server-side validation182- **Data Sanitization**: All inputs sanitized before database storage183- **Privacy Focused**: No tracking beyond essential quiz functionality184- **Secure Storage**: Encrypted database storage through Val Town185## 🚀 Deployment1901. **Main Application**: `index.http.ts` - Primary entry point users visit1912. **Admin Dashboard**: `admin.http.ts` - Analytics and data management1923. **Database**: Automatic SQLite initialization with proper indexing1934. **Email**: Enhanced email service with HTML templates following Val Town standards1945. **Frontend**: Served as static files with mobile-responsive design254- **Efficient Rendering**: Optimized React components255- **CSS Optimization**: Custom properties and efficient selectors256- **Database Queries**: Indexed and optimized queries257
ssscQuizindex.http.ts9 matches
13});14// Database setup following Val Town standards16const TABLE_NAME = 'sssc_quiz_submissions_v1'; // Must match admin.http.ts table name17// Initialize database with Val Town best practices19async function initDatabase() {20await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (21id INTEGER PRIMARY KEY AUTOINCREMENT,37}38// Initialize database on startup40await initDatabase();41// Serve static files86const ipHash = forwarded ? await hashIP(forwarded.split(',')[0].trim()) : '';87console.log("Storing in database...");89console.log("Table name:", TABLE_NAME);90console.log("Data to insert:", {96});97// Store in database following Val Town patterns99const insertResult = await sqlite.execute(100`INSERT INTO ${TABLE_NAME} (113]114);115console.log("Database insert successful, result:", insertResult);116// Verify the insert worked200app.get("/api/test-insert", async c => {201try {202console.log("Testing database insert...");203const testEmail = `test${Date.now()}@example.com`;
37},38// Database configuration40database: {41tableName: "sssc_quiz_submissions_v1",42enableIndexes: true
11});1213app.get("/clear-databases", async (c) => {14return c.html(`15<h1>Clear Databases</h1>16<p>This will clear the databases for the bot.</p>17<form method="post" action="/clear-databases">18<input type="text" name="token" placeholder="Token" />19<button type="submit">Clear Databases</button>20</form>21<p>The password is ${Deno.env.get("ADMIN_TOKEN")}</p>23});2425// Clear databases endpoint26app.post("/clear-databases", async (c) => {27const body = await c.req.parseBody();28const token = body["token"];32}3334// clear the databases35await sqlite.execute(`DELETE FROM ${LangChainTables.checkpoints}`);36await sqlite.execute(`DELETE FROM ${LangChainTables.checkpoint_writes}`);3738return c.json({ message: "Databases cleared" });39});40
40await ctx.reply(`✅ Successfully joined room with secret: ${roomSecret}`);41} catch (dbError) {42console.error("Database error in join command:", dbError);43await ctx.reply("❌ Error joining room. Please try again.");44}74await ctx.reply(`✅ Successfully left room with secret: ${roomSecret}`);75} catch (dbError) {76console.error("Database error in leave command:", dbError);77await ctx.reply("❌ Error leaving room. Please try again.");78}