\" + (page * 10 + i + 1) + \". \" + bookmarks.rows[i][0]\n + \"

\";\n }\n var pagination = \"

\";\n if (page > 0) {\n pagination += \" < prev \";\n }\n if (page < pagesCount) {\n pagination += \" next > \";\n }\n pagination += \"

\";\n const html = `\n \n My reading list\n \n \n \n

Reading list

`\n + bookmarksList\n + pagination + `\n `;\n return new Response(\n html,\n {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n },\n );\n});\n\napp.get(\"/save\", async (c) => {\n const id = c.req.query(\"id\");\n const secret = c.req.query(\"secret\");\n const title = c.req.query(\"t\");\n const url = c.req.query(\"u\");\n if (!id && !secret) {\n return c.text(\"Authentication details (ID/Secret) missing!\");\n }\n if (id != Deno.env.get(\"bookmarks_client_id\") || secret != Deno.env.get(\"bookmarks_client_secret\")) {\n return c.text(\"Unauthorized!\");\n }\n if (!url) {\n return c.text(\"URL missing!\");\n }\n const create_table = await sqlite.execute(\n \"CREATE TABLE IF NOT EXISTS bookmarks (title TEXT, url TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP)\",\n );\n const res = await sqlite.execute({\n sql: `insert into bookmarks (title, url) values (:title, :url)`,\n args: { title: title, url: url },\n });\n return c.text(\"Saved!\");\n});\n\nexport default app.fetch;","deleted","label",[98],"permalink","https://www.val.town/x/stevekrouse/bookmark/code/main.tsx","extension","actionData","errors"]