[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_151":152,"_153":154},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_103":86,"_27":36,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":25,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_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":25},"version",2,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","b6d62544-a8f4-11f1-a9fa-1607ee4eb77e","name","fileType","script","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}","createdAt",["D",1788590463316],"branchVersion","branchId","f1f4f591-0e87-49a4-ae7f-f2e20b870867","id","d3c67252-fcdb-4b77-b25a-a7e028031bee","brog",["D",1788590441775],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","ブログ（恐らく完成版）","imageUrl","e8dc4c42-368d-443a-bdb0-f12c12a7ed90","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a06c07-a416-700f-9d79-6326f651fc92","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_102":36},"org",{"_96":95,"_97":36,"_98":36,"_18":55,"_99":100,"_101":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned",4,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","konnnitiha","handle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":147,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_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":148,"_80":149,"_82":150,"_84":25},"tree",[142],"files",[142],"counts",{"_132":62,"_133":129,"_134":62,"_135":136,"_137":138},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":128,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_27":131},"ef173941-3d5a-415f-a12e-0b2334608210","parentId","latest",["D",1788590463316],1,"label",[28],"pulls","branches","forks","envVars",{"_139":62,"_141":62},"connections",{"_139":62,"_140":62},"count","unfilledCount","emptyCount",{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":143,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_144":145,"_27":146},["D",1788590463316],"children",[],[28],["D",1788590441775],{"_96":95,"_102":36},{"_96":95,"_97":36,"_98":36,"_18":55,"_99":100,"_101":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_121":184,"_185":186,"_187":188,"_189":25,"_190":25,"_191":25,"_192":58,"_193":-5,"_194":-7,"_195":-7,"_196":62,"_197":25,"_198":25,"_199":-5,"_200":25,"_201":25,"_202":25,"_203":-5},"ENV",{"_155":156,"_157":158,"_159":86,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183},"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"]

Diff · v2