pyspider 存入mysql

from pyspider.libs.base_handler import *
import pymysql

class Handler(BaseHandler):
    crawl_config = {
    }

    @every(minutes=24 * 60)
    def on_start(self):
        self.crawl('http://example.com/', callback=self.index_page)

    @config(age=10 * 24 * 60 * 60)
    def index_page(self, response):
        for each in response.doc('a[href^="http"]').items():
            self.crawl(each.attr.href, callback=self.detail_page)

    def detail_page(self, response):
        data = {
            'title': response.doc('title').text(),
            'url': response.url
        }
        self.save_to_mysql(data)

    def save_to_mysql(self, data):
        conn = pymysql.connect(host='localhost', user='root', password='password', db='test')
        cursor = conn.cursor()
        sql = "INSERT INTO web_data (title, url) VALUES (%s, %s)"
        cursor.execute(sql, (data['title'], data['url']))
        conn.commit()
        cursor.close()
        conn.close()