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()