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

\";\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 bookmarks\n \n \n \n

My Bookmarks

`\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 fbToken = c.req.query(\"fbToken\");\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 (fbToken !== Deno.env.get(\"FEEDBIN_TOKEN\") || !Deno.env.get(\"FEEDBIN_EMAIL\") || !Deno.env.get(\"FEEDBIN_PSWD\")) {\n return c.text(\"No Feedbin credentials provided!\");\n }\n if (!url) {\n return c.text(\"URL missing!\");\n }\n\n // Then attempt to send to Feedbin\n const feedbinResult = await sendToFeedbin(url, title);\n\n if (feedbinResult) {\n // Since we saved to Feedbin, we add record to SQL bookmarks table\n try {\n const res = await sqlite.execute({\n sql: `insert into bookmarks (title, url, summary) values (:title, :url, :summary)`,\n args: {\n title: feedbinResult.title || title,\n url: feedbinResult.url || url,\n summary: feedbinResult.summary || \"\",\n },\n });\n } catch (error) {\n console.error(\"Failed to save new record in bookmarks table:\", error);\n }\n\n return c.text(\"Saved to Feedbin and Val!\");\n } else {\n return c.text(\"Saved to Val, but Feedbin sync failed\");\n }\n});\n\napp.get(\"/api/bookmarks\", async (c) => {\n var baseUrl = c.req.url;\n var page = parseInt(c.req.query(\"page\") || \"0\");\n var offset = 0;\n if (page && page > 0) {\n offset = page * 10;\n }\n var bookmarks = await sqlite.execute({\n sql: \"select title, url from bookmarks order by created_at desc limit 10 offset :offset\",\n args: { offset: offset },\n });\n\n var totalBookmarkRows = await sqlite.execute(\"select count(1) from bookmarks order by created_at desc\");\n var totalBookmarks = parseInt(totalBookmarkRows.rows[0][0].toString());\n var pagesCount = Math.floor(\n ((totalBookmarks % 10) == 0 && totalBookmarks / 10 > 0)\n ? ((totalBookmarks / 10) - 1)\n : (totalBookmarks / 10),\n );\n let response = {\n prev: page > 0 ? baseUrl + \"?page=\" + (page - 1) : null,\n next: page < pagesCount ? baseUrl + \"?page=\" + (page + 1) : null,\n data: bookmarks.rows.map(b => {\n return {\n title: b[0],\n url: b[1],\n };\n }),\n };\n\n return c.json(response);\n});\n\nexport default app.fetch;","deleted","label",[99],"permalink","https://www.val.town/x/juanca/bookmark/code/main.tsx","extension","actionData","errors"]