[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_340":341,"_342":343},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_254":-5,"_20":255,"_22":256,"_257":258,"_259":260,"_26":261,"_24":262,"_263":-5,"_264":-5,"_265":55,"_266":267,"_268":46,"_269":-5,"_270":-5,"_271":272},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","conrad","name","icalEvents","branchName","main","version","path","backend/routes","project",{"_34":201,"_13":14,"_47":202,"_203":-5,"_204":55,"_205":206,"_207":206,"_208":-5,"_209":-5,"_210":211,"_212":131,"_213":46,"_214":46,"_215":-5,"_216":64,"_217":218,"_219":-5,"_220":-5,"_221":-5,"_222":-5,"_223":224,"_225":224,"_226":227,"_228":227,"_229":227,"_230":224,"_231":224,"_232":233,"_234":235,"_236":237,"_238":55},"tree",[67,68,69,70],"file",{"_34":60,"_13":59,"_37":40,"_39":61,"_41":42,"_43":62,"_45":46,"_47":63,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_18":66},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","9e593074-58fa-11f0-88c5-f69ea79377d9","shortener.ts","fileId","21fa13b8-5896-11f0-abbd-f69ea79377d9","parentId","fa5818fc-a282-4ad3-9ce6-533effbb7366","branchId","3994bace-5895-11f0-bac7-f69ea79377d9","branchVersion",39,"latest",true,"createdAt",["D",1751649387011],11,"fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createShortlink, getShortlink, incrementAccessCount, updateIcalContent } from \"../services/shortener-simple.ts\";\nimport { fetchAndExtractEvents, generateIcal } from \"../services/ical.ts\";\n\nconst app = new Hono();\n\n// Create a new short link\napp.post(\"/shorten\", async (c) => {\n try {\n const body = await c.req.json();\n const { url } = body;\n\n if (!url) {\n return c.json({ error: \"URL is required\" }, 400);\n }\n\n const shortlink = await createShortlink(url);\n \n return c.json({\n shortCode: shortlink.short_code,\n originalUrl: shortlink.original_url,\n shortUrl: `${new URL(c.req.url).origin}/${shortlink.short_code}`,\n statusUrl: `${new URL(c.req.url).origin}/${shortlink.short_code}/status`,\n icalUrl: `${new URL(c.req.url).origin}/${shortlink.short_code}.ics`,\n createdAt: shortlink.created_at\n });\n } catch (error) {\n console.error(\"Error creating shortlink:\", error);\n return c.json({ error: error.message }, 500);\n }\n});\n\n// Generate and serve iCal file\napp.get(\"/:shortCode\", async (c) => {\n const shortCode = c.req.param(\"shortCode\");\n \n // Check if this is an .ics request\n if (shortCode.endsWith('.ics')) {\n const actualShortCode = shortCode.slice(0, -4); // Remove .ics extension\n \n try {\n console.log(\"iCal request for shortCode:\", actualShortCode);\n const shortlink = await getShortlink(actualShortCode);\n\n if (!shortlink) {\n return c.json({ error: \"Short link not found\" }, 404);\n }\n\n // Check if we have cached iCal content (less than 24 hours old)\n const now = new Date();\n const cacheExpiry = 24 * 60 * 60 * 1000; // 24 hours in milliseconds\n \n if (shortlink.ical_content && shortlink.ical_generated_at) {\n const icalAge = now.getTime() - new Date(shortlink.ical_generated_at).getTime();\n if (icalAge < cacheExpiry) {\n return new Response(shortlink.ical_content, {\n headers: {\n 'Content-Type': 'text/calendar; charset=utf-8',\n 'Content-Disposition': `attachment; filename=\"${actualShortCode}.ics\"`\n }\n });\n }\n }\n\n // Generate new iCal content\n console.log(\"Generating iCal for URL:\", shortlink.original_url);\n const events = await fetchAndExtractEvents(shortlink.original_url);\n const title = shortlink.title || 'Events';\n const icalContent = generateIcal(events, title);\n\n // Cache the iCal content\n await updateIcalContent(actualShortCode, icalContent);\n\n return new Response(icalContent, {\n headers: {\n 'Content-Type': 'text/calendar; charset=utf-8',\n 'Content-Disposition': `attachment; filename=\"${actualShortCode}.ics\"`\n }\n });\n } catch (error) {\n console.error(\"Error generating iCal:\", error);\n return c.json({ error: `Error generating calendar: ${error.message}` }, 500);\n }\n }\n \n // Regular redirect logic for non-.ics requests\n try {\n const shortlink = await getShortlink(shortCode);\n\n if (!shortlink) {\n return c.json({ error: \"Short link not found\" }, 404);\n }\n\n // Increment access count\n await incrementAccessCount(shortCode);\n\n // Redirect to original URL\n return new Response(null, {\n status: 302,\n headers: {\n Location: shortlink.original_url\n }\n });\n } catch (error) {\n console.error(\"Error redirecting:\", error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\n// Get shortlink status\napp.get(\"/:shortCode/status\", async (c) => {\n try {\n const shortCode = c.req.param(\"shortCode\");\n const shortlink = await getShortlink(shortCode);\n\n if (!shortlink) {\n return c.json({ error: \"Short link not found\" }, 404);\n }\n\n return c.json({\n shortCode: shortlink.short_code,\n originalUrl: shortlink.original_url,\n title: shortlink.title,\n createdAt: shortlink.created_at,\n lastAccessed: shortlink.last_accessed,\n accessCount: shortlink.access_count,\n hasIcal: !!shortlink.ical_content,\n icalGeneratedAt: shortlink.ical_generated_at\n });\n } catch (error) {\n console.error(\"Error getting status:\", error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\nexport default app;","deleted",false,"label",[58,59,36],"backend","routes","21fa1eee-5896-11f0-abbd-f69ea79377d9","ac3d6682-c2d2-4d5e-9141-4d60dfb4440e",8,["D",1751606228680],0,"directory",[58,59],{"_34":120,"_13":58,"_37":61,"_39":-5,"_41":42,"_43":121,"_45":46,"_47":122,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_77":123,"_18":124},{"_34":88,"_13":89,"_37":90,"_39":-5,"_41":42,"_43":91,"_45":46,"_47":92,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_77":93,"_18":94},{"_34":80,"_13":81,"_37":82,"_39":-5,"_41":42,"_43":83,"_45":46,"_47":84,"_17":74,"_50":24,"_52":85,"_54":55,"_56":-5,"_77":86,"_18":87},{"_34":71,"_13":72,"_37":73,"_39":-5,"_41":42,"_43":74,"_45":46,"_47":75,"_17":64,"_50":51,"_52":76,"_54":55,"_56":-5,"_77":78,"_18":79},"3996cba2-5895-11f0-bac7-f69ea79377d9","main.tsx","3996cc2e-5895-11f0-bac7-f69ea79377d9",1,["D",1751605838797],"","children",[],[72],"c4a066ee-58fa-11f0-be81-f69ea79377d9","README.md","ed7c7950-5895-11f0-8313-f69ea79377d9",40,["D",1751649451226],"# URL Shortener with iCal Generation\n\nA URL shortener service that creates short links and generates iCal calendar files from web page events using GPT-4.\n\n## Features\n\n- **Web Interface**: User-friendly frontend for creating and managing short links\n- Create short links for any URL\n- View shortlink status and analytics\n- Generate iCal calendar files from web page content using GPT-4\n- SQLite database with Drizzle ORM for data persistence\n- Caching for improved performance\n\n## Web Interface\n\nVisit the main page to access the web interface where you can:\n- Enter URLs to shorten\n- Copy generated short links\n- Access status pages and download calendar files\n- View API documentation\n\n## API Endpoints\n\n- `POST /shorten` - Create a new short link\n- `GET /{shortCode}` - Redirect to original URL\n- `GET /{shortCode}/status` - View shortlink status\n- `GET /{shortCode}.ics` - Download iCal calendar file\n- `GET /api` - API documentation (JSON format)\n\n## Usage\n\n### Web Interface\n1. Visit the main page\n2. Enter a URL in the form\n3. Click \"Shorten URL\" to create a short link\n4. Use the generated links to access the original URL, view status, or download calendar\n\n### API Usage\n1. POST to `/shorten` with `{ \"url\": \"your-url-here\" }`\n2. Use the returned short code to access the link or calendar\n3. Access `/{shortCode}.ics` to get calendar events from the page\n\n## Tech Stack\n\n- **Frontend**: HTML, JavaScript, TailwindCSS\n- **Backend**: Hono for API framework\n- **Database**: Drizzle ORM with SQLite\n- **AI**: OpenAI GPT-4 for event extraction\n- **Language**: TypeScript for type safety",[],[81],"1fcc2fa4-58fa-11f0-8a6e-f69ea79377d9","frontend","b2ddf7f3-e110-40b9-b69e-7296cb3e3481",33,["D",1751649174691],[95,96,97],[89],{"_34":113,"_13":81,"_37":114,"_39":90,"_41":42,"_43":115,"_45":46,"_47":116,"_17":64,"_50":24,"_52":117,"_54":55,"_56":-5,"_77":118,"_18":119},{"_34":106,"_13":107,"_37":108,"_39":90,"_41":42,"_43":91,"_45":46,"_47":109,"_17":64,"_50":24,"_52":110,"_54":55,"_56":-5,"_77":111,"_18":112},{"_34":98,"_13":99,"_37":100,"_39":90,"_41":42,"_43":101,"_45":46,"_47":102,"_17":64,"_50":51,"_52":103,"_54":55,"_56":-5,"_77":104,"_18":105},"2b200286-58fa-11f0-bc69-f69ea79377d9","index.js","2b20034e-58fa-11f0-bc69-f69ea79377d9",34,["D",1751649193700],"// DOM elements\nconst shortenForm = document.getElementById('shortenForm');\nconst urlInput = document.getElementById('url');\nconst resultsDiv = document.getElementById('results');\nconst shortUrlInput = document.getElementById('shortUrl');\nconst copyBtn = document.getElementById('copyBtn');\nconst visitLink = document.getElementById('visitLink');\nconst statusLink = document.getElementById('statusLink');\nconst calendarLink = document.getElementById('calendarLink');\nconst loading = document.getElementById('loading');\nconst errorMessage = document.getElementById('errorMessage');\nconst errorText = document.getElementById('errorText');\n\n// Show error message\nfunction showError(message) {\n errorText.textContent = message;\n errorMessage.classList.remove('hidden');\n setTimeout(() => {\n errorMessage.classList.add('hidden');\n }, 5000);\n}\n\n// Show loading\nfunction showLoading() {\n loading.classList.remove('hidden');\n}\n\n// Hide loading\nfunction hideLoading() {\n loading.classList.add('hidden');\n}\n\n// Handle form submission\nshortenForm.addEventListener('submit', async (e) => {\n e.preventDefault();\n \n const url = urlInput.value.trim();\n if (!url) {\n showError('Please enter a valid URL');\n return;\n }\n\n showLoading();\n \n try {\n const response = await fetch('/shorten', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ url })\n });\n\n if (!response.ok) {\n const errorData = await response.json().catch(() => ({ error: 'Unknown error occurred' }));\n throw new Error(errorData.error || `HTTP ${response.status}: ${response.statusText}`);\n }\n\n const data = await response.json();\n \n // Get the current domain for building full URLs\n const currentDomain = window.location.origin;\n const shortUrl = `${currentDomain}/${data.shortCode}`;\n const statusUrl = `${currentDomain}/${data.shortCode}/status`;\n const calendarUrl = `${currentDomain}/${data.shortCode}.ics`;\n\n // Update the results section\n shortUrlInput.value = shortUrl;\n visitLink.href = shortUrl;\n statusLink.href = statusUrl;\n calendarLink.href = calendarUrl;\n\n // Show results\n resultsDiv.classList.remove('hidden');\n \n // Scroll to results\n resultsDiv.scrollIntoView({ behavior: 'smooth' });\n\n } catch (error) {\n console.error('Error shortening URL:', error);\n showError(error.message || 'Failed to shorten URL. Please try again.');\n } finally {\n hideLoading();\n }\n});\n\n// Handle copy button\ncopyBtn.addEventListener('click', async () => {\n try {\n await navigator.clipboard.writeText(shortUrlInput.value);\n \n // Visual feedback\n const originalText = copyBtn.textContent;\n copyBtn.textContent = 'Copied!';\n copyBtn.classList.remove('bg-green-600', 'hover:bg-green-700');\n copyBtn.classList.add('bg-green-800');\n \n setTimeout(() => {\n copyBtn.textContent = originalText;\n copyBtn.classList.remove('bg-green-800');\n copyBtn.classList.add('bg-green-600', 'hover:bg-green-700');\n }, 2000);\n \n } catch (error) {\n console.error('Failed to copy:', error);\n showError('Failed to copy to clipboard');\n }\n});\n\n// Auto-focus URL input on page load\ndocument.addEventListener('DOMContentLoaded', () => {\n urlInput.focus();\n});\n\n// Handle Enter key in URL input\nurlInput.addEventListener('keypress', (e) => {\n if (e.key === 'Enter') {\n shortenForm.dispatchEvent(new Event('submit'));\n }\n});\n\n// Clear results when starting a new URL\nurlInput.addEventListener('input', () => {\n if (urlInput.value.trim() === '') {\n resultsDiv.classList.add('hidden');\n }\n});",[],[89,99],"1fcc121c-58fa-11f0-8a6e-f69ea79377d9","index.html","1fcc12ee-58fa-11f0-8a6e-f69ea79377d9",["D",1751649174691],"\n\n\n \n \n URL Shortener with iCal Generation\n \n \n\n\n

\n \n

🔗 URL Shortener

Create short links and generate calendar events from web pages

\n\n \n

Create Short Link

\n \n

\n\n \n

Your Short Link

\n \n \n

\n \n 🔗 Visit Link\n \n \n 📊 View Status\n \n \n 📅 Download Calendar\n \n

\n\n \n

🔗 URL Shortening

\n Create short, memorable links for any URL. Perfect for sharing on social media, \n emails, or anywhere space is limited.\n

📅 Smart Calendar Generation

\n Automatically extract events from web pages and generate iCal calendar files \n using AI-powered content analysis.\n

\n\n \n

API Endpoints

\n POST /shorten\n Create a new short link\n

\n GET /{shortCode}\n Redirect to original URL\n

\n GET /{shortCode}/status\n View shortlink status and analytics\n

\n GET /{shortCode}.ics\n Download iCal calendar file\n

\n\n \n

\n Creating short link...\n

\n\n \n

\n \n

\n\n \n\n",[],[89,107],"e1acc94e-58fa-11f0-aa34-f69ea79377d9","e1acca02-58fa-11f0-aa34-f69ea79377d9",41,["D",1751649499954],"# Frontend\n\nThis directory contains the frontend files for the URL Shortener application.\n\n## Files\n\n- `index.html` - Main HTML template with TailwindCSS styling\n- `index.js` - JavaScript for form handling, API calls, and user interactions\n\n## Features\n\n- **Responsive Design**: Works on desktop and mobile devices\n- **Real-time Validation**: URL input validation and error handling\n- **Copy to Clipboard**: One-click copying of generated short links\n- **Loading States**: Visual feedback during API calls\n- **Error Handling**: User-friendly error messages\n- **Accessibility**: Proper labels, focus management, and keyboard navigation\n\n## Styling\n\nThe frontend uses TailwindCSS via CDN for styling, providing:\n- Modern, clean design\n- Responsive grid layouts\n- Hover and focus states\n- Loading animations\n- Color-coded action buttons\n\n## JavaScript Features\n\n- Form submission handling\n- Fetch API for backend communication\n- Clipboard API integration\n- DOM manipulation for dynamic content\n- Error state management\n- Auto-focus and keyboard shortcuts\n\n## API Integration\n\nThe frontend communicates with the backend API endpoints:\n- `POST /shorten` - Create new short links\n- Displays generated short URLs, status links, and calendar download links\n- Handles API errors gracefully with user feedback",[],[89,81],"f21acbd8-5895-11f0-a49d-f69ea79377d9",3,["D",1751606148364],[125,126,127,128],[58],{"_34":178,"_13":179,"_37":180,"_39":61,"_41":42,"_43":121,"_45":46,"_47":181,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_77":182,"_18":183},{"_34":60,"_13":59,"_37":40,"_39":61,"_41":42,"_43":62,"_45":46,"_47":171,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_77":172,"_18":173},{"_34":139,"_13":140,"_37":141,"_39":61,"_41":42,"_43":142,"_45":46,"_47":143,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_77":144,"_18":145},{"_34":129,"_13":130,"_37":131,"_39":61,"_41":42,"_43":132,"_45":46,"_47":133,"_17":134,"_50":135,"_52":136,"_54":55,"_56":-5,"_77":137,"_18":138},"3d4059de-58fa-11f0-a42f-f69ea79377d9","index.ts","27c67d18-5896-11f0-8483-f69ea79377d9",36,["D",1751649224107],7,"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { initializeTable, getShortlink, updateIcalContent } from \"./services/shortener-simple.ts\";\nimport { fetchAndExtractEvents, generateIcal } from \"./services/ical.ts\";\nimport shortenerRoutes from \"./routes/shortener.ts\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.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 initializeTable();\n\n// Health check endpoint\napp.get(\"/health\", (c) => {\n return c.json({ status: \"ok\", timestamp: new Date().toISOString() });\n});\n\n// Serve frontend files\napp.get(\"/frontend/*\", 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// API documentation endpoint (for programmatic access)\napp.get(\"/api\", (c) => {\n return c.json({\n name: \"URL Shortener with iCal Generation\",\n version: \"1.0.0\",\n endpoints: {\n \"POST /shorten\": \"Create a new short link\",\n \"GET /{shortCode}\": \"Redirect to original URL\",\n \"GET /{shortCode}/status\": \"Get shortlink status and analytics\",\n \"GET /{shortCode}.ics\": \"Download iCal calendar file with events from the page\"\n },\n example: {\n create: {\n method: \"POST\",\n url: \"/shorten\",\n body: { url: \"https://example.com\" }\n },\n usage: {\n redirect: \"/{shortCode}\",\n status: \"/{shortCode}/status\",\n calendar: \"/{shortCode}.ics\"\n }\n }\n });\n});\n\n// Mount shortener routes\napp.route(\"/\", shortenerRoutes);\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[58,130],"009edb72-5896-11f0-9902-f69ea79377d9","services","759c894b-182e-427a-b444-3dfdc28953d5",5,["D",1751606172712],[146,147,148],[58,140],{"_34":164,"_13":165,"_37":166,"_39":141,"_41":42,"_43":134,"_45":46,"_47":167,"_17":64,"_50":51,"_52":168,"_54":55,"_56":-5,"_77":169,"_18":170},{"_34":156,"_13":157,"_37":158,"_39":141,"_41":42,"_43":159,"_45":46,"_47":160,"_17":62,"_50":51,"_52":161,"_54":55,"_56":-5,"_77":162,"_18":163},{"_34":149,"_13":36,"_37":150,"_39":141,"_41":42,"_43":151,"_45":46,"_47":152,"_17":74,"_50":51,"_52":153,"_54":55,"_56":-5,"_77":154,"_18":155},"038f19d2-5896-11f0-aacd-f69ea79377d9","009ecf06-5896-11f0-9902-f69ea79377d9",6,["D",1751606177640],"import { eq, sql } from \"https://esm.sh/drizzle-orm@0.29.0\";\nimport { db } from \"../database/db.ts\";\nimport { shortlinks, type NewShortlink, type Shortlink } from \"../database/schema.ts\";\n\n// Generate a random short code\nfunction generateShortCode(length: number = 6): string {\n const chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';\n let result = '';\n for (let i = 0; i < length; i++) {\n result += chars.charAt(Math.floor(Math.random() * chars.length));\n }\n return result;\n}\n\n// Extract page title from HTML content\nfunction extractTitle(html: string): string | null {\n const titleMatch = html.match(/]*>([^<]+)<\\/title>/i);\n return titleMatch ? titleMatch[1].trim() : null;\n}\n\nexport async function createShortlink(originalUrl: string): Promise {\n // Validate URL\n try {\n new URL(originalUrl);\n } catch {\n throw new Error(\"Invalid URL provided\");\n }\n\n // Check if URL already exists\n const existing = await db.select().from(shortlinks).where(eq(shortlinks.originalUrl, originalUrl));\n if (existing.length > 0) {\n return existing[0];\n }\n\n // Generate unique short code\n let shortCode: string;\n let attempts = 0;\n do {\n shortCode = generateShortCode();\n attempts++;\n if (attempts > 10) {\n shortCode = generateShortCode(8); // Use longer code if having collisions\n }\n const existingCode = await db.select().from(shortlinks).where(eq(shortlinks.shortCode, shortCode));\n if (existingCode.length === 0) break;\n } while (attempts < 20);\n\n if (attempts >= 20) {\n throw new Error(\"Failed to generate unique short code\");\n }\n\n // Fetch page title\n let title: string | null = null;\n try {\n const response = await fetch(originalUrl, {\n headers: {\n 'User-Agent': 'Mozilla/5.0 (compatible; URLShortener/1.0)'\n }\n });\n if (response.ok) {\n const html = await response.text();\n title = extractTitle(html);\n }\n } catch (error) {\n console.warn(\"Failed to fetch page title:\", error);\n }\n\n // Create shortlink\n const newShortlink: NewShortlink = {\n shortCode,\n originalUrl,\n title,\n createdAt: new Date(),\n accessCount: 0,\n };\n\n const result = await db.insert(shortlinks).values(newShortlink).returning();\n return result[0];\n}\n\nexport async function getShortlink(shortCode: string): Promise {\n const result = await db.select().from(shortlinks).where(eq(shortlinks.shortCode, shortCode));\n return result.length > 0 ? result[0] : null;\n}\n\nexport async function incrementAccessCount(shortCode: string): Promise {\n await db.update(shortlinks)\n .set({ \n accessCount: sql`access_count + 1`,\n lastAccessed: new Date()\n })\n .where(eq(shortlinks.shortCode, shortCode));\n}\n\nexport async function updateIcalContent(shortCode: string, icalContent: string, pageContent?: string): Promise {\n const updateData: any = {\n icalContent,\n icalGeneratedAt: new Date(),\n };\n \n if (pageContent) {\n updateData.pageContent = pageContent;\n }\n\n await db.update(shortlinks)\n .set(updateData)\n .where(eq(shortlinks.shortCode, shortCode));\n}",[],[58,140,36],"b7300a6e-5896-11f0-b10f-f69ea79377d9","shortener-simple.ts","5c0943da-5896-11f0-bc6f-f69ea79377d9",24,["D",1751606479010],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport interface Shortlink {\n id: number;\n short_code: string;\n original_url: string;\n title?: string;\n created_at: string;\n last_accessed?: string;\n access_count: number;\n ical_content?: string;\n ical_generated_at?: string;\n page_content?: string;\n}\n\nconst TABLE_NAME = 'shortlinks_v1';\n\n// Initialize database table\nexport async function initializeTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n short_code TEXT NOT NULL UNIQUE,\n original_url TEXT NOT NULL,\n title TEXT,\n created_at TEXT NOT NULL,\n last_accessed TEXT,\n access_count INTEGER DEFAULT 0 NOT NULL,\n ical_content TEXT,\n ical_generated_at TEXT,\n page_content TEXT\n )\n `);\n}\n\n// Generate a random short code\nfunction generateShortCode(length: number = 6): string {\n const chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';\n let result = '';\n for (let i = 0; i < length; i++) {\n result += chars.charAt(Math.floor(Math.random() * chars.length));\n }\n return result;\n}\n\n// Extract page title from HTML content\nfunction extractTitle(html: string): string | null {\n const titleMatch = html.match(/]*>([^<]+)<\\/title>/i);\n return titleMatch ? titleMatch[1].trim() : null;\n}\n\nexport async function createShortlink(originalUrl: string): Promise {\n // Validate URL\n try {\n new URL(originalUrl);\n } catch {\n throw new Error(\"Invalid URL provided\");\n }\n\n // Check if URL already exists\n const existing = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE original_url = ?`, \n [originalUrl]\n );\n if (existing.rows && existing.rows.length > 0) {\n return existing.rows[0] as Shortlink;\n }\n\n // Generate unique short code\n let shortCode: string;\n let attempts = 0;\n const maxAttempts = 10;\n \n do {\n shortCode = generateShortCode(attempts > 5 ? 8 : 6);\n attempts++;\n \n try {\n const existingCode = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${TABLE_NAME} WHERE short_code = ?`, \n [shortCode]\n );\n \n // Check if no existing code found\n if (!existingCode.rows || existingCode.rows.length === 0 || existingCode.rows[0]?.count === 0) {\n break;\n }\n } catch (error) {\n console.error(\"Error checking short code:\", error);\n // If there's an error checking, assume it's unique and break\n break;\n }\n } while (attempts < maxAttempts);\n\n if (attempts >= maxAttempts) {\n // Use timestamp-based code as fallback\n shortCode = Date.now().toString(36) + Math.random().toString(36).substr(2, 3);\n }\n\n // Fetch page title\n let title: string | null = null;\n try {\n const response = await fetch(originalUrl, {\n headers: {\n 'User-Agent': 'Mozilla/5.0 (compatible; URLShortener/1.0)'\n }\n });\n if (response.ok) {\n const html = await response.text();\n title = extractTitle(html);\n }\n } catch (error) {\n console.warn(\"Failed to fetch page title:\", error);\n }\n\n // Create shortlink\n const createdAt = new Date().toISOString();\n console.log(\"Creating shortlink with code:\", shortCode);\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (short_code, original_url, title, created_at, access_count) \n VALUES (?, ?, ?, ?, 0)`,\n [shortCode, originalUrl, title, createdAt]\n );\n\n console.log(\"Shortlink created, fetching result...\");\n \n // Return the created shortlink\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE short_code = ?`,\n [shortCode]\n );\n \n console.log(\"Query result:\", result);\n \n if (!result.rows || result.rows.length === 0) {\n throw new Error(\"Failed to retrieve created shortlink\");\n }\n \n return result.rows[0] as Shortlink;\n}\n\nexport async function getShortlink(shortCode: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE short_code = ?`,\n [shortCode]\n );\n return (result.rows && result.rows.length > 0) ? result.rows[0] as Shortlink : null;\n}\n\nexport async function incrementAccessCount(shortCode: string): Promise {\n const lastAccessed = new Date().toISOString();\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} \n SET access_count = access_count + 1, last_accessed = ? \n WHERE short_code = ?`,\n [lastAccessed, shortCode]\n );\n}\n\nexport async function updateIcalContent(shortCode: string, icalContent: string, pageContent?: string): Promise {\n const icalGeneratedAt = new Date().toISOString();\n \n if (pageContent) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} \n SET ical_content = ?, ical_generated_at = ?, page_content = ? \n WHERE short_code = ?`,\n [icalContent, icalGeneratedAt, pageContent, shortCode]\n );\n } else {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} \n SET ical_content = ?, ical_generated_at = ? \n WHERE short_code = ?`,\n [icalContent, icalGeneratedAt, shortCode]\n );\n }\n}",[],[58,140,157],"16ef4024-5896-11f0-ba3f-f69ea79377d9","ical.ts","16ef40ba-5896-11f0-ba3f-f69ea79377d9",["D",1751606210154],"import { OpenAI } from \"https://esm.town/v/std/openai\";\n\nexport interface CalendarEvent {\n title: string;\n description?: string;\n startDate: Date;\n endDate?: Date;\n location?: string;\n url?: string;\n}\n\n// Generate iCal content from events\nexport function generateIcal(events: CalendarEvent[], title: string = \"Events\"): string {\n const now = new Date();\n const timestamp = now.toISOString().replace(/[-:]/g, '').split('.')[0] + 'Z';\n \n let ical = [\n 'BEGIN:VCALENDAR',\n 'VERSION:2.0',\n 'PRODID:-//URLShortener//Event Calendar//EN',\n 'CALSCALE:GREGORIAN',\n 'METHOD:PUBLISH',\n `X-WR-CALNAME:${title}`,\n 'X-WR-TIMEZONE:UTC'\n ].join('\\r\\n') + '\\r\\n';\n\n events.forEach((event, index) => {\n const uid = `event-${index}-${timestamp}@urlshortener.val.town`;\n const dtstart = formatIcalDate(event.startDate);\n const dtend = event.endDate ? formatIcalDate(event.endDate) : formatIcalDate(new Date(event.startDate.getTime() + 2 * 60 * 60 * 1000)); // Default 2 hours\n \n ical += [\n 'BEGIN:VEVENT',\n `UID:${uid}`,\n `DTSTAMP:${timestamp}`,\n `DTSTART:${dtstart}`,\n `DTEND:${dtend}`,\n `SUMMARY:${escapeIcalText(event.title)}`,\n event.description ? `DESCRIPTION:${escapeIcalText(event.description)}` : '',\n event.location ? `LOCATION:${escapeIcalText(event.location)}` : '',\n event.url ? `URL:${event.url}` : '',\n 'STATUS:CONFIRMED',\n 'END:VEVENT'\n ].filter(line => line !== '').join('\\r\\n') + '\\r\\n';\n });\n\n ical += 'END:VCALENDAR\\r\\n';\n return ical;\n}\n\n// Format date for iCal (YYYYMMDDTHHMMSSZ)\nfunction formatIcalDate(date: Date): string {\n return date.toISOString().replace(/[-:]/g, '').split('.')[0] + 'Z';\n}\n\n// Escape text for iCal format\nfunction escapeIcalText(text: string): string {\n return text\n .replace(/\\\\/g, '\\\\\\\\')\n .replace(/;/g, '\\\\;')\n .replace(/,/g, '\\\\,')\n .replace(/\\n/g, '\\\\n')\n .replace(/\\r/g, '');\n}\n\n// Extract events from web page content using GPT-4\nexport async function extractEventsFromContent(content: string, url: string): Promise {\n const openai = new OpenAI();\n \n // Clean and truncate content to avoid token limits\n const cleanContent = content\n .replace(/]*>[\\s\\S]*?<\\/script>/gi, '')\n .replace(/]*>[\\s\\S]*?<\\/style>/gi, '')\n .replace(/<[^>]+>/g, ' ')\n .replace(/\\s+/g, ' ')\n .trim()\n .substring(0, 8000); // Limit content size\n\n const prompt = `\nExtract calendar events from the following web page content. Look for any events, games, shows, meetings, or scheduled activities.\n\nFor each event found, provide:\n- title: Clear, descriptive title\n- description: Brief description (optional)\n- startDate: ISO 8601 format (YYYY-MM-DDTHH:MM:SS.000Z)\n- endDate: ISO 8601 format (optional, estimate if not provided)\n- location: Venue or location (optional)\n\nReturn ONLY a valid JSON array of events. If no events are found, return an empty array [].\n\nWeb page URL: ${url}\n\nContent:\n${cleanContent}\n\nExample format:\n[\n {\n \"title\": \"Basketball Game vs Team A\",\n \"description\": \"Home game at stadium\",\n \"startDate\": \"2025-02-15T19:00:00.000Z\",\n \"endDate\": \"2025-02-15T21:30:00.000Z\",\n \"location\": \"Sports Arena\"\n }\n]\n`;\n\n try {\n const completion = await openai.chat.completions.create({\n model: \"gpt-4o\",\n messages: [\n {\n role: \"system\",\n content: \"You are an expert at extracting structured event data from web content. Always return valid JSON arrays only, no additional text or formatting.\"\n },\n {\n role: \"user\",\n content: prompt\n }\n ],\n max_tokens: 2000,\n temperature: 0.1\n });\n\n const response = completion.choices[0]?.message?.content?.trim();\n if (!response) {\n throw new Error(\"No response from OpenAI\");\n }\n\n // Parse the JSON response\n const events = JSON.parse(response);\n \n // Validate and convert dates\n return events.map((event: any) => ({\n title: event.title || 'Untitled Event',\n description: event.description || undefined,\n startDate: new Date(event.startDate),\n endDate: event.endDate ? new Date(event.endDate) : undefined,\n location: event.location || undefined,\n url: url\n })).filter((event: CalendarEvent) => \n !isNaN(event.startDate.getTime()) // Filter out invalid dates\n );\n\n } catch (error) {\n console.error(\"Error extracting events:\", error);\n throw new Error(`Failed to extract events: ${error.message}`);\n }\n}\n\n// Fetch page content and extract events\nexport async function fetchAndExtractEvents(url: string): Promise {\n try {\n const response = await fetch(url, {\n headers: {\n 'User-Agent': 'Mozilla/5.0 (compatible; URLShortener/1.0; +https://urlshortener.val.town)'\n }\n });\n\n if (!response.ok) {\n throw new Error(`HTTP ${response.status}: ${response.statusText}`);\n }\n\n const content = await response.text();\n return await extractEventsFromContent(content, url);\n } catch (error) {\n console.error(\"Error fetching page content:\", error);\n throw new Error(`Failed to fetch page: ${error.message}`);\n }\n}",[],[58,140,165],["D",1751606228680],[174],[58,59],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":175,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_77":176,"_18":177},["D",1751649387011],[],[58,59,36],"f21acdb8-5895-11f0-a49d-f69ea79377d9","database","0b4272c2-f35f-4fad-8c96-8cdc597e0db0",["D",1751606148364],[184,185],[58,179],{"_34":193,"_13":194,"_37":195,"_39":180,"_41":42,"_43":196,"_45":46,"_47":197,"_17":74,"_50":51,"_52":198,"_54":55,"_56":-5,"_77":199,"_18":200},{"_34":186,"_13":187,"_37":188,"_39":180,"_41":42,"_43":121,"_45":46,"_47":189,"_17":64,"_50":51,"_52":190,"_54":55,"_56":-5,"_77":191,"_18":192},"f21ac502-5895-11f0-a49d-f69ea79377d9","schema.ts","f21ac5de-5895-11f0-a49d-f69ea79377d9",["D",1751606148364],"import { sqliteTable, text, integer } from \"https://esm.sh/drizzle-orm@0.29.0/sqlite-core\";\n\nexport const shortlinks = sqliteTable('shortlinks', {\n id: integer('id').primaryKey({ autoIncrement: true }),\n shortCode: text('short_code').notNull().unique(),\n originalUrl: text('original_url').notNull(),\n title: text('title'),\n createdAt: integer('created_at', { mode: 'timestamp' }).notNull(),\n lastAccessed: integer('last_accessed', { mode: 'timestamp' }),\n accessCount: integer('access_count').default(0).notNull(),\n icalContent: text('ical_content'), // Cached iCal content\n icalGeneratedAt: integer('ical_generated_at', { mode: 'timestamp' }),\n pageContent: text('page_content'), // Cached page content for iCal generation\n});\n\nexport type Shortlink = typeof shortlinks.$inferSelect;\nexport type NewShortlink = typeof shortlinks.$inferInsert;",[],[58,179,187],"4da4e790-5896-11f0-ab79-f69ea79377d9","db.ts","f6a36822-5895-11f0-bb83-f69ea79377d9",12,["D",1751606301937],"import { drizzle } from \"https://esm.sh/drizzle-orm@0.29.0/sqlite-proxy\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport * as schema from \"./schema.ts\";\n\n// Create the database connection\nexport const db = drizzle(\n async (sql, params, method) => {\n try {\n const result = await sqlite.execute(sql, params || []);\n \n // Ensure result is always an array\n const rows = Array.isArray(result) ? result : [result];\n \n if (method === \"get\") {\n return { rows: rows.length > 0 ? [rows[0]] : [] };\n }\n return { rows };\n } catch (error) {\n console.error(\"Database error:\", error);\n throw error;\n }\n },\n { schema }\n);\n\n// Initialize database tables\nexport async function initializeDatabase() {\n try {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS shortlinks (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n short_code TEXT NOT NULL UNIQUE,\n original_url TEXT NOT NULL,\n title TEXT,\n created_at INTEGER NOT NULL,\n last_accessed INTEGER,\n access_count INTEGER DEFAULT 0 NOT NULL,\n ical_content TEXT,\n ical_generated_at INTEGER,\n page_content TEXT\n )\n `);\n console.log(\"Database initialized successfully\");\n } catch (error) {\n console.error(\"Failed to initialize database:\", error);\n throw error;\n }\n}",[],[58,179,194],"399475d2-5895-11f0-bac7-f69ea79377d9",["D",1751605838784],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","03d7951b-c940-49ae-a583-c68882582606","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","b8e8b612-b6cb-437f-82a8-e60039566a18","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_253":249},"org",{"_11":12,"_247":-5,"_248":249,"_210":211,"_250":251,"_252":55},"branch",{"_17":115,"_13":16,"_34":42,"_239":201,"_240":-5,"_241":-5,"_242":-5,"_243":-5,"_244":-5,"_245":14,"_246":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2PZ83uNHxUkcYKOv5OpFlBSfGHk.jpeg","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":201,"_13":14,"_47":336,"_203":-5,"_204":55,"_205":206,"_207":206,"_208":-5,"_209":-5,"_210":211,"_212":131,"_213":46,"_214":46,"_215":-5,"_216":64,"_217":218,"_219":-5,"_220":-5,"_221":-5,"_222":-5,"_223":224,"_225":224,"_226":227,"_228":227,"_229":227,"_230":224,"_231":224,"_232":337,"_234":338,"_236":339,"_238":55},[285,296,300,301],"files",[285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301],"counts",{"_276":64,"_277":74,"_278":64,"_32":279,"_280":281},[274],{"_34":60,"_13":59,"_37":40,"_39":61,"_41":42,"_43":62,"_45":46,"_47":63,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_18":273},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[58,59],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":275},[58,59,36],"pulls","branches","forks",{"_282":64,"_284":64},"connections",{"_282":64,"_283":64},"count","unfilledCount","emptyCount",{"_34":120,"_13":58,"_37":61,"_39":-5,"_41":42,"_43":121,"_45":46,"_47":122,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_77":334,"_18":335},{"_34":178,"_13":179,"_37":180,"_39":61,"_41":42,"_43":121,"_45":46,"_47":181,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_77":332,"_18":333},{"_34":193,"_13":194,"_37":195,"_39":180,"_41":42,"_43":196,"_45":46,"_47":197,"_17":74,"_50":51,"_52":198,"_54":55,"_56":-5,"_77":330,"_18":331},{"_34":186,"_13":187,"_37":188,"_39":180,"_41":42,"_43":121,"_45":46,"_47":189,"_17":64,"_50":51,"_52":190,"_54":55,"_56":-5,"_77":328,"_18":329},{"_34":60,"_13":59,"_37":40,"_39":61,"_41":42,"_43":62,"_45":46,"_47":171,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_77":326,"_18":327},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":175,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_77":324,"_18":325},{"_34":139,"_13":140,"_37":141,"_39":61,"_41":42,"_43":142,"_45":46,"_47":143,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_77":322,"_18":323},{"_34":164,"_13":165,"_37":166,"_39":141,"_41":42,"_43":134,"_45":46,"_47":167,"_17":64,"_50":51,"_52":168,"_54":55,"_56":-5,"_77":320,"_18":321},{"_34":156,"_13":157,"_37":158,"_39":141,"_41":42,"_43":159,"_45":46,"_47":160,"_17":62,"_50":51,"_52":161,"_54":55,"_56":-5,"_77":318,"_18":319},{"_34":149,"_13":36,"_37":150,"_39":141,"_41":42,"_43":151,"_45":46,"_47":152,"_17":74,"_50":51,"_52":153,"_54":55,"_56":-5,"_77":316,"_18":317},{"_34":129,"_13":130,"_37":131,"_39":61,"_41":42,"_43":132,"_45":46,"_47":133,"_17":134,"_50":135,"_52":136,"_54":55,"_56":-5,"_77":314,"_18":315},{"_34":88,"_13":89,"_37":90,"_39":-5,"_41":42,"_43":91,"_45":46,"_47":92,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_77":312,"_18":313},{"_34":113,"_13":81,"_37":114,"_39":90,"_41":42,"_43":115,"_45":46,"_47":116,"_17":64,"_50":24,"_52":117,"_54":55,"_56":-5,"_77":310,"_18":311},{"_34":106,"_13":107,"_37":108,"_39":90,"_41":42,"_43":91,"_45":46,"_47":109,"_17":64,"_50":24,"_52":110,"_54":55,"_56":-5,"_77":308,"_18":309},{"_34":98,"_13":99,"_37":100,"_39":90,"_41":42,"_43":101,"_45":46,"_47":102,"_17":64,"_50":51,"_52":103,"_54":55,"_56":-5,"_77":306,"_18":307},{"_34":80,"_13":81,"_37":82,"_39":-5,"_41":42,"_43":83,"_45":46,"_47":84,"_17":74,"_50":24,"_52":85,"_54":55,"_56":-5,"_77":304,"_18":305},{"_34":71,"_13":72,"_37":73,"_39":-5,"_41":42,"_43":74,"_45":46,"_47":75,"_17":64,"_50":51,"_52":76,"_54":55,"_56":-5,"_77":302,"_18":303},[],[72],[],[81],[],[89,99],[],[89,107],[],[89,81],[297,298,299],[89],[],[58,130],[],[58,140,36],[],[58,140,157],[],[58,140,165],[292,293,294],[58,140],[],[58,59,36],[290],[58,59],[],[58,179,187],[],[58,179,194],[287,288],[58,179],[286,289,291,295],[58],["D",1751605838784],{"_11":12,"_253":249},{"_11":12,"_247":-5,"_248":249,"_210":211,"_250":251,"_252":55},{"_17":115,"_13":16,"_34":42,"_239":201,"_240":-5,"_241":-5,"_242":-5,"_243":-5,"_244":-5,"_245":14,"_246":12},"ctx",{"_232":-5,"_270":373,"_374":375,"_376":377,"_378":55,"_379":55,"_380":55,"_381":46,"_382":-5,"_383":-7,"_384":-7,"_385":64,"_386":55,"_387":55,"_388":-5,"_389":55,"_390":55,"_391":55,"_392":-5},"ENV",{"_344":345,"_346":347,"_348":16,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372},"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"]