sqlserver.test.js

const { basicDatabaseTest } = require('../desktop/panel/testutil');
const { withDocker } = require('./docker');

const BASIC_TESTS = [
  {
    type: 'sqlserver',
    // SQL Server doesn't have true/false literals
    query: `SELECT 1 AS "1", 2.2 AS "2", 1 AS "true", 'string' AS "string", CAST('2021-01-01' AS DATE) AS "date"`,
  },
  /*
     NOTES ON RUNNING ODBC TESTS LOCALLY:
     * Install the odbc driver for SQL Server here: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16
     * Run: ./runner/plugin/odbc/build.sh -race
     * Build the test runner: yarn build-test-runner
     * Run: yarn test-local integration/sqlserver.test.js -t odbc
     
     Easy peasy.
   */
  {
    type: 'odbc',
    // SQL Server doesn't have true/false literals
    query: `SELECT 1 AS "1", 2.2 AS "2", 1 AS "true", 'string' AS "string", CAST('2021-01-01' AS DATE) AS "date"`,
  },
  {
    type: 'odbc',
    query: `INSERT INTO test (id, name) VALUES (1, 'name')`,
  },
];

const vendorOverride = {
  sqlserver: {
    address: 'localhost',
    username: 'sa',
    password: '1StrongPwd!!',
    database: 'master',
  },
  odbc: {
    address: 'localhost',
    username: 'sa',
    password: '1StrongPwd!!',
    database: 'master',
    extra: {
      driver: 'ODBC Driver 18 for SQL Server',
      params: 'TrustServerCertificate=yes;',
    },
  },
};

describe('basic sqlserver tests', () => {
  for (const t of BASIC_TESTS) {
    test(
      t.type + ':' + t.query,
      async () => {
        await withDocker(
          {
            image: 'mcr.microsoft.com/mssql/server:2019-latest',
            port: '1433',
            env: {
              ACCEPT_EULA: 'Y',
              MSSQL_SA_PASSWORD: '1StrongPwd!!',
            },
            cmds: [
              `/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "1StrongPwd!!" -Q "CREATE TABLE master.[dbo].test (id int PRIMARY KEY, name text);"`,
            ],
          },
          () => basicDatabaseTest(t, vendorOverride)
        );
      },
      360_000
    );
  }
});