[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_234":235,"_236":237},"routes/_app.x.$handle.$name",{"_94":93,"_31":43,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":56,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","fu1688f8e6s9fq427795s3v55e2s558ff2.ts","latestPath","fileId","dc98edf8-c4c9-11f0-b8e3-42dde27851f2","name","fileType","http","content","import { sendEmail } from \"npm:@kliv/sdk@1\";\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 // Only allow POST requests\n if (req.method !== 'POST') {\n return Response.json({ \n error: 'Method not allowed' \n }, { status: 405 });\n }\n\n try {\n const body = await req.json();\n const { name, email, subject, message } = body;\n\n // Validate required fields\n if (!name || !email || !subject || !message) {\n return Response.json({ \n error: 'All fields are required' \n }, { status: 400 });\n }\n\n // Basic email validation\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(email)) {\n return Response.json({ \n error: 'Invalid email address' \n }, { status: 400 });\n }\n\n // Prepare email content\n const emailHtml = `\n

New Contact Form Submission

\n \n

Name: ${name}

Email: ${email}

Subject: ${subject}

\n \n

Message:

${message}

\n \n

\n This message was sent via the Kliv contact form.\n

\n `;\n\n // Send email to hello@kliv.dev\n await sendEmail({\n to: 'hello@kliv.dev',\n subject: `Kliv Contact: ${subject}`,\n html: emailHtml,\n replyTo: email\n });\n\n return Response.json({ \n success: true, \n message: 'Email sent successfully' \n }, { status: 200 });\n\n } catch (error) {\n console.error('Contact form error:', error);\n return Response.json({ \n error: 'Failed to send email' \n }, { status: 500 });\n }\n}","createdAt",["D",1763503171688],"branchVersion","branchId","75233a9a-bd7e-11f0-aa40-42dde27851f2","id","7522b764-bd7e-11f0-aa40-42dde27851f2","te34692sv97882490490s4f832ssf880vf",["D",1762701127718],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","0199d9f9-8fb9-705d-a1be-150ee5ea0145","pinnedFileId","c9b6e12e-bd83-11f0-95e4-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","0199d9f9-8fb9-705d-a1be-18ed6d1d02d7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":52,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_41":40,"_85":42,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":43,"_92":93},"isOwned",26,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kliv","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzMzeW9MdTZSSlZXdUFyNHFTckJtSlg1b3paYiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":230,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":231,"_78":232,"_80":233,"_82":24},"tree",[197,198,199,200,201,202,203,204],"files",[197,198,199,200,201,202,203,204],"counts",{"_187":60,"_188":154,"_189":60,"_190":191,"_192":193},"contents",[124,125,126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":181,"_31":182,"_29":54,"_135":-5,"_39":40,"_38":183,"_137":56,"_36":184,"_13":177,"_32":33,"_34":185,"_23":24,"_140":-5,"_26":186},{"_41":174,"_31":175,"_29":176,"_135":-5,"_39":40,"_38":177,"_137":56,"_36":178,"_13":154,"_32":33,"_34":179,"_23":24,"_140":-5,"_26":180},{"_41":171,"_31":27,"_29":30,"_135":-5,"_39":40,"_38":14,"_137":24,"_36":172,"_13":60,"_32":33,"_34":35,"_23":24,"_140":-5,"_26":173},{"_41":164,"_31":165,"_29":166,"_135":-5,"_39":40,"_38":167,"_137":56,"_36":168,"_13":60,"_32":33,"_34":169,"_23":24,"_140":-5,"_26":170},{"_41":157,"_31":158,"_29":159,"_135":-5,"_39":40,"_38":160,"_137":56,"_36":161,"_13":60,"_32":33,"_34":162,"_23":24,"_140":-5,"_26":163},{"_41":149,"_31":150,"_29":151,"_135":-5,"_39":40,"_38":152,"_137":56,"_36":153,"_13":154,"_32":33,"_34":155,"_23":24,"_140":-5,"_26":156},{"_41":142,"_31":143,"_29":144,"_135":-5,"_39":40,"_38":145,"_137":56,"_36":146,"_13":60,"_32":33,"_34":147,"_23":24,"_140":-5,"_26":148},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":56,"_36":138,"_13":60,"_32":33,"_34":139,"_23":24,"_140":-5,"_26":141},"881a9dd2-bd7e-11f0-a5b9-42dde27851f2","futv6v5f568f5144s5953v1s45ee920t01.ts","881a9ec2-bd7e-11f0-a5b9-42dde27851f2","parentId",3,"latest",["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}","label",[133],"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}",[143],"dd3f7c82-bd98-11f0-b645-42dde27851f2","fuet253012v46340518s23t089711243tq.ts","86d69d94-bd98-11f0-bb52-42dde27851f2",11,["D",1762712469300],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 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}",[150],"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}",[158],"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}",[165],"dc98ed12-c4c9-11f0-b8e3-42dde27851f2",["D",1763503171688],[27],"7686071e-bd7e-11f0-8042-42dde27851f2","fu1031qqf345s045q685539fe87t0q3q2s.ts","752fa1b8-bd7e-11f0-abc4-42dde27851f2",2,["D",1762701130043],"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}",[175],"332e9c7c-bd85-11f0-8087-42dde27851f2","fu0sq6574255984qs8qv9016e9t1350159.ts",8,["D",1762704023541],"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}",[182],"pulls","branches","forks","envVars",{"_194":60,"_196":60},"connections",{"_194":60,"_195":60},"count","unfilledCount","emptyCount",{"_41":181,"_31":182,"_29":54,"_135":-5,"_39":40,"_38":183,"_137":56,"_36":227,"_13":177,"_32":33,"_34":185,"_23":24,"_140":-5,"_206":228,"_26":229},{"_41":174,"_31":175,"_29":176,"_135":-5,"_39":40,"_38":177,"_137":56,"_36":224,"_13":154,"_32":33,"_34":179,"_23":24,"_140":-5,"_206":225,"_26":226},{"_41":171,"_31":27,"_29":30,"_135":-5,"_39":40,"_38":14,"_137":24,"_36":221,"_13":60,"_32":33,"_34":35,"_23":24,"_140":-5,"_206":222,"_26":223},{"_41":164,"_31":165,"_29":166,"_135":-5,"_39":40,"_38":167,"_137":56,"_36":218,"_13":60,"_32":33,"_34":169,"_23":24,"_140":-5,"_206":219,"_26":220},{"_41":157,"_31":158,"_29":159,"_135":-5,"_39":40,"_38":160,"_137":56,"_36":215,"_13":60,"_32":33,"_34":162,"_23":24,"_140":-5,"_206":216,"_26":217},{"_41":149,"_31":150,"_29":151,"_135":-5,"_39":40,"_38":152,"_137":56,"_36":212,"_13":154,"_32":33,"_34":155,"_23":24,"_140":-5,"_206":213,"_26":214},{"_41":142,"_31":143,"_29":144,"_135":-5,"_39":40,"_38":145,"_137":56,"_36":209,"_13":60,"_32":33,"_34":147,"_23":24,"_140":-5,"_206":210,"_26":211},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":56,"_36":205,"_13":60,"_32":33,"_34":139,"_23":24,"_140":-5,"_206":207,"_26":208},["D",1762701159541],"children",[],[133],["D",1762707807777],[],[143],["D",1762712469300],[],[150],["D",1762702651404],[],[158],["D",1762701161381],[],[165],["D",1763503171688],[],[27],["D",1762701130043],[],[175],["D",1762704023541],[],[182],["D",1762701127718],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":52,"_98":99,"_100":24},{"_13":83,"_31":84,"_41":40,"_85":42,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":43,"_92":93},"ctx",{"_76":-5,"_121":267,"_268":269,"_270":271,"_272":24,"_273":24,"_274":24,"_275":56,"_276":-5,"_277":-7,"_278":-7,"_279":60,"_280":24,"_281":24,"_282":-5,"_283":24,"_284":24,"_285":24,"_286":-5},"ENV",{"_238":239,"_240":241,"_242":84,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v12