def main(): topic = u'电影传送门' query = """SELECT douban_title, download_url, douban_url, lpic_url, douban_id FROM movie WHERE douban_id in (SELECT douban_id FROM movie ORDER BY random() LIMIT 1) and sended=0""" update = "UPDATE movie SET sended=1 WHERE douban_id=?" send_weibo(topic, query, update)
def main(): topic = u'电影传送门' #query = """SELECT douban_title, download_url, douban_url, lpic_url, douban_id FROM # movie WHERE douban_id=3319755 and sended=0""" query = """SELECT douban_title, download_url, douban_url, lpic_url, douban_id FROM movie WHERE douban_title='倾国之恋' and sended=0""" update = "UPDATE movie SET sended=1 WHERE douban_id=?" send_weibo(topic, query, update)
def main(): #1. save up-to-date data to database session = requests.Session() session.get(ROOT) url = 'http://strs.gdufs.edu.cn/web/VOD/vod_sourcelist.asp?Groupid=1' db = DATABASE _save_data(url, session, db) #2. send up-to-date content to sina weibo from database topic = u'最新上传' query = """select douban_title, download_url, douban_url, lpic_url, douban_id from movie_new where douban_id in (select douban_id from movie_new where upload_date in (select strftime('%Y-%m-%d', 'now')) and sended=0 order by random() limit 1);""" update = "UPDATE movie_new SET sended=1 WHERE douban_id=?" # 一天最多也就可能有8条更新吧 for i in xrange(8): send_weibo(topic, query, update)