[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_377":378,"_379":380},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_278":-5,"_20":279,"_22":280,"_281":282,"_283":284,"_26":285,"_24":286,"_287":-5,"_288":-5,"_289":57,"_290":291,"_292":49,"_293":-5,"_294":-5,"_295":296},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","charmaine","name","testtownie","branchName","main","version","path","frontend","project",{"_37":225,"_13":14,"_50":226,"_227":-5,"_228":57,"_229":230,"_231":230,"_232":-5,"_233":-5,"_234":235,"_236":179,"_237":49,"_238":-5,"_239":-5,"_240":52,"_241":242,"_243":-5,"_244":-5,"_245":-5,"_246":-5,"_247":248,"_249":248,"_250":251,"_252":251,"_253":251,"_254":248,"_255":248,"_256":257,"_258":259,"_260":261,"_262":57},"tree",[85,86,87,88],"file",{"_37":82,"_13":19,"_40":43,"_42":-5,"_44":45,"_46":71,"_48":49,"_50":83,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_18":84},"contents",[33,34,35,36],"upstream","pull","ahead","behind","envVars",{"_37":75,"_13":76,"_40":77,"_42":43,"_44":45,"_46":78,"_48":49,"_50":79,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_18":81},{"_37":68,"_13":69,"_40":70,"_42":43,"_44":45,"_46":71,"_48":49,"_50":72,"_17":52,"_53":24,"_54":73,"_56":57,"_58":-5,"_18":74},{"_37":60,"_13":61,"_40":62,"_42":43,"_44":45,"_46":63,"_48":49,"_50":64,"_17":52,"_53":65,"_54":66,"_56":57,"_58":-5,"_18":67},{"_37":38,"_13":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_17":52,"_53":24,"_54":55,"_56":57,"_58":-5,"_18":59},"id","cd7dded0-2c37-11f0-b57c-569c3dd06744","test.html","fileId","cd7de114-2c37-11f0-b57c-569c3dd06744","parentId","6cd2b22e-6328-441f-a133-f4fbb7c4d9a0","branchId","38b20524-2c37-11f0-abee-569c3dd06744","branchVersion",14,"latest",true,"createdAt",["D",1746727863083],0,"fileType","content","\n\n\n \n \n TEST BIG\n \n \n\n\n

TEST

BIG

\n \n \n\n","deleted",false,"label",[19,39],"7fa6a926-2c37-11f0-99d4-569c3dd06744","index.tsx","7fa6a9e4-2c37-11f0-99d4-569c3dd06744",8,["D",1746727732486],"script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { BrowserRouter, Routes, Route, useParams, Link, useNavigate } from \"https://esm.sh/react-router-dom@6.20.1?deps=react@18.2.0\";\nimport { PostWithTags } from \"../shared/types.ts\";\nimport { Header } from \"./components/Header.tsx\";\nimport { Footer } from \"./components/Footer.tsx\";\nimport { PostList } from \"./components/PostList.tsx\";\nimport { PostView } from \"./components/PostView.tsx\";\n\n// Main App component\nfunction App() {\n return (\n \n

\n \n } />\n } />\n } />\n \n

\n \n );\n}\n\n// Home page component\nfunction Home() {\n const [posts, setPosts] = React.useState([]);\n const [loading, setLoading] = React.useState(true);\n const [error, setError] = React.useState(null);\n\n React.useEffect(() => {\n async function fetchPosts() {\n try {\n const response = await fetch('/api/posts');\n if (!response.ok) {\n throw new Error('Failed to fetch posts');\n }\n const data = await response.json();\n setPosts(data.posts);\n } catch (err) {\n setError('Failed to load blog posts. Please try again later.');\n console.error(err);\n } finally {\n setLoading(false);\n }\n }\n\n fetchPosts();\n }, []);\n\n if (loading) {\n return (\n

\n );\n }\n\n if (error) {\n return (\n

{error}

\n );\n }\n\n return ;\n}\n\n// Single post page component\nfunction Post() {\n const { slug } = useParams<{ slug: string }>();\n const [post, setPost] = React.useState(null);\n const [loading, setLoading] = React.useState(true);\n const [error, setError] = React.useState(null);\n const navigate = useNavigate();\n\n React.useEffect(() => {\n async function fetchPost() {\n if (!slug) return;\n \n try {\n const response = await fetch(`/api/posts/${slug}`);\n if (response.status === 404) {\n navigate('/not-found');\n return;\n }\n if (!response.ok) {\n throw new Error('Failed to fetch post');\n }\n const data = await response.json();\n setPost(data.post);\n } catch (err) {\n setError('Failed to load blog post. Please try again later.');\n console.error(err);\n } finally {\n setLoading(false);\n }\n }\n\n fetchPost();\n }, [slug, navigate]);\n\n if (loading) {\n return (\n

\n );\n }\n\n if (error) {\n return (\n

{error}

\n );\n }\n\n if (!post) {\n return (\n

Post not found

The blog post you're looking for doesn't exist or has been removed.

\n \n Back to Home\n \n

\n );\n }\n\n return ;\n}\n\n// 404 Not Found component\nfunction NotFound() {\n return (\n

Page Not Found

The page you're looking for doesn't exist or has been moved.

\n \n Back to Home\n \n

\n );\n}\n\n// Render the app\nconst root = createRoot(document.getElementById('app')!);\nroot.render();",[19,61],"7430f25e-2c37-11f0-9ddf-569c3dd06744","index.html","7430f2f4-2c37-11f0-9ddf-569c3dd06744",7,["D",1746727713260],"\n\n\n \n \n Beautiful Blog\n \n \n \n \n \n \n \n\n\n

\n \n\n",[19,69],"852d8fe0-2c37-11f0-a478-569c3dd06744","components","20d14ce9-ac17-4948-bcb1-0d322348aa17",9,["D",1746727741753],"directory",[19,76],"743115b8-2c37-11f0-9ddf-569c3dd06744",["D",1746727713260],[19],{"_37":167,"_13":168,"_40":169,"_42":-5,"_44":45,"_46":170,"_48":49,"_50":171,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":172,"_18":173},{"_37":82,"_13":19,"_40":43,"_42":-5,"_44":45,"_46":71,"_48":49,"_50":113,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":114,"_18":115},{"_37":98,"_13":99,"_40":100,"_42":-5,"_44":45,"_46":101,"_48":49,"_50":102,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":103,"_18":104},{"_37":89,"_13":90,"_40":91,"_42":-5,"_44":45,"_46":92,"_48":49,"_50":93,"_17":52,"_53":24,"_54":94,"_56":57,"_58":-5,"_95":96,"_18":97},"471a6692-2c37-11f0-a1d8-569c3dd06744","README.md","471a675a-2c37-11f0-a1d8-569c3dd06744",1,["D",1746727637595],"# Beautiful Blog\n\nA modern, elegant blog built on Val Town with a clean design and simple content management.\n\n## Features\n\n- Clean, responsive design with Tailwind CSS\n- Markdown support for blog posts\n- SQLite database for content storage\n- API endpoints for managing blog content\n- Beautiful typography and reading experience\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ └── queries.ts # DB query functions\n│ ├── routes/ # Route modules\n│ │ ├── posts.ts # Blog post routes\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main entry point\n├── frontend/\n│ ├── components/\n│ │ ├── Header.tsx # Blog header\n│ │ ├── Footer.tsx # Blog footer\n│ │ ├── PostList.tsx # List of blog posts\n│ │ └── PostView.tsx # Single post view\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend JS entry point\n└── shared/\n └── types.ts # Shared types\n```\n\n## Getting Started\n\nVisit the blog at the HTTP endpoint URL. To add new posts, use the `/admin` route.","children",[],[90],"65c7571c-2c37-11f0-bcb4-569c3dd06744","shared","a090259e-2fa0-4432-addf-7a1dda28d076",5,["D",1746727689078],[105],[99],{"_37":106,"_13":107,"_40":108,"_42":100,"_44":45,"_46":101,"_48":49,"_50":109,"_17":52,"_53":65,"_54":110,"_56":57,"_58":-5,"_95":111,"_18":112},"65c725a8-2c37-11f0-bcb4-569c3dd06744","types.ts","65c7267a-2c37-11f0-bcb4-569c3dd06744",["D",1746727689078],"/**\n * Blog post type\n */\nexport interface Post {\n id: number;\n title: string;\n slug: string;\n content: string;\n excerpt?: string;\n publishedAt: number; // timestamp\n updatedAt?: number; // timestamp\n isPublished: boolean;\n featuredImage?: string;\n}\n\n/**\n * Tag type\n */\nexport interface Tag {\n id: number;\n name: string;\n slug: string;\n}\n\n/**\n * Post with associated tags\n */\nexport interface PostWithTags extends Post {\n tags: Tag[];\n}\n\n/**\n * API response for posts list\n */\nexport interface PostsResponse {\n posts: PostWithTags[];\n total: number;\n}\n\n/**\n * API response for a single post\n */\nexport interface PostResponse {\n post: PostWithTags;\n}\n\n/**\n * API response for tags list\n */\nexport interface TagsResponse {\n tags: Tag[];\n}",[],[99,107],["D",1746727713260],[116,117,118,119],[19],{"_37":75,"_13":76,"_40":77,"_42":43,"_44":45,"_46":78,"_48":49,"_50":129,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":130,"_18":131},{"_37":68,"_13":69,"_40":70,"_42":43,"_44":45,"_46":71,"_48":49,"_50":126,"_17":52,"_53":24,"_54":73,"_56":57,"_58":-5,"_95":127,"_18":128},{"_37":60,"_13":61,"_40":62,"_42":43,"_44":45,"_46":63,"_48":49,"_50":123,"_17":52,"_53":65,"_54":66,"_56":57,"_58":-5,"_95":124,"_18":125},{"_37":38,"_13":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":120,"_17":52,"_53":24,"_54":55,"_56":57,"_58":-5,"_95":121,"_18":122},["D",1746727863083],[],[19,39],["D",1746727732486],[],[19,61],["D",1746727713260],[],[19,69],["D",1746727741753],[132,133,134,135],[19,76],{"_37":159,"_13":160,"_40":161,"_42":77,"_44":45,"_46":162,"_48":49,"_50":163,"_17":52,"_53":65,"_54":164,"_56":57,"_58":-5,"_95":165,"_18":166},{"_37":152,"_13":153,"_40":154,"_42":77,"_44":45,"_46":78,"_48":49,"_50":155,"_17":52,"_53":65,"_54":156,"_56":57,"_58":-5,"_95":157,"_18":158},{"_37":144,"_13":145,"_40":146,"_42":77,"_44":45,"_46":147,"_48":49,"_50":148,"_17":52,"_53":65,"_54":149,"_56":57,"_58":-5,"_95":150,"_18":151},{"_37":136,"_13":137,"_40":138,"_42":77,"_44":45,"_46":139,"_48":49,"_50":140,"_17":52,"_53":65,"_54":141,"_56":57,"_58":-5,"_95":142,"_18":143},"a7481c1c-2c37-11f0-8318-569c3dd06744","PostView.tsx","a7481cc6-2c37-11f0-8318-569c3dd06744",12,["D",1746727798975],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Link } from \"https://esm.sh/react-router-dom@6.20.1?deps=react@18.2.0\";\nimport { PostWithTags } from \"../../shared/types.ts\";\n\n// @ts-ignore - marked is loaded from CDN\ndeclare const marked: any;\n// @ts-ignore - hljs is loaded from CDN\ndeclare const hljs: any;\n\ninterface PostViewProps {\n post: PostWithTags;\n}\n\nexport function PostView({ post }: PostViewProps) {\n // Format date\n const formatDate = (timestamp: number) => {\n return new Date(timestamp).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n };\n\n // Configure marked with syntax highlighting\n React.useEffect(() => {\n if (typeof marked !== 'undefined' && typeof hljs !== 'undefined') {\n marked.setOptions({\n highlight: function(code: string, language: string) {\n if (language && hljs.getLanguage(language)) {\n return hljs.highlight(code, { language }).value;\n }\n return hljs.highlightAuto(code).value;\n },\n breaks: true,\n gfm: true\n });\n }\n }, []);\n\n // Render markdown content\n const renderMarkdown = (content: string) => {\n if (typeof marked === 'undefined') {\n return content;\n }\n return { __html: marked.parse(content) };\n };\n\n return (\n

\n {/* Back button */}\n

\n \n \n Back to all posts\n \n

\n \n {/* Post header */}\n

{post.title}

\n {formatDate(post.publishedAt)}\n {post.tags.length > 0 && (\n <>\n •\n

\n {post.tags.map(tag => (\n \n {tag.name}\n \n ))}\n

\n \n )}\n

\n \n {/* Featured image */}\n {post.featuredImage && (\n

\n ${post.title}\n$ \n

\n )}\n

\n \n {/* Post content */}\n

\n \n {/* Post footer */}\n \n

\n );\n}",[],[19,76,137],"9a85af80-2c37-11f0-98bc-569c3dd06744","PostList.tsx","9a85b02a-2c37-11f0-98bc-569c3dd06744",11,["D",1746727777571],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Link } from \"https://esm.sh/react-router-dom@6.20.1?deps=react@18.2.0\";\nimport { PostWithTags } from \"../../shared/types.ts\";\n\ninterface PostListProps {\n posts: PostWithTags[];\n}\n\nexport function PostList({ posts }: PostListProps) {\n if (posts.length === 0) {\n return (\n

No Posts Found

There are no blog posts available at the moment. Check back later!

\n );\n }\n\n // Format date function\n const formatDate = (timestamp: number) => {\n return new Date(timestamp).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n };\n\n return (\n

Latest Posts

\n \n {/* Featured post (first post) */}\n {posts.length > 0 && (\n

\n \n

\n {posts[0].featuredImage && (\n

\n ${posts[0].title}\n$ \n

\n )}\n

\n {formatDate(posts[0].publishedAt)}\n •\n

\n {posts[0].tags.map(tag => (\n \n {tag.name}\n \n ))}\n

{posts[0].title}

\n {posts[0].excerpt || posts[0].content.substring(0, 150) + '...'}\n

\n Read more →\n

\n \n

\n )}\n \n {/* Rest of the posts in a grid */}\n

\n {posts.slice(1).map(post => (\n \n

\n {post.featuredImage && (\n

\n ${post.title}\n$ \n

\n )}\n

\n {formatDate(post.publishedAt)}\n {post.tags.length > 0 && (\n <>\n •\n

\n {post.tags.slice(0, 2).map(tag => (\n \n {tag.name}\n \n ))}\n {post.tags.length > 2 && (\n +{post.tags.length - 2}\n )}\n

\n \n )}\n

{post.title}

\n {post.excerpt || post.content.substring(0, 100) + '...'}\n

\n Read more →\n

\n \n ))}\n

\n );\n}",[],[19,76,145],"852d747e-2c37-11f0-a478-569c3dd06744","Header.tsx","852d750a-2c37-11f0-a478-569c3dd06744",["D",1746727741753],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Link } from \"https://esm.sh/react-router-dom@6.20.1?deps=react@18.2.0\";\n\nexport function Header() {\n return (\n

\n \n 📝\n

Beautiful Blog

\n \n

Thoughts, stories, and ideas

\n \n

\n );\n}",[],[19,76,153],"8d466954-2c37-11f0-81b4-569c3dd06744","Footer.tsx","8d466a26-2c37-11f0-81b4-569c3dd06744",10,["D",1746727755345],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { parseProject } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\nexport function Footer() {\n const currentYear = new Date().getFullYear();\n const projectInfo = React.useMemo(() => {\n try {\n // This will only work on the server side\n if (typeof window === 'undefined') {\n return parseProject(import.meta.url);\n }\n return null;\n } catch (e) {\n console.error(\"Error parsing project info:\", e);\n return null;\n }\n }, []);\n\n return (\n \n );\n}",[],[19,76,160],"4c0ee632-2c37-11f0-992d-569c3dd06744","backend","6cdf2377-46e4-4600-b8e5-ba7617fcb631",2,["D",1746727645920],[174,175,176],[168],{"_37":201,"_13":202,"_40":203,"_42":169,"_44":45,"_46":204,"_48":49,"_50":205,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":206,"_18":207},{"_37":186,"_13":187,"_40":188,"_42":169,"_44":45,"_46":189,"_48":49,"_50":190,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":191,"_18":192},{"_37":177,"_13":178,"_40":179,"_42":169,"_44":45,"_46":180,"_48":49,"_50":181,"_17":92,"_53":182,"_54":183,"_56":57,"_58":-5,"_95":184,"_18":185},"a928c018-2c37-11f0-bb56-569c3dd06744","index.ts","4c0ea9b0-2c37-11f0-992d-569c3dd06744",13,["D",1746727802123],"http","import { Hono } from \"https://esm.sh/hono@3.12.6\";\nimport { cors } from \"https://esm.sh/hono@3.12.6/middleware\";\nimport { serveFile, readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { createTables } from \"./database/migrations.ts\";\nimport { postRoutes } from \"./routes/posts.ts\";\n\n// Initialize the Hono app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(err);\n throw err;\n});\n\n// Set up CORS\napp.use(\"*\", cors());\n\n// Initialize database\ncreateTables().catch(console.error);\n\n// API routes\napp.route(\"/api\", postRoutes);\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve the main HTML page with initial data\napp.get(\"/*\", async c => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index.html:\", error);\n return c.text(\"Error loading the blog. Please try again later.\", 500);\n }\n});\n\n// Export the Hono app for HTTP val\nexport default app.fetch;",[],[168,178],"6abce534-2c37-11f0-8f14-569c3dd06744","routes","591421db-0ca7-4afe-9d37-86c6d6405982",6,["D",1746727697399],[193],[168,187],{"_37":194,"_13":195,"_40":196,"_42":188,"_44":45,"_46":189,"_48":49,"_50":197,"_17":52,"_53":65,"_54":198,"_56":57,"_58":-5,"_95":199,"_18":200},"6abcc20c-2c37-11f0-8f14-569c3dd06744","posts.ts","6abcc2de-2c37-11f0-8f14-569c3dd06744",["D",1746727697399],"import { Hono } from \"https://esm.sh/hono@3.12.6\";\nimport { getAllPosts, getPostBySlug, getAllTags } from \"../database/queries.ts\";\nimport { PostsResponse, PostResponse, TagsResponse } from \"../../shared/types.ts\";\n\n// Create a new Hono router\nexport const postRoutes = new Hono();\n\n/**\n * Get all published blog posts\n */\npostRoutes.get(\"/posts\", async (c) => {\n try {\n const posts = await getAllPosts();\n const response: PostsResponse = {\n posts,\n total: posts.length\n };\n return c.json(response);\n } catch (error) {\n console.error(\"Error fetching posts:\", error);\n return c.json({ error: \"Failed to fetch posts\" }, 500);\n }\n});\n\n/**\n * Get a single blog post by slug\n */\npostRoutes.get(\"/posts/:slug\", async (c) => {\n try {\n const slug = c.req.param(\"slug\");\n const post = await getPostBySlug(slug);\n \n if (!post) {\n return c.json({ error: \"Post not found\" }, 404);\n }\n \n const response: PostResponse = { post };\n return c.json(response);\n } catch (error) {\n console.error(\"Error fetching post:\", error);\n return c.json({ error: \"Failed to fetch post\" }, 500);\n }\n});\n\n/**\n * Get all tags\n */\npostRoutes.get(\"/tags\", async (c) => {\n try {\n const tags = await getAllTags();\n const response: TagsResponse = { tags };\n return c.json(response);\n } catch (error) {\n console.error(\"Error fetching tags:\", error);\n return c.json({ error: \"Failed to fetch tags\" }, 500);\n }\n});",[],[168,187,195],"55a4f056-2c37-11f0-80d7-569c3dd06744","database","c00b2a61-dd0b-45c2-800a-01bc27c202df",3,["D",1746727662010],[208,209],[168,202],{"_37":218,"_13":219,"_40":220,"_42":203,"_44":45,"_46":204,"_48":49,"_50":221,"_17":52,"_53":65,"_54":222,"_56":57,"_58":-5,"_95":223,"_18":224},{"_37":210,"_13":211,"_40":212,"_42":203,"_44":45,"_46":213,"_48":49,"_50":214,"_17":52,"_53":65,"_54":215,"_56":57,"_58":-5,"_95":216,"_18":217},"62b9cb54-2c37-11f0-992d-569c3dd06744","queries.ts","62b9cbf4-2c37-11f0-992d-569c3dd06744",4,["D",1746727683960],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { POSTS_TABLE, TAGS_TABLE, POST_TAGS_TABLE } from \"./migrations.ts\";\nimport { Post, PostWithTags, Tag } from \"../../shared/types.ts\";\n\n/**\n * Get all published blog posts\n */\nexport async function getAllPosts(): Promise {\n const result = await sqlite.execute(`\n SELECT \n p.id, p.title, p.slug, p.excerpt, p.content, \n p.published_at, p.updated_at, p.is_published, p.featured_image,\n GROUP_CONCAT(t.id) as tag_ids,\n GROUP_CONCAT(t.name) as tag_names,\n GROUP_CONCAT(t.slug) as tag_slugs\n FROM ${POSTS_TABLE} p\n LEFT JOIN ${POST_TAGS_TABLE} pt ON p.id = pt.post_id\n LEFT JOIN ${TAGS_TABLE} t ON pt.tag_id = t.id\n WHERE p.is_published = 1\n GROUP BY p.id\n ORDER BY p.published_at DESC\n `);\n\n return result.rows.map(row => {\n const tags: Tag[] = [];\n \n // Process tags if they exist\n if (row.tag_ids) {\n const tagIds = row.tag_ids.split(',');\n const tagNames = row.tag_names.split(',');\n const tagSlugs = row.tag_slugs.split(',');\n \n for (let i = 0; i < tagIds.length; i++) {\n tags.push({\n id: parseInt(tagIds[i]),\n name: tagNames[i],\n slug: tagSlugs[i]\n });\n }\n }\n \n return {\n id: row.id,\n title: row.title,\n slug: row.slug,\n excerpt: row.excerpt,\n content: row.content,\n publishedAt: row.published_at,\n updatedAt: row.updated_at,\n isPublished: Boolean(row.is_published),\n featuredImage: row.featured_image,\n tags\n };\n });\n}\n\n/**\n * Get a single blog post by slug\n */\nexport async function getPostBySlug(slug: string): Promise {\n const result = await sqlite.execute(`\n SELECT \n p.id, p.title, p.slug, p.excerpt, p.content, \n p.published_at, p.updated_at, p.is_published, p.featured_image,\n GROUP_CONCAT(t.id) as tag_ids,\n GROUP_CONCAT(t.name) as tag_names,\n GROUP_CONCAT(t.slug) as tag_slugs\n FROM ${POSTS_TABLE} p\n LEFT JOIN ${POST_TAGS_TABLE} pt ON p.id = pt.post_id\n LEFT JOIN ${TAGS_TABLE} t ON pt.tag_id = t.id\n WHERE p.slug = ? AND p.is_published = 1\n GROUP BY p.id\n `, [slug]);\n\n if (result.rows.length === 0) {\n return null;\n }\n\n const row = result.rows[0];\n const tags: Tag[] = [];\n \n // Process tags if they exist\n if (row.tag_ids) {\n const tagIds = row.tag_ids.split(',');\n const tagNames = row.tag_names.split(',');\n const tagSlugs = row.tag_slugs.split(',');\n \n for (let i = 0; i < tagIds.length; i++) {\n tags.push({\n id: parseInt(tagIds[i]),\n name: tagNames[i],\n slug: tagSlugs[i]\n });\n }\n }\n \n return {\n id: row.id,\n title: row.title,\n slug: row.slug,\n excerpt: row.excerpt,\n content: row.content,\n publishedAt: row.published_at,\n updatedAt: row.updated_at,\n isPublished: Boolean(row.is_published),\n featuredImage: row.featured_image,\n tags\n };\n}\n\n/**\n * Get all tags\n */\nexport async function getAllTags(): Promise {\n const result = await sqlite.execute(`\n SELECT id, name, slug\n FROM ${TAGS_TABLE}\n ORDER BY name ASC\n `);\n\n return result.rows.map(row => ({\n id: row.id,\n name: row.name,\n slug: row.slug\n }));\n}\n\n/**\n * Create a new blog post\n */\nexport async function createPost(post: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${POSTS_TABLE} (\n title, slug, content, excerpt, published_at, \n updated_at, is_published, featured_image\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n RETURNING id\n `, [\n post.title,\n post.slug,\n post.content,\n post.excerpt,\n post.publishedAt,\n post.updatedAt,\n post.isPublished ? 1 : 0,\n post.featuredImage\n ]);\n\n return result.rows[0].id;\n}\n\n/**\n * Update an existing blog post\n */\nexport async function updatePost(id: number, post: Partial): Promise {\n const fields: string[] = [];\n const values: any[] = [];\n\n if (post.title !== undefined) {\n fields.push('title = ?');\n values.push(post.title);\n }\n\n if (post.slug !== undefined) {\n fields.push('slug = ?');\n values.push(post.slug);\n }\n\n if (post.content !== undefined) {\n fields.push('content = ?');\n values.push(post.content);\n }\n\n if (post.excerpt !== undefined) {\n fields.push('excerpt = ?');\n values.push(post.excerpt);\n }\n\n if (post.publishedAt !== undefined) {\n fields.push('published_at = ?');\n values.push(post.publishedAt);\n }\n\n if (post.updatedAt !== undefined) {\n fields.push('updated_at = ?');\n values.push(post.updatedAt);\n }\n\n if (post.isPublished !== undefined) {\n fields.push('is_published = ?');\n values.push(post.isPublished ? 1 : 0);\n }\n\n if (post.featuredImage !== undefined) {\n fields.push('featured_image = ?');\n values.push(post.featuredImage);\n }\n\n if (fields.length === 0) {\n return false;\n }\n\n values.push(id);\n\n const result = await sqlite.execute(`\n UPDATE ${POSTS_TABLE}\n SET ${fields.join(', ')}\n WHERE id = ?\n `, values);\n\n return result.rowsAffected > 0;\n}",[],[168,202,211],"55a4c41e-2c37-11f0-80d7-569c3dd06744","migrations.ts","55a4c4c8-2c37-11f0-80d7-569c3dd06744",["D",1746727662010],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names\nexport const POSTS_TABLE = \"blog_posts\";\nexport const TAGS_TABLE = \"blog_tags\";\nexport const POST_TAGS_TABLE = \"blog_post_tags\";\n\n/**\n * Create all necessary tables for the blog\n */\nexport async function createTables() {\n // Create posts table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${POSTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n slug TEXT NOT NULL UNIQUE,\n content TEXT NOT NULL,\n excerpt TEXT,\n published_at INTEGER NOT NULL,\n updated_at INTEGER,\n is_published BOOLEAN DEFAULT 1,\n featured_image TEXT\n )\n `);\n\n // Create tags table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TAGS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n slug TEXT NOT NULL UNIQUE\n )\n `);\n\n // Create post_tags junction table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${POST_TAGS_TABLE} (\n post_id INTEGER NOT NULL,\n tag_id INTEGER NOT NULL,\n PRIMARY KEY (post_id, tag_id),\n FOREIGN KEY (post_id) REFERENCES ${POSTS_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (tag_id) REFERENCES ${TAGS_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n // Create indexes\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_posts_published_at ON ${POSTS_TABLE}(published_at)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_posts_slug ON ${POSTS_TABLE}(slug)`);\n\n // Insert sample post if none exist\n const postCount = await sqlite.execute(`SELECT COUNT(*) as count FROM ${POSTS_TABLE}`);\n if (postCount.rows[0].count === 0) {\n await createSamplePost();\n }\n}\n\n/**\n * Create a sample blog post\n */\nasync function createSamplePost() {\n const now = Date.now();\n \n await sqlite.execute(`\n INSERT INTO ${POSTS_TABLE} (\n title, \n slug, \n content, \n excerpt, \n published_at, \n is_published, \n featured_image\n ) VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [\n \"Welcome to Your Beautiful Blog\",\n \"welcome-to-your-beautiful-blog\",\n `# Welcome to Your Beautiful Blog\n\nThis is your first blog post! You can edit or delete this post and start creating your own content.\n\n## Markdown Support\n\nThis blog supports Markdown formatting, which means you can:\n\n- Create **bold** or *italic* text\n- Add [links](https://val.town)\n- Include code blocks:\n\n\\`\\`\\`typescript\nconst greeting = \"Hello, world!\";\nconsole.log(greeting);\n\\`\\`\\`\n\n## Next Steps\n\n1. Visit the admin section to create new posts\n2. Customize your blog's appearance\n3. Share your blog with the world!\n\nEnjoy your new blog!`,\n \"Get started with your new beautiful blog built on Val Town. This post introduces the features and capabilities of your new blog platform.\",\n now,\n true,\n \"https://images.unsplash.com/photo-1499750310107-5fef28a66643?q=80&w=1000\"\n ]);\n\n // Add a sample tag\n await sqlite.execute(`\n INSERT INTO ${TAGS_TABLE} (name, slug) VALUES (?, ?)\n `, [\"Getting Started\", \"getting-started\"]);\n\n // Link the post to the tag\n const postId = (await sqlite.execute(`SELECT id FROM ${POSTS_TABLE} WHERE slug = ?`, [\"welcome-to-your-beautiful-blog\"])).rows[0].id;\n const tagId = (await sqlite.execute(`SELECT id FROM ${TAGS_TABLE} WHERE slug = ?`, [\"getting-started\"])).rows[0].id;\n \n await sqlite.execute(`\n INSERT INTO ${POST_TAGS_TABLE} (post_id, tag_id) VALUES (?, ?)\n `, [postId, tagId]);\n}",[],[168,202,219],"38b1bf24-2c37-11f0-abee-569c3dd06744",["D",1746727613446],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","2019e55b-c541-4c51-bef0-008eef10ef88","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_277":273},"org",{"_11":12,"_271":-5,"_272":273,"_234":235,"_274":275,"_276":57},"branch",{"_17":47,"_13":16,"_37":45,"_263":225,"_264":-5,"_265":-5,"_266":-5,"_267":-5,"_268":-5,"_269":14,"_270":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_37":225,"_13":14,"_50":373,"_227":-5,"_228":57,"_229":230,"_231":230,"_232":-5,"_233":-5,"_234":235,"_236":179,"_237":49,"_238":-5,"_239":-5,"_240":52,"_241":242,"_243":-5,"_244":-5,"_245":-5,"_246":-5,"_247":248,"_249":248,"_250":251,"_252":251,"_253":251,"_254":248,"_255":248,"_256":374,"_258":375,"_260":376,"_262":57},[316,323,332,334],"files",[316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334],"counts",{"_307":52,"_308":92,"_309":52,"_32":310,"_311":312},[299,300,301,302],{"_37":82,"_44":45,"_40":43,"_13":19,"_54":-5,"_53":80,"_17":52,"_42":-5,"_50":297,"_46":71,"_58":-5,"_18":298},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746727713260],[19],{"_37":75,"_13":76,"_40":77,"_42":43,"_44":45,"_46":78,"_48":49,"_50":79,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_18":306},{"_37":68,"_13":69,"_40":70,"_42":43,"_44":45,"_46":71,"_48":49,"_50":72,"_17":52,"_53":24,"_54":73,"_56":57,"_58":-5,"_18":305},{"_37":60,"_13":61,"_40":62,"_42":43,"_44":45,"_46":63,"_48":49,"_50":64,"_17":52,"_53":65,"_54":66,"_56":57,"_58":-5,"_18":304},{"_37":38,"_13":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_17":52,"_53":24,"_54":55,"_56":57,"_58":-5,"_18":303},[19,39],[19,61],[19,69],[19,76],"pulls","branches","forks",{"_313":52,"_315":52},"connections",{"_313":52,"_314":52},"count","unfilledCount","emptyCount",{"_37":167,"_13":168,"_40":169,"_42":-5,"_44":45,"_46":170,"_48":49,"_50":171,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":371,"_18":372},{"_37":201,"_13":202,"_40":203,"_42":169,"_44":45,"_46":204,"_48":49,"_50":205,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":369,"_18":370},{"_37":218,"_13":219,"_40":220,"_42":203,"_44":45,"_46":204,"_48":49,"_50":221,"_17":52,"_53":65,"_54":222,"_56":57,"_58":-5,"_95":367,"_18":368},{"_37":210,"_13":211,"_40":212,"_42":203,"_44":45,"_46":213,"_48":49,"_50":214,"_17":52,"_53":65,"_54":215,"_56":57,"_58":-5,"_95":365,"_18":366},{"_37":186,"_13":187,"_40":188,"_42":169,"_44":45,"_46":189,"_48":49,"_50":190,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":363,"_18":364},{"_37":194,"_13":195,"_40":196,"_42":188,"_44":45,"_46":189,"_48":49,"_50":197,"_17":52,"_53":65,"_54":198,"_56":57,"_58":-5,"_95":361,"_18":362},{"_37":177,"_13":178,"_40":179,"_42":169,"_44":45,"_46":180,"_48":49,"_50":181,"_17":92,"_53":182,"_54":183,"_56":57,"_58":-5,"_95":359,"_18":360},{"_37":82,"_13":19,"_40":43,"_42":-5,"_44":45,"_46":71,"_48":49,"_50":113,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":357,"_18":358},{"_37":75,"_13":76,"_40":77,"_42":43,"_44":45,"_46":78,"_48":49,"_50":129,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":355,"_18":356},{"_37":159,"_13":160,"_40":161,"_42":77,"_44":45,"_46":162,"_48":49,"_50":163,"_17":52,"_53":65,"_54":164,"_56":57,"_58":-5,"_95":353,"_18":354},{"_37":152,"_13":153,"_40":154,"_42":77,"_44":45,"_46":78,"_48":49,"_50":155,"_17":52,"_53":65,"_54":156,"_56":57,"_58":-5,"_95":351,"_18":352},{"_37":144,"_13":145,"_40":146,"_42":77,"_44":45,"_46":147,"_48":49,"_50":148,"_17":52,"_53":65,"_54":149,"_56":57,"_58":-5,"_95":349,"_18":350},{"_37":136,"_13":137,"_40":138,"_42":77,"_44":45,"_46":139,"_48":49,"_50":140,"_17":52,"_53":65,"_54":141,"_56":57,"_58":-5,"_95":347,"_18":348},{"_37":68,"_13":69,"_40":70,"_42":43,"_44":45,"_46":71,"_48":49,"_50":126,"_17":52,"_53":24,"_54":73,"_56":57,"_58":-5,"_95":345,"_18":346},{"_37":60,"_13":61,"_40":62,"_42":43,"_44":45,"_46":63,"_48":49,"_50":123,"_17":52,"_53":65,"_54":66,"_56":57,"_58":-5,"_95":343,"_18":344},{"_37":38,"_13":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":120,"_17":52,"_53":24,"_54":55,"_56":57,"_58":-5,"_95":341,"_18":342},{"_37":98,"_13":99,"_40":100,"_42":-5,"_44":45,"_46":101,"_48":49,"_50":102,"_17":52,"_53":80,"_54":-5,"_56":57,"_58":-5,"_95":339,"_18":340},{"_37":106,"_13":107,"_40":108,"_42":100,"_44":45,"_46":101,"_48":49,"_50":109,"_17":52,"_53":65,"_54":110,"_56":57,"_58":-5,"_95":337,"_18":338},{"_37":89,"_13":90,"_40":91,"_42":-5,"_44":45,"_46":92,"_48":49,"_50":93,"_17":52,"_53":24,"_54":94,"_56":57,"_58":-5,"_95":335,"_18":336},[],[90],[],[99,107],[333],[99],[],[19,39],[],[19,61],[],[19,69],[],[19,76,137],[],[19,76,145],[],[19,76,153],[],[19,76,160],[325,326,327,328],[19,76],[324,329,330,331],[19],[],[168,178],[],[168,187,195],[321],[168,187],[],[168,202,211],[],[168,202,219],[318,319],[168,202],[317,320,322],[168],["D",1746727613446],{"_11":12,"_277":273},{"_11":12,"_271":-5,"_272":273,"_234":235,"_274":275,"_276":57},{"_17":47,"_13":16,"_37":45,"_263":225,"_264":-5,"_265":-5,"_266":-5,"_267":-5,"_268":-5,"_269":14,"_270":12},"ctx",{"_256":-5,"_294":410,"_411":412,"_413":414,"_415":57,"_416":57,"_417":57,"_418":49,"_419":-5,"_420":-7,"_421":-7,"_422":52,"_423":57,"_424":57,"_425":-5,"_426":57,"_427":57,"_428":57,"_429":-5},"ENV",{"_381":382,"_383":384,"_385":16,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401,"_402":403,"_404":405,"_406":407,"_408":409},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]