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