How to use the ISOLATION_LEVEL function from mssql

shared-refresh-csv-rows.js

GitHub: uk-gov-mirror/defra.future-flood-forecasting-web-portal-importer

11
12
13
14
15
16
17
18
19
20
// Refresh with a serializable isolation level so that refresh is prevented if the table is in use.
// If the table is in use and table lock acquisition fails, the function invocation will fail.
// In most cases function invocation will be retried automatically and should succeed.  In rare
// cases where successive retries fail, the message that triggers the function invocation will be
// placed on a dead letter queue.  In this case, manual intervention will be required.
await doInTransaction(refreshInTransaction, context, `The ${refreshData.csvSourceFile} refresh has failed with the following error:`, sql.ISOLATION_LEVEL.SERIALIZABLE, refreshData)

// Transaction 2
// If a rollback has occurred, workflow refresh and message replay should not occur.
if (refreshData.workflowRefreshCsvType && refreshData.refreshRollbackRequested === false) {

3

0

0

+ 5 other calls in file