[JavaScript] python分析postfix邮件日志的状态

#!/usr/bin/env python-- coding: utf-8 --
import re
import threading
import MySQLdb
import datetime,time
def Gainid(log):
#mail id re
mailid = re.compile(r'\w{11}\:')
list_id = []
for line in log:
    m  = mailid.search(line)
    if m is not None:
      list_id.append(m.group().strip(':'))
    else:
      continue
  return list(set(list_id))

m = re.search(mailid,line)
    if m is not None:
      mailre = re.compile(r'[^\._-][\w\.-]+@(?:[A-Za-z0-9]+\.)+[A-Za-z]+')
      timere = re.compile(r'^\w+\s+\d+\s\d{2}\:\d{2}:\d{2}')
      nt = timere.search(line)
      mtime = nt.group()
      n = mailre.search(line)
      if n is not None:
        f = re.search(r'from\=',line)
        t = re.search(r'to\=',line)
        if f is not None:
          fmail = n.group().strip('<')
        if t is not None:
          tmail = n.group().strip('<')
          for  key in sdict:
            statre = re.search(key,line)
            if statre is not None:
              status = sdict [key]
            else:
              pass
          print ("id: %s date :%s  |frdr: %s |  todr: %s | status: %s" % (mailid,mtime ,fmail,tmail,status))
          ttime = fromttime(mtime)  
          sql = "insert into mailtest values('%s','%s','%s','%s','%s')" % (mailid,ttime ,fmail,tmail,status)      
          insertmail(sql)

else:
      continue

conn=MySQLdb.connect(host='localhost',user='root',passwd='',port=3306,db='mailawst')
    cur = conn.cursor()
  cur.execute(sql)
    cur.close()
  conn.commit()
    conn.close()
  except MySQLdb.Error,e:
    print "Mysql Error %d: %s" % (e.args[0],e.args[1])

HandleLog(log,mailid[i])

#logfile = "/data/maillog/mail.log.20140516"
  main(logfile)</pre>WEB 展现通过apahce+php：<pre class="brush:php;toolbar:false">&lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8"&gt;

if ($field->name=="mailid")
    {
    echo "<td> "."邮件ID"." </td>";  }
    if ($field->name=="sendtime")
    {
    echo "<td> "."发送时间"." </td>";  }
    if ($field->name=="fromaddress")
    {
    echo "<td> "."邮件发送者"." </td>";  }
    if ($field->name=="toaddress")
    {
    echo "<td> "."邮件接收者"." </td>";  }
    if ($field->name=="status")
    {
    echo "<td> "."邮件发送结果"." </td>";  }

while($rows = mysql_fetch_row($resultq))
    {//使用while遍历所有记录，并显示在表格的tr中
        echo "<tr bgcolor=#CC9999>";
        for($i = 0; $i < count($rows); $i++)
        echo "<td> ".$rows[$i]."</td>";
       $flag++;
    }
    echo "</tr></table>";
    if ($flag == 0)
    echo "<table align=center bgcolor=#cc3366 >没有找到合适的记录</table>";

while($rows = mysql_fetch_row($result)){
    //使用while遍历所有记录，并显示在表格的tr中  
        echo "<tr bgcolor=#CC9999>";
        for($i = 0; $i < count($rows); $i++)
        echo "<td> ".$rows[$i]."</td>";
    }
    echo "</tr></table>";