将Mongoose文档写入csv文件

npm install mongoose csv-parser

const mongoose = require('mongoose');
const fs = require('fs');
const csv = require('csv-parser');

mongoose.connect('mongodb://localhost/mydatabase', { useNewUrlParser: true, useUnifiedTopology: true });

const Schema = mongoose.Schema;
const mySchema = new Schema({
  // 定义文档的字段
  field1: String,
  field2: Number,
  // ...
});

const MyModel = mongoose.model('MyModel', mySchema);

MyModel.find({}, (err, docs) => {
  if (err) {
    console.error(err);
    return;
  }

  // 将查询结果写入CSV文件
  const csvStream = fs.createWriteStream('output.csv');
  csvStream.write('field1,field2\n'); // 写入CSV文件的标题行

  docs.forEach((doc) => {
    csvStream.write(`${doc.field1},${doc.field2}\n`); // 写入每个文档的数据行
  });

  csvStream.end();
  console.log('CSV file has been created successfully.');
});