复制代码 代码如下:
# -*- coding: UTF-8 -*-
import mysql.connector as db
import client.tWeibo
import time
if __name__ == \’__main__\’:
connect = db.connect(user=\’root\’,db=\’collection\’,password=\’\’,host=\”127.0.0.1\”)
cursor = connect.cursor()
cursor.execute(\”SET SQL_MODE = \’TRADITIONAL\’\”)
uin = \’QQ号\’
passwd = \’密码\’
wb = client.tWeibo.tWeibo(uin, passwd)
wb.login()
sqlSelectTwitter = \”SELECT `content`,`pic` FROM `collection`.`weibo_content2` ORDER BY `id` DESC LIMIT 0, 144\”
cursor.execute(sqlSelectTwitter)
for (content, pic) in cursor:
result = wb.publish(content, pic)
print(result)
print(\”暂停10分钟……\”)
time.sleep(600)
cursor.close()
connect.close()