def reset_dba_portal_redis(self): ''' Reset redis data. ''' print '%s: -- redis: reset backup data...' % time.strftime('%Y-%m-%d %H-%M-%S') backup_list = BackupList() print '%s: -- redis: reset server data...' % time.strftime('%Y-%m-%d %H-%M-%S') server_list = ServerList() server_all = server_list.list_all() self.set_json_with_expire('server_all', server_all, self._expire_server_all) time.sleep(3) # server_available = server_list.list_available() # self.set_json_with_expire('server_available', server_available, self._expire_server_available) # time.sleep(3) # server_total_count = server_list.get_total_count() # self.set_json_with_expire('server_total_count', server_total_count, self._expire_server_total_count) # time.sleep(3) print '%s: -- redis: reset instance data...' % time.strftime('%Y-%m-%d %H-%M-%S') instance_list = InstanceList() instance_all = instance_list.list_all() self.set_json_with_expire('instance_all', instance_all, self._expire_instance_all) time.sleep(3) instance_total_count = instance_list.get_total_count() self.set_json_with_expire('instance_total_count', instance_total_count, self._expire_instance_total_count) time.sleep(3) return True
def reset_dba_portal_redis(self): ''' Reset redis data. ''' print '%s: -- redis: reset backup data...' % time.strftime( '%Y-%m-%d %H-%M-%S') backup_list = BackupList() print '%s: -- redis: reset server data...' % time.strftime( '%Y-%m-%d %H-%M-%S') server_list = ServerList() server_all = server_list.list_all() self.set_json_with_expire('server_all', server_all, self._expire_server_all) time.sleep(3) # server_available = server_list.list_available() # self.set_json_with_expire('server_available', server_available, self._expire_server_available) # time.sleep(3) # server_total_count = server_list.get_total_count() # self.set_json_with_expire('server_total_count', server_total_count, self._expire_server_total_count) # time.sleep(3) print '%s: -- redis: reset instance data...' % time.strftime( '%Y-%m-%d %H-%M-%S') instance_list = InstanceList() instance_all = instance_list.list_all() self.set_json_with_expire('instance_all', instance_all, self._expire_instance_all) time.sleep(3) instance_total_count = instance_list.get_total_count() self.set_json_with_expire('instance_total_count', instance_total_count, self._expire_instance_total_count) time.sleep(3) return True
def instance_info(id=None): try: data = dict({'page_data': dict()}) host_info = ServerList() instance = InstList() single_instance_info = dict() query_result = instance.info_by_id(id) single_instance_info = query_result[0] data['page_data']['instance_info'] = single_instance_info server_id = single_instance_info['server_id'] single_server_info = dict() query_result = host_info.info_by_id(server_id) single_server_info = query_result[0] data['page_data']['server_info'] = single_server_info data['page_data']['server_info']['server_id'] = server_id machine_info = dict() query_result = host_info.machine_info_by_id(server_id) machine_info = query_result[0] data['page_data']['machine_info'] = machine_info data['page_name'] = 'Instance Info' return render_template('instanceinfo.html', data=data) except CmdbApiCallException, e: flash(e.detail_msg(), 'danger') return render_template('blank.html')
def server_info_edit(server_id=None): try: data = dict() host_info = ServerList() if request.method == 'POST': page_data = request.form host_info.save_server_info(page_data) flash('Edit Server Information Success', 'success') else: if not server_id or server_id == 0: page_data = '' else: page_data = host_info.info_by_id(server_id)[0] server_form = ServerInfoForm() supported_select_key = ['owner', 'mirror', 'server_status', 'env'] fill_select_data = dict() for key in supported_select_key: fill_select_data[key] = page_data[key] server_form = fill_server_info_form(server_form=server_form, **fill_select_data) data['page_name'] = 'Server Info' data['form'] = server_form data['page_data'] = page_data return render_template('serverinfoedit.html', data=data) except CmdbApiCallException, e: flash(e.detail_msg(), 'danger') return render_template('blank.html')
def server_list(): try: data = dict() supported_query_key = ['owner', 'mirror', 'server_status', 'env', 'use_status'] query_condition = dict() all_servers = ServerList() for key in supported_query_key: request_value = request.args.get(key, False) if request_value: query_condition[key] = request_value page_data = all_servers.list_all(data=query_condition) filter_form = ServerInfoForm() filter_form = fill_server_info_form(server_form=filter_form, **query_condition) message_list = ({'from': 'admin', 'time': '2013-01-01', 'content': 'This is a test message'},) task_list = ({'name': 'task 1', 'progress': 10},) data['message_list'] = message_list data['task_list'] = task_list data['page_name'] = 'Machine List' data['page_data'] = page_data data['filter_form'] = filter_form return render_template('serverlist.html', data=data) except CmdbApiCallException, e: flash(e.detail_msg(), 'danger') return render_template('blank.html')
def init_system(server_id=None): try: data = dict() host_info = ServerList() if request.method == 'POST': request_dict = dict() request_dict['server_id'] = request.form.get('server_id') request_dict['server_ip'] = request.form.get('server_ip') request_dict['mirror'] = request.form.get('mirror') request_dict['comment'] = request.form.get('comment') result = host_info.init_system_with_mirror(request_dict) flash('System initial request sent', 'success') else: if not server_id or server_id == 0: page_data = '' page_data = host_info.info_by_id(server_id)[0] server_form = ServerInitForm() if request.form.get('mirror', False): server_form = fill_init_server_form(server_form, request.form.get('mirror', '')) else: server_form = fill_init_server_form(server_form, mirror=page_data['mirror']) data['page_name'] = 'Server Info' data['form'] = server_form data['page_data'] = page_data return render_template('init_system.html', data=data) except CmdbApiCallException, e: flash(e.detail_msg(), 'danger') return render_template('blank.html')
def online_system(server_id=None): host_info = ServerList() try: query_result = host_info.online_by_id(server_id) flash('Online Server Success', 'success') except CmdbApiCallException, e: flash(e.detail_msg(), 'danger') return render_template('blank.html')
def fill_init_server_form(server_form=None, mirror=''): host_info = ServerList() mirror_list = host_info.list_supported_mirror() mirror_list = zip(mirror_list, mirror_list) server_form.mirror.choices = mirror_list if not mirror: mirror = '' server_form.mirror.data = mirror return server_form
def delete_server(server_id=None): host_info = ServerList() try: query_result = host_info.delete_by_id(server_id) flash('Delete Server Success', 'success') return redirect(url_for('server_list')) except CmdbApiCallException, e: flash(e.detail_msg(), 'danger') return render_template('blank.html') return redirect(url_for('server_info', server_id=server_id))
def add_server(): try: host_info = ServerList() env = host_info.list_supported_env() mirror = host_info.list_supported_mirror() use_status = host_info.list_supported_use_status() owner = host_info.list_supported_dba() status = host_info.list_supported_status() server_form = ServerInfoForm() server_form.env.choices = env server_form.mirror.choices = mirror server_form.server_status.choices = status server_form.use_status.choices = use_status server_form.owner.choices = owner data = dict() if request.method == 'POST': server_post = request.form server_info = ServerList() result = server_info.add_server(server_post) page_data = dict() page_data['add_result'] = dict() flash('Add Server Success!', 'success') return redirect(url_for('server_info', server_id=request.form['server_id'])) data['form_data'] = server_post else: page_data = '' data['form_data'] = dict() data['page_name'] = 'Add Server' data['form'] = server_form data['page_data'] = page_data return render_template('addserver.html', data=data) except CmdbApiCallException, e: flash(e.detail_msg(), 'danger') return render_template('blank.html')
def init_dba_portal_redis(self): self._redis.flushall() print 'add server data into redis...' server_list = ServerList() server_all = server_list.list_all() server_all = json.dumps(server_all, ensure_ascii=False) self._redis.set('server_all', server_all) time.sleep(3) server_available = server_list.list_available() server_available = json.dumps(server_available, ensure_ascii=False) self._redis.set('server_available', server_available) time.sleep(3) server_total_count = server_list.get_total_count() server_total_count = json.dumps(server_total_count, ensure_ascii=False) self._redis.set('server_total_count', server_total_count) time.sleep(3) print 'add instance data into redis...' instance_list = InstList() instance_total_count = instance_list.get_total_count() instance_total_count = json.dumps(instance_total_count, ensure_ascii=False) self._redis.set('instance_total_count', instance_total_count) time.sleep(3) print 'add backup data into redis...' backup_list = BackupList() backup_mha = backup_list.mha() backup_mha = json.dumps(backup_mha, ensure_ascii=False) self._redis.set('backup_mha', backup_mha) time.sleep(3) backup_single_instance = backup_list.single_instance() backup_single_instance = json.dumps(backup_single_instance, ensure_ascii=False) self._redis.set('backup_single_instance', backup_single_instance) time.sleep(3) backup_configure = backup_list.configure() backup_configure = json.dumps(backup_configure, ensure_ascii=False) self._redis.set('backup_configure', backup_configure) time.sleep(3) backup_email_backup_report = backup_list.email_backup_report() backup_email_backup_report = json.dumps(backup_email_backup_report, ensure_ascii=False) self._redis.set('backup_email_backup_report', backup_email_backup_report) time.sleep(3) return True
def init_dba_portal_redis(self): self._redis.flushall() print "add server data into redis..." server_list = ServerList() server_all = server_list.list_all() server_all = json.dumps(server_all, ensure_ascii=False) self._redis.set("server_all", server_all) time.sleep(3) server_available = server_list.list_available() server_available = json.dumps(server_available, ensure_ascii=False) self._redis.set("server_available", server_available) time.sleep(3) server_total_count = server_list.get_total_count() server_total_count = json.dumps(server_total_count, ensure_ascii=False) self._redis.set("server_total_count", server_total_count) time.sleep(3) print "add instance data into redis..." instance_list = InstList() instance_total_count = instance_list.get_total_count() instance_total_count = json.dumps(instance_total_count, ensure_ascii=False) self._redis.set("instance_total_count", instance_total_count) time.sleep(3) print "add backup data into redis..." backup_list = BackupList() backup_mha = backup_list.mha() backup_mha = json.dumps(backup_mha, ensure_ascii=False) self._redis.set("backup_mha", backup_mha) time.sleep(3) backup_single_instance = backup_list.single_instance() backup_single_instance = json.dumps(backup_single_instance, ensure_ascii=False) self._redis.set("backup_single_instance", backup_single_instance) time.sleep(3) backup_configure = backup_list.configure() backup_configure = json.dumps(backup_configure, ensure_ascii=False) self._redis.set("backup_configure", backup_configure) time.sleep(3) backup_email_backup_report = backup_list.email_backup_report() backup_email_backup_report = json.dumps(backup_email_backup_report, ensure_ascii=False) self._redis.set("backup_email_backup_report", backup_email_backup_report) time.sleep(3) return True
def dashboard(): try: data = dict() message_list = ({'from': 'admin', 'time': '2013-01-01', 'content': 'This is a test message'},) task_list = ({'name': 'task 1', 'progress': 10},) data['message_list'] = message_list data['task_list'] = task_list data['page_name'] = 'Dash Board' servers = ServerList() instances = InstList() data['page_data'] = dict() data['page_data']['server_cnt'] = servers.get_total_cnt() data['page_data']['instance_cnt'] = instances.get_total_cnt() return render_template('dashboard.html', data=data) except (CmdbApiCallException, requests.ConnectionError), e: flash(e.message, 'danger') return render_template('dashboard.html', data=data)
def fill_server_info_form(server_form=None, env='', mirror='', server_status='', use_status='', owner=''): host_info = ServerList() env_list = host_info.list_supported_env() mirror_list = host_info.list_supported_mirror() use_status_list = host_info.list_supported_use_status() server_status_list = host_info.list_supported_status() owner_list = host_info.list_supported_dba() server_form.env.choices = env_list server_form.mirror.choices = mirror_list server_form.server_status.choices = server_status_list server_form.use_status.choices = use_status_list server_form.owner.choices = owner_list if not env: env = '' if not mirror: mirror = '' if not owner: owner = '' if not server_status: server_status = '' if not use_status: use_status = '' server_form.env.data = env server_form.mirror.data = mirror server_form.owner.data = owner server_form.server_status.data = server_status server_form.use_status.data = use_status return server_form
def server_info(server_id=None): try: data = dict({'page_data': dict()}) host_info = ServerList() single_server_info = dict() query_result = host_info.info_by_id(server_id) single_server_info = query_result[0] data['page_data']['server_info'] = single_server_info data['page_data']['server_info']['server_id'] = server_id machine_info = dict() query_result = host_info.machine_info_by_id(server_id) if len(query_result) > 0: machine_info = query_result[0] data['page_data']['machine_info'] = machine_info data['page_name'] = 'Server Info' return render_template('serverinfo.html', data=data) except CmdbApiCallException, e: flash(e.detail_msg(), 'danger') return render_template('blank.html')