Difference between revisions of "Mongo examples"
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
===mongo examples=== | ===mongo examples=== | ||
==== works | ==== works ==== | ||
show dbs | show dbs | ||
use stuffDb | use stuffDb | ||
show collections | show collections | ||
db.users.insert({email:"mckenna.tim@gmail.com}) | db.users.insert({email:"mckenna.tim@gmail.com"}) | ||
WriteResult({ "nInserted" : 1 }) | |||
db.users.find().pretty() | |||
db.users.update({email:"mckenna.tim@gmail.com"},{email:"mckenna.tim@gmail.com", timestamp: Date.now()}) | |||
db.lists.find({lid: "Jutebi"}, {items:1}).pretty() | db.lists.find({lid: "Jutebi"}, {items:1}).pretty() |
Latest revision as of 10:30, 16 March 2017
mongo examples
works
show dbs use stuffDb show collections db.users.insert({email:"mckenna.tim@gmail.com"}) WriteResult({ "nInserted" : 1 }) db.users.find().pretty() db.users.update({email:"mckenna.tim@gmail.com"},{email:"mckenna.tim@gmail.com", timestamp: Date.now()})
db.lists.find({lid: "Jutebi"}, {items:1}).pretty()
var u = db.lists.find({lid: "Jutebi"}, {items:1}) u.pretty() while (u.hasNext()) {print(tojson(u.next()));} u.forEach(function(x){print(tojson(x))}) // u.forEach(function(x){print(x.product)}) u.forEach(function(x){print(x)})
db.lists.find({lid: "Jutebi"}, {"items.product":1}).pretty() //just the products
var w = db.lists.find({lid: "Jutebi"}, {"items.product":1}) w.pretty() w.forEach(function(x){print(tojson(x))}) w.toArray()
var t = db.lists.find({lid: "Jutebi"}, {"items.product":1}).toArray()
==== doesnt db.lists.find({lid: "Jutebi"}, {"items.product":1}).forEach(function(x){print(x.product);})
var u = db.lists.find({lid: "Jutebi"}, {items:1})
while(u.hasNext()){print(u.Next().product);} while (u.hasNext()) {print(tojson(u.next()));}
db.devices.find({devid:"CYURD001"})
db.devices.update({devid:"CYURD001"}, {$set:{loc:{ lat: 14.34500000, lng: -72.44400000, timezone: "America/New_York", address: "12 Parley Vale, Jamaica Plain, MA 02130" }}})
var nt = { lat: 14.34500000, lng: -72.44400000, timezone: "America/New_York", address: "12 Parley Vale, Jamaica Plain, MA 02130" }
var nt = { devid: 'YRUDBD0001', domain: 'parley', userarr: [], loc: { lat: 2334555.3344, lng: 12345.2344, timezone: -5, address: '12 Parley Vale, Jamaica Plain, MA 02130' }, users: [], usersarr: []}