Skip to content

A simple RESTful API created using Flask and SQLAlchemy that interacts with a PostgreSQL database of Doctors and Reviews

License

Notifications You must be signed in to change notification settings

mgreenw/flask-restapi-example

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

31 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

A RESTful API in Flask using SQLAlchemy

The idea: A simple RESTful API created using Flask and SQLAlchemy that interacts with a PostgreSQL database of doctors and reviews.

Python Version Used: Python 3.6.0

Installation:

  1. Ensure the python3 version is 3.6.0. To check, run python3 -V. If you do not have it, you can install it here
  2. Clone the Github repo: $ git clone git@github.com:mgreenw/flask-restapi-example.git
  3. Move into the project directory $ cd flask-restapi-example
  4. Setup a virtual environment in the project folder using python3: $ python3 -m venv /path/to/project-parent-folder/flask-restapi-example/venv
  5. Start the virtual environment. You should see (venv) in as part of the command prompt once it is started: $ source /path/to/project-parent-folder/flask-restapi-example/venv/bin/activate NOTE: To stop the virtual environment at any time, run (venv) $ deactivate
  6. Install all the requirements, including flask. Be sure not to use sudo as this will install flask in the global environment instead of the virtual environment: (venv) $ pip3 install -r requirements.txt
  7. In a separate terminal window, install PostgreSQL. To do this, either install PostgreSQL.app or use HomeBrew for MacOS: $ brew install postgresql
  8. If using Homebrew, start PostgreSQL: $ postgres -D /usr/local/var/postgres
  9. In a separate terminal window, run $ psql. Then, create a database called doctor_reviews by running # CREATE DATABASE doctor_reviews;
  10. Finally, run # \q to quit psql, and back in the original terminal window run (venv) $ python3 setup.py to initialize the database tables.

To Run:

  1. Set an export path for flask: (venv) $ export FLASK_APP=app.py
  2. Run flask! (venv) $ flask run
  3. Go to http://127.0.0.1:5000 in a browser

API Documentation

Show Doctor

Returns json data about a single doctor.

  • URL

    /api/v1/doctors/:id

  • Method:

    GET

  • URL Params

    Required:

    id=[integer]

  • Data Params

    None

  • Success Response:

    • Code: 200
      Content: {"id": 1, "name": "Max Greenwald", "reviews": []}
  • Error Response:

    • Code: 404 NOT FOUND
      Content: {"error": "Doctor does not exist"}

Create Doctor

Creates Doctor and returns json data about that doctor

  • URL

    /api/v1/doctors

  • Method:

    POST

  • URL Params

    None

  • Data Params

    Required:

    name=[string]

  • Success Response:

    • Code: 201
      Content: {"doctor": {"id": 1, "name": "Max Greenwald", "reviews": []}}
  • Error Response:

    • Code: 400 BAD REQUEST
      Content: {"error": "Missing required data."}

Show Review

Returns json data about a single review.

  • URL

    /api/v1/reviews/:id

  • Method:

    GET

  • URL Params

    Required:

    id=[integer]

  • Data Params

    None

  • Success Response:

    • Code: 200
      Content: { "description": "He's not a doctor exactly...", "doctor": { "id": 1, "name": "Max Greenwald" }, "doctor_id": 1, "id": 1 }
  • Error Response:

    • Code: 404 NOT FOUND
      Content: {"error": "Review does not exist."}

Create Review

Creates a Review and returns json data about that Review

  • URL

    /api/v1/reviews

  • Method:

    POST

  • URL Params

    None

  • Data Params

    Required:

    description=[text] doctor_id=[int]

  • Success Response:

    • Code: 201
      Content: { "review": { "description": "He's not a doctor exactly...", "doctor_id": 1, "id": 1 } }
  • Error Response:

    • Code: 400 BAD REQUEST
      Content: {"error": "Missing required data."}

      OR

    • Code: 400 UNAUTHORIZED
      Content: { error : "Given doctor_id does not exist." }

About

A simple RESTful API created using Flask and SQLAlchemy that interacts with a PostgreSQL database of Doctors and Reviews

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages