Function setupMSSQL

packages/client/src/utils/setupMSSQL.ts:27–38

(options: SetupParams)

  }
}
export async function setupMSSQL(options: SetupParams): Promise<void> {
  const { connectionString } = options
  const { dirname } = options
  const schema = fs.readFileSync(path.join(dirname, 'setup.sql'), 'utf-8')
  const config = getMSSQLConfig(connectionString)

  const connectionPool = new mssql.ConnectionPool(config)
  const connection = await connectionPool.connect()

  await connection.query(schema)
  await connection.close()
}