需要导一个地理数据库进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();
}
});
});
})