[{"_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",{"_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":56,"_127":128,"_129":53,"_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","uo","branchName","main","version","path","main.ts","project",{"_33":60,"_13":14,"_45":61,"_62":-5,"_63":56,"_64":65,"_66":65,"_67":68,"_69":-5,"_70":71,"_72":38,"_73":53,"_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":56},"tree",[51],"file",{"_33":34,"_35":36,"_37":38,"_13":19,"_39":40,"_41":42,"_17":43,"_44":-5,"_45":46,"_47":48,"_49":-5,"_18":50},"contents",[],"upstream","pull","ahead","behind","envVars","id","32493693-901b-4c08-97ba-b02375c2d0b2","branchId","f8de2692-2037-4ece-a4cf-56683681b892","fileId","1a9e7124-a8e8-11f1-878c-1607ee4eb77e","content","// ==========================================\n// 【本館永久保存版 1回目：ここから貼り付け】\n// ==========================================\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// 🔑 あなただけの秘密のログインパスワード\nconst ADMIN_PASSWORD = \"haruki-secret-pass\";\n\n// 🛠 データベースの準備（テーブルがなければ作成）\nasync function initDatabase() {\n // ① 記事テーブル\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS simple_posts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n views INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n // ② コメントテーブル\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS simple_comments (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n post_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n text TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n}\n\nexport default async function server(request: Request): Promise {\n const url = new URL(request.url);\n await initDatabase();\n\n // 💡 閲覧数を増やす処理\n if (url.pathname === \"/\" && request.method === \"GET\") {\n await sqlite.execute(\"UPDATE simple_posts SET views = views + 1\");\n }\n\n // 🚀 記事の投稿 (POST /add)\n if (url.pathname === \"/add\" && request.method === \"POST\") {\n const formData = await request.formData();\n const password = formData.get(\"password\") as string;\n const title = formData.get(\"title\") as string || \"無題の記事\";\n const content = formData.get(\"content\") as string || \"\";\n\n if (password !== ADMIN_PASSWORD) {\n return new Response(\"パスワードが違います。認証エラー。\", {\n status: 403,\n });\n }\n\n await sqlite.execute({\n sql: \"INSERT INTO simple_posts (title, content) VALUES (?, ?)\",\n args: [title, content],\n });\n\n return Response.redirect(url.origin);\n }\n\n // 💬 コメントの投稿 (POST /comment)\n if (url.pathname === \"/comment\" && request.method === \"POST\") {\n const formData = await request.formData();\n const postId = parseInt(formData.get(\"postId\") as string, 10);\n const commentName = formData.get(\"commentName\") as string || \"名無しさん\";\n const commentText = formData.get(\"commentText\") as string;\n\n if (postId && commentText) {\n await sqlite.execute({\n sql:\n \"INSERT INTO simple_comments (post_id, name, text) VALUES (?, ?, ?)\",\n args: [postId, commentName, commentText],\n });\n }\n\n return Response.redirect(url.origin);\n }\n\n // 🗑 記事の削除 (POST /delete)\n if (url.pathname === \"/delete\" && request.method === \"POST\") {\n const formData = await request.formData();\n const password = formData.get(\"password\") as string;\n const id = parseInt(formData.get(\"id\") as string, 10);\n\n if (password !== ADMIN_PASSWORD) {\n return new Response(\"パスワードが違います。認証エラー。\", {\n status: 403,\n });\n }\n\n await sqlite.execute({\n sql: \"DELETE FROM simple_posts WHERE id = ?\",\n args: [id],\n });\n await sqlite.execute({\n sql: \"DELETE FROM simple_comments WHERE post_id = ?\",\n args: [id],\n });\n\n return Response.redirect(url.origin);\n }\n\n // 🔍 データベースから全データを確実に取得する処理\n const postsResult = await sqlite.execute(\n \"SELECT id, title, content, views, created_at FROM simple_posts ORDER BY created_at DESC\",\n );\n const allPosts = [];\n\n if (postsResult && postsResult.rows) {\n for (const row of postsResult.rows) {\n const pId = Number(row.id);\n const pTitle = String(row.title || \"無題の記事\");\n const pContent = String(row.content || \"\");\n const pViews = Number(row.views || 0);\n const pDate = String(row.created_at || new Date().toISOString());\n\n // コメントを取得\n const commentsResult = await sqlite.execute({\n sql:\n \"SELECT name, text, created_at FROM simple_comments WHERE post_id = ? ORDER BY created_at ASC\",\n args: [pId],\n });\n const parsedComments = (commentsResult.rows || []).map((c) => ({\n name: String(c.name),\n text: String(c.text),\n date: String(c.created_at),\n }));\n\n allPosts.push({\n id: pId,\n title: pTitle,\n content: pContent,\n views: pViews,\n created_at: pDate,\n comments: parsedComments,\n });\n }\n }\n // （※ここから下の続きの画面表示コードは「2回目」で送るよ！）\n // ==========================================\n // 【本館永久保存版 2回目：ここからコピーして下に繋げてね】\n // ==========================================\n\n const html = `\n \n \n \n \n \n My Simple Database Blog\n \n \n \n\n

📝 永久保存できる僕のブログ

\n \n

\n\n

誰でも閲覧・コメント可能・管理者のみ記事編集可能

\n\n \n

✨ 新しい記事を書く

\n \n

\n\n \n

\n ${\n allPosts.length === 0\n ? '

まだ記事がありません。最初の記事を書いてみよう！

'\n : \"\"\n }\n ${\n allPosts.map((post) => `\n

${post.title}

\n 📅 ${\n new Date(post.created_at).toLocaleString(\"ja-JP\", {\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n })\n }\n 👁 ${post.views} 回閲覧\n

\n \n

${post.content}

\n \n \n

\n \n

\n\n \n

💬 コメント (${post.comments.length})

\n \n

\n ${\n post.comments.length === 0\n ? '

まだコメントはありません。

'\n : \"\"\n }\n ${\n post.comments.map((c) => `\n

\n 👤 ${c.name}\n 🕒 ${\n new Date(c.date).toLocaleString(\"ja-JP\", {\n month: \"2-digit\",\n day: \"2-digit\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n })\n }\n

${c.text}

\n `).join(\"\")\n }\n

\n\n \n

\n \n

\n\n

\n `).join(\"\")\n }\n

\n\n \n \n \n \n `;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=UTF-8\" },\n });\n}","fileType","http",11,"parentId","createdAt",["D",1788590259837],"branchVersion",12,"label",[19],{"_33":34,"_13":19,"_37":38,"_44":-5,"_35":36,"_47":48,"_52":53,"_45":54,"_17":43,"_41":42,"_39":40,"_55":56,"_49":-5,"_57":58,"_18":59},"latest",true,["D",1788590259837],"deleted",false,"children",[],[19],"f0e327fc-ef96-497e-929b-b05dbdb126a9",["D",1788585025730],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","ブログ（メモ帳？）","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":56},"branch",{"_17":48,"_13":16,"_33":36,"_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,"_45":149,"_62":-5,"_63":56,"_64":65,"_66":65,"_67":68,"_69":-5,"_70":71,"_72":38,"_73":53,"_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":150,"_95":151,"_97":152,"_99":56},[146],"files",[146],"counts",{"_136":77,"_137":138,"_139":77,"_32":140,"_141":142},[],{"_33":34,"_13":19,"_37":38,"_44":-5,"_35":36,"_47":48,"_52":53,"_45":134,"_17":43,"_41":42,"_39":40,"_55":56,"_49":-5,"_18":135},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788590259837],[19],"pulls","branches",1,"forks",{"_143":77,"_145":77},"connections",{"_143":77,"_144":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":19,"_37":38,"_44":-5,"_35":36,"_47":48,"_52":53,"_45":54,"_17":43,"_41":42,"_39":40,"_55":56,"_49":-5,"_57":147,"_18":148},[],[19],["D",1788585025730],{"_11":12,"_114":109},{"_11":12,"_108":109,"_110":109,"_70":71,"_111":112,"_113":56},{"_17":48,"_13":16,"_33":36,"_100":60,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_131":186,"_187":188,"_189":190,"_191":56,"_192":56,"_193":56,"_194":53,"_195":-5,"_196":-7,"_197":-7,"_198":77,"_199":56,"_200":56,"_201":-5,"_202":56,"_203":56,"_204":56,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":16,"_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","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"]