def add_industry(self, industry: COIndustry): dbsession = None try: if not isinstance(industry, COIndustry): message = COMLIndustry.MSG_INDUSTRY_NOT_VALID + COStringLiteral.STR_SEPARATOR_PIPE + str( industry.identifier) self.get_logger().error(message) raise CFException(ValueError(message), message, status_code=CFException.HTTP_400_BAD_REQUEST) dbsession = DBConnection().getsession() dbsession.add(industry) dbsession.commit() self.get_logger().info( COMLIndustry.MSG_INDUSTRY_INSERT_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str( industry.identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLIndustry.MSG_INDUSTRY_INSERT_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( industry.identifier) self.get_logger().error(message) raise CFException(Exception(message), message) finally: dbsession.close()
def add_byonic_user(self, byonic_user: COByonicUser): dbsession = None try: if not isinstance(byonic_user, COByonicUser): message = COMLByonicUser.MSG_BYONIC_USER_NOT_VALID + COStringLiteral.STR_SEPARATOR_PIPE + str( byonic_user.identifier) self.get_logger().error(message) raise CFException(ValueError(message), message, status_code=CFException.HTTP_400_BAD_REQUEST) dbsession = DBConnection().getsession() byonic_user.password = hashlib.sha512(byonic_user.password.encode("utf-8")).hexdigest() dbsession.add(byonic_user) dbsession.commit() self.get_logger().info( COMLByonicUser.MSG_BYONIC_USER_INSERT_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str( byonic_user.identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLByonicUser.MSG_BYONIC_USER_INSERT_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( byonic_user.identifier) self.get_logger().error(message) raise CFException(Exception(message), message) finally: dbsession.close()
def add_revenue_range(self, revenue_range: CORevenue): dbsession = None try: if not isinstance(revenue_range, CORevenue): message = COMLRevenue.MSG_REVENUE_RANGE_NOT_VALID + COStringLiteral.STR_SEPARATOR_PIPE + str( revenue_range.identifier) self.get_logger().error(message) raise CFException(ValueError(message), message, status_code=CFException.HTTP_400_BAD_REQUEST) dbsession = DBConnection().getsession() dbsession.add(revenue_range) dbsession.commit() self.get_logger().info( COMLRevenue.MSG_REVENUE_RANGE_INSERT_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str(revenue_range.identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLRevenue.MSG_REVENUE_RANGE_INSERT_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( revenue_range.identifier) self.get_logger().error(message) raise CFException(Exception(message), message) finally: dbsession.close()
def update_intent_topics(self, intent_topics: COTopic): dbsession = None try: if not isinstance(intent_topics, COTopic): message = COMLTopic.MSG_TOPIC_NOT_VALID + COStringLiteral.STR_SEPARATOR_PIPE + str( intent_topics.identifier) self.get_logger().error(message) raise CFException(ValueError(message), message, status_code=CFException.HTTP_400_BAD_REQUEST) dbsession = DBConnection().getsession() db_intent_topics: COTopic = dbsession.query(COTopic).get( intent_topics.identifier) db_intent_topics.identifier = intent_topics.identifier db_intent_topics.name = intent_topics.name dbsession.commit() self.get_logger().info(COMLTopic.MSG_TOPIC_UPDATE_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str(intent_topics.identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLTopic.MSG_TOPIC_UPDATE_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( intent_topics.identifier) raise CFException(Exception(message), message) finally: dbsession.close()
def add_job_level(self, job_level: COJobLevel): dbsession = None try: if not isinstance(job_level, COJobLevel): message = COMLJobLevel.MSG_JOB_LEVEL_NOT_VALID + COStringLiteral.STR_SEPARATOR_PIPE + str( job_level.identifier) self.get_logger().error(message) raise CFException(ValueError(message), message, status_code=CFException.HTTP_400_BAD_REQUEST) dbsession = DBConnection().getsession() dbsession.add(job_level) dbsession.commit() self.get_logger().info(COMLJobLevel.MSG_JOB_LEVEL_INSERT_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str(job_level.identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLJobLevel.MSG_JOB_LEVEL_INSERT_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( job_level.identifier) self.get_logger().error(message) raise CFException(Exception(message), message) finally: dbsession.close()
def add_employee_size(self, employee_size: COEmployee): dbsession = None try: if not isinstance(employee_size, COEmployee): message = COMLEmployee.MSG_EMPLOYEE_VALUE_NOT_VALID + COStringLiteral.STR_SEPARATOR_PIPE + str( employee_size.identifier) self.get_logger().error(message) raise CFException(ValueError(message), message, status_code=CFException.HTTP_400_BAD_REQUEST) dbsession = DBConnection().getsession() dbsession.add(employee_size) dbsession.commit() self.get_logger().info( COMLEmployee.MSG_EMPLOYEE_VALUE_INSERT_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str( employee_size.identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLEmployee.MSG_EMPLOYEE_VALUE_INSERT_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( employee_size.identifier) self.get_logger().error(message) raise CFException(Exception(message), message) finally: dbsession.close()
def update_byonic_user(self, byonic_user: COByonicUser): dbsession = None try: if not isinstance(byonic_user, COByonicUser): message = COMLByonicUser.MSG_BYONIC_USER_NOT_VALID + COStringLiteral.STR_SEPARATOR_PIPE + str( byonic_user.identifier) self.get_logger().error(message) raise CFException(ValueError(message), message, status_code=CFException.HTTP_400_BAD_REQUEST) dbsession = DBConnection().getsession() db_byonic_user: COByonicUser = dbsession.query(COByonicUser).get(byonic_user.identifier) db_byonic_user.identifier = byonic_user.identifier db_byonic_user.reset = byonic_user.reset db_byonic_user.user_first_name = byonic_user.user_first_name db_byonic_user.user_last_name = byonic_user.user_last_name db_byonic_user.email = byonic_user.email db_byonic_user.password = hashlib.sha512(byonic_user.password.encode("utf-8")).hexdigest() db_byonic_user.organisation_id = byonic_user.organisation_id db_byonic_user.role_id = byonic_user.role_id db_byonic_user.status = byonic_user.status dbsession.commit() self.get_logger().info( COMLByonicUser.MSG_BYONIC_USER_UPDATE_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str( byonic_user.identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLByonicUser.MSG_BYONIC_USER_UPDATE_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( byonic_user.identifier) raise CFException(Exception(message), message) finally: dbsession.close()
def delete_industry(self, identifier: int): dbsession = None try: dbsession = DBConnection().getsession() db_industry: COIndustry = dbsession.query(COIndustry).get(identifier) dbsession.delete(db_industry) dbsession.commit() self.get_logger().info( COMLIndustry.MSG_INDUSTRY_DELETE_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str( identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLIndustry.MSG_INDUSTRY_DELETE_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( identifier) self.get_logger().error(message) raise CFException(Exception(message), message) finally: dbsession.close()
def delete_byonic_user(self, identifier: int): dbsession = None try: dbsession = DBConnection().getsession() db_byonic_user: COByonicUser = dbsession.query(COByonicUser).get(identifier) dbsession.delete(db_byonic_user) dbsession.commit() self.get_logger().info( COMLByonicUser.MSG_BYONIC_USER_DELETE_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str( identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLByonicUser.MSG_BYONIC_USER_DELETE_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( identifier) self.get_logger().error(message) raise CFException(Exception(message), message) finally: dbsession.close()
def delete_employee_size(self, identifier: int): dbsession = None try: dbsession = DBConnection().getsession() db_employee_size: COEmployee = dbsession.query(COEmployee).get(identifier) dbsession.delete(db_employee_size) dbsession.commit() self.get_logger().info( COMLEmployee.MSG_EMPLOYEE_VALUE_DELETE_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str( identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLEmployee.MSG_EMPLOYEE_VALUE_DELETE_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( identifier) self.get_logger().error(message) raise CFException(Exception(message), message) finally: dbsession.close()
def delete_revenue_range(self, identifier: int): dbsession = None try: dbsession = DBConnection().getsession() db_revenue_range: CORevenue = dbsession.query(CORevenue).get( identifier) dbsession.delete(db_revenue_range) dbsession.commit() self.get_logger().info( COMLRevenue.MSG_REVENUE_RANGE_DELETE_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str(identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLRevenue.MSG_REVENUE_RANGE_DELETE_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( identifier) self.get_logger().error(message) raise CFException(Exception(message), message) finally: dbsession.close()
def delete_job_level(self, identifier: int): dbsession = None try: dbsession = DBConnection().getsession() db_job_level: COJobLevel = dbsession.query(COJobLevel).get( identifier) dbsession.delete(db_job_level) dbsession.commit() self.get_logger().info(COMLJobLevel.MSG_JOB_LEVEL_DELETE_SUCCESS + COStringLiteral.STR_SEPARATOR_PIPE + str(identifier)) except CFException: dbsession.rollback() raise except Exception: dbsession.rollback() message = COMLJobLevel.MSG_JOB_LEVEL_DELETE_FAILED + COStringLiteral.STR_SEPARATOR_PIPE + str( identifier) self.get_logger().error(message) raise CFException(Exception(message), message) finally: dbsession.close()