client.js 13 KB

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