代码如下:
# -*- coding: utf-8 -*-import mysql.connector as dbimport client.tweiboimport 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()