index.js 1.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. 'use strict';
  2. const _ = require('lodash');
  3. const AbstractDialect = require('../abstract');
  4. const ConnectionManager = require('./connection-manager');
  5. const Query = require('./query');
  6. const QueryGenerator = require('./query-generator');
  7. const DataTypes = require('../../data-types').mssql;
  8. class MssqlDialect extends AbstractDialect {
  9. constructor(sequelize) {
  10. super();
  11. this.sequelize = sequelize;
  12. this.connectionManager = new ConnectionManager(this, sequelize);
  13. this.QueryGenerator = new QueryGenerator({
  14. _dialect: this,
  15. sequelize
  16. });
  17. }
  18. }
  19. MssqlDialect.prototype.supports = _.merge(_.cloneDeep(AbstractDialect.prototype.supports), {
  20. 'DEFAULT': true,
  21. 'DEFAULT VALUES': true,
  22. 'LIMIT ON UPDATE': true,
  23. 'ORDER NULLS': false,
  24. lock: false,
  25. transactions: true,
  26. migrations: false,
  27. returnValues: {
  28. output: true
  29. },
  30. schemas: true,
  31. autoIncrement: {
  32. identityInsert: true,
  33. defaultValue: false,
  34. update: false
  35. },
  36. constraints: {
  37. restrict: false,
  38. default: true
  39. },
  40. index: {
  41. collate: false,
  42. length: false,
  43. parser: false,
  44. type: true,
  45. using: false,
  46. where: true
  47. },
  48. NUMERIC: true,
  49. tmpTableTrigger: true
  50. });
  51. ConnectionManager.prototype.defaultVersion = '12.0.2000'; // SQL Server 2014 Express
  52. MssqlDialect.prototype.Query = Query;
  53. MssqlDialect.prototype.name = 'mssql';
  54. MssqlDialect.prototype.TICK_CHAR = '"';
  55. MssqlDialect.prototype.TICK_CHAR_LEFT = '[';
  56. MssqlDialect.prototype.TICK_CHAR_RIGHT = ']';
  57. MssqlDialect.prototype.DataTypes = DataTypes;
  58. module.exports = MssqlDialect;