Question 26: Consider the following flask_sqlalchemy data models “Use…

1class User(db.Model):
2    id = db.Column(db.Integer, primary_key=True)
3    username= db.Column(db.String(), unique=True, nullable=False)
4    password = db.Column(db.String(), nullable=False)
5    email= db.Column(db.String())
6    roles= db.relationship("Role", backref="bearer")
7
8class Role(db.Model):
9    id = db.Column(db.Integer, primary_key=True)
10    r_name = db.Column(db.String(), unique=True, nullable=False)
11    user = db.Column(db.Integer, db.ForeignKey("user.id"))

1>>> from app import *
2>>> db.create_all()
3>>> user1 = User(username="Rakesh",password="1234",email="user1@gmail.com")
4>>> user2 = User(username="Suresh",password="123",email="user2@gmail.com")
5>>> db.session.add_all([user1,user2])
6>>> db.session.commit()
7>>> r1=Role(r_name="instructor",user=1)
8>>> r2=Role(r_name="admin",user=1)
9>>> r3=Role(r_name="ops",user=2)
10>>> r4=Role(r_name="student",user=2)
11>>> db.session.add_all([r1,r2,r3,r4])
12>>> db.session.commit()
13>>> users = User.query.all()
14>>> roles = Role.query.all()