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
