Postgresql 在Docker Compose中获取CSV文件数据

我有一个从PostgreSQL数据库获取CSV文件的CLI应用程序.尽管运行代码会创建CSV文件并将数据放入CSV，但通过docker compose运行应用程序并不会这样做.

我把音量放到了app服务中，但它不起作用.

Docker compose file个

version: "3.8"
services:
  app:
    build:
      context: .
      dockerfile: Dockerfile
    command: sh -c "while true; do echo 'App is running'; sleep 10; done"
    environment:
      POSTGRES_HOST: postgres
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: password
      POSTGRES_DB: flow
      POSTGRES_SSL: disable
    depends_on:
      - postgres
    volumes:
      - /path/to/store/CSV/file:/app/data

  postgres:
    image: postgres:latest
    restart: always
    ports:
      - "5432:5432"
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: password
      POSTGRES_DB: flow
    volumes:
      - postgres_data:/var/lib/postgresql/data

volumes:
  postgres_data:
    driver: local

Dockerfile个

FROM golang:1.22.0-alpine3.19

RUN mkdir -p /app

WORKDIR /app

COPY go.mod /app
COPY go.sum /app

COPY . /app

RUN go mod download

RUN go build -o flow .

CMD ["./flow"]

Data getting function个

func GetBudgetData(filepath, filename string) error {
    bv := new(BudgetVariables)
    db, err := budget_db.Connection()
    if err != nil {
        return err
    }

    query := "SELECT categories, amounts FROM Budget"
    rows, err := db.Query(query)
    if err != nil {
        return err
    }
    defer rows.Close()

    file, err := os.Create(filepath + "/" + filename)
    if err != nil {
        return err
    }
    defer file.Close()

    writer := csv.NewWriter(file)
    defer writer.Flush()

    header := []string{"Category", "Amount"}
    if err := writer.Write(header); err != nil {
        return err
    }
    for rows.Next() {
        if err := rows.Scan(&bv.Category, &bv.Amount); err != nil {
            return err
        }

        data := []string{bv.Category, bv.Amount}
        if err := writer.Write(data); err != nil {
            return err
        }

        if err := rows.Err(); err != nil {
            return err
        }
    }
    fmt.Printf("Successfully created a '%s' file in '%s'\n", filename, filepath)
    return nil
}