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 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)
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)
