II
DD
KKD
DDIID
JJIIIJ
K
M
BBB
.set() method if one takes only 1 write.B
M
.upsert()BM
E
VM
H
MH
UMU
UME
BUBUB
[cause]: Error: FOREIGN KEY constraint failedU
BUBBblobId, but shouldnt last_insert_rowid() return the idblob ? as in the first batch statement?B
.set().upsert()await this.db.batch([
this.db.insert(blobs).values({ hash: blobHash }),
this.db
.insert(assets)
.values({ projectId, blobId: sql`last_insert_rowid()` })
.returning({ assetId: assets.id }),
]); [cause]: Error: FOREIGN KEY constraint failedblobIdlast_insert_rowid()blobbool SqlStorage::isAllowedName(kj::StringPtr name) {
return !name.startsWith("_cf_");
}INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...)
ON CONFLICT (constraint_column)
DO UPDATE SET column1 = value1, column2 = value2, ...;INSERT OR REPLACE INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);