\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",[114],"pulls",1,"forks","envVars",{"_136":54,"_138":54},"connections",{"_136":54,"_137":54},"count","unfilledCount","emptyCount",{"_20":113,"_13":114,"_115":48,"_116":-5,"_117":21,"_118":30,"_119":50,"_22":140,"_29":121,"_122":123,"_124":125,"_126":38,"_127":-5,"_141":142,"_90":143},["D",1788770861787],"children",[],[114],["D",1788590909976],{"_11":12,"_88":83},{"_11":12,"_82":83,"_84":83,"_45":46,"_85":86,"_87":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"ctx",{"_70":-5,"_109":181,"_182":183,"_184":185,"_186":38,"_187":38,"_188":38,"_189":50,"_190":-5,"_191":-7,"_192":-7,"_193":54,"_194":38,"_195":38,"_196":-5,"_197":38,"_198":38,"_199":38,"_200":-5},"ENV",{"_152":153,"_154":155,"_156":26,"_157":158,"_159":160,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180},"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"]

Branches1

Branches
1