# -*- coding: utf-8 -*-
import sys
import os
def CreateHtml(tableId, dataType, fPath, rows, titles, pos):
logstr = ""
if len(rows) != 0:
# convert the data into a table
chart_table=""
for row in rows[:-1]:
rowstr="['{0}', {1}],\n".format(str(row[0]),str(row[pos]))
chart_table+=rowstr
row=rows[-1]
rowstr="['{0}', {1}]\n".format(str(row[0]),str(row[pos]))
chart_table+=rowstr
table=chart_table
else:
print "No data found"
return
# start creating the html page
logstr += ""+'\n\r'
logstr += ""+'\n\r'
logstr += " "+'\n\r'
logstr += " "+'\n\r'
# google chart snippet
c_code_1 = """
"""
c_code = c_code_1+c_code_2+c_code_3+'"'+c_code_4+'"'+c_code_5
logstr += c_code % (table)
logstr += '\n\r'
logstr += ""+'\n\r'
logstr += ""+'\n\r'
logstr += "EventGhost Climate Data Calculation Graph
"+'\n\r'
logstr += "
"+'\n\r'
logstr += ""+tableId+"
"+'\n\r'
logstr += ''+'\n\r'
logstr += ""+'\n\r'
logstr += ""+'\n\r'
fName = tableId+'.html'
fileHandle = None
if not os.path.exists(fPath) and not os.path.isdir(fPath):
os.makedirs(fPath)
fileHandle = open(fPath+'/'+fName, 'a')
fileHandle.seek(0)
fileHandle.truncate()
fileHandle.write(logstr.encode('utf-8'))
fileHandle.close()