Building RESTful APIs with Flask in PyCharm

 Installing packages

Once your virtualenv is ready, click the “Install” button to begin installing packages. We’ll be installing three packages for our project:

1. Flask (install either by pycharms STTINGS-----PYTHON INTERPRETOR (+))
2. Flask-Restless (for building the RESTful API)
3. Flask-SQLAlchemy (for connecting to our database) || OR MySQLdb

In Pycharms (Main.py):write below code here change parameters as per your database:

import flask 
from flask import Flask, json, request, jsonify
from flask_mysqldb import MySQL, MySQLdb  # pip install flask-mysqldb https://github.com/alexferl/flask-mysqldb

app = Flask(__name__)

app.secret_key = "2021"

app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = ''
app.config['MYSQL_DB'] = 'entry_system'
app.config['MYSQL_CURSORCLASS'] = 'DictCursor'
mysql = MySQL(app)


@app.route('/')
def index():
    cur = mysql.connection.cursor(MySQLdb.cursors.DictCursor)
    cur.execute("SELECT * FROM visit_mas")
    rv = cur.fetchall()
    employee = []
    content = {}
    for result in rv:
        content = {'pass_no': result['pass_no'], 'mobile_no': result['mobile_no'],
                   'visit_purpose': result['visit_purpose']}
        employee.append(content)
        content = {}
    return jsonify(employee)


if __name__ == "__main__":
    app.run(debug=True)

Then Run Pycharms

CONSOLE WILL SHOW IN PYCHARMS S:

C:\Users\RCF\PycharmProjects\pythonProject\venv\Scripts\python.exe "C:\Program Files\JetBrains\PyCharm Community Edition 2020.3.2\plugins\python-ce\helpers\pydev\pydevd.py" --multiproc --qt-support=auto --client 127.0.0.1 --port 65023 --file C:/Users/RCF/PycharmProjects/pythonProject/main.py
Connected to pydev debugger (build 203.6682.179)
 * Serving Flask app "main" (lazy loading)
 * Environment: production
   WARNING: This is a development server. Do not use it in a production deployment.
   Use a production WSGI server instead.
 * Debug mode: on
 * Restarting with stat
 * Debugger is active!
 * Debugger PIN: 239-188-691
 * Running on http://127.0.0.1:5000/ (Press CTRL+C to quit)

OPEN  IN BROWSER : http://127.0.0.1:5000/:::::

[
  {
    "mobile_no": "213223421", 
    "pass_no": 124, 
    "visit_purpose": "test"
  }
]


REMARKS: 
1.use Double Underscope else will give name error in

__name__ == "__main__":

2.choose project Directory as | Sources Root: