[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_162":163,"_164":165},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_61":127,"_16":-7,"_133":-5,"_17":134,"_135":136,"_28":137,"_21":138,"_23":139,"_140":-5,"_141":-5,"_142":-5,"_143":35,"_144":145,"_146":38,"_147":-5,"_148":-5,"_149":150},"routes/_app.x.$handle.$name._index",{"_11":12,"_13":14,"_15":-7,"_16":-7,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-7,"_26":-5,"_27":-5,"_28":29,"_30":31,"_32":-5,"_33":-5,"_34":35,"_36":35,"_37":38},"handle","konnnitiha","name","brog","branchName","version","project",{"_39":78,"_13":14,"_50":79,"_80":-5,"_81":35,"_82":83,"_84":83,"_85":86,"_87":-5,"_88":89,"_90":43,"_91":38,"_92":-5,"_93":-5,"_94":67,"_95":96,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":111,"_112":113,"_114":115,"_116":35},"tags",[],"counts",{"_66":67,"_68":69,"_70":67,"_71":72,"_73":74},"contents",[63],"readme","upstream","pull","files",[31],"preview",{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":51,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_59":60,"_61":62},"ahead","behind","showHomeCustomizationHint",false,"showHTTPPreviewSettingsHint","hasHTTPFiles",true,"id","c8f548b9-608e-463b-92bc-cc9ac20793b8","main.ts","fileId","b6d62544-a8f4-11f1-a9fa-1607ee4eb77e","parentId","branchId","f1f4f591-0e87-49a4-ae7f-f2e20b870867","branchVersion",4,"latest","createdAt",["D",1788590585011],3,"fileType","http","content","// ==========================================\n// 【本館永久保存版 1回目：ここから貼り付け】\n// ==========================================\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// 🔑 あなただけの秘密のログインパスワード\nconst ADMIN_PASSWORD = \"fj10576890:^\";\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","label","children",[],"path",[41],{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":64,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_61":65},["D",1788590585011],[41],"pulls",0,"branches",1,"forks","envVars",{"_75":67,"_77":67},"connections",{"_75":67,"_76":67},"count","unfilledCount","emptyCount","d3c67252-fcdb-4b77-b25a-a7e028031bee",["D",1788590441775],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","ブログ（恐らく完成版）","imageUrl","userId","e8dc4c42-368d-443a-bdb0-f12c12a7ed90","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a06c07-a416-700f-9d79-6326f651fc92","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_132":127},"org",{"_11":12,"_126":127,"_128":127,"_88":89,"_129":130,"_131":35},"branch",{"_16":48,"_13":117,"_39":46,"_118":78,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_39":78,"_13":14,"_50":158,"_80":-5,"_81":35,"_82":83,"_84":83,"_85":86,"_87":-5,"_88":89,"_90":43,"_91":38,"_92":-5,"_93":-5,"_94":67,"_95":96,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":159,"_112":160,"_114":161,"_116":35},"tree",[155],[155],{"_66":67,"_68":69,"_70":67,"_71":153,"_73":154},[151],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":64,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_61":152},[41],{"_75":67,"_77":67},{"_75":67,"_76":67},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":38,"_50":51,"_16":52,"_53":54,"_55":56,"_57":35,"_58":-5,"_59":156,"_61":157},[],[41],["D",1788590441775],{"_11":12,"_132":127},{"_11":12,"_126":127,"_128":127,"_88":89,"_129":130,"_131":35},{"_16":48,"_13":117,"_39":46,"_118":78,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"ctx",{"_110":-5,"_148":195,"_196":197,"_198":199,"_200":35,"_201":35,"_202":35,"_203":38,"_204":-5,"_205":-7,"_206":-7,"_207":67,"_208":35,"_209":35,"_210":-5,"_211":35,"_212":35,"_213":35,"_214":-5},"ENV",{"_166":167,"_168":169,"_170":117,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194},"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"]