MongoDB

MongoDB 3系を CentOS7 にインストール

https://qiita.com/SOJO/items/dc5bf9b4375eab14991b

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 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})

---

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
>

---

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