#coding=utf8
import sys
import json
import requests
import MySQLdb
reload(sys)
sys.setdefaultencoding('utf-8')
conn= MySQLdb.connect(
host='localhost',
port = 3306,
user='root',
passwd='root',
db ='df',
)
cur = conn.cursor()
sqli="insert into image(image_url) values(%s)"
def extract_image(resp):
o = json.loads(resp)
result = o['result']
for r in result:
#print r['image']
if(r.has_key('image')):
print r['image']
cur.execute(sqli,(r['image']))
for i in range(0,2000,10):
print i
url = 'http://www.yidianzixun.com/api/q/?path=channel|news-list-for-channel&channel_id=u241&fields=docid&fields=category&fields=date&fields=image&fields=image_urls&fields=like&fields=source&fields=title&fields=url&fields=comment_count&fields=summary&fields=up&cstart='+str(i)+'&cend='+str(i+10)+'&version=999999&infinite=true'
response = requests.get(url).text
extract_image(response)
cur.close()
conn.commit()
conn.close()