def update_title_image(): source_id = 'walmart' wmt_ids = [r['id'] for r in execute("""select distinct r.retailer_id id from product_reviews r left join product_details d on r.source_id = d.source_id and r.retailer_id = d.retailer_id where r.source_id = 'walmart' and (d.title is null or d.img_url is null)""")] cq = '''select item_id, upc, img150, item_name from dotcom_products where item_id in (%s)''' % \ (', '.join(str(x) for x in wmt_ids)) data = execute_cia(cq) ins_data = [] for img_data in data: url = "#" title = img_data['item_name'] id = img_data['item_id'] if img_data['img150'] is None: upc = img_data['upc'] if upc is not None: upc_s = "%013d" % upc url = "http://i.walmartimages.com/i/p/%s/%s/%s/%s/%s/%s_150X150.jpg" % ( upc_s[0:2], upc_s[2:4], upc_s[4:6], upc_s[6:8], upc_s[8:10], upc_s) else: url = img_data['img150'] upc = img_data['upc'] ins_data.append((id, title, url, upc)) q = """insert into product_details (source_id, retailer_id, title, img_url) values %s on duplicate key update title = values(title), img_url = values(img_url) """ % (', '.join( ["('%s', '%s', '%s' , '%s')" % (escape_sql(source_id), r[0], escape_sql(r[1]), escape_sql(r[2])) for r in ins_data])) execute(q)
def update_summary(id, summary): table = 'product_reviews' q = "update %s set summary='%s' where id=%s" % (table, escape_sql(summary), id) # execute(q) return q