好吧，我想您想念电影中的角色关系了+插入内容并非完全正确。
还有一些细节，您必须要小心。为什么电影的id是movieS_id，字符的id是character_id？
另外，如果未指定，则列名与变量名相同。
例如，您可以这样做：
character_description = db.Column(db.Text())
无论如何，在不更改此详细信息的情况下，您可以尝试以下操作：
class Movie(db.Model): __tablename__ = "movies" id = db.Column('movies_id', db.Integer, primary_key=True) movie_type = db.Column('movie_type', db.Text()) characters = db.relationship("Character", backref="movie", lazy='dynamic') def __init__(self, movie_type): self.movie_type = movie_type def __repr__(self): return '<Movie %r>' % self.idclass Character(db.Model): __tablename__ = "characters" id = db.Column('character_id', db.Integer, primary_key=True) character_description = db.Column('character_description', db.Text()) movie_id = db.Column(db.Integer, db.ForeignKey('movies.movies_id')) movie = db.relationship('Movie') def __init__(self, character_description, movie): self.character_description = character_description self.movie = movie def __repr__(self): return '<Character %r>' % self.id插入
c = Character(character_description='c')c2 = Character(character_description='c2')m = Movie(movie_type ='action')# link characters to moviem.characters.append(c)m.characters.append(c2)# orm.characters.extend([c,c2])db.session.add(m)# add charactersdb.session.add(c)db.session.add(c2)# ordb.session.add_all([c,c2])# commitdb.session.commit()
