Python get_attr Examples

Example #1

File: source_from_meituan_and_dianping.py Project: qingfengliu/python_study

#相同的`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)

Example #2

#相同的`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()