def test_get_all_chart_data_ignore_type():
global test_db_file
filename = os.path.join(os.getcwd(), test_db_file)
query1 = 'Select TotalFrameCount from AnalyzerPortResults'
data = sql_utils.get_all_chart_data_ignore_type(query1, [filename])
assert data is not None
assert data == [1151261, 1239945]
query2 = 'Select Name from StcSystem'
data = sql_utils.get_all_chart_data_ignore_type(query2, [filename])
assert data is not None
assert data == ['StcSystem 1']
query3 = 'Select TotalFrameCount, TotalOctetCount from AnalyzerPortResults'
data = sql_utils.get_all_chart_data_ignore_type(query3, [filename])
assert data is not None
assert data == [[1151261, 147361408], [1239945, 158712960]]
def get_series_data(result_file_list):
this_cmd = get_this_cmd()
series = this_cmd.GetCollection('Series')
new_series = []
for s in series:
if is_sql_query(s):
new_series.append(sql_utils.get_all_chart_data_ignore_type(s, result_file_list))
else:
split_pairs = re.findall('\[(.*?)\]', s)
if not split_pairs:
# Single data type
new_series.append([int_or_float_or_string(i) for i in s.split(',')])
else:
# Pair (or more) data type
pair_list = []
for pair in split_pairs:
pair_list.append([int_or_float_or_string(i) for i in pair.split(',')])
new_series.append(pair_list)
return new_series
