\n マイブログ\n

\n ＋新規投稿\n

{children}

\n \n \n);\n// --- 🛠️ 添付ファイルをBlobサーバーから配信するエンドポイント ---\napp.get(\"/file/:key\", async (c) => {\n const key = c.req.param(\"key\");\n try {\n const data = await blob.get(key);\n if (!data || !data.ok) return c.text(\"ファイルが見つかりません\", 404);\n\n let contentType = \"application/octet-stream\";\n if (key.endsWith(\"ドットpng\")) contentType = \"image/png\";\n else if (key.endsWith(\"ドットjpg\") || key.endsWith(\"ドットjpeg\")) {\n contentType = \"image/jpeg\";\n } else if (key.endsWith(\"ドットgif\")) contentType = \"image/gif\";\n else if (key.endsWith(\"ドットtxt\")) contentType = \"text/plain; charset=utf-8\";\n\n return new Response(data.body, {\n headers: { \"Content-Type\": contentType },\n });\n } catch (e) {\n return c.text(\"ファイルの読み込みに失敗しました\", 500);\n }\n});\n\n// 1. トップページ（記事の一覧表示）\napp.get(\"/\", async (c) => {\n const result = await sqlite.execute(\n \"SELECT id, title, content, file_url, file_type, views, created_at FROM blog_posts ORDER BY created_at DESC\",\n );\n\n const idIdx = result.columns.indexOf(\"id\");\n const titleIdx = result.columns.indexOf(\"title\");\n const contentIdx = result.columns.indexOf(\"content\");\n const fileUrlIdx = result.columns.indexOf(\"file_url\");\n const fileTypeIdx = result.columns.indexOf(\"file_type\");\n const viewsIdx = result.columns.indexOf(\"views\");\n const dateIdx = result.columns.indexOf(\"created_at\");\n\n return c.html(\n \n {result.rows.length === 0\n ? (\n

\n まだ記事がありません。「新規投稿」から最初の記事を書いてみましょう！\n

\n )\n : (\n result.rows.map((row: any) => {\n const id = row[idIdx];\n const title = row[titleIdx];\n const content = row[contentIdx];\n const fileUrl = row[fileUrlIdx];\n const fileType = row[fileTypeIdx];\n const views = row[viewsIdx] || 0;\n const created_at = row[dateIdx];\n\n return (\n

\n {created_at}\n 👁️ {views} views\n

\n {title}\n

\n {content.length > 100\n ? `${content.substring(0, 100)}...`\n : content}\n

\n\n {fileUrl && (\n

\n {fileType && fileType.startsWith(\"image/\")\n ? $\"添付画像\"$ \n : (\n \n 📄 添付ファイルをダウンロード・閲覧\n \n )}\n

\n )}\n\n \n \n \n

\n );\n })\n )}\n ,\n );\n});\n// 2. 記事の詳細ページ\napp.get(\"/posts/:id\", async (c) => {\n const id = c.req.param(\"id\");\n\n // 詳細を開いたときに、閲覧数を1つ増やす（インクリメント）SQLを実行\n try {\n await sqlite.execute({\n sql: \"UPDATE blog_posts SET views = COALESCE(views, 0) + 1 WHERE id = :id\",\n args: { id },\n });\n } catch (e) {\n // エラー保護\n }\n\n const result = await sqlite.execute({\n sql:\n \"SELECT id, title, content, file_url, file_type, views, created_at FROM blog_posts WHERE id = :id\",\n args: { id },\n });\n\n if (result.rows.length === 0) {\n return c.html(\n \n

記事が見つかりませんでした。

\n ← トップへ戻る\n ,\n 404,\n );\n }\n\n const row = result.rows[0];\n const titleIdx = result.columns.indexOf(\"title\");\n const contentIdx = result.columns.indexOf(\"content\");\n const fileUrlIdx = result.columns.indexOf(\"file_url\");\n const fileTypeIdx = result.columns.indexOf(\"file_type\");\n const viewsIdx = result.columns.indexOf(\"views\");\n const dateIdx = result.columns.indexOf(\"created_at\");\n\n const fileUrl = row[fileUrlIdx];\n const fileType = row[fileTypeIdx];\n const views = row[viewsIdx] || 0;\n\n return c.html(\n \n {row[dateIdx]}\n 👁️ {views} views\n \n

\n {row[titleIdx]}\n

\n {row[contentIdx]}\n

\n\n {fileUrl && (\n

\n {fileType && fileType.startsWith(\"image/\")\n ? $\"添付画像\"$ \n : (\n \n 📄 添付ファイルをダウンロード・閲覧\n \n )}\n

\n )}\n\n ← 記事一覧へ戻る\n ,\n );\n});\n\n// --- 🔒 ここから下のページ・機能はパスワードを要求します 🔒 ---\n\n// 3. 投稿用の管理画面（認証付き）\napp.get(\"/admin\", adminAuth, (c) => {\n return c.html(\n \n

新しい記事を書く

\n \n ← 戻る\n ,\n );\n});\n\n// 4. フォームから送信された記事を保存する処理（認証付き）\napp.post(\"/admin\", adminAuth, async (c) => {\n const body = await c.req.parseBody();\n const title = body.title as string;\n const content = body.content as string;\n const file = body.file as File | undefined;\n\n let fileUrl: string | null = null;\n let fileType: string | null = null;\n\n if (title && content) {\n if (file && file.size > 0) {\n fileType = file.type;\n const blobKey = `blog_${Date.now()}_${file.name}`;\n\n const arrayBuffer = await file.arrayBuffer();\n await blob.set(blobKey, new Uint8Array(arrayBuffer));\n\n fileUrl = `/file/${blobKey}`;\n }\n\n const nowJST = new Date(Date.now() + 9 * 60 * 60 * 1000)\n .toISOString()\n .replace(\"T\", \" \")\n .substring(0, 19);\n\n await sqlite.execute({\n sql:\n \"INSERT INTO blog_posts (title, content, file_url, file_type, views, created_at) VALUES (:title, :content, :file_url, :file_type, 0, :created_at)\",\n args: {\n title,\n content,\n file_url: fileUrl,\n file_type: fileType,\n created_at: nowJST,\n },\n });\n }\n return c.redirect(\"/\");\n});\n\n// 5. 記事を削除する処理（認証付き）\napp.post(\"/delete/:id\", adminAuth, async (c) => {\n const id = c.req.param(\"id\");\n\n try {\n const result = await sqlite.execute({\n sql: \"SELECT id FROM blog_posts WHERE id = :id\",\n args: { id },\n });\n\n if (result.rows.length > 0) {\n const fileUrlIdx = result.columns.indexOf(\"file_url\");\n\n if (fileUrlIdx !== -1) {\n const row = result.rows;\n const fileUrl = row[fileUrlIdx];\n if (fileUrl && fileUrl.startsWith(\"/file/\")) {\n const blobKey = fileUrl.replace(\"/file/\", \"\");\n try {\n await blob.delete(blobKey);\n } catch (e) {\n // エラー無視\n }\n }\n }\n }\n } catch (e) {\n // エラー保護\n }\n\n await sqlite.execute({\n sql: \"DELETE FROM blog_posts WHERE id = :id\",\n args: { id },\n });\n\n return c.redirect(\"/\");\n});\n\nexport default app.fetch;","deleted","label",[108],"pulls","branches",1,"forks","envVars",{"_131":42,"_133":42},"connections",{"_131":42,"_132":42},"count","unfilledCount","emptyCount",{"_18":107,"_20":108,"_109":36,"_110":-5,"_111":68,"_112":66,"_113":38,"_22":135,"_65":115,"_116":117,"_118":119,"_120":26,"_121":-5,"_136":137,"_85":138},["D",1788770861787],"children",[],[108],["D",1788590909976],{"_16":17,"_83":78},{"_16":17,"_77":78,"_79":78,"_33":34,"_80":81,"_82":26},{"_65":66,"_20":67,"_18":68,"_69":19,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":21,"_76":17},"ctx",{"_58":-5,"_103":176,"_177":178,"_179":180,"_181":26,"_182":26,"_183":26,"_184":38,"_185":-5,"_186":-7,"_187":-7,"_188":42,"_189":26,"_190":26,"_191":-5,"_192":26,"_193":26,"_194":26,"_195":-5},"ENV",{"_147":148,"_149":150,"_151":67,"_152":153,"_154":155,"_156":157,"_158":159,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175},"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"]

Search