Fundamentos de MongoDB
驴Qu茅 es Mongo DB?
Bases de datos NoSQL
驴Qu茅 son los documentos y colecciones?
Creando tu primer BD
Usando Mongo Compass
Mongo en VSCode
Instalando Docker
Mongo con Docker
Conect谩ndonos usando mongosh
Json vs. Bson
CRUD
Insertando un documento
Insertando varios documentos
Actualizando un documento
Actualizando varios documentos
Array Update Operators
Update or insert
Elimando documentos
Operadores
Usando $eq y $ne
Usando $gt, $gte, $lt, $lte
Ejemplos de $gt, $gte, $lt, $lte
Usando $regex
Projection
Operadores para Arrays
Operadores l贸gicos
Expresive operator
Query in subdocs
Herramientas comunes al trabajar con MongoDB
Aggregation Framework
Sort, limit y skip
Atlas features
Toma el Curso de Modelamiento de Datos en MongoDB
You don't have access to this class
Keep learning! Join and start boosting your career
When working with databases, it is crucial to understand how to handle more complex data structures, such as arrays. MongoDB offers specific tools for updating and managing arrays in documents. In this content, we explore how to use these operators, specifically push and pull, to modify arrays efficiently.
To begin with, it is essential to have a suitable environment. In this exercise, we worked with a software called Platzi Store and used a predefined dataset. Here are the basic steps:
dataset.mongodb file.query.mongodb to make queries on the database without the need to constantly insert data.push?The push operator is a powerful tool that allows you to add new elements to the end of an array within a specific document. Here is how you can use it:
db.inventory.updateOne( { _id: 4 }, { $push: { tags: "headphone" } })In this example, the goal is to add "headphone" to the tags array of the document with _id: 4. This is useful to keep your database up to date without replacing existing data.
pull?Just as push allows you to add, the pull operator is ideal for removing elements. It can be used to remove either a single element or several elements from an array. Here is the syntax to remove a single element:
db.inventory.updateMany( {}, { $pull: { tags: "book" } })This operation removes "book" from all tags arrays in the database documents.
pull with in?To remove multiple elements from an array, you can use a combination of pull and in. Here both "school" and "appliance" are removed from the arrays:
db.inventory.updateMany( {}, { $pull: { tags: { $in: ["school", "appliance"] } } } } })This approach is particularly efficient for cleaning unwanted data from multiple documents at once.
push and pull operators should be applied with precision to avoid unnecessary alterations.With these tools and strategies, you will be able to manipulate arrays in your MongoDB databases more effectively and with confidence. Keep exploring and improving your skills!
Contributions 11
Questions 0
Por si necesitan insertar multiples valores adentro de un arreglo, lo pueden hacer de la siguiente manera:
use("platzi_store")
db.inventory.updateOne({_id: 4}, {
$push: {
tags:{
$each:["headphone","wireless"]
}
}
})
db.inventory.find()
Modificadores del operador push
$each
Agrega m煤ltiples valores al campo de la matriz.
$slice
Limita el n煤mero de elementos de la matriz. Requiere el uso del modificador $each.
$sort
Ordena los elementos de la matriz. Requiere el uso del modificador $each.
$position
Especifica la ubicaci贸n en la matriz en la que insertar los nuevos elementos. Requiere el uso del modificador $each. Sin el modificador $position, el $push agrega los elementos al final de la matriz
Mas sobre Array Update operators
Con los siguientes operadores podremos modificar los documentos que dentro contengan un array:
Valla, este profesor es muy pro, se le entiende muy bien, eso si prestar atencion con enfoque
Est谩 muy interesante el curso, al punto que me tiene trasnochando 馃槄
Array Update Operator
{ _id: 1, item: { name: "item ab", code: "123", description : "Single line description." }, qty: 15, tags: [ "school", "book", "bag", "headphone", "appliance" ], },
{ _id: 2, item: { name: "item cd", code: "123", description : "First line\nSecond line" }, qty: 20, tags: [ "appliance", "school", "book" ] },
{ _id: 3, item: { name: "item ij", code: "456", description : "Many spaces before line" }, qty: 25, tags: [ "school", "book" ] },
{ _id: 4, item: { name: "item xy", code: "456", description : "Multiple\nline description" }, qty: 30, tags: [ "electronics", "school" ] },
{ _id: 5, item: { name: "item mn", code: "000" }, qty: 20, tags: [ "appliance", "school" ] },
si queremos a帽adir un nuevo elemento a la propiedad de arreglo podemos hacerlo con el operador $push
db.inventory.updateOne(
{
_id: 4
},
{
$push: {
tags: "anything"
}
}
)
si queremos a帽adir varios elementos a la propiedad de arreglo podemos hacerlo con el operador $each
db.inventory.updateMany({},
{
$push: {
tags: {
$each: ["ele1", "ele2"]
}
}
}
)
caso contrario, si queremos quitar un elemento de la propiedad de arreglo podemos hacerlo con el operador $pull
db.inventory.updateMany({},
{
$pull: {
tags: "book"
}
}
)
si queremos quitar varios elementos de la propiedad de arreglo podemos hacerlo con el operador $in
db.inventory.updateMany({},
{
$pull: {
tags: {
$in: ["ele1", "ele2"]
}
}
}
)
Resumiendo
$push: a帽ade un elemento a un arreglo
$each: a帽ade varios elementos a un arreglo
$pull: remueve un elemento de un arreglo
$in: remueve varios elementos de un arreglo
Otra forma de hacerlo:
db.inventory.updateMany(
{},
{
//delete this elements in a array
$pullAll: {
tags: ["notebook", "pencil"],
},
}
);
Want to see more contributions, questions and answers from the community?