def parse(self,response):
xxs = XmlXPathSelector(response)
citys = xxs.select('//division')
list = []
for city in citys:
list.append((
city.select('id/text()').extract()[0],
city.select('name/text()').extract()[0],
city.select('location/latitude/text()').extract()[0],
city.select('location/latitude/text()').extract()[0]
))
sql = 'insert into city_meituan (m_id,`name`,latitude,longtitude)value(%s,%s,%s,%s)'
trun = 'truncate table city_meituan'
db.batchSQL(sql=sql,list=list,trun=trun)
