[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_187":188,"_189":190},"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",5,"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","fue7v09f99fs204s45s90s3vqsf6s30f04.ts","latestPath","fileId","0153264e-bd82-11f0-b059-42dde27851f2","name","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 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}","createdAt",["D",1762702651404],"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":183,"_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":184,"_78":185,"_80":186,"_82":24},"tree",[166,167,168,169],"files",[166,167,168,169],"counts",{"_156":60,"_157":153,"_158":60,"_159":160,"_161":162},"contents",[124,125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":148,"_31":149,"_29":150,"_131":-5,"_39":40,"_38":151,"_133":56,"_36":152,"_13":153,"_32":33,"_34":154,"_23":24,"_136":-5,"_26":155},{"_41":141,"_31":142,"_29":143,"_131":-5,"_39":40,"_38":144,"_133":56,"_36":145,"_13":60,"_32":33,"_34":146,"_23":24,"_136":-5,"_26":147},{"_41":138,"_31":27,"_29":30,"_131":-5,"_39":40,"_38":14,"_133":56,"_36":139,"_13":60,"_32":33,"_34":35,"_23":24,"_136":-5,"_26":140},{"_41":128,"_31":129,"_29":130,"_131":-5,"_39":40,"_38":132,"_133":56,"_36":134,"_13":60,"_32":33,"_34":135,"_23":24,"_136":-5,"_26":137},"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",[129],"0153255e-bd82-11f0-b059-42dde27851f2",["D",1762702651404],[27],"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}",[142],"7686071e-bd7e-11f0-8042-42dde27851f2","fu1031qqf345s045q685539fe87t0q3q2s.ts","752fa1b8-bd7e-11f0-abc4-42dde27851f2",2,["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}",[149],"pulls","branches","forks","envVars",{"_163":60,"_165":60},"connections",{"_163":60,"_164":60},"count","unfilledCount","emptyCount",{"_41":148,"_31":149,"_29":150,"_131":-5,"_39":40,"_38":151,"_133":56,"_36":180,"_13":153,"_32":33,"_34":154,"_23":24,"_136":-5,"_171":181,"_26":182},{"_41":141,"_31":142,"_29":143,"_131":-5,"_39":40,"_38":144,"_133":56,"_36":177,"_13":60,"_32":33,"_34":146,"_23":24,"_136":-5,"_171":178,"_26":179},{"_41":138,"_31":27,"_29":30,"_131":-5,"_39":40,"_38":14,"_133":56,"_36":174,"_13":60,"_32":33,"_34":35,"_23":24,"_136":-5,"_171":175,"_26":176},{"_41":128,"_31":129,"_29":130,"_131":-5,"_39":40,"_38":132,"_133":56,"_36":170,"_13":60,"_32":33,"_34":135,"_23":24,"_136":-5,"_171":172,"_26":173},["D",1762701159541],"children",[],[129],["D",1762702651404],[],[27],["D",1762701161381],[],[142],["D",1762701130043],[],[149],["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":220,"_221":222,"_223":224,"_225":24,"_226":24,"_227":24,"_228":56,"_229":-5,"_230":-7,"_231":-7,"_232":60,"_233":24,"_234":24,"_235":-5,"_236":24,"_237":24,"_238":24,"_239":-5},"ENV",{"_191":192,"_193":194,"_195":84,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v5