{"id":598,"date":"2023-10-23T10:18:57","date_gmt":"2023-10-23T08:18:57","guid":{"rendered":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/?page_id=598"},"modified":"2025-07-26T18:54:06","modified_gmt":"2025-07-26T16:54:06","slug":"2-5-inserir-documents","status":"publish","type":"page","link":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/2-5-inserir-documents\/","title":{"rendered":"2.5. Inserir documents"},"content":{"rendered":"<p>Com que tenim la col\u00b7lecci\u00f3 <strong>chr1<\/strong> buida hi inserirem documents:<\/p>\n<p>Inserirem el seg\u00fcent document amb informaci\u00f3 del gen <strong>uc001aaa.3<\/strong>, localitzat en el cromosoma 1:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\" data-enlighter-theme=\"droide\">{ \"name\": \"uc001aaa.3\", \"chrom\": \"chr1\", \"strand\": \"+\", \"txStart\": \r\n11873, \"txEnd\": 14409, \"cdsStart\": 11873, \"cdsEnd\": 11873, \r\n\"exonCount\": 3, \"exonStarts\": \"11873,12612,13220,\", \"exonEnds\": \r\n\"12227,12721,14409,\", \"proteinID\": \"\", \"alignID\": \"uc001aaa.3\"}<\/pre>\n<p>Per inserir aquest document a la col\u00b7lecci\u00f3 <strong>chr1<\/strong> utilitzarem la instrucci\u00f3 <code>db.chr1.insert();<\/code> on s\u2019indica amb <code>db<\/code> la base de dades a la qual estem connectats, <code>db.chr1...<\/code> , la col\u00b7lecci\u00f3 on inserim el nou document, la col\u00b7lecci\u00f3 <strong>chr1,<\/strong> i la funci\u00f3 insert() que espera com a par\u00e0metre el document que vam inserir:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mariadb\" data-enlighter-theme=\"mowtwo\">db.chr1.insert({ \"name\": \"uc001aaa.3\", \"chrom\": \"chr1\", \"strand\": \"+\", \r\n\"txStart\": 11873, \"txEnd\": 14409, \"cdsStart\": 11873, \"cdsEnd\": 11873, \r\n\"exonCount\": 3, \"exonStarts\": \"11873,12612,13220,\", \"exonEnds\": \r\n\"12227,12721,14409,\", \"proteinID\": \"\", \"alignID\": \"uc001aaa.3\"});<\/pre>\n<p>Si la inserci\u00f3 s\u2019ha realitzat correctament el sistema ens mostra el missatge seg\u00fcent:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\" data-enlighter-theme=\"droide\">WriteResult({ \"nInserted\" : 1 })<\/pre>\n<p>Ara hi inserirem dos documents m\u00e9s. Els documents JSON amb informaci\u00f3 sobre els gens <strong>uc010nxr.1<\/strong> i <strong>uc009vit.3<\/strong>, tamb\u00e9 localitzats en el cromosoma 1.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mariadb\" data-enlighter-theme=\"mowtwo\">db.chr1.insert({ \"name\": \"uc010nxr.1\", \"chrom\": \"chr1\", \"strand\": \"+\", \r\n\"txStart\": 11873, \"txEnd\": 14409, \"cdsStart\": 11873, \"cdsEnd\": 11873, \r\n\"exonCount\": 3, \"exonStarts\": \"11873,12645,13220,\", \"exonEnds\": \r\n\"12227,12697,14409,\", \"proteinID\": \"\", \"alignID\": \"uc010nxr.1\"});\r\n\r\n\r\ndb.chr1.insert({ \"name\": \"uc009vit.3\", \"chrom\": \"chr1\", \"strand\": \"-\", \r\n\"txStart\": 14361, \"txEnd\": 19759, \"cdsStart\": 14361, \"cdsEnd\": 14361, \r\n\"exonCount\": 9, \"exonStarts\": \"14361,14969,15795,16606,16857,17232,17914,18267,18912,\", \r\n\"exonEnds\": \r\n\"14829,15038,15947,16765,17055,17742,18061,18366,19759,\", \r\n\"proteinID\": \"\", \"alignID\": \"uc009vit.3\"});<\/pre>\n<p>Ara eliminarem tota la col\u00b7lecci\u00f3<strong> chr1 <\/strong>de documents amb la instrucci\u00f3 <code>db.chr1.drop();<\/code><\/p>\n<p>I la tornem a crear:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mariadb\" data-enlighter-theme=\"mowtwo\">db.createCollection(\"chr1\");<\/pre>\n<p>per inserir els tres documents alhora amb la instrucci\u00f3 <code>insertMany();<\/code><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mariadb\" data-enlighter-theme=\"mowtwo\">&gt; db.chr1.drop();\r\ntrue\r\n&gt; db.createCollection(\"chr1\");\r\n{ \"ok\" : 1 }\r\n&gt; show collections\r\nchr1<\/pre>\n<p>A la part de fitxers JSON hem vist que moltes vegades trobem un fitxer amb una col\u00b7lecci\u00f3 de documents que estan tots en un <em>array<\/em>.<\/p>\n<p>Els tres documents amb la informaci\u00f3 dels gens dels exemples anteriors els tenim ara dins d\u2019un <em>array<\/em>:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\" data-enlighter-theme=\"droide\">[{ \"name\": \"uc001aaa.3\", \"chrom\": \"chr1\", \"strand\": \"+\", \"txStart\":\u00a0\r\n11873, \"txEnd\": 14409, \"cdsStart\": 11873, \"cdsEnd\": 11873, \r\n\"exonCount\": 3, \"exonStarts\": \"11873,12612,13220,\", \"exonEnds\": \r\n\"12227,12721,14409,\", \"proteinID\": \"\", \"alignID\": \"uc001aaa.3\"}, \r\n{\"name\": \"uc010nxr.1\", \"chrom\": \"chr1\", \"strand\": \"+\", \"txStart\": \r\n11873, \"txEnd\": 14409, \"cdsStart\": 11873, \"cdsEnd\": 11873, \r\n\"exonCount\": 3, \"exonStarts\": \"11873,12645,13220,\", \"exonEnds\": \r\n\"12227,12697,14409,\", \"proteinID\": \"\", \"alignID\": \"uc010nxr.1\"}, \r\n{\"name\": \"uc009vit.3\", \"chrom\": \"chr1\", \"strand\": \"-\", \"txStart\": \r\n14361, \"txEnd\": 19759, \"cdsStart\": 14361, \"cdsEnd\": 14361, \r\n\"exonCount\": 9, \"exonStarts\": \r\n\"14361,14969,15795,16606,16857,17232,17914,18267,18912,\", \r\n\"exonEnds\": \"14829,15038,15947,16765,17055,17742,18061,18366,19759,\", \r\n\"proteinID\": \"\", \"alignID\": \"uc009vit.3\"}]<\/pre>\n<p>I els inserirem en la col\u00b7lecci\u00f3 <strong>chr1<\/strong> amb la instrucci\u00f3 <code>insertMany();<\/code><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mariadb\" data-enlighter-theme=\"mowtwo\">db.chr1.insertMany([{ \"name\": \"uc001aaa.3\", \"chrom\": \"chr1\",\r\n\"strand\": \"+\", \"txStart\": 11873, \"txEnd\": 14409, \"cdsStart\": 11873,\r\n\"cdsEnd\": 11873, \"exonCount\": 3, \"exonStarts\": \"11873,12612,13220,\", \r\n\"exonEnds\": \"12227,12721,14409,\", \"proteinID\": \"\", \"alignID\": \r\n\"uc001aaa.3\"}, {\"name\": \"uc010nxr.1\", \"chrom\": \"chr1\", \"strand\": \"+\", \r\n\"txStart\": 11873, \"txEnd\": 14409, \"cdsStart\": 11873, \"cdsEnd\": 11873, \r\n\"exonCount\": 3, \"exonStarts\": \"11873,12645,13220,\", \"exonEnds\": \r\n\"12227,12697,14409,\", \"proteinID\": \"\", \"alignID\": \"uc010nxr.1\"}, \r\n{\"name\": \"uc009vit.3\", \"chrom\": \"chr1\", \"strand\": \"-\", \"txStart\": \r\n14361, \"txEnd\": 19759, \"cdsStart\": 14361, \"cdsEnd\": 14361, \r\n\"exonCount\": 9, \"exonStarts\": \r\n\"14361,14969,15795,16606,16857,17232,17914,18267,18912,\", \r\n\"exonEnds\": \r\n\"14829,15038,15947,16765,17055,17742,18061,18366,19759,\", \r\n\"proteinID\": \"\", \"alignID\": \"uc009vit.3\"}]);<\/pre>\n<p>Ja tenim una altra vegada els tres documents a la col\u00b7lecci\u00f3 <strong>chr1<\/strong> de la base de dades <strong>uoc, <\/strong>i veurem algunes instruccions b\u00e0siques per gestionar la informaci\u00f3 amb MongoDB.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Com que tenim la col\u00b7lecci\u00f3 chr1 buida hi inserirem documents: Inserirem el seg\u00fcent document amb informaci\u00f3 del gen uc001aaa.3, localitzat en el cromosoma 1: { &#8220;name&#8221;: &#8220;uc001aaa.3&#8221;, &#8220;chrom&#8221;: &#8220;chr1&#8221;, &#8220;strand&#8221;: &#8220;+&#8221;, &#8220;txStart&#8221;: 11873, &#8220;txEnd&#8221;: 14409, &#8220;cdsStart&#8221;: 11873, &#8220;cdsEnd&#8221;: 11873, &#8220;exonCount&#8221;: 3, &#8220;exonStarts&#8221;: &#8220;11873,12612,13220,&#8221;, &#8220;exonEnds&#8221;: &#8220;12227,12721,14409,&#8221;, &#8220;proteinID&#8221;: &#8220;&#8221;, &#8220;alignID&#8221;: &#8220;uc001aaa.3&#8221;} Per inserir aquest document a la [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"acf":[],"_links":{"self":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages\/598"}],"collection":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/comments?post=598"}],"version-history":[{"count":8,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages\/598\/revisions"}],"predecessor-version":[{"id":1058,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages\/598\/revisions\/1058"}],"wp:attachment":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/media?parent=598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}