\n setIsPreview(false)}\n >\n Edit\n \n setIsPreview(true)}\n >\n Preview\n \n

\n {!isPreview\n ? (\n onChange(e.target.value)}\n placeholder={placeholder}\n className=\"markdown-input\"\n />\n )\n : (\n

\n \n {value || \"Nothing to preview\"}\n \n

\n )}\n

Markdown Formatting Tips

**Bold** or __Bold__
*Italic* or _Italic_
# Heading 1
## Heading 2
- List item
`Inline code`
```Code block```
[Link](https://example.com)

\n );\n}\n\nfunction BlogPostForm({\n onSubmit,\n initialPost = { title: \"\", content: \"\" },\n isEditing = false,\n}: {\n onSubmit: (post: BlogPost) => void;\n initialPost?: BlogPost;\n isEditing?: boolean;\n}) {\n const [title, setTitle] = useState(initialPost.title);\n const [content, setContent] = useState(initialPost.content);\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n onSubmit({\n ...initialPost,\n title,\n content,\n });\n if (!isEditing) {\n setTitle(\"\");\n setContent(\"\");\n }\n };\n\n return (\n

\n setTitle(e.target.value)}\n placeholder=\"Post Title\"\n required\n />\n \n \n \n );\n}\n\nfunction BlogPostView({ post, onEdit, onDelete }: {\n post: BlogPost;\n onEdit: () => void;\n onDelete: () => void;\n}) {\n return (\n

{post.title}

\n \n Published on {new Date(post.createdAt || \"\").toLocaleDateString()}\n \n

\n \n {post.content}\n \n

\n \n \n

\n );\n}\n\nfunction BlogList() {\n const [posts, setPosts] = useState([]);\n const [editingPost, setEditingPost] = useState(null);\n\n useEffect(() => {\n fetchPosts();\n }, []);\n\n const fetchPosts = async () => {\n try {\n const response = await fetch(\"/posts\");\n const data = await response.json();\n setPosts(data);\n } catch (error) {\n console.error(\"Failed to fetch posts\", error);\n }\n };\n\n const handleCreatePost = async (post: BlogPost) => {\n try {\n const response = await fetch(\"/posts\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(post),\n });\n if (response.ok) {\n fetchPosts();\n }\n } catch (error) {\n console.error(\"Failed to create post\", error);\n }\n };\n\n const handleDeletePost = async (id: number) => {\n try {\n const response = await fetch(`/posts/${id}`, { method: \"DELETE\" });\n if (response.ok) {\n fetchPosts();\n }\n } catch (error) {\n console.error(\"Failed to delete post\", error);\n }\n };\n\n const handleUpdatePost = async (updatedPost: BlogPost) => {\n try {\n const response = await fetch(`/posts/${updatedPost.id}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(updatedPost),\n });\n if (response.ok) {\n fetchPosts();\n setEditingPost(null);\n }\n } catch (error) {\n console.error(\"Failed to update post\", error);\n }\n };\n\n return (\n

My Markdown Blog 📝

\n {!editingPost && (\n \n )}\n

\n {posts.map(post => (\n \n {editingPost?.id === post.id\n ? (\n \n )\n : (\n setEditingPost(post)}\n onDelete={() => handleDeletePost(post.id!)}\n />\n )}\n \n ))}\n

\n \n View Source\n \n

\n );\n}\n\nfunction App() {\n return ;\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"buildBlog\";\n const SCHEMA_VERSION = 6; // Incrementing schema version to force table recreation\n\n try {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_blog_posts_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n } catch (error) {\n console.error(\"Failed to create table:\", error);\n return new Response(\"Database initialization error\", { status: 500 });\n }\n\n // Handle different routes\n const url = new URL(request.url);\n\n // GET all posts\n if (request.method === \"GET\" && url.pathname === \"/posts\") {\n try {\n const posts = await sqlite.execute(`\n SELECT * FROM ${KEY}_blog_posts_${SCHEMA_VERSION} \n ORDER BY createdAt DESC\n `);\n return new Response(JSON.stringify(posts.rows || []), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n console.error(\"Failed to fetch posts:\", error);\n return new Response(\"Failed to retrieve posts\", { status: 500 });\n }\n }\n\n // POST new post\n if (request.method === \"POST\" && url.pathname === \"/posts\") {\n try {\n const { title, content } = await request.json();\n\n // Validate input\n if (!title || !content) {\n return new Response(\"Title and content are required\", { status: 400 });\n }\n\n await sqlite.execute(\n `\n INSERT INTO ${KEY}_blog_posts_${SCHEMA_VERSION} (title, content) \n VALUES (?, ?)\n `,\n [title, content],\n );\n return new Response(\"Post created\", { status: 201 });\n } catch (error) {\n console.error(\"Failed to create post:\", error);\n return new Response(\"Failed to create post\", { status: 500 });\n }\n }\n\n // DELETE post\n if (request.method === \"DELETE\" && url.pathname.startsWith(\"/posts/\")) {\n try {\n const id = url.pathname.split(\"/\").pop();\n\n // Validate ID\n if (!id || isNaN(Number(id))) {\n return new Response(\"Invalid post ID\", { status: 400 });\n }\n\n await sqlite.execute(\n `\n DELETE FROM ${KEY}_blog_posts_${SCHEMA_VERSION} \n WHERE id = ?\n `,\n [id],\n );\n return new Response(\"Post deleted\", { status: 200 });\n } catch (error) {\n console.error(\"Failed to delete post:\", error);\n return new Response(\"Failed to delete post\", { status: 500 });\n }\n }\n\n // PUT (update) post\n if (request.method === \"PUT\" && url.pathname.startsWith(\"/posts/\")) {\n try {\n const id = url.pathname.split(\"/\").pop();\n const { title, content } = await request.json();\n\n // Validate input\n if (!id || isNaN(Number(id)) || !title || !content) {\n return new Response(\"Invalid input\", { status: 400 });\n }\n\n await sqlite.execute(\n `\n UPDATE ${KEY}_blog_posts_${SCHEMA_VERSION} \n SET title = ?, content = ? \n WHERE id = ?\n `,\n [title, content, id],\n );\n return new Response(\"Post updated\", { status: 200 });\n } catch (error) {\n console.error(\"Failed to update post:\", error);\n return new Response(\"Failed to update post\", { status: 500 });\n }\n }\n\n // Serve HTML\n return new Response(\n `\n \n \n My Markdown Blog\n \n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\nconst css = `\nbody {\n font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, 'Open Sans', 'Helvetica Neue', sans-serif;\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n line-height: 1.6;\n color: #333;\n}\n\n.blog-form {\n display: flex;\n flex-direction: column;\n gap: 10px;\n margin-bottom: 20px;\n}\n\n.blog-form input, \n.markdown-input {\n padding: 10px;\n border: 1px solid #ddd;\n border-radius: 4px;\n width: 100%;\n box-sizing: border-box;\n}\n\n.markdown-editor {\n border: 1px solid #ddd;\n border-radius: 4px;\n}\n\n.editor-tabs {\n display: flex;\n border-bottom: 1px solid #ddd;\n}\n\n.editor-tabs button {\n padding: 10px;\n background: #f4f4f4;\n border: none;\n cursor: pointer;\n flex-grow: 1;\n}\n\n.editor-tabs button.active {\n background: #007bff;\n color: white;\n}\n\n.markdown-input, \n.markdown-preview {\n padding: 10px;\n min-height: 200px;\n width: 100%;\n box-sizing: border-box;\n}\n\n.markdown-preview {\n background: #f9f9f9;\n overflow-y: auto;\n}\n\n.markdown-help {\n padding: 10px;\n background: #f4f4f4;\n font-size: 0.8em;\n}\n\n.markdown-help details {\n cursor: pointer;\n}\n\n.blog-form button {\n padding: 10px;\n background-color: #007bff;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n}\n\n.post-list {\n display: flex;\n flex-direction: column;\n gap: 20px;\n}\n\n.blog-post {\n border: 1px solid #eee;\n padding: 15px;\n border-radius: 4px;\n}\n\n.post-meta {\n color: #666;\n display: block;\n margin-bottom: 10px;\n}\n\n.post-content {\n margin-bottom: 15px;\n}\n\n.post-content h1 { font-size: 1.8em; }\n.post-content h2 { font-size: 1.6em; }\n.post-content h3 { font-size: 1.4em; }\n.post-content code { \n background: #f4f4f4; \n padding: 2px 4px; \n border-radius: 3px; \n}\n.post-content pre { \n background: #f4f4f4; \n padding: 10px; \n border-radius: 4px; \n overflow-x: auto; \n}\n\n.post-actions {\n display: flex;\n gap: 10px;\n}\n\n.post-actions button {\n padding: 5px 10px;\n background-color: #f0f0f0;\n border: 1px solid #ddd;\n border-radius: 4px;\n cursor: pointer;\n}\n\n.source-link {\n display: block;\n margin-top: 20px;\n text-align: center;\n color: #666;\n text-decoration: none;\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/Klaksy/buildBlog/code/main.tsx","extension","actionData","errors"]