Function getMSSQLConnection

src/lib/connectors/mssql/index.ts:7–27

(connection: Connection)

const systemDatabases = ["master", "tempdb", "model", "msdb"];

const getMSSQLConnection = async (connection: Connection): Promise<ConnectionPool> => {
  const connectionOptions: any = {
    server: connection.host,
    port: parseInt(connection.port),
    user: connection.username,
    password: connection.password,
    database: connection.database,
    options: {
      encrypt: connection.encrypt === true,
    },
  };
  if (connection.ssl) {
    connectionOptions.ssl = {
      ca: connection.ssl?.ca,
      cert: connection.ssl?.cert,
      key: connection.ssl?.key,
    };
  }
  const pool = await new ConnectionPool(connectionOptions).connect();
  return pool;
};

const testConnection = async (connection: Connection): Promise<boolean> => {
  const pool = await getMSSQLConnection(connection);