bliotti · November 18, 2019 05:35 · Nov 28, 2013 · Nov 28, 2013 · Nov 28, 2013 · Nov 28, 2013
diff --git a/mongodb.md b/mongodb.md
@@ -596,7 +596,7 @@ db.dropDatabase();
 ```
 To delete specific fields within a document you have to use an update using the $unset operator.  
 ###Indexes
----INDEX WHATEVER FIELDS YOU QUERY MOST OFTEN BY.
+INDEX WHATEVER FIELDS YOU QUERY MOST OFTEN BY.
 ####EXPLAIN Mehtod
 
 Get query specifications like objects found, kind of cursor, number of scanned objects, milliseconds it took to do the query.

diff --git a/mongodb.md b/mongodb.md
@@ -596,7 +596,9 @@ db.dropDatabase();
 ```
 To delete specific fields within a document you have to use an update using the $unset operator.  
 ###Indexes
+---INDEX WHATEVER FIELDS YOU QUERY MOST OFTEN BY.
 ####EXPLAIN Mehtod
+
 Get query specifications like objects found, kind of cursor, number of scanned objects, milliseconds it took to do the query.
 ```
 db.links.find({title:'Nettuts+'}).explain();
@@ -626,4 +628,15 @@ When documents don't have the selected field they would still get an index. To a
 db.links.ensureIndex({ title: 1},{ sparse:true });
 ```
 ####Compound Indexes
-
+```
+db.links.ensureIndex({ title:1, url: 1 });
+```
+MongoDB can just use a single index per query
+###Get rid of indexes
+```
+db.links.dropIndex({title_1_url_1});
+```
+###Show indexes
+```
+db.system.indexes.find();
+```
diff --git a/mongodb.md b/mongodb.md
@@ -602,12 +602,28 @@ Get query specifications like objects found, kind of cursor, number of scanned o
 db.links.find({title:'Nettuts+'}).explain();
 ```
 ####ENSURE INDEX Method
-To create our own indexes:
+To create your own indexes:
 ```
 db.links.ensureIndex({ title: 1});
 ```
 1 means to index in ascending order.
 To see if the index was created:
 ```
 db.system.indexes.find();
-```
+```
+To set unique indexes for every document:
+```
+db.links.ensureIndex({ title: 1},{ unique:true });
+```
+If there were multiple documents with the same value
+```
+db.links.ensureIndex({ title: 1},{ unique:true, dropDups:true});
+```
+It would only keep the first one and get rid to any subsequent documents with the same field value.  
+
+When documents don't have the selected field they would still get an index. To avoid this use "sparse":
+```
+db.links.ensureIndex({ title: 1},{ sparse:true });
+```
+####Compound Indexes
+
diff --git a/mongodb.md b/mongodb.md
@@ -597,7 +597,17 @@ db.dropDatabase();
 To delete specific fields within a document you have to use an update using the $unset operator.  
 ###Indexes
 ####EXPLAIN Mehtod
-Get query specifications like objects found, kind of cursor, number of scanned objects...
+Get query specifications like objects found, kind of cursor, number of scanned objects, milliseconds it took to do the query.
 ```
 db.links.find({title:'Nettuts+'}).explain();
+```
+####ENSURE INDEX Method
+To create our own indexes:
+```
+db.links.ensureIndex({ title: 1});
+```
+1 means to index in ascending order.
+To see if the index was created:
+```
+db.system.indexes.find();
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -594,4 +594,10 @@ db.collection.drop();
 ```
 db.dropDatabase();
 ```
-To delete specific fields within a document you have to use an update using the $unset operator.
+To delete specific fields within a document you have to use an update using the $unset operator.  
+###Indexes
+####EXPLAIN Mehtod
+Get query specifications like objects found, kind of cursor, number of scanned objects...
+```
+db.links.find({title:'Nettuts+'}).explain();
+```
diff --git a/mongodb.md b/mongodb.md
@@ -585,4 +585,13 @@ db.users.findAndModify({
   query:{'name.first':/B/},
   remove:true
 });
-```
+```
+####DELETE A COLLECTION
+```
+db.collection.drop();
+```
+####DELETE A WHOLE DATABASE
+```
+db.dropDatabase();
+```
+To delete specific fields within a document you have to use an update using the $unset operator.
diff --git a/mongodb.md b/mongodb.md
@@ -573,4 +573,16 @@ db.users.update(
   {$rename: {$rename: {'random':'new_attribute_name'} }},
   false,true
 );
+```
+###Removing Documents
+####REMOVE Operator
+```
+db.users.remove({'name.first':'John'});
+```
+####FIND AND MODIFY Operator
+```
+db.users.findAndModify({
+  query:{'name.first':/B/},
+  remove:true
+});
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -566,6 +566,7 @@ db.users.update(
 );
 ```
 #####RENAME Operator
+Renames fields
 ```
 db.users.update(
   {random:true},

diff --git a/mongodb.md b/mongodb.md
@@ -564,4 +564,12 @@ db.users.update(
   {$set: {'logins.$.location':'unknown'} },
   false, true
 );
+```
+#####RENAME Operator
+```
+db.users.update(
+  {random:true},
+  {$rename: {$rename: {'random':'new_attribute_name'} }},
+  false,true
+);
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -558,4 +558,10 @@ db.users.update(
   {$inc: {'logins.$.minutes':10} },
   false, true
 );
+
+db.users.update(
+  {'logins.minutes':30},
+  {$set: {'logins.$.location':'unknown'} },
+  false, true
+);
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -553,4 +553,9 @@ db.links.update(n,{ $pop:{ tags: -1 } }); /*Pop off the begining*/
 ```
 #####POSITIONAL Operator
 ```
+db.users.update(
+  {'logins.minutes':20},
+  {$inc: {'logins.$.minutes':10} },
+  false, true
+);
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -550,4 +550,7 @@ var n = {title: 'Nettuts+'};
 db.links.update(n,{ $pop:{ tags: 1 } }); /*Pop off the end*/
 
 db.links.update(n,{ $pop:{ tags: -1 } }); /*Pop off the begining*/
+```
+#####POSITIONAL Operator
+```
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -499,6 +499,7 @@ db.users.findAndModify({
 });
 ```
 ####Modification Operators
+####Array Operators
 #####PUSH Operator
 Push new items into an array
 ```
@@ -540,4 +541,13 @@ Remove multiple values inside an array.
 var n = {title: 'Nettuts+'};
 
 db.links.update(n,{ $pullAll:{ tags: ['two',three'] } });
+```
+#####POP Operator
+Remove the first or last elements of an array
+```
+var n = {title: 'Nettuts+'};
+
+db.links.update(n,{ $pop:{ tags: 1 } }); /*Pop off the end*/
+
+db.links.update(n,{ $pop:{ tags: -1 } }); /*Pop off the begining*/
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -526,4 +526,18 @@ To uniquely add multiple values at once to an array
 var n = {title: 'Nettuts+'};
 
 db.links.update(n,{ $addToSet:{ tags:{ $each: ['one','two'] } } });
+```
+#####PULL Operator
+Remove elements inside an array.
+```
+var n = {title: 'Nettuts+'};
+
+db.links.update(n,{ $pull:{ tags:'four' } });
+```
+#####PULL ALL Operator  
+Remove multiple values inside an array.
+```
+var n = {title: 'Nettuts+'};
+
+db.links.update(n,{ $pullAll:{ tags: ['two',three'] } });
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -513,3 +513,17 @@ var n = {title: 'Nettuts+'};
 
 db.links.update(n,{ $pushAll:{ tags:['one','two'] } });
 ```
+#####ADD TO SET Operator
+If you want your arrays to have unique values.
+```
+var n = {title: 'Nettuts+'};
+
+db.links.update(n,{ $addToSet:{ tags:'code' } });
+```
+#####EACH Operator
+To uniquely add multiple values at once to an array
+```
+var n = {title: 'Nettuts+'};
+
+db.links.update(n,{ $addToSet:{ tags:{ $each: ['one','two'] } } });
+```
diff --git a/mongodb.md b/mongodb.md
@@ -498,3 +498,18 @@ db.users.findAndModify({
   fields: {title:1, favourites:1, _id:0}
 });
 ```
+####Modification Operators
+#####PUSH Operator
+Push new items into an array
+```
+var n = {title: 'Nettuts+'};
+
+db.links.update(n,{ $push:{ tags:'blog' } });
+```
+#####PUSH ALL Operator
+Push each item in an array to an array in the selected document.
+```
+var n = {title: 'Nettuts+'};
+
+db.links.update(n,{ $pushAll:{ tags:['one','two'] } });
+```
diff --git a/mongodb.md b/mongodb.md
@@ -488,4 +488,13 @@ db.users.findAndModify({
   update:{ $set: {age: 20} },
   new: true /*return the updated object, false is the default, and it returns the object before updates*/
 });
+
+
+db.users.findAndModify({
+  query:{ favourites: 110 },
+  update:{ $inc: { favourites: 10 } },
+  sort: { title: 1},
+  new: true,
+  fields: {title:1, favourites:1, _id:0}
+});
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -486,6 +486,6 @@ This method takes a single object as its parameter. This object has several prop
 db.users.findAndModify({
   query:{ name:'Kate Wills' },
   update:{ $set: {age: 20} },
-  new: true /*return the updated object, false is the default, and it    returns the object before updates*/
+  new: true /*return the updated object, false is the default, and it returns the object before updates*/
 });
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -480,3 +480,12 @@ var bob = db.users.findOne({'name.first':'Bob'});
 bob.job = 'Server Admin';
 db.users.save(bob);
 ```
+####Find & Modify Method  
+This method takes a single object as its parameter. This object has several properties.
+```
+db.users.findAndModify({
+  query:{ name:'Kate Wills' },
+  update:{ $set: {age: 20} },
+  new: true /*return the updated object, false is the default, and it    returns the object before updates*/
+});
+```
diff --git a/mongodb.md b/mongodb.md
@@ -473,5 +473,10 @@ This just works with updates by modification.
 /*First boolean value is used for UPSERTS, the second one for MULTIPARAMETER*/
 
 db.users.update({'name.first':'Jane'}),{$set: {job:'developer'}},false,true);
-
-```
+```
+####Save Method
+```
+var bob = db.users.findOne({'name.first':'Bob'});
+bob.job = 'Server Admin';
+db.users.save(bob);
+```
diff --git a/mongodb.md b/mongodb.md
@@ -467,8 +467,11 @@ db.users.update(q,{$set: {job: 'Wev Developer'}});
 
 db.users.update(q,{$unset: {job: 'Wev Developer'}});
 ```
-#####Update Multiple Records  
+#####MULTIPARAMETER Update Multiple Records  
 This just works with updates by modification.
 ```
-sadf
+/*First boolean value is used for UPSERTS, the second one for MULTIPARAMETER*/
+
+db.users.update({'name.first':'Jane'}),{$set: {job:'developer'}},false,true);
+
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -466,6 +466,9 @@ db.users.update(q,{$set: {job: 'Wev Developer'}});
 /*This also works with fields that doesn't exist yet, and to get rid of fields*/
 
 db.users.update(q,{$unset: {job: 'Wev Developer'}});
-
-
+```
+#####Update Multiple Records  
+This just works with updates by modification.
+```
+sadf
 ```
diff --git a/mongodb.md b/mongodb.md
@@ -251,7 +251,7 @@ bsondump dump/mydb/users.bson > users.json
 ```
 mongostat
 ```
-##MONGO SHELL COMMANDS (JAVASCRIPT)
+##MONGO COMMANDS (JAVASCRIPT)
 ```
 ###SHOW AVAILABLE DATABASES
 show dbs

diff --git a/mongodb.md b/mongodb.md
@@ -447,6 +447,25 @@ db.users.update({'name.first':'John'},{'job':'developer'});
 
 /*Use this if you want to create a document if it doesn't find the one you passed to update*/
 
-db.users.update({name: 'Kate Wills'},{name: 'Kate Wills',job:'LISP Developer}, true);
+db.users.update({name: 'Kate Wills'},{name: 'Kate Wills', job:'LISP Developer}, true);
 ```
 #####Update By Modification
+```
+/*INCREMENT*/
+
+var n = {title: 'Nettuts+'};
+db.links.find(n,{title:1, favourites:1});
+db.links.update(n,{$inc:{favourites: 5});
+db.links.update(n,{$inc:{favourites: -5});
+
+/*CHANGE VALUE*/
+
+var q = {name: "Kate Wills};
+db.users.update(q,{$set: {job: 'Wev Developer'}});
+
+/*This also works with fields that doesn't exist yet, and to get rid of fields*/
+
+db.users.update(q,{$unset: {job: 'Wev Developer'}});
+
+
+```
diff --git a/mongodb.md b/mongodb.md
@@ -442,5 +442,11 @@ Replace whatever record it finds that matches the first object.
 All other fields are removed and replaced with the second object values.
 ```
 db.users.update({'name.first':'John'},{'job':'developer'});
+
+/*UPSERT*/
+
+/*Use this if you want to create a document if it doesn't find the one you passed to update*/
+
+db.users.update({name: 'Kate Wills'},{name: 'Kate Wills',job:'LISP Developer}, true);
 ```
 #####Update By Modification
diff --git a/mongodb.md b/mongodb.md
@@ -441,6 +441,6 @@ db.links.find().skip(1*3).limit(3); /*GETS ELEMENTS 4,5 & 6*/
 Replace whatever record it finds that matches the first object.
 All other fields are removed and replaced with the second object values.
 ```
-db.users.update({'name.first':'John'},{job:'developer'});
+db.users.update({'name.first':'John'},{'job':'developer'});
 ```
 #####Update By Modification
diff --git a/mongodb.md b/mongodb.md
@@ -436,11 +436,11 @@ db.links.find().skip(0*3).limit(3); /*GETS ELEMENTS 1,2 & 3*/
 db.links.find().skip(1*3).limit(3); /*GETS ELEMENTS 4,5 & 6*/
 ```
 ###Updating Documents
-#####Update Method
-######Update By Replacement  
+####Update Method
+#####Update By Replacement  
 Replace whatever record it finds that matches the first object.
 All other fields are removed and replaced with the second object values.
 ```
 db.users.update({'name.first':'John'},{job:'developer'});
 ```
-######Update By Modification
+#####Update By Modification
diff --git a/mongodb.md b/mongodb.md
@@ -435,4 +435,12 @@ db.links.find({},title:1,favourites:1,_id:0).sort({favourites:1}).limit(1);
 db.links.find().skip(0*3).limit(3); /*GETS ELEMENTS 1,2 & 3*/
 db.links.find().skip(1*3).limit(3); /*GETS ELEMENTS 4,5 & 6*/
 ```
-###Updating Documents
+###Updating Documents
+#####Update Method
+######Update By Replacement  
+Replace whatever record it finds that matches the first object.
+All other fields are removed and replaced with the second object values.
+```
+db.users.update({'name.first':'John'},{job:'developer'});
+```
+######Update By Modification
diff --git a/mongodb.md b/mongodb.md
@@ -434,4 +434,5 @@ db.links.find({},title:1,favourites:1,_id:0).sort({favourites:1}).limit(1);
 ```
 db.links.find().skip(0*3).limit(3); /*GETS ELEMENTS 1,2 & 3*/
 db.links.find().skip(1*3).limit(3); /*GETS ELEMENTS 4,5 & 6*/
-```
+```
+###Updating Documents
diff --git a/mongodb.md b/mongodb.md
@@ -430,4 +430,8 @@ db.links.find({},{title:1,favourites: 1, _id:0}).sort({favourites:-1, title:1});
 ```
 db.links.find({},title:1,favourites:1,_id:0).sort({favourites:1}).limit(1);
 ```
-
+#####Skip
+```
+db.links.find().skip(0*3).limit(3); /*GETS ELEMENTS 1,2 & 3*/
+db.links.find().skip(1*3).limit(3); /*GETS ELEMENTS 4,5 & 6*/
+```
No results found