[{"_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":16,"_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.branch.$branch.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","uo","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","32493693-901b-4c08-97ba-b02375c2d0b2","main.ts","fileId","1a9e7124-a8e8-11f1-878c-1607ee4eb77e","parentId","branchId","f8de2692-2037-4ece-a4cf-56683681b892","branchVersion",12,"latest",true,"createdAt",["D",1788590259837],11,"fileType","http","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}","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",1788590259837],"children",[],[35],"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":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",1788585025730],{"_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","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"]

Code