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)
