pym = mysql(host='#####', port=3306, user='######',
            password='########', database='algorithm')

#查询数据

charge_sql = 'SELECT log_date, campaign_id, campaign_name,roi,ad_pv,click,charge,ecpc,ecpm,avg_access_page_num,alipay_inshop_amt FROM zuanshi.report_campaign_day  ' \
             'WHERE account_id={0} AND campaign_model=1 AND effect=15 AND effect_type="impression" and log_date in {1}'.format(
    accountId, tuple(li))

campaign_data = pym.Query(charge_sql)

#保存数据

pym.my_keep(campaign_data ,'campaign_data ')