python 生成html文件

这次要写一个脚本，做一个web汇报页面，利用到的PyH这个库，这个库用来生成html文件，wiki在这里 http://code.google.com/p/pyh/wiki/UserManual，很简单的一个库，弄清关系以后很好使用，我只了解最基本的html，其中还有一部分CSS是朋友代劳，目前已经基本实现了，脚本应该可以优化，老大催的紧，先搞出结果再说 包含2部分，先贴下css的，很简单的小文件，common.css(实在懒得看这玩意)

点击(此处)折叠或打开

1. tr{ white-space:0;}
   
2. .table0{border:none;width:100%;}
   
3. .table0_td{padding:0 0px 0px 0;}
   
4. .table1 {border-collapse:collapse;width:100%;}
   
5. .table1 td{ height:30px; border:#333333 solid 1px;text-align:center;width:25%}

python脚本WeekReport.py 

点击(此处)折叠或打开

1. #!/usr/bin/python
   
2. #coding:utf-8
   
3. from pyh import  *
   
4. import MySQLdb
   
5. import datetime
   
6. 
   
7. class Getdata:
   
8.     def __init__(self):
   
9.         self.conn=MySQLdb.connect(host='urhost',db='urdb',user='user',passwd='urpass')
   
10.         self.cur=self.conn.cursor()
    
11. 
    
12.     def getdata(self):
    
13.         D={} #main 字典
    
14.         d={} #临时字典
    
15.         now=datetime.date.today()
    
16.         delta=datetime.timedelta(days=7)
    
17.         lastnow=now-delta
    
18. 
    
19.         load='''
    
20.         select a.f_name as project,c.avgload,c.f_date from t_project a,t_department b,
    
21.         (select f_project_id,(sum(f_avg_load)/count(*)) as avgload,f_date from t_load_daily where f_date=date_add(curdate(),interval -7 day) group by f_project_id,f_date order by f_date) c
    
22.         where c.f_project_id=a.f_pro_id and a.f_depart_id=b.f_depart_id union all select a.f_name as project,c.avgload,c.f_date from t_project a,t_department b,(select f_project_id,(sum(f_avg_load)/count(*)) as avgload,f_date from t_load_daily where f_date=date(now()) group by f_project_id,f_date order by f_date) c
    
23.         where c.f_project_id=a.f_pro_id and a.f_depart_id=b.f_depart_id
    
24.         '''
    
25.         idc='''
    
26.         select b.f_name as project,c.num,c.f_date from t_department a,t_project b,
    
27.         (select f_depart_id,f_project_id,sum(f_flow_num) as num ,f_date from t_flows where f_type=3 and f_date=date(now()) group by f_project_id,f_date) c
    
28.         where c.f_depart_id=a.f_depart_id and c.f_project_id=b.f_pro_id union all select b.f_name as project,c.num,c.f_date from t_department a,t_project b,(select f_depart_id,f_project_id,sum(f_flow_num) as num ,f_date from t_flows where f_type=3 and f_date=date_add(curdate(),interval -7 day)
    
29.         group by f_project_id,f_date) c where c.f_depart_id=a.f_depart_id and c.f_project_id=b.f_pro_id;
    
30.         '''
    
31. 
    
32.         cdn='''
    
33.         select b.f_name as project,c.num,c.f_date from t_department a,t_project b,
    
34.         (select f_depart_id,f_project_id,sum(f_flow_num) as num ,f_date from t_flows where f_type=2 and f_date=date_add(curdate(),interval -7 day)
    
35.         group by f_project_id,f_date) c where c.f_depart_id=a.f_depart_id and c.f_project_id=b.f_pro_id union all select b.f_name as project,c.num,c.f_date from t_department a,t_project b,(select f_depart_id,f_project_id,sum(f_flow_num) as num ,f_date from t_flows where f_type=2 and f_date=date(now()) group by f_project_id,f_date) c
    
36.         where c.f_depart_id=a.f_depart_id and c.f_project_id=b.f_pro_id
    
37.         '''
    
38.         dau='''
    
39.         select f_name,num,date from t_project a,
    
40.         (select f_project_id as id ,sum(f_num) as num,f_date as date from t_dau where f_date=date(now()) group by f_project_id) b
    
41.         where a.f_pro_id=b.id union all select f_name,num,date from t_project a,
    
42.         (select f_project_id as id ,sum(f_num) as num,f_date as date from t_dau where f_date=date_add(curdate(),interval -7 day)
    
43.         group by f_project_id) b where a.f_pro_id=b.id
    
44.         '''
    
45.         srvsum='''
    
46.         select f_name,num,date from t_project a,
    
47.         (select f_project_id as id,sum(f_costing_num) as num,f_date as date from t_costing_daily where f_costing_type=1 and f_date=date_add(curdate(),interval -7 day) group by f_project_id) b where a.f_pro_id=b.id
    
48.         union all select f_name,num,date from t_project a,(select f_project_id as id,sum(f_costing_num) as num,f_date as date from t_costing_daily where f_costing_type=1 and f_date=date(now()) group by f_project_id) b where a.f_pro_id=b.id
    
49.         '''
    
50.         self.cur.execute(srvsum)
    
51.         rows=self.cur.fetchall()
    
52. 
    
53.         for row in rows:
    
54.             try:
    
55.                 d[row[0]]=d[row[0]]+row[1::] # 数据合并汇总
    
56.             except KeyError,e:
    
57.                 d[row[0]]=row[1::]
    
58. 
    
59.         for k,v in d.items():
    
60.             a=[]
    
61.             m=list(v)
    
62.             if now in v:
    
63.                 a.append(m[m.index(now)-1])
    
64.             else:
    
65.                 a.append(0)
    
66.             if lastnow in v:
    
67.                 a.append(m[m.index(lastnow)-1])
    
68.             else:
    
69.                 a.append(0)
    
70.             D[k]={'num':a}
    
71.         ###
    
72.         d={} ##置空字典
    
73.         self.cur.execute(load)
    
74.         rows=self.cur.fetchall()
    
75.         for row in rows:
    
76.             try:
    
77.                 d[row[0]]=d[row[0]]+row[1::] # 数据合并汇总
    
78.             except KeyError,e:
    
79.                 d[row[0]]=row[1::]
    
80.         for k,v in d.items():
    
81.             a=[]
    
82.             m=list(v)
    
83.             if now in v:
    
84.                 a.append(m[m.index(now)-1])
    
85.             else:
    
86.                 a.append(0)
    
87.             if lastnow in v:
    
88.                 a.append(m[m.index(lastnow)-1])
    
89.             else:
    
90.                 a.append(0)
    
91.             D[k]['load']=a
    
92. 
    
93.         ####
    
94.         d={}
    
95.         self.cur.execute(cdn)
    
96.         rows=self.cur.fetchall()
    
97.         for row in rows:
    
98.             try:
    
99.                 d[row[0]]=d[row[0]]+row[1::] # 数据合并汇总
    
100.             except KeyError,e:
     
101.                 d[row[0]]=row[1::]
     
102.         for k,v in d.items():
     
103.             a=[]
     
104.             m=list(v)
     
105.             if now in v:
     
106.                 a.append(m[m.index(now)-1])
     
107.             else:
     
108.                 a.append(0)
     
109.             if lastnow in v:
     
110.                 a.append(m[m.index(lastnow)-1])
     
111.             else:
     
112.                 a.append(0)
     
113.             D[k]['cdn']=a
     
114. 
     
115.         ####
     
116.         d={}
     
117.         self.cur.execute(idc)
     
118.         rows=self.cur.fetchall()
     
119.         for row in rows:
     
120.             try:
     
121.                 d[row[0]]=d[row[0]]+row[1::] # 数据合并汇总
     
122.             except KeyError,e:
     
123.                 d[row[0]]=row[1::]
     
124.         for k,v in d.items():
     
125.             a=[]
     
126.             m=list(v)
     
127.             if now in v:
     
128.                 a.append(m[m.index(now)-1])
     
129.             else:
     
130.                 a.append(0)
     
131.             if lastnow in v:
     
132.                 a.append(m[m.index(lastnow)-1])
     
133.             else:
     
134.                 a.append(0)
     
135.             D[k]['idc']=a
     
136. 
     
137.         ####
     
138.         d={}
     
139.         self.cur.execute(dau)
     
140.         rows=self.cur.fetchall()
     
141.         for row in rows:
     
142.             try:
     
143.                 d[row[0]]=d[row[0]]+row[1::] # 数据合并汇总
     
144.             except KeyError,e:
     
145.                 d[row[0]]=row[1::]
     
146.         for k,v in d.items():
     
147.             a=[]
     
148.             m=list(v)
     
149.             if now in v:
     
150.                 a.append(m[m.index(now)-1])
     
151.             else:
     
152.                 a.append(0)
     
153.             if lastnow in v:
     
154.                 a.append(m[m.index(lastnow)-1])
     
155.             else:
     
156.                 a.append(0)
     
157.             D[k]['dau']=a
     
158. 
     
159.         return D
     
160. 
     
161. 
     
162. 
     
163. 
     
164. 
     
165. 
     
166. 
     
167. class ToHtml:
     
168.     '''
     
169.        此类主要用来生成html文件
     
170. 
     
171.     '''
172. 
     
173.     def str3tocoma(self,num):#每三个数字加一个逗号
     
174.         e = list(str(num))
     
175.         if len(e)<=3:
     
176.            return num
     
177.         else:
     
178.            for i in range(len(e))[::-3][1:]:
     
179.                e.insert(i+1,",")
     
180.            return "".join(e)
     
181. 
     
182.     def Gentable(self,pro,data):
     
183.         def k(x,y):
     
184.             try:
     
185.                return float(x-y)/float(y)
     
186.             except ZeroDivisionError:
     
187.                return 0
     
188.         t=table(caption='%s' % pro,border="1",cl="table1",cellpadding="0",cellspacing="0")
     
189.         t<<tr(td('%s' % pro,bgColor='#0099ff')+td('当前数据')+td('上周同比数据')+td('上周同比百分比'))
     
190.         if data.has_key('dau'):
     
191.             N=k(data.get('dau')[0],data.get('dau')[1])
     
192.             if N>0.3: 
     
193.                 t<<tr(td('DAU')+td(self.str3tocoma(data.get('dau')[0]))+td(self.str3tocoma(data.get('dau')[1]))+td("%5.2F%%"% (N*100),bgColor='#ff0000'))
     
194.             elif N<0:
     
195.                 t<<tr(td('DAU')+td(self.str3tocoma(data.get('dau')[0]))+td(self.str3tocoma(data.get('dau')[1]))+td("%5.2f%%"% (N*100),bgColor='#00ff00'))
     
196.             else:
     
197.                 t<<tr(td('DAU')+td(self.str3tocoma(data.get('dau')[0]))+td(self.str3tocoma(data.get('dau')[1]))+td("%5.2f%%"% (N*100)))
     
198.                 
     
199.         else:
     
200.             t<<tr(td('DAU')+td(0)+td(0)+td(0))
     
201.         if data.has_key('load'):
     
202.             N=k(data.get('load')[0],data.get('load')[1])
     
203.             if N>0.2: 
     
204.                 t<<tr(td('负载')+td(data.get('load')[0])+td(data.get('load')[1])+td("%5.2F%%" % (N*100),bgColor='#ff0000'))
     
205.             elif N<0:
     
206.                 t<<tr(td('负载')+td(data.get('load')[0])+td(data.get('load')[1])+td("%5.2F%%" % (N*100),bgColor='#00ff00'))
     
207.             else:
     
208.                 t<<tr(td('负载')+td(self.str3tocoma(data.get('load')[0]))+td(self.str3tocoma(data.get('load')[1]))+td("%5.2F%%" % (N*100)))
     
209.         else:
     
210.             t<<tr(td('负载')+td(0)+td(0)+td(0))
     
211.         if data.has_key('num'):
     
212.             N=k(data.get('num')[0],data.get('num')[1])
     
213.             if N>0.2:
     
214.                 t<<tr(td('服务器数量')+td(data.get('num')[0])+td(data.get('num')[1])+td("%5.2F%%" % (N*100),bgColor='#ff0000'))
     
215.             elif N<0:
     
216.                 t<<tr(td('服务器数量')+td(data.get('num')[0])+td(data.get('num')[1])+td("%5.2F%%" % (N*100),bgColor='#00ff00'))
     
217.             else:
     
218.                 t<<tr(td('服务器数量')+td(data.get('num')[0])+td(data.get('num')[1])+td("%5.2F%%" % (N*100)))
     
219.         else:
     
220.             t<<tr(td('服务器数量')+td(0)+td(0)+td(0))
     
221.         if data.has_key('cdn'):
     
222.             N=k(data.get('num')[0],data.get('num')[1])
     
223.             if N>0.3:
     
224.                 t<<tr(td('CDN流量')+td(data.get('cdn')[0])+td(data.get('cdn')[0])+td("%5.2F%%" % (N*100),bgColor='#ff0000'))
     
225.             elif N<0:
     
226.                 t<<tr(td('CDN流量')+td(data.get('cdn')[0])+td(data.get('cdn')[0])+td("%5.2F%%" % (N*100),bgColor='#00ff00'))
     
227.             else:
     
228.                 t<<tr(td('CDN流量')+td(data.get('cdn')[0])+td(data.get('cdn')[0])+td("%5.2F%%" % (N*100)))
     
229.         else:
     
230.             t<<tr(td('CDN流量')+td(0)+td(0)+td(0))
     
231.         if data.has_key('idc'):
     
232.             N=k(data.get('num')[0],data.get('num')[1])
     
233.             if N>0.3:
     
234.                 t<<tr(td('IDC流量')+td(data.get('idc')[0])+td(data.get('idc')[0])+td("%5.2F%%" % (N*100),bgColor='#ff0000'))
     
235.             elif N<0:
     
236.                 t<<tr(td('IDC流量')+td(data.get('idc')[0])+td(data.get('idc')[0])+td("%5.2F%%" % (N*100),bgColor='#00ff00'))
     
237.             else:
     
238.                 t<<tr(td('IDC流量')+td(data.get('idc')[0])+td(data.get('idc')[0])+td("%5.2F%%" % (N*100)))
     
239.         else: 
     
240.             t<<tr(td('IDC流量')+td(0)+td(0)+td(0))
     
241.         return t
     
242. 
     
243. 
     
244.     def Tohtml(self,tables):
     
245.         page=PyH('本周报告')
     
246.         page.addCSS('common.css')
     
247.         page<<h1('本周报告',align='center')
     
248.         tab=table(cellpadding="0",cellspacing="0",cl="table0")
     
249.         for t in range(0,len(tables),2):
     
250.             tab<<tr(td(tables[t-1],cl="table0_td")+td(tables[t],cl="table0_td"))
     
251.         page<<tab
     
252.         page.printOut()
     
253. 
     
254. if __name__=="__main__":
     
255.     I=Getdata()
     
256.     d=I.getdata()
     
257.     tabrows=[]
     
258.     h=ToHtml()
     
259.     for k,v in d.items():
     
260.         t=h.Gentable(k,v)
     
261.         tabrows.append(t)
     
262.     h.Tohtml(tabrows)

最后插入图片一张：