Many to many flask-sqlalchemy

association_table = db.Table('association', db.Model.metadata,
    db.Column('left_id', db.Integer, db.ForeignKey('left.id')),
    db.Column('right_id', db.Integer, db.ForeignKey('right.id'))
)

class Parent(db.Model):
    __tablename__ = 'left'
    id = db.Column(db.Integer, primary_key=True)
    children = db.relationship("Child",
                    secondary=association_table)

class Child(db.Model):
    __tablename__ = 'right'
    id = db.Column(db.Integer, primary_key=True)


p = Parent()
c = Child()
p.children.append(c)
db.session.add(p)
db.session.commit()

Source: stackoverflow.com

Many to many flask-sqlalchemy

student_identifier = db.Table('student_identifier',
    db.Column('class_id', db.Integer, db.ForeignKey('classes.class_id')),
    db.Column('user_id', db.Integer, db.ForeignKey('students.user_id'))
)

class Student(db.Model):
    __tablename__ = 'students'
    user_id = db.Column(db.Integer, primary_key=True)
    user_fistName = db.Column(db.String(64))
    user_lastName = db.Column(db.String(64))
    user_email = db.Column(db.String(128), unique=True)


class Class(db.Model):
    __tablename__ = 'classes'
    class_id = db.Column(db.Integer, primary_key=True)
    class_name = db.Column(db.String(128), unique=True)
    students = db.relationship("Student",
                               secondary=student_identifier)

s = Student()
c = Class()
c.students.append(s)
db.session.add(c)
db.session.commit()

Source: stackoverflow.com

Similar codes

0 vote225 views1 answer
Mysql utc timestamp
SQL
0 vote228 views1 answer
Contact mysql column field
SQL
2 votes233 views1 answer
Columns Present in a table
SQL
15 votes234 views6 answers
Drop foreign key mysql
SQL
0 vote242 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
51 votes291 views6 answers
Change column name sql
SQL
0 vote223 views1 answer
Syntax for changing column size in mysql
SQL
2 votes232 views1 answer
Can you use a where clause for a child query
SQL
0 vote213 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote250 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL