import { sqlite } from "https://esm.town/v/std/sqlite"; import { markdownToHtml } from "https://esm.town/v/xkonti/markdownToHtml"; import { Hono, HonoRequest } from "npm:hono"; import { basicAuth } from "npm:hono/basic-auth"; export default async function(req: Request): Promise { const app = new Hono(); app.use( "*", basicAuth({ username: Deno.env.get("USERNAME"), password: Deno.env.get("PASSWORD"), }), ); app.get("/", (c) => c.html(bugListTable("open"))); app.get("/all", (c) => c.html(bugListTable("all"))); app.get("/new", (c) => c.html(createBugForm(c.req))); app.post("/new", (c) => c.html(createBug(c.req))); app.get("/bug/:id", (c) => c.html(showBug(c.req))); app.get("/close/:id", (c) => c.html(closeBug(c.req))); app.get("/wontfix/:id", (c) => c.html(wontfixBug(c.req))); app.get("/projects", (c) => c.html(getProjects())); app.get("/projects/:name", (c) => c.html(getProject(c.req))); return app.fetch(req); } async function getTable(rows: any) { let html = ""; for (const row of rows.rows) { html += ``; } html += "

ID	Title	Project	Type	Status	Actions
${row[0]}	${row[1]}	${ row[4] }	${row[3]}	${row[5]}	\| \|

"; return html; } async function getProject(req: HonoRequest) { const name = req.param("name"); const rows = await sqlite.execute({ sql: "SELECT * FROM bugs WHERE project = ?", args: [name] }); let html = await getTable(rows); html += "

"; return await htmlWrapper(html); } async function distinctProjects(): any { return await sqlite.execute("SELECT DISTINCT project FROM bugs"); } async function getProjects() { const rows = await distinctProjects(); let html = ""; for (const row of rows.rows) { html += ``; } html += "

Project
${row[0]}

"; html += "

Home

"; return await htmlWrapper(html); } async function showBug(req: HonoRequest) { const id = req.param("id"); const rows = await sqlite.execute({ sql: "SELECT * FROM bugs WHERE id = ?", args: [id] }); let html = await getTable(rows); html += `${await markdownToHtml(rows.rows[0][2])}`; html += "

Home

"; return await htmlWrapper(html); } async function bugListTable(q: string) { let rows = await sqlite.execute("SELECT * FROM bugs where status='open'"); if (q == "all") { rows = await sqlite.execute("SELECT * FROM bugs"); } let html = await getTable(rows); html += "Show All | Show Open | New | Show Projects"; return await htmlWrapper(html); } async function createBugForm(req: HonoRequest) { let parent = req.query("parent"); let parentHTML = `Parent: `; let datalist = ``; const rows = await distinctProjects(); for (const row of rows.rows) { datalist += `"; let projectHTML = `Project: ${datalist}`; if (parent != null) { parentHTML = ``; const rows = await sqlite.execute({ sql: "select project from bugs where id=?", args: [parent] }); projectHTML = ``; } let body = ` Home `; return await htmlWrapper(body); } async function htmlWrapper(html: string) { const style = ``; return ` Bug Tracker ${style}

Bug Tracker

${html} `; } async function createBug(req: HonoRequest) { const formData = await req.formData(); const title = formData.get("title") as string; const description = formData.get("description") as string; const type = formData.get("type") as string; const project = formData.get("project") as string; const status = formData.get("status") as string; const parent = formData.get("parent") as string; await sqlite.execute({ sql: `INSERT INTO bugs (title, description, type, project, status, parent) VALUES (?, ?, ?, ?, ?, ?)`, args: [title, description, type, project, status, parent], }); return createBugForm(req); } async function closeBug(req: HonoRequest) { const id = req.param("id"); await sqlite.execute({ sql: `UPDATE bugs SET status = 'closed', closedtime = CURRENT_TIMESTAMP WHERE id = ?`, args: [id], }); return bugListTable(req); } async function wontfixBug(req: HonoRequest) { const id = req.param("id"); await sqlite.execute({ sql: `UPDATE bugs SET status = 'wontfix', closedtime = CURRENT_TIMESTAMP WHERE id = ?`, args: [id], }); return bugListTable(req); }

flymaster