mongo_db_work.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pymongo import MongoClient\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import logging\n",
    "logging.basicConfig(level=logging.DEBUG)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "def init_mongo():\n",
    "    \"\"\"\n",
    "    #Creates a connection to our local mongoDB and returns the following:\n",
    "\n",
    "    Returns: \n",
    "        client: A Pymongo client (lowest level object of MongoDB connection)\n",
    "        hot_soup_table: MongoDB Table\n",
    "        kitchen_collection: MongoDB collection inside hot_soup_table.\n",
    "        user_collection: MongoDB collection inside hot_soup_table\n",
    "\n",
    "    \"\"\"\n",
    "    try:\n",
    "        client = MongoClient('mongodb://admin:HotSoup4321!@localhost:27017/hot_soup_local_db?authSource=admin')\n",
    "        hot_soup_table = client['hot_soup_table']\n",
    "        kitchen_collection = hot_soup_table['kitchens']\n",
    "        return client, hot_soup_table, kitchen_collection, user_collection\n",
    "    except:\n",
    "        logging.error(\"Client to MongoDB unavailable.  Please check your environment variables.\")\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Client for connection to MongoDB\n",
    "mongo_client, mongo_table, kitchen_collection = init_mongo()\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Sample Kitchen example\n",
    "\n",
    "sample_kitchen = {\"Name\":\"Scott's Kitchen\",\n",
    " \"Address\": {\n",
    "     \"street_name\":\"Fake Street\",\n",
    "     \"street_number\": \"123\",\n",
    "     \"city\":\"Chicago\",\n",
    "     \"state\":\"Illinois\",\n",
    "     \"zip_code\":\"60127\"\n",
    " },\n",
    " \"Comment\":\"Friendly Staff and Great Food\",\n",
    " \"Phone\":\"1-123-555-4321\",\n",
    " \"Hours\":\n",
    " {\"Monday\": {\"start\": 700, \"end\": 1500},\n",
    "  \"Tuesday\":{\"start\": 900, \"end\": 1200},\n",
    "  \"Wednesday\":{\"start\": 600, \"end\":1500}\n",
    " }\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.InsertOneResult at 0x118ea84f0>"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#inserting above sample_kitchen into the kitchen_collection\n",
    "kitchen_collection.insert_one(sample_kitchen)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'_id': ObjectId('62c26cfe6ec73ffe5727ed4d'), 'Name': \"Scott's Kitchen\", 'Address': {'street_name': 'Fake Street', 'street_number': '123', 'city': 'Chicago', 'state': 'Illinois', 'zip_code': '60127'}, 'Comment': 'Friendly Staff and Great Food', 'Phone': '1-123-555-4321', 'Hours': {'Monday': {'start': 700, 'end': 1500}, 'Tuesday': {'start': 900, 'end': 1200}, 'Wednesday': {'start': 600, 'end': 1500}}}]\n"
     ]
    }
   ],
   "source": [
    "#This is printing out all the values inside the kitchen_collection\n",
    "print(list(kitchen_collection.find()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#How to delete via the name key and outputs the deleted value.\n",
    "#NOTE:  Since it is .delete_one it should always be one!\n",
    "kitchen_collection.delete_one({'Name':\"Scott's Kitchen\"}).deleted_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.DeleteResult at 0x11e008e20>"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "aee8b7b246df8f9039afb4144a1f6fd8d2ca17a180786b69acc140d282b71a49"
  },
  "kernelspec": {
   "display_name": "Python 3.9.13 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.9.13"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}