port=incept.db_backup_port, tableName=tableName, sequence=str(ds.sequence).replace('\'',''), ) if rbkSql.get('status') == 'success': for sql in rbkSql.get('data'): rollBackSql.append(sql[0]) if rollBackSql: rbkSql = Inception( host=order.sql_audit_order.order_db.db_host, name=order.sql_audit_order.order_db.db_name, user=order.sql_audit_order.order_db.db_user, passwd=order.sql_audit_order.order_db.db_passwd, port=order.sql_audit_order.order_db.db_port ) for sql in rollBackSql: result = rbkSql.rollback(sql) if result.get('status') == 'error':#回滚时如果其中一条出现错误就停止回滚 return JsonResponse({'msg':"SQL回滚失败:" + result.get('errinfo'),"code":500,'data':[]}) #回滚语句如果全部执行成功则修改状态 order.order_status = 6 order.save() sendOrderNotice.delay(order.id,mask='【已回滚】') return JsonResponse({'msg':"SQL回滚成功","code":200,'data':[]}) else: return JsonResponse({'msg':"没有需要执行的回滚SQL语句","code":500,'data':[]}) else: return JsonResponse({'msg':"SQL已经被执行","code":500,'data':[]}) @login_required() @permission_required('OpsManage.change_sql_audit_control',login_url='/noperm/')
user=incept.db_backup_user, passwd=incept.db_backup_passwd, dbName=ds.backup_db, port=incept.db_backup_port, tableName=tableName, sequence=str(ds.sequence).replace('\'', ''), ) if rbkSql.get('status') == 'success': rollBackSql.append(rbkSql.get('data')[0]) if rollBackSql: rbkSql = Inception(host=order.order_db.db_host, name=order.order_db.db_name, user=order.order_db.db_user, passwd=order.order_db.db_passwd, port=order.order_db.db_port) result = rbkSql.rollback(','.join(rollBackSql)) if result.get('status') == 'success': order.order_status = 3 order.save() sendSqlEmail.delay(order.id, mask='【已回滚】') return JsonResponse({ 'msg': "SQL回滚成功", "code": 200, 'data': [] }) else: return JsonResponse({ 'msg': "SQL回滚失败:" + result.get('errinfo'), "code": 500,
tableName = result.get('data')[0] rbkSql = Inception.getRollBackSQL( host=incept.db_backup_host, user=incept.db_backup_user, passwd=incept.db_backup_passwd, dbName=ds.backup_db, port=incept.db_backup_port, tableName=tableName, sequence=str(ds.sequence).replace('\'',''), ) if rbkSql.get('status') == 'success': rollBackSql.append(rbkSql.get('data')[0]) if rollBackSql: rbkSql = Inception( host=order.order_db.db_host,name=order.order_db.db_name, user=order.order_db.db_user,passwd=order.order_db.db_passwd, port=order.order_db.db_port ) result = rbkSql.rollback(','.join(rollBackSql)) if result.get('status') == 'success': order.order_status = 3 order.save() sendSqlNotice.delay(order.id,mask='【已回滚】') return JsonResponse({'msg':"SQL回滚成功","code":200,'data':[]}) else: return JsonResponse({'msg':"SQL回滚失败:" + result.get('errinfo'),"code":500,'data':[]}) else: return JsonResponse({'msg':"没有需要执行的回滚SQL语句","code":500,'data':[]}) else: return JsonResponse({'msg':"SQL已经被执行","code":500,'data':[]}) @login_required() @permission_required('OpsManage.change_sql_audit_control',login_url='/noperm/')
port=incept.db_backup_port, tableName=tableName, sequence=str(ds.sequence).replace('\'', ''), ) if rbkSql.get('status') == 'success': for sql in rbkSql.get('data'): rollBackSql.append(sql[0]) if rollBackSql: rbkSql = Inception( host=order.sql_audit_order.order_db.db_host, name=order.sql_audit_order.order_db.db_name, user=order.sql_audit_order.order_db.db_user, passwd=order.sql_audit_order.order_db.db_passwd, port=order.sql_audit_order.order_db.db_port) for sql in rollBackSql: result = rbkSql.rollback(sql) if result.get('status') == 'error': #回滚时如果其中一条出现错误就停止回滚 return JsonResponse({ 'msg': "SQL回滚失败:" + result.get('errinfo'), "code": 500, 'data': [] }) #回滚语句如果全部执行成功则修改状态 order.order_status = 6 order.save() sendOrderNotice.delay(order.id, mask='【已回滚】') return JsonResponse({ 'msg': "SQL回滚成功", "code": 200,