Pythonmysql SMS alert

Recently, it was found that it was a little unreliable to receive emails and then send text messages via China Unicom mail. The company had a text message gateway, so it wrote a python script and nagios called the script to send text messages. #! Usrbinenvpython #-*-coding: UTF-8-*-author: NetsedCreatedon2013-8-26? ImportMySQLdbimportsys? PhoneNumber

Recently, it was found that it was a little unreliable to receive emails and then send text messages via China Unicom mail. The company had a text message gateway, so it wrote a python script and nagios called the script to send text messages. #! /Usr/bin/env python #-*-coding: UTF-8-*-''' author: NetsedCreated on '''? Import MySQLdbimport sys? PhoneNumber =

Recently, it was found that it was a little unreliable to receive emails and then send text messages via China Unicom mail. The company had a text message gateway, so it wrote a python script and nagios called the script to send text messages.

#!/usr/bin/env python#-*- coding: UTF-8 -*-'''author:NetsedCreated on 2013-8-26'''?import MySQLdbimport 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()

Brief description: The company's SMS gateway is relatively simple to use. As long as several SMS queues are inserted to mysql in a fixed format, the SMS Gateway Program will automatically scan the queue. This script only needs to insert the content to the queue.

Original article address: SMS alert for python mysql. Thank you for sharing it with me.