Difference between revisions of "Mongo examples"
(Created page with "===mongo examples=== db.devices.update({devid:"CYURD001"}, {$set:{loc:{ lat: 14.34500000, lng: -72.44400000, timezone: "America/New_York", address: "12 Parley Vale, Jamaica P...") |
|||
(6 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
===mongo examples=== | ===mongo examples=== | ||
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" }}) | ==== 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 = { | var nt = { |
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: []}