Difference between revisions of "Mongo examples"

From Wiki2
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
===mongo examples===
===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" }}})
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" }}})

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: []}