[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_101":102,"_103":104},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","konnnitiha","name","brog","path","main.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/konnnitiha/brog/code/main.ts","extension","id","c8f548b9-608e-463b-92bc-cc9ac20793b8","fileId","b6d62544-a8f4-11f1-a9fa-1607ee4eb77e","parentId","branchId","f1f4f591-0e87-49a4-ae7f-f2e20b870867","branchVersion",4,"latest",true,"createdAt",["D",1788590585011],"version",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",false,"label",[14],"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",0,"orgId","01a06c07-a416-700f-9d79-6326f651fc92","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_100":95},"org",{"_9":10,"_94":95,"_96":95,"_55":56,"_97":98,"_99":42},"branch",{"_35":30,"_11":85,"_22":28,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":12,"_93":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","ctx",{"_78":-5,"_134":135,"_136":137,"_138":139,"_140":42,"_141":42,"_142":42,"_143":32,"_144":-5,"_145":-7,"_146":-7,"_147":62,"_148":42,"_149":42,"_150":-5,"_151":42,"_152":42,"_153":42,"_154":-5},"ENV",{"_105":106,"_107":108,"_109":85,"_110":111,"_112":113,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]