{"id":22030,"date":"2022-08-24T00:27:03","date_gmt":"2022-08-24T03:27:03","guid":{"rendered":"http:\/\/maurinsoft.com.br\/?p=22030"},"modified":"2022-08-24T00:27:03","modified_gmt":"2022-08-24T03:27:03","slug":"mongodb-buscando-o-registro","status":"publish","type":"post","link":"https:\/\/maurinsoft.com.br\/wp\/mongodb-buscando-o-registro\/","title":{"rendered":"MongoDB buscando o registro"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>Baseado nas inclus\u00f5es, vamos pesquisar todos com idade superior a 30 anos.<\/p>\n\n\n\n<p>Para isso, usamos o comando<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>db.funcionarios.find({idade:{$gt: 30}})<\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"http:\/\/maurinsoft.com.br\/wp-content\/uploads\/2022\/08\/image-53.png\" alt=\"\" class=\"wp-image-22031\"\/><\/figure>\n\n\n\n<p>Buscando resultado  Funcion\u00e1rios com idade menor ou igual a 30 anos<\/p>\n\n\n\n<p>db.funcionarios.find({idade:({$lt: 30},{$eq:30})})<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"http:\/\/maurinsoft.com.br\/wp-content\/uploads\/2022\/08\/image-54.png\" alt=\"\" class=\"wp-image-22032\"\/><figcaption>Funcion\u00e1rios com idade menor ou igual a 30 anos<\/figcaption><\/figure>\n\n\n\n<p>Encontrando funcionarios cuja comida \u00e9 pizza;<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>db.funcionarios.find({&#8220;favoritos.comida&#8221;:&#8221;pizza&#8221;})<\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"http:\/\/maurinsoft.com.br\/wp-content\/uploads\/2022\/08\/image-55.png\" alt=\"\" class=\"wp-image-22036\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Alterar o telefone do Funcion\u00e1rio Wilson<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>db.funcionarios.updateOne({nome:&#8221;Wilson&#8221;},{$set:{&#8220;telefone.pessoal&#8221;:&#8217;93-123-45-67&#8242;}},{multi:true})<\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"http:\/\/maurinsoft.com.br\/wp-content\/uploads\/2022\/08\/image-56.png\" alt=\"\" class=\"wp-image-22037\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Alterar o privil\u00e9gio do Roberto para o usu\u00e1rio normal: user.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>db.funcionarios.updateOne({nome:&#8221;Roberto&#8221;},{$set:{&#8220;privilegios&#8221;:&#8217;user&#8217;}})<\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"http:\/\/maurinsoft.com.br\/wp-content\/uploads\/2022\/08\/image-57.png\" alt=\"\" class=\"wp-image-22038\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Encontre todos os funcionarios cujo artista seja Picasso.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>db.funcionarios.find({&#8220;favoritos.artista&#8221;:&#8217;Picasso&#8217;})<\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"http:\/\/maurinsoft.com.br\/wp-content\/uploads\/2022\/08\/image-58.png\" alt=\"\" class=\"wp-image-22039\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Delete o empregado cujo nome \u00e9 Joao<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>db.funcionarios.remove({nome:&#8221;Joao&#8221;})<\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"http:\/\/maurinsoft.com.br\/wp-content\/uploads\/2022\/08\/image-59.png\" alt=\"\" class=\"wp-image-22040\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Listar todos os funcionarios e ordenando por nome<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>db.funcionarios.find().sort({nome:1})<\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"http:\/\/maurinsoft.com.br\/wp-content\/uploads\/2022\/08\/image-60.png\" alt=\"\" class=\"wp-image-22041\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Adicione um bonus de 15 a todos os funcionarios que tem um bonus menor que 10.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>db.funcionarios.updateMany({},{$inc:{&#8220;pontos.$[elem].bonus&#8221;:15}},{arrayFilters:[{&#8220;elem.bonus&#8221;:{$lte:10}}]})<\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"http:\/\/maurinsoft.com.br\/wp-content\/uploads\/2022\/08\/image-61.png\" alt=\"\" class=\"wp-image-22042\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Baseado nas inclus\u00f5es, vamos pesquisar todos com idade superior a 30 anos. Para isso, usamos o comando db.funcionarios.find({idade:{$gt: 30}}) Buscando resultado Funcion\u00e1rios com idade menor ou igual a 30 anos db.funcionarios.find({idade:({$lt: 30},{$eq:30})}) Encontrando funcionarios cuja comida \u00e9 pizza; db.funcionarios.find({&#8220;favoritos.comida&#8221;:&#8221;pizza&#8221;}) Alterar o telefone do Funcion\u00e1rio Wilson db.funcionarios.updateOne({nome:&#8221;Wilson&#8221;},{$set:{&#8220;telefone.pessoal&#8221;:&#8217;93-123-45-67&#8242;}},{multi:true}) Alterar o privil\u00e9gio do Roberto para o usu\u00e1rio normal: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":21976,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39,68],"tags":[],"class_list":["post-22030","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ia","category-mongodb-banco-de-dados"],"_links":{"self":[{"href":"https:\/\/maurinsoft.com.br\/wp\/wp-json\/wp\/v2\/posts\/22030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maurinsoft.com.br\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maurinsoft.com.br\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maurinsoft.com.br\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maurinsoft.com.br\/wp\/wp-json\/wp\/v2\/comments?post=22030"}],"version-history":[{"count":0,"href":"https:\/\/maurinsoft.com.br\/wp\/wp-json\/wp\/v2\/posts\/22030\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/maurinsoft.com.br\/wp\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/maurinsoft.com.br\/wp\/wp-json\/wp\/v2\/media?parent=22030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maurinsoft.com.br\/wp\/wp-json\/wp\/v2\/categories?post=22030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maurinsoft.com.br\/wp\/wp-json\/wp\/v2\/tags?post=22030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}