MongoDB 3系を CentOS7 にインストール
cd /usr/bin
mongoimport -d test -c zips --type csv --fields zipcode,perfecture,city,town,pref_rome,city_rome,town_rome 272OSAKA.CSV
mongoimport -d test2 -c zips --type csv --fields zipcode,perfecture,city,town,pref_rome,city_rome,town_rome /root/ダウンロード/KEN_ALL.CSV
mongoimport -d test -c zips --type csv --fields zipcode,perfecture,city,town,pref_rome,city_rome,town_rome 272OSAKA.CSV
mongoimport -d test2 -c zips --type csv --fields zipcode,perfecture,city,town,pref_rome,city_rome,town_rome /root/ダウンロード/KEN_ALL.CSV
mongoimport -d test3 -c zips --type csv --fields zipcode,perfecture,city,town,pref_rome,city_rome,town_rome /root/ダウンロード/KEN_ALL_UTF8.CSV
mongo
db.zips.findOne({zipcode:1600004})
mongo
db.zips.findOne({zipcode:1600004})
cd /usr/bin
mongoimport -d test3 -c zips --type csv --fields zipcode,perfecture,city,town,pref_rome,city_rome,town_rome KEN_ALL8.CSV
mongo
use test3
db.zips.findOne({zipcode:1101})
db.zips.find().limit(10)
db.zips.find().forEach(function(doc){ var zipcode=doc.zipcode; doc.zipcode=("0000000"+zipcode.tostring()).substr(-7); db.zips.save(doc) }
db.zips.find().forEach(function(doc) { var zipcode = doc.zipcode; doc.zipcode=( "0000000" + zipcode.tostring()).substr(-7); db.zips.save(doc) })
err----------
2018-07-30T15:59:50.853+0900 E QUERY [thread1] TypeError: zipcode.tostring is not a function :
@(shell):1:93
DBQuery.prototype.forEach@src/mongo/shell/query.js:501:1
@(shell):1:1
>
@(shell):1:93
DBQuery.prototype.forEach@src/mongo/shell/query.js:501:1
@(shell):1:1
>
OK--(toString)
db.zips.find().forEach(function(doc) { var zipcode = doc.zipcode; doc.zipcode=( "0000000" + zipcode.toString()).substr(-7); db.zips.save(doc) })
db.zips.findOne({zipcode:"5520015"})
show.dbs
show collections
db.dropdatabase
db.dropdatabase