[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_193":194,"_195":196},"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":25,"_118":119,"_120":58,"_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":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",28,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","endpoint.tsx","latestPath","fileId","682d250e-3e89-11f0-9518-76b3cceeab13","name","fileType","http","content","export default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}","// 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*/","createdAt",["D",1748742051920],"branchVersion","branchId","319a0716-3e69-11f0-b8a8-76b3cceeab13","id","3199be46-3e69-11f0-b8a8-76b3cceeab13","fetch-socials",["D",1748728197311],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","fetch and archive my social posts ","imageUrl","0b183774-7327-4420-94f0-5c8d391db67d","pinnedFileId","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",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":14,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","welson","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yV0d1d3lHUzVZTEttYW1pTWJzRDJ6VXBsMVIifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":189,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":190,"_80":191,"_82":192,"_84":25},"tree",[172,173,174,175],"files",[172,173,174,175],"counts",{"_161":62,"_162":163,"_164":62,"_165":166,"_167":168},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":157,"_32":28,"_30":31,"_132":-5,"_41":42,"_40":14,"_134":58,"_38":158,"_13":159,"_33":34,"_35":37,"_24":25,"_139":-5,"_27":160},{"_43":149,"_32":150,"_30":151,"_132":-5,"_41":42,"_40":152,"_134":58,"_38":153,"_13":154,"_33":137,"_35":155,"_24":25,"_139":-5,"_27":156},{"_43":141,"_32":142,"_30":143,"_132":-5,"_41":42,"_40":144,"_134":58,"_38":145,"_13":146,"_33":137,"_35":147,"_24":25,"_139":-5,"_27":148},{"_43":129,"_32":130,"_30":131,"_132":-5,"_41":42,"_40":133,"_134":58,"_38":135,"_13":136,"_33":137,"_35":138,"_24":25,"_139":-5,"_27":140},"4055a842-3e86-11f0-9045-76b3cceeab13","fetchMicroblog.tsx","319bd4ba-3e69-11f0-b8a8-76b3cceeab13","parentId",10,"latest",["D",1748740677428],7,"interval","// 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}","label",[130],"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}",[142],"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}",[150],"7398475c-3e89-11f0-a090-76b3cceeab13",["D",1748742051920],4,[28],"pulls","branches",1,"forks","envVars",{"_169":159,"_171":62},"connections",{"_169":62,"_170":62},"count","unfilledCount","emptyCount",{"_43":157,"_32":28,"_30":31,"_132":-5,"_41":42,"_40":14,"_134":58,"_38":186,"_13":159,"_33":34,"_35":37,"_24":25,"_139":-5,"_177":187,"_27":188},{"_43":149,"_32":150,"_30":151,"_132":-5,"_41":42,"_40":152,"_134":58,"_38":183,"_13":154,"_33":137,"_35":155,"_24":25,"_139":-5,"_177":184,"_27":185},{"_43":141,"_32":142,"_30":143,"_132":-5,"_41":42,"_40":144,"_134":58,"_38":180,"_13":146,"_33":137,"_35":147,"_24":25,"_139":-5,"_177":181,"_27":182},{"_43":129,"_32":130,"_30":131,"_132":-5,"_41":42,"_40":133,"_134":58,"_38":176,"_13":136,"_33":137,"_35":138,"_24":25,"_139":-5,"_177":178,"_27":179},["D",1748740677428],"children",[],[130],["D",1748740926958],[],[142],["D",1748741796733],[],[150],["D",1748742051920],[],[28],["D",1748728197311],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":14,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_78":-5,"_122":226,"_227":228,"_229":230,"_231":25,"_232":25,"_233":25,"_234":58,"_235":-5,"_236":-7,"_237":-7,"_238":62,"_239":25,"_240":25,"_241":-5,"_242":25,"_243":25,"_244":25,"_245":-5},"ENV",{"_197":198,"_199":200,"_201":85,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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 · v28