def query_task_by_id(task_id): session = Session() rows = session.query(TaskInfo.id, TaskInfo.input_data_type_id, TaskInfo.time_range, TaskInfo.functions, TaskInfo.result_data_type_id, TaskInfo.title).filter(TaskInfo.id == task_id) for info in rows: temp = {'id': int(info[0]), 'input_data_type_id': int(info[1]), 'time_range': json_wrapper.encode(info[2], 'utf-8'), 'functions': json_wrapper.loads(info[3]), 'result_data_type_id': int(info[4]), 'title': json_wrapper.encode(info[5], 'utf-8')} result = temp session.close() return result
def query_data_type(): session = Session() rows = session.query(DataTypeInfo.id, DataTypeInfo.title, DataTypeInfo.attrs) result = [] for info in rows: temp = {'id': info[0], 'title': json_wrapper.encode(info[1], 'utf-8'), 'attrs': json_wrapper.loads(info[2])} result.append(temp) session.close() return result
def task_list(): debug_logger.info(str(request)) task_list = __task_center.get_tasks() if len(task_list) == 0: chart_content = high_chart.generate_chart_content( title='No Data', subtitle='No Data', chart_id='chart', data_list=[]) return render_template('task.html', name=None, tasks={}, selected_task=None, selected_function=None, chart=chart_content) tasks = {} for task in task_list: functions = [] for i in xrange(1, len(task['functions']) + 1): functions.append(task['functions'][str(i)]) task['functions'] = functions if len(task['title']) > 19: task['title'] = task['title'][:17] + '...' tasks[task['id']] = task name = request.values.get('name') if name is None: name = "unknown" selected_task = request.values.get('selected_task') if selected_task is None: selected_task = task_list[0]['id'] else: selected_task = int(selected_task) selected_function = json_wrapper.encode(request.values.get('selected_function'), 'utf-8') if selected_function is not None: selected_function = int(selected_function) else: selected_function = 1 result_data_type_id = tasks[selected_task]['result_data_type_id'] chart_data = __data_center.query(result_data_type_id) result_data_type = __data_center.get_data_type(result_data_type_id) input_data_type_id = tasks[selected_task]['input_data_type_id'] input_data_type = __data_center.get_data_type(input_data_type_id) # print(chart_data) chart_content = high_chart.generate_chart_content( title='Result Data Type: [' + str(result_data_type_id) + ']' + result_data_type['title'], subtitle='Input Data Type: [{id}]{title}'.format( id=input_data_type_id, title=input_data_type['title']), chart_id='chart', data_list=chart_data) return render_template('task.html', name=name, tasks=tasks, selected_task=selected_task, selected_function=selected_function, chart=chart_content)
def task_list(): debug_logger.info(str(request)) task_list = __task_center.get_tasks() if len(task_list) == 0: chart_content = high_chart.generate_chart_content(title='No Data', subtitle='No Data', chart_id='chart', data_list=[]) return render_template('task.html', name=None, tasks={}, selected_task=None, selected_function=None, chart=chart_content) tasks = {} for task in task_list: functions = [] for i in xrange(1, len(task['functions']) + 1): functions.append(task['functions'][str(i)]) task['functions'] = functions if len(task['title']) > 19: task['title'] = task['title'][:17] + '...' tasks[task['id']] = task name = request.values.get('name') if name is None: name = "unknown" selected_task = request.values.get('selected_task') if selected_task is None: selected_task = task_list[0]['id'] else: selected_task = int(selected_task) selected_function = json_wrapper.encode( request.values.get('selected_function'), 'utf-8') if selected_function is not None: selected_function = int(selected_function) else: selected_function = 1 result_data_type_id = tasks[selected_task]['result_data_type_id'] chart_data = __data_center.query(result_data_type_id) result_data_type = __data_center.get_data_type(result_data_type_id) input_data_type_id = tasks[selected_task]['input_data_type_id'] input_data_type = __data_center.get_data_type(input_data_type_id) # print(chart_data) chart_content = high_chart.generate_chart_content( title='Result Data Type: [' + str(result_data_type_id) + ']' + result_data_type['title'], subtitle='Input Data Type: [{id}]{title}'.format( id=input_data_type_id, title=input_data_type['title']), chart_id='chart', data_list=chart_data) return render_template('task.html', name=name, tasks=tasks, selected_task=selected_task, selected_function=selected_function, chart=chart_content)
def to_dict(self): _dict = {'id': self.id, 'title': json_wrapper.encode(self.title, 'utf-8'), 'attrs': json_wrapper.loads(self.attrs)} return _dict