diff --git a/getTimeLine.py b/getTimeLine.py index b889fab..29ad11a 100644 --- a/getTimeLine.py +++ b/getTimeLine.py @@ -78,17 +78,16 @@ level_zhong_per = str(i['f81']) level_xiao = str(i['f84']) level_xiao_per = str(i['f87']) - shijian = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime((i['f124']))) + shijian = time.strftime("%Y-%m-%d %H:%M", time.localtime((i['f124']))) sql = "REPLACE INTO `t_zijinliu_gegu` " \ "(`code`, `name`, `type`, `zhangfu`, `shijian`, `level_zhuli`, `level_zhuli_per`, `level_chaoda`, " \ "`level_chaoda_per`, `level_da`, `level_da_per`, `level_zhong`, `level_zhong_per`, `level_xiao`, " \ - "`level_xiao_per`, `bankuai_code`, `bankuai_name`) VALUES " \ - "('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" % \ + "`level_xiao_per`) VALUES " \ + "('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" % \ (code, name, bkData[2], zhangfu, shijian, level_zhuli, level_zhuli_per, level_chaoda, level_chaoda_per, - level_da, level_da_per, level_zhong, level_zhong_per, level_xiao, level_xiao_per, - bkData[0], bkData[1]) + level_da, level_da_per, level_zhong, level_zhong_per, level_xiao, level_xiao_per) sqlList.append(sql)