def insert_vm_list_db(self, session, notification_id, notification_uuid, retry_cnt): """ VM list table registration :param :cursor: cursor object :param :notification_id: Notification ID (used as search criteria for notification list table) :param :notification_uuid:VM of uuid (used as the registered contents of the VM list table) :param :retry_cnt:Retry count (used as the registered contents of the VM list table) :return :primary_id: The value of LAST_INSERT_ID """ try: res = dbapi.get_all_notification_list_by_notification_id( session, notification_id ) # Todo(sampath): select first and only object from the list # log if many records notification_recover_to = res[0].recover_to notification_recover_by = res[0].recover_by vm_item = dbapi.add_vm_list(session, datetime.datetime.now(), "0", notification_uuid, "0", str(retry_cnt), notification_id, notification_recover_to, str(notification_recover_by) ) self.rc_util.syslogout_ex("RecoveryControllerUtilDb_0001", syslog.LOG_INFO) primary_id = vm_item.id return primary_id except KeyError: self.rc_util.syslogout_ex("RecoveryControllerUtilDb_0002", syslog.LOG_ERR) error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) self.rc_util.syslogout(error_type, syslog.LOG_ERR) self.rc_util.syslogout(error_value, syslog.LOG_ERR) for tb in tb_list: self.rc_util.syslogout(tb, syslog.LOG_ERR) msg = "Exception : KeyError in insert_vm_list_db()." self.rc_util.syslogout(msg, syslog.LOG_ERR) raise KeyError except exc.SQLAlchemyError: self.rc_util.syslogout_ex("RecoveryControllerUtilDb_0003", syslog.LOG_ERR) error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) self.rc_util.syslogout(error_type, syslog.LOG_ERR) self.rc_util.syslogout(error_value, syslog.LOG_ERR) for tb in tb_list: self.rc_util.syslogout(tb, syslog.LOG_ERR) msg = "Exception : sqlalchemy error in insert_vm_list_db()." self.rc_util.syslogout(msg, syslog.LOG_ERR) raise exc.SQLAlchemyError except: self.rc_util.syslogout_ex("RecoveryControllerUtilDb_0004", syslog.LOG_ERR) error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) self.rc_util.syslogout(error_type, syslog.LOG_ERR) self.rc_util.syslogout(error_value, syslog.LOG_ERR) for tb in tb_list: self.rc_util.syslogout(tb, syslog.LOG_ERR) msg = "Exception : Exception in insert_vm_list_db()." self.rc_util.syslogout(msg, syslog.LOG_ERR) raise
def insert_vm_list_db(self, session, notification_id, notification_uuid, retry_cnt): """ VM list table registration :param :cursor: cursor object :param :notification_id: Notification ID (used as search criteria for notification list table) :param :notification_uuid:VM of uuid (used as the registered contents of the VM list table) :param :retry_cnt:Retry count (used as the registered contents of the VM list table) :return :primary_id: The value of LAST_INSERT_ID """ try: msg = "Do get_all_notification_list_by_notification_id." LOG.info(msg) res = dbapi.get_all_notification_list_by_notification_id( session, notification_id ) msg = "Succeeded in get_all_notification_list_by_notification_id. " \ + "Return_value = " + str(res) LOG.info(msg) # Todo(sampath): select first and only object from the list # log if many records notification_recover_to = res[0].recover_to notification_recover_by = res[0].recover_by msg = "Do add_vm_list." LOG.info(msg) vm_item = dbapi.add_vm_list(session, datetime.datetime.now(), "0", notification_uuid, "0", str(retry_cnt), notification_id, notification_recover_to, str(notification_recover_by) ) msg = "Succeeded in add_vm_list. " \ + "Return_value = " + str(vm_item) LOG.info(msg) primary_id = vm_item.id return primary_id except KeyError: error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) LOG.error(error_type) LOG.error(error_value) for tb in tb_list: LOG.error(tb) msg = "Exception : KeyError in insert_vm_list_db()." LOG.error(msg) raise KeyError except exc.SQLAlchemyError: error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) LOG.error(error_type) LOG(error_value) for tb in tb_list: LOG.error(tb) msg = "Exception : sqlalchemy error in insert_vm_list_db()." LOG.error(msg) raise exc.SQLAlchemyError except: error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) LOG.error(error_type) LOG.error(error_value) for tb in tb_list: LOG.error(tb) msg = "Exception : Exception in insert_vm_list_db()." LOG.error(msg) raise
def insert_vm_list_db(self, session, notification_id, notification_uuid, retry_cnt): """ VM list table registration :param :cursor: cursor object :param :notification_id: Notification ID (used as search criteria for notification list table) :param :notification_uuid:VM of uuid (used as the registered contents of the VM list table) :param :retry_cnt:Retry count (used as the registered contents of the VM list table) :return :primary_id: The value of LAST_INSERT_ID """ try: msg = "Do get_all_notification_list_by_notification_id." LOG.info(msg) res = dbapi.get_all_notification_list_by_notification_id( session, notification_id) msg = "Succeeded in get_all_notification_list_by_notification_id. " \ + "Return_value = " + str(res) LOG.info(msg) # Todo(sampath): select first and only object from the list # log if many records notification_recover_to = res[0].recover_to notification_recover_by = res[0].recover_by msg = "Do add_vm_list." LOG.info(msg) vm_item = dbapi.add_vm_list(session, datetime.datetime.now(), "0", notification_uuid, "0", str(retry_cnt), notification_id, notification_recover_to, str(notification_recover_by)) msg = "Succeeded in add_vm_list. " \ + "Return_value = " + str(vm_item) LOG.info(msg) primary_id = vm_item.id return primary_id except KeyError: error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) LOG.error(error_type) LOG.error(error_value) for tb in tb_list: LOG.error(tb) msg = "Exception : KeyError in insert_vm_list_db()." LOG.error(msg) raise KeyError except exc.SQLAlchemyError: error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) LOG.error(error_type) LOG(error_value) for tb in tb_list: LOG.error(tb) msg = "Exception : sqlalchemy error in insert_vm_list_db()." LOG.error(msg) raise exc.SQLAlchemyError except: error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) LOG.error(error_type) LOG.error(error_value) for tb in tb_list: LOG.error(tb) msg = "Exception : Exception in insert_vm_list_db()." LOG.error(msg) raise
def insert_vm_list_db(self, session, notification_id, notification_uuid, retry_cnt): """ VM list table registration :param :cursor: cursor object :param :notification_id: Notification ID (used as search criteria for notification list table) :param :notification_uuid:VM of uuid (used as the registered contents of the VM list table) :param :retry_cnt:Retry count (used as the registered contents of the VM list table) :return :primary_id: The value of LAST_INSERT_ID """ try: res = dbapi.get_all_notification_list_by_notification_id( session, notification_id) # Todo(sampath): select first and only object from the list # log if many records notification_recover_to = res[0].recover_to notification_recover_by = res[0].recover_by vm_item = dbapi.add_vm_list(session, datetime.datetime.now(), "0", notification_uuid, "0", str(retry_cnt), notification_id, notification_recover_to, str(notification_recover_by)) self.rc_util.syslogout_ex("RecoveryControllerUtilDb_0001", syslog.LOG_INFO) primary_id = vm_item.id return primary_id except KeyError: self.rc_util.syslogout_ex("RecoveryControllerUtilDb_0002", syslog.LOG_ERR) error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) self.rc_util.syslogout(error_type, syslog.LOG_ERR) self.rc_util.syslogout(error_value, syslog.LOG_ERR) for tb in tb_list: self.rc_util.syslogout(tb, syslog.LOG_ERR) msg = "Exception : KeyError in insert_vm_list_db()." self.rc_util.syslogout(msg, syslog.LOG_ERR) raise KeyError except exc.SQLAlchemyError: self.rc_util.syslogout_ex("RecoveryControllerUtilDb_0003", syslog.LOG_ERR) error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) self.rc_util.syslogout(error_type, syslog.LOG_ERR) self.rc_util.syslogout(error_value, syslog.LOG_ERR) for tb in tb_list: self.rc_util.syslogout(tb, syslog.LOG_ERR) msg = "Exception : sqlalchemy error in insert_vm_list_db()." self.rc_util.syslogout(msg, syslog.LOG_ERR) raise exc.SQLAlchemyError except: self.rc_util.syslogout_ex("RecoveryControllerUtilDb_0004", syslog.LOG_ERR) error_type, error_value, traceback_ = sys.exc_info() tb_list = traceback.format_tb(traceback_) self.rc_util.syslogout(error_type, syslog.LOG_ERR) self.rc_util.syslogout(error_value, syslog.LOG_ERR) for tb in tb_list: self.rc_util.syslogout(tb, syslog.LOG_ERR) msg = "Exception : Exception in insert_vm_list_db()." self.rc_util.syslogout(msg, syslog.LOG_ERR) raise