Db.relationship sqlalchemy flask

class Person(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50), nullable=False)
    addresses = db.relationship('Address', backref='person', lazy=True)

class Address(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), nullable=False)
    person_id = db.Column(db.Integer, db.ForeignKey('person.id'),
        nullable=False)

Source: flask-sqlalchemy.palletsprojects.com

Similar codes

0 vote238 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote266 views1 answer
Sql select maximum column with other columns returned
SQL
-1 vote304 views1 answer
Round up and down sql
SQL
1 vote294 views1 answer
Copy postgres table from one schema into another
SQL
16 votes315 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes251 views4 answers
Mysql change database character set to utf8mb4
SQL
1 vote297 views1 answer
Select not matching data with join table
SQL
0 vote295 views1 answer
Oracle DROP PROGRAM
SQL
4 votes289 views4 answers
Update select mysql
SQL
4 votes293 views2 answers
How to insert ip address in mysql using php
SQL