FrontEnd.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from flask import Flask\n",
    "from flask import render_template, request"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * Serving Flask app \"__main__\" (lazy loading)\n",
      " * Environment: production\n",
      "   WARNING: This is a development server. Do not use it in a production deployment.\n",
      "   Use a production WSGI server instead.\n",
      " * Debug mode: off\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      " * Running on http://127.0.0.1:5000/ (Press CTRL+C to quit)\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:08] \"GET / HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /developthon HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /css/style.css HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /css/coin-slider.css HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /js/cufon-yui.js HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /js/cufon-ubuntu.js HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /js/jquery-1.4.2.min.js HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /js/script.js HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /js/coin-slider.min.js HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /images/slide1.jpg HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /images/slide2.jpg HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /images/slide3.jpg HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /images/gal1.jpg HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /images/gal2.jpg HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /images/gal3.jpg HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /images/gal4.jpg HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /images/gal5.jpg HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:32:14] \"GET /images/gal6.jpg HTTP/1.1\" 404 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:35:06] \"POST /result1 HTTP/1.1\" 200 -\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Enter the employee id where name to be added :05\n",
      "Input name : Chinmay\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "127.0.0.1 - - [02/Feb/2020 12:37:49] \"POST /result2 HTTP/1.1\" 200 -\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Enter the employee id to be removed :05\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "127.0.0.1 - - [02/Feb/2020 12:39:34] \"POST /result3 HTTP/1.1\" 200 -\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Enter the employee id to get the immediate senior : 09\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "127.0.0.1 - - [02/Feb/2020 12:40:22] \"POST /result4 HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [02/Feb/2020 12:40:57] \"POST /result5 HTTP/1.1\" 200 -\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "05 Project Coordinator\n",
      "09 SDE\n",
      "Number of positions empty 2\n",
      "Enter new id : 15\n",
      "Enter name : Kabir\n",
      "Enter position : 3\n",
      "Enter upper id : 03\n",
      "Enter lower id : 05\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "127.0.0.1 - - [02/Feb/2020 12:43:10] \"POST /result6 HTTP/1.1\" 200 -\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "15 \n",
      "Enter the employee id to get the immediate senior : 09\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "127.0.0.1 - - [02/Feb/2020 12:44:03] \"POST /result4 HTTP/1.1\" 200 -\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Enter id : 15\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "127.0.0.1 - - [02/Feb/2020 12:44:46] \"POST /result7 HTTP/1.1\" 200 -\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Input smaller level id : 15\n",
      "Input bigger level id : 9\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[2020-02-02 12:45:04,988] ERROR in app: Exception on /result8 [POST]\n",
      "Traceback (most recent call last):\n",
      "  File \"C:\\Users\\aksha\\Anaconda3\\lib\\site-packages\\flask\\app.py\", line 2446, in wsgi_app\n",
      "    response = self.full_dispatch_request()\n",
      "  File \"C:\\Users\\aksha\\Anaconda3\\lib\\site-packages\\flask\\app.py\", line 1951, in full_dispatch_request\n",
      "    rv = self.handle_user_exception(e)\n",
      "  File \"C:\\Users\\aksha\\Anaconda3\\lib\\site-packages\\flask\\app.py\", line 1820, in handle_user_exception\n",
      "    reraise(exc_type, exc_value, tb)\n",
      "  File \"C:\\Users\\aksha\\Anaconda3\\lib\\site-packages\\flask\\_compat.py\", line 39, in reraise\n",
      "    raise value\n",
      "  File \"C:\\Users\\aksha\\Anaconda3\\lib\\site-packages\\flask\\app.py\", line 1949, in full_dispatch_request\n",
      "    rv = self.dispatch_request()\n",
      "  File \"C:\\Users\\aksha\\Anaconda3\\lib\\site-packages\\flask\\app.py\", line 1935, in dispatch_request\n",
      "    return self.view_functions[rule.endpoint](**req.view_args)\n",
      "  File \"<ipython-input-2-3e51bac33bdc>\", line 362, in result8\n",
      "    print_res = {\"Depth Difference\": diff(small,big)}\n",
      "  File \"<ipython-input-2-3e51bac33bdc>\", line 356, in diff\n",
      "    b = depth(big)\n",
      "  File \"<ipython-input-2-3e51bac33bdc>\", line 349, in depth\n",
      "    id = details[id][2][0]\n",
      "KeyError: '9'\n",
      "127.0.0.1 - - [02/Feb/2020 12:45:04] \"POST /result8 HTTP/1.1\" 500 -\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Input smaller level id : 15\n",
      "Input bigger level id : 09\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "127.0.0.1 - - [02/Feb/2020 12:45:23] \"POST /result8 HTTP/1.1\" 200 -\n"
     ]
    }
   ],
   "source": [
    "#from app import app\n",
    "app = Flask(__name__)\n",
    "\n",
    "@app.route('/home')\n",
    "\n",
    "def index():\n",
    "    \n",
    "    return render_template('index.html',title = 'Home')\n",
    "@app.route('/developthon')\n",
    "\n",
    "def developthon():\n",
    "    return render_template('support.html', title = 'Developthon')\n",
    "\n",
    "@app.route('/result1',methods = ['POST', 'GET'])\n",
    "def result1():\n",
    "    if request.method == 'POST':\n",
    "        import sqlite3\n",
    "        conn = sqlite3.connect('present.db')\n",
    "        cur = conn.cursor()\n",
    "\n",
    "        sqlstr = 'SELECT emp_id, emp_name, emp_position, upper, lower FROM present'\n",
    "        details = {}\n",
    "        for row in cur.execute(sqlstr):\n",
    "            emp_id = row[0]\n",
    "            emp_name = row[1]\n",
    "            emp_pos = row[2]\n",
    "            if row[3] is not \"NULL\":\n",
    "                upper = row[3].split(\" \")\n",
    "            if row[4] is not \"NULL\":\n",
    "                lower = row[4].split(\" \")\n",
    "            details[emp_id]=[]\n",
    "            details[emp_id].append(emp_name)\n",
    "            details[emp_id].append(emp_pos)\n",
    "            details[emp_id].append(upper)\n",
    "            details[emp_id].append(lower)\n",
    "\n",
    "        cur.close()\n",
    "    \n",
    "    result = request.form\n",
    "    return details\n",
    "\n",
    "@app.route('/result2',methods = ['POST', 'GET'])\n",
    "def result2():\n",
    "    if request.method == 'POST':\n",
    "        import sqlite3\n",
    "        conn = sqlite3.connect('present.db')\n",
    "        cur = conn.cursor()\n",
    "\n",
    "        sqlstr = 'SELECT emp_id, emp_name, emp_position, upper, lower FROM present'\n",
    "        details = {}\n",
    "        for row in cur.execute(sqlstr):\n",
    "            emp_id = row[0]\n",
    "            emp_name = row[1]\n",
    "            emp_pos = row[2]\n",
    "            if row[3] is not \"NULL\":\n",
    "                upper = row[3].split(\" \")\n",
    "            if row[4] is not \"NULL\":\n",
    "                lower = row[4].split(\" \")\n",
    "            details[emp_id]=[]\n",
    "            details[emp_id].append(emp_name)\n",
    "            details[emp_id].append(emp_pos)\n",
    "            details[emp_id].append(upper)\n",
    "            details[emp_id].append(lower)\n",
    "\n",
    "        cur.close()\n",
    "        def add_emp(id):\n",
    "            if details[id][0] == \"NULL\":\n",
    "                name = input(\"Input name : \")\n",
    "                details[id][0] = name\n",
    "                conn = sqlite3.connect('present.db')\n",
    "                cur = conn.cursor()\n",
    "                cur.execute('UPDATE present SET emp_name = ? WHERE emp_id = ?',(name,id,))\n",
    "                conn.commit()\n",
    "                cur.close()\n",
    "            else:\n",
    "                print(\"Position not empty!\")\n",
    "        add = input(\"Enter the employee id where name to be added :\")\n",
    "        \n",
    "        print_res = {\"Employee Added\":add_emp(add)}\n",
    "    #result = request.form\n",
    "    return print_res\n",
    "\n",
    "@app.route('/result3', methods = ['POST', 'GET'])\n",
    "\n",
    "def result3():\n",
    "    if request.method == \"POST\":\n",
    "        import sqlite3\n",
    "        conn = sqlite3.connect('present.db')\n",
    "        cur = conn.cursor()\n",
    "\n",
    "        sqlstr = 'SELECT emp_id, emp_name, emp_position, upper, lower FROM present'\n",
    "        details = {}\n",
    "        for row in cur.execute(sqlstr):\n",
    "            emp_id = row[0]\n",
    "            emp_name = row[1]\n",
    "            emp_pos = row[2]\n",
    "            if row[3] is not \"NULL\":\n",
    "                upper = row[3].split(\" \")\n",
    "            if row[4] is not \"NULL\":\n",
    "                lower = row[4].split(\" \")\n",
    "            details[emp_id]=[]\n",
    "            details[emp_id].append(emp_name)\n",
    "            details[emp_id].append(emp_pos)\n",
    "            details[emp_id].append(upper)\n",
    "            details[emp_id].append(lower)\n",
    "\n",
    "        cur.close()\n",
    "        def remove_emp(id):\n",
    "            name = details[id][0]\n",
    "            details[id][0] = \"NULL\"\n",
    "            conn = sqlite3.connect('present.db')\n",
    "            cur = conn.cursor()\n",
    "            cur.execute('INSERT INTO past (id,name,position) VALUES (?,?,?)',(id,name,details[id][1],))\n",
    "            #sqlstr = 'UPDATE present SET emp_name = \"NULL\" WHERE emp_id = {}'.format(id)\n",
    "            cur.execute('UPDATE present SET emp_name = \"NULL\" WHERE emp_id = ?',(id,))\n",
    "            conn.commit()\n",
    "            cur.close()\n",
    "        rem = input(\"Enter the employee id to be removed :\")\n",
    "        \n",
    "        print_res = {\"Employee Removed\":remove_emp(rem)}\n",
    "    return print_res\n",
    "        \n",
    "@app.route('/result4', methods = ['POST', 'GET'])\n",
    "    \n",
    "def result4():\n",
    "    if request.method == \"POST\":\n",
    "        import sqlite3\n",
    "        conn = sqlite3.connect('present.db')\n",
    "        cur = conn.cursor()\n",
    "\n",
    "        sqlstr = 'SELECT emp_id, emp_name, emp_position, upper, lower FROM present'\n",
    "        details = {}\n",
    "        for row in cur.execute(sqlstr):\n",
    "            emp_id = row[0]\n",
    "            emp_name = row[1]\n",
    "            emp_pos = row[2]\n",
    "            if row[3] is not \"NULL\":\n",
    "                upper = row[3].split(\" \")\n",
    "            if row[4] is not \"NULL\":\n",
    "                lower = row[4].split(\" \")\n",
    "            details[emp_id]=[]\n",
    "            details[emp_id].append(emp_name)\n",
    "            details[emp_id].append(emp_pos)\n",
    "            details[emp_id].append(upper)\n",
    "            details[emp_id].append(lower)\n",
    "\n",
    "        cur.close()\n",
    "        def adj_senior(id):\n",
    "            senior = details[id][2][0]\n",
    "            depth = 1\n",
    "            while True:\n",
    "                if details[senior][0]==\"NULL\":\n",
    "                    senior = details[senior][2][0]\n",
    "                    depth += 1\n",
    "                else:\n",
    "                    return senior,depth\n",
    "        \n",
    "        find = input(\"Enter the employee id to get the immediate senior : \")\n",
    "        #print(adj_senior(find))\n",
    "        print_res = {\"Reporting Senior\": adj_senior(find)}\n",
    "    return print_res\n",
    "\n",
    "@app.route('/result5', methods = ['POST', 'GET'])\n",
    "\n",
    "def result5():\n",
    "    if request.method == 'POST':\n",
    "        import sqlite3\n",
    "        conn = sqlite3.connect('present.db')\n",
    "        cur = conn.cursor()\n",
    "\n",
    "        sqlstr = 'SELECT emp_id, emp_name, emp_position, upper, lower FROM present'\n",
    "        details = {}\n",
    "        for row in cur.execute(sqlstr):\n",
    "            emp_id = row[0]\n",
    "            emp_name = row[1]\n",
    "            emp_pos = row[2]\n",
    "            if row[3] is not \"NULL\":\n",
    "                upper = row[3].split(\" \")\n",
    "            if row[4] is not \"NULL\":\n",
    "                lower = row[4].split(\" \")\n",
    "            details[emp_id]=[]\n",
    "            details[emp_id].append(emp_name)\n",
    "            details[emp_id].append(emp_pos)\n",
    "            details[emp_id].append(upper)\n",
    "            details[emp_id].append(lower)\n",
    "\n",
    "        cur.close()\n",
    "        count = 0\n",
    "        for i in details:\n",
    "            if details[i][0]==\"NULL\":\n",
    "                count += 1\n",
    "                print(i,details[i][1])\n",
    "        print(\"Number of positions empty\",count)\n",
    "        print_res = { 'Number of Positions Empty' : count }\n",
    "    return print_res\n",
    "\n",
    "@app.route('/result6', methods = ['POST', 'GET'])\n",
    "\n",
    "def result6():\n",
    "    if request.method == 'POST':\n",
    "        import sqlite3\n",
    "        conn = sqlite3.connect('present.db')\n",
    "        cur = conn.cursor()\n",
    "\n",
    "        sqlstr = 'SELECT emp_id, emp_name, emp_position, upper, lower FROM present'\n",
    "        details = {}\n",
    "        for row in cur.execute(sqlstr):\n",
    "            emp_id = row[0]\n",
    "            emp_name = row[1]\n",
    "            emp_pos = row[2]\n",
    "            if row[3] is not \"NULL\":\n",
    "                upper = row[3].split(\" \")\n",
    "            if row[4] is not \"NULL\":\n",
    "                lower = row[4].split(\" \")\n",
    "            details[emp_id]=[]\n",
    "            details[emp_id].append(emp_name)\n",
    "            details[emp_id].append(emp_pos)\n",
    "            details[emp_id].append(upper)\n",
    "            details[emp_id].append(lower)\n",
    "\n",
    "        cur.close()\n",
    "        # add new person in an in-between level\n",
    "        def addNew():\n",
    "\n",
    "            while True:\n",
    "                id = input(\"Enter new id : \")\n",
    "                if id not in details:\n",
    "                    break\n",
    "                else:\n",
    "                    print(\"This id already exists.\")\n",
    "\n",
    "            name = input(\"Enter name : \")\n",
    "            pos = input(\"Enter position : \")\n",
    "            upper = input(\"Enter upper id : \")\n",
    "            lower = input(\"Enter lower id : \")\n",
    "\n",
    "            details[id]=[]\n",
    "            details[id].append(name)\n",
    "            details[id].append(pos)\n",
    "            details[id].append(upper)\n",
    "            details[id].append(lower)\n",
    "\n",
    "            conn = sqlite3.connect('present.db')\n",
    "            cur = conn.cursor()\n",
    "            cur.execute('INSERT INTO present (emp_id, emp_name, emp_position, upper, lower) VALUES (?,?,?,?,?)',(id,name,pos,upper,lower,))\n",
    "\n",
    "            # upper list of lower\n",
    "            uLow = details[str(lower)][2]\n",
    "            ul = \"\"   \n",
    "            for x in uLow: \n",
    "                if x == upper:\n",
    "                    ul += id\n",
    "                else:\n",
    "                    ul += x \n",
    "                ul += ' '\n",
    "            # lower list of upper       \n",
    "            lUp = details[str(upper)][3]\n",
    "            lu = \"\"   \n",
    "            for x in lUp: \n",
    "                if x == lower:\n",
    "                    lu += id\n",
    "                else:\n",
    "                    lu += x \n",
    "                lu += ' '\n",
    "\n",
    "            details[lower][2] = ul.split(\" \")\n",
    "            details[upper][3] = lu.split(\" \")\n",
    "            cur.execute('UPDATE present SET upper = ? where emp_id = ?',(ul,lower,))\n",
    "            cur.execute('UPDATE present SET lower = ? where emp_id = ?',(lu,upper,))\n",
    "            print(ul)\n",
    "            conn.commit()\n",
    "            cur.close()\n",
    "\n",
    "        #addNew()\n",
    "        print_res = {\"Depth \": addNew()}\n",
    "    return print_res\n",
    "\n",
    "\n",
    "@app.route('/result7', methods = ['POST', 'GET'])\n",
    "\n",
    "def result7():\n",
    "    if request.method == 'POST':\n",
    "        import sqlite3\n",
    "        conn = sqlite3.connect('present.db')\n",
    "        cur = conn.cursor()\n",
    "\n",
    "        sqlstr = 'SELECT emp_id, emp_name, emp_position, upper, lower FROM present'\n",
    "        details = {}\n",
    "        for row in cur.execute(sqlstr):\n",
    "            emp_id = row[0]\n",
    "            emp_name = row[1]\n",
    "            emp_pos = row[2]\n",
    "            if row[3] is not \"NULL\":\n",
    "                upper = row[3].split(\" \")\n",
    "            if row[4] is not \"NULL\":\n",
    "                lower = row[4].split(\" \")\n",
    "            details[emp_id]=[]\n",
    "            details[emp_id].append(emp_name)\n",
    "            details[emp_id].append(emp_pos)\n",
    "            details[emp_id].append(upper)\n",
    "            details[emp_id].append(lower)\n",
    "\n",
    "        cur.close()\n",
    "        def depth(id):\n",
    "            count = 0\n",
    "            # details[id][2][0]\n",
    "            while True:\n",
    "                id = details[id][2][0]\n",
    "                if id == 'NULL':\n",
    "                    break\n",
    "                if details[id][0] != 'NULL':\n",
    "                    count += 1\n",
    "            return count\n",
    "    \n",
    "        id = input(\"Enter id : \")\n",
    "        #print('Depth is',depth(id))\n",
    "        print_res = {\"Depth \": depth(id)}\n",
    "    return print_res\n",
    "\n",
    "@app.route('/result8', methods = ['POST', 'GET'])\n",
    "\n",
    "def result8():\n",
    "    if request.method == 'POST':\n",
    "        import sqlite3\n",
    "        conn = sqlite3.connect('present.db')\n",
    "        cur = conn.cursor()\n",
    "\n",
    "        sqlstr = 'SELECT emp_id, emp_name, emp_position, upper, lower FROM present'\n",
    "        details = {}\n",
    "        for row in cur.execute(sqlstr):\n",
    "            emp_id = row[0]\n",
    "            emp_name = row[1]\n",
    "            emp_pos = row[2]\n",
    "            if row[3] is not \"NULL\":\n",
    "                upper = row[3].split(\" \")\n",
    "            if row[4] is not \"NULL\":\n",
    "                lower = row[4].split(\" \")\n",
    "            details[emp_id]=[]\n",
    "            details[emp_id].append(emp_name)\n",
    "            details[emp_id].append(emp_pos)\n",
    "            details[emp_id].append(upper)\n",
    "            details[emp_id].append(lower)\n",
    "\n",
    "        cur.close()\n",
    "        def depth(id):\n",
    "            count = 0\n",
    "            # details[id][2][0]\n",
    "            while True:\n",
    "                id = details[id][2][0]\n",
    "                if id == 'NULL':\n",
    "                    break\n",
    "                if details[id][0] != 'NULL':\n",
    "                    count += 1\n",
    "            return count        \n",
    "        def diff(small,big):\n",
    "            b = depth(big)\n",
    "            s = depth(small)\n",
    "            return s-b\n",
    "\n",
    "        small = input(\"Input smaller level id : \")\n",
    "        big = input(\"Input bigger level id : \")\n",
    "        print_res = {\"Depth Difference\": diff(small,big)}\n",
    "    return print_res\n",
    "    \n",
    "if __name__ == '__main__':\n",
    "    app.run()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}