mathiash98
/ Bulk edit documents in mongoDB collection
Last active
September 4, 2017 19:09
Bulk MongoDB edit key on all documents of collection, here: lowercase string except first letter
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var bulk = db.postnummer.initializeOrderedBulkOp(); | |
| var counter = 0; | |
| db.postnummer.find().forEach(function(data) { | |
| var updoc = { | |
| "$set": {} | |
| }; | |
| var myKey = "kommune"; | |
| updoc["$set"][myKey] = data.kommune[0] + data.kommune.toLowerCase().substring(1); | |
| // queue the update | |
| bulk.find({ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| .square { | |
| width: 100%; | |
| } | |
| .square:after { | |
| content: ""; | |
| display: block; | |
| padding-bottom: 100%; | |
| } | |
| /*=========== apply to parent element source: https://spin.atomicobject.com/2015/07/14/css-responsive-square/ ============*/ |
mathiash98
/ gist:ec2baf41616367b092054a57587f5927
Created
March 8, 2017 14:26
Mongoimport norwegian zip code postnummer mongodb columnsHaveTypes
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mongoimport --db naturAll --collection postnummer --fields _id.string(),poststed.string(),kommunekode.string(),kommune.string(),kategori.string() --columnsHaveTypes --type tsv --file C:\Users\mathi\Downloads\Postnummerregister_ansi.txt --drop |