#!/usr/bin/env python
#-*- coding: utf-8 -*-
import httplib
import json
import MySQLdb
#從數(shù)據(jù)庫中獲取access_token
access_token=""
try:
  conn=MySQLdb.connect(host='192.168.1.1',user='root',passwd='root',db='db_weixin',port=3306)
  cur=conn.cursor()
  cur.execute('select access_token from weixin_public')
  result=cur.fetchone()
  #print result
  #print result[0]
  access_token=result[0]
  cur.close()
  conn.close()
except MySQLdb.Error,e:
  print "Mysql Error %d: %s" % (e.args[0], e.args[1])
#根據(jù)接口推送消息
if not access_token is None:
  conn = httplib.HTTPConnection("api.weixin.qq.com:80")#微信接口鏈接
  headers = {"Content-type":"application/json"} #application/x-www-form-urlencoded
  params = ({'touser' : "oEGZ4johnKOtayJbnEVeuaZr6zQ0",#用戶openid
  'template_id' : 'AtFuydv8k_15UGZuFntaBzJRCsHCkjNm1dcWD3A-11Y',#模板消息ID
  'url' : 'http://www.dbjr.com.cn',#跳轉(zhuǎn)鏈接
  "topcolor" : "#667F00",#顏色
  "data" : {#模板內(nèi)容
    "first" : {"value" : "尊敬的710.so : 您的網(wǎng)站http://www.dbjr.com.cn (192.168.1.1) 有異常訪問", "color" : "#173177"},
    "keyword1" : {"value" : "訪問時間 2015-04-05 15:30:59 訪問IP 192.168.1.2", "color" : "#173177"},
    "keyword2" : {"value" : "訪問鏈接 http://www.dbjr.com.cn", "color" : "#173177"},
    "remark" : {"value" : "訪問頻率 10/s", "color" : "#173177"}
    }
  }
  )
  conn.request("POST", "/cgi-bin/message/template/send?access_token="+access_token, json.JSONEncoder().encode(params), headers)#推送消息請求
  response = conn.getresponse()
  data = response.read()#推送返回數(shù)據(jù)
  if response.status == 200:
    print 'success'
    print data
  else:
    print 'fail'
  conn.close()