Y
B
CYBYB
L
d1.batch
SELECTUPDATELIMIT 1
TT
M
Z
D
JJ
O
TDD
OD
OD
M
B
J
神神M神
神M神神M神M神M
T
V
db rather than tx does.V
SVVV
To execute a transaction, please use the state.storage.transaction() API instead of the SQL BEGIN TRANSACTION or SAVEPOINT statements. The JavaScript API is safer because it will automatically roll back on exceptions, and because it interacts correctly with Durable Objects' automatic atomic write coalescing.dbtxError: D1_ERROR: not authorized: SQLITE_AUTH
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async SQLiteD1Session.transaction (...) {
[cause]: Error: not authorized: SQLITE_AUTH
at D1Database._sendOrThrow (cloudflare-internal:d1-api:67:24)
at async D1PreparedStatement.run (cloudflare-internal:d1-api:178:29) {
[cause]: undefined
}
}db.transaction(async (tx) => {
const returned = await tx
.insert(schema.universities)
.values({ handle: form.data.handle })
.returning({ id: schema.universities.id });
await tx.insert(schema.localizedUniversityNames).values({
university: returned[0].id,
languageTag: form.data.languageTag,
name: form.data.name,
});
});