def insert_item(self, args):
try:
sql = 'replace into nd_tb_parser_item(crawl_time,item_id,position,item_name,item_price,item_sale,item_url,seller_id,seller_name,shop_url) values(%s)' % Common.aggregate(
10)
self.db.execute(sql, args)
except Exception, e:
print '# insert tb item exception:', e
def insert_parser_item_info(self, args):
try:
sql = 'replace into nd_tb_parser_item_info(crawl_time,item_id,item_name,item_price,item_sale,item_url,seller_id,seller_name,shop_id,shop_name,shop_url,brand_id,brand_name,category_id,c_begindate,c_beginhour) values(%s)' % Common.aggregate(
16)
self.db.execute(sql, args)
except Exception, e:
print '# insert tb shop item exception:', e
def insert_parser_item_info(self, args):
try:
sql = 'replace into nd_tb_parser_item_info(crawl_time,item_id,item_name,item_price,item_sale,item_url,seller_id,seller_name,shop_id,shop_name,shop_url,brand_id,brand_name,category_id,c_begindate,c_beginhour) values(%s)' % Common.aggregate(16)
self.db.execute(sql, args)
except Exception, e:
print '# insert tb shop item exception:', e
def insert_item(self, args):
try:
sql = 'replace into nd_tb_parser_item(crawl_time,item_id,position,item_name,item_price,item_sale,item_url,seller_id,seller_name,shop_url) values(%s)' % Common.aggregate(10)
self.db.execute(sql, args)
except Exception, e:
print '# insert tb item exception:', e
def insert_item(self, args):
try:
sql = 'replace into nd_brand_parser_item(crawl_time,brand_name,serie_title,item_type,item_name,item_price,item_unit,item_size,item_url,item_img_url,item_number,c_begindate,c_beginhour) values(%s)' % Common.aggregate(13)
self.brand_db.execute(sql, args)
except Exception, e:
print '# insert brand item exception:', e
