dis_id = read_attribute_from_config_file('dis_id', config)
if start_time is None:
start_time = (datetime.now() - timedelta(days=3)).strftime('%Y-%m-%d 00:00:00')
else:
check_time_format(time=start_time)
if end_time is None:
end_time = (datetime.now() + timedelta(days=2)).strftime('%Y-%m-%d 00:00:00')
else:
check_time_format(time=end_time)
pool = get_Pool(host=con_params.CURW_SIM_HOST, port=con_params.CURW_SIM_PORT, user=con_params.CURW_SIM_USERNAME,
password=con_params.CURW_SIM_PASSWORD,
db=con_params.CURW_SIM_DATABASE)
TS = Timeseries(pool)
latest_fgt = TS.get_obs_end(dis_id)
if output_dir is None:
output_dir = os.path.join(OUTPUT_DIRECTORY, (datetime.utcnow() + timedelta(hours=5, minutes=30)).strftime('%Y-%m-%d_%H-00-00'))
if file_name is None:
file_name = 'mike_dis.txt' #.format(latest_fgt.strftime('%Y-%m-%d_%H-%M-00'))
mike_dis_file_path = os.path.join(output_dir, file_name)
if not os.path.isfile(mike_dis_file_path):
makedir_if_not_exist_given_filepath(mike_dis_file_path)
print("{} start preparing mike discharge input".format(datetime.now()))
mike_discharge = prepare_mike_dis_input(TS=TS, start=start_time, end=end_time, dis_id=dis_id)
mike_discharge.to_csv(mike_dis_file_path, header=False, index=True)
[round_to_nearest_hour(discharge_ts[k][0]), '%.3f' % float(discharge_ts[k][1])])
return processed_dis_ts
if __name__=="__main__":
try:
curw_sim_pool = get_Pool(host=CURW_SIM_HOST, user=CURW_SIM_USERNAME, password=CURW_SIM_PASSWORD,
port=CURW_SIM_PORT, db=CURW_SIM_DATABASE)
curw_fcst_pool = get_Pool(host=CURW_FCST_HOST, user=CURW_FCST_USERNAME, password=CURW_FCST_PASSWORD,
port=CURW_FCST_PORT, db=CURW_FCST_DATABASE)
TS = Timeseries(pool=curw_sim_pool)
# [station_name,latitude,longitude,target,model,version,sim_tag,station]
extract_stations = read_csv('grids/discharge_stations/flo2d_stations.csv')
for i in range(len(extract_stations)):
station_name = extract_stations[i][0]
latitude = extract_stations[i][1]
longitude = extract_stations[i][2]
target_model = extract_stations[i][3]
method = extract_stations[i][4]
meta_data = {
'latitude': float('%.6f' % float(latitude)),
'longitude': float('%.6f' % float(longitude)),
'model': target_model, 'method': method,