Description
cbq> EXECUTE FUNCTION doDelivery(1,7,"2022-01-10 11:07:35.066141"); |
{
|
"requestID": "e66e7cc7-295a-4fab-b04c-cfcc9e7de3c1", |
"signature": null, |
"results": [ |
[
|
1, |
2418 |
]
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "51.530981ms", |
"executionTime": "51.420036ms", |
"resultCount": 1, |
"resultSize": 31, |
"serviceLoad": 3, |
"transactionElapsedTime": "22.330848ms", |
"transactionRemainingTime": "14.977660267s" |
}
|
}
|
function doDelivery(w_id,o_carrier_id,ol_delivery_d){
|
|
try{ |
var querybegin=BEGIN WORK;
|
querybegin.close();
|
|
var result = [];
|
var d_id=1; |
var params = [d_id,w_id];
|
var query= N1QL('EXECUTE DELIVERY_getNewOrder',params); |
var newOrder = [];
|
for (const row of query) { |
newOrder.push(row);
|
}
|
query.close();
|
|
if (newOrder.length == 0){ |
/*## No orders for this district: skip it. Note: This must be reported if > 1%*/ |
var query = COMMIT WORK;
|
return; |
}
|
var no_o_id = newOrder[0]['NO_O_ID']; |
|
params = [no_o_id, d_id, w_id];
|
var query = N1QL('EXECUTE DELIVERY_getCId',params); |
var rs = [];
|
....
|
....
|
|
var query = COMMIT WORK;
|
query.close();
|
|
return result; |
}catch (error){ var query = ROLLBACK WORK; throw error; |
}
|