C
S
M
D
MMDD
M
request.url has the URL. I'd suggest reading the MDN docs on how to parse URLs (https://developer.mozilla.org/en-US/docs/Web/API/URL) and/or moving over to #workers-help for non-D1 specific questions
M
9/11/23, 2:36 PM
JCJCJM
GM
UDCM
DUU
DD
KD
RETURNINGDDDDDDDDDGMM
M
9/13/23, 8:59 PM
E
C
I
bun:sqlite instead of better-sqlite3.Cexport default {
async fetch(request, env, ctx) {
const res = await env.DB.prepare('SELECT 1;').all()
return new Response(JSON.stringify(res, null, 2));
},
};{
....
"results": [
{
"1": 1
}
]
}request.urlRETURNINGError: D1_ERROR: Error: SQL execute error: Execute returned results - did you mean to call query?bun:sqlitebetter-sqlite3const d1_lookup_code = await c.env.DB.prepare(`SELECT id, program, details FROM my_codes WHERE code = ?`).bind(code).first();
await c.env.DB.prepare(`DELETE FROM my_codes WHERE code = ?`).bind(code).run();await c.env.DB.prepare(`DELETE FROM my_codes WHERE code = ? RETURNING *`).bind(code).run()await c.env.DB.prepare(`DELETE FROM my_codes WHERE code = ? RETURNING *`).bind(code).first()