#相同的`con_deal_id`,`con_shop_id`,`dt`求和并且一些文字信息使用的是 import sqlalchemy import sql_name import datetime import pymysql from sqlalchemy.dialects.mysql import DATE import arg_del import pandas as pd import numpy as np #每周六运行 start_time,end_time,fdatabase,tdatabase=arg_del.get_attr() start_time,end_time,fdatabase,tdatabase=arg_del.set_attr_def_value(start_time,end_time,fdatabase,tdatabase) print('start_time=%s***********************,end_time=%s*****************'%(start_time,end_time)) for now_time in arg_del.week_alter(start_time,end_time): day={} day['start_time']=now_time.strftime('%Y-%m-%d') day['end_time']=(now_time+datetime.timedelta(7)).strftime('%Y-%m-%d') print('************************day=%s*************************' % day['start_time']) localhost_conn = pymysql.connect(host=fdatabase['ip'], user=fdatabase['user'], passwd=fdatabase['password'], db='o2o', charset='utf8', connect_timeout=7200 * 3, cursorclass=pymysql.cursors.DictCursor) localhost_cur = localhost_conn.cursor() localhost_cur.execute(sql_name.sql_source_meituan_and_dianping %day) datas=localhost_cur.fetchall() localhost_cur.close() localhost_conn.close() datas=pd.DataFrame(datas) datas.drop(['index','check_url'], axis=1, inplace=True)
import sqlalchemy import sql_name import datetime import pymysql from sqlalchemy.dialects.mysql import DATE import arg_del import pandas as pd import numpy as np #每周六运行 start_time, end_time, fdatabase, tdatabase = arg_del.get_attr() start_time, end_time, fdatabase, tdatabase = arg_del.set_attr_def_value( start_time, end_time, fdatabase, tdatabase) print('start_time=%s***********************,end_time=%s*****************' % (start_time, end_time)) for now_time in arg_del.week_alter(start_time, end_time): day = {} day['start_time'] = now_time.strftime('%Y-%m-%d') day['end_time'] = (now_time + datetime.timedelta(7)).strftime('%Y-%m-%d') print('************************day=%s*************************' % day['start_time']) localhost_conn = pymysql.connect(host=fdatabase['ip'], user=fdatabase['user'], passwd=fdatabase['password'], db='o2o', charset='utf8', connect_timeout=7200 * 3, cursorclass=pymysql.cursors.DictCursor) localhost_cur = localhost_conn.cursor() localhost_cur.execute(sql_name.sql_source_meituan_and_dianping % day)