transaction.js
2.25 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
import Promise from 'bluebird';
import Transaction from '../../transaction';
const debug = require('debug')('knex:tx')
export default class Transaction_MSSQL extends Transaction {
begin(conn) {
debug('%s: begin', this.txid)
return conn.tx_.begin()
.then(this._resolver, this._rejecter)
}
savepoint(conn) {
debug('%s: savepoint at', this.txid)
return Promise.resolve()
.then(() => this.query(conn, `SAVE TRANSACTION ${this.txid}`))
}
commit(conn, value) {
this._completed = true
debug('%s: commit', this.txid)
return conn.tx_.commit()
.then(() => this._resolver(value), this._rejecter)
}
release(conn, value) {
return this._resolver(value)
}
rollback(conn, error) {
this._completed = true
debug('%s: rolling back', this.txid)
return conn.tx_.rollback()
.then(
() => this._rejecter(error),
err => {
if (error) err.originalError = error;
return this._rejecter(err);
}
)
}
rollbackTo(conn, error) {
debug('%s: rolling backTo', this.txid)
return Promise.resolve()
.then(() => this.query(conn, `ROLLBACK TRANSACTION ${this.txid}`, 2, error))
.then(() => this._rejecter(error))
}
// Acquire a connection and create a disposer - either using the one passed
// via config or getting one off the client. The disposer will be called once
// the original promise is marked completed.
acquireConnection(config) {
const t = this
const configConnection = config && config.connection
return Promise.try(() => {
return (t.outerTx ? t.outerTx.conn : null) ||
configConnection ||
t.client.acquireConnection();
}).tap(function(conn) {
if (!t.outerTx) {
t.conn = conn
conn.tx_ = conn.transaction()
}
}).disposer(function(conn) {
if (t.outerTx) return;
if (conn.tx_) {
if (!t._completed) {
debug('%s: unreleased transaction', t.txid)
conn.tx_.rollback();
}
conn.tx_ = null;
}
t.conn = null
if (!configConnection) {
debug('%s: releasing connection', t.txid)
t.client.releaseConnection(conn)
} else {
debug('%s: not releasing external connection', t.txid)
}
})
}
}