Elite_Tickets.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 401
        },
        "id": "sQX0HRT-Uv6n",
        "outputId": "1bfc70fd-efae-4581-9678-bd0bcd63db82"
      },
      "source": [
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n",
        "from IPython.display import display\n",
        "print('Welcome to Elite Tickets.')\n",
        "\n",
        "import mysql.connector as sqltr\n",
        "#Please change the MySQL password\n",
        "con=sqltr.connect(host='localhost',user='root',password='soumya126',database='project')\n",
        "if con.is_connected==False:\n",
        "    print('Error in connection')\n",
        "cursor=con.cursor()\n",
        "\n",
        "while True:\n",
        "    print('Date: 20 September, 2020')\n",
        "    print('Day: Sunday')\n",
        "    print('''Movies available:''')\n",
        "    mdf=pd.DataFrame({'Movie ID':['E1493','A3032','E4523','E5099','A6041'],'Movie Name':['Movie1','Movie2','Movie3','Movie4','Movie5'],'Theatre No':['T1','T3','T4','T5','T6'],'Age Rating':['R','PG','PG','PG-13','PG'],'Language':['English','Arabic','English','English','Arabic'],'Morning':['8:00','8:15','8:45','9:15','9:45'],'Afternoon':['12:15','12:45','13:00','14:15','14:45'],'Evening':['16:30','16:45','17:00','17:30','17:45'],'Night':['20:00','20:30','20:45','21:15','21:45']},index=['i)','ii)','iii)','iv)','v)'])\n",
        "    display(mdf)\n",
        "\n",
        "    print('''1) Book tickets\n",
        "2) View Booking Details\n",
        "3) Edit Booking Details\n",
        "4) Cancel Booking\n",
        "5) Popularity''')\n",
        "    print()\n",
        "    choice=input('Enter your choice(1,2,3,4,5): ')\n",
        "    print()\n",
        "\n",
        "    if choice=='1':\n",
        "        print('Booking tickets')\n",
        "        while True:\n",
        "            info=pd.read_sql_query(\"Select * from ticket;\",con)\n",
        "            movieg=info.groupby('MovieID')\n",
        "            QID=int(input('Enter your Qatar ID number: '))\n",
        "            MID=input('Enter your movie ID: ')\n",
        "            while True:\n",
        "                try:\n",
        "                    moviedf=movieg.get_group(MID)\n",
        "                except KeyError:\n",
        "                    if MID=='E1493' or MID=='A3032' or MID=='E4523' or MID=='E5099' or MID=='A6041':\n",
        "                        BookedTickets=0\n",
        "                        print('We have 200 seats remaining')\n",
        "                        break\n",
        "                    else:\n",
        "                        print('Invalid movie ID')\n",
        "                        MID=input('Enter a valid movie ID: ')\n",
        "                        continue\n",
        "                else:\n",
        "                    BookedTickets=moviedf['NoOfTickets'].sum()\n",
        "                    if BookedTickets==200:\n",
        "                        print('No tickets available for',MID)\n",
        "                        print('We have 0 seats remaining')\n",
        "                        DiffBookQ=input('Do you want to make a booking for another movie?(y/n): ')\n",
        "                        if DiffBookQ=='y' or DiffBookQ=='yes' or DiffBookQ=='Yes' or DiffBookQ=='Y' or DiffBookQ=='YES':\n",
        "                            MID=input('Enter MovieID: ')\n",
        "                            continue\n",
        "                        else:\n",
        "                            break\n",
        "                    else:\n",
        "                        print('We have',200-BookedTickets,'seats remaining')\n",
        "                        break\n",
        "            if BookedTickets==200:\n",
        "                if DiffBookQ=='y' or DiffBookQ=='yes' or DiffBookQ=='Yes' or DiffBookQ=='Y' or DiffBookQ=='YES':\n",
        "                    pass\n",
        "                else:\n",
        "                    break\n",
        "            Name=input('Enter your name: ')\n",
        "            PhoneNo=int(input('Enter your Phone number: '))\n",
        "            NoOfTickets=int(input('Enter the number of tickets: '))\n",
        "            while True:\n",
        "                if BookedTickets+NoOfTickets>200:\n",
        "                    print('Exceeded total number of theatre seats')\n",
        "                    print('We only have',200-BookedTickets,'seats remaining')\n",
        "                    NoOfTickets=int(input('Enter a valid number of tickets: '))\n",
        "                elif NoOfTickets<1:\n",
        "                    print('Invalid number of tickets')\n",
        "                    NoOfTickets=int(input('Enter a valid number of tickets: '))\n",
        "                else:\n",
        "                    break\n",
        "            Shift=input('Enter the shift(Morning,Afternoon,Evening,Night): ')\n",
        "            Snacks=input('Enter preferred snacks(Popcorn,Nachos,Fries,Chips): ')\n",
        "            cursor.execute(\"Insert into ticket values({},'{}','{}',{},{},'{}','{}')\".format(QID,MID,Name,PhoneNo,NoOfTickets,Shift,Snacks))\n",
        "            con.commit()\n",
        "            if NoOfTickets>1:\n",
        "                print('Tickets booked')\n",
        "            else:\n",
        "                print('Ticket booked')\n",
        "            print()\n",
        "            BookAQ=input('Do you want to make another booking?(y/n): ')\n",
        "            if BookAQ=='y' or BookAQ=='yes' or BookAQ=='Yes' or BookAQ=='Y' or BookAQ=='YES':\n",
        "                print()\n",
        "                continue\n",
        "            else:\n",
        "                break\n",
        "\n",
        "    elif choice=='2':\n",
        "        print('Viewing Booking Details')\n",
        "        info=pd.read_sql_query(\"Select * from ticket;\",con)\n",
        "        group=info.groupby(['QatarID','MovieID'])\n",
        "        while True:\n",
        "            QID=int(input('Enter your Qatar ID number: '))\n",
        "            MID=input('Enter your movie ID: ')\n",
        "            Specific=group.get_group((QID,MID))\n",
        "            Specific.set_index('QatarID',inplace=True)\n",
        "            print('Name          : ',Specific.Name[QID])\n",
        "            print('Phone Number  : ',Specific.PhoneNo[QID])\n",
        "            print('No. of tickets: ',Specific.NoOfTickets[QID])\n",
        "            print('Shift         : ',Specific.Shift[QID])\n",
        "            print('Snacks        : ',Specific.Snacks[QID])\n",
        "            print()\n",
        "            ViewAQ=input('Do you want to view details of a different booking?(y/n): ')\n",
        "            if ViewAQ=='y' or ViewAQ=='yes' or ViewAQ=='Yes' or ViewAQ=='Y' or ViewAQ=='YES':\n",
        "                print()\n",
        "                continue\n",
        "            else:\n",
        "                break\n",
        "\n",
        "    elif choice=='3':\n",
        "        print('Editing Booking Details')\n",
        "        QID=int(input('Enter your Qatar ID number: '))\n",
        "        MID=input('Enter your movie ID: ')\n",
        "        info=pd.read_sql_query(\"Select * from ticket;\",con)        \n",
        "        movieg=info.groupby('MovieID')        \n",
        "        group=info.groupby(['QatarID','MovieID'])\n",
        "        Specific=group.get_group((QID,MID))\n",
        "        Specific.set_index('QatarID',inplace=True)\n",
        "        print('1)Name          : ',Specific.Name[QID])\n",
        "        print('2)Phone Number  : ',Specific.PhoneNo[QID])\n",
        "        print('3)No. of tickets: ',Specific.NoOfTickets[QID])\n",
        "        print('4)Shift         : ',Specific.Shift[QID])\n",
        "        print('5)Snacks        : ',Specific.Snacks[QID])\n",
        "        while True:\n",
        "            Detail=input('Which detail do you want to edit?(1,2,3,4,5): ')\n",
        "            if Detail=='1':\n",
        "                col='Name'\n",
        "                DN='Name'\n",
        "            elif Detail=='2':\n",
        "                col='PhoneNo'\n",
        "                DN='Phone number'\n",
        "            elif Detail=='3':\n",
        "                col='NoOfTickets'\n",
        "                DN='Number of tickets'\n",
        "            elif Detail=='4':\n",
        "                col='Shift'\n",
        "                DN='Shift(Morning,Afternoon,Evening,Night)'\n",
        "            elif Detail=='5':\n",
        "                col='Snacks'\n",
        "                DN='Snacks(Popcorn,Nachos,Fries,Chips)'\n",
        "            else:\n",
        "                print('Invalid Option')\n",
        "                continue\n",
        "            if Detail=='1' or Detail=='4' or Detail=='5':\n",
        "                Change=input('Enter new value for '+DN+': ')\n",
        "                cursor.execute(\"Update ticket set \"+col+\"='{}' where QatarID={} and MovieID='{}'\".format(Change,QID,MID))\n",
        "            elif Detail=='2':\n",
        "                Change=int(input('Enter new value for '+DN+': '))\n",
        "                cursor.execute(\"Update ticket set \"+col+\"={} where QatarID={} and MovieID='{}'\".format(Change,QID,MID))\n",
        "            elif Detail=='3':\n",
        "                moviedf=movieg.get_group(MID)\n",
        "                BookedTickets=moviedf['NoOfTickets'].sum()-Specific.NoOfTickets[QID]\n",
        "                print('We have',200-BookedTickets,'seats remaining')\n",
        "                Change=int(input('Enter new value for '+DN+': '))\n",
        "                while True:\n",
        "                    if BookedTickets+Change>200:\n",
        "                        print('Exceeded total number of theatre seats')\n",
        "                        print('We only have',200-BookedTickets,'seats remaining')\n",
        "                        Change=int(input('Enter a valid number of tickets: '))\n",
        "                    elif Change<1:\n",
        "                        print('Invalid number of tickets')\n",
        "                        Change=int(input('Enter a valid number of tickets: '))\n",
        "                    else:\n",
        "                        break\n",
        "                cursor.execute(\"Update ticket set \"+col+\"={} where QatarID={} and MovieID='{}'\".format(Change,QID,MID))\n",
        "            else:\n",
        "                pass\n",
        "            con.commit()\n",
        "            print('Updated details:')\n",
        "            info=pd.read_sql_query(\"Select * from ticket;\",con)\n",
        "            group=info.groupby(['QatarID','MovieID'])\n",
        "            Specific=group.get_group((QID,MID))\n",
        "            Specific.set_index('QatarID',inplace=True)\n",
        "            print('1)Name         : ',Specific.Name[QID])\n",
        "            print('2)Phone Number : ',Specific.PhoneNo[QID])\n",
        "            print('3)Total tickets: ',Specific.NoOfTickets[QID])\n",
        "            print('4)Shift        : ',Specific.Shift[QID])\n",
        "            print('5)Snacks       : ',Specific.Snacks[QID])\n",
        "            print()\n",
        "            EditAQ=input('Do you want to edit another detail?(y/n): ')\n",
        "            if EditAQ=='y' or EditAQ=='yes' or EditAQ=='Yes' or EditAQ=='Y' or EditAQ=='YES':\n",
        "                print()\n",
        "                continue\n",
        "            else:\n",
        "                break\n",
        "\n",
        "    elif choice=='4':\n",
        "        print('Cancelling Booking')\n",
        "        while True:\n",
        "            QID=int(input('Enter your Qatar ID number: '))\n",
        "            MID=input('Enter your movie ID: ')\n",
        "            info=pd.read_sql_query(\"Select * from ticket;\",con)\n",
        "            group=info.groupby(['QatarID','MovieID'])\n",
        "            Specific=group.get_group((QID,MID))\n",
        "            Specific.set_index('QatarID',inplace=True)\n",
        "            print('Name         : ',Specific.Name[QID])\n",
        "            print('Phone Number : ',Specific.PhoneNo[QID])\n",
        "            print('Total tickets: ',Specific.NoOfTickets[QID])\n",
        "            print('Shift        : ',Specific.Shift[QID])\n",
        "            print('Snacks       : ',Specific.Snacks[QID])\n",
        "            CancelQ=input('Are you sure you want to cancel the above booking?(y/n): ')\n",
        "            if CancelQ=='y'or CancelQ=='Y' or CancelQ=='Yes' or CancelQ=='yes' or CancelQ=='YES':\n",
        "                cursor.execute(\"Delete from ticket where QatarID={} and MovieID='{}'\".format(QID,MID))\n",
        "                con.commit()\n",
        "                print('Booking Cancelled')\n",
        "            else:\n",
        "                pass\n",
        "            print()\n",
        "            CAQ=input('Do you want to cancel another booking?(y/n): ')\n",
        "            if CAQ=='y'or CAQ=='Y' or CAQ=='Yes' or CAQ=='yes' or CAQ=='YES':\n",
        "                print()\n",
        "                continue\n",
        "            else:\n",
        "                break\n",
        "\n",
        "    elif choice=='5':\n",
        "        print('Popularity')\n",
        "        info=pd.read_sql_query(\"Select * from ticket;\",con)\n",
        "        while True:\n",
        "            print('''1)Popularity of Snacks\n",
        "2)Popularity of Movies\n",
        "3)Rush Hours''')\n",
        "            Pop=input('Which option do you want to see?(1,2,3): ')\n",
        "            if Pop=='1':\n",
        "                g=info.groupby('Snacks')\n",
        "                Size=g.size()\n",
        "                spie=plt.pie(g['NoOfTickets'].sum(),labels=Size.index,autopct='%0.2f%%')\n",
        "                plt.title('Popularity of Snacks')\n",
        "                plt.show()\n",
        "            elif Pop=='2':\n",
        "                g=info.groupby('MovieID')\n",
        "                Size=g.size()\n",
        "                mpie=plt.pie(g['NoOfTickets'].sum(),labels=Size.index,autopct='%0.2f%%')\n",
        "                plt.title('Popularity of Movies')\n",
        "                plt.show()\n",
        "            elif Pop=='3':\n",
        "                g=info.groupby('Shift')\n",
        "                Size=g.size()\n",
        "                xaxis=Size.index\n",
        "                yaxis=g['NoOfTickets'].sum()\n",
        "                rbar=plt.bar(xaxis,yaxis)\n",
        "                plt.xlabel('Shift')\n",
        "                plt.ylabel('No of People')\n",
        "                plt.title('Rush Hours')\n",
        "                plt.show()\n",
        "            else:\n",
        "                print('Invalid option')\n",
        "            GAgainQ=input('Do you want to see another popularity option?(y/n): ')\n",
        "            if GAgainQ=='y'or GAgainQ=='Y' or GAgainQ=='Yes' or GAgainQ=='yes' or GAgainQ=='YES':\n",
        "                continue\n",
        "            else:\n",
        "                break\n",
        "\n",
        "    else:\n",
        "        print('Invalid Option')\n",
        "    print()\n",
        "    OverallAQ=input('Do you want to select another option?(y/n): ')\n",
        "    if OverallAQ=='y'or OverallAQ=='Y' or OverallAQ=='Yes' or OverallAQ=='yes' or OverallAQ=='YES':\n",
        "        print()\n",
        "        continue\n",
        "    else:\n",
        "        break\n",
        "   \n",
        "con.close()"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Welcome to Elite Tickets.\n"
          ]
        },
        {
          "output_type": "error",
          "ename": "ModuleNotFoundError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mModuleNotFoundError\u001b[0m                       Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-1-80d3449999b8>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'Welcome to Elite Tickets.'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 6\u001b[0;31m \u001b[0;32mimport\u001b[0m \u001b[0mmysql\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mconnector\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0msqltr\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      7\u001b[0m \u001b[0;31m#Please change the MySQL password\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      8\u001b[0m \u001b[0mcon\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0msqltr\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mconnect\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mhost\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'localhost'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0muser\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'root'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mpassword\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'soumya126'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mdatabase\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'project'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mModuleNotFoundError\u001b[0m: No module named 'mysql'",
            "",
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0;32m\nNOTE: If your import is failing due to a missing package, you can\nmanually install dependencies using either !pip or !apt.\n\nTo view examples of installing some common dependencies, click the\n\"Open Examples\" button below.\n\u001b[0;31m---------------------------------------------------------------------------\u001b[0m\n"
          ],
          "errorDetails": {
            "actions": [
              {
                "action": "open_url",
                "actionText": "Open Examples",
                "url": "/notebooks/snippets/importing_libraries.ipynb"
              }
            ]
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Q2Zrjb7ldJni",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "0b8bf86b-5b0c-4871-d1e3-ae08740f1d5c"
      },
      "source": [],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Requirement already satisfied: mysql-connector in /usr/local/lib/python3.7/dist-packages (2.2.9)\n"
          ],
          "name": "stdout"
        }
      ]
    }
  ]
}