[{"_1":2,"_273":-5,"_274":-5},"loaderData",{"_3":4,"_91":92,"_264":265},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","8e9ab478faef4805babde6d59c528a1818a04d96","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":-7,"_98":72,"_99":-7,"_100":101,"_146":147,"_223":224,"_225":226,"_234":235,"_257":-5,"_258":-5,"_259":-5,"_260":22,"_261":22,"_262":263},"handle","kliv","name","te34692sv97882490490s4f832ssf880vf","branchName","path","version","project",{"_102":103,"_95":96,"_104":105,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":127,"_130":131,"_133":134,"_145":22},"id","7522b764-bd7e-11f0-aa40-42dde27851f2","createdAt",["D",1762701127718],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","0199d9f9-8fb9-705d-a1be-150ee5ea0145","pinnedFileId","pinPreview","screenshotVersion","likeCount","0199d9f9-8fb9-705d-a1be-18ed6d1d02d7","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_128":129},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzMzeW9MdTZSSlZXdUFyNHFTckJtSlg1b3paYiJ9","org",{"_93":94,"_132":129,"_14":112},"avatar","branch",{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},11,"75233a9a-bd7e-11f0-aa40-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[148,170,179,188,197,205,214],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":156,"_157":158,"_104":159,"_99":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_167":168,"_98":169},"332e9c7c-bd85-11f0-8087-42dde27851f2","fu0sq6574255984qs8qv9016e9t1350159.ts","fileId","c9b6e12e-bd83-11f0-95e4-42dde27851f2","parentId","branchId","branchVersion",8,"latest",true,["D",1762704023541],2,"fileType","http","content","export default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const BASE_URL = 'https://kliv.dev';\n const currentDate = new Date().toISOString().split('T')[0];\n\n try {\n // Get database credentials from headers\n const dbUrl = req.headers.get(\"x-database-url\");\n const dbToken = req.headers.get(\"x-database-token\");\n\n if (!dbUrl || !dbToken) {\n throw new Error('Database credentials not available');\n }\n\n // Import Turso serverless driver\n const { connect } = await import(\"npm:@tursodatabase/serverless\");\n \n const conn = connect({\n url: dbUrl,\n authToken: dbToken\n });\n\n // Query categories and pages\n const categoriesStmt = conn.prepare(\"SELECT slug FROM landing_categories ORDER BY display_order, name\");\n const categories = await categoriesStmt.all();\n\n const pagesStmt = conn.prepare(\"SELECT slug, category_name FROM landing_pages ORDER BY category_name, title\");\n const pages = await pagesStmt.all();\n\n let sitemapXml = `\n\n`;\n\n // Add static pages\n const staticPages = ['', 'about', 'features', 'pricing', 'careers', 'privacy', 'terms', 'security', 'signup', 'login', 'inspiration'];\n const languages = ['en', 'ja', 'sv'];\n\n languages.forEach(lang => {\n staticPages.forEach(page => {\n const url = page === '' ? `${BASE_URL}/${lang}` : `${BASE_URL}/${lang}/${page}`;\n const priority = page === '' ? '1.0' : '0.8';\n sitemapXml += `\n \n ${url}\n ${currentDate}\n weekly\n ${priority}\n `;\n });\n });\n\n // Add database stats comment\n sitemapXml += `\n`;\n\n // Add category pages\n categories.rows.forEach((category: any) => {\n languages.forEach(lang => {\n const url = `${BASE_URL}/${lang}/inspiration/${category.slug}`;\n sitemapXml += `\n \n ${url}\n ${currentDate}\n weekly\n 0.8\n `;\n });\n });\n\n // Add landing pages\n pages.rows.forEach((page: any) => {\n const categorySlug = page.category_name.toLowerCase().replace(/[^a-z0-9]+/g, '-').replace(/^-|-$/g, '');\n languages.forEach(lang => {\n const url = `${BASE_URL}/${lang}/${categorySlug}/${page.slug}`;\n sitemapXml += `\n \n ${url}\n ${currentDate}\n monthly\n 0.7\n `;\n });\n });\n\n const totalUrls = (staticPages.length * languages.length) + (categories.rows.length * languages.length) + (pages.rows.length * languages.length);\n sitemapXml += `\n\n`;\n\n return new Response(sitemapXml, {\n status: 200,\n headers: {\n 'Content-Type': 'application/xml; charset=utf-8',\n 'Cache-Control': 'public, max-age=3600' // Cache for 1 hour\n }\n });\n\n } catch (error) {\n console.error('Failed to generate sitemap:', error);\n \n // Return minimal fallback sitemap\n const fallbackSitemap = `\n\n\n \n ${BASE_URL}/\n ${currentDate}\n daily\n 1.0\n \n`;\n\n return new Response(fallbackSitemap, {\n status: 200,\n headers: {\n 'Content-Type': 'application/xml; charset=utf-8',\n 'Cache-Control': 'public, max-age=300' // Cache for 5 minutes on error\n }\n });\n }\n}","deleted","label","children",[],[150],{"_102":171,"_95":172,"_151":173,"_153":-5,"_154":136,"_155":160,"_157":158,"_104":174,"_99":175,"_161":162,"_163":176,"_165":22,"_166":-5,"_167":177,"_98":178},"7686071e-bd7e-11f0-8042-42dde27851f2","fu1031qqf345s045q685539fe87t0q3q2s.ts","752fa1b8-bd7e-11f0-abc4-42dde27851f2",["D",1762701130043],1,"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const sdkUrl = req.headers.get(\"x-sdk-url\");\n const { PlatformClient } = await import(sdkUrl);\n const platform = new PlatformClient(\n req.headers.get(\"x-platform-token\"),\n req.headers.get(\"x-api-base-url\")\n );\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\")\n });\n\n try {\n // Clear existing data first\n await conn.prepare(\"DELETE FROM inspiration_entries\").run();\n await conn.prepare(\"DELETE FROM landing_pages\").run();\n await conn.prepare(\"DELETE FROM landing_categories\").run();\n \n console.log(\"Cleared existing content data\");\n\n // Step 1: Process inspiration files to get categories\n const inspirationContent = await platform.getContentFile('/public/content/inspiration/en.json');\n const inspirationData = JSON.parse(new TextDecoder().decode(inspirationContent));\n \n console.log(\"Loaded inspiration data\");\n\n // Step 2: Insert categories from inspiration data\n const categories: Record = {};\n const categoryStmt = conn.prepare(\"INSERT INTO landing_categories (name, slug, description, display_order) VALUES (?, ?, ?, ?)\");\n \n let categoryOrder = 0;\n for (const [categoryName, categoryData] of Object.entries(inspirationData)) {\n const category = categoryData as any;\n categories[categoryName] = category.slug;\n await categoryStmt.run([categoryName, category.slug, `Landing pages for ${categoryName}`, categoryOrder++]);\n }\n \n console.log(`Inserted ${Object.keys(categories).length} categories`);\n\n // Step 3: Create slug to category mapping for easier lookup\n const slugToCategory: Record = {};\n for (const [categoryName, categorySlug] of Object.entries(categories)) {\n slugToCategory[categorySlug] = categoryName;\n }\n\n // Step 4: Process all landing page files\n const landingFiles = await platform.listContentFiles('/public/content/landing-pages/en/');\n \n let pagesProcessed = 0;\n\n for (const file of landingFiles.files) {\n if (file.path.endsWith('.json')) {\n try {\n const content = await platform.getContentFile(file.path);\n const pageData = JSON.parse(new TextDecoder().decode(content));\n \n // Extract category slug from path: /public/content/landing-pages/en/category-slug/filename.json\n const pathMatch = file.path.match(/\\/landing-pages\\/en\\/([^\\/]+)\\/([^\\/]+)\\.json$/);\n \n if (pathMatch) {\n const categorySlug = pathMatch[1];\n const pageSlug = pathMatch[2];\n \n // Find category name\n const categoryName = slugToCategory[categorySlug];\n \n if (categoryName) {\n // Insert landing page\n await conn.prepare(\"INSERT INTO landing_pages (slug, category_name, title, description, default_prompt, meta_description, hero_title, hero_subtitle, hero_cta, sections, file_path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\").run([\n pageSlug,\n categoryName,\n pageData.title || '',\n pageData.description || '',\n pageData.defaultPrompt || '',\n pageData.metaDescription || '',\n pageData.hero?.title || '',\n pageData.hero?.subtitle || '',\n pageData.hero?.cta || '',\n JSON.stringify(pageData.sections || []),\n file.path\n ]);\n pagesProcessed++;\n } else {\n console.warn(`No category found for slug: ${categorySlug}`);\n }\n }\n } catch (error) {\n console.error(`Error processing file ${file.path}:`, error);\n }\n }\n }\n\n // Step 5: Insert inspiration entries\n const inspirationStmt = conn.prepare(\"INSERT INTO inspiration_entries (category_name, category_slug, page_title, page_slug, page_description, url, subcategory, features, tags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\");\n let inspirationEntries = 0;\n\n for (const [categoryName, categoryData] of Object.entries(inspirationData)) {\n const category = categoryData as any;\n for (const page of category.pages) {\n await inspirationStmt.run([\n categoryName,\n category.slug,\n page.title,\n page.slug,\n page.description,\n page.url,\n page.subcategory || null,\n JSON.stringify(page.features || []),\n JSON.stringify(page.tags || [])\n ]);\n inspirationEntries++;\n }\n }\n\n console.log(`Migration complete: ${pagesProcessed} pages, ${inspirationEntries} inspiration entries`);\n\n return Response.json({\n success: true,\n message: 'Content migration completed successfully',\n stats: {\n categories: Object.keys(categories).length,\n pages: pagesProcessed,\n inspirationEntries: inspirationEntries\n }\n });\n\n } catch (error: any) {\n console.error('Migration error:', error);\n return Response.json({\n success: false,\n error: error.message || 'Unknown error occurred'\n }, { status: 500 });\n }\n}",[],[172],{"_102":180,"_95":181,"_151":182,"_153":-5,"_154":136,"_155":183,"_157":158,"_104":184,"_99":32,"_161":162,"_163":185,"_165":22,"_166":-5,"_167":186,"_98":187},"8933a100-bd7e-11f0-8418-42dde27851f2","fu73t9v4stf6284e8tsvt61s5s0e792v12.ts","8933a1c8-bd7e-11f0-8418-42dde27851f2",4,["D",1762701161381],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\")\n });\n\n try {\n const query = `\n SELECT \n lc.name as category_name,\n lc.slug as category_slug,\n lc.description as category_description,\n ic.page_title as title,\n ic.page_slug as slug,\n ic.page_description as description,\n ic.url,\n ic.subcategory,\n ic.features,\n ic.tags\n FROM inspiration_entries ic\n JOIN landing_categories lc ON ic.category_name = lc.name\n WHERE ic._deleted = 0 AND lc._deleted = 0\n ORDER BY lc.display_order, ic.page_title\n `;\n\n const stmt = conn.prepare(query);\n const results = await stmt.all();\n\n // Group results by category to match original JSON structure\n const groupedData: Record = {};\n \n results.rows.forEach(row => {\n const categoryName = row.category_name;\n \n if (!groupedData[categoryName]) {\n groupedData[categoryName] = {\n slug: row.category_slug,\n pages: []\n };\n }\n \n groupedData[categoryName].pages.push({\n title: row.title,\n description: row.description,\n slug: row.slug,\n subcategory: row.subcategory,\n url: row.url,\n features: JSON.parse(row.features || '[]'),\n tags: JSON.parse(row.tags || '[]')\n });\n });\n\n return Response.json(groupedData);\n\n } catch (error: any) {\n console.error('Error fetching inspiration index:', error);\n return Response.json({\n error: 'Failed to fetch inspiration index',\n message: error.message\n }, { status: 500 });\n }\n}",[],[181],{"_102":189,"_95":190,"_151":191,"_153":-5,"_154":136,"_155":192,"_157":158,"_104":193,"_99":32,"_161":162,"_163":194,"_165":22,"_166":-5,"_167":195,"_98":196},"0153255e-bd82-11f0-b059-42dde27851f2","fue7v09f99fs204s45s90s3vqsf6s30f04.ts","0153264e-bd82-11f0-b059-42dde27851f2",5,["D",1762702651404],"export default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n const currentDate = new Date().toISOString().split('T')[0];\n const BASE_URL = 'https://kliv.dev';\n \n // Get database connection from headers\n const dbUrl = req.headers.get(\"x-database-url\");\n const dbToken = req.headers.get(\"x-database-token\");\n \n if (!dbUrl || !dbToken) {\n return Response.json({ error: \"Database credentials not available\" }, { status: 500 });\n }\n \n // Connect to database\n import { connect } from \"npm:@tursodatabase/serverless\";\n const conn = connect({\n url: dbUrl,\n authToken: dbToken\n });\n \n // Get all categories\n const categoriesStmt = conn.prepare(\"SELECT slug FROM landing_categories WHERE _deleted = 0\");\n const categories = await categoriesStmt.all();\n \n // Get all landing pages\n const pagesStmt = conn.prepare(\"SELECT slug, category_name FROM landing_pages WHERE _deleted = 0\");\n const pages = await pagesStmt.all();\n \n // Supported languages\n const LANGUAGES = ['en', 'ja', 'sv'];\n \n // Static pages (without language prefix)\n const STATIC_PAGES = [\n '',\n 'about',\n 'features', \n 'pricing',\n 'careers',\n 'privacy',\n 'terms',\n 'security',\n 'signup',\n 'login',\n 'inspiration'\n ];\n \n let sitemap = `\n`;\n\n // Add static pages for each language\n LANGUAGES.forEach(lang => {\n STATIC_PAGES.forEach(page => {\n const url = page === '' ? `${BASE_URL}/${lang}` : `${BASE_URL}/${lang}/${page}`;\n const priority = page === '' ? '1.0' : '0.8';\n \n sitemap += `\n \n ${url}\n ${currentDate}\n weekly\n ${priority}\n `;\n });\n });\n\n // Add category pages\n categories.forEach(category => {\n LANGUAGES.forEach(lang => {\n const url = `${BASE_URL}/${lang}/inspiration/${category.slug}`;\n sitemap += `\n \n ${url}\n ${currentDate}\n weekly\n 0.8\n `;\n });\n });\n\n // Add landing pages\n pages.forEach(page => {\n // Convert category name to slug format (basic conversion)\n const categorySlug = page.category_name\n .toLowerCase()\n .replace(/[^a-z0-9]+/g, '-')\n .replace(/^-|-$/g, '');\n \n LANGUAGES.forEach(lang => {\n const url = `${BASE_URL}/${lang}/${categorySlug}/${page.slug}`;\n sitemap += `\n \n ${url}\n ${currentDate}\n monthly\n 0.7\n `;\n });\n });\n\n sitemap += `\n`;\n\n // Return as XML with proper content type\n return new Response(sitemap, {\n status: 200,\n headers: {\n 'Content-Type': 'application/xml; charset=utf-8',\n 'Cache-Control': 'public, max-age=3600, s-maxage=86400' // Cache for 1 hour, CDN for 24 hours\n }\n });\n \n } catch (error) {\n console.error('Sitemap generation error:', error);\n return Response.json({ \n error: \"Failed to generate sitemap\",\n details: error.message \n }, { status: 500 });\n }\n}",[],[190],{"_102":198,"_95":199,"_151":200,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":201,"_99":175,"_161":162,"_163":202,"_165":22,"_166":-5,"_167":203,"_98":204},"dd3f7c82-bd98-11f0-b645-42dde27851f2","fuet253012v46340518s23t089711243tq.ts","86d69d94-bd98-11f0-bb52-42dde27851f2",["D",1762712469300],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n // Set the proper content type for XML\n const headers = new Headers({\n 'Content-Type': 'application/xml; charset=utf-8',\n 'Cache-Control': 'public, max-age=3600' // Cache for 1 hour\n });\n\n // Database credentials from headers\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\")\n });\n\n const BASE_URL = 'https://kliv.dev';\n const currentDate = new Date().toISOString().split('T')[0];\n\n // Query categories and pages\n const categoriesStmt = conn.prepare(\"SELECT slug FROM landing_categories WHERE _deleted = 0\");\n const categories = await categoriesStmt.all();\n \n const pagesStmt = conn.prepare(\"SELECT slug, category_name FROM landing_pages WHERE _deleted = 0\");\n const pages = await pagesStmt.all();\n\n let sitemapXml = `\n`;\n\n // Add static pages\n const staticPages = ['', 'about', 'features', 'pricing', 'careers', 'privacy', 'terms', 'security', 'signup', 'login', 'inspiration'];\n const languages = ['en', 'ja', 'sv'];\n\n languages.forEach(lang => {\n staticPages.forEach(page => {\n const url = page === '' ? `${BASE_URL}/${lang}` : `${BASE_URL}/${lang}/${page}`;\n const priority = page === '' ? '1.0' : '0.8';\n sitemapXml += `\n \n ${url}\n ${currentDate}\n weekly\n ${priority}\n `;\n });\n });\n\n // Add category pages\n categories.forEach((category: any) => {\n languages.forEach(lang => {\n const url = `${BASE_URL}/${lang}/inspiration/${category.slug}`;\n sitemapXml += `\n \n ${url}\n ${currentDate}\n weekly\n 0.8\n `;\n });\n });\n\n // Add landing pages\n pages.forEach((page: any) => {\n const categorySlug = page.category_name.toLowerCase().replace(/[^a-z0-9]+/g, '-').replace(/^-|-$/g, '');\n languages.forEach(lang => {\n const url = `${BASE_URL}/${lang}/${categorySlug}/${page.slug}`;\n sitemapXml += `\n \n ${url}\n ${currentDate}\n monthly\n 0.7\n `;\n });\n });\n\n const totalUrls = (staticPages.length * languages.length) + (categories.length * languages.length) + (pages.length * languages.length);\n sitemapXml += `\n`;\n\n return new Response(sitemapXml, { \n status: 200, \n headers \n });\n\n } catch (error) {\n console.error('Sitemap edge function error:', error);\n \n // Fallback minimal sitemap\n const currentDate = new Date().toISOString().split('T')[0];\n const fallbackSitemap = `\n\n \n https://kliv.dev/\n ${currentDate}\n daily\n 1.0\n \n`;\n\n return new Response(fallbackSitemap, { \n status: 200, \n headers: new Headers({\n 'Content-Type': 'application/xml; charset=utf-8',\n 'Cache-Control': 'public, max-age=300' // Shorter cache on error\n })\n });\n }\n}",[],[199],{"_102":206,"_95":207,"_151":208,"_153":-5,"_154":136,"_155":209,"_157":158,"_104":210,"_99":32,"_161":162,"_163":211,"_165":22,"_166":-5,"_167":212,"_98":213},"02c341d8-bd8e-11f0-bc30-42dde27851f2","futq498qf91tvq4q69s056q3f1e1694e8s.ts","02c34282-bd8e-11f0-bc30-42dde27851f2",9,["D",1762707807777],"import { PlatformClient } from \"npm:@kliv/platform-sdk@latest\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n const body = await req.json();\n const { existingPageKeys, skipExisting = true } = body;\n \n const sdkUrl = req.headers.get(\"x-sdk-url\");\n const platform = new PlatformClient(\n req.headers.get(\"x-platform-token\"),\n req.headers.get(\"x-api-base-url\")\n );\n\n console.log('🚀 Starting migration via edge function...');\n \n // Get existing page keys if not provided\n const existingKeys = new Set(existingPageKeys || []);\n \n // Scan the content filesystem for landing pages\n const { files } = await platform.listContentFiles('/content/landing-pages/');\n \n // Filter for JSON files only\n const jsonFiles = files.filter(file => file.path.endsWith('.json'));\n \n let addedCount = 0;\n const processedFiles = [];\n\n // Get database connection\n const dbUrl = req.headers.get(\"x-database-url\");\n const dbToken = req.headers.get(\"x-database-token\");\n \n // Use Turso driver for database operations\n const { connect } = await import(\"npm:@tursodatabase/serverless\");\n const conn = connect({\n url: dbUrl,\n authToken: dbToken\n });\n\n for (const file of jsonFiles) {\n try {\n // Extract category and slug from path\n const pathParts = file.path.split('/');\n const lang = pathParts[2]; // /content/landing-pages/lang/category/.../file.json\n const category = pathParts[3];\n const slug = pathParts[pathParts.length - 1].replace('.json', '');\n \n if (!category || !lang || lang !== 'en') {\n continue; // Skip non-English files for now\n }\n\n // Skip if this page already exists\n const pageKey = `${slug}|${category}`;\n if (skipExisting && existingKeys.has(pageKey)) {\n continue;\n }\n\n // Read the file content\n const content = await platform.getContentFile(file.path);\n const data = JSON.parse(content.toString());\n \n if (!data.title || !data.description) {\n continue;\n }\n\n // Extract sections data\n const sections = JSON.stringify(data.sections || []);\n const features = JSON.stringify(data.features || []);\n const tags = JSON.stringify(data.tags || []);\n\n // Insert the landing page\n await conn.prepare(`\n INSERT OR IGNORE INTO landing_pages (\n slug, category_name, title, description, default_prompt, \n meta_description, hero_title, hero_subtitle, hero_cta, \n sections, file_path\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `).run([\n slug,\n category,\n data.title,\n data.description,\n data.defaultPrompt || '',\n data.metaDescription || data.description,\n data.hero?.title || data.title,\n data.hero?.subtitle || data.description,\n data.hero?.cta || 'Get Started',\n sections,\n file.path\n ]);\n\n // Insert inspiration entry\n await conn.prepare(`\n INSERT OR IGNORE INTO inspiration_entries (\n category_name, category_slug, page_title, page_slug, \n page_description, url, subcategory, features, tags\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n `).run([\n category,\n category,\n data.title,\n slug,\n data.description,\n `/${lang}/${category}/${slug}`,\n null, // subcategory would need more complex path parsing\n features,\n tags\n ]);\n\n addedCount++;\n console.log(`✅ Added: ${category}/${slug}`);\n processedFiles.push(`${category}/${slug}`);\n \n } catch (error) {\n console.warn(`⚠️ Could not process ${file.path}:`, error.message);\n }\n }\n\n // Get final counts\n const finalPages = await conn.prepare(\"SELECT COUNT(*) as count FROM landing_pages\").get();\n const finalCategories = await conn.prepare(\"SELECT COUNT(*) as count FROM landing_categories\").get();\n\n console.log(`🎉 Migration completed! Added ${addedCount} new pages.`);\n console.log(`📈 Final counts: ${finalPages?.count || 0} pages, ${finalCategories?.count || 0} categories`);\n\n return Response.json({\n success: true,\n addedCount,\n totalProcessedFiles: processedFiles.length,\n processedFiles,\n finalCounts: {\n pages: finalPages?.count || 0,\n categories: finalCategories?.count || 0\n }\n });\n\n } catch (error) {\n console.error('❌ Migration failed:', error);\n return Response.json({\n success: false,\n error: error.message\n }, { status: 500 });\n }\n}",[],[207],{"_102":215,"_95":216,"_151":217,"_153":-5,"_154":136,"_155":218,"_157":158,"_104":219,"_99":32,"_161":162,"_163":220,"_165":22,"_166":-5,"_167":221,"_98":222},"881a9dd2-bd7e-11f0-a5b9-42dde27851f2","futv6v5f568f5144s5953v1s45ee920t01.ts","881a9ec2-bd7e-11f0-a5b9-42dde27851f2",3,["D",1762701159541],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\")\n });\n\n try {\n const url = new URL(req.url);\n const category = url.searchParams.get('category');\n const slug = url.searchParams.get('slug');\n const categorySlug = url.searchParams.get('categorySlug');\n\n let query = `\n SELECT \n (lp.slug || '/' || lc.slug) as url,\n lp.slug as page_slug,\n lp.title,\n lp.description,\n lp.default_prompt as defaultPrompt,\n lp.meta_description as metaDescription,\n lp.hero_title as \"hero.title\",\n lp.hero_subtitle as \"hero.subtitle\", \n lp.hero_cta as \"hero.cta\",\n lp.sections,\n lc.name as category_name,\n lc.slug as category_slug\n FROM landing_pages lp\n JOIN landing_categories lc ON lp.category_name = lc.name\n WHERE lp._deleted = 0 AND lc._deleted = 0\n `;\n\n const params = [];\n\n if (slug && categorySlug) {\n query += \" AND lp.slug = ? AND lc.slug = ?\";\n params.push(slug, categorySlug);\n } else if (categorySlug) {\n query += \" AND lc.slug = ?\";\n params.push(categorySlug);\n } else if (category) {\n query += \" AND lc.name = ?\";\n params.push(category);\n }\n\n query += \" ORDER BY lc.display_order, lp.title\";\n\n const stmt = conn.prepare(query);\n const results = await stmt.all(params);\n\n // Parse sections JSON for each result\n const processedResults = results.rows.map(row => ({\n ...row,\n sections: JSON.parse(row.sections || '[]')\n }));\n\n return Response.json(processedResults);\n\n } catch (error: any) {\n console.error('Error fetching landing pages:', error);\n return Response.json({\n error: 'Failed to fetch landing pages',\n message: error.message\n }, { status: 500 });\n }\n}",[],[216],"files",[148,170,179,188,197,205,214],"counts",{"_227":32,"_228":175,"_229":32,"_230":231},"pulls","branches","forks","envVars",{"_232":32,"_233":32},"count","emptyCount","contents",[236,239,242,245,248,251,254],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":156,"_157":158,"_104":237,"_99":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":238},["D",1762704023541],[150],{"_102":171,"_95":172,"_151":173,"_153":-5,"_154":136,"_155":160,"_157":158,"_104":240,"_99":175,"_161":162,"_163":176,"_165":22,"_166":-5,"_98":241},["D",1762701130043],[172],{"_102":180,"_95":181,"_151":182,"_153":-5,"_154":136,"_155":183,"_157":158,"_104":243,"_99":32,"_161":162,"_163":185,"_165":22,"_166":-5,"_98":244},["D",1762701161381],[181],{"_102":189,"_95":190,"_151":191,"_153":-5,"_154":136,"_155":192,"_157":158,"_104":246,"_99":32,"_161":162,"_163":194,"_165":22,"_166":-5,"_98":247},["D",1762702651404],[190],{"_102":198,"_95":199,"_151":200,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":249,"_99":175,"_161":162,"_163":202,"_165":22,"_166":-5,"_98":250},["D",1762712469300],[199],{"_102":206,"_95":207,"_151":208,"_153":-5,"_154":136,"_155":209,"_157":158,"_104":252,"_99":32,"_161":162,"_163":211,"_165":22,"_166":-5,"_98":253},["D",1762707807777],[207],{"_102":215,"_95":216,"_151":217,"_153":-5,"_154":136,"_155":218,"_157":158,"_104":255,"_99":32,"_161":162,"_163":220,"_165":22,"_166":-5,"_98":256},["D",1762701159541],[216],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.remixes",{"_93":94,"_95":96,"_100":266,"_229":271,"_272":-5},{"_102":103,"_95":96,"_104":267,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":268,"_130":269,"_133":270,"_145":22},["D",1762701127718],{"_93":94,"_128":129},{"_93":94,"_132":129,"_14":112},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},[],"upstream","actionData","errors"]