[{"_1":2,"_276":-5,"_277":-5},"loaderData",{"_3":4,"_92":93,"_240":241},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22,"_34":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","isTeamOrgMember","ENV",{"_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":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","48807a73dfb4c250ae0af97d07e94d04aadb2cac","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",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":22,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":22,"_91":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",{"_82":22,"_21":22,"_83":73,"_84":85,"_86":73,"_87":46,"_88":22,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_94":95,"_96":97,"_98":44,"_99":100,"_101":102,"_103":104,"_152":153,"_217":218,"_219":220,"_228":229,"_230":231,"_234":-5,"_235":-5,"_236":22,"_237":22,"_238":239},"handle","kliv","name","te34692sv97882490490s4f832ssf880vf","branchName","path","futq498qf91tvq4q69s056q3f1e1694e8s.ts","version",9,"project",{"_105":106,"_96":97,"_107":108,"_109":-5,"_110":22,"_111":112,"_113":-5,"_114":-5,"_14":115,"_116":117,"_118":119,"_120":119,"_121":-5,"_122":32,"_16":123,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":133,"_136":137,"_139":140,"_151":22},"id","7522b764-bd7e-11f0-aa40-42dde27851f2","createdAt",["D",1762701127718],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","0199d9f9-8fb9-705d-a1be-150ee5ea0145","pinnedFileId","c9b6e12e-bd83-11f0-95e4-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","0199d9f9-8fb9-705d-a1be-18ed6d1d02d7","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_134":135},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzMzeW9MdTZSSlZXdUFyNHFTckJtSlg1b3paYiJ9","org",{"_94":95,"_138":135,"_14":115},"avatar","branch",{"_101":141,"_96":44,"_105":142,"_143":106,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":97,"_150":95},26,"75233a9a-bd7e-11f0-aa40-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[154,174,183,192,201,208],{"_105":155,"_96":156,"_157":117,"_158":-5,"_159":142,"_160":161,"_162":119,"_107":163,"_101":164,"_165":166,"_167":168,"_169":22,"_170":-5,"_171":172,"_99":173},"332e9c7c-bd85-11f0-8087-42dde27851f2","fu0sq6574255984qs8qv9016e9t1350159.ts","fileId","parentId","branchId","branchVersion",8,"latest",["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",[],[156],{"_105":175,"_96":176,"_157":177,"_158":-5,"_159":142,"_160":164,"_162":119,"_107":178,"_101":179,"_165":166,"_167":180,"_169":22,"_170":-5,"_171":181,"_99":182},"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}",[],[176],{"_105":184,"_96":185,"_157":186,"_158":-5,"_159":142,"_160":187,"_162":119,"_107":188,"_101":32,"_165":166,"_167":189,"_169":22,"_170":-5,"_171":190,"_99":191},"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}",[],[185],{"_105":193,"_96":194,"_157":195,"_158":-5,"_159":142,"_160":196,"_162":119,"_107":197,"_101":32,"_165":166,"_167":198,"_169":22,"_170":-5,"_171":199,"_99":200},"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}",[],[194],{"_105":202,"_96":100,"_157":203,"_158":-5,"_159":142,"_160":102,"_162":119,"_107":204,"_101":32,"_165":166,"_167":205,"_169":22,"_170":-5,"_171":206,"_99":207},"02c341d8-bd8e-11f0-bc30-42dde27851f2","02c34282-bd8e-11f0-bc30-42dde27851f2",["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}",[],[100],{"_105":209,"_96":210,"_157":211,"_158":-5,"_159":142,"_160":212,"_162":119,"_107":213,"_101":32,"_165":166,"_167":214,"_169":22,"_170":-5,"_171":215,"_99":216},"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}",[],[210],"files",[154,174,183,192,201,208],"counts",{"_221":32,"_222":179,"_223":32,"_224":225},"pulls","branches","forks","envVars",{"_226":32,"_227":32},"count","emptyCount","contents",[],"file",{"_105":202,"_96":100,"_157":203,"_158":-5,"_159":142,"_160":102,"_162":119,"_107":232,"_101":32,"_165":166,"_167":205,"_169":22,"_170":-5,"_99":233},["D",1762707807777],[100],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_94":95,"_96":97,"_98":44,"_101":102,"_99":100,"_103":242,"_152":247,"_217":266,"_230":267,"_228":269,"_270":-5,"_271":-5,"_272":-5,"_273":-5,"_274":275,"_224":-5},{"_105":106,"_96":97,"_107":243,"_109":-5,"_110":22,"_111":112,"_113":-5,"_114":-5,"_14":115,"_116":117,"_118":119,"_120":119,"_121":-5,"_122":32,"_16":123,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":244,"_136":245,"_139":246,"_151":22},["D",1762701127718],{"_94":95,"_134":135},{"_94":95,"_138":135,"_14":115},{"_101":141,"_96":44,"_105":142,"_143":106,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":97,"_150":95},[248,251,254,257,260,263],{"_105":155,"_96":156,"_157":117,"_158":-5,"_159":142,"_160":161,"_162":119,"_107":163,"_101":164,"_165":166,"_167":168,"_169":22,"_170":-5,"_171":249,"_99":250},[],[156],{"_105":175,"_96":176,"_157":177,"_158":-5,"_159":142,"_160":164,"_162":119,"_107":178,"_101":179,"_165":166,"_167":180,"_169":22,"_170":-5,"_171":252,"_99":253},[],[176],{"_105":184,"_96":185,"_157":186,"_158":-5,"_159":142,"_160":187,"_162":119,"_107":188,"_101":32,"_165":166,"_167":189,"_169":22,"_170":-5,"_171":255,"_99":256},[],[185],{"_105":193,"_96":194,"_157":195,"_158":-5,"_159":142,"_160":196,"_162":119,"_107":197,"_101":32,"_165":166,"_167":198,"_169":22,"_170":-5,"_171":258,"_99":259},[],[194],{"_105":202,"_96":100,"_157":203,"_158":-5,"_159":142,"_160":102,"_162":119,"_107":204,"_101":32,"_165":166,"_167":205,"_169":22,"_170":-5,"_171":261,"_99":262},[],[100],{"_105":209,"_96":210,"_157":211,"_158":-5,"_159":142,"_160":212,"_162":119,"_107":213,"_101":32,"_165":166,"_167":214,"_169":22,"_170":-5,"_171":264,"_99":265},[],[210],[248,251,254,257,260,263],{"_105":202,"_96":100,"_157":203,"_158":-5,"_159":142,"_160":102,"_162":119,"_107":232,"_101":32,"_165":166,"_167":205,"_169":22,"_170":-5,"_99":268},[100],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]