Python Microservices Development

Model

In a Flask application based on SQLAlchemy, the model is described through classes, which represent the database schema.

For Runnerly, the database tables are:

• User: This contains info about each user, including their credentials
• Run: This is a list of runs with all the info extracted from Strava, and runs for a training plan
• Race: This is a list of races added by users, with date, location, and distance
• Plan: This is a training plan that is defined by a collection of runs to be done

Using the Flask-SQLAlchemy (http://flask-sqlalchemy.pocoo.org/) extension, you can specify the tables using the Model class as a base class. The following is the definition for the User table with the SQLAlchemy class:

 from flask_sqlalchemy import SQLAlchemy ...