def __init__(self): # SQLServer17数据库对象 self.sqlser_db_oper = sqlser_helper_class(conf.db_conf) # MySQL20数据库对象 self.mysql_db_oper = mysql_helper_class(conf.db_conf) # 读取偏移值 self.offset_num = 0
def deal_with_jk_price(jk_prod_id, date): '''补全健客价格''' mysql_db_oper = mysql_helper_class(conf.db_conf) sql_else = '''SELECT price FROM `wrk_comweb_hour_price` WHERE comp_id=100000 AND prod_id='%s' AND DATE_FORMAT(insert_time,'%%Y-%%m-%%d')='%s' GROUP BY comp_id, prod_id''' for day in range(1,11): current_date = time.strptime(date,'%Y-%m-%d') left_datetime = (datetime.datetime(*current_date[:3]) - datetime.timedelta(days=day)).strftime('%Y-%m-%d') right_datetime = (datetime.datetime(*current_date[:3]) - datetime.timedelta(days=-day)).strftime('%Y-%m-%d') (line_left, res_left) = mysql_db_oper.exe_search(sql_else % (jk_prod_id, left_datetime)) (line_right, res_right) = mysql_db_oper.exe_search(sql_else % (jk_prod_id, right_datetime)) if res_left and res_left[0]['price'] != 0: price = res_left[0]['price'] return price elif res_right and res_right[0]['price'] != 0: price = res_right[0]['price'] return price else: price = 0 return price date_item = datelist((2015, 12, 25), (2016, 12, 31)) mysql_db_oper = mysql_helper_class(conf.db_conf) sqlser_db_oper = sqlser_helper_class(conf.db_conf) current_date = time.strptime('2015-12-25','%Y-%m-%d') date=[322,323,324,325,326] for i in date: right_datetime = (datetime.datetime(*current_date[:3]) + datetime.timedelta(days=(i-1))).strftime('%Y-%m-%d') print right_datetime