def __init__(self):
dbconfig = {
'host':'localhost',
'port': 3306,
'user':'******',
'passwd':'111111',
'db':'sport',
'charset':'utf8'
}
self._db = MySQL(dbconfig)
class SportPipeline(object):
_db = None
def __init__(self):
dbconfig = {
'host': 'localhost',
'port': 3306,
'user': '******',
'passwd': '123123',
'db': 'testdj',
'charset': 'utf8'
}
self._db = MySQL(dbconfig)
def process_item(self, item, spider):
insert_sql = "INSERT INTO calc_blogphoto (guid,title,source_url,user_id,remote_images_paths,local_images_paths,remote_default_image,local_default_image) VALUES ('%s','%s','%s',%d,'%s','%s','%s','%s')" % (
'aaaa', db_charset_to_utf8(item['title'][0]), item['source_url'],
item['user_id'], '3', '33', '22', '13')
id = self._db.insert(insert_sql)
print('============================')
print(id)
print('============================')
return item
class SportPipeline(object):
_db = None
def __init__(self):
dbconfig = {
'host':'localhost',
'port': 3306,
'user':'******',
'passwd':'111111',
'db':'sport',
'charset':'utf8'
}
self._db = MySQL(dbconfig)
def process_item(self, item, spider):
insert_sql = "INSERT INTO sport_schedule(home_team,guest_team,home_logo,guest_logo,match_date,game_type) values \
('%s','%s','%s','%s','%s','%s')" % (item['home_team'], item['guest_team'], item['home_logo'],\
item['guest_logo'], item['match_date'], item['game_type'])
self._db.insert(insert_sql)
return item
