csv转mongodb

来源：互联网发布：php 正式表达式验证qq 编辑：程序博客网时间：2024/05/03 19:33

需要导一个地理数据库进mongodb，csv格式的，搞了一堆导入命令，眼都花了，于是干脆这样

var csv = require('csv');var fs = require('fs');var path = require('path');var mongoose = require("mongoose");var conn = mongoose.createConnection('localhost', 'autodb');var Schema = mongoose.Schema;var areaSchema = Schema({    id: String,    areaname: String,    parentid: String,    shortname: String,    lng: String,    lat: String,    level: Number,    position: String,    sort: Number});var Area = conn.model('area', areaSchema);var filepath = "d:/web/ludeb/areas.csv";fs.readFile(filepath, function(err, data) {    csv.parse(data, function(err, data) {        data.forEach(function(e, i, a) {            if (i != 0) {                var a = new Area({                    id: e[0],                    areaname: e[1],                    parentid: e[2],                    shortname: e[3],                    lng: e[4],                    lat: e[5],                    level: e[6],                    position: e[7],                    sort: e[8]                });                a.save();            }        });    });})

0 0