node.js 生成CSV文件并下载

const Json2csvParser = require('json2csv').Parser;
const fields = ['batch', 'time', 'symbol', 'totalAddress', 'totalSupply', 'toAddress', 'value'
];
let data = `select * from airDrop where batch=?`
    let myData = {}
    db.query(data, [1], (err, result) => {
        if (err) throw err;
        myData = result
        let csv = ''
        //写CSV标题
        const json2csvParser = new Json2csvParser({ fields });
        //将数据转为CSV
        csv = json2csvParser.parse(myData);
        console.log(csv)
        res.header('Content-Type', 'text/csv');
        //CSV命名
        res.attachment('airDrop.csv');
        res.send(csv);
    });

注：需要安装json2csv