def delete_employer_by_id(id_): try: trans = Transaction() n = trans.query(Employer).filter(Employer.id == id_).delete() trans.commit() return ('ok', '', n) except Exception as e: return ('err', e.__class__.__name__, 0)
def update_employer(id_, req): try: trans = Transaction() n = trans.query(Employer).filter(Employer.id == id_).update(req) trans.commit() return ('ok', '', n) except IntegrityError as e: return ('err', e.__class__.__name__, 0) except Exception as e: return ('err', e.__class__.__name__, 0)
def create_employer(req): try: trans = Transaction() employer = Employer(**req) trans.add(employer) trans.commit() return ('ok', '', employer.id) except IntegrityError as e: return ('err', e.__class__.__name__, None) except Exception as e: return ('err', e.__class__.__name__, None)