class UserSkillRatingDA(Base):
__tablename__ = 'skill_rating'
skill_rating_id = Column(Integer, primary_key=True)
skill_id_one = Column(Integer)
skill_id_two = Column(Integer)
rating = Column(DECIMAL(10, 10))
user_id = Column(Integer)
def __init__(self):
self.db = DbConnection()
self.session = self.db.connect()
def getAll(self):
results = self.session.query(UserSkillRatingDA)
return results
def getAllForUser(self, id):
results = self.session.query(UserSkillRatingDA).filter(
UserSkillRatingDA.user_id == id).order_by(
UserSkillRatingDA.skill_id_one, UserSkillRatingDA.skill_id_two)
return results
def getByID(self, id):
results = self.session.query(UserSkillRatingDA).filter(
UserSkillRatingDA.skill_rating_id == id).one()
return results
class UserDA(Base):
__tablename__ = 'user'
user_id = Column(Integer, primary_key=True)
first_name = Column(String(20))
last_name = Column(String(20))
def __repr__(self):
return "{'user_id':'%s', 'first_name': '%s', 'last_name': '%s'}" % (
self.user_id, self.first_name.decode("utf-8"),
self.last_name.decode("utf-8"))
def __init__(self):
self.db = DbConnection()
self.session = self.db.connect()
def GetAll(self):
# SELECT * FROM user
results = self.session.query(UserDA).all()
return results
def GetByID(self, id):
# SELECT * FROM user WHERE id =
results = self.session.query(UserDA).filter(UserDA.user_id == id).all()
return results
class JobDA(Base):
__tablename__ = 'job_post'
job_id = Column(Integer, primary_key=True)
job_title = Column(String)
job_description = Column(String)
def __repr__(self):
return "{Job(job_title=='%s', job_description='%s')}" % (
self.job_title.decode("utf-8"),
self.job_description.decode("utf-8"))
def __init__(self):
self.db = DbConnection()
self.session = self.db.connect()
def GetAll(self):
# SELECT * FROM job_post
results = self.session.query(JobDA).all()
return results
def GetByID(self, id):
# SELECT * FROM Job_postWHERE id =
results = self.session.query(JobDA).filter(JobDA.job_id == id).all()
return results
def __init__(self, user_id=0, job_id=0, score=0):
JobMatchDA.db = DbConnection()
JobMatchDA.session = JobMatchDA.db.connect()
if user_id != 0:
self.user_id = user_id
self.job_id = job_id
self.score = score
def __init__(self):
UserSkillDA.db = DbConnection()
UserSkillDA.session = UserSkillDA.db.connect()
def __init__(self):
self.db = DbConnection()
self.session = self.db.connect()
def __init__(self):
JobSkillDA.db = DbConnection()
JobSkillDA.session = JobSkillDA.db.connect()
def __init__(self):
SkillDA.db = DbConnection()
SkillDA.session = SkillDA.db.connect()