class Favorite(db.Model):
__tablename__ = 'favories'
id = db.Column(db.Integer, primary_key=True)
jobseeker_id = db.Column(db.Integer, db.ForeignKey('job_seekers.id'))
offer_id = db.Column(db.Integer, db.ForeignKey('offers.id'))
jobseeker = db.relationship('JobSeeker', back_populates='favories')
offer = db.relationship('Offer', back_populates='favories')
class Offer(db.Model):
__tablename__ = 'offers'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), nullable=False)
description = db.Column(db.Text(), nullable=False)
date_posted = db.Column(db.Date(),
nullable=False,
default=datetime.date.today())
enterprise_id = db.Column(db.Integer, db.ForeignKey('enterprises.id'))
enterprise = db.relationship('Enterprise', back_populates='offers')
jobseekers = db.relationship('JobSeeker',
secondary=offer_job_seeker,
lazy='subquery',
backref=db.backref('offers', lazy=True))
favories = db.relationship('Favorite', back_populates='offer')
def __repr__(self):
return f'Offer {self.id} -- {self.name}'
def ollow(self):
user_id = session.get('user_id')
if not user_id:
return False
jobseeker = User.query.get(user_id).jobseeker
if not jobseeker:
return False
return jobseeker not in self.jobseekers
def has_already_apply(self, j):
acc = Accepted.query.filter_by(offer=self, jobseeker=j).first()
if acc:
return True
return False
def toJson(self):
jobseekers = self.jobseekers
if not jobseekers:
jobseekers = []
count = len(jobseekers)
js = []
for j in jobseekers:
j.apply = self.has_already_apply(j)
js.append(j.toJson())
return {
'id': self.id,
'name': self.name,
'description': self.description,
'date_posted': self.date_posted.strftime('%d/%m/%Y'),
'enterprise': self.enterprise.name,
'apply': count,
'ollow': self.ollow(),
'jobseekers': js
}
class Accepted(db.Model):
id = db.Column(db.Integer, primary_key=True)
jobseeker_id = db.Column(db.Integer, db.ForeignKey('job_seekers.id'))
offer_id = db.Column(db.Integer, db.ForeignKey('offers.id'))
jobseeker = db.relationship('JobSeeker', uselist=False)
offer = db.relationship('Offer', uselist=False)
@classmethod
def toArrayByJs(cls, js):
items = cls.query.filter_by(jobseeker=js).all()
accArray = []
for item in items:
accArray.append(item.offer.toJson())
return accArray
class Enterprise(db.Model):
__tablename__ = 'enterprises'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'))
user = db.relationship('User', back_populates='enterprise')
offers = db.relationship("Offer", back_populates="enterprise")
def __repr__(self):
return f'Enterpries {self.id} -- {self.name}'
def toJson(self):
offers = []
for offer in self.offers:
offers.append(offer.toJson())
return {'id': self.id, 'name': self.name, 'offers': offers}
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), nullable=False, unique=True)
email = db.Column(db.String(120), nullable=False, unique=True)
account_type = db.Column(db.Enum(AccountType),
default=AccountType.demandeur)
password = db.Column(db.String(60), nullable=False, unique=True)
enterprise = db.relationship('Enterprise',
back_populates='user',
uselist=False)
job_seeker = db.relationship('JobSeeker',
back_populates='user',
uselist=False)
def is_authenticated(self):
return self.id == session.get('user_id')
def is_enterprise_account(self):
if self.is_authenticated():
return self.account_type.value == 'entreprises'
else:
return
def is_jobseeker_account(self):
if self.is_authenticated():
return self.account_type.value == 'demandeur'
else:
return
def has_complete_profile(self):
return self.job_seeker != None
def __repr__(self):
return f'User {self.id} -- {self.username}'
def toJson(self):
return {'id': self.id, 'username': self.username, 'email': self.email}
class JobSeeker(db.Model):
__tablename__ = 'job_seekers'
apply = None
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(20), nullable=False)
last_name = db.Column(db.String(20), nullable=False)
cv = db.Column(db.Text(), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'))
user = db.relationship('User',
backref=db.backref('jobseeker', uselist=False))
favories = db.relationship('Favorite', back_populates='jobseeker')
def __repr__(self):
return f'Job Seeker {self.id} -- {self.first_name} {self.last_name}'
def toJson(self):
return {
'id': self.id,
'first_name': self.first_name,
'last_name': self.last_name,
'cv': self.cv,
'apply': self.apply
}
offers = db.relationship("Offer", back_populates="enterprise")
def __repr__(self):
return f'Enterpries {self.id} -- {self.name}'
def toJson(self):
offers = []
for offer in self.offers:
offers.append(offer.toJson())
return {'id': self.id, 'name': self.name, 'offers': offers}
offer_job_seeker = db.Table(
'tags',
db.Column('offer_id',
db.Integer,
db.ForeignKey('offers.id'),
primary_key=True),
db.Column('jobseeker_id',
db.Integer,
db.ForeignKey('job_seekers.id'),
primary_key=True))
class Offer(db.Model):
__tablename__ = 'offers'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), nullable=False)
description = db.Column(db.Text(), nullable=False)
date_posted = db.Column(db.Date(),
nullable=False,
default=datetime.date.today())