1. Modify the application/database/ini.py ( in the screenshot below) to add an address field.
2. Run the command to make a migration: flask db migrate -m "added address field"
3. Run the command to apply the migration: flask db upgrade

 

""
Database Initialization and Models
"""
from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()


class User(db.Model):
    """User Model"""
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(128))
    password = db.Column(db.String(128))
    email = db.Column(db.String(128))
    phone = db.Column(db.String(128))

    @classmethod
    def all(cls):
        return cls.query.all()

    @classmethod
    def find_user_by_email(cls, email):
        return cls.query.filter(cls.email == email).first()

    @classmethod
    def find_user_by_id(cls, user_id):
        return cls.query.filter(cls.id == user_id).first()

    @classmethod
    def record_count(cls):
        return cls.query.count()
 

 

Transcribed Image Text:

J from flask_sqlalchemy import SQLAlchemy db = SQLAlchemy ( ) github-classroom [bot] class User(db.Model): """User Model """ id = db.Column(db.Integer, primary_key=True) name = db.Column (db.String(128)) password = db.Column (db.String(128)) email = db.Column(db.String(128)) phone db.Column(db.String (128)) github-classroom[bot] @classmethod def all(cls): return cls.query.all() github-classroom[bot] @classmethod def find_user_by_email(cls, email): return cls.query.filter(cls.email == email).first() github-classroom [bot] @classmethod def find_user_by_id(cls, user_id): return cls.query.filter(cls.id github-classroom [bot] @classmethod def record_count(cls): return cls.query.count() == user_id).first() J from flask_sqlalchemy import SQLAlchemy db = SQLAlchemy ( ) github-classroom [bot] class User(db.Model): """User Model """ id = db.Column(db.Integer, primary_key=True) name = db.Column (db.String(128)) password = db.Column (db.String(128)) email = db.Column(db.String(128)) phone db.Column(db.String (128)) github-classroom[bot] @classmethod def all(cls): return cls.query.all() github-classroom[bot] @classmethod def find_user_by_email(cls, email): return cls.query.filter(cls.email == email).first() github-classroom [bot] @classmethod def find_user_by_id(cls, user_id): return cls.query.filter(cls.id github-classroom [bot] @classmethod def record_count(cls): return cls.query.count() == user_id).first()