Sequelize/packages/core/test/unit/dialects/mssql/query.test.js

'use strict';

const { MsSqlQuery: Query } = require('@sequelize/mssql');
const Support = require('../../../support');

const dialect = Support.getTestDialect();
const sequelize = Support.sequelize;
const expect = require('chai').expect;
const tedious = require('tedious');

const connectionStub = { lib: tedious };

let query;

if (dialect === 'mssql') {
  describe('[MSSQL Specific] Query', () => {
    beforeEach(() => {
      const options = {
        transaction: { name: 'transactionName' },
        isolationLevel: 'REPEATABLE_READ',
        logging: false,
      };
      query = new Query(connectionStub, sequelize, options);
    });

    describe('getSQLTypeFromJsType', () => {
      const TYPES = tedious.TYPES;
      it('should return correct parameter type', () => {
        expect(query.getSQLTypeFromJsType(2_147_483_647, TYPES)).to.eql({
          type: TYPES.Int,
          typeOptions: {},
          value: 2_147_483_647,
        });
        expect(query.getSQLTypeFromJsType(-2_147_483_648, TYPES)).to.eql({
          type: TYPES.Int,
          typeOptions: {},
          value: -2_147_483_648,
        });

        expect(query.getSQLTypeFromJsType(2_147_483_648, TYPES)).to.eql({
          type: TYPES.BigInt,
          typeOptions: {},
          value: 2_147_483_648,
        });
        expect(query.getSQLTypeFromJsType(-2_147_483_649, TYPES)).to.eql({
          type: TYPES.BigInt,
          typeOptions: {},
          value: -2_147_483_649,
        });

        expect(query.getSQLTypeFromJsType(2_147_483_647n, TYPES)).to.eql({
          type: TYPES.Int,
          typeOptions: {},
          value: 2_147_483_647,
        });
        expect(query.getSQLTypeFromJsType(-2_147_483_648n, TYPES)).to.eql({
          type: TYPES.Int,
          typeOptions: {},
          value: -2_147_483_648,
        });

        expect(query.getSQLTypeFromJsType(BigInt(Number.MAX_SAFE_INTEGER), TYPES)).to.eql({
          type: TYPES.BigInt,
          typeOptions: {},
          value: Number.MAX_SAFE_INTEGER,
        });
        expect(query.getSQLTypeFromJsType(BigInt(Number.MIN_SAFE_INTEGER), TYPES)).to.eql({
          type: TYPES.BigInt,
          typeOptions: {},
          value: Number.MIN_SAFE_INTEGER,
        });

        const overMaxSafe = BigInt(Number.MAX_SAFE_INTEGER) + 1n;
        expect(query.getSQLTypeFromJsType(overMaxSafe, TYPES)).to.eql({
          type: TYPES.VarChar,
          typeOptions: {},
          value: overMaxSafe.toString(),
        });
        const underMinSafe = BigInt(Number.MIN_SAFE_INTEGER) - 1n;
        expect(query.getSQLTypeFromJsType(underMinSafe, TYPES)).to.eql({
          type: TYPES.VarChar,
          typeOptions: {},
          value: underMinSafe.toString(),
        });

        const buffer = Buffer.from('abc');
        expect(query.getSQLTypeFromJsType(buffer, TYPES)).to.eql({
          type: TYPES.VarBinary,
          typeOptions: {},
          value: buffer,
        });
      });

      it('should return parameter type correct scale for float', () => {
        expect(query.getSQLTypeFromJsType(1.23, TYPES)).to.eql({
          type: TYPES.Numeric,
          typeOptions: { precision: 30, scale: 2 },
          value: 1.23,
        });
        expect(query.getSQLTypeFromJsType(0.300_000_000_000_000_04, TYPES)).to.eql({
          type: TYPES.Numeric,
          typeOptions: { precision: 30, scale: 17 },
          value: 0.300_000_000_000_000_04,
        });
        expect(query.getSQLTypeFromJsType(2.5e-15, TYPES)).to.eql({
          type: TYPES.Numeric,
          typeOptions: { precision: 30, scale: 16 },
          value: 2.5e-15,
        });
      });
    });
  });
}