复制代码 代码如下:

# -*- 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()