CSVDownloadsController.java

package edu.ucsb.cs156.frontiers.controllers;

import com.opencsv.bean.StatefulBeanToCsv;

import com.opencsv.exceptions.CsvDataTypeMismatchException;

import com.opencsv.exceptions.CsvRequiredFieldEmptyException;

import edu.ucsb.cs156.frontiers.entities.Course;

import edu.ucsb.cs156.frontiers.errors.EntityNotFoundException;

import edu.ucsb.cs156.frontiers.models.RosterStudentDTO;

import edu.ucsb.cs156.frontiers.repositories.CourseRepository;

import edu.ucsb.cs156.frontiers.services.RosterStudentDTOService;

import io.swagger.v3.oas.annotations.Operation;

import io.swagger.v3.oas.annotations.Parameter;

import io.swagger.v3.oas.annotations.media.Content;

import io.swagger.v3.oas.annotations.media.Schema;

import io.swagger.v3.oas.annotations.responses.ApiResponse;

import io.swagger.v3.oas.annotations.tags.Tag;

import java.io.IOException;

import java.io.OutputStreamWriter;

import java.io.Writer;

import java.nio.charset.StandardCharsets;

import java.util.List;

import lombok.extern.slf4j.Slf4j;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.http.HttpHeaders;

import org.springframework.http.MediaType;

import org.springframework.http.ResponseEntity;

import org.springframework.security.access.prepost.PreAuthorize;

import org.springframework.web.bind.annotation.GetMapping;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestParam;

import org.springframework.web.bind.annotation.RestController;

import org.springframework.web.servlet.mvc.method.annotation.StreamingResponseBody;

@Tag(name = "CSV Downloads")

@RequestMapping("/api/csv")

@RestController

  @Autowired private CourseRepository courseRepository;

  @Autowired private RosterStudentDTOService rosterStudentDTOService;

  @Operation(

      summary = "Download CSV File of Roster Students",

      description = "Returns a CSV file as a response",

      responses = {

        @ApiResponse(

            responseCode = "200",

            description = "CSV file",

            content =

                @Content(

                    mediaType = "text/csv",

                    schema = @Schema(type = "string", format = "binary"))),

        @ApiResponse(responseCode = "500", description = "Internal Server Error")

      })

  @GetMapping(value = "/rosterstudents", produces = "text/csv")

  @PreAuthorize("@CourseSecurity.hasManagePermissions(#root, #courseId)")

  public ResponseEntity<StreamingResponseBody> csvForQuarter(

      @Parameter(name = "courseId", description = "course id", example = "1") @RequestParam

          Long courseId)

      throws EntityNotFoundException, Exception, IOException {

        courseRepository

        (outputStream) -> {

            try {

            HttpHeaders.CONTENT_DISPOSITION,

  }

}

Mutations