duanqian3953 2018-02-12 09:27
浏览 80
已采纳

从Go-kit Golang中的API请求解析CSV文件

I am trying to build a service that takes user input of file from POST request and then iterates the CSV and passes it into my database. I am having problem to pass the file and read it. Below are my codes.

Endpoint.go

  type CSVRequest struct {
    File  io.Reader

}


func MakeCSVEndpoint(svc Service) endpoint.Endpoint {
    return func(ctx context.Context, request interface{}) (interface{}, error) {
        req := request.(CSVRequest)

        data, err := svc.ReadCSV(req.File)

        if err != nil {
            return GetErrorResponse{err}, nil
        }

        return CreateProductResponse{data}, nil
    }
}

transport.go

    func decodeCreateProductsCSV(_ context.Context, r *http.Request) (interface{}, error) {
    file, _, err := r.FormFile("file")

    return CSVRequest{File: file}, nil
}

so how can I pass the csv file to the service.go and then read and iterate the csv file and get the values of the csv file.

  • 写回答

1条回答 默认 最新

  • dongxiao_0528 2018-02-12 10:04
    关注

    Here is a basic function that can do the parsing from a POST request. The result is a two-dimensional array of strings, the first dimension being the rows and the second dimension being the values in a row. It uses the golang's own "encoding/csv" package. Go playground example available here.

    func ReadCSVFromHttpRequest(req *http.Request) ([][]string, error) {
        // parse POST body as csv
        reader := csv.NewReader(req.Body)
        var results [][]string
        for {
            // read one row from csv
            record, err := reader.Read()
            if err == io.EOF {
                break
            }
            if err != nil {
                return nil, err
            }
    
            // add record to result set
            results = append(results, record)
        }
        return results, nil
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 DB-GPT-HUB Text-to-SQL微调
  • ¥20 求解答(matlab)
  • ¥30 ffmpeg库使用过程中遇到的问题
  • ¥15 pyqt5 中python如何通过Qtwebchannel主动发消息给web前端
  • ¥15 关于HTML中title获取xml内容的问题
  • ¥15 fanuc机器人PRIO083数字信号未复原错误,如何解决?
  • ¥20 如何为现有电路板增加远程控制功能
  • ¥15 C#点击按钮的时候的循环次数就是最后一次,如何是循环第几次的值?
  • ¥15 UE5打包失败,求解决
  • ¥15 请问STM32G431的CANOPEN协议函数怎么写