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