def render(self, query_name, **kwargs):
query = utility.get_template(query_name, self._sql_templates_path, 'sql')
return query.render(kwargs)
series_item = {'name': series_info['name'], 'data': series_data}
series.append(series_item)
return series
images = {}
def export_chart(chart_name, chart_data):
global images
chart_setting_path = os.path.join(TEMP_DIR, "%s.json" % chart_name)
with open(chart_setting_path, 'w') as chart_setting_file:
chart_setting_file.write(json.dumps(chart_data))
chart_path = os.path.join(TEMP_DIR, '%s.jpg' % chart_name)
export_cmd = 'export.cmd %s %s' % (chart_setting_path, chart_path)
os.system(export_cmd)
images[chart_name] = chart_path
helper = sql_helper.SqlHelper(CONNECTION_STR, args.report, REPORT_MAPPING['data'])
report_data = helper.fetch_all_data()
report_template = utility.get_template('report_template', REPORT_DIR, 'html')
report = report_template.render(**report_data)
for chart_name, chart in REPORT_MAPPING['charts'].iteritems():
generate_x_data(chart)
chart["series"] = generate_y_data(chart)
export_chart(chart_name, chart)
utility.send_email(SMTP, USER, PWD, REPORT_NAME, FROM_EMAIL, TO_EMAIL, report, images)
print "Done"
