关闭

关于csv数据如何导入mongo的historicialQuotes的命令导入方式

384人阅读 评论(0) 收藏 举报
分类:

这边提供了两种方式导入这批数据:

第一种,导入批量csv数据到Mongo的historicalQuotes数据表里

1.先删除historicialQuotes的原始数据,可以通过下面的MongoVUE界面里的remove all来实现。


2. 准备好csv文件格式:



3.执行mongoimport文件到mongo数据:


mongoimport -d fcmarketdata -c HistoricalQuotes -type csv -fields TradeDate,OpenPrice,HighPrice,LowPrice,ClosePrice,MatchQuantity,StockCode -file d:\mongodb\data\510050.csv -headerline


这个命令式mongodb\bin里的外部命令

4.进入mongo数据库,切换到fcmarketdata数据库执行下面的改变tradedate和stockcode字段的类型命令


db.HistoricalQuotes.find({'StockCode':510050}).forEach(function(x){
     x.StockCode=x.StockCode+"";
     db.HistoricalQuotes.save(x);
});
db.HistoricalQuotes.find({'StockCode':"510050"}).forEach(function(x){
     x.TradeDate=new Date(x.TradeDate);
     db.HistoricalQuotes.save(x);
});


第二种是直接删除后进行单条插入,这个也是客户要求:


删除时间段里的数据

 db.HistoricalQuotes.remove({"TradeDate":{"$gt":  ISODate("2015-07-08T08:13:49.98Z")}})

插入数据
 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-06-23T16:00:00Z"),   "OpenPrice" : 2.89,   "HighPrice" : 2.99,   "LowPrice" : 2.8,   "ClosePrice" : 2.98,   "MatchQuantity" : NumberLong(2573711425),   "StockCode" : "510050"})





 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-06-24T16:00:00Z"),   "OpenPrice" : 2.99,   "HighPrice" : 3.03,   "LowPrice" : 2.92,   "ClosePrice" : 3.02,   "MatchQuantity" : NumberLong(2269673751),   "StockCode" : "510050"})






 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-06-25T16:00:00Z"),   "OpenPrice" : 3.05,   "HighPrice" : 3.06,   "LowPrice" : 2.91,   "ClosePrice" :2.92,   "MatchQuantity" : NumberLong(2239861306),   "StockCode" : "510050"})




 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-06-26T16:00:00Z"),   "OpenPrice" : 2.86,   "HighPrice" : 2.93,   "LowPrice" : 2.63,   "ClosePrice" : 2.69,   "MatchQuantity" : NumberLong(4091997209),   "StockCode" : "510050"})





 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-06-29T16:00:00Z"),   "OpenPrice" : 2.77,   "HighPrice" : 2.8,   "LowPrice" : 2.48,   "ClosePrice" : 2.66,   "MatchQuantity" : NumberLong(7737937085),   "StockCode" : "510050"})





 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-06-30T16:00:00Z"),   "OpenPrice" : 2.66,   "HighPrice" : 2.86,   "LowPrice" : 2.6,   "ClosePrice" : 2.85,   "MatchQuantity" : NumberLong(6802366362),   "StockCode" : "510050"})





 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-07-01T16:00:00Z"),   "OpenPrice" : 2.81,   "HighPrice" : 2.85,   "LowPrice" : 2.69,   "ClosePrice" : 2.73,   "MatchQuantity" : NumberLong(4433403139),   "StockCode" : "510050"})




 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-07-02T16:00:00Z"),   "OpenPrice" : 2.79,   "HighPrice" : 2.79,   "LowPrice" : 2.58,   "ClosePrice" : 2.68,   "MatchQuantity" : NumberLong(5865295181),   "StockCode" : "510050"})




 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-07-03T16:00:00Z"),   "OpenPrice" : 2.66,   "HighPrice" : 2.73,   "LowPrice" : 2.5,   "ClosePrice" : 2.58,   "MatchQuantity" : NumberLong(4464872090),   "StockCode" : "510050"})





 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-07-06T16:00:00Z"),   "OpenPrice" : 2.84,   "HighPrice" : 2.84,   "LowPrice" : 2.63,   "ClosePrice" : 2.74,   "MatchQuantity" : NumberLong(9146831430),   "StockCode" : "510050"})




 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-07-07T16:00:00Z"),   "OpenPrice" : 2.68,   "HighPrice" : 2.82,   "LowPrice" : 2.61,   "ClosePrice" : 2.79,   "MatchQuantity" : NumberLong(6650103182),   "StockCode" : "510050"})


 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-07-08T16:00:00Z"),   "OpenPrice" : 2.6,   "HighPrice" : 2.76,   "LowPrice" : 2.51,   "ClosePrice" : 2.6,   "MatchQuantity" : NumberLong(7054986215),   "StockCode" : "510050"})



 db.HistoricalQuotes.insert({"TradeDate" : ISODate("2015-07-09T16:00:00Z"),   "OpenPrice" : 2.53,   "HighPrice" : 2.86,   "LowPrice" : 2.48,   "ClosePrice" : 2.79,   "MatchQuantity" : NumberLong(3893441316),   "StockCode" : "510050"})



0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:681878次
    • 积分:11788
    • 等级:
    • 排名:第1364名
    • 原创:352篇
    • 转载:438篇
    • 译文:2篇
    • 评论:52条
    最新评论