인프런 커뮤니티 질문&답변

안녕하세요.

강사님 내용대로 하면 계속 경고문구가 나오는데요.

이걸 변경해줘야 할 지요..

(경고문구)

Role.query.all()

back_populates 로 바꿔주면 경고는 사라집니다.

from flask_sqlalchemy import SQLAlchemy
from flask import Flask


app = Flask(__name__)
app.app_context().push()

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////ryujaean/study/flask_sqlalchemy/form_webapp/form_db'

db = SQLAlchemy(app)


# Role, Membr, Project

class Role(db.Model):
    id = db.Column(db.Integer, primary_key = True)
    position = db.Column(db.String(50))
    members = db.relationship('Member', backref='role', lazy = 'dynamic')

class Member(db.Model):
    id = db.Column(db.Integer, primary_key = True)
    name = db.Column(db.String(100))
    role_id = db.Column(db.Integer, db.ForeignKey('role.id'))
    # projects = db.relationship('Project', secondary='member_project', backref='member', lazy='dynamic')
    projects = db.relationship('Project', secondary='member_project', back_populates='members', lazy='dynamic')
    

class Project(db.Model):
    id = db.Column(db.Integer, primary_key = True)
    name = db.Column(db.String(100))
    # members = db.relationship('Member', secondary='member_project', backref='project', lazy='dynamic')
    members = db.relationship('Member', secondary='member_project', back_populates='projects', lazy='dynamic')
    

db.Table('member_project',
    db.Column('member_id',db.Integer, db.ForeignKey('member.id')),
    db.Column('project_id',db.Integer, db.ForeignKey('project.id'))
    )