[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_104":86,"_27":98,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":58,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",26,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","cde979d8-a8f5-11f1-86a4-1607ee4eb77e","name","fileType","http","content","/** @jsxImportSource npm:hono@3/jsx */\nimport { Hono } from \"npm:hono\";\nimport { basicAuth } from \"npm:hono/basic-auth\";\n// 貼り付け後に「ドット」を「.`」に修正してください\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nconst app = new Hono();\n\n// --- データベースの初期化 ---\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS blog_posts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n`);\n\n// 画像・ファイル添付用のカラムを自動で追加する処理（既存のデータは壊れません）\ntry {\n await sqlite.execute(\"ALTER TABLE blog_posts ADD COLUMN file_url TEXT\");\n await sqlite.execute(\"ALTER TABLE blog_posts ADD COLUMN file_type TEXT\");\n} catch (e) {\n // すでにカラムが存在する場合はエラーを無視します\n}\n\n// --- 🔒 ここにあなたのログイン情報を直接書きます 🔒 ---\nconst authUser = \"konnnitiha\";\nconst authPass = \"fj10576890:^\";\n\nconst adminAuth = basicAuth({\n username: authUser,\n password: authPass,\n});\n\n// --- 共通のレイアウトHTML ---\nconst Layout = ({ title, children }: { title: string; children: any }) => (\n \n \n \n \n {title}\n \n \n \n

\n マイブログ\n

\n ＋新規投稿\n

{children}

\n \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 // データの取得に失敗した、またはエラーの場合\n if (!data || !data.ok) return c.text(\"ファイルが見つかりません\", 404);\n\n // 拡張子から適切なContent-Typeを自動判別\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 // dataのあとに「.body」を付け足して、画像データを正しくブラウザに送ります\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, 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 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 created_at = row[dateIdx];\n\n return (\n

\n {created_at}\n

\n {title}\n

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

\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});\n\n// 2. 記事の詳細ページ\napp.get(\"/posts/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const result = await sqlite.execute({\n sql:\n \"SELECT id, title, content, file_url, file_type, 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 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 dateIdx = result.columns.indexOf(\"created_at\");\n\n const fileUrl = row[fileUrlIdx];\n const fileType = row[fileTypeIdx];\n\n return c.html(\n \n {row[dateIdx]}\n

\n {row[titleIdx]}\n

\n {row[contentIdx]}\n

\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

{children}

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

\n {created_at}\n

\n {title}\n

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

\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 {row[titleIdx]}\n

\n {row[contentIdx]}\n

\n\n {/* 詳細ページでの添付ファイルの表示 */}\n {fileUrl && (\n

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

新しい記事を書く

\n {/* 送信形式を multipart/form-data に変更 */}\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 // 添付ファイルが存在する場合の処理\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 // ⌚️ ここで現在の正確な「日本時間（JST）」を自動計算して作ります\n const nowJST = new Date(Date.now() + 9 * 60 * 60 * 1000)\n .toISOString()\n .replace(\"T\", \" \")\n .substring(0, 19);\n\n // データベースに記事と「日本時間（created_at）」をまとめて安全に格納します\n await sqlite.execute({\n sql:\n \"INSERT INTO blog_posts (title, content, file_url, file_type, created_at) VALUES (:title, :content, :file_url, :file_type, :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 // 紐づく添付ファイルがあればBlobストレージ側も自動で掃除する\n const result = await sqlite.execute({\n sql: \"SELECT file_url 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 const fileUrl = result.rows[fileUrlIdx];\n\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 // テーブルから記事データを削除\n await sqlite.execute({\n sql: \"DELETE FROM blog_posts WHERE id = :id\",\n args: { id },\n });\n return c.redirect(\"/\");\n});\n\nexport default app.fetch;","createdAt",["D",1788673641874],"branchVersion","branchId","8ec45fbf-d545-428f-a831-7c9bda6d0387","id","81b63661-d269-43fd-99f7-981b59ce0807","tanomu",["D",1788590909976],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","burogusaigonotyannsu ","imageUrl","e8dc4c42-368d-443a-bdb0-f12c12a7ed90","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a06c07-a416-700f-9d79-6326f651fc92","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":98},"org",{"_96":95,"_97":98,"_99":98,"_18":55,"_100":101,"_102":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned",40,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","konnnitiha","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":149,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":150,"_80":151,"_82":152,"_84":25},"tree",[144],"files",[144],"counts",{"_133":62,"_134":135,"_136":62,"_137":138,"_139":140},"contents",[125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":129,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_27":132},"2b785f94-cb23-4a38-9e5e-f1012815b6e0","parentId","latest",["D",1788673641874],25,"label",[28],"pulls","branches",1,"forks","envVars",{"_141":62,"_143":62},"connections",{"_141":62,"_142":62},"count","unfilledCount","emptyCount",{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":145,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_146":147,"_27":148},["D",1788673641874],"children",[],[28],["D",1788590909976],{"_96":95,"_103":98},{"_96":95,"_97":98,"_99":98,"_18":55,"_100":101,"_102":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_122":186,"_187":188,"_189":190,"_191":25,"_192":25,"_193":25,"_194":58,"_195":-5,"_196":-7,"_197":-7,"_198":62,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":86,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v26