class Student(db.Model): __tablename__ = 'Student' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50), nullable= False) physics = db.Column(db.Integer) maths = db.Column(db.Integer) chemistry = db.Column(db.Integer) def __init__(self,name,physics,maths,chemistry): self.name = name self.physics = physics self.maths = maths self.chemistry = chemistry def get_id(self): return str(self.id) def get_name(self): return str(self.name) def get_physics(self): return int(self.physics) def get_maths(self): return int(self.maths) def get_chemistry(self): return int(self.chemistry) def __repr__(self): return "Student('{self.id}', '{self.name}',{self.physics}',{self.maths}',{self.chemistry}')"
class Student(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50), nullable=False) physics = db.Column(db.Integer) maths = db.Column(db.Integer) chemistry = db.Column(db.Integer) def __repr__(self): return f"Student('{self.id}', '{self.name}',{self.physics}',{self.maths}',{self.chemistry}')"
class Users(db.Model): __tablename__ = 'Users' id = db.Column(db.Integer, primary_key=True, autoincrement=True) email = db.Column(db.String, unique=True, nullable=False) hashed_password = db.Column(db.Binary(60), nullable=False) authenticated = db.Column(db.Boolean, default=False) registered_on = db.Column(db.DateTime, nullable=True) role = db.Column(db.String, default='user') def __init__(self, email, plaintext_password, role='user'): self.email = email self.hashed_password = bcrypt.generate_password_hash(plaintext_password) self.authenticated = False self.registered_on = datetime.now() self.role = role def set_password(self, plaintext_password): self.hashed_password = bcrypt.generate_password_hash(plaintext_password) def is_correct_password(self, plaintext_password): return bcrypt.check_password_hash(self.hashed_password, plaintext_password) @property def is_authenticated(self): """Return True if the user is authenticated.""" return self.authenticated @property def is_active(self): """Always True, as all users are active.""" return True @property def is_anonymous(self): """Always False, as anonymous users aren't supported.""" return False def get_id(self): """Return the id of a user to satisfy Flask-Login's requirements.""" return str(self.id) def __repr__(self): return '<Users {}>'.format(self.email)