pythonmysql短信告警

#!/usr/bin/env python
#-*- coding: UTF-8 -*-
'''
author:Netsed
Created on 2013-8-26
'''
?
import MySQLdb
import sys
?
PhoneNumber=('13666666666',)
Message=sys.argv[1]
?
class Smsgate:
 def __init__(self,host="1.1.1.1",user="test",password="test",port=3306,charset="utf8",db="smsgate_cmpp"):
 self.host=host
 self.user=user
 self.password=password
 self.port=port
 self.charset=charset
 self.db=db
 try:
 self.conn=MySQLdb.connect(host=self.host,user=self.user,passwd=self.password,port=self.port,db=self.db)
 self.conn.set_character_set(self.charset)
 self.cur=self.conn.cursor()
 except MySQLdb.Error as e:
 print("Mysql Error %d: %s" % (e.args[0], e.args[1]))
?
 def sms_insert(self,usernumber,messagecontent):
 sql="INSERT INTO `send_queue` (`id`, `spnumber`, `usernumber`, `serviceid`, `messagecoding`, \
 `messagecontent`, `reserve`, `createtime`, `sendtime`, `fromserver`, `level`) VALUES \
 (NULL, '11111', '%s', 'FREE', '15', '%s', '', now(), now(), \
 'YANYAN', '4')" % (usernumber,messagecontent)
 try:
 self.cur.execute(sql)
 self.conn.commit()
 except:
 self.conn.rollback()
 def close(self):
 self.cur.close()
 self.conn.close()
?
if __name__ == '__main__':
 send = Smsgate()
 for i in PhoneNumber:
 send.sms_insert(i,Message)
 send.close()