[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","konnnitiha","name","tanomu","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","6e22ea63-919b-4ffd-b86f-80ef876a908e","main.ts","fileId","cde979d8-a8f5-11f1-86a4-1607ee4eb77e","parentId","branchId","8ec45fbf-d545-428f-a831-7c9bda6d0387","branchVersion",40,"latest",true,"createdAt",["D",1788770861787],39,"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// ✨閲覧回数用のカラムを自動で追加する処理（初期値は0）\ntry {\n await sqlite.execute(\"ALTER TABLE blog_posts ADD COLUMN views INTEGER DEFAULT 0\");\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// --- 共通のレイアウト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// --- 🛠️ 添付ファイルを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",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1788770861787],"children",[],[35],"81b63661-d269-43fd-99f7-981b59ce0807",["D",1788590909976],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","burogusaigonotyannsu ","imageUrl","userId","e8dc4c42-368d-443a-bdb0-f12c12a7ed90","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a06c07-a416-700f-9d79-6326f651fc92","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_114":19},"org",{"_11":12,"_109":19,"_110":19,"_71":72,"_111":112,"_113":53},"branch",{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":148,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":149,"_96":150,"_98":151,"_100":53},[145],"files",[145],"counts",{"_135":78,"_136":137,"_138":78,"_31":139,"_140":141},[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":134},[35],"pulls","branches",1,"forks",{"_142":78,"_144":78},"connections",{"_142":78,"_143":78},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":146,"_18":147},[],[35],["D",1788590909976],{"_11":12,"_114":19},{"_11":12,"_109":19,"_110":19,"_71":72,"_111":112,"_113":53},{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"ctx",{"_94":-5,"_130":185,"_186":187,"_188":189,"_190":53,"_191":53,"_192":53,"_193":44,"_194":-5,"_195":-7,"_196":-7,"_197":78,"_198":53,"_199":53,"_200":-5,"_201":53,"_202":53,"_203":53,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":16,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Code