[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_395":396,"_397":398},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":57,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",20,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/AuthComponent.tsx","latestPath","fileId","de59bdc6-3cba-11f0-8179-9e149126039e","name","AuthComponent.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { AuthService } from \"../services/AuthService.ts\";\nimport { validateEmail, validatePassword } from \"../../shared/utils.ts\";\nimport type { User } from \"../../shared/types.ts\";\n\ninterface AuthComponentProps {\n onLogin: (user: User, token: string) => void;\n error: string | null;\n setError: (error: string | null) => void;\n}\n\nexport default function AuthComponent({ onLogin, error, setError }: AuthComponentProps) {\n const [isLogin, setIsLogin] = useState(true);\n const [loading, setLoading] = useState(false);\n const [formData, setFormData] = useState({\n email: '',\n username: '',\n password: '',\n confirmPassword: ''\n });\n\n const handleInputChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n setError(null);\n };\n\n const validateForm = () => {\n if (!formData.email || !formData.password) {\n setError('Email and password are required');\n return false;\n }\n\n if (!validateEmail(formData.email)) {\n setError('Please enter a valid email address');\n return false;\n }\n\n if (!isLogin) {\n if (!formData.username) {\n setError('Username is required');\n return false;\n }\n\n const passwordValidation = validatePassword(formData.password);\n if (!passwordValidation.valid) {\n setError(passwordValidation.message!);\n return false;\n }\n\n if (formData.password !== formData.confirmPassword) {\n setError('Passwords do not match');\n return false;\n }\n }\n\n return true;\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!validateForm()) return;\n\n setLoading(true);\n setError(null);\n\n try {\n let response;\n \n if (isLogin) {\n response = await AuthService.login(formData.email, formData.password);\n } else {\n response = await AuthService.signup(formData.email, formData.username, formData.password);\n }\n\n if (response.success && response.user && response.token) {\n onLogin(response.user, response.token);\n } else {\n setError(response.message || 'Authentication failed');\n }\n } catch (error) {\n setError('Network error. Please try again.');\n console.error('Auth error:', error);\n } finally {\n setLoading(false);\n }\n };\n\n return (\n

🤖

\n AI Media Recognition Platform\n

\n {isLogin ? 'Sign in to your account' : 'Create your account'}\n

\n\n

\n \n Email address\n \n \n

\n\n {!isLogin && (\n

\n \n Username\n \n \n

\n )}\n\n

\n \n Password\n \n \n

\n\n {!isLogin && (\n

\n \n Confirm Password\n \n \n

\n )}\n

\n\n {error && (\n

\n {error}\n

\n )}\n\n

\n \n {loading ? (\n

\n ) : (\n isLogin ? 'Sign In' : 'Sign Up'\n )}\n \n

\n\n

\n {\n setIsLogin(!isLogin);\n setError(null);\n setFormData({\n email: '',\n username: '',\n password: '',\n confirmPassword: ''\n });\n }}\n className=\"text-indigo-600 hover:text-indigo-500 text-sm font-medium\"\n >\n {isLogin \n ? \"Don't have an account? Sign up\" \n : \"Already have an account? Sign in\"\n }\n \n

\n\n

Secure authentication with encrypted passwords

Your data is protected and never shared

\n );\n}","createdAt",["D",1748543374044],"branchVersion","branchId","61cd9f9a-3cb8-11f0-a555-9e149126039e","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",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"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",{"_42":43,"_31":44,"_37":391,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":392,"_79":393,"_81":394,"_83":24},"tree",[210,222,228,231,232,233,234,235,236],"files",[210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236],"counts",{"_200":61,"_201":148,"_202":61,"_203":204,"_205":206},"contents",[125,126,127,128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":194,"_31":195,"_29":196,"_137":-5,"_40":41,"_39":197,"_139":57,"_37":198,"_13":61,"_33":186,"_35":-5,"_23":24,"_141":-5,"_26":199},{"_42":188,"_31":189,"_29":190,"_137":-5,"_40":41,"_39":191,"_139":57,"_37":192,"_13":61,"_33":186,"_35":-5,"_23":24,"_141":-5,"_26":193},{"_42":181,"_31":182,"_29":183,"_137":-5,"_40":41,"_39":184,"_139":57,"_37":185,"_13":61,"_33":186,"_35":-5,"_23":24,"_141":-5,"_26":187},{"_42":174,"_31":175,"_29":176,"_137":-5,"_40":41,"_39":177,"_139":57,"_37":178,"_13":61,"_33":34,"_35":179,"_23":24,"_141":-5,"_26":180},{"_42":167,"_31":168,"_29":55,"_137":-5,"_40":41,"_39":169,"_139":57,"_37":170,"_13":61,"_33":171,"_35":172,"_23":24,"_141":-5,"_26":173},{"_42":159,"_31":160,"_29":161,"_137":-5,"_40":41,"_39":162,"_139":57,"_37":163,"_13":61,"_33":164,"_35":165,"_23":24,"_141":-5,"_26":166},{"_42":151,"_31":152,"_29":153,"_137":-5,"_40":41,"_39":154,"_139":57,"_37":155,"_13":61,"_33":156,"_35":157,"_23":24,"_141":-5,"_26":158},{"_42":143,"_31":144,"_29":145,"_137":-5,"_40":41,"_39":146,"_139":57,"_37":147,"_13":148,"_33":20,"_35":149,"_23":24,"_141":-5,"_26":150},{"_42":134,"_31":135,"_29":136,"_137":-5,"_40":41,"_39":138,"_139":57,"_37":140,"_13":61,"_33":34,"_35":104,"_23":24,"_141":-5,"_26":142},"b767872c-3cb8-11f0-9e5d-9e149126039e","new-file-5453.tsx","b76787cc-3cb8-11f0-9e5d-9e149126039e","parentId",6,"latest",["D",1748542449711],"label",[135],"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",[144],"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}",[152],"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}",[160],"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}",[168],"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",[175],"532f31b8-3cba-11f0-b872-9e149126039e","shared","d1679996-877c-44a1-9d8e-b54e3dba81a5",8,["D",1748543140561],"directory",[182],"c18548fa-3cba-11f0-aa86-9e149126039e","frontend","b8367289-7745-4625-961a-e594774f7d4d",17,["D",1748543325673],[189],"630ab242-3cba-11f0-bbbe-9e149126039e","backend","b451bc98-fdf2-4a33-a9e6-5d661aed07bd",10,["D",1748543167164],[195],"pulls","branches","forks","envVars",{"_207":61,"_209":61},"connections",{"_207":61,"_208":61},"count","unfilledCount","emptyCount",{"_42":194,"_31":195,"_29":196,"_137":-5,"_40":41,"_39":197,"_139":57,"_37":388,"_13":61,"_33":186,"_35":-5,"_23":24,"_141":-5,"_238":389,"_26":390},{"_42":384,"_31":383,"_29":377,"_137":196,"_40":41,"_39":378,"_139":57,"_37":385,"_13":61,"_33":186,"_35":-5,"_23":24,"_141":-5,"_238":386,"_26":387},{"_42":375,"_31":257,"_29":376,"_137":377,"_40":41,"_39":378,"_139":57,"_37":379,"_13":61,"_33":34,"_35":380,"_23":24,"_141":-5,"_238":381,"_26":382},{"_42":371,"_31":363,"_29":357,"_137":196,"_40":41,"_39":197,"_139":57,"_37":372,"_13":61,"_33":186,"_35":-5,"_23":24,"_141":-5,"_238":373,"_26":374},{"_42":364,"_31":365,"_29":366,"_137":357,"_40":41,"_39":197,"_139":57,"_37":367,"_13":61,"_33":34,"_35":368,"_23":24,"_141":-5,"_238":369,"_26":370},{"_42":354,"_31":355,"_29":356,"_137":357,"_40":41,"_39":358,"_139":57,"_37":359,"_13":61,"_33":34,"_35":360,"_23":24,"_141":-5,"_238":361,"_26":362},{"_42":350,"_31":341,"_29":335,"_137":196,"_40":41,"_39":345,"_139":57,"_37":351,"_13":61,"_33":186,"_35":-5,"_23":24,"_141":-5,"_238":352,"_26":353},{"_42":342,"_31":343,"_29":344,"_137":335,"_40":41,"_39":345,"_139":57,"_37":346,"_13":61,"_33":34,"_35":347,"_23":24,"_141":-5,"_238":348,"_26":349},{"_42":332,"_31":333,"_29":334,"_137":335,"_40":41,"_39":336,"_139":57,"_37":337,"_13":61,"_33":34,"_35":338,"_23":24,"_141":-5,"_238":339,"_26":340},{"_42":328,"_31":327,"_29":321,"_137":196,"_40":41,"_39":322,"_139":57,"_37":329,"_13":61,"_33":186,"_35":-5,"_23":24,"_141":-5,"_238":330,"_26":331},{"_42":318,"_31":319,"_29":320,"_137":321,"_40":41,"_39":322,"_139":57,"_37":323,"_13":61,"_33":34,"_35":324,"_23":24,"_141":-5,"_238":325,"_26":326},{"_42":310,"_31":311,"_29":312,"_137":196,"_40":41,"_39":313,"_139":57,"_37":314,"_13":61,"_33":34,"_35":315,"_23":24,"_141":-5,"_238":316,"_26":317},{"_42":188,"_31":189,"_29":190,"_137":-5,"_40":41,"_39":191,"_139":57,"_37":307,"_13":61,"_33":186,"_35":-5,"_23":24,"_141":-5,"_238":308,"_26":309},{"_42":303,"_31":294,"_29":290,"_137":190,"_40":41,"_39":298,"_139":57,"_37":304,"_13":61,"_33":186,"_35":-5,"_23":24,"_141":-5,"_238":305,"_26":306},{"_42":295,"_31":296,"_29":297,"_137":290,"_40":41,"_39":298,"_139":57,"_37":299,"_13":61,"_33":34,"_35":300,"_23":24,"_141":-5,"_238":301,"_26":302},{"_42":289,"_31":32,"_29":30,"_137":290,"_40":41,"_39":14,"_139":57,"_37":291,"_13":61,"_33":34,"_35":36,"_23":24,"_141":-5,"_238":292,"_26":293},{"_42":282,"_31":283,"_29":284,"_137":190,"_40":41,"_39":191,"_139":57,"_37":285,"_13":61,"_33":20,"_35":286,"_23":24,"_141":-5,"_238":287,"_26":288},{"_42":274,"_31":275,"_29":276,"_137":190,"_40":41,"_39":277,"_139":57,"_37":278,"_13":61,"_33":34,"_35":279,"_23":24,"_141":-5,"_238":280,"_26":281},{"_42":181,"_31":182,"_29":183,"_137":-5,"_40":41,"_39":184,"_139":57,"_37":271,"_13":61,"_33":186,"_35":-5,"_23":24,"_141":-5,"_238":272,"_26":273},{"_42":264,"_31":265,"_29":266,"_137":183,"_40":41,"_39":184,"_139":57,"_37":267,"_13":61,"_33":34,"_35":268,"_23":24,"_141":-5,"_238":269,"_26":270},{"_42":256,"_31":257,"_29":258,"_137":183,"_40":41,"_39":259,"_139":57,"_37":260,"_13":61,"_33":34,"_35":261,"_23":24,"_141":-5,"_238":262,"_26":263},{"_42":174,"_31":175,"_29":176,"_137":-5,"_40":41,"_39":177,"_139":57,"_37":253,"_13":61,"_33":34,"_35":179,"_23":24,"_141":-5,"_238":254,"_26":255},{"_42":167,"_31":168,"_29":55,"_137":-5,"_40":41,"_39":169,"_139":57,"_37":250,"_13":61,"_33":171,"_35":172,"_23":24,"_141":-5,"_238":251,"_26":252},{"_42":159,"_31":160,"_29":161,"_137":-5,"_40":41,"_39":162,"_139":57,"_37":247,"_13":61,"_33":164,"_35":165,"_23":24,"_141":-5,"_238":248,"_26":249},{"_42":151,"_31":152,"_29":153,"_137":-5,"_40":41,"_39":154,"_139":57,"_37":244,"_13":61,"_33":156,"_35":157,"_23":24,"_141":-5,"_238":245,"_26":246},{"_42":143,"_31":144,"_29":145,"_137":-5,"_40":41,"_39":146,"_139":57,"_37":241,"_13":148,"_33":20,"_35":149,"_23":24,"_141":-5,"_238":242,"_26":243},{"_42":134,"_31":135,"_29":136,"_137":-5,"_40":41,"_39":138,"_139":57,"_37":237,"_13":61,"_33":34,"_35":104,"_23":24,"_141":-5,"_238":239,"_26":240},["D",1748542449711],"children",[],[135],["D",1748543129866],[],[144],["D",1748542306158],[],[152],["D",1748542306141],[],[160],["D",1748542306129],[],[168],["D",1748542306117],[],[175],"5ac9717c-3cba-11f0-a693-9e149126039e","utils.ts","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}",[],[182,257],"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};",[],[182,265],["D",1748543140561],[229,230],[182],"c50a28c4-3cba-11f0-b846-9e149126039e","index.tsx","c50a2964-3cba-11f0-b846-9e149126039e",18,["D",1748543331580],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById('root')!);\nroot.render();",[],[189,275],"c185260e-3cba-11f0-aa86-9e149126039e","index.html","c18526b8-3cba-11f0-aa86-9e149126039e",["D",1748543325673],"\n\n\n \n \n AI Media Recognition Platform\n \n \n 🤖\">\n \n\n\n

\n \n \n\n",[],[189,283],"de59bd12-3cba-11f0-8179-9e149126039e","420348fe-490a-49ac-adf7-fdcd5f2e2f5e",["D",1748543374044],[],[189,294,32],"components","cdb7d958-3cba-11f0-b7dd-9e149126039e","App.tsx","cdb7da34-3cba-11f0-b7dd-9e149126039e",19,["D",1748543346137],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport AuthComponent from \"./AuthComponent.tsx\";\nimport Dashboard from \"./Dashboard.tsx\";\nimport { AuthService } from \"../services/AuthService.ts\";\nimport type { User } from \"../../shared/types.ts\";\n\nexport default function App() {\n const [user, setUser] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n useEffect(() => {\n checkAuthStatus();\n }, []);\n\n const checkAuthStatus = async () => {\n try {\n const token = localStorage.getItem('auth_token');\n if (token) {\n const response = await AuthService.getCurrentUser();\n if (response.success && response.user) {\n setUser(response.user);\n } else {\n localStorage.removeItem('auth_token');\n }\n }\n } catch (error) {\n console.error('Auth check failed:', error);\n localStorage.removeItem('auth_token');\n } finally {\n setLoading(false);\n }\n };\n\n const handleLogin = (userData: User, token: string) => {\n setUser(userData);\n localStorage.setItem('auth_token', token);\n setError(null);\n };\n\n const handleLogout = async () => {\n try {\n await AuthService.logout();\n } catch (error) {\n console.error('Logout error:', error);\n } finally {\n setUser(null);\n localStorage.removeItem('auth_token');\n }\n };\n\n if (loading) {\n return (\n

\n );\n }\n\n if (!user) {\n return (\n

\n \n

\n );\n }\n\n return (\n

\n \n

\n );\n}",[],[189,294,296],"cdb7e4de-3cba-11f0-b7dd-9e149126039e",["D",1748543346137],[224,225],[189,294],["D",1748543325673],[223,226,227],[189],"b77b18a8-3cba-11f0-8e85-9e149126039e","index.ts","b77b1966-3cba-11f0-8e85-9e149126039e",16,["D",1748543308833],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { initializeDatabase, cleanupExpiredSessions } from \"./database/migrations.ts\";\nimport authRoutes from \"./routes/auth.ts\";\nimport mediaRoutes from \"./routes/media.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nawait initializeDatabase();\n\n// Clean up expired sessions periodically\nsetInterval(cleanupExpiredSessions, 60 * 60 * 1000); // Every hour\n\n// Health check endpoint\napp.get('/health', (c) => {\n return c.json({ \n status: 'healthy', \n timestamp: new Date().toISOString(),\n version: '1.0.0'\n });\n});\n\n// API routes\napp.route('/api/auth', authRoutes);\napp.route('/api/media', mediaRoutes);\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main application\napp.get(\"/\", async c => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial configuration\n const config = {\n apiUrl: '/api',\n maxFileSize: 50 * 1024 * 1024, // 50MB\n supportedFormats: {\n image: ['image/jpeg', 'image/png', 'image/webp'],\n video: ['video/mp4', 'video/webm'],\n audio: ['audio/mp3', 'audio/wav', 'audio/webm']\n }\n };\n \n const configScript = ``;\n \n html = html.replace(\"\", `${configScript}`);\n return c.html(html);\n } catch (error) {\n console.error('Error serving main page:', error);\n return c.html(`\n \n \n \n AI Media Recognition Platform\n \n \n \n \n

AI Media Recognition Platform

Loading application...

Error: ${error.message}

\n \n \n `);\n }\n});\n\n// Catch-all route for SPA routing\napp.get(\"*\", async c => {\n // For any other route, serve the main app (SPA routing)\n return app.fetch(new Request(new URL(\"/\", c.req.url)));\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[195,311],"8b012448-3cba-11f0-8bcc-9e149126039e","ai-analysis.ts","8b012510-3cba-11f0-8bcc-9e149126039e","25c031c1-741e-47c3-9312-45c5ab04aaf1",13,["D",1748543234212],"import { OpenAI } from \"https://esm.town/v/std/openai\";\nimport type { AnalysisResponse } from \"../../shared/types.ts\";\n\nconst openai = new OpenAI();\n\nexport async function analyzeImage(imageData: string, fileName: string): Promise {\n try {\n // Remove data URL prefix if present\n const base64Data = imageData.replace(/^data:image\\/[a-z]+;base64,/, '');\n \n const response = await openai.chat.completions.create({\n model: \"gpt-4o-mini\",\n messages: [\n {\n role: \"user\",\n content: [\n {\n type: \"text\",\n text: `Analyze this image and provide:\n1. A detailed description of what you see\n2. List of objects/subjects in the image\n3. Emotions or mood if people are present\n4. Any text visible in the image\n5. Tags for categorization\n6. Confidence level (0-1)\n\nFormat your response as JSON with the following structure:\n{\n \"description\": \"detailed description\",\n \"objects\": [\"object1\", \"object2\"],\n \"emotions\": [\"emotion1\", \"emotion2\"],\n \"text\": \"any visible text\",\n \"tags\": [\"tag1\", \"tag2\", \"tag3\"],\n \"confidence\": 0.95\n}`\n },\n {\n type: \"image_url\",\n image_url: {\n url: `data:image/jpeg;base64,${base64Data}`\n }\n }\n ]\n }\n ],\n max_tokens: 1000\n });\n\n const content = response.choices[0]?.message?.content;\n if (!content) {\n throw new Error('No response from AI model');\n }\n\n // Parse the JSON response\n const analysis = JSON.parse(content);\n \n return {\n success: true,\n analysis: {\n description: analysis.description,\n tags: analysis.tags || [],\n confidence: analysis.confidence || 0.8,\n objects: analysis.objects || [],\n emotions: analysis.emotions || [],\n text: analysis.text || ''\n }\n };\n } catch (error) {\n console.error('Image analysis error:', error);\n return {\n success: false,\n message: `Failed to analyze image: ${error.message}`\n };\n }\n}\n\nexport async function analyzeAudio(audioData: string, fileName: string): Promise {\n try {\n // For audio analysis, we'll use Whisper for transcription and then analyze the text\n // Note: This is a simplified approach. In production, you might want to use specialized audio analysis APIs\n \n // Convert base64 to blob for Whisper API\n const base64Data = audioData.replace(/^data:audio\\/[^;]+;base64,/, '');\n const audioBuffer = Uint8Array.from(atob(base64Data), c => c.charCodeAt(0));\n const audioBlob = new Blob([audioBuffer], { type: 'audio/wav' });\n \n // Create a File object for the API\n const audioFile = new File([audioBlob], fileName, { type: 'audio/wav' });\n \n const transcription = await openai.audio.transcriptions.create({\n file: audioFile,\n model: \"whisper-1\",\n });\n\n const text = transcription.text;\n \n // Analyze the transcribed text\n const textAnalysis = await openai.chat.completions.create({\n model: \"gpt-4o-mini\",\n messages: [\n {\n role: \"user\",\n content: `Analyze this audio transcription and provide:\n1. A summary of the content\n2. Key topics discussed\n3. Emotional tone\n4. Language detected\n5. Tags for categorization\n6. Confidence level (0-1)\n\nTranscription: \"${text}\"\n\nFormat your response as JSON:\n{\n \"description\": \"summary of audio content\",\n \"topics\": [\"topic1\", \"topic2\"],\n \"emotions\": [\"emotion1\", \"emotion2\"],\n \"language\": \"detected language\",\n \"tags\": [\"tag1\", \"tag2\", \"tag3\"],\n \"confidence\": 0.95\n}`\n }\n ],\n max_tokens: 800\n });\n\n const analysisContent = textAnalysis.choices[0]?.message?.content;\n if (!analysisContent) {\n throw new Error('No response from AI model');\n }\n\n const analysis = JSON.parse(analysisContent);\n \n return {\n success: true,\n analysis: {\n description: analysis.description,\n tags: analysis.tags || [],\n confidence: analysis.confidence || 0.8,\n objects: analysis.topics || [],\n emotions: analysis.emotions || [],\n text: text\n }\n };\n } catch (error) {\n console.error('Audio analysis error:', error);\n return {\n success: false,\n message: `Failed to analyze audio: ${error.message}`\n };\n }\n}\n\nexport async function analyzeVideo(videoData: string, fileName: string): Promise {\n try {\n // For video analysis, we'll extract a frame and analyze it as an image\n // In a production environment, you might want to extract multiple frames or use specialized video analysis\n \n // This is a simplified approach - we'll treat the video thumbnail as an image\n // In practice, you'd need to extract frames from the video\n \n const response = await openai.chat.completions.create({\n model: \"gpt-4o-mini\",\n messages: [\n {\n role: \"user\",\n content: `Analyze this video file and provide:\n1. A description of what the video likely contains based on the filename: \"${fileName}\"\n2. Estimated content type (educational, entertainment, documentary, etc.)\n3. Suggested tags for categorization\n4. Confidence level (0-1)\n\nFormat your response as JSON:\n{\n \"description\": \"estimated video content description\",\n \"contentType\": \"content type\",\n \"tags\": [\"tag1\", \"tag2\", \"tag3\"],\n \"confidence\": 0.7\n}`\n }\n ],\n max_tokens: 500\n });\n\n const content = response.choices[0]?.message?.content;\n if (!content) {\n throw new Error('No response from AI model');\n }\n\n const analysis = JSON.parse(content);\n \n return {\n success: true,\n analysis: {\n description: analysis.description,\n tags: analysis.tags || [],\n confidence: analysis.confidence || 0.6, // Lower confidence for filename-based analysis\n objects: [analysis.contentType] || [],\n emotions: [],\n text: ''\n }\n };\n } catch (error) {\n console.error('Video analysis error:', error);\n return {\n success: false,\n message: `Failed to analyze video: ${error.message}`\n };\n }\n}\n\nexport async function generateSearchSuggestions(query: string): Promise {\n try {\n const response = await openai.chat.completions.create({\n model: \"gpt-4o-mini\",\n messages: [\n {\n role: \"user\",\n content: `Generate 5 related search suggestions for the query: \"${query}\"\n \n Focus on:\n - Similar concepts\n - Related objects or subjects\n - Alternative descriptions\n - Broader or narrower terms\n \n Return as a JSON array of strings:\n [\"suggestion1\", \"suggestion2\", \"suggestion3\", \"suggestion4\", \"suggestion5\"]`\n }\n ],\n max_tokens: 200\n });\n\n const content = response.choices[0]?.message?.content;\n if (!content) {\n return [];\n }\n\n return JSON.parse(content);\n } catch (error) {\n console.error('Search suggestions error:', error);\n return [];\n }\n}",[],[195,327,319],"services","8b014a68-3cba-11f0-8bcc-9e149126039e",["D",1748543234212],[220],[195,327],"ad0f3fc0-3cba-11f0-93f2-9e149126039e","media.ts","ad0f406a-3cba-11f0-93f2-9e149126039e","8ff4979e-279f-4940-9f37-2aa3515ba625",15,["D",1748543291349],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { requireAuth, getCurrentUser } from \"../auth/utils.ts\";\nimport { \n createMediaAnalysis, \n getUserMediaAnalyses, \n searchMediaAnalyses,\n createSearchHistory,\n deleteMediaAnalysis \n} from \"../database/queries.ts\";\nimport { \n analyzeImage, \n analyzeAudio, \n analyzeVideo,\n generateSearchSuggestions \n} from \"../services/ai-analysis.ts\";\nimport { \n sanitizeFileName, \n extractFileExtension, \n isValidMediaType \n} from \"../../shared/utils.ts\";\nimport { MEDIA_CONSTRAINTS } from \"../../shared/types.ts\";\nimport type { AnalysisRequest, AnalysisResponse, SearchRequest } from \"../../shared/types.ts\";\n\nconst media = new Hono();\n\n// Analyze uploaded media\nmedia.post('/analyze', requireAuth, async (c) => {\n try {\n const user = getCurrentUser(c);\n const { mediaType, fileName, fileData }: AnalysisRequest = await c.req.json();\n\n // Validate input\n if (!mediaType || !fileName || !fileData) {\n return c.json({ \n success: false, \n message: 'Media type, file name, and file data are required' \n }, 400);\n }\n\n if (!['image', 'video', 'audio'].includes(mediaType)) {\n return c.json({ \n success: false, \n message: 'Invalid media type' \n }, 400);\n }\n\n // Validate file size (rough estimate from base64)\n const estimatedSize = (fileData.length * 3) / 4;\n if (estimatedSize > MEDIA_CONSTRAINTS.maxFileSize) {\n return c.json({ \n success: false, \n message: `File too large. Maximum size is ${MEDIA_CONSTRAINTS.maxFileSize / (1024 * 1024)}MB` \n }, 400);\n }\n\n // Sanitize filename\n const cleanFileName = sanitizeFileName(fileName);\n \n // Store file in blob storage\n const blobKey = `media_${user.id}_${Date.now()}_${cleanFileName}`;\n await blob.set(blobKey, fileData);\n\n // Analyze based on media type\n let analysisResult: AnalysisResponse;\n \n switch (mediaType) {\n case 'image':\n analysisResult = await analyzeImage(fileData, cleanFileName);\n break;\n case 'audio':\n analysisResult = await analyzeAudio(fileData, cleanFileName);\n break;\n case 'video':\n analysisResult = await analyzeVideo(fileData, cleanFileName);\n break;\n default:\n return c.json({ \n success: false, \n message: 'Unsupported media type' \n }, 400);\n }\n\n if (!analysisResult.success) {\n // Clean up blob if analysis failed\n await blob.delete(blobKey);\n return c.json(analysisResult, 500);\n }\n\n // Save analysis to database\n const mediaAnalysis = await createMediaAnalysis(\n user.id,\n mediaType,\n cleanFileName,\n estimatedSize,\n blobKey,\n analysisResult.analysis!.description,\n analysisResult.analysis!.tags,\n analysisResult.analysis!.confidence\n );\n\n return c.json({\n success: true,\n analysis: analysisResult.analysis,\n mediaId: mediaAnalysis.id,\n message: 'Media analyzed successfully'\n });\n\n } catch (error) {\n console.error('Media analysis error:', error);\n return c.json({ \n success: false, \n message: 'Failed to analyze media' \n }, 500);\n }\n});\n\n// Search media analyses\nmedia.post('/search', requireAuth, async (c) => {\n try {\n const user = getCurrentUser(c);\n const { query, mediaType, limit = 20 }: SearchRequest = await c.req.json();\n\n if (!query || query.trim().length === 0) {\n return c.json({ \n success: false, \n message: 'Search query is required' \n }, 400);\n }\n\n // Perform search\n const results = await searchMediaAnalyses(\n user.id, \n query.trim(), \n mediaType, \n Math.min(limit, 50) // Cap at 50 results\n );\n\n // Save search to history\n await createSearchHistory(user.id, query.trim(), mediaType || null, results.length);\n\n // Generate search suggestions\n const suggestions = await generateSearchSuggestions(query);\n\n return c.json({\n success: true,\n results,\n suggestions,\n message: `Found ${results.length} results`\n });\n\n } catch (error) {\n console.error('Search error:', error);\n return c.json({ \n success: false, \n message: 'Search failed' \n }, 500);\n }\n});\n\n// Get user's media history\nmedia.get('/history', requireAuth, async (c) => {\n try {\n const user = getCurrentUser(c);\n const limit = parseInt(c.req.query('limit') || '50');\n \n const analyses = await getUserMediaAnalyses(user.id, Math.min(limit, 100));\n \n return c.json({\n success: true,\n analyses,\n message: `Retrieved ${analyses.length} analyses`\n });\n\n } catch (error) {\n console.error('History error:', error);\n return c.json({ \n success: false, \n message: 'Failed to retrieve history' \n }, 500);\n }\n});\n\n// Delete media analysis\nmedia.delete('/:id', requireAuth, async (c) => {\n try {\n const user = getCurrentUser(c);\n const id = parseInt(c.req.param('id'));\n\n if (isNaN(id)) {\n return c.json({ \n success: false, \n message: 'Invalid media ID' \n }, 400);\n }\n\n const deleted = await deleteMediaAnalysis(id, user.id);\n \n if (!deleted) {\n return c.json({ \n success: false, \n message: 'Media analysis not found or access denied' \n }, 404);\n }\n\n return c.json({\n success: true,\n message: 'Media analysis deleted successfully'\n });\n\n } catch (error) {\n console.error('Delete error:', error);\n return c.json({ \n success: false, \n message: 'Failed to delete media analysis' \n }, 500);\n }\n});\n\n// Get media file (for viewing)\nmedia.get('/file/:id', requireAuth, async (c) => {\n try {\n const user = getCurrentUser(c);\n const id = parseInt(c.req.param('id'));\n\n if (isNaN(id)) {\n return c.json({ \n success: false, \n message: 'Invalid media ID' \n }, 400);\n }\n\n // Get media analysis to verify ownership and get blob key\n const analysis = await getUserMediaAnalyses(user.id, 1000)\n .then(analyses => analyses.find(a => a.id === id));\n\n if (!analysis) {\n return c.json({ \n success: false, \n message: 'Media not found or access denied' \n }, 404);\n }\n\n // Get file from blob storage\n const fileData = await blob.get(analysis.blob_key);\n \n if (!fileData) {\n return c.json({ \n success: false, \n message: 'Media file not found in storage' \n }, 404);\n }\n\n // Determine content type\n const extension = extractFileExtension(analysis.file_name);\n let contentType = 'application/octet-stream';\n \n if (['jpg', 'jpeg'].includes(extension)) contentType = 'image/jpeg';\n else if (extension === 'png') contentType = 'image/png';\n else if (extension === 'webp') contentType = 'image/webp';\n else if (extension === 'mp4') contentType = 'video/mp4';\n else if (extension === 'webm') contentType = 'video/webm';\n else if (extension === 'mp3') contentType = 'audio/mpeg';\n else if (extension === 'wav') contentType = 'audio/wav';\n\n return new Response(fileData, {\n headers: {\n 'Content-Type': contentType,\n 'Content-Disposition': `inline; filename=\"${analysis.file_name}\"`\n }\n });\n\n } catch (error) {\n console.error('File retrieval error:', error);\n return c.json({ \n success: false, \n message: 'Failed to retrieve media file' \n }, 500);\n }\n});\n\nexport default media;",[],[195,341,333],"routes","98a5cb58-3cba-11f0-8962-9e149126039e","auth.ts","98a5cbf8-3cba-11f0-8962-9e149126039e",14,["D",1748543257101],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createUser, \n getUserByEmail, \n getUserByUsername, \n getUserPasswordHash,\n deleteUserSessions \n} from \"../database/queries.ts\";\nimport { \n hashPassword, \n verifyPassword, \n createUserSession, \n invalidateSession,\n requireAuth,\n getCurrentUser,\n getTokenFromRequest\n} from \"../auth/utils.ts\";\nimport { validateEmail, validatePassword } from \"../../shared/utils.ts\";\nimport type { AuthResponse } from \"../../shared/types.ts\";\n\nconst auth = new Hono();\n\n// Register new user\nauth.post('/signup', async (c) => {\n try {\n const { email, username, password } = await c.req.json();\n\n // Validate input\n if (!email || !username || !password) {\n return c.json({ \n success: false, \n message: 'Email, username, and password are required' \n }, 400);\n }\n\n if (!validateEmail(email)) {\n return c.json({ \n success: false, \n message: 'Invalid email format' \n }, 400);\n }\n\n const passwordValidation = validatePassword(password);\n if (!passwordValidation.valid) {\n return c.json({ \n success: false, \n message: passwordValidation.message \n }, 400);\n }\n\n // Check if user already exists\n const existingUserByEmail = await getUserByEmail(email);\n if (existingUserByEmail) {\n return c.json({ \n success: false, \n message: 'User with this email already exists' \n }, 409);\n }\n\n const existingUserByUsername = await getUserByUsername(username);\n if (existingUserByUsername) {\n return c.json({ \n success: false, \n message: 'Username already taken' \n }, 409);\n }\n\n // Create user\n const passwordHash = await hashPassword(password);\n const user = await createUser(email, username, passwordHash);\n const token = await createUserSession(user.id);\n\n const response: AuthResponse = {\n success: true,\n user,\n token,\n message: 'User created successfully'\n };\n\n return c.json(response, 201);\n } catch (error) {\n console.error('Signup error:', error);\n return c.json({ \n success: false, \n message: 'Internal server error' \n }, 500);\n }\n});\n\n// Login user\nauth.post('/login', async (c) => {\n try {\n const { email, password } = await c.req.json();\n\n if (!email || !password) {\n return c.json({ \n success: false, \n message: 'Email and password are required' \n }, 400);\n }\n\n // Get user and password hash\n const user = await getUserByEmail(email);\n if (!user) {\n return c.json({ \n success: false, \n message: 'Invalid email or password' \n }, 401);\n }\n\n const passwordHash = await getUserPasswordHash(email);\n if (!passwordHash) {\n return c.json({ \n success: false, \n message: 'Invalid email or password' \n }, 401);\n }\n\n // Verify password\n const isValidPassword = await verifyPassword(password, passwordHash);\n if (!isValidPassword) {\n return c.json({ \n success: false, \n message: 'Invalid email or password' \n }, 401);\n }\n\n // Create session\n const token = await createUserSession(user.id);\n\n const response: AuthResponse = {\n success: true,\n user,\n token,\n message: 'Login successful'\n };\n\n return c.json(response);\n } catch (error) {\n console.error('Login error:', error);\n return c.json({ \n success: false, \n message: 'Internal server error' \n }, 500);\n }\n});\n\n// Logout user\nauth.post('/logout', requireAuth, async (c) => {\n try {\n const token = getTokenFromRequest(c);\n if (token) {\n await invalidateSession(token);\n }\n\n return c.json({ \n success: true, \n message: 'Logout successful' \n });\n } catch (error) {\n console.error('Logout error:', error);\n return c.json({ \n success: false, \n message: 'Internal server error' \n }, 500);\n }\n});\n\n// Get current user\nauth.get('/me', requireAuth, async (c) => {\n try {\n const user = getCurrentUser(c);\n return c.json({ \n success: true, \n user \n });\n } catch (error) {\n console.error('Get user error:', error);\n return c.json({ \n success: false, \n message: 'Internal server error' \n }, 500);\n }\n});\n\n// Logout from all devices\nauth.post('/logout-all', requireAuth, async (c) => {\n try {\n const user = getCurrentUser(c);\n await deleteUserSessions(user.id);\n\n return c.json({ \n success: true, \n message: 'Logged out from all devices' \n });\n } catch (error) {\n console.error('Logout all error:', error);\n return c.json({ \n success: false, \n message: 'Internal server error' \n }, 500);\n }\n});\n\nexport default auth;",[],[195,341,343],"98a5d85a-3cba-11f0-8962-9e149126039e",["D",1748543257101],[217,218],[195,341],"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}",[],[195,363,355],"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}",[],[195,363,365],"630ab3dc-3cba-11f0-bbbe-9e149126039e",["D",1748543167164],[214,215],[195,363],"79666162-3cba-11f0-a622-9e149126039e","79666202-3cba-11f0-a622-9e149126039e","4a597fca-4fe3-4edc-9b5a-2d40ac8f5452",12,["D",1748543204677],"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}",[],[195,383,257],"auth","796685e8-3cba-11f0-a622-9e149126039e",["D",1748543204677],[212],[195,383],["D",1748543167164],[211,213,216,219,221],[195],["D",1748542306097],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":428,"_429":430,"_431":432,"_433":24,"_434":24,"_435":24,"_436":57,"_437":-5,"_438":-7,"_439":-7,"_440":61,"_441":24,"_442":24,"_443":-5,"_444":24,"_445":24,"_446":24,"_447":-5},"ENV",{"_399":400,"_401":402,"_403":85,"_404":405,"_406":407,"_408":409,"_410":411,"_412":413,"_414":415,"_416":417,"_418":419,"_420":421,"_422":423,"_424":425,"_426":427},"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 · v20