[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_296":297,"_298":299},"routes/_app.x.$handle.$name",{"_102":101,"_32":51,"_110":92,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_21":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":64,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_38":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",12,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","backend/auth/utils.ts","latestPath","fileId","79666202-3cba-11f0-a622-9e149126039e","name","utils.ts","fileType","script","content","import { Context } from \"https://esm.sh/hono@3.11.7\";\nimport { sign, verify } from \"https://esm.sh/jsonwebtoken@9.0.2\";\nimport { hash, compare } from \"https://esm.sh/bcryptjs@2.4.3\";\nimport { getUserById, validateSession, createSession, deleteSession } from \"../database/queries.ts\";\nimport type { User } from \"../../shared/types.ts\";\n\nconst JWT_SECRET = Deno.env.get('JWT_SECRET') || 'your-secret-key-change-in-production';\nconst TOKEN_EXPIRY = '7d'; // 7 days\n\nexport async function hashPassword(password: string): Promise {\n return await hash(password, 12);\n}\n\nexport async function verifyPassword(password: string, hash: string): Promise {\n return await compare(password, hash);\n}\n\nexport function generateToken(userId: number): string {\n return sign({ userId }, JWT_SECRET, { expiresIn: TOKEN_EXPIRY });\n}\n\nexport async function verifyToken(token: string): Promise {\n try {\n const decoded = verify(token, JWT_SECRET) as { userId: number };\n return decoded.userId;\n } catch {\n return null;\n }\n}\n\nexport async function createUserSession(userId: number): Promise {\n const token = generateToken(userId);\n const tokenHash = await hash(token, 10);\n const expiresAt = new Date(Date.now() + 7 * 24 * 60 * 60 * 1000).toISOString(); // 7 days\n \n await createSession(userId, tokenHash, expiresAt);\n return token;\n}\n\nexport async function validateUserSession(token: string): Promise {\n const userId = await verifyToken(token);\n if (!userId) return null;\n \n const tokenHash = await hash(token, 10);\n const sessionUserId = await validateSession(tokenHash);\n \n if (!sessionUserId || sessionUserId !== userId) return null;\n \n return await getUserById(userId);\n}\n\nexport async function invalidateSession(token: string): Promise {\n const tokenHash = await hash(token, 10);\n await deleteSession(tokenHash);\n}\n\nexport function getTokenFromRequest(c: Context): string | null {\n const authHeader = c.req.header('Authorization');\n if (authHeader && authHeader.startsWith('Bearer ')) {\n return authHeader.substring(7);\n }\n \n // Also check cookies as fallback\n const cookieToken = c.req.header('Cookie')\n ?.split(';')\n .find(cookie => cookie.trim().startsWith('auth_token='))\n ?.split('=')[1];\n \n return cookieToken || null;\n}\n\nexport async function requireAuth(c: Context, next: () => Promise) {\n const token = getTokenFromRequest(c);\n \n if (!token) {\n return c.json({ success: false, message: 'Authentication required' }, 401);\n }\n \n const user = await validateUserSession(token);\n if (!user) {\n return c.json({ success: false, message: 'Invalid or expired token' }, 401);\n }\n \n // Add user to context\n c.set('user', user);\n await next();\n}\n\nexport function getCurrentUser(c: Context): User {\n return c.get('user');\n}","createdAt",["D",1748543204677],"branchVersion","branchId","61cd9f9a-3cb8-11f0-a555-9e149126039e",{"_30":45,"_32":46,"_34":47,"_36":-5,"_38":48,"_40":14,"_41":42,"_24":25},"backend/auth","4a597fca-4fe3-4edc-9b5a-2d40ac8f5452","auth","directory",["D",1748543204677],"id","61cd709c-3cb8-11f0-a555-9e149126039e","my-first-val",["D",1748542306097],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","5468f8e0-3cb8-11f0-8166-d94e9c211fd2","pinnedFileId","61d290ea-3cb8-11f0-a555-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","5d0995c1-fabc-4a0d-8c50-4107c4a34e15","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"isOwned",24,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Mahi77","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4bVRUM0tHbVEwRVZFSHJ1R2VNb0ZvQnZReCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_38":292,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":293,"_86":294,"_88":295,"_90":25},"tree",[209,215,218,219,220,221,222,223],"files",[209,210,211,212,213,214,215,216,217,218,219,220,221,222,223],"counts",{"_199":68,"_200":154,"_201":68,"_202":203,"_204":205},"contents",[132,133,134,135,136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":193,"_32":194,"_30":195,"_143":-5,"_41":42,"_40":196,"_145":64,"_38":197,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_27":198},{"_49":187,"_32":188,"_30":189,"_143":-5,"_41":42,"_40":190,"_145":64,"_38":191,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_27":192},{"_49":180,"_32":181,"_30":182,"_143":-5,"_41":42,"_40":183,"_145":64,"_38":184,"_13":68,"_34":35,"_36":185,"_24":25,"_147":-5,"_27":186},{"_49":173,"_32":174,"_30":62,"_143":-5,"_41":42,"_40":175,"_145":64,"_38":176,"_13":68,"_34":177,"_36":178,"_24":25,"_147":-5,"_27":179},{"_49":165,"_32":166,"_30":167,"_143":-5,"_41":42,"_40":168,"_145":64,"_38":169,"_13":68,"_34":170,"_36":171,"_24":25,"_147":-5,"_27":172},{"_49":157,"_32":158,"_30":159,"_143":-5,"_41":42,"_40":160,"_145":64,"_38":161,"_13":68,"_34":162,"_36":163,"_24":25,"_147":-5,"_27":164},{"_49":149,"_32":150,"_30":151,"_143":-5,"_41":42,"_40":152,"_145":64,"_38":153,"_13":154,"_34":21,"_36":155,"_24":25,"_147":-5,"_27":156},{"_49":140,"_32":141,"_30":142,"_143":-5,"_41":42,"_40":144,"_145":64,"_38":146,"_13":68,"_34":35,"_36":111,"_24":25,"_147":-5,"_27":148},"b767872c-3cb8-11f0-9e5d-9e149126039e","new-file-5453.tsx","b76787cc-3cb8-11f0-9e5d-9e149126039e","parentId",6,"latest",["D",1748542449711],"label",[141],"4cd1f45e-3cba-11f0-9eda-9e149126039e","README.md","61ceda04-3cb8-11f0-a555-9e149126039e",7,["D",1748543129866],1,"# AI/ML Media Recognition Platform\n\nA comprehensive platform for AI-powered media recognition with user authentication, real-time analysis, and intelligent search capabilities.\n\n## Features\n\n- **User Authentication**: Secure login/signup system with session management\n- **Multi-Media Support**: Image, video, and audio recognition\n- **Real-time Capture**: In-browser media capture capabilities\n- **AI Analysis**: Powered by OpenAI's vision and audio models\n- **Intelligent Search**: Find similar content based on descriptions\n- **Secure Storage**: User data and media metadata stored securely\n\n## Architecture\n\n### Backend (`/backend/`)\n- **index.ts**: Main Hono server with API routes\n- **database/**: SQLite database setup and queries\n- **routes/**: Modular route handlers\n- **auth/**: Authentication middleware and utilities\n\n### Frontend (`/frontend/`)\n- **index.html**: Main application shell\n- **components/**: React components for UI\n- **services/**: API communication and media handling\n- **utils/**: Client-side utilities\n\n### Shared (`/shared/`)\n- **types.ts**: TypeScript interfaces and types\n- **utils.ts**: Shared utility functions\n\n## API Endpoints\n\n- `POST /api/auth/login` - User login\n- `POST /api/auth/signup` - User registration\n- `POST /api/auth/logout` - User logout\n- `GET /api/auth/me` - Get current user\n- `POST /api/media/analyze` - Analyze uploaded media\n- `POST /api/media/search` - Search similar content\n- `GET /api/media/history` - Get user's analysis history\n\n## Technology Stack\n\n- **Backend**: Hono, SQLite, OpenAI API\n- **Frontend**: React, TailwindCSS\n- **AI/ML**: OpenAI GPT-4 Vision, Whisper\n- **Storage**: Val Town Blob storage\n- **Authentication**: JWT-based sessions\n\n## Getting Started\n\n1. Set up environment variables:\n - `OPENAI_API_KEY`: Your OpenAI API key\n - `JWT_SECRET`: Secret for JWT token signing\n\n2. The application will automatically create database tables on first run\n\n3. Access the application at the HTTP endpoint URL\n\n## Security Features\n\n- Password hashing with bcrypt\n- JWT-based authentication\n- CORS protection\n- Input validation and sanitization\n- Secure file upload handling",[150],"61d6e258-3cb8-11f0-a555-9e149126039e","04_email.tsx","61d6e2ee-3cb8-11f0-a555-9e149126039e",5,["D",1748542306158],"email","// This code is triggered when an email is sent to its unique address.\n// Click \"Run\", copy and paste the email address and send an email to it.\n// This example will log the email details received.\nexport default async function emailHandler(email: Email){\n console.log(\"Email received!\", email.from, email.subject, email.text);\n for (const file of email.attachments) {\n console.log(`Filename: ${file.name}`);\n console.log(`Content Type: ${file.type}`);\n console.log(`Content: ${await file.text()}`);\n }\n}",[158],"61d4961a-3cb8-11f0-a555-9e149126039e","03_cron.tsx","61d496ba-3cb8-11f0-a555-9e149126039e",4,["D",1748542306141],"interval","// This cron runs on a schedule (e.g. every hour, day).\n// Configure the timer with the 🕒 icon in the top right.\n// This example just logs the current time.\nexport function scheduledHandler() {\n const timestamp = new Date().toISOString();\n console.log(`Cron val executed at: ${timestamp}`);\n return `Executed at ${timestamp}`;\n}",[166],"61d29036-3cb8-11f0-a555-9e149126039e","02_http.tsx",3,["D",1748542306129],"http","// This code responds to HTTP web requests.\n// Access it via its public URL (you can also pick a nicer subdomain).\n// Try adding ?name=YourName to the URL!\nexport default function httpHandler(req: Request): Response {\n const url = new URL(req.url);\n const name = url.searchParams.get(\"name\") || \"Friend\";\n console.log(`Greeted ${name} via HTTP`);\n return new Response(`Hello, ${name}! Welcome to Val Town.`);\n}",[174],"61d0c65c-3cb8-11f0-a555-9e149126039e","01_script.tsx","61d0c706-3cb8-11f0-a555-9e149126039e",2,["D",1748542306117],"// This script returns a random fun fact\n// You can run scripts manually in this view or call it from other vals.\nexport default function getRandomFact() {\n const funFacts = [\n \"Honey never spoils.\",\n \"Bananas are actually berries, but strawberries are not.\",\n \"Val Town has a citizen Juicy Bear. 🐻\",\n ];\n const fact = funFacts[Math.floor(Math.random() * funFacts.length)];\n return fact;\n}\nconsole.log(\"Fun fact:\", getRandomFact());\n",[181],"532f31b8-3cba-11f0-b872-9e149126039e","shared","d1679996-877c-44a1-9d8e-b54e3dba81a5",8,["D",1748543140561],[188],"630ab242-3cba-11f0-bbbe-9e149126039e","backend","b451bc98-fdf2-4a33-a9e6-5d661aed07bd",10,["D",1748543167164],[194],"pulls","branches","forks","envVars",{"_206":68,"_208":68},"connections",{"_206":68,"_207":68},"count","unfilledCount","emptyCount",{"_49":193,"_32":194,"_30":195,"_143":-5,"_41":42,"_40":196,"_145":64,"_38":289,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_225":290,"_27":291},{"_49":285,"_32":46,"_30":45,"_143":195,"_41":42,"_40":14,"_145":64,"_38":286,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_225":287,"_27":288},{"_49":281,"_32":33,"_30":31,"_143":45,"_41":42,"_40":14,"_145":64,"_38":282,"_13":68,"_34":35,"_36":37,"_24":25,"_147":-5,"_225":283,"_27":284},{"_49":277,"_32":269,"_30":263,"_143":195,"_41":42,"_40":196,"_145":64,"_38":278,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_225":279,"_27":280},{"_49":270,"_32":271,"_30":272,"_143":263,"_41":42,"_40":196,"_145":64,"_38":273,"_13":68,"_34":35,"_36":274,"_24":25,"_147":-5,"_225":275,"_27":276},{"_49":260,"_32":261,"_30":262,"_143":263,"_41":42,"_40":264,"_145":64,"_38":265,"_13":68,"_34":35,"_36":266,"_24":25,"_147":-5,"_225":267,"_27":268},{"_49":187,"_32":188,"_30":189,"_143":-5,"_41":42,"_40":190,"_145":64,"_38":257,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_225":258,"_27":259},{"_49":250,"_32":251,"_30":252,"_143":189,"_41":42,"_40":190,"_145":64,"_38":253,"_13":68,"_34":35,"_36":254,"_24":25,"_147":-5,"_225":255,"_27":256},{"_49":243,"_32":33,"_30":244,"_143":189,"_41":42,"_40":245,"_145":64,"_38":246,"_13":68,"_34":35,"_36":247,"_24":25,"_147":-5,"_225":248,"_27":249},{"_49":180,"_32":181,"_30":182,"_143":-5,"_41":42,"_40":183,"_145":64,"_38":240,"_13":68,"_34":35,"_36":185,"_24":25,"_147":-5,"_225":241,"_27":242},{"_49":173,"_32":174,"_30":62,"_143":-5,"_41":42,"_40":175,"_145":64,"_38":237,"_13":68,"_34":177,"_36":178,"_24":25,"_147":-5,"_225":238,"_27":239},{"_49":165,"_32":166,"_30":167,"_143":-5,"_41":42,"_40":168,"_145":64,"_38":234,"_13":68,"_34":170,"_36":171,"_24":25,"_147":-5,"_225":235,"_27":236},{"_49":157,"_32":158,"_30":159,"_143":-5,"_41":42,"_40":160,"_145":64,"_38":231,"_13":68,"_34":162,"_36":163,"_24":25,"_147":-5,"_225":232,"_27":233},{"_49":149,"_32":150,"_30":151,"_143":-5,"_41":42,"_40":152,"_145":64,"_38":228,"_13":154,"_34":21,"_36":155,"_24":25,"_147":-5,"_225":229,"_27":230},{"_49":140,"_32":141,"_30":142,"_143":-5,"_41":42,"_40":144,"_145":64,"_38":224,"_13":68,"_34":35,"_36":111,"_24":25,"_147":-5,"_225":226,"_27":227},["D",1748542449711],"children",[],[141],["D",1748543129866],[],[150],["D",1748542306158],[],[158],["D",1748542306141],[],[166],["D",1748542306129],[],[174],["D",1748542306117],[],[181],"5ac9717c-3cba-11f0-a693-9e149126039e","5ac97244-3cba-11f0-a693-9e149126039e",9,["D",1748543153316],"// Shared utility functions\n\nexport function validateEmail(email: string): boolean {\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n return emailRegex.test(email);\n}\n\nexport function validatePassword(password: string): { valid: boolean; message?: string } {\n if (password.length < 8) {\n return { valid: false, message: 'Password must be at least 8 characters long' };\n }\n if (!/(?=.*[a-z])/.test(password)) {\n return { valid: false, message: 'Password must contain at least one lowercase letter' };\n }\n if (!/(?=.*[A-Z])/.test(password)) {\n return { valid: false, message: 'Password must contain at least one uppercase letter' };\n }\n if (!/(?=.*\\d)/.test(password)) {\n return { valid: false, message: 'Password must contain at least one number' };\n }\n return { valid: true };\n}\n\nexport function formatFileSize(bytes: number): string {\n if (bytes === 0) return '0 Bytes';\n const k = 1024;\n const sizes = ['Bytes', 'KB', 'MB', 'GB'];\n const i = Math.floor(Math.log(bytes) / Math.log(k));\n return parseFloat((bytes / Math.pow(k, i)).toFixed(2)) + ' ' + sizes[i];\n}\n\nexport function formatDate(dateString: string): string {\n const date = new Date(dateString);\n return date.toLocaleDateString() + ' ' + date.toLocaleTimeString();\n}\n\nexport function generateId(): string {\n return Math.random().toString(36).substr(2, 9);\n}\n\nexport function sanitizeFileName(fileName: string): string {\n return fileName.replace(/[^a-zA-Z0-9.-]/g, '_');\n}\n\nexport function extractFileExtension(fileName: string): string {\n return fileName.split('.').pop()?.toLowerCase() || '';\n}\n\nexport function isValidMediaType(mimeType: string, allowedTypes: string[]): boolean {\n return allowedTypes.includes(mimeType);\n}\n\nexport function truncateText(text: string, maxLength: number): string {\n if (text.length <= maxLength) return text;\n return text.substr(0, maxLength) + '...';\n}\n\nexport function debounce any>(\n func: T,\n wait: number\n): (...args: Parameters) => void {\n let timeout: number | undefined;\n return (...args: Parameters) => {\n clearTimeout(timeout);\n timeout = setTimeout(() => func(...args), wait);\n };\n}\n\nexport function createFormData(data: Record): FormData {\n const formData = new FormData();\n Object.entries(data).forEach(([key, value]) => {\n if (value instanceof File) {\n formData.append(key, value);\n } else {\n formData.append(key, JSON.stringify(value));\n }\n });\n return formData;\n}",[],[188,33],"532f12f0-3cba-11f0-b872-9e149126039e","types.ts","532f13cc-3cba-11f0-b872-9e149126039e",["D",1748543140561],"// Shared TypeScript types and interfaces\n\nexport interface User {\n id: number;\n email: string;\n username: string;\n created_at: string;\n}\n\nexport interface AuthResponse {\n success: boolean;\n user?: User;\n token?: string;\n message?: string;\n}\n\nexport interface MediaAnalysis {\n id: number;\n user_id: number;\n media_type: 'image' | 'video' | 'audio';\n file_name: string;\n file_size: number;\n analysis_result: string;\n tags: string[];\n confidence_score: number;\n created_at: string;\n}\n\nexport interface AnalysisRequest {\n mediaType: 'image' | 'video' | 'audio';\n fileName: string;\n fileData: string; // base64 encoded\n}\n\nexport interface AnalysisResponse {\n success: boolean;\n analysis?: {\n description: string;\n tags: string[];\n confidence: number;\n objects?: string[];\n emotions?: string[];\n text?: string;\n };\n message?: string;\n}\n\nexport interface SearchRequest {\n query: string;\n mediaType?: 'image' | 'video' | 'audio';\n limit?: number;\n}\n\nexport interface SearchResponse {\n success: boolean;\n results?: MediaAnalysis[];\n message?: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n message?: string;\n error?: string;\n}\n\nexport interface CaptureOptions {\n video?: boolean;\n audio?: boolean;\n facingMode?: 'user' | 'environment';\n}\n\nexport interface MediaConstraints {\n maxFileSize: number; // in bytes\n allowedTypes: string[];\n maxDuration?: number; // for video/audio in seconds\n}\n\nexport const MEDIA_CONSTRAINTS: MediaConstraints = {\n maxFileSize: 50 * 1024 * 1024, // 50MB\n allowedTypes: [\n 'image/jpeg',\n 'image/png',\n 'image/webp',\n 'video/mp4',\n 'video/webm',\n 'audio/mp3',\n 'audio/wav',\n 'audio/webm'\n ],\n maxDuration: 300 // 5 minutes\n};",[],[188,251],["D",1748543140561],[216,217],[188],"70861c36-3cba-11f0-8367-9e149126039e","queries.ts","70861cf4-3cba-11f0-8367-9e149126039e","7007d617-c866-4d62-b49d-4382369ad7cd",11,["D",1748543189786],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { User, MediaAnalysis } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(email: string, username: string, passwordHash: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO users_v1 (email, username, password_hash) VALUES (?, ?, ?) RETURNING *`,\n [email, username, passwordHash]\n );\n return result[0] as User;\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, username, created_at FROM users_v1 WHERE email = ?`,\n [email]\n );\n return result[0] as User || null;\n}\n\nexport async function getUserByUsername(username: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, username, created_at FROM users_v1 WHERE username = ?`,\n [username]\n );\n return result[0] as User || null;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, username, created_at FROM users_v1 WHERE id = ?`,\n [id]\n );\n return result[0] as User || null;\n}\n\nexport async function getUserPasswordHash(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT password_hash FROM users_v1 WHERE email = ?`,\n [email]\n );\n return result[0]?.password_hash || null;\n}\n\n// Session queries\nexport async function createSession(userId: number, tokenHash: string, expiresAt: string): Promise {\n await sqlite.execute(\n `INSERT INTO user_sessions_v1 (user_id, token_hash, expires_at) VALUES (?, ?, ?)`,\n [userId, tokenHash, expiresAt]\n );\n}\n\nexport async function validateSession(tokenHash: string): Promise {\n const result = await sqlite.execute(\n `SELECT user_id FROM user_sessions_v1 WHERE token_hash = ? AND expires_at > datetime('now')`,\n [tokenHash]\n );\n return result[0]?.user_id || null;\n}\n\nexport async function deleteSession(tokenHash: string): Promise {\n await sqlite.execute(\n `DELETE FROM user_sessions_v1 WHERE token_hash = ?`,\n [tokenHash]\n );\n}\n\nexport async function deleteUserSessions(userId: number): Promise {\n await sqlite.execute(\n `DELETE FROM user_sessions_v1 WHERE user_id = ?`,\n [userId]\n );\n}\n\n// Media analysis queries\nexport async function createMediaAnalysis(\n userId: number,\n mediaType: string,\n fileName: string,\n fileSize: number,\n blobKey: string,\n analysisResult: string,\n tags: string[],\n confidenceScore: number\n): Promise {\n const result = await sqlite.execute(\n `INSERT INTO media_analyses_v1 \n (user_id, media_type, file_name, file_size, blob_key, analysis_result, tags, confidence_score) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?) RETURNING *`,\n [userId, mediaType, fileName, fileSize, blobKey, JSON.stringify(tags), analysisResult, confidenceScore]\n );\n \n const analysis = result[0] as any;\n return {\n ...analysis,\n tags: JSON.parse(analysis.tags)\n } as MediaAnalysis;\n}\n\nexport async function getUserMediaAnalyses(userId: number, limit: number = 50): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM media_analyses_v1 WHERE user_id = ? ORDER BY created_at DESC LIMIT ?`,\n [userId, limit]\n );\n \n return result.map((analysis: any) => ({\n ...analysis,\n tags: JSON.parse(analysis.tags)\n })) as MediaAnalysis[];\n}\n\nexport async function getMediaAnalysisById(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM media_analyses_v1 WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n \n if (!result[0]) return null;\n \n const analysis = result[0] as any;\n return {\n ...analysis,\n tags: JSON.parse(analysis.tags)\n } as MediaAnalysis;\n}\n\nexport async function searchMediaAnalyses(\n userId: number,\n query: string,\n mediaType?: string,\n limit: number = 20\n): Promise {\n let sql = `\n SELECT * FROM media_analyses_v1 \n WHERE user_id = ? AND (\n analysis_result LIKE ? OR \n tags LIKE ? OR \n file_name LIKE ?\n )\n `;\n \n const params: any[] = [userId, `%${query}%`, `%${query}%`, `%${query}%`];\n \n if (mediaType) {\n sql += ` AND media_type = ?`;\n params.push(mediaType);\n }\n \n sql += ` ORDER BY created_at DESC LIMIT ?`;\n params.push(limit);\n \n const result = await sqlite.execute(sql, params);\n \n return result.map((analysis: any) => ({\n ...analysis,\n tags: JSON.parse(analysis.tags)\n })) as MediaAnalysis[];\n}\n\nexport async function deleteMediaAnalysis(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM media_analyses_v1 WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n return result.changes > 0;\n}\n\n// Search history queries\nexport async function createSearchHistory(\n userId: number,\n query: string,\n mediaType: string | null,\n resultsCount: number\n): Promise {\n await sqlite.execute(\n `INSERT INTO search_history_v1 (user_id, query, media_type, results_count) VALUES (?, ?, ?, ?)`,\n [userId, query, mediaType, resultsCount]\n );\n}\n\nexport async function getUserSearchHistory(userId: number, limit: number = 10): Promise {\n const result = await sqlite.execute(\n `SELECT query, media_type, results_count, created_at \n FROM search_history_v1 \n WHERE user_id = ? \n ORDER BY created_at DESC \n LIMIT ?`,\n [userId, limit]\n );\n return result;\n}",[],[194,269,261],"database","630a8f06-3cba-11f0-bbbe-9e149126039e","migrations.ts","630a8fe2-3cba-11f0-bbbe-9e149126039e",["D",1748543167164],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Database schema definitions and migrations\n\nexport async function initializeDatabase() {\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE NOT NULL,\n username TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Media analyses table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS media_analyses_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n media_type TEXT NOT NULL CHECK (media_type IN ('image', 'video', 'audio')),\n file_name TEXT NOT NULL,\n file_size INTEGER NOT NULL,\n blob_key TEXT NOT NULL,\n analysis_result TEXT NOT NULL,\n tags TEXT NOT NULL, -- JSON array of tags\n confidence_score REAL NOT NULL DEFAULT 0.0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users_v1 (id) ON DELETE CASCADE\n )\n `);\n\n // User sessions table for JWT token management\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS user_sessions_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n token_hash TEXT NOT NULL,\n expires_at DATETIME NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users_v1 (id) ON DELETE CASCADE\n )\n `);\n\n // Search history table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS search_history_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n query TEXT NOT NULL,\n media_type TEXT,\n results_count INTEGER NOT NULL DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users_v1 (id) ON DELETE CASCADE\n )\n `);\n\n // Create indexes for better performance\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_media_analyses_user_id ON media_analyses_v1(user_id)\n `);\n \n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_media_analyses_type ON media_analyses_v1(media_type)\n `);\n \n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_media_analyses_created_at ON media_analyses_v1(created_at)\n `);\n \n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_user_sessions_user_id ON user_sessions_v1(user_id)\n `);\n \n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_user_sessions_expires_at ON user_sessions_v1(expires_at)\n `);\n\n console.log('Database initialized successfully');\n}\n\nexport async function cleanupExpiredSessions() {\n await sqlite.execute(`\n DELETE FROM user_sessions_v1 \n WHERE expires_at < datetime('now')\n `);\n}",[],[194,269,271],"630ab3dc-3cba-11f0-bbbe-9e149126039e",["D",1748543167164],[213,214],[194,269],"79666162-3cba-11f0-a622-9e149126039e",["D",1748543204677],[],[194,46,33],"796685e8-3cba-11f0-a622-9e149126039e",["D",1748543204677],[211],[194,46],["D",1748543167164],[210,212],[194],["D",1748542306097],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":329,"_330":331,"_332":333,"_334":25,"_335":25,"_336":25,"_337":64,"_338":-5,"_339":-7,"_340":-7,"_341":68,"_342":25,"_343":25,"_344":-5,"_345":25,"_346":25,"_347":25,"_348":-5},"ENV",{"_300":301,"_302":303,"_304":92,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v12