语言:javaScript
平台:node.js
本人考虑如何将table.csv文件中的数据批量导入 mongodb 数据库中
代码文件名为test.js。 csv文件table.csv放在同一目录下
table.csv中的原始数据为
Date,Open,High,Low,Close,Volume,Adj
2007/11/5,48.6,48.62,41.7,43.96,1547499500,35.52
2007/11/6,41.4,42.4,39.8,39.99,342977800,32.31
使用了mongodb、line-reader两个模块
npm install mongodb
npm install line-reader
记得打开数据库
运行node test.js 代码如下
var mongodb = require('mongodb');
var lineReader = require('line-reader');
var server = new mongodb.Server('localhost', 27017, {auto_reconnect:true});
//连接的数据库为stock
var db = new mongodb.Db('stock', server, {safe:true});
db.open(function(err, db){
if(!err){
console.log('connect successful');
db.createCollection('stocks', {safe:true}, function(er