[{"_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,"_26":122,"_24":123,"_124":-5,"_125":-5,"_126":52,"_127":128,"_129":43,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","konnnitiha","name","tanomu","branchName","main","version","path","main.ts","project",{"_33":60,"_13":14,"_44":61,"_62":-5,"_63":52,"_64":65,"_66":65,"_67":68,"_69":-5,"_70":71,"_72":36,"_73":43,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":52},"tree",[55],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_18":54},"contents",[],"upstream","pull","ahead","behind","envVars","id","6e22ea63-919b-4ffd-b86f-80ef876a908e","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",[19],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":56,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_57":58,"_18":59},["D",1788770861787],"children",[],[19],"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":109},"org",{"_11":12,"_108":109,"_110":109,"_70":71,"_111":112,"_113":52},"branch",{"_17":41,"_13":16,"_33":39,"_100":60,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":60,"_13":14,"_44":148,"_62":-5,"_63":52,"_64":65,"_66":65,"_67":68,"_69":-5,"_70":71,"_72":36,"_73":43,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":149,"_95":150,"_97":151,"_99":52},[145],"files",[145],"counts",{"_135":77,"_136":137,"_138":77,"_32":139,"_140":141},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_18":134},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches",1,"forks",{"_142":77,"_144":77},"connections",{"_142":77,"_143":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":56,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_57":146,"_18":147},[],[19],["D",1788590909976],{"_11":12,"_114":109},{"_11":12,"_108":109,"_110":109,"_70":71,"_111":112,"_113":52},{"_17":41,"_13":16,"_33":39,"_100":60,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_131":185,"_186":187,"_188":189,"_190":52,"_191":52,"_192":52,"_193":43,"_194":-5,"_195":-7,"_196":-7,"_197":77,"_198":52,"_199":52,"_200":-5,"_201":52,"_202":52,"_203":52,"_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","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"]