client.js 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365
  1. 'use strict';
  2. exports.__esModule = true;
  3. var _cloneDeep2 = require('lodash/cloneDeep');
  4. var _cloneDeep3 = _interopRequireDefault(_cloneDeep2);
  5. var _uniqueId2 = require('lodash/uniqueId');
  6. var _uniqueId3 = _interopRequireDefault(_uniqueId2);
  7. var _assign2 = require('lodash/assign');
  8. var _assign3 = _interopRequireDefault(_assign2);
  9. var _bluebird = require('bluebird');
  10. var _bluebird2 = _interopRequireDefault(_bluebird);
  11. var _helpers = require('./helpers');
  12. var helpers = _interopRequireWildcard(_helpers);
  13. var _raw = require('./raw');
  14. var _raw2 = _interopRequireDefault(_raw);
  15. var _runner = require('./runner');
  16. var _runner2 = _interopRequireDefault(_runner);
  17. var _formatter = require('./formatter');
  18. var _formatter2 = _interopRequireDefault(_formatter);
  19. var _transaction = require('./transaction');
  20. var _transaction2 = _interopRequireDefault(_transaction);
  21. var _builder = require('./query/builder');
  22. var _builder2 = _interopRequireDefault(_builder);
  23. var _compiler = require('./query/compiler');
  24. var _compiler2 = _interopRequireDefault(_compiler);
  25. var _builder3 = require('./schema/builder');
  26. var _builder4 = _interopRequireDefault(_builder3);
  27. var _compiler3 = require('./schema/compiler');
  28. var _compiler4 = _interopRequireDefault(_compiler3);
  29. var _tablebuilder = require('./schema/tablebuilder');
  30. var _tablebuilder2 = _interopRequireDefault(_tablebuilder);
  31. var _tablecompiler = require('./schema/tablecompiler');
  32. var _tablecompiler2 = _interopRequireDefault(_tablecompiler);
  33. var _columnbuilder = require('./schema/columnbuilder');
  34. var _columnbuilder2 = _interopRequireDefault(_columnbuilder);
  35. var _columncompiler = require('./schema/columncompiler');
  36. var _columncompiler2 = _interopRequireDefault(_columncompiler);
  37. var _genericPool = require('generic-pool');
  38. var _inherits = require('inherits');
  39. var _inherits2 = _interopRequireDefault(_inherits);
  40. var _events = require('events');
  41. var _string = require('./query/string');
  42. function _interopRequireWildcard(obj) { if (obj && obj.__esModule) { return obj; } else { var newObj = {}; if (obj != null) { for (var key in obj) { if (Object.prototype.hasOwnProperty.call(obj, key)) newObj[key] = obj[key]; } } newObj.default = obj; return newObj; } }
  43. function _interopRequireDefault(obj) { return obj && obj.__esModule ? obj : { default: obj }; }
  44. var debug = require('debug')('knex:client');
  45. var debugQuery = require('debug')('knex:query');
  46. var debugBindings = require('debug')('knex:bindings');
  47. var debugPool = require('debug')('knex:pool');
  48. var id = 0;
  49. function clientId() {
  50. return 'client' + id++;
  51. }
  52. // The base client provides the general structure
  53. // for a dialect specific client object.
  54. function Client() {
  55. var config = arguments.length > 0 && arguments[0] !== undefined ? arguments[0] : {};
  56. this.config = config;
  57. //Client is a required field, so throw error if it's not supplied.
  58. //If 'this.dialect' is set, then this is a 'super()' call, in which case
  59. //'client' does not have to be set as it's already assigned on the client prototype.
  60. if (!this.config.client && !this.dialect) {
  61. throw new Error('knex: Required configuration option \'client\' is missing.');
  62. }
  63. this.connectionSettings = (0, _cloneDeep3.default)(config.connection || {});
  64. if (this.driverName && config.connection) {
  65. this.initializeDriver();
  66. if (!config.pool || config.pool && config.pool.max !== 0) {
  67. this.__cid = clientId();
  68. this.initializePool(config);
  69. }
  70. }
  71. this.valueForUndefined = this.raw('DEFAULT');
  72. if (config.useNullAsDefault) {
  73. this.valueForUndefined = null;
  74. }
  75. }
  76. (0, _inherits2.default)(Client, _events.EventEmitter);
  77. (0, _assign3.default)(Client.prototype, {
  78. formatter: function formatter() {
  79. return new _formatter2.default(this);
  80. },
  81. queryBuilder: function queryBuilder() {
  82. return new _builder2.default(this);
  83. },
  84. queryCompiler: function queryCompiler(builder) {
  85. return new _compiler2.default(this, builder);
  86. },
  87. schemaBuilder: function schemaBuilder() {
  88. return new _builder4.default(this);
  89. },
  90. schemaCompiler: function schemaCompiler(builder) {
  91. return new _compiler4.default(this, builder);
  92. },
  93. tableBuilder: function tableBuilder(type, tableName, fn) {
  94. return new _tablebuilder2.default(this, type, tableName, fn);
  95. },
  96. tableCompiler: function tableCompiler(tableBuilder) {
  97. return new _tablecompiler2.default(this, tableBuilder);
  98. },
  99. columnBuilder: function columnBuilder(tableBuilder, type, args) {
  100. return new _columnbuilder2.default(this, tableBuilder, type, args);
  101. },
  102. columnCompiler: function columnCompiler(tableBuilder, columnBuilder) {
  103. return new _columncompiler2.default(this, tableBuilder, columnBuilder);
  104. },
  105. runner: function runner(connection) {
  106. return new _runner2.default(this, connection);
  107. },
  108. transaction: function transaction(container, config, outerTx) {
  109. return new _transaction2.default(this, container, config, outerTx);
  110. },
  111. raw: function raw() {
  112. var _ref;
  113. return (_ref = new _raw2.default(this)).set.apply(_ref, arguments);
  114. },
  115. _formatQuery: function _formatQuery(sql, bindings, timeZone) {
  116. var _this = this;
  117. bindings = bindings == null ? [] : [].concat(bindings);
  118. var index = 0;
  119. return sql.replace(/\\?\?/g, function (match) {
  120. if (match === '\\?') {
  121. return '?';
  122. }
  123. if (index === bindings.length) {
  124. return match;
  125. }
  126. var value = bindings[index++];
  127. return _this._escapeBinding(value, { timeZone: timeZone });
  128. });
  129. },
  130. _escapeBinding: (0, _string.makeEscape)({
  131. escapeString: function escapeString(str) {
  132. return '\'' + str.replace(/'/g, "''") + '\'';
  133. }
  134. }),
  135. query: function query(connection, obj) {
  136. var _this2 = this;
  137. if (typeof obj === 'string') obj = { sql: obj };
  138. obj.bindings = this.prepBindings(obj.bindings);
  139. debugQuery(obj.sql);
  140. this.emit('query', (0, _assign3.default)({ __knexUid: connection.__knexUid }, obj));
  141. debugBindings(obj.bindings);
  142. return this._query(connection, obj).catch(function (err) {
  143. err.message = _this2._formatQuery(obj.sql, obj.bindings) + ' - ' + err.message;
  144. _this2.emit('query-error', err, (0, _assign3.default)({ __knexUid: connection.__knexUid }, obj));
  145. throw err;
  146. });
  147. },
  148. stream: function stream(connection, obj, _stream, options) {
  149. if (typeof obj === 'string') obj = { sql: obj };
  150. this.emit('query', (0, _assign3.default)({ __knexUid: connection.__knexUid }, obj));
  151. debugQuery(obj.sql);
  152. obj.bindings = this.prepBindings(obj.bindings);
  153. debugBindings(obj.bindings);
  154. return this._stream(connection, obj, _stream, options);
  155. },
  156. prepBindings: function prepBindings(bindings) {
  157. return bindings;
  158. },
  159. wrapIdentifier: function wrapIdentifier(value) {
  160. return value !== '*' ? '"' + value.replace(/"/g, '""') + '"' : '*';
  161. },
  162. initializeDriver: function initializeDriver() {
  163. try {
  164. this.driver = this._driver();
  165. } catch (e) {
  166. helpers.exit('Knex: run\n$ npm install ' + this.driverName + ' --save\n' + e.stack);
  167. }
  168. },
  169. poolDefaults: function poolDefaults(poolConfig) {
  170. var _this3 = this;
  171. var name = this.dialect + ':' + this.driverName + ':' + this.__cid;
  172. return {
  173. min: 2,
  174. max: 10,
  175. name: name,
  176. log: function log(str, level) {
  177. if (level === 'info') {
  178. debugPool(level.toUpperCase() + ' pool ' + name + ' - ' + str);
  179. }
  180. },
  181. create: function create(callback) {
  182. _this3.acquireRawConnection().tap(function (connection) {
  183. connection.__knexUid = (0, _uniqueId3.default)('__knexUid');
  184. if (poolConfig.afterCreate) {
  185. return _bluebird2.default.promisify(poolConfig.afterCreate)(connection);
  186. }
  187. }).asCallback(callback);
  188. },
  189. destroy: function destroy(connection) {
  190. if (poolConfig.beforeDestroy) {
  191. helpers.warn('\n beforeDestroy is deprecated, please open an issue if you use this\n to discuss alternative apis\n ');
  192. poolConfig.beforeDestroy(connection, function () {});
  193. }
  194. if (connection !== void 0) {
  195. _this3.destroyRawConnection(connection);
  196. }
  197. },
  198. validate: function validate(connection) {
  199. if (connection.__knex__disposed) {
  200. helpers.warn('Connection Error: ' + connection.__knex__disposed);
  201. return false;
  202. }
  203. return _this3.validateConnection(connection);
  204. }
  205. };
  206. },
  207. initializePool: function initializePool(config) {
  208. if (this.pool) {
  209. helpers.warn('The pool has already been initialized');
  210. return;
  211. }
  212. this.pool = new _genericPool.Pool((0, _assign3.default)(this.poolDefaults(config.pool || {}), config.pool));
  213. },
  214. validateConnection: function validateConnection(connection) {
  215. return true;
  216. },
  217. // Acquire a connection from the pool.
  218. acquireConnection: function acquireConnection() {
  219. var _this4 = this;
  220. return new _bluebird2.default(function (resolver, rejecter) {
  221. if (!_this4.pool) {
  222. return rejecter(new Error('Unable to acquire a connection'));
  223. }
  224. var wasRejected = false;
  225. var t = setTimeout(function () {
  226. wasRejected = true;
  227. rejecter(new _bluebird2.default.TimeoutError('Knex: Timeout acquiring a connection. The pool is probably full. ' + 'Are you missing a .transacting(trx) call?'));
  228. }, _this4.config.acquireConnectionTimeout || 60000);
  229. _this4.pool.acquire(function (err, connection) {
  230. if (err) {
  231. return rejecter(err);
  232. }
  233. clearTimeout(t);
  234. if (wasRejected) {
  235. _this4.pool.release(connection);
  236. } else {
  237. debug('acquired connection from pool: %s', connection.__knexUid);
  238. resolver(connection);
  239. }
  240. });
  241. });
  242. },
  243. // Releases a connection back to the connection pool,
  244. // returning a promise resolved when the connection is released.
  245. releaseConnection: function releaseConnection(connection) {
  246. var _this5 = this;
  247. return new _bluebird2.default(function (resolver) {
  248. debug('releasing connection to pool: %s', connection.__knexUid);
  249. _this5.pool.release(connection);
  250. resolver();
  251. });
  252. },
  253. // Destroy the current connection pool for the client.
  254. destroy: function destroy(callback) {
  255. var _this6 = this;
  256. var promise = new _bluebird2.default(function (resolver) {
  257. if (!_this6.pool) {
  258. return resolver();
  259. }
  260. _this6.pool.drain(function () {
  261. _this6.pool.destroyAllNow(function () {
  262. _this6.pool = undefined;
  263. resolver();
  264. });
  265. });
  266. });
  267. // Allow either a callback or promise interface for destruction.
  268. if (typeof callback === 'function') {
  269. promise.asCallback(callback);
  270. } else {
  271. return promise;
  272. }
  273. },
  274. // Return the database being used by this client.
  275. database: function database() {
  276. return this.connectionSettings.database;
  277. },
  278. toString: function toString() {
  279. return '[object KnexClient]';
  280. },
  281. canCancelQuery: false,
  282. assertCanCancelQuery: function assertCanCancelQuery() {
  283. if (!this.canCancelQuery) {
  284. throw new Error("Query cancelling not supported for this dialect");
  285. }
  286. },
  287. cancelQuery: function cancelQuery() {
  288. throw new Error("Query cancelling not supported for this dialect");
  289. }
  290. });
  291. exports.default = Client;
  292. module.exports = exports['default'];