[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_189":190,"_191":192},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_89":-7,"_90":91,"_29":-7,"_92":-5,"_15":93,"_94":95,"_96":97,"_98":99,"_100":101,"_102":-5,"_103":-5,"_104":-5,"_105":38,"_106":107,"_108":50,"_109":-5,"_110":-5,"_111":112},"routes/_app.x.$handle.$name.branches",{"_11":12,"_13":14,"_15":16,"_17":18},"handle","welson","name","fetch-socials","project",{"_20":28,"_13":14,"_22":36,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":50,"_51":50,"_52":-5,"_53":54,"_55":56,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":62,"_64":65,"_66":65,"_67":65,"_68":62,"_69":62,"_70":71,"_72":73,"_74":75,"_76":38},"branches",[19],{"_20":21,"_22":23,"_24":25,"_13":26,"_27":28,"_29":30,"_31":-5,"_32":-5,"_33":34,"_35":-5},"id","319a0716-3e69-11f0-b8a8-76b3cceeab13","createdAt",["D",1748728197311],"updatedAt",["D",1748742051920],"main","projectId","3199be46-3e69-11f0-b8a8-76b3cceeab13","version",28,"forkedBranchId","forkedBranchVersion","lockfileKey","1768850693225-esm.town_v_welson_fetch-socials@28-main","deletedAt",["D",1748728197311],"legacyEnvVars",false,"privacy","public","httpPrivacy","description","fetch and archive my social posts ","imageUrl","userId","0b183774-7327-4420-94f0-5c8d391db67d","pinnedFileId","682d250e-3e89-11f0-9518-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","7ee36961-6294-402b-b7ad-8e2fc1ef8a81","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_88":84},"org",{"_11":12,"_82":-5,"_83":84,"_45":46,"_85":86,"_87":38},"branch",{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"isOwned","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yV0d1d3lHUzVZTEttYW1pTWJzRDJ6VXBsMVIifQ","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_20":28,"_13":14,"_22":185,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":50,"_51":50,"_52":-5,"_53":54,"_55":56,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":62,"_64":65,"_66":65,"_67":65,"_68":62,"_69":62,"_70":186,"_72":187,"_74":188,"_76":38},"tree",[168,169,170,171],"files",[168,169,170,171],"counts",{"_158":54,"_17":159,"_160":54,"_161":162,"_163":164},"contents",[113,114,115,116],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_20":151,"_13":152,"_119":48,"_121":-5,"_122":21,"_123":30,"_125":50,"_22":153,"_29":154,"_128":155,"_130":156,"_132":38,"_133":-5,"_90":157},{"_20":143,"_13":144,"_119":145,"_121":-5,"_122":21,"_123":146,"_125":50,"_22":147,"_29":148,"_128":129,"_130":149,"_132":38,"_133":-5,"_90":150},{"_20":135,"_13":136,"_119":137,"_121":-5,"_122":21,"_123":138,"_125":50,"_22":139,"_29":140,"_128":129,"_130":141,"_132":38,"_133":-5,"_90":142},{"_20":117,"_13":118,"_119":120,"_121":-5,"_122":21,"_123":124,"_125":50,"_22":126,"_29":127,"_128":129,"_130":131,"_132":38,"_133":-5,"_90":134},"4055a842-3e86-11f0-9045-76b3cceeab13","fetchMicroblog.tsx","fileId","319bd4ba-3e69-11f0-b8a8-76b3cceeab13","parentId","branchId","branchVersion",10,"latest",["D",1748740677428],7,"fileType","interval","content","// Val.town function to fetch and archive Micro.blog posts\n// This can be run as a cron job every 30 minutes\n\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\n// Replace with your Micro.blog username\nconst MICROBLOG_USERNAME = \"welson\";\n\nexport default async function(interval: Interval) {\n // Initialize Supabase client\n const supabaseUrl = Deno.env.get(\"SUPABASE_URL\");\n const supabaseKey = Deno.env.get(\"SUPABASE_SERVICE_KEY\");\n\n if (!supabaseUrl || !supabaseKey) {\n throw new Error(\"Missing Supabase credentials\");\n }\n\n const supabase = createClient(supabaseUrl, supabaseKey);\n\n try {\n // Fetch Micro.blog JSON feed\n const feedUrl = `https://micro.blog/posts/${MICROBLOG_USERNAME}`;\n console.log(`Fetching from: ${feedUrl}`);\n\n const response = await fetch(feedUrl, {\n headers: {\n \"Accept\": \"application/json\",\n },\n });\n\n if (!response.ok) {\n throw new Error(`Failed to fetch feed: ${response.status}`);\n }\n\n const data = await response.json();\n const posts = data.items || [];\n\n console.log(`Found ${posts.length} posts in feed`);\n\n // Transform and prepare posts for insertion\n const transformedPosts = posts.map(post => ({\n source: \"microblog\",\n post_id: post.id || post.url, // Use ID or URL as unique identifier\n content: post.content_text || post.content_html || \"\",\n created_at: post.date_published || new Date().toISOString(),\n media_urls: extractMediaUrls(post),\n metadata: {\n url: post.url,\n title: post.title,\n tags: post.tags || [],\n original: post, // Store the entire original post\n },\n }));\n\n // Insert posts in batches, ignoring duplicates\n const results = {\n processed: 0,\n inserted: 0,\n errors: [],\n };\n\n for (const post of transformedPosts) {\n try {\n const { data, error } = await supabase\n .from(\"posts\")\n .insert([post])\n .select();\n\n if (error) {\n // Check if it's a duplicate key error\n if (error.code === \"23505\") {\n console.log(`Post ${post.post_id} already exists, skipping`);\n } else {\n console.error(`Error inserting post ${post.post_id}:`, error);\n results.errors.push({ post_id: post.post_id, error: error.message });\n }\n } else {\n results.inserted++;\n console.log(`Inserted post: ${post.post_id}`);\n }\n\n results.processed++;\n } catch (err) {\n console.error(`Unexpected error processing post:`, err);\n results.errors.push({ post_id: post.post_id, error: err.message });\n }\n }\n\n // Get total count of archived posts\n const { count } = await supabase\n .from(\"posts\")\n .select(\"*\", { count: \"exact\", head: true })\n .eq(\"source\", \"microblog\");\n\n return {\n success: true,\n feedPosts: posts.length,\n processed: results.processed,\n inserted: results.inserted,\n errors: results.errors.length,\n totalArchived: count,\n timestamp: new Date().toISOString(),\n };\n } catch (error) {\n console.error(\"Fetcher error:\", error);\n return {\n success: false,\n error: error.message,\n timestamp: new Date().toISOString(),\n };\n }\n}\n\n// Helper function to extract media URLs from a post\nfunction extractMediaUrls(post) {\n const mediaUrls = [];\n\n // Check for image property\n if (post.image) {\n mediaUrls.push(post.image);\n }\n\n // Check for attachments\n if (post.attachments && Array.isArray(post.attachments)) {\n post.attachments.forEach(attachment => {\n if (attachment.url) {\n mediaUrls.push(attachment.url);\n }\n });\n }\n\n // Extract images from HTML content if present\n if (post.content_html) {\n const imgRegex = /]+src=\"([^\">]+)\"/g;\n let match;\n while ((match = imgRegex.exec(post.content_html)) !== null) {\n mediaUrls.push(match[1]);\n }\n }\n\n return mediaUrls;\n}","deleted","label",[118],"d5113712-3e86-11f0-82f8-76b3cceeab13","fetchMastodon.tsx","61647770-3e86-11f0-9045-76b3cceeab13",16,["D",1748740926958],5,"// Val.town function to fetch and archive Mastodon posts\n// This can be run as a cron job every 30 minutes\n\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\n// Configure your Mastodon details here\nconst MASTODON_INSTANCE = \"tacobelllabs.net\"; // Change to your instance (e.g., fosstodon.org)\nconst MASTODON_USERNAME = \"gabby\"; // Just the username, no @ symbol\n\nexport default async function(interval: Interval) {\n // Initialize Supabase client\n const supabaseUrl = Deno.env.get(\"SUPABASE_URL\");\n const supabaseKey = Deno.env.get(\"SUPABASE_SERVICE_KEY\");\n\n if (!supabaseUrl || !supabaseKey) {\n throw new Error(\"Missing Supabase credentials\");\n }\n\n const supabase = createClient(supabaseUrl, supabaseKey);\n\n try {\n console.log(`🦣 Starting Mastodon fetch from @${MASTODON_USERNAME}@${MASTODON_INSTANCE}`);\n\n // Step 1: Look up the account ID\n const accountLookupUrl = `https://${MASTODON_INSTANCE}/api/v1/accounts/lookup?acct=${MASTODON_USERNAME}`;\n console.log(\"Looking up account ID...\");\n\n const accountResponse = await fetch(accountLookupUrl);\n if (!accountResponse.ok) {\n throw new Error(`Failed to look up account: ${accountResponse.status}`);\n }\n\n const account = await accountResponse.json();\n const accountId = account.id;\n console.log(`✅ Found account ID: ${accountId}`);\n\n // Step 2: Fetch recent posts (statuses)\n const statusesUrl =\n `https://${MASTODON_INSTANCE}/api/v1/accounts/${accountId}/statuses?limit=40&exclude_replies=true&exclude_reblogs=true`;\n console.log(\"Fetching recent posts...\");\n\n const statusesResponse = await fetch(statusesUrl);\n if (!statusesResponse.ok) {\n throw new Error(`Failed to fetch statuses: ${statusesResponse.status}`);\n }\n\n const statuses = await statusesResponse.json();\n console.log(`📝 Found ${statuses.length} posts to process`);\n\n // Transform and prepare posts for insertion\n const transformedPosts = statuses.map(status => ({\n source: \"mastodon\",\n post_id: status.id,\n content: stripHtml(status.content), // Convert HTML to plain text\n created_at: status.created_at,\n media_urls: extractMastodonMedia(status),\n metadata: {\n url: status.url,\n uri: status.uri,\n visibility: status.visibility,\n language: status.language,\n favourites_count: status.favourites_count,\n reblogs_count: status.reblogs_count,\n replies_count: status.replies_count,\n tags: status.tags || [],\n mentions: status.mentions || [],\n card: status.card,\n poll: status.poll,\n content_html: status.content, // Store original HTML\n sensitive: status.sensitive,\n spoiler_text: status.spoiler_text,\n },\n }));\n\n // Insert posts in batches, ignoring duplicates\n const results = {\n processed: 0,\n inserted: 0,\n skipped: 0,\n errors: [],\n };\n\n for (const post of transformedPosts) {\n try {\n const { data, error } = await supabase\n .from(\"posts\")\n .insert([post])\n .select();\n\n if (error) {\n if (error.code === \"23505\") {\n // Duplicate key - post already exists\n results.skipped++;\n } else {\n console.error(`❌ Error inserting post ${post.post_id}:`, error);\n results.errors.push({ post_id: post.post_id, error: error.message });\n }\n } else {\n results.inserted++;\n console.log(`✅ Inserted post: ${post.post_id} - \"${post.content.substring(0, 50)}...\"`);\n }\n\n results.processed++;\n } catch (err) {\n console.error(`❌ Unexpected error processing post:`, err);\n results.errors.push({ post_id: post.post_id, error: err.message });\n }\n }\n\n // Get total count of archived Mastodon posts\n const { count } = await supabase\n .from(\"posts\")\n .select(\"*\", { count: \"exact\", head: true })\n .eq(\"source\", \"mastodon\");\n\n const summary = {\n success: true,\n instance: MASTODON_INSTANCE,\n username: MASTODON_USERNAME,\n fetchedPosts: statuses.length,\n processed: results.processed,\n inserted: results.inserted,\n skipped: results.skipped,\n errors: results.errors.length,\n totalArchived: count,\n timestamp: new Date().toISOString(),\n };\n\n console.log(\"\\n📊 Summary:\", summary);\n\n return summary;\n } catch (error) {\n console.error(\"❌ Fetcher error:\", error);\n return {\n success: false,\n error: error.message,\n timestamp: new Date().toISOString(),\n };\n }\n}\n\n// Helper function to extract media URLs from Mastodon status\nfunction extractMastodonMedia(status) {\n const mediaUrls = [];\n\n if (status.media_attachments && Array.isArray(status.media_attachments)) {\n status.media_attachments.forEach(attachment => {\n // Use preview_url for images, url as fallback\n const url = attachment.preview_url || attachment.url;\n if (url) {\n mediaUrls.push({\n url: url,\n type: attachment.type,\n description: attachment.description,\n });\n }\n });\n }\n\n return mediaUrls;\n}\n\n// Helper function to convert HTML to plain text\nfunction stripHtml(html) {\n // Basic HTML stripping - removes tags and decodes entities\n return html\n .replace(//gi, \"\\n\") // Convert
to newlines\n .replace(/<\\/p>/gi, \"\\n\\n\") // Add double newline after paragraphs\n .replace(/<[^>]*>/g, \"\") // Remove all other HTML tags\n .replace(/&/g, \"&\")\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/"/g, \"\\\"\")\n .replace(/'/g, \"'\")\n .replace(/ /g, \" \")\n .trim();\n}",[136],"db7de134-3e88-11f0-b220-76b3cceeab13","fetchBluesky.tsx","4fbf9828-3e87-11f0-a7df-76b3cceeab13",23,["D",1748741796733],6,"// Val.town function to fetch and archive Bluesky posts (TypeScript)\n// This can be run as a cron job every 30 minutes\n\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\n// Bluesky types\ninterface BlueskySession {\n did: string;\n handle: string;\n email: string;\n accessJwt: string;\n refreshJwt: string;\n}\n\ninterface BlueskyPost {\n uri: string;\n cid: string;\n author: {\n did: string;\n handle: string;\n displayName?: string;\n };\n record: {\n $type: string;\n text: string;\n createdAt: string;\n embed?: {\n $type: string;\n images?: Array<{\n alt: string;\n image: {\n $type: string;\n ref: { $link: string };\n mimeType: string;\n size: number;\n };\n }>;\n external?: {\n uri: string;\n title: string;\n description: string;\n thumb?: { $type: string; ref: { $link: string } };\n };\n };\n facets?: Array<{\n index: { byteStart: number; byteEnd: number };\n features: Array<{\n $type: string;\n uri?: string;\n did?: string;\n }>;\n }>;\n };\n likeCount?: number;\n repostCount?: number;\n replyCount?: number;\n indexedAt: string;\n}\n\ninterface BlueskyFeedResponse {\n cursor?: string;\n feed: Array<{\n post: BlueskyPost;\n reply?: any;\n reason?: any;\n }>;\n}\n\n// Configure your Bluesky handle - add password to Val.town secrets\nconst BLUESKY_HANDLE = \"gabby.gay\"; // Change to your handle\n\n// Set to true for initial import, false for regular updates\nconst FETCH_FULL_HISTORY = false; // Change to false after initial import\n\nexport default async function(): Promise<{\n success: boolean;\n error?: string;\n [key: string]: any;\n}> {\n // Initialize Supabase client\n const supabaseUrl = Deno.env.get(\"SUPABASE_URL\");\n const supabaseKey = Deno.env.get(\"SUPABASE_SERVICE_KEY\");\n const blueskyPassword = Deno.env.get(\"BLUESKY_PASSWORD\");\n\n if (!supabaseUrl || !supabaseKey) {\n throw new Error(\"Missing Supabase credentials\");\n }\n\n if (!blueskyPassword) {\n throw new Error(\"Missing BLUESKY_PASSWORD in secrets\");\n }\n\n const supabase = createClient(supabaseUrl, supabaseKey);\n\n try {\n console.log(`🦋 Starting Bluesky fetch for ${BLUESKY_HANDLE}`);\n\n // Step 1: Authenticate with Bluesky\n console.log(\"Authenticating with Bluesky...\");\n const session = await authenticateBluesky(BLUESKY_HANDLE, blueskyPassword);\n console.log(`✅ Authenticated as ${session.handle}`);\n\n // Step 2: Fetch author's feed\n console.log(\"Fetching posts...\");\n const posts = await fetchAuthorFeed(session, FETCH_FULL_HISTORY);\n console.log(`📝 Found ${posts.length} posts to process`);\n\n // Transform and prepare posts for insertion\n const transformedPosts = posts.map(item => {\n const post = item.post;\n return {\n source: \"bluesky\" as const,\n post_id: post.uri,\n content: post.record.text,\n created_at: post.record.createdAt,\n media_urls: extractBlueskyMedia(post),\n metadata: {\n uri: post.uri,\n cid: post.cid,\n author: {\n did: post.author.did,\n handle: post.author.handle,\n displayName: post.author.displayName,\n },\n engagement: {\n likes: post.likeCount || 0,\n reposts: post.repostCount || 0,\n replies: post.replyCount || 0,\n },\n embed: post.record.embed,\n facets: post.record.facets,\n indexedAt: post.indexedAt,\n },\n };\n });\n\n // Insert posts into Supabase\n const results = {\n processed: 0,\n inserted: 0,\n skipped: 0,\n errors: [] as Array<{ post_id: string; error: string }>,\n };\n\n for (const post of transformedPosts) {\n try {\n const { data, error } = await supabase\n .from(\"posts\")\n .insert([post])\n .select();\n\n if (error) {\n if (error.code === \"23505\") {\n // Duplicate key - post already exists\n results.skipped++;\n } else {\n console.error(`❌ Error inserting post ${post.post_id}:`, error);\n results.errors.push({ post_id: post.post_id, error: error.message });\n }\n } else {\n results.inserted++;\n console.log(`✅ Inserted post: \"${post.content.substring(0, 50)}...\"`);\n }\n\n results.processed++;\n } catch (err: any) {\n console.error(`❌ Unexpected error processing post:`, err);\n results.errors.push({ post_id: post.post_id, error: err.message });\n }\n }\n\n // Get total count of archived Bluesky posts\n const { count } = await supabase\n .from(\"posts\")\n .select(\"*\", { count: \"exact\", head: true })\n .eq(\"source\", \"bluesky\");\n\n const summary = {\n success: true,\n handle: BLUESKY_HANDLE,\n fetchedPosts: posts.length,\n processed: results.processed,\n inserted: results.inserted,\n skipped: results.skipped,\n errors: results.errors.length,\n totalArchived: count,\n timestamp: new Date().toISOString(),\n };\n\n console.log(\"\\n📊 Summary:\", summary);\n\n return summary;\n } catch (error: any) {\n console.error(\"❌ Fetcher error:\", error);\n return {\n success: false,\n error: error.message,\n timestamp: new Date().toISOString(),\n };\n }\n}\n\n// Authenticate with Bluesky AT Protocol\nasync function authenticateBluesky(handle: string, password: string): Promise {\n const response = await fetch(\"https://bsky.social/xrpc/com.atproto.server.createSession\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n identifier: handle,\n password: password,\n }),\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Authentication failed: ${response.status} - ${error}`);\n }\n\n return response.json();\n}\n\n// Fetch posts from author's feed with pagination\nasync function fetchAuthorFeed(\n session: BlueskySession,\n fetchFullHistory: boolean = false,\n): Promise {\n const allPosts: BlueskyFeedResponse[\"feed\"] = [];\n let cursor: string | undefined = undefined;\n let pageCount = 0;\n const maxPages = fetchFullHistory ? 50 : 1; // Fetch many pages for history, or just 1 for updates\n\n console.log(fetchFullHistory ? \"Fetching full post history...\" : \"Fetching recent posts...\");\n\n while (pageCount < maxPages) {\n // Build URL with cursor if available\n const url = new URL(\"https://bsky.social/xrpc/app.bsky.feed.getAuthorFeed\");\n url.searchParams.set(\"actor\", session.did);\n url.searchParams.set(\"limit\", \"100\"); // Max limit per request\n if (cursor) {\n url.searchParams.set(\"cursor\", cursor);\n }\n\n const response = await fetch(url.toString(), {\n headers: {\n \"Authorization\": `Bearer ${session.accessJwt}`,\n },\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Failed to fetch feed: ${response.status} - ${error}`);\n }\n\n const data: BlueskyFeedResponse = await response.json();\n\n // Filter out reposts and replies\n const filteredPosts = data.feed.filter(item => {\n // Skip if it's a repost\n if (item.reason) return false;\n // Skip if it's a reply\n if (item.reply) return false;\n return true;\n });\n\n allPosts.push(...filteredPosts);\n pageCount++;\n\n console.log(` Page ${pageCount}: fetched ${data.feed.length} posts, kept ${filteredPosts.length} original posts`);\n\n // Check if there are more pages\n if (data.cursor && fetchFullHistory) {\n cursor = data.cursor;\n } else {\n // No more pages or not fetching full history\n if (!data.cursor) {\n console.log(\" No more pages available\");\n }\n break;\n }\n\n // Optional: Add a small delay to be respectful to the API\n if (fetchFullHistory) {\n await new Promise(resolve => setTimeout(resolve, 100));\n }\n }\n\n console.log(`✅ Total posts fetched across ${pageCount} page(s): ${allPosts.length}`);\n\n return allPosts;\n}\n\n// Extract media URLs from Bluesky post\nfunction extractBlueskyMedia(post: BlueskyPost): string[] {\n const mediaUrls: string[] = [];\n\n if (post.record.embed) {\n // Handle image embeds\n if (post.record.embed.images && Array.isArray(post.record.embed.images)) {\n post.record.embed.images.forEach(img => {\n // Convert AT Protocol image reference to URL\n const imageRef = img.image.ref.$link;\n const imageUrl = `https://bsky.social/xrpc/com.atproto.sync.getBlob?did=${post.author.did}&cid=${imageRef}`;\n mediaUrls.push(imageUrl);\n });\n }\n\n // Handle external link embeds\n if (post.record.embed.external) {\n // Store the external URL as media\n mediaUrls.push(post.record.embed.external.uri);\n }\n }\n\n return mediaUrls;\n}",[144],"7398475c-3e89-11f0-a090-76b3cceeab13","endpoint.tsx",["D",1748742051920],4,"http","// Val.town HTTP endpoint to serve archived posts with pagination and filtering\n// This will be accessible at: https://USERNAME-posts-api.web.val.run\n\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\n// Types\ninterface QueryParams {\n source?: \"bluesky\" | \"mastodon\" | \"microblog\" | \"all\";\n page?: number;\n limit?: number;\n sort?: \"asc\" | \"desc\";\n}\n\ninterface Post {\n id: string;\n source: string;\n post_id: string;\n content: string;\n created_at: string;\n archived_at: string;\n media_urls: any[];\n metadata: Record;\n}\n\ninterface ApiResponse {\n success: boolean;\n data?: {\n posts: Post[];\n pagination: {\n page: number;\n limit: number;\n total: number;\n totalPages: number;\n hasNext: boolean;\n hasPrev: boolean;\n };\n filter: {\n source: string;\n };\n };\n error?: string;\n}\n\nexport default async function(req: Request): Promise {\n // CORS headers for your Astro site\n const headers = {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\", // Configure this to your domain in production\n \"Access-Control-Allow-Methods\": \"GET, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type, Authorization\",\n };\n\n // Handle preflight requests\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers });\n }\n\n // Only allow GET requests\n if (req.method !== \"GET\") {\n return new Response(\n JSON.stringify({ success: false, error: \"Method not allowed\" }),\n { status: 405, headers },\n );\n }\n\n try {\n // Check authorization\n const authHeader = req.headers.get(\"Authorization\");\n const apiKey = Deno.env.get(\"POSTS_API_KEY\");\n\n if (!apiKey || authHeader !== `Bearer ${apiKey}`) {\n return new Response(\n JSON.stringify({ success: false, error: \"Unauthorized\" }),\n { status: 401, headers },\n );\n }\n\n // Parse query parameters\n const url = new URL(req.url);\n const params: QueryParams = {\n source: (url.searchParams.get(\"source\") as QueryParams[\"source\"]) || \"all\",\n page: parseInt(url.searchParams.get(\"page\") || \"1\"),\n limit: parseInt(url.searchParams.get(\"limit\") || \"20\"),\n sort: (url.searchParams.get(\"sort\") as QueryParams[\"sort\"]) || \"desc\",\n };\n\n // Validate parameters\n if (params.page! < 1) params.page = 1;\n if (params.limit! < 1 || params.limit! > 100) params.limit = 20;\n if (![\"all\", \"bluesky\", \"mastodon\", \"microblog\"].includes(params.source!)) {\n params.source = \"all\";\n }\n\n // Initialize Supabase client\n const supabaseUrl = Deno.env.get(\"SUPABASE_URL\");\n const supabaseKey = Deno.env.get(\"SUPABASE_SERVICE_KEY\");\n\n if (!supabaseUrl || !supabaseKey) {\n throw new Error(\"Missing Supabase credentials\");\n }\n\n const supabase = createClient(supabaseUrl, supabaseKey);\n\n // Build query\n let query = supabase\n .from(\"posts\")\n .select(\"*\", { count: \"exact\" });\n\n // Apply source filter\n if (params.source !== \"all\") {\n query = query.eq(\"source\", params.source);\n }\n\n // Apply sorting\n query = query.order(\"created_at\", { ascending: params.sort === \"asc\" });\n\n // Apply pagination\n const from = (params.page! - 1) * params.limit!;\n const to = from + params.limit! - 1;\n query = query.range(from, to);\n\n // Execute query\n const { data: posts, error, count } = await query;\n\n if (error) {\n throw new Error(`Database error: ${error.message}`);\n }\n\n // Calculate pagination info\n const totalCount = count || 0;\n const totalPages = Math.ceil(totalCount / params.limit!);\n\n // Build response\n const response: ApiResponse = {\n success: true,\n data: {\n posts: posts || [],\n pagination: {\n page: params.page!,\n limit: params.limit!,\n total: totalCount,\n totalPages: totalPages,\n hasNext: params.page! < totalPages,\n hasPrev: params.page! > 1,\n },\n filter: {\n source: params.source!,\n },\n },\n };\n\n return new Response(JSON.stringify(response), { status: 200, headers });\n } catch (error: any) {\n console.error(\"API Error:\", error);\n\n const errorResponse: ApiResponse = {\n success: false,\n error: error.message || \"Internal server error\",\n };\n\n return new Response(\n JSON.stringify(errorResponse),\n { status: 500, headers },\n );\n }\n}\n\n// API Documentation (for reference)\n/*\n# Posts API Documentation\n\n## Authentication\nAll requests must include an Authorization header:\nAuthorization: Bearer YOUR_API_KEY\n\n## Endpoints\n\n### GET /\nFetch posts with optional filtering and pagination\n\nQuery Parameters:\n- source: \"all\" | \"bluesky\" | \"mastodon\" | \"microblog\" (default: \"all\")\n- page: number (default: 1)\n- limit: number (default: 20, max: 100)\n- sort: \"asc\" | \"desc\" (default: \"desc\")\n\nExample Requests:\n- Get all posts: /?page=1&limit=20\n- Get only Bluesky posts: /?source=bluesky&page=1&limit=20\n- Get posts in ascending order: /?sort=asc&page=1&limit=50\n\nResponse Format:\n{\n \"success\": true,\n \"data\": {\n \"posts\": [...],\n \"pagination\": {\n \"page\": 1,\n \"limit\": 20,\n \"total\": 150,\n \"totalPages\": 8,\n \"hasNext\": true,\n \"hasPrev\": false\n },\n \"filter\": {\n \"source\": \"all\"\n }\n }\n}\n*/",[152],"pulls",1,"forks","envVars",{"_165":154,"_167":54},"connections",{"_165":54,"_166":54},"count","unfilledCount","emptyCount",{"_20":151,"_13":152,"_119":48,"_121":-5,"_122":21,"_123":30,"_125":50,"_22":182,"_29":154,"_128":155,"_130":156,"_132":38,"_133":-5,"_173":183,"_90":184},{"_20":143,"_13":144,"_119":145,"_121":-5,"_122":21,"_123":146,"_125":50,"_22":179,"_29":148,"_128":129,"_130":149,"_132":38,"_133":-5,"_173":180,"_90":181},{"_20":135,"_13":136,"_119":137,"_121":-5,"_122":21,"_123":138,"_125":50,"_22":176,"_29":140,"_128":129,"_130":141,"_132":38,"_133":-5,"_173":177,"_90":178},{"_20":117,"_13":118,"_119":120,"_121":-5,"_122":21,"_123":124,"_125":50,"_22":172,"_29":127,"_128":129,"_130":131,"_132":38,"_133":-5,"_173":174,"_90":175},["D",1748740677428],"children",[],[118],["D",1748740926958],[],[136],["D",1748741796733],[],[144],["D",1748742051920],[],[152],["D",1748728197311],{"_11":12,"_88":84},{"_11":12,"_82":-5,"_83":84,"_45":46,"_85":86,"_87":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"ctx",{"_70":-5,"_110":222,"_223":224,"_225":226,"_227":38,"_228":38,"_229":38,"_230":50,"_231":-5,"_232":-7,"_233":-7,"_234":54,"_235":38,"_236":38,"_237":-5,"_238":38,"_239":38,"_240":38,"_241":-5},"ENV",{"_193":194,"_195":196,"_197":26,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221},"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"]

Branches1

Branches
1