#!/usr/bin/env python # -*- coding:utf-8 -*- # @FileName :data_nwp_ftp.py # @Time :2024/12/26 08:38 # @Author :David # @Company: shenyang JY from datetime import timedelta from ftplib import FTP import threading, glob, pytz import pandas as pd from pytz import timezone from flask import Flask,request,jsonify import time, datetime, os, traceback, re import zipfile, tempfile, shutil, fnmatch from common.database_dml import insert_data_into_mongo from apscheduler.schedulers.background import BackgroundScheduler from common.logs import Log logger = Log('data-processing').logger app = Flask('data_nwp_ftp——service') def update_thread(): thread = threading.Thread(target=start_jobs) thread.start() def start_jobs(): scheduler = BackgroundScheduler() scheduler.configure({'timezone': timezone("Asia/Shanghai")}) scheduler.add_job(func=download_zip_files_from_ftp, trigger="interval", seconds=900) scheduler.start() def match_date(date, filename): given_date = datetime.datetime.strptime(date, '%Y%m%d') date_pattern = re.compile(r'(\d{8})') match = date_pattern.search(filename) if match: filename_str = match.group(0) filename_date = datetime.datetime.strptime(filename_str, '%Y%m%d') if filename_date <= given_date: return True def delete_zip_files(date): xxl_path = ftp_params['xxl']['local_dir'] # 遍历文件夹中的所有文件 for root, dirs, files in os.walk(xxl_path): for filename in files: # 检查文件名是否以 'meteo_date_' 开头且以 '.zip' 结尾 if fnmatch.fnmatch(filename, f'*.zip') and match_date(date, filename): # 构建文件的完整路径 file_path = os.path.join(xxl_path, filename) # 删除文件 try: os.remove(file_path) print(f"Deleted file: {file_path}") except OSError as e: print(f"Error deleting file {file_path}: {e.strerror}") for farmId in dirs: target_dir_path = os.path.join(root, farmId) for file_name in os.listdir(target_dir_path): csv_file_path = os.path.join(target_dir_path, file_name) if fnmatch.fnmatch(csv_file_path, f'*.csv') and match_date(date, file_name): try: os.remove(csv_file_path) print(f"Deleted file: {csv_file_path}") except OSError as e: print(f"Error deleting file {csv_file_path}: {e.strerror}") def get_moment_next(schedule_dt=False): if schedule_dt: now = datetime.datetime.strptime(str(schedule_dt), '%Y-%m-%d %H:%M:%S') else: now = datetime.datetime.now(pytz.utc).astimezone(timezone("Asia/Shanghai")) if now.hour == 18: moment = '18' elif now.hour > 18: moment = '00' elif now.hour == 12: moment = '12' elif now.hour > 12: moment = '18' elif now.hour == 6: moment = '06' elif now.hour > 6: moment = '12' elif 2 >= now.hour >= 0: moment = '00' else: moment = '06' return moment def get_moment(schedule_dt=False): if schedule_dt: now = datetime.datetime.strptime(str(schedule_dt), '%Y-%m-%d %H:%M:%S') else: now = datetime.datetime.now(pytz.utc).astimezone(timezone("Asia/Shanghai")) if now.hour >= 18: moment = '18' elif now.hour >= 12: moment = '12' elif now.hour >= 6: moment = '06' else: moment = '00' return moment def download_zip_files_from_ftp(moment=None): now = datetime.datetime.now(pytz.utc).astimezone(timezone("Asia/Shanghai")) date = now.strftime("%Y%m%d") date_2 = (now - timedelta(days=2)).strftime("%Y%m%d") if moment is None: moment = get_moment_next() host = 'xxl' ftp_host, ftp_user, ftp_password, remote_dir, local_dir = ftp_params[host]['host'], ftp_params[host]['user'], ftp_params[host]['password'], ftp_params[host]['remote_dir'], ftp_params['xxl']['local_dir'] zip_extension = f'meteoforce_{date}{str(moment)}_*.zip' zip_file_path = [] # 连接到FTP服务器 with FTP(ftp_host) as ftp: ftp.login(user=ftp_user, passwd=ftp_password) # 切换到远程目录 ftp.cwd(remote_dir) # 获取远程目录中的文件和目录列表 files = ftp.nlst() # 遍历文件列表，找到ZIP文件并下载 for file_name in files: if fnmatch.fnmatch(file_name, zip_extension): remote_file_path = os.path.join(remote_dir, file_name) local_file_path = os.path.join(local_dir, file_name) if os.path.isfile(local_file_path): continue with open(local_file_path, 'wb') as local_file: logger.info(f"Downloading {remote_file_path} to {local_file_path}") ftp.retrbinary(f'RETR {remote_file_path}', local_file.write) logger.info(f"Downloaded {file_name}") zip_file_path.append(local_file_path) # 解压 ZIP 文件到临时目录 for zip_file_p in zip_file_path: with zipfile.ZipFile(zip_file_p, 'r') as zip_ref: zip_ref.extractall(local_dir) # 删除前天之前所有 ZIP 文件 delete_zip_files(date_2) def select_file_to_mongo(args): date, moment, farmId, isDq = args['dt'], get_moment_next(args['dt']), args['farmId'], args['isDq'] date = datetime.datetime.strptime(date, '%Y-%m-%d %H:%M:%S').strftime("%Y%m%d") csv_file_format = 'meteoforce_{}_{}_*.csv'.format(farmId, date + str(moment)) csv_file_weather = csv_file_format.replace('*', 'weather') csv_file_power = csv_file_format.replace('*', 'power') csv_weather_path, csv_power_path = False, False # 查找目标目录并读取 CSV 文件 for root, dirs, files in os.walk(ftp_params['xxl']['local_dir']): if farmId in dirs: target_dir_path = os.path.join(root, farmId) for file_name in os.listdir(target_dir_path): csv_file_path = os.path.join(target_dir_path, file_name) if fnmatch.fnmatch(file_name, csv_file_weather): csv_weather_path = csv_file_path logger.info("找到nwp:{}".format(csv_weather_path)) if fnmatch.fnmatch(file_name, csv_file_power): csv_power_path = csv_file_path logger.info("找到power:{}".format(csv_power_path)) if csv_weather_path or csv_power_path: break if csv_weather_path is False: raise ValueError("获取nwp文件异常:找不到文件") # 使用 pandas 读取 CSV 文件 weather = pd.read_csv(csv_weather_path) power = pd.read_csv(csv_power_path) if csv_power_path else None if isDq: if csv_weather_path and csv_power_path: power.drop(columns=['farm_id'], inplace=True) weather_power = pd.merge(weather, power, on='date_time') # 截取D0-D13时段数据 df = select_dx_from_nwp(weather_power, args) insert_data_into_mongo(df, args) else: df = select_dx_from_nwp(weather, args) insert_data_into_mongo(df, args) logger.info(f"CSV 文件 {csv_file_power} 或 {csv_file_weather} 在目标目录 {farmId} 中未找到") else: if csv_weather_path: weather = select_dx_from_nwp(weather, args) # 截取D0-D13时段数据 df = select_dx_from_nwp(weather, args) insert_data_into_mongo(df, args) else: logger.info(f"CSV 文件 {csv_file_weather} 在目标目录 {farmId} 中未找到") def select_dx_from_nwp(df, args): date = datetime.datetime.strptime(args['dt'], '%Y-%m-%d %H:%M:%S') date_begin = date + pd.Timedelta(days=int(args.get('day_begin', 'D0')[1:])) date_end = date + pd.Timedelta(days=int(args.get('day_end', 'D13')[1:])) df['date_time'] = df['date_time'].str.replace("_", " ") df['date_time'] = pd.to_datetime(df['date_time']) df.set_index('date_time', inplace=True) df = df.loc[date_begin.strftime('%Y-%m-%d'): date_end.strftime('%Y-%m-%d')].reset_index(drop=False) df.reset_index(drop=True, inplace=True) df['date_time'] = df['date_time'].dt.strftime('%Y-%m-%d %H:%M:%S') return df # 示例使用 ftp_params = { 'xxl' : { 'host' : '39.107.246.215', 'user' : 'jiayue', 'password' : 'JYoguf2018', 'remote_dir' : './', 'local_dir': 'data_processing/cache/data/xxl' } } @app.route('/data_nwp_ftp', methods=['POST']) def get_nwp_from_ftp(): # 获取程序开始时间 start_time = time.time() result = {} success = 0 args = {} # print("data_nwp_ftp starts execution!") try: now = datetime.datetime.now(pytz.utc).astimezone(timezone("Asia/Shanghai")).strftime('%Y-%m-%d %H:%M:%S') args = request.values.to_dict() if args.get('dt') is None: args['dt'] = now # 1. 获取参数：日期，数据源，时刻，D0-9，场站ID，存储的 mongo 和表 # print('args', args) logger.info(args) # 2. 连接FTP，从FTP服务器中获取指定参数的压缩文件（定时任务） # 3. 解压压缩文件，将其存储到mongo中 select_file_to_mongo(args) success = 1 except Exception as e: my_exception = traceback.format_exc() my_exception.replace("\n", "\t") result['msg'] = my_exception logger.info("生产，获取原始nwp出错：{}".format(my_exception)) end_time = time.time() result['success'] = success result['args'] = args result['start_time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(start_time)) result['end_time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(end_time)) # print("Program execution ends!") return result if __name__ == "__main__": print("Program starts execution!") from waitress import serve update_thread() #定时任务开启 current_hour = '06' # 默认首次运行下载06时刻的zip threading.Thread(target=download_zip_files_from_ftp, kwargs={'moment': current_hour}).start() serve(app, host="0.0.0.0", port=10102) print("server start!") # args = {"source": 'xxl', "date": '2024-12-27', 'moment': '06', 'farmId': 'J00645', # 'mongodb_database': 'db2', 'mongodb_write_table': 'j00645-d1', 'day_begin':'D0', # 'day_end': 'D13', 'isDq': True} # download_zip_files_from_ftp(hour='06') # select_file_to_mongo(args) # delete_zip_files('20241225')