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