class GroupModel(db.Model):
__tablename__ = 'GroupModel'
id = db.Column(db.Integer, primary_key=True)
groupname = db.Column(db.String(32), nullable=False)
Description = db.Column(db.String(120), nullable=False)
default_picture = db.Column(db.String(20), default='default.jpg')
users = db.relationship('User', backref='member', lazy=True)
def __repr__(self):
return f"('{self.id}', '{self.groupname}', '{self.Description}', '{self.default_picture}','{self.users}')"
class Group(db.Model):
groupid = db.Column(db.Integer, primary_key=True)
groupname = db.Column(db.String(32), nullable=False)
def __repr__(self):
return f"('{self.fullname}', '{self.email}', '{self.Username}')"
#It is not linked with the server yet.
class User(db.Model, UserMixin):
__tablename__ = 'User'
id = db.Column(db.Integer, primary_key=True)
FullName = db.Column(db.String(40), nullable=False)
EMAIL = db.Column(db.String(120), unique=True, nullable=False)
profile_pic = db.Column(db.String(20),
nullable=False,
default='default_pic.png')
Username = db.Column(db.String(40), unique=True, nullable=False)
Password = db.Column(db.String(64), nullable=False)
#group = db.relationship('GroupModel', backref='member', lazy=True)
group_id = db.Column(db.Integer,
db.ForeignKey('GroupModel.id'),
nullable=True)
event_id = db.Column(db.Integer,
db.ForeignKey('EventModel.id'),
nullable=True)
def __repr__(self):
return f"('{self.id}','{self.FullName}', '{self.EMAIL}', '{self.Username}','{self.profile_pic}','{self.Password}','{self.group_id}', {self.event_id})"
class EventModel(db.Model):
__tablename__ = 'EventModel'
id = db.Column(db.Integer, primary_key=True)
EventName = db.Column(db.String(64), nullable=False)
Description = db.Column(db.String, nullable=False)
Date = db.Column(db.DateTime, nullable=False)
startTime = db.Column(db.DateTime, nullable=False)
endTime = db.Column(db.DateTime, nullable=False)
users = db.relationship('User', backref='author', lazy=True)
def __repr__(self):
return f"('{self.id}', '{self.EventName}', '{self.Description}', '{self.Date}', '{self.startTime}', '{self.endTime}')"
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
fullname = db.Column(db.String, nullable=False)
email = db.Column(db.String, unique=True, nullable=False)
Username = db.Column(db.String, unique=True, nullable=False)
password = db.Column(db.String(64), nullable=False)