027.mongodb class 1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7c92b895",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pymongo\n",
    "client = pymongo.MongoClient(\"mongodb+srv://mongodb:<passkey>@cluster0.qunyg.mongodb.net/myFirstDatabase?retryWrites=true&w=majority\")\n",
    "db = client.test\n",
    "print(db)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fd753d59",
   "metadata": {},
   "outputs": [],
   "source": [
    "!pip install pymongo[srv]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a8094321",
   "metadata": {},
   "outputs": [],
   "source": [
    "!pip install dnspython"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "e05174e5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Database(MongoClient(host=['localhost:27017'], document_class=dict, tz_aware=False, connect=True), 'test')\n"
     ]
    }
   ],
   "source": [
    "import pymongo\n",
    "client = pymongo.MongoClient(\"mongodb://localhost:27017/\")\n",
    "db = client.test\n",
    "print(db)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "b486cd56",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Database(MongoClient(host=['localhost:27017'], document_class=dict, tz_aware=False, connect=True), 'test')\n"
     ]
    }
   ],
   "source": [
    "print(db)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "bfc67d6e",
   "metadata": {},
   "outputs": [],
   "source": [
    "db1 = client.test1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "dc836214",
   "metadata": {},
   "outputs": [],
   "source": [
    "db2 = client['iNeurondb']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "c9432423",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['admin', 'config', 'iNeurondb', 'local']"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "client.list_database_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "83861f84",
   "metadata": {},
   "outputs": [],
   "source": [
    "coll1 = db2['ineuron_collection']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "a3061104",
   "metadata": {},
   "outputs": [],
   "source": [
    "dict1 = {\n",
    "    \"name\" :\"sudhanshu\",\n",
    "    \"email_id\" :\"sudhanshu@ineuron.ai\",\n",
    "    \"product\" : [\"one neuron\" , \"tech neuron\" , \"kids neuron \" , \"drone fleetmatics\"],\n",
    "    \"company\" : \"ineuron intelligence private limited\"\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "a2be9c48",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.InsertOneResult at 0x2cbfa8ebf40>"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "coll1.insert_one(dict1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "615a426a",
   "metadata": {},
   "outputs": [],
   "source": [
    "dict3 = {\n",
    "    \"_id\" :\"fsdfafdsafasfdfdgasdf\",\n",
    "    \"name\" :\"sudhanshu\",\n",
    "    \"email_id\" :\"sudhanshu@ineuron.ai\",\n",
    "    \"product\" : [\"one neuron\" , \"tech neuron\" , \"kids neuron \" , \"drone fleetmatics\"],\n",
    "    \"company\" : \"ineuron intelligence private limited\",\n",
    "    \"phone_number\": \"34534534635\"\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "91c9208f",
   "metadata": {},
   "outputs": [],
   "source": [
    "coll1.insert_one(dict3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f9baf7e8",
   "metadata": {},
   "outputs": [],
   "source": [
    "list1 = [\n",
    "        {\n",
    "            \"item\": \"canvas\",\n",
    "            \"qty\": 100,\n",
    "            \"size\": {\"h\": 28, \"w\": 35.5, \"uom\": \"cm\"},\n",
    "            \"status\": \"A\",\n",
    "        },\n",
    "        {\n",
    "            \"item\": \"journal\",\n",
    "            \"qty\": 25,\n",
    "            \"size\": {\"h\": 14, \"w\": 21, \"uom\": \"cm\"},\n",
    "            \"status\": \"A\",\n",
    "        },\n",
    "        {\n",
    "            \"item\": \"mat\",\n",
    "            \"qty\": 85,\n",
    "            \"size\": {\"h\": 27.9, \"w\": 35.5, \"uom\": \"cm\"},\n",
    "            \"status\": \"A\",\n",
    "        },\n",
    "        {\n",
    "            \"item\": \"mousepad\",\n",
    "            \"qty\": 25,\n",
    "            \"size\": {\"h\": 19, \"w\": 22.85, \"uom\": \"cm\"},\n",
    "            \"status\": \"P\",\n",
    "        },\n",
    "        {\n",
    "            \"item\": \"notebook\",\n",
    "            \"qty\": 50,\n",
    "            \"size\": {\"h\": 8.5, \"w\": 11, \"uom\": \"in\"},\n",
    "            \"status\": \"P\",\n",
    "        },\n",
    "        {\n",
    "            \"item\": \"paper\",\n",
    "            \"qty\": 100,\n",
    "            \"size\": {\"h\": 8.5, \"w\": 11, \"uom\": \"in\"},\n",
    "            \"status\": \"D\",\n",
    "        },\n",
    "        {\n",
    "            \"item\": \"planner\",\n",
    "            \"qty\": 75,\n",
    "            \"size\": {\"h\": 22.85, \"w\": 30, \"uom\": \"cm\"},\n",
    "            \"status\": \"D\",\n",
    "        },\n",
    "        {\n",
    "            \"item\": \"postcard\",\n",
    "            \"qty\": 45,\n",
    "            \"size\": {\"h\": 10, \"w\": 15.25, \"uom\": \"cm\"},\n",
    "            \"status\": \"A\",\n",
    "        },\n",
    "        {\n",
    "            \"item\": \"sketchbook\",\n",
    "            \"qty\": 80,\n",
    "            \"size\": {\"h\": 14, \"w\": 21, \"uom\": \"cm\"},\n",
    "            \"status\": \"A\",\n",
    "        },\n",
    "        {\n",
    "            \"item\": \"sketch pad\",\n",
    "            \"qty\": 95,\n",
    "            \"size\": {\"h\": 22.85, \"w\": 30.5, \"uom\": \"cm\"},\n",
    "            \"status\": \"A\",\n",
    "        },\n",
    "    ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "54f439ea",
   "metadata": {},
   "outputs": [],
   "source": [
    "coll1.insert_many(list1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c3568476",
   "metadata": {},
   "outputs": [],
   "source": [
    "list2 = [\n",
    "    {\n",
    "    \"name\" :\"sudhanshu\",\n",
    "    \"email_id\" :\"sudhanshu@ineuron.ai\",\n",
    "    \"product\" : [\"one neuron\" , \"tech neuron\" , \"kids neuron \" , \"drone fleetmatics\"],\n",
    "    \"company\" : \"ineuron intelligence private limited\"\n",
    "},\n",
    "    {\n",
    "    \"name\" :\"sudhanshu\",\n",
    "    \"email_id\" :\"sudhanshu@ineuron.ai\",\n",
    "    \"product\" : [\"one neuron\" , \"tech neuron\" , \"kids neuron \" , \"drone fleetmatics\"],\n",
    "    \"company\" : \"ineuron intelligence private limited\"\n",
    "},\n",
    "    {\n",
    "    \"name\" :\"sudhanshu\",\n",
    "    \"email_id\" :\"sudhanshu@ineuron.ai\",\n",
    "    \"product\" : [\"one neuron\" , \"tech neuron\" , \"kids neuron \" , \"drone fleetmatics\"],\n",
    "    \"company\" : \"ineuron intelligence private limited\"\n",
    "},\n",
    "    {\n",
    "    \"name\" :\"sudhanshu\",\n",
    "    \"email_id\" :\"sudhanshu@ineuron.ai\",\n",
    "    \"product\" : [\"one neuron\" , \"tech neuron\" , \"kids neuron \" , \"drone fleetmatics\"],\n",
    "    \"company\" : \"ineuron intelligence private limited\"\n",
    "},\n",
    "    {\n",
    "    \"name\" :\"sudhanshu\",\n",
    "    \"email_id\" :\"sudhanshu@ineuron.ai\",\n",
    "    \"product\" : [\"one neuron\" , \"tech neuron\" , \"kids neuron \" , \"drone fleetmatics\"],\n",
    "    \"company\" : \"ineuron intelligence private limited\"\n",
    "},\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e14c8986",
   "metadata": {},
   "outputs": [],
   "source": [
    "coll1.insert_many(list2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c28271b4",
   "metadata": {},
   "outputs": [],
   "source": [
    "Break till 11.48 AM IST "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "bf0bb8e1",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'_id': ObjectId('62825cfdf1a69f0688eb771f'), 'name': 'sudhanshu', 'email_id': 'sudhanshu@ineuron.ai', 'product': ['one neuron', 'tech neuron', 'kids neuron ', 'drone fleetmatics'], 'company': 'ineuron intelligence private limited'}\n"
     ]
    }
   ],
   "source": [
    "for i in coll1.find():\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fcfa5a5e",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find({\"name\" :\"sudhanshu\"}):\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3cab3b55",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find({\"name\" :{\"$in\" :[\"sudhan\" , \"sudhanshu\" ,\"sudh\"]},'email_id':\"sudhanshu@ineuron.ai\"}):\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "df8e48bc",
   "metadata": {},
   "outputs": [],
   "source": [
    "coll1.find_one()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "08c2a535",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find({\"qty\":{'$gte' : 25}}):\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fff3b2d1",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find({\"qty\":{'$lte' : 25}}):\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ed36b615",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find():\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "499a9904",
   "metadata": {},
   "outputs": [],
   "source": [
    "coll1.update_many({'name': 'sudhanshu'},{\"$set\":{'name': 'sudhanshu kumar'}})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0858fb32",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find():\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9d5539ab",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find().limit(2):\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "08f1f24d",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find({'qty' : {'$not' :{\"$gte\" : 25}}}):\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "be4320ca",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find({'qty' : {'$not' :{\"$lte\" : 25}}}):\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "449536c9",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find():\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "145e21c4",
   "metadata": {},
   "outputs": [],
   "source": [
    "coll1.find_one_and_update({'item': 'journal'} , {\"$set\" : {\"qty\" : 250}})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d88e0ec4",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find() : \n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "45730883",
   "metadata": {},
   "outputs": [],
   "source": [
    "coll1.update_many({'qty': {\"$gt\" : 50}} , {\"$set\" :{'qty' : 400}})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "22c4ffbe",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find() :\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "07221500",
   "metadata": {},
   "outputs": [],
   "source": [
    "coll1.delete_many({'name': 'sudhanshu kumar'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8dc26414",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in coll1.find():\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "448fe5a2",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "fd354288a369f680a7322ddff2a06d3b3ac546c5fe22b956c0c96b589b2c4d3d"
  },
  "kernelspec": {
   "display_name": "Python 3.10.4 64-bit",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}