Python通过USB串行发送许多短信 [英] Python sending many sms via usb serial

问题描述

我现在真的迷路了，我需要向多个收件人发送短信.

I'm really lost now at this part where I need to send sms to multiple recipients.

如何向我数据库中的所有联系人发送短信?我是否使用for循环?还是还有其他方法?请帮忙，谢谢你.

How do i send an sms to all the contacts i have in my database? Do I use for-loops? Or is there other ways? Please help thank you so much.

这是我的短信代码

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import serial
import time
import sys
import MySQLdb as mdb

try:
    con = mdb.connect('localhost', 'user', 'password', 'db')
    print 'Database connected';
except Exception as e:
    sys.exit('Database connection failed')

cur = con.cursor()
cur.execute("Select contacts from dbtable")
con.commit()
number= cur.fetchall()
print number

for item in number:
    recipient= recipient+item

class TextMessage:
    def __init__(self, recipient="xxxxxxxx",message="TextMessage.content not set."):
        self.recipient = recipient
        self.content = message

    def setRecipient(self, number):
        self.recipient = number

    def setContent(self, message):
        self.content = message

    def connectPhone(self):
        self.ser = serial.Serial('/dev/ttyUSBSMS', 460800, timeout=5, xonxoff = False, rtscts = False, bytesize = serial.EIGHTBITS, parity = serial.PARITY_NONE, stopbits = serial.STOPBITS_ONE)
        time.sleep(1)

    def sendMessage(self):
        self.ser.write('ATZ\r')
        time.sleep(1)
        self.ser.write('AT+CMGF=1\r')
        time.sleep(1)
        self.ser.write('''AT+CMGS="''' + self.recipient + '''"\r''')
        time.sleep(1)
        self.ser.write(self.content + "\r")
        time.sleep(1)
        self.ser.write(chr(26))
        time.sleep(1)
     def disconnectPhone(self):
        self.ser.close()

sms = TextMessage("xxxxxxxx","Important!")
sms.connectPhone()
sms.sendMessage()
sms.disconnectPhone()
print "message sent successfully"

打印输出

(('99876545',), ('87546412',), ('97789546',), ('87546464',), ('97377454',))

推荐答案

简单的for循环即可完成工作:

A simple for loop would do the job:

t_list =  (('99876545',), ('87546412',), ('97789546',), ('87546464',), ('97377454',))

for t in t_list:
    number = t[0]
    print(number)
    # Call function to send SMS to the given `number`

只需采用这种基本方法即可满足您的需求.

Just adapt this basic approach do fulfill your needs.

这篇关于Python通过USB串行发送许多短信的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！