Azure DocumentDB不支持UPSERT。有没有合理的解决方法来实现相同的功能?
使用存储过程来检查文档是否存在以确定应执行插入还是更新是否是一种有效的策略?
如果我需要批量执行数千个操作怎么办?
使用存储过程来检查文档是否存在以确定应执行插入还是更新是否是一种有效的策略?
如果我需要批量执行数千个操作怎么办?
在这里为该功能投票:
http://feedback.azure.com/forums/263030-documentdb/suggestions/7075256-provide-for-upsert
更新 - 这是我尝试编写的批量 upsert 存储过程。
function bulkImport(docs) {
var collection = getContext().getCollection();
var collectionLink = collection.getSelfLink();
var count = 0;
if (!docs) throw new Error('Docs parameter is null');
var docsLength = docs.length;
if (docsLength == 0) {
getContext().getResponse().setBody(0);
}
tryUpsert(docs[count], callback);
function tryUpsert(doc, callback) {
var query = { query: ""select * from root r where r.id = @id"", parameters: [ {name: ""@id"", value: doc.id}]};
var isAccepted = collection.queryDocuments(collectionLink, query, function(err, resources, options) {
if (err) throw err;
if(resources.length > 0) {
// Perform a replace
var isAccepted = collection.replaceDocument(resources[0]._self, doc, callback);
if (!isAccepted) getContext().getResponse().setBody(count);
}
else {
// Perform a create
var isAccepted = collection.createDocument(collectionLink, doc, callback);
if (!isAccepted) getContext().getResponse().setBody(count);
}
});
if (!isAccepted) getContext().getResponse().setBody(count);
}
function callback(err, doc, options) {
if (err) throw err;
// One more document has been inserted, increment the count.
count++;
if (count >= docsLength) {
// If we have created all documents, we are done. Just set the response.
getContext().getResponse().setBody(count);
} else {
// Create next document.
tryUpsert(docs[count], callback);
}
}
}