oCEO-flask-webapp

• A flask webapp for performing INSERT, UPDATE, DELETE, RENAME, WHERE operations in oCEO database

Assignment-4: here

Firstly download latest python version, its packages and flask framework shown below :-

• Create a python virtual environment [Recommended]
  • Go to powershell(being in project directory) and follow the below steps :-

  1. Command: pip install virtualenv (enter)

  2. then type virtualenv env (enter)

     • Fig: a folder named "env" will be created[as shown]
       

  3. Now, we have to activate this python virtual environment using command: .\env\Scripts\activate.ps1 (press enter)

     • Fig: It will show something like this

  4. install python packages(flask, pyyaml, flask-mysqldb) using command: pip install flask pyyaml flask-mysqldb (enter)

  5. Finally type command to run the flask-webapp: python .\app.py (press enter)

     • Fig: Server got started[running on PORT shown]

If you are getting an error, like this!!!

• sometime while activating python virtual env. we get an error as shown

• to remove this, open windows powershell as admin and do as shown in Screenshot

Other way(if above steps not working) :-

• install Flask(python web framework) using the commands as shown :
  • py -m pip install flask
• Now, check their versions using command as shown :-
  • py -m flask --version
  • SS for the output :-
    
• Then install following pip packages :-
  • pip3 install flask-mysqldb
  • pip3 install pyyaml
    

Open the oCEO-flask-webApp

• command: python app.py (press enter)
• then in terminal we get the ouput as shown in screenshot below
  
• On clicking the default PORT(shown with arrow mark)[on clicking the link] : we will our app running and displays the homepage

Home Page view:-

• On clicking the IITGN-logo, we get 3 options as follows:-
  • Login As Student
  • Login As Professor
  • Login As Admin
• On clicking "Login As Student" we get the UI as shown :-
  • Login details of student(for registered student) i.e emailID and Password
• On clicking "Login As Professor" we get the UI as shown :-
• On clicking "Login As Admin" we get the UI as shown :-

In MySQL, created database named "oceo" and tables as shown :-

These are the following commnads used for creating tables :-

• Creating Student table

• Creating Professor table

• Creating total_jobs table

• Creating application table

• Creating ongoing_jobs table

• Creating concluded_jobs table

• Creating bank_details table

Working of all Operations shown below(with SS attached) :-

RENAME Operation :-

• Same rename operation working on MySQL Workbench :-
  • RENAME queries

SELECT with WHERE operation :-

• Professor login page
• Operation performed in MySQL workbench
• Updated date get reflected in table shown

UPDATE operation :-

• before update
• before update in schema
• updated data in schema
• Alert dialog box to confirm the update operation Dynamic execution in the frontEnd

DELETE operation :-

• Before delete operation
• Before delete in schema(i.e MySQL workbench)
• Alert Box for confirming deletion operation
• After delete operation from Schema(from MySQL workbench)
• deletion operation on table showing Dynamic Execution

INSERT operation (for student Registration):-

• These data of student will be stored in student table in oceo database
• Student will be prompted with "Student Login" page as shown below
• The updated data can be viewed from mySQL Workbench

Here are some of the dummy data used for testing our webApps shown below :-

If login details is wrong :-

About-Us page of oCEO database :-

## NavBar and Selection process in oCEO database :-

Assignment - 3 | Contribution details : https://docs.google.com/document/d/1BiXMFtXF_6aI8bDtQSFaYC893RRDsi20zemd4p5jOqY/edit?usp=sharing