class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) posts = db.relationship('Post', backref='author', lazy=True) def __repr__(self): return f"User('{self.username}', '{self.email}', '{self.image_file}')"
class User(db.Model, UserMixin): __table_args__ = {'extend_existing': True} id = db.Column(db.Integer, primary_key=True) fname = db.Column(db.String(20), unique=True, nullable=False) lname = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(50), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) posts = db.relationship('Post', backref='author', lazy=True) def __repr__(self): return f"User('{self.fname}', '{self.lname}', '{self.email}', '{self.image_file}')"
class User(db.Model, UserMixin): __tablename__ = 'users' __table_args__ = {'extend_existing': True} userID = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(25), unique=True, nullable=False) passwords = db.Column(db.String(70), nullable=False) roleID = db.Column(db.Integer, db.ForeignKey('role.roleID'), nullable=False) timeStamp = db.Column(db.DateTime, nullable=False) userinfo = db.relationship("UserInfo", backref='user', lazy=True) def get_id(self): return (self.userID)
class building(db.Model, UserMixin): __tablename__ = 'Building' __table_args__ = {'extend_existing': False} buildingID = db.Column(db.Integer, primary_key=True) buildingName = db.Column(db.String(200), nullable=False) buildingAddress = db.Column(db.String(200), nullable=False) postalCode = db.Column(db.Integer, nullable=False) numberOfrooms = db.Column(db.Integer, nullable=False) units=db.relationship('unit',backref='building') def get_id(self): return (self.buildingID) def __str__(self): return self.buildingName
class Role(db.Model, UserMixin): __tablename__ = 'role' __table_args__ = {'extend_existing': True} roleID = db.Column(db.Integer, primary_key=True, nullable=False) roleName = db.Column(db.String(25), nullable=False) user = db.relationship("User", backref='role', lazy=True)