import { sqlite } from "https://esm.town/v/std/sqlite?v=4"; import { Hono } from "npm:hono@3"; const app = new Hono(); app.get("/", async (c) => { var page = parseInt(c.req.query("page") || "0"); var offset = 0; if (page && page > 0) { offset = page * 10; } var bookmarks = await sqlite.execute({ sql: "select title, url from bookmarks order by created_at desc limit 10 offset :offset", args: { offset: offset }, }); var totalBookmarkRows = await sqlite.execute("select count(1) from bookmarks order by created_at desc"); var totalBookmarks = parseInt(totalBookmarkRows.rows[0][0].toString()); var pagesCount = Math.floor( ((totalBookmarks % 10) == 0 && totalBookmarks / 10 > 0) ? ((totalBookmarks / 10) - 1) : (totalBookmarks / 10), ); var bookmarksList = ""; for (var i = 0; i < bookmarks.rows.length; i++) { bookmarksList += "

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

"; } var pagination = "

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

"; const html = ` My reading list

Reading list

` + bookmarksList + pagination + ` `; return new Response( html, { headers: { "Content-Type": "text/html", }, }, ); }); app.get("/save", async (c) => { const id = c.req.query("id"); const secret = c.req.query("secret"); const title = c.req.query("t"); const url = c.req.query("u"); if (!id && !secret) { return c.text("Authentication details (ID/Secret) missing!"); } if (id != Deno.env.get("bookmarks_client_id") || secret != Deno.env.get("bookmarks_client_secret")) { return c.text("Unauthorized!"); } if (!url) { return c.text("URL missing!"); } const create_table = await sqlite.execute( "CREATE TABLE IF NOT EXISTS bookmarks (title TEXT, url TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP)", ); const res = await sqlite.execute({ sql: `insert into bookmarks (title, url) values (:title, :url)`, args: { title: title, url: url }, }); return c.text("Saved!"); }); app.get("/api/bookmarks", async (c) => { var baseUrl = c.req.url; var page = parseInt(c.req.query("page") || "0"); var offset = 0; if (page && page > 0) { offset = page * 10; } var bookmarks = await sqlite.execute({ sql: "select title, url from bookmarks order by created_at desc limit 10 offset :offset", args: { offset: offset }, }); var totalBookmarkRows = await sqlite.execute("select count(1) from bookmarks order by created_at desc"); var totalBookmarks = parseInt(totalBookmarkRows.rows[0][0].toString()); var pagesCount = Math.floor( ((totalBookmarks % 10) == 0 && totalBookmarks / 10 > 0) ? ((totalBookmarks / 10) - 1) : (totalBookmarks / 10), ); let response = { prev: page > 0 ? baseUrl + "?page=" + (page - 1) : null, next: page < pagesCount ? baseUrl + "?page=" + (page + 1) : null, data: bookmarks.rows.map(b => { return { title: b[0], url: b[1], }; }), }; return c.json(response); }); export default app.fetch;