[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_324":325,"_326":327},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":26,"_118":119,"_120":24,"_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",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":26,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":24,"_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":26},"version",44,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_23":26},"previous","deleted",true,"deletedHere",false,"path","backend/routes/auth.ts","latestPath","fileId","c6f300d0-3a98-11f0-ad28-9e149126039e","name","auth.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createOrUpdateUser } from \"../database/queries.ts\";\nimport type { User, AuthResponse } from \"../../shared/types.ts\";\n\nconst auth = new Hono();\n\n// Simple JWT-like token creation (in production, use proper JWT library)\nasync function createToken(user: User): Promise {\n const payload = {\n email: user.email,\n name: user.name,\n exp: Date.now() + (24 * 60 * 60 * 1000), // 24 hours\n };\n \n // Simple base64 encoding (in production, use proper JWT with signing)\n return btoa(JSON.stringify(payload));\n}\n\nasync function verifyToken(token: string): Promise {\n try {\n const payload = JSON.parse(atob(token));\n \n // Check if token is expired\n if (Date.now() > payload.exp) {\n return null;\n }\n \n return {\n email: payload.email,\n name: payload.name,\n picture: '', // We'll get this from Google\n };\n } catch {\n return null;\n }\n}\n\n// Google OAuth callback\nauth.post(\"/google\", async (c) => {\n try {\n const body = await c.req.json();\n const { credential } = body;\n \n if (!credential) {\n return c.json({ error: \"No credential provided\" }, 400);\n }\n\n // Verify Google JWT token\n const response = await fetch(`https://oauth2.googleapis.com/tokeninfo?id_token=${credential}`);\n \n if (!response.ok) {\n return c.json({ error: \"Invalid Google token\" }, 401);\n }\n \n const googleUser = await response.json();\n \n const user: User = {\n email: googleUser.email,\n name: googleUser.name,\n picture: googleUser.picture,\n };\n \n // Save/update user in database\n await createOrUpdateUser(user);\n \n // Create our own token\n const token = await createToken(user);\n \n const authResponse: AuthResponse = {\n user,\n token,\n };\n \n return c.json(authResponse);\n } catch (error) {\n console.error(\"Google auth error:\", error);\n return c.json({ error: \"Authentication failed\" }, 500);\n }\n});\n\n// Verify token endpoint\nauth.post(\"/verify\", async (c) => {\n try {\n const body = await c.req.json();\n const { token } = body;\n \n if (!token) {\n return c.json({ error: \"No token provided\" }, 400);\n }\n \n const user = await verifyToken(token);\n \n if (!user) {\n return c.json({ error: \"Invalid or expired token\" }, 401);\n }\n \n return c.json({ user });\n } catch (error) {\n console.error(\"Token verification error:\", error);\n return c.json({ error: \"Token verification failed\" }, 500);\n }\n});\n\n// Middleware to verify authentication\nexport async function requireAuth(c: any, next: any) {\n const authHeader = c.req.header('Authorization');\n \n if (!authHeader || !authHeader.startsWith('Bearer ')) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n \n const token = authHeader.substring(7);\n const user = await verifyToken(token);\n \n if (!user) {\n return c.json({ error: \"Invalid or expired token\" }, 401);\n }\n \n // Add user to context\n c.set('user', user);\n await next();\n}\n\nexport default auth;","createdAt",["D",1748308829570],"branchVersion","branchId","8b629f4c-3a95-11f0-9eec-9e149126039e","id","8b627634-3a95-11f0-9eec-9e149126039e","NoteByPGC",["D",1748307441149],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","60fb6c16-2bdf-4286-9ac5-f4b9e6eb529c","pinnedFileId","ddc3fb64-3a95-11f0-877b-9e149126039e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","4a331ea8-f02b-42f1-b904-21c47f2b041c","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":54,"_99":100,"_101":26},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",81,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Itssongoku","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yck1oWTdNWlpJSmNPMWpWR1VSM3VvNEQyWXQifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":320,"_47":-5,"_48":26,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":24,"_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":321,"_79":322,"_81":323,"_83":26},"tree",[169,177,186,188],"files",[169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188],"counts",{"_159":61,"_160":136,"_161":61,"_162":163,"_164":165},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":153,"_32":154,"_30":155,"_132":-5,"_41":42,"_40":156,"_134":24,"_38":157,"_13":61,"_34":145,"_36":-5,"_23":26,"_138":-5,"_27":158},{"_43":147,"_32":148,"_30":149,"_132":-5,"_41":42,"_40":150,"_134":24,"_38":151,"_13":61,"_34":145,"_36":-5,"_23":26,"_138":-5,"_27":152},{"_43":140,"_32":141,"_30":142,"_132":-5,"_41":42,"_40":143,"_134":24,"_38":144,"_13":61,"_34":145,"_36":-5,"_23":26,"_138":-5,"_27":146},{"_43":129,"_32":130,"_30":131,"_132":-5,"_41":42,"_40":133,"_134":26,"_38":135,"_13":136,"_34":20,"_36":137,"_23":26,"_138":-5,"_27":139},"e6095dee-3a97-11f0-ad89-9e149126039e","README.md","c599a714-3a95-11f0-bca3-9e149126039e","parentId",39,"latest",["D",1748308452228],1,"# 3D Note Sharing Platform\n\nA beautiful note-sharing website with 3D graphics and smooth UI animations. Only the admin can create notes, but anyone can view shared notes with the proper links.\n\n## Features\n\n- **Admin-Only Creation**: Only the admin can create new notes using a protected password\n- **Public Viewing**: Anyone can view notes if they have the link\n- **Password Protection**: Optional password protection for private notes\n- **3D Graphics**: Smooth 3D animations and visual effects\n- **Responsive Design**: Works on all devices\n- **Smooth UI**: Beautiful animations and transitions\n- **Unique Links**: Each note gets its own shareable URL\n\n## How It Works\n\n1. **Creating Notes**: Only the admin (with password \"Random@2001\") can create new notes\n2. **Sharing Notes**: Each note gets a unique URL that can be shared with anyone\n3. **Viewing Notes**: Anyone with the link can view public notes\n4. **Password Protection**: Notes can optionally be password-protected for extra security\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main Hono server\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ └── routes/\n│ └── notes.ts # Note API endpoints\n├── frontend/\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # React app entry point\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ └── Scene3D.tsx # 3D graphics component\n│ └── style.css # Custom styles\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## API Endpoints\n\n- `POST /api/notes` - Create a new note (admin only, requires admin password)\n- `GET /api/notes/:id` - Get a note (public access)\n- `POST /api/notes/:id/verify` - Verify password for protected note (public access)\n\n## Tech Stack\n\n- **Backend**: Hono + SQLite\n- **Frontend**: React + Three.js for 3D graphics\n- **Styling**: TailwindCSS + custom CSS\n- **Database**: SQLite for note storage\n- **Authentication**: Simple password-based admin authentication","label",[130],"c7ed97aa-3a95-11f0-a8c1-9e149126039e","shared","e110a0ce-b293-4b74-9df8-b59d44107e15",2,["D",1748307542718],"directory",[141],"e9f8d6a2-3a95-11f0-96df-9e149126039e","frontend","a873d97a-82f8-46fa-b0eb-c4ca82e2331e",7,["D",1748307599836],[148],"cad8cf98-3a95-11f0-b008-9e149126039e","backend","8712dfa5-2aab-4afc-aafd-78a9ccf69905",3,["D",1748307547617],[154],"pulls","branches","forks","envVars",{"_166":61,"_168":61},"connections",{"_166":61,"_167":61},"count","unfilledCount","emptyCount",{"_43":153,"_32":154,"_30":155,"_132":-5,"_41":42,"_40":156,"_134":24,"_38":317,"_13":61,"_34":145,"_36":-5,"_23":26,"_138":-5,"_190":318,"_27":319},{"_43":313,"_32":304,"_30":298,"_132":155,"_41":42,"_40":156,"_134":24,"_38":314,"_13":61,"_34":145,"_36":-5,"_23":26,"_138":-5,"_190":315,"_27":316},{"_43":305,"_32":306,"_30":307,"_132":298,"_41":42,"_40":308,"_134":26,"_38":309,"_13":143,"_34":35,"_36":310,"_23":26,"_138":-5,"_190":311,"_27":312},{"_43":295,"_32":296,"_30":297,"_132":298,"_41":42,"_40":299,"_134":26,"_38":300,"_13":231,"_34":35,"_36":301,"_23":26,"_138":-5,"_190":302,"_27":303},{"_43":290,"_32":285,"_30":279,"_132":155,"_41":42,"_40":291,"_134":24,"_38":292,"_13":61,"_34":145,"_36":-5,"_23":26,"_138":-5,"_190":293,"_27":294},{"_43":286,"_32":33,"_30":31,"_132":279,"_41":42,"_40":14,"_134":26,"_38":287,"_13":61,"_34":35,"_36":37,"_23":26,"_138":-5,"_190":288,"_27":289},{"_43":276,"_32":277,"_30":278,"_132":279,"_41":42,"_40":280,"_134":26,"_38":281,"_13":143,"_34":35,"_36":282,"_23":26,"_138":-5,"_190":283,"_27":284},{"_43":268,"_32":269,"_30":56,"_132":155,"_41":42,"_40":270,"_134":26,"_38":271,"_13":156,"_34":272,"_36":273,"_23":26,"_138":-5,"_190":274,"_27":275},{"_43":147,"_32":148,"_30":149,"_132":-5,"_41":42,"_40":150,"_134":24,"_38":265,"_13":61,"_34":145,"_36":-5,"_23":26,"_138":-5,"_190":266,"_27":267},{"_43":261,"_32":236,"_30":230,"_132":149,"_41":42,"_40":231,"_134":24,"_38":262,"_13":61,"_34":145,"_36":-5,"_23":26,"_138":-5,"_190":263,"_27":264},{"_43":253,"_32":254,"_30":255,"_132":230,"_41":42,"_40":256,"_134":26,"_38":257,"_13":150,"_34":35,"_36":258,"_23":26,"_138":-5,"_190":259,"_27":260},{"_43":245,"_32":246,"_30":247,"_132":230,"_41":42,"_40":248,"_134":24,"_38":249,"_13":61,"_34":35,"_36":250,"_23":26,"_138":-5,"_190":251,"_27":252},{"_43":237,"_32":238,"_30":239,"_132":230,"_41":42,"_40":240,"_134":24,"_38":241,"_13":61,"_34":35,"_36":242,"_23":26,"_138":-5,"_190":243,"_27":244},{"_43":227,"_32":228,"_30":229,"_132":230,"_41":42,"_40":231,"_134":24,"_38":232,"_13":61,"_34":35,"_36":233,"_23":26,"_138":-5,"_190":234,"_27":235},{"_43":219,"_32":220,"_30":221,"_132":149,"_41":42,"_40":222,"_134":26,"_38":223,"_13":136,"_34":20,"_36":224,"_23":26,"_138":-5,"_190":225,"_27":226},{"_43":211,"_32":212,"_30":213,"_132":149,"_41":42,"_40":214,"_134":24,"_38":215,"_13":136,"_34":35,"_36":216,"_23":26,"_138":-5,"_190":217,"_27":218},{"_43":204,"_32":205,"_30":206,"_132":149,"_41":42,"_40":150,"_134":24,"_38":207,"_13":61,"_34":20,"_36":208,"_23":26,"_138":-5,"_190":209,"_27":210},{"_43":140,"_32":141,"_30":142,"_132":-5,"_41":42,"_40":143,"_134":24,"_38":201,"_13":61,"_34":145,"_36":-5,"_23":26,"_138":-5,"_190":202,"_27":203},{"_43":193,"_32":194,"_30":195,"_132":142,"_41":42,"_40":196,"_134":26,"_38":197,"_13":143,"_34":35,"_36":198,"_23":26,"_138":-5,"_190":199,"_27":200},{"_43":129,"_32":130,"_30":131,"_132":-5,"_41":42,"_40":133,"_134":26,"_38":189,"_13":136,"_34":20,"_36":137,"_23":26,"_138":-5,"_190":191,"_27":192},["D",1748308452228],"children",[],[130],"a62fa6fa-3a98-11f0-8785-9e149126039e","types.ts","c7ed76da-3a95-11f0-a8c1-9e149126039e",41,["D",1748308774601],"export interface Note {\n id: string;\n title: string;\n content: string;\n hasPassword: boolean;\n createdAt: string;\n expiresAt?: string;\n createdBy: string; // Google user email\n}\n\nexport interface CreateNoteRequest {\n title: string;\n content: string;\n password?: string;\n expiresIn?: number; // hours\n}\n\nexport interface VerifyPasswordRequest {\n password: string;\n}\n\nexport interface NoteResponse {\n note: Note;\n requiresPassword?: boolean;\n}\n\nexport interface User {\n email: string;\n name: string;\n picture: string;\n}\n\nexport interface AuthResponse {\n user: User;\n token: string;\n}",[],[141,194],["D",1748307542718],[187],[141],"e9f8b24e-3a95-11f0-96df-9e149126039e","style.css","e9f8b30c-3a95-11f0-96df-9e149126039e",["D",1748307599836],"/* Custom 3D and animation styles */\n@import url('https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&display=swap');\n\n* {\n margin: 0;\n padding: 0;\n box-sizing: border-box;\n}\n\nbody {\n font-family: 'Inter', sans-serif;\n background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);\n min-height: 100vh;\n overflow-x: hidden;\n}\n\n/* 3D Card Effects */\n.card-3d {\n transform-style: preserve-3d;\n transition: all 0.6s cubic-bezier(0.23, 1, 0.320, 1);\n perspective: 1000px;\n}\n\n.card-3d:hover {\n transform: rotateY(5deg) rotateX(5deg) translateZ(20px);\n}\n\n.card-inner {\n transform-style: preserve-3d;\n transition: transform 0.6s;\n}\n\n/* Floating Animation */\n@keyframes float {\n 0%, 100% { transform: translateY(0px) rotate(0deg); }\n 33% { transform: translateY(-10px) rotate(1deg); }\n 66% { transform: translateY(5px) rotate(-1deg); }\n}\n\n.floating {\n animation: float 6s ease-in-out infinite;\n}\n\n/* Glowing Effects */\n.glow {\n box-shadow: 0 0 20px rgba(255, 255, 255, 0.3);\n transition: box-shadow 0.3s ease;\n}\n\n.glow:hover {\n box-shadow: 0 0 30px rgba(255, 255, 255, 0.5);\n}\n\n/* Gradient Text */\n.gradient-text {\n background: linear-gradient(45deg, #667eea, #764ba2, #f093fb);\n background-size: 300% 300%;\n -webkit-background-clip: text;\n -webkit-text-fill-color: transparent;\n background-clip: text;\n animation: gradientShift 4s ease infinite;\n}\n\n@keyframes gradientShift {\n 0%, 100% { background-position: 0% 50%; }\n 50% { background-position: 100% 50%; }\n}\n\n/* Morphing Button */\n.morph-button {\n position: relative;\n overflow: hidden;\n transition: all 0.3s cubic-bezier(0.23, 1, 0.320, 1);\n}\n\n.morph-button::before {\n content: '';\n position: absolute;\n top: 0;\n left: -100%;\n width: 100%;\n height: 100%;\n background: linear-gradient(90deg, transparent, rgba(255,255,255,0.2), transparent);\n transition: left 0.5s;\n}\n\n.morph-button:hover::before {\n left: 100%;\n}\n\n.morph-button:hover {\n transform: translateY(-2px);\n box-shadow: 0 10px 25px rgba(0,0,0,0.2);\n}\n\n/* Particle Background */\n.particles {\n position: fixed;\n top: 0;\n left: 0;\n width: 100%;\n height: 100%;\n pointer-events: none;\n z-index: -1;\n}\n\n.particle {\n position: absolute;\n width: 4px;\n height: 4px;\n background: rgba(255, 255, 255, 0.5);\n border-radius: 50%;\n animation: particleFloat 20s linear infinite;\n}\n\n@keyframes particleFloat {\n 0% {\n transform: translateY(100vh) rotate(0deg);\n opacity: 0;\n }\n 10% {\n opacity: 1;\n }\n 90% {\n opacity: 1;\n }\n 100% {\n transform: translateY(-100vh) rotate(360deg);\n opacity: 0;\n }\n}\n\n/* Glass Morphism */\n.glass {\n background: rgba(255, 255, 255, 0.1);\n backdrop-filter: blur(10px);\n border: 1px solid rgba(255, 255, 255, 0.2);\n}\n\n/* Smooth Transitions */\n.smooth-transition {\n transition: all 0.3s cubic-bezier(0.4, 0, 0.2, 1);\n}\n\n/* Loading Animation */\n.loading-dots {\n display: inline-block;\n}\n\n.loading-dots::after {\n content: '';\n animation: dots 2s infinite;\n}\n\n@keyframes dots {\n 0%, 20% { content: ''; }\n 40% { content: '.'; }\n 60% { content: '..'; }\n 80%, 100% { content: '...'; }\n}\n\n/* Pulse Animation */\n@keyframes pulse {\n 0%, 100% { opacity: 1; }\n 50% { opacity: 0.5; }\n}\n\n.pulse {\n animation: pulse 2s infinite;\n}\n\n/* Custom Scrollbar */\n::-webkit-scrollbar {\n width: 8px;\n}\n\n::-webkit-scrollbar-track {\n background: rgba(255, 255, 255, 0.1);\n}\n\n::-webkit-scrollbar-thumb {\n background: rgba(255, 255, 255, 0.3);\n border-radius: 4px;\n}\n\n::-webkit-scrollbar-thumb:hover {\n background: rgba(255, 255, 255, 0.5);\n}",[],[148,205],"dc2b44aa-3a96-11f0-92d0-9e149126039e","index.tsx","2cce9b06-3a96-11f0-bd80-9e149126039e",19,["D",1748308006175],"/** @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 container = document.getElementById('root');\nif (container) {\n const root = createRoot(container);\n root.render();\n}",[],[148,212],"b41fb98c-3a96-11f0-9b1e-9e149126039e","index.html","35f05d50-3a96-11f0-8de3-9e149126039e",17,["D",1748307938991],"\n\n\n \n \n 3D Notes - Share Notes with Style\n \n \n \n 📝\">\n \n \n \n \n \n \n \n \n \n \n \n\n\n \n

\n \n

📝

3D Notes

\n\n \n \n\n",[],[148,220],"f658826c-3a95-11f0-9549-9e149126039e","Scene3D.tsx","f658833e-3a95-11f0-9549-9e149126039e","e2bb5107-7f87-44e6-82b0-54f6e9536421",8,["D",1748307620597],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useRef, useEffect } from 'https://esm.sh/react@18.2.0';\nimport * as THREE from 'https://esm.sh/three@0.158.0';\n\ninterface Scene3DProps {\n className?: string;\n}\n\nexport default function Scene3D({ className = '' }: Scene3DProps) {\n const mountRef = useRef(null);\n const sceneRef = useRef(null);\n const rendererRef = useRef(null);\n const animationIdRef = useRef(null);\n\n useEffect(() => {\n if (!mountRef.current) return;\n\n // Scene setup\n const scene = new THREE.Scene();\n const camera = new THREE.PerspectiveCamera(75, window.innerWidth / window.innerHeight, 0.1, 1000);\n const renderer = new THREE.WebGLRenderer({ alpha: true, antialias: true });\n \n renderer.setSize(window.innerWidth, window.innerHeight);\n renderer.setClearColor(0x000000, 0);\n mountRef.current.appendChild(renderer.domElement);\n\n sceneRef.current = scene;\n rendererRef.current = renderer;\n\n // Create floating geometric shapes\n const geometries = [\n new THREE.BoxGeometry(1, 1, 1),\n new THREE.SphereGeometry(0.7, 32, 32),\n new THREE.ConeGeometry(0.7, 1.5, 32),\n new THREE.TorusGeometry(0.7, 0.3, 16, 100),\n ];\n\n const materials = [\n new THREE.MeshPhongMaterial({ color: 0x667eea, transparent: true, opacity: 0.7 }),\n new THREE.MeshPhongMaterial({ color: 0x764ba2, transparent: true, opacity: 0.7 }),\n new THREE.MeshPhongMaterial({ color: 0xf093fb, transparent: true, opacity: 0.7 }),\n new THREE.MeshPhongMaterial({ color: 0x48c6ef, transparent: true, opacity: 0.7 }),\n ];\n\n const meshes: THREE.Mesh[] = [];\n\n // Create multiple floating objects\n for (let i = 0; i < 8; i++) {\n const geometry = geometries[i % geometries.length];\n const material = materials[i % materials.length];\n const mesh = new THREE.Mesh(geometry, material);\n \n // Random positioning\n mesh.position.x = (Math.random() - 0.5) * 20;\n mesh.position.y = (Math.random() - 0.5) * 20;\n mesh.position.z = (Math.random() - 0.5) * 20;\n \n // Random rotation\n mesh.rotation.x = Math.random() * Math.PI;\n mesh.rotation.y = Math.random() * Math.PI;\n \n scene.add(mesh);\n meshes.push(mesh);\n }\n\n // Lighting\n const ambientLight = new THREE.AmbientLight(0xffffff, 0.6);\n scene.add(ambientLight);\n\n const directionalLight = new THREE.DirectionalLight(0xffffff, 0.8);\n directionalLight.position.set(10, 10, 5);\n scene.add(directionalLight);\n\n camera.position.z = 15;\n\n // Animation loop\n const animate = () => {\n animationIdRef.current = requestAnimationFrame(animate);\n\n // Rotate and float objects\n meshes.forEach((mesh, index) => {\n mesh.rotation.x += 0.005 + index * 0.001;\n mesh.rotation.y += 0.005 + index * 0.001;\n mesh.position.y += Math.sin(Date.now() * 0.001 + index) * 0.01;\n });\n\n renderer.render(scene, camera);\n };\n\n animate();\n\n // Handle resize\n const handleResize = () => {\n if (!camera || !renderer) return;\n camera.aspect = window.innerWidth / window.innerHeight;\n camera.updateProjectionMatrix();\n renderer.setSize(window.innerWidth, window.innerHeight);\n };\n\n window.addEventListener('resize', handleResize);\n\n // Mouse interaction\n const handleMouseMove = (event: MouseEvent) => {\n const mouseX = (event.clientX / window.innerWidth) * 2 - 1;\n const mouseY = -(event.clientY / window.innerHeight) * 2 + 1;\n \n camera.position.x = mouseX * 2;\n camera.position.y = mouseY * 2;\n camera.lookAt(scene.position);\n };\n\n window.addEventListener('mousemove', handleMouseMove);\n\n // Cleanup\n return () => {\n window.removeEventListener('resize', handleResize);\n window.removeEventListener('mousemove', handleMouseMove);\n \n if (animationIdRef.current) {\n cancelAnimationFrame(animationIdRef.current);\n }\n \n if (mountRef.current && renderer.domElement) {\n mountRef.current.removeChild(renderer.domElement);\n }\n \n // Dispose of Three.js objects\n geometries.forEach(geo => geo.dispose());\n materials.forEach(mat => mat.dispose());\n renderer.dispose();\n };\n }, []);\n\n return

;\n}",[],[148,236,228],"components","18109796-3a96-11f0-9e99-9e149126039e","NoteView.tsx","18109868-3a96-11f0-9e99-9e149126039e",10,["D",1748307677170],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from 'https://esm.sh/react@18.2.0';\nimport type { Note, NoteResponse } from '../../shared/types.ts';\n\ninterface NoteViewProps {\n noteId: string;\n onBack: () => void;\n}\n\nexport default function NoteView({ noteId, onBack }: NoteViewProps) {\n const [note, setNote] = useState(null);\n const [requiresPassword, setRequiresPassword] = useState(false);\n const [password, setPassword] = useState('');\n const [isLoading, setIsLoading] = useState(true);\n const [isVerifying, setIsVerifying] = useState(false);\n const [error, setError] = useState('');\n\n useEffect(() => {\n fetchNote();\n }, [noteId]);\n\n const fetchNote = async () => {\n try {\n setIsLoading(true);\n setError('');\n \n const response = await fetch(`/api/notes/${noteId}`);\n \n if (!response.ok) {\n if (response.status === 404) {\n setError('Note not found or has expired');\n } else {\n setError('Failed to load note');\n }\n return;\n }\n\n const data: NoteResponse = await response.json();\n setNote(data.note);\n setRequiresPassword(!!data.requiresPassword);\n } catch (error) {\n console.error('Error fetching note:', error);\n setError('Failed to load note');\n } finally {\n setIsLoading(false);\n }\n };\n\n const verifyPassword = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!password.trim()) return;\n\n setIsVerifying(true);\n setError('');\n\n try {\n const response = await fetch(`/api/notes/${noteId}/verify`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ password: password.trim() }),\n });\n\n if (!response.ok) {\n if (response.status === 401) {\n setError('Incorrect password');\n } else {\n setError('Failed to verify password');\n }\n return;\n }\n\n const data: NoteResponse = await response.json();\n setNote(data.note);\n setRequiresPassword(false);\n setPassword('');\n } catch (error) {\n console.error('Error verifying password:', error);\n setError('Failed to verify password');\n } finally {\n setIsVerifying(false);\n }\n };\n\n const copyToClipboard = async () => {\n if (!note) return;\n \n try {\n await navigator.clipboard.writeText(note.content);\n // You could add a toast notification here\n alert('Note content copied to clipboard!');\n } catch (error) {\n console.error('Failed to copy to clipboard:', error);\n }\n };\n\n const shareNote = async () => {\n const url = window.location.href;\n \n if (navigator.share) {\n try {\n await navigator.share({\n title: note?.title || 'Shared Note',\n text: note?.title || 'Check out this note',\n url: url,\n });\n } catch (error) {\n // User cancelled sharing\n }\n } else {\n // Fallback to copying URL\n try {\n await navigator.clipboard.writeText(url);\n alert('Note URL copied to clipboard!');\n } catch (error) {\n console.error('Failed to copy URL:', error);\n }\n }\n };\n\n if (isLoading) {\n return (\n

Loading note...

\n );\n }\n\n if (error) {\n return (\n

⚠️ {error}

\n \n Go Back\n \n

\n );\n }\n\n if (requiresPassword) {\n return (\n

\n 🔒 Protected Note\n

This note is password protected

\n\n \n

\n );\n }\n\n if (!note) return null;\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleString();\n };\n\n return (\n

\n {note.title}\n

\n \n 📋\n \n \n 🔗\n \n \n ←\n \n

\n\n

\n 📅 Created: {formatDate(note.createdAt)}\n {note.hasPassword && 🔒 Password Protected}\n {note.expiresAt && (\n ⏰ Expires: {formatDate(note.expiresAt)}\n )}\n

\n\n

\n {note.content}\n

\n\n

\n \n Create Another Note\n \n

\n );\n}",[],[148,236,238],"05167bd8-3a96-11f0-aa9d-9e149126039e","NoteForm.tsx","05167c8c-3a96-11f0-aa9d-9e149126039e",9,["D",1748307645331],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from 'https://esm.sh/react@18.2.0';\nimport type { CreateNoteRequest } from '../../shared/types.ts';\n\ninterface NoteFormProps {\n onNoteCreated: (noteId: string) => void;\n}\n\nexport default function NoteForm({ onNoteCreated }: NoteFormProps) {\n const [title, setTitle] = useState('');\n const [content, setContent] = useState('');\n const [password, setPassword] = useState('');\n const [expiresIn, setExpiresIn] = useState(undefined);\n const [isLoading, setIsLoading] = useState(false);\n const [showAdvanced, setShowAdvanced] = useState(false);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!title.trim() || !content.trim()) return;\n\n setIsLoading(true);\n\n try {\n const noteData: CreateNoteRequest = {\n title: title.trim(),\n content: content.trim(),\n password: password.trim() || undefined,\n expiresIn: expiresIn || undefined,\n };\n\n const response = await fetch('/api/notes', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(noteData),\n });\n\n if (!response.ok) {\n throw new Error('Failed to create note');\n }\n\n const result = await response.json();\n onNoteCreated(result.id);\n \n // Reset form\n setTitle('');\n setContent('');\n setPassword('');\n setExpiresIn(undefined);\n setShowAdvanced(false);\n } catch (error) {\n console.error('Error creating note:', error);\n alert('Failed to create note. Please try again.');\n } finally {\n setIsLoading(false);\n }\n };\n\n return (\n

\n Create a New Note\n

\n \n

\n \n Title\n \n setTitle(e.target.value)}\n className=\"w-full px-4 py-3 rounded-lg bg-white/10 border border-white/20 text-white placeholder-white/60 focus:outline-none focus:ring-2 focus:ring-white/30 smooth-transition\"\n placeholder=\"Enter note title...\"\n required\n />\n

\n\n

\n \n Content\n \n setContent(e.target.value)}\n rows={6}\n className=\"w-full px-4 py-3 rounded-lg bg-white/10 border border-white/20 text-white placeholder-white/60 focus:outline-none focus:ring-2 focus:ring-white/30 smooth-transition resize-none\"\n placeholder=\"Write your note content here...\"\n required\n />\n

\n\n

\n setShowAdvanced(!showAdvanced)}\n className=\"text-white/80 hover:text-white smooth-transition flex items-center gap-2\"\n >\n {showAdvanced ? '▼' : '▶'}\n Advanced Options\n \n

\n\n {showAdvanced && (\n

\n \n Password (Optional)\n \n setPassword(e.target.value)}\n className=\"w-full px-4 py-3 rounded-lg bg-white/10 border border-white/20 text-white placeholder-white/60 focus:outline-none focus:ring-2 focus:ring-white/30 smooth-transition\"\n placeholder=\"Leave empty for public note\"\n />\n

\n Add a password to make this note private\n

\n\n

\n \n Auto-delete after (Optional)\n \n setExpiresIn(e.target.value ? parseInt(e.target.value) : undefined)}\n className=\"w-full px-4 py-3 rounded-lg bg-white/10 border border-white/20 text-white focus:outline-none focus:ring-2 focus:ring-white/30 smooth-transition\"\n >\n \n \n \n \n \n \n

\n )}\n\n \n {isLoading ? (\n Creating Note\n ) : (\n 'Create Note'\n )}\n \n \n

\n );\n}",[],[148,236,246],"cb0be0fc-3a97-11f0-9df5-9e149126039e","App.tsx","2976ac3c-3a96-11f0-92e9-9e149126039e",36,["D",1748308406944],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from 'https://esm.sh/react@18.2.0';\n\ntype AppState = 'home' | 'view-note' | 'note-created';\n\ninterface Note {\n id: string;\n title: string;\n content: string;\n hasPassword: boolean;\n createdAt: string;\n expiresAt?: string;\n}\n\nexport default function App() {\n const [appState, setAppState] = useState('home');\n const [currentNoteId, setCurrentNoteId] = useState('');\n const [currentNote, setCurrentNote] = useState(null);\n const [requiresPassword, setRequiresPassword] = useState(false);\n const [password, setPassword] = useState('');\n const [isLoading, setIsLoading] = useState(false);\n const [error, setError] = useState('');\n\n // Form states\n const [title, setTitle] = useState('');\n const [content, setContent] = useState('');\n const [notePassword, setNotePassword] = useState('');\n const [adminPassword, setAdminPassword] = useState('');\n\n useEffect(() => {\n // Check if we're on a note page\n const path = window.location.pathname;\n const noteMatch = path.match(/^\\/note\\/(.+)$/);\n \n if (noteMatch) {\n setCurrentNoteId(noteMatch[1]);\n setAppState('view-note');\n fetchNote(noteMatch[1]);\n }\n }, []);\n\n const fetchNote = async (noteId: string) => {\n setIsLoading(true);\n setError('');\n \n try {\n const response = await fetch(`/api/notes/${noteId}`);\n \n if (!response.ok) {\n if (response.status === 404) {\n setError('Note not found or has expired');\n } else {\n setError('Failed to load note');\n }\n return;\n }\n\n const data = await response.json();\n setCurrentNote(data.note);\n setRequiresPassword(!!data.requiresPassword);\n } catch (error) {\n console.error('Error fetching note:', error);\n setError('Failed to load note');\n } finally {\n setIsLoading(false);\n }\n };\n\n const createNote = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!title.trim() || !content.trim() || !adminPassword.trim()) return;\n\n setIsLoading(true);\n setError('');\n\n try {\n const noteData = {\n title: title.trim(),\n content: content.trim(),\n password: notePassword.trim() || undefined,\n adminPassword: adminPassword.trim(),\n };\n\n const response = await fetch('/api/notes', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(noteData),\n });\n\n if (!response.ok) {\n const errorData = await response.json();\n throw new Error(errorData.error || 'Failed to create note');\n }\n\n const result = await response.json();\n setCurrentNoteId(result.id);\n setAppState('note-created');\n \n // Update URL\n window.history.pushState({}, '', `/note/${result.id}`);\n \n // Reset form (but keep admin password for convenience)\n setTitle('');\n setContent('');\n setNotePassword('');\n // Keep adminPassword for convenience\n } catch (error) {\n console.error('Error creating note:', error);\n setError(error.message || 'Failed to create note. Please try again.');\n } finally {\n setIsLoading(false);\n }\n };\n\n const verifyPassword = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!password.trim()) return;\n\n setIsLoading(true);\n setError('');\n\n try {\n const response = await fetch(`/api/notes/${currentNoteId}/verify`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ password: password.trim() }),\n });\n\n if (!response.ok) {\n if (response.status === 401) {\n setError('Incorrect password');\n } else {\n setError('Failed to verify password');\n }\n return;\n }\n\n const data = await response.json();\n setCurrentNote(data.note);\n setRequiresPassword(false);\n setPassword('');\n } catch (error) {\n console.error('Error verifying password:', error);\n setError('Failed to verify password');\n } finally {\n setIsLoading(false);\n }\n };\n\n const goHome = () => {\n setAppState('home');\n setCurrentNoteId('');\n setCurrentNote(null);\n setRequiresPassword(false);\n setPassword('');\n setError('');\n setAdminPassword(''); // Clear admin password when going home\n window.history.pushState({}, '', '/');\n };\n\n const copyToClipboard = async (text: string) => {\n try {\n await navigator.clipboard.writeText(text);\n alert('Copied to clipboard!');\n } catch (error) {\n console.error('Failed to copy:', error);\n }\n };\n\n // Home page - Create note form\n if (appState === 'home') {\n return (\n

\n {/* Header */}\n

\n 📝 3D Notes\n

\n Share notes with style and security\n

\n\n {/* Create Note Form */}\n

\n Create a New Note\n

\n \n

\n \n Title\n \n setTitle(e.target.value)}\n className=\"w-full px-4 py-3 rounded-lg bg-white/10 border border-white/20 text-white placeholder-white/60 focus:outline-none focus:ring-2 focus:ring-white/30\"\n placeholder=\"Enter note title...\"\n required\n />\n

\n\n

\n \n Content\n \n setContent(e.target.value)}\n rows={6}\n className=\"w-full px-4 py-3 rounded-lg bg-white/10 border border-white/20 text-white placeholder-white/60 focus:outline-none focus:ring-2 focus:ring-white/30 resize-none\"\n placeholder=\"Write your note content here...\"\n required\n />\n

\n\n

\n \n Password (Optional)\n \n setNotePassword(e.target.value)}\n className=\"w-full px-4 py-3 rounded-lg bg-white/10 border border-white/20 text-white placeholder-white/60 focus:outline-none focus:ring-2 focus:ring-white/30\"\n placeholder=\"Leave empty for public note\"\n />\n

\n Add a password to make this note private\n

\n\n

\n \n Admin Password (Required) 🔐\n \n setAdminPassword(e.target.value)}\n className=\"w-full px-4 py-3 rounded-lg bg-white/10 border border-white/20 text-white placeholder-white/60 focus:outline-none focus:ring-2 focus:ring-white/30\"\n placeholder=\"Enter admin password to create notes\"\n required\n />\n

\n Only the admin can create new notes\n

\n\n {error && (\n

\n {error}\n

\n )}\n\n \n {isLoading ? 'Creating Note...' : 'Create Note'}\n \n \n

\n\n {/* Features */}\n

🔐

Admin Protected

Only the admin can create notes. Others can only view shared notes.

\n \n

🔒

Password Protection

Keep your notes private with optional password protection

\n \n

🔗

Unique Links

Each note gets its own unique shareable link

\n );\n }\n\n // Note created success page\n if (appState === 'note-created') {\n const noteUrl = `${window.location.origin}/note/${currentNoteId}`;\n \n return (\n

✅

\n Note Created Successfully!\n

\n Your note has been created and is ready to share.\n

\n \n

Share this URL:

\n \n copyToClipboard(noteUrl)}\n className=\"px-4 py-2 bg-white/20 text-white text-sm rounded morph-button\"\n >\n Copy\n \n

\n\n

\n {\n setAppState('view-note');\n fetchNote(currentNoteId);\n }}\n className=\"px-6 py-3 bg-gradient-to-r from-blue-500 to-purple-500 text-white font-semibold rounded-lg morph-button\"\n >\n View Note\n \n \n Create Another\n \n

\n );\n }\n\n // View note page\n if (appState === 'view-note') {\n if (isLoading) {\n return (\n

Loading note...

\n );\n }\n\n if (error) {\n return (\n

⚠️ {error}

\n \n Go Home\n \n

\n );\n }\n\n if (requiresPassword) {\n return (\n

\n 🔒 Protected Note\n

This note is password protected

\n\n \n

\n );\n }\n\n if (!currentNote) return null;\n\n return (\n

\n {currentNote.title}\n

\n copyToClipboard(currentNote.content)}\n className=\"p-3 bg-white/10 text-white rounded-lg morph-button hover:bg-white/20\"\n title=\"Copy content\"\n >\n 📋\n \n copyToClipboard(window.location.href)}\n className=\"p-3 bg-white/10 text-white rounded-lg morph-button hover:bg-white/20\"\n title=\"Copy link\"\n >\n 🔗\n \n \n 🏠\n \n

\n\n

\n 📅 Created: {new Date(currentNote.createdAt).toLocaleString()}\n {currentNote.hasPassword && 🔒 Password Protected}\n

\n\n

\n {currentNote.content}\n

\n\n

\n \n Create Another Note\n \n

\n );\n }\n\n return null;\n}",[],[148,236,254],"f658b606-3a95-11f0-9549-9e149126039e",["D",1748307620597],[179,180,181,182],[148,236],["D",1748307599836],[178,183,184,185],[148],"d35e6680-3a97-11f0-870b-9e149126039e","index.ts",37,["D",1748308420908],"http","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 { runMigrations, cleanupExpiredNotes } from \"./database/migrations.ts\";\nimport notes from \"./routes/notes.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\nawait runMigrations();\n\n// Cleanup expired notes periodically\nsetInterval(cleanupExpiredNotes, 60 * 60 * 1000); // Every hour\n\n// API routes\napp.route(\"/api/notes\", notes);\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 page\napp.get(\"/\", async c => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// Serve note pages\napp.get(\"/note/:id\", async c => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\nexport default app.fetch;",[],[154,269],"acdb6044-3a97-11f0-be6b-9e149126039e","notes.ts","d8a3ef4a-3a95-11f0-b008-9e149126039e","36c8c5e1-8777-48c6-8efa-355b1401dc97",30,["D",1748308356294],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createNote, getNoteById, verifyNotePassword } from \"../database/queries.ts\";\n\nconst notes = new Hono();\n\n// Admin password for creating notes\nconst ADMIN_PASSWORD = \"Random@2001\";\n\n// Create a new note (admin only)\nnotes.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n \n if (!body.title || !body.content) {\n return c.json({ error: \"Title and content are required\" }, 400);\n }\n\n // Check admin password\n if (!body.adminPassword || body.adminPassword !== ADMIN_PASSWORD) {\n return c.json({ error: \"Invalid admin password. Only the admin can create notes.\" }, 401);\n }\n\n // Remove admin password from the note data before saving\n const { adminPassword, ...noteData } = body;\n const noteId = await createNote(noteData);\n \n return c.json({ id: noteId, success: true });\n } catch (error) {\n console.error(\"Error creating note:\", error);\n return c.json({ error: \"Failed to create note\" }, 500);\n }\n});\n\n// Get a note by ID (public access)\nnotes.get(\"/:id\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n const note = await getNoteById(id);\n\n if (!note) {\n return c.json({ error: \"Note not found or expired\" }, 404);\n }\n\n if (note.hasPassword) {\n // Return note metadata without content for password-protected notes\n const response = {\n note: {\n ...note,\n content: \"\", // Don't send content for password-protected notes\n },\n requiresPassword: true,\n };\n return c.json(response);\n }\n\n // Return full note for public notes\n const response = { note };\n return c.json(response);\n } catch (error) {\n console.error(\"Error fetching note:\", error);\n return c.json({ error: \"Failed to fetch note\" }, 500);\n }\n});\n\n// Verify password and get note content (public access)\nnotes.post(\"/:id/verify\", async (c) => {\n try {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n\n if (!body.password) {\n return c.json({ error: \"Password is required\" }, 400);\n }\n\n const isValid = await verifyNotePassword(id, body.password);\n \n if (!isValid) {\n return c.json({ error: \"Invalid password\" }, 401);\n }\n\n const note = await getNoteById(id);\n if (!note) {\n return c.json({ error: \"Note not found or expired\" }, 404);\n }\n\n const response = { note };\n return c.json(response);\n } catch (error) {\n console.error(\"Error verifying password:\", error);\n return c.json({ error: \"Failed to verify password\" }, 500);\n }\n});\n\nexport default notes;",[],[154,285,277],"routes","c6f2fffe-3a98-11f0-ad28-9e149126039e",["D",1748308829570],[],[154,285,33],"d8a417b8-3a95-11f0-b008-9e149126039e",5,["D",1748307570760],[174,175],[154,285],"bcb28f82-3a98-11f0-8744-9e149126039e","queries.ts","d193894a-3a95-11f0-ad9a-9e149126039e","b4134992-6d40-484c-b6f0-f41d1fe662b6",43,["D",1748308812368],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME, USERS_TABLE } from \"./migrations.ts\";\nimport type { Note, CreateNoteRequest, User } from \"../../shared/types.ts\";\n\n// Simple hash function for passwords (in production, use bcrypt)\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password);\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}\n\nexport async function createOrUpdateUser(user: User): Promise {\n try {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${USERS_TABLE} (email, name, picture, last_login) \n VALUES (?, ?, ?, datetime('now'))`,\n [user.email, user.name, user.picture]\n );\n } catch (error) {\n console.error('Error in createOrUpdateUser:', error);\n throw error;\n }\n}\n\nexport async function createNote(noteData: CreateNoteRequest, userEmail: string): Promise {\n try {\n const id = crypto.randomUUID();\n const hasPassword = !!noteData.password;\n const passwordHash = hasPassword ? await hashPassword(noteData.password!) : null;\n \n let expiresAt = null;\n if (noteData.expiresIn) {\n const expireDate = new Date();\n expireDate.setHours(expireDate.getHours() + noteData.expiresIn);\n expiresAt = expireDate.toISOString();\n }\n\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, title, content, password_hash, has_password, expires_at, created_by) \n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [id, noteData.title, noteData.content, passwordHash, hasPassword ? 1 : 0, expiresAt, userEmail]\n );\n\n return id;\n } catch (error) {\n console.error('Error in createNote:', error);\n throw error;\n }\n}\n\nexport async function getNoteById(id: string): Promise {\n try {\n const result = await sqlite.execute(\n `SELECT id, title, content, has_password, created_at, expires_at, created_by \n FROM ${TABLE_NAME} \n WHERE id = ?`,\n [id]\n );\n\n if (!result.rows || result.rows.length === 0) {\n return null;\n }\n\n const row = result.rows[0];\n \n // Check if note has expired\n if (row.expires_at) {\n const expiresAt = new Date(row.expires_at as string);\n const now = new Date();\n if (now > expiresAt) {\n return null; // Note has expired\n }\n }\n \n const note = {\n id: row.id as string,\n title: row.title as string,\n content: row.content as string,\n hasPassword: !!(row.has_password),\n createdAt: row.created_at as string,\n expiresAt: row.expires_at as string || undefined,\n createdBy: row.created_by as string,\n };\n \n return note;\n } catch (error) {\n console.error('Error in getNoteById:', error);\n throw error;\n }\n}\n\nexport async function verifyNotePassword(id: string, password: string): Promise {\n try {\n const passwordHash = await hashPassword(password);\n \n const result = await sqlite.execute(\n `SELECT id FROM ${TABLE_NAME} WHERE id = ? AND password_hash = ?`,\n [id, passwordHash]\n );\n\n return result.rows && result.rows.length > 0;\n } catch (error) {\n console.error('Error in verifyNotePassword:', error);\n throw error;\n }\n}\n\nexport async function getUserNotes(userEmail: string): Promise {\n try {\n const result = await sqlite.execute(\n `SELECT id, title, content, has_password, created_at, expires_at, created_by \n FROM ${TABLE_NAME} \n WHERE created_by = ? AND (expires_at IS NULL OR expires_at > datetime('now'))\n ORDER BY created_at DESC`,\n [userEmail]\n );\n\n if (!result.rows) return [];\n\n return result.rows.map(row => ({\n id: row.id as string,\n title: row.title as string,\n content: row.content as string,\n hasPassword: !!(row.has_password),\n createdAt: row.created_at as string,\n expiresAt: row.expires_at as string || undefined,\n createdBy: row.created_by as string,\n }));\n } catch (error) {\n console.error('Error in getUserNotes:', error);\n throw error;\n }\n}\n\n",[],[154,304,296],"database","acb9c938-3a98-11f0-82b2-9e149126039e","migrations.ts","cad8b15c-3a95-11f0-b008-9e149126039e",42,["D",1748308785572],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = 'notes_3d_v2'; // Updated version for new schema\nconst USERS_TABLE = 'users_3d_v1';\n\nexport async function runMigrations() {\n // Create users table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n email TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n picture TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n last_login DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create notes table with user reference\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n password_hash TEXT,\n has_password BOOLEAN NOT NULL DEFAULT FALSE,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n expires_at DATETIME,\n created_by TEXT NOT NULL,\n FOREIGN KEY (created_by) REFERENCES ${USERS_TABLE} (email)\n )`);\n \n console.log('Database migrations completed');\n}\n\nexport async function cleanupExpiredNotes(): Promise {\n await sqlite.execute(\n `DELETE FROM ${TABLE_NAME} WHERE expires_at IS NOT NULL AND expires_at <= datetime('now')`\n );\n}\n\nexport { TABLE_NAME, USERS_TABLE };",[],[154,304,306],"cad8d13c-3a95-11f0-b008-9e149126039e",["D",1748307547617],[171,172],[154,304],["D",1748307547617],[170,173,176],[154],["D",1748307441149],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":26},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_122":357,"_358":359,"_360":361,"_362":26,"_363":26,"_364":26,"_365":24,"_366":-5,"_367":-7,"_368":-7,"_369":61,"_370":26,"_371":26,"_372":-5,"_373":26,"_374":26,"_375":26,"_376":-5},"ENV",{"_328":329,"_330":331,"_332":85,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356},"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 · v44