[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_224":225,"_226":227},"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":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",{"_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",7,"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","backend/services/ical.ts","latestPath","fileId","16ef40ba-5896-11f0-ba3f-f69ea79377d9","name","ical.ts","fileType","script","content","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}","createdAt",["D",1751606210154],"branchVersion","branchId","3994bace-5895-11f0-bac7-f69ea79377d9","id","399475d2-5895-11f0-bac7-f69ea79377d9","icalEvents",["D",1751605838784],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","03d7951b-c940-49ae-a583-c68882582606","pinnedFileId","27c67d18-5896-11f0-8483-f69ea79377d9","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","b8e8b612-b6cb-437f-82a8-e60039566a18","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",41,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","conrad","handle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2PZ83uNHxUkcYKOv5OpFlBSfGHk.jpeg","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":220,"_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":221,"_79":222,"_81":223,"_83":24},"tree",[161,168,169],"files",[161,162,163,164,165,166,167,168,169],"counts",{"_151":61,"_152":132,"_153":61,"_154":155,"_156":157},"contents",[125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":144,"_31":145,"_29":146,"_131":-5,"_40":41,"_39":147,"_133":57,"_37":148,"_13":61,"_33":149,"_35":-5,"_23":24,"_135":-5,"_26":150},{"_42":137,"_31":138,"_29":139,"_131":-5,"_40":41,"_39":140,"_133":24,"_37":141,"_13":61,"_33":20,"_35":142,"_23":24,"_135":-5,"_26":143},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":57,"_37":134,"_13":61,"_33":34,"_35":104,"_23":24,"_135":-5,"_26":136},"3996cba2-5895-11f0-bac7-f69ea79377d9","main.tsx","3996cc2e-5895-11f0-bac7-f69ea79377d9","parentId",1,"latest",["D",1751605838797],"label",[129],"ed7c7892-5895-11f0-8313-f69ea79377d9","README.md","ed7c7950-5895-11f0-8313-f69ea79377d9",2,["D",1751606140613],"# 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- 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## 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\n## Usage\n\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- Hono for API framework\n- Drizzle ORM with SQLite\n- OpenAI GPT-4 for event extraction\n- TypeScript for type safety",[138],"f21acbd8-5895-11f0-a49d-f69ea79377d9","backend","ac3d6682-c2d2-4d5e-9141-4d60dfb4440e",3,["D",1751606148364],"directory",[145],"pulls","branches","forks","envVars",{"_158":61,"_160":61},"connections",{"_158":61,"_159":61},"count","unfilledCount","emptyCount",{"_42":144,"_31":145,"_29":146,"_131":-5,"_40":41,"_39":147,"_133":57,"_37":217,"_13":61,"_33":149,"_35":-5,"_23":24,"_135":-5,"_171":218,"_26":219},{"_42":213,"_31":204,"_29":199,"_131":146,"_40":41,"_39":147,"_133":57,"_37":214,"_13":61,"_33":149,"_35":-5,"_23":24,"_135":-5,"_171":215,"_26":216},{"_42":205,"_31":206,"_29":207,"_131":199,"_40":41,"_39":208,"_133":24,"_37":209,"_13":61,"_33":34,"_35":210,"_23":24,"_135":-5,"_171":211,"_26":212},{"_42":196,"_31":197,"_29":198,"_131":199,"_40":41,"_39":147,"_133":57,"_37":200,"_13":61,"_33":34,"_35":201,"_23":24,"_135":-5,"_171":202,"_26":203},{"_42":191,"_31":186,"_29":180,"_131":146,"_40":41,"_39":192,"_133":57,"_37":193,"_13":61,"_33":149,"_35":-5,"_23":24,"_135":-5,"_171":194,"_26":195},{"_42":187,"_31":32,"_29":30,"_131":180,"_40":41,"_39":14,"_133":57,"_37":188,"_13":61,"_33":34,"_35":36,"_23":24,"_135":-5,"_171":189,"_26":190},{"_42":177,"_31":178,"_29":179,"_131":180,"_40":41,"_39":181,"_133":57,"_37":182,"_13":132,"_33":34,"_35":183,"_23":24,"_135":-5,"_171":184,"_26":185},{"_42":137,"_31":138,"_29":139,"_131":-5,"_40":41,"_39":140,"_133":24,"_37":174,"_13":61,"_33":20,"_35":142,"_23":24,"_135":-5,"_171":175,"_26":176},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":57,"_37":170,"_13":61,"_33":34,"_35":104,"_23":24,"_135":-5,"_171":172,"_26":173},["D",1751605838797],"children",[],[129],["D",1751606140613],[],[138],"038f19d2-5896-11f0-aacd-f69ea79377d9","shortener.ts","009ecf06-5896-11f0-9902-f69ea79377d9","759c894b-182e-427a-b444-3dfdc28953d5",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}",[],[145,186,178],"services","16ef4024-5896-11f0-ba3f-f69ea79377d9",["D",1751606210154],[],[145,186,32],"009edb72-5896-11f0-9902-f69ea79377d9",5,["D",1751606172712],[166,167],[145,186],"f21ac502-5895-11f0-a49d-f69ea79377d9","schema.ts","f21ac5de-5895-11f0-a49d-f69ea79377d9","0b4272c2-f35f-4fad-8c96-8cdc597e0db0",["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;",[],[145,204,197],"database","f6a36746-5895-11f0-bb83-f69ea79377d9","db.ts","f6a36822-5895-11f0-bb83-f69ea79377d9",4,["D",1751606155969],"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 if (method === \"get\") {\n return { rows: result.length > 0 ? [result[0]] : [] };\n }\n return { rows: result };\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}",[],[145,204,206],"f21acdb8-5895-11f0-a49d-f69ea79377d9",["D",1751606148364],[163,164],[145,204],["D",1751606148364],[162,165],[145],["D",1751605838784],{"_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":257,"_258":259,"_260":261,"_262":24,"_263":24,"_264":24,"_265":57,"_266":-5,"_267":-7,"_268":-7,"_269":61,"_270":24,"_271":24,"_272":-5,"_273":24,"_274":24,"_275":24,"_276":-5},"ENV",{"_228":229,"_230":231,"_232":85,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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 · v7