Difference between revisions of "Mongo examples"
Line 1: | Line 1: | ||
===mongo examples=== | ===mongo examples=== | ||
==== works | |||
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.find({devid:"CYURD001"}) |
Revision as of 21:18, 7 March 2017
mongo examples
==== works 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: []}