... logged to D1 database { result: Promise { <pending> } }INSERT.... logged to D1 database { result: Promise { <pending> } }INSERT try {
// Check if the DB is reachable
env.DB.prepare("SELECT 1").first();
const result = env.DB.prepare("INSERT INTO ... (...) VALUES (?, ?, ?, ?)")
.bind()
.run()
.then((result: unknown) => {
console.debug("Insertion result:", result);
})
.catch((error: unknown) => {
console.error("Error inserting data:", error);
throw error; // Rethrow to handle in the catch block
});
console.debug({ ... }, "logged to D1 database", { result });
} catch (err) {
console.error("Insertion into", { env }, "failed", err);
}
HPromise.Hawait instead of then and catchawait, I see the error, although I believe that makes the database insertion a blocking operation.
Iawait. You can't see the value of a Promise before it's completed, and the console.debug({}) is run before the result of the Promise.I
T
D
JJTJHHH
env and ctx?HHExportedHandler and Env?
Sconst db = drizzle(env.DB); everywhere they need the db. is that the way to go? or is it still possible to somehow export 1 drizzle client globally?
HSS
BB
await DB.prepare('SELECT col FROM table WHERE col1 = ?2 AND col2 = ?1 AND col3 = ?1').bind(1, 2).run()
ISELECT file_id FROM file WHERE ref_id = '123'"rows_read": 2npx wrangler d1 migrations --helpnpx wrangler d1 migrations apply --helppersist-to
--help
I
S
JS
M
LM
OLAlso is there any way to prevent this replication? Like when does that happen? If for anyone outside of an specific region no DB access happens, does that mean no replication is happening either?There is no replication at the moment. Once it's out, we will have some control for jurisdictions once those are added for D1.
MM
L
meta
CMRPHHif (e.message.startsWith(`D1_ERROR: UNIQUE constraint failed:`)){
throw createError({statusCode:400, statusMessage:`Your name needs to be unique`})
}PromiseawaitawaitawaitthenenvctxExportedHandlerEnvconst db = drizzle(env.DB);await DB.prepare('SELECT col FROM table WHERE col1 = ?2 AND col2 = ?1 AND col3 = ?1').bind(1, 2).run() const result = env.DB.prepare("INSERT INTO ... (...) VALUES (?, ?, ?, ?)")
.bind()
.run(); async fetch(request: Request, env: any): Promise<Response>async fetch(request, env, ctx)
CDCloudflare Developers / workers-and-pages-helpCDCloudflare Developers / general-helpCDCloudflare Developers / workers-and-pages-helpCDCloudflare Developers / general-help