pythoncream 2013-11-11
代码如下:
# -*- 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()