Difference between revisions of "Mongo examples"
Line 5: | Line 5: | ||
use stuffDb | use stuffDb | ||
show collections | show collections | ||
db.users.insert({email:"mckenna.tim@gmail.com}) | |||
db.lists.find({lid: "Jutebi"}, {items:1}).pretty() | db.lists.find({lid: "Jutebi"}, {items:1}).pretty() |
Revision as of 11:46, 15 March 2017
mongo examples
==== works
show dbs use stuffDb show collections db.users.insert({email:"mckenna.tim@gmail.com})
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: []}