def export_csv(self):
if self.table_name in dtl_names:
decision_table.D_table_dtl(self.file_name,
file_type=self.table_name).write()
elif self.table_name == 'mgt_sch':
lum.Management_sch(self.file_name).write()
else:
ignored_cols = []
initial_headers = []
custom_query = None
if self.table_name == 'rec_dat':
ignored_cols.append('recall_rec')
custom_query = self.table.select().where(
self.table.recall_rec_id == self.related_id)
elif self.table_name == 'rec_cnst':
ignored_cols.append('recall_rec')
ignored_cols.append('yr')
ignored_cols.append('t_step')
initial_headers.append('name')
custom_query = Recall_dat.select(
Recall_rec.name,
Recall_dat).join(Recall_rec).where(Recall_rec.rec_typ == 4)
try:
fileio.write_csv(self.file_name,
self.table,
ignore_id_col=self.ignore_id_col,
ignored_cols=ignored_cols,
custom_query=custom_query,
initial_headers=initial_headers)
except PermissionError:
sys.exit(
'Permission error. Please check to make sure the file is not open.'
)
def import_csv(self): if self.table_name == 'rec_dat': recall.Recall_rec(self.file_name).read_data(self.related_id, self.delete_existing, self.rec_typ) elif self.table_name == 'rec_cnst': recall.Recall_rec(self.file_name).read_const_data() elif self.table_name in dtl_names: decision_table.D_table_dtl(self.file_name, file_type=self.table_name).read() elif self.table_name == 'mgt_sch': lum.Management_sch(self.file_name).read() else: fileio.read_csv_file(self.file_name, self.table, project_base.db, 0, ignore_id_col=self.ignore_id_col, overwrite=fileio.FileOverwrite.replace, remove_spaces_cols=['name'])
def write_decision_table(self, start_prog, allocated_prog):
num_files = 4
files = self.get_file_names("decision_table", num_files)
prog_step = round(allocated_prog / num_files)
prog = start_prog
lum_dtl_file = files[0].strip()
if lum_dtl_file != NULL_FILE:
self.update_file_status(start_prog, lum_dtl_file)
decision_table.D_table_dtl(os.path.join(self.__dir, lum_dtl_file),
self.__version,
self.__swat_version).write()
prog += prog_step
res_rel_dtl_file = files[1].strip()
if res_rel_dtl_file != NULL_FILE:
self.update_file_status(prog, res_rel_dtl_file)
decision_table.D_table_dtl(
os.path.join(self.__dir, res_rel_dtl_file), self.__version,
self.__swat_version).write()
prog += prog_step
scen_lu_dtl_file = files[2].strip()
if scen_lu_dtl_file != NULL_FILE:
self.update_file_status(prog, scen_lu_dtl_file)
decision_table.D_table_dtl(
os.path.join(self.__dir, scen_lu_dtl_file), self.__version,
self.__swat_version).write()
prog += prog_step
flo_con_dtl_file = files[3].strip()
if flo_con_dtl_file != NULL_FILE:
self.update_file_status(prog, flo_con_dtl_file)
decision_table.D_table_dtl(
os.path.join(self.__dir, flo_con_dtl_file), self.__version,
self.__swat_version).write()
def initialize_data(version: str = None):
codes = [
{'table': 'connect', 'variable': 'obj_typ', 'code': 'hru', 'description': 'hru'},
{'table': 'connect', 'variable': 'obj_typ', 'code': 'hlt', 'description': 'hru_lte'},
{'table': 'connect', 'variable': 'obj_typ', 'code': 'ru', 'description': 'routing unit'},
{'table': 'connect', 'variable': 'obj_typ', 'code': 'mfl', 'description': 'modflow'},
{'table': 'connect', 'variable': 'obj_typ', 'code': 'aqu', 'description': 'aquifer'},
{'table': 'connect', 'variable': 'obj_typ', 'code': 'cha', 'description': 'channel'},
{'table': 'connect', 'variable': 'obj_typ', 'code': 'res', 'description': 'reservoir'},
{'table': 'connect', 'variable': 'obj_typ', 'code': 'rec', 'description': 'recall'},
{'table': 'connect', 'variable': 'obj_typ', 'code': 'exc', 'description': 'export coefficients'},
{'table': 'connect', 'variable': 'obj_typ', 'code': 'dr', 'description': 'delivery ratio'},
{'table': 'connect', 'variable': 'obj_typ', 'code': 'out', 'description': 'outlet'},
{'table': 'connect', 'variable': 'obj_typ', 'code': 'sdc', 'description': 'swat-deg channel'},
{'table': 'connect', 'variable': 'hyd_typ', 'code': 'tot', 'description': 'total flow'},
{'table': 'connect', 'variable': 'hyd_typ', 'code': 'rhg', 'description': 'recharge'},
{'table': 'connect', 'variable': 'hyd_typ', 'code': 'sur', 'description': 'surface'},
{'table': 'connect', 'variable': 'hyd_typ', 'code': 'lat', 'description': 'lateral'},
{'table': 'connect', 'variable': 'hyd_typ', 'code': 'til', 'description': 'tile'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'plnt', 'description': 'plant'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'harv', 'description': 'harvest only'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'kill', 'description': 'kill'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'hvkl', 'description': 'harvest and kill'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'till', 'description': 'tillage'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'irrm', 'description': 'irrigation'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'fert', 'description': 'fertilizer'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'pest', 'description': 'pesticide application'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'graz', 'description': 'grazing'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'burn', 'description': 'burn'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'swep', 'description': 'street sweep'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'prtp', 'description': 'print plant vars'},
{'table': 'management_sch', 'variable': 'op_typ', 'code': 'skip', 'description': 'skip to end of the year'}
]
with base.db.atomic():
if version is not None:
definitions.Version.create(value=version)
definitions.Tropical_bounds.insert(north=18, south=-18).execute()
"""if definitions.Var_code.select().count() < 1:
definitions.Var_code.insert_many(codes).execute()"""
if basin.Codes_bsn.select().count() < 1:
files_basin.Codes_bsn(source_data_path + 'codes.bsn').read('datasets')
if basin.Parameters_bsn.select().count() < 1:
files_basin.Parameters_bsn(source_data_path + 'parameters.bsn').read('datasets')
if change.Cal_parms_cal.select().count() < 1:
files_change.Cal_parms_cal(source_data_path + 'cal_parms.cal').read('datasets')
if hru_parm_db.Plants_plt.select().count() < 1:
files_parmdb.Plants_plt(source_data_path + 'plants.plt').read('datasets')
if hru_parm_db.Fertilizer_frt.select().count() < 1:
files_parmdb.Fertilizer_frt(source_data_path + 'fertilizer.frt').read('datasets')
if hru_parm_db.Tillage_til.select().count() < 1:
files_parmdb.Tillage_til(source_data_path + 'tillage.til').read('datasets')
if hru_parm_db.Pesticide_pst.select().count() < 1:
files_parmdb.Pesticide_pst(source_data_path + 'pesticide.pst').read('datasets')
if hru_parm_db.Urban_urb.select().count() < 1:
files_parmdb.Urban_urb(source_data_path + 'urban.urb').read('datasets')
if hru_parm_db.Septic_sep.select().count() < 1:
files_parmdb.Septic_sep(source_data_path + 'septic.sep').read('datasets')
if hru_parm_db.Snow_sno.select().count() < 1:
files_parmdb.Snow_sno(source_data_path + 'snow.sno').read('datasets')
if lum.Cntable_lum.select().count() < 1:
files_lum.Cntable_lum(source_data_path + 'cntable.lum').read('datasets')
if lum.Ovn_table_lum.select().count() < 1:
files_lum.Ovn_table_lum(source_data_path + 'ovn_table.lum').read('datasets')
if lum.Cons_prac_lum.select().count() < 1:
files_lum.Cons_prac_lum(source_data_path + 'cons_practice.lum').read('datasets')
if ops.Graze_ops.select().count() < 1:
files_ops.Graze_ops(source_data_path + 'graze.ops').read('datasets')
if ops.Harv_ops.select().count() < 1:
files_ops.Harv_ops(source_data_path + 'harv.ops').read('datasets')
if ops.Fire_ops.select().count() < 1:
files_ops.Fire_ops(source_data_path + 'fire.ops').read('datasets')
if ops.Irr_ops.select().count() < 1:
files_ops.Irr_ops(source_data_path + 'irr.ops').read('datasets')
if ops.Sweep_ops.select().count() < 1:
files_ops.Sweep_ops(source_data_path + 'sweep.ops').read('datasets')
if ops.Chem_app_ops.select().count() < 1:
files_ops.Chem_app_ops(source_data_path + 'chem_app.ops').read('datasets')
if structural.Bmpuser_str.select().count() < 1:
files_str.Bmpuser_str(source_data_path + 'bmpuser.str').read('datasets')
if structural.Filterstrip_str.select().count() < 1:
files_str.Filterstrip_str(source_data_path + 'filterstrip.str').read('datasets')
if structural.Grassedww_str.select().count() < 1:
files_str.Grassedww_str(source_data_path + 'grassedww.str').read('datasets')
if structural.Septic_str.select().count() < 1:
files_str.Septic_str(source_data_path + 'septic.str').read('datasets')
if structural.Tiledrain_str.select().count() < 1:
files_str.Tiledrain_str(source_data_path + 'tiledrain.str').read('datasets')
if decision_table.D_table_dtl.select().count() < 1:
files_dtable.D_table_dtl(source_data_path + 'lum.dtl').read('datasets')
files_dtable.D_table_dtl(source_data_path + 'res_rel.dtl').read('datasets')
files_dtable.D_table_dtl(source_data_path + 'scen_lu.dtl').read('datasets')
files_dtable.D_table_dtl(source_data_path + 'flo_con.dtl').read('datasets')
if soils.Soils_lte_sol.select().count() < 1:
files_soils.Soils_lte_sol(source_data_path + 'soils_lte.sol').read('datasets')
"""if lum.Management_sch.select().count() < 1:
files_lum.Management_sch(source_data_path + 'management.sch').read('datasets')"""
classifications = [
{'id': 1, 'name': 'simulation'},
{'id': 2, 'name': 'basin'},
{'id': 3, 'name': 'climate'},
{'id': 4, 'name': 'connect'},
{'id': 5, 'name': 'channel'},
{'id': 6, 'name': 'reservoir'},
{'id': 7, 'name': 'routing_unit'},
{'id': 8, 'name': 'hru'},
{'id': 9, 'name': 'exco'},
{'id': 10, 'name': 'recall'},
{'id': 11, 'name': 'dr'},
{'id': 12, 'name': 'aquifer'},
{'id': 13, 'name': 'herd'},
{'id': 14, 'name': 'water_rights'},
{'id': 15, 'name': 'link'},
{'id': 16, 'name': 'hydrology'},
{'id': 17, 'name': 'structural'},
{'id': 18, 'name': 'hru_parm_db'},
{'id': 19, 'name': 'ops'},
{'id': 20, 'name': 'lum'},
{'id': 21, 'name': 'chg'},
{'id': 22, 'name': 'init'},
{'id': 23, 'name': 'soils'},
{'id': 24, 'name': 'decision_table'},
{'id': 25, 'name': 'regions'},
{'id': 26, 'name': 'pcp_path'},
{'id': 27, 'name': 'tmp_path'},
{'id': 28, 'name': 'slr_path'},
{'id': 29, 'name': 'hmd_path'},
{'id': 30, 'name': 'wnd_path'}
]
file_cio = [
{'classification': 1, 'order_in_class': 1, 'default_file_name': 'time.sim', 'database_table': 'time_sim', 'is_core_file': True},
{'classification': 1, 'order_in_class': 2, 'default_file_name': 'print.prt', 'database_table': 'print_prt', 'is_core_file': True},
{'classification': 1, 'order_in_class': 3, 'default_file_name': 'object.prt', 'database_table': 'object_prt', 'is_core_file': False},
{'classification': 1, 'order_in_class': 4, 'default_file_name': 'object.cnt', 'database_table': 'object_cnt', 'is_core_file': True},
{'classification': 1, 'order_in_class': 5, 'default_file_name': 'constituents.cs', 'database_table': 'constituents_cs', 'is_core_file': False},
{'classification': 2, 'order_in_class': 1, 'default_file_name': 'codes.bsn', 'database_table': 'codes_bsn', 'is_core_file': True},
{'classification': 2, 'order_in_class': 2, 'default_file_name': 'parameters.bsn', 'database_table': 'parameters_bsn', 'is_core_file': True},
{'classification': 3, 'order_in_class': 1, 'default_file_name': 'weather-sta.cli', 'database_table': 'weather_sta_cli', 'is_core_file': True},
{'classification': 3, 'order_in_class': 2, 'default_file_name': 'weather-wgn.cli', 'database_table': 'weather_wgn_cli', 'is_core_file': True},
{'classification': 3, 'order_in_class': 3, 'default_file_name': 'wind-dir.cli', 'database_table': 'wind_dir_cli', 'is_core_file': False},
{'classification': 3, 'order_in_class': 4, 'default_file_name': 'pcp.cli', 'database_table': 'weather_file', 'is_core_file': True},
{'classification': 3, 'order_in_class': 5, 'default_file_name': 'tmp.cli', 'database_table': 'weather_file', 'is_core_file': True},
{'classification': 3, 'order_in_class': 6, 'default_file_name': 'slr.cli', 'database_table': 'weather_file', 'is_core_file': True},
{'classification': 3, 'order_in_class': 7, 'default_file_name': 'hmd.cli', 'database_table': 'weather_file', 'is_core_file': True},
{'classification': 3, 'order_in_class': 8, 'default_file_name': 'wnd.cli', 'database_table': 'weather_file', 'is_core_file': True},
{'classification': 3, 'order_in_class': 9, 'default_file_name': 'atmodep.cli', 'database_table': 'atmodep_cli', 'is_core_file': False},
{'classification': 4, 'order_in_class': 1, 'default_file_name': 'hru.con', 'database_table': 'hru_con', 'is_core_file': True},
{'classification': 4, 'order_in_class': 2, 'default_file_name': 'hru-lte.con', 'database_table': 'hru_lte_con', 'is_core_file': False},
{'classification': 4, 'order_in_class': 3, 'default_file_name': 'rout_unit.con', 'database_table': 'rout_unit_con', 'is_core_file': True},
{'classification': 4, 'order_in_class': 4, 'default_file_name': 'modflow.con', 'database_table': 'modflow_con', 'is_core_file': False},
{'classification': 4, 'order_in_class': 5, 'default_file_name': 'aquifer.con', 'database_table': 'aquifer_con', 'is_core_file': True},
{'classification': 4, 'order_in_class': 6, 'default_file_name': 'aquifer2d.con', 'database_table': 'aquifer2d_con', 'is_core_file': False},
{'classification': 4, 'order_in_class': 7, 'default_file_name': 'channel.con', 'database_table': 'channel_con', 'is_core_file': True},
{'classification': 4, 'order_in_class': 8, 'default_file_name': 'reservoir.con', 'database_table': 'reservoir_con', 'is_core_file': True},
{'classification': 4, 'order_in_class': 9, 'default_file_name': 'recall.con', 'database_table': 'recall_con', 'is_core_file': True},
{'classification': 4, 'order_in_class': 10, 'default_file_name': 'exco.con', 'database_table': 'exco_con', 'is_core_file': False},
{'classification': 4, 'order_in_class': 11, 'default_file_name': 'delratio.con', 'database_table': 'delratio_con', 'is_core_file': False},
{'classification': 4, 'order_in_class': 12, 'default_file_name': 'outlet.con', 'database_table': 'outlet_con', 'is_core_file': True},
{'classification': 4, 'order_in_class': 13, 'default_file_name': 'chandeg.con', 'database_table': 'chandeg_con', 'is_core_file': False},
{'classification': 5, 'order_in_class': 1, 'default_file_name': 'initial.cha', 'database_table': 'initial_cha', 'is_core_file': True},
{'classification': 5, 'order_in_class': 2, 'default_file_name': 'channel.cha', 'database_table': 'channel_cha', 'is_core_file': True},
{'classification': 5, 'order_in_class': 3, 'default_file_name': 'hydrology.cha', 'database_table': 'hydrology_cha', 'is_core_file': True},
{'classification': 5, 'order_in_class': 4, 'default_file_name': 'sediment.cha', 'database_table': 'sediment_cha', 'is_core_file': True},
{'classification': 5, 'order_in_class': 5, 'default_file_name': 'nutrients.cha', 'database_table': 'nutrients_cha', 'is_core_file': True},
{'classification': 5, 'order_in_class': 6, 'default_file_name': 'channel-lte.cha', 'database_table': 'channel_lte_cha', 'is_core_file': False},
{'classification': 5, 'order_in_class': 7, 'default_file_name': 'hyd-sed-lte.cha', 'database_table': 'hyd_sed_lte_cha', 'is_core_file': False},
{'classification': 5, 'order_in_class': 8, 'default_file_name': 'temperature.cha', 'database_table': 'temperature_cha', 'is_core_file': False},
{'classification': 6, 'order_in_class': 1, 'default_file_name': 'initial.res', 'database_table': 'initial_res', 'is_core_file': True},
{'classification': 6, 'order_in_class': 2, 'default_file_name': 'reservoir.res', 'database_table': 'reservoir_res', 'is_core_file': True},
{'classification': 6, 'order_in_class': 3, 'default_file_name': 'hydrology.res', 'database_table': 'hydrology_res', 'is_core_file': True},
{'classification': 6, 'order_in_class': 4, 'default_file_name': 'sediment.res', 'database_table': 'sediment_res', 'is_core_file': True},
{'classification': 6, 'order_in_class': 5, 'default_file_name': 'nutrients.res', 'database_table': 'nutrients_res', 'is_core_file': True},
{'classification': 6, 'order_in_class': 6, 'default_file_name': 'weir.res', 'database_table': 'weir_res', 'is_core_file': False},
{'classification': 6, 'order_in_class': 7, 'default_file_name': 'wetland.wet', 'database_table': 'wetland_wet', 'is_core_file': False},
{'classification': 6, 'order_in_class': 8, 'default_file_name': 'hydrology.wet', 'database_table': 'hydrology_wet', 'is_core_file': False},
{'classification': 7, 'order_in_class': 1, 'default_file_name': 'rout_unit.def', 'database_table': '', 'is_core_file': True},
{'classification': 7, 'order_in_class': 2, 'default_file_name': 'rout_unit.ele', 'database_table': 'rout_unit_ele', 'is_core_file': True},
{'classification': 7, 'order_in_class': 3, 'default_file_name': 'rout_unit.rtu', 'database_table': 'rout_unit_rtu', 'is_core_file': True},
{'classification': 7, 'order_in_class': 4, 'default_file_name': 'rout_unit.dr', 'database_table': 'rout_unit_dr', 'is_core_file': False},
{'classification': 8, 'order_in_class': 1, 'default_file_name': 'hru-data.hru', 'database_table': 'hru_data_hru', 'is_core_file': True},
{'classification': 8, 'order_in_class': 2, 'default_file_name': 'hru-lte.hru', 'database_table': 'hru_lte_hru', 'is_core_file': False},
{'classification': 9, 'order_in_class': 1, 'default_file_name': 'exco.exc', 'database_table': 'exco_exc', 'is_core_file': False},
{'classification': 9, 'order_in_class': 2, 'default_file_name': 'exco_om.exc', 'database_table': 'exco_om_exc', 'is_core_file': False},
{'classification': 9, 'order_in_class': 3, 'default_file_name': 'exco_pest.exc', 'database_table': 'exco_pest_exc', 'is_core_file': False},
{'classification': 9, 'order_in_class': 4, 'default_file_name': 'exco_path.exc', 'database_table': 'exco_path_exc', 'is_core_file': False},
{'classification': 9, 'order_in_class': 5, 'default_file_name': 'exco_hmet.exc', 'database_table': 'exco_hmet_exc', 'is_core_file': False},
{'classification': 9, 'order_in_class': 6, 'default_file_name': 'exco_salt.exc', 'database_table': 'exco_salt_exc', 'is_core_file': False},
{'classification': 10, 'order_in_class': 1, 'default_file_name': 'recall.rec', 'database_table': 'recall_rec', 'is_core_file': True},
{'classification': 11, 'order_in_class': 1, 'default_file_name': 'delratio.del', 'database_table': 'delratio_del', 'is_core_file': False},
{'classification': 11, 'order_in_class': 2, 'default_file_name': 'dr_om.del', 'database_table': 'dr_om_exc', 'is_core_file': False},
{'classification': 11, 'order_in_class': 3, 'default_file_name': 'dr_pest.del', 'database_table': 'dr_pest_del', 'is_core_file': False},
{'classification': 11, 'order_in_class': 4, 'default_file_name': 'dr_path.del', 'database_table': 'dr_path_del', 'is_core_file': False},
{'classification': 11, 'order_in_class': 5, 'default_file_name': 'dr_hmet.del', 'database_table': 'dr_hmet_del', 'is_core_file': False},
{'classification': 11, 'order_in_class': 6, 'default_file_name': 'dr_salt.del', 'database_table': 'dr_salt_del', 'is_core_file': False},
{'classification': 12, 'order_in_class': 1, 'default_file_name': 'initial.aqu', 'database_table': 'initial_aqu', 'is_core_file': True},
{'classification': 12, 'order_in_class': 2, 'default_file_name': 'aquifer.aqu', 'database_table': 'aquifer_aqu', 'is_core_file': True},
{'classification': 13, 'order_in_class': 1, 'default_file_name': 'animal.hrd', 'database_table': 'animal_hrd', 'is_core_file': False},
{'classification': 13, 'order_in_class': 2, 'default_file_name': 'herd.hrd', 'database_table': 'herd_hrd', 'is_core_file': False},
{'classification': 13, 'order_in_class': 3, 'default_file_name': 'ranch.hrd', 'database_table': 'ranch_hrd', 'is_core_file': False},
{'classification': 14, 'order_in_class': 1, 'default_file_name': 'define.wro', 'database_table': 'define_wro', 'is_core_file': False},
{'classification': 14, 'order_in_class': 2, 'default_file_name': 'element.wro', 'database_table': 'element_wro', 'is_core_file': False},
{'classification': 14, 'order_in_class': 3, 'default_file_name': 'water_rights.wro', 'database_table': 'water_rights_wro', 'is_core_file': False},
{'classification': 15, 'order_in_class': 1, 'default_file_name': 'chan-surf.lin', 'database_table': 'chan_surf_lin', 'is_core_file': False},
{'classification': 15, 'order_in_class': 2, 'default_file_name': 'chan-aqu.lin', 'database_table': 'chan_aqu_lin', 'is_core_file': False},
{'classification': 16, 'order_in_class': 1, 'default_file_name': 'hydrology.hyd', 'database_table': 'hydrology_hyd', 'is_core_file': True},
{'classification': 16, 'order_in_class': 2, 'default_file_name': 'topography.hyd', 'database_table': 'topography_hyd', 'is_core_file': True},
{'classification': 16, 'order_in_class': 3, 'default_file_name': 'field.fld', 'database_table': 'field_fld', 'is_core_file': True},
{'classification': 17, 'order_in_class': 1, 'default_file_name': 'tiledrain.str', 'database_table': 'tiledrain_str', 'is_core_file': True},
{'classification': 17, 'order_in_class': 2, 'default_file_name': 'septic.str', 'database_table': 'septic_str', 'is_core_file': False},
{'classification': 17, 'order_in_class': 3, 'default_file_name': 'filterstrip.str', 'database_table': 'filterstrip_str', 'is_core_file': True},
{'classification': 17, 'order_in_class': 4, 'default_file_name': 'grassedww.str', 'database_table': 'grassedww_str', 'is_core_file': True},
{'classification': 17, 'order_in_class': 5, 'default_file_name': 'bmpuser.str', 'database_table': 'bmpuser_str', 'is_core_file': False},
{'classification': 18, 'order_in_class': 1, 'default_file_name': 'plants.plt', 'database_table': 'plants_plt', 'is_core_file': True},
{'classification': 18, 'order_in_class': 2, 'default_file_name': 'fertilizer.frt', 'database_table': 'fertilizer_frt', 'is_core_file': True},
{'classification': 18, 'order_in_class': 3, 'default_file_name': 'tillage.til', 'database_table': 'tillage_til', 'is_core_file': True},
{'classification': 18, 'order_in_class': 4, 'default_file_name': 'pesticide.pst', 'database_table': 'pesticide_pst', 'is_core_file': False},
{'classification': 18, 'order_in_class': 5, 'default_file_name': 'pathogens.pth', 'database_table': 'pathogens_pth', 'is_core_file': False},
{'classification': 18, 'order_in_class': 6, 'default_file_name': 'metals.mtl', 'database_table': 'metals_mtl', 'is_core_file': False},
{'classification': 18, 'order_in_class': 7, 'default_file_name': 'salts.slt', 'database_table': 'salts_slt', 'is_core_file': False},
{'classification': 18, 'order_in_class': 8, 'default_file_name': 'urban.urb', 'database_table': 'urban_urb', 'is_core_file': True},
{'classification': 18, 'order_in_class': 9, 'default_file_name': 'septic.sep', 'database_table': 'septic_sep', 'is_core_file': False},
{'classification': 18, 'order_in_class': 10, 'default_file_name': 'snow.sno', 'database_table': 'snow_sno', 'is_core_file': True},
{'classification': 19, 'order_in_class': 1, 'default_file_name': 'harv.ops', 'database_table': 'harv_ops', 'is_core_file': True},
{'classification': 19, 'order_in_class': 2, 'default_file_name': 'graze.ops', 'database_table': 'graze_ops', 'is_core_file': True},
{'classification': 19, 'order_in_class': 3, 'default_file_name': 'irr.ops', 'database_table': 'irr_ops', 'is_core_file': True},
{'classification': 19, 'order_in_class': 4, 'default_file_name': 'chem_app.ops', 'database_table': 'chem_app_ops', 'is_core_file': False},
{'classification': 19, 'order_in_class': 5, 'default_file_name': 'fire.ops', 'database_table': 'fire_ops', 'is_core_file': True},
{'classification': 19, 'order_in_class': 6, 'default_file_name': 'sweep.ops', 'database_table': 'sweep_ops', 'is_core_file': False},
{'classification': 20, 'order_in_class': 1, 'default_file_name': 'landuse.lum', 'database_table': 'landuse_lum', 'is_core_file': True},
{'classification': 20, 'order_in_class': 2, 'default_file_name': 'management.sch', 'database_table': 'management_sch', 'is_core_file': True},
{'classification': 20, 'order_in_class': 3, 'default_file_name': 'cntable.lum', 'database_table': 'cntable_lum', 'is_core_file': True},
{'classification': 20, 'order_in_class': 4, 'default_file_name': 'cons_practice.lum', 'database_table': 'cons_practice_lum', 'is_core_file': True},
{'classification': 20, 'order_in_class': 5, 'default_file_name': 'ovn_table.lum', 'database_table': 'ovn_table_lum', 'is_core_file': True},
{'classification': 21, 'order_in_class': 1, 'default_file_name': 'cal_parms.cal', 'database_table': 'cal_parms_cal', 'is_core_file': False},
{'classification': 21, 'order_in_class': 2, 'default_file_name': 'calibration.cal', 'database_table': 'calibration_cal', 'is_core_file': False},
{'classification': 21, 'order_in_class': 3, 'default_file_name': 'codes.sft', 'database_table': 'codes_sft', 'is_core_file': False},
{'classification': 21, 'order_in_class': 4, 'default_file_name': 'wb_parms.sft', 'database_table': 'wb_parms_sft', 'is_core_file': False},
{'classification': 21, 'order_in_class': 5, 'default_file_name': 'water_balance.sft', 'database_table': 'water_balance_sft', 'is_core_file': False},
{'classification': 21, 'order_in_class': 6, 'default_file_name': 'ch_sed_budget.sft', 'database_table': 'ch_sed_budget_sft', 'is_core_file': False},
{'classification': 21, 'order_in_class': 7, 'default_file_name': 'ch_sed_parms.sft', 'database_table': 'ch_sed_parms_sft', 'is_core_file': False},
{'classification': 21, 'order_in_class': 8, 'default_file_name': 'plant_parms.sft', 'database_table': 'plant_parms_sft', 'is_core_file': False},
{'classification': 21, 'order_in_class': 9, 'default_file_name': 'plant_gro.sft', 'database_table': 'plant_gro_sft', 'is_core_file': False},
{'classification': 22, 'order_in_class': 1, 'default_file_name': 'plant.ini', 'database_table': 'plant_ini', 'is_core_file': False},
{'classification': 22, 'order_in_class': 2, 'default_file_name': 'soil_plant.ini', 'database_table': 'soil_plant_ini', 'is_core_file': True},
{'classification': 22, 'order_in_class': 3, 'default_file_name': 'om_water.ini', 'database_table': 'om_water_ini', 'is_core_file': True},
{'classification': 22, 'order_in_class': 4, 'default_file_name': 'pest_hru.ini', 'database_table': 'pest_hru_ini', 'is_core_file': True},
{'classification': 22, 'order_in_class': 5, 'default_file_name': 'pest_water.ini', 'database_table': 'pest_water_ini', 'is_core_file': True},
{'classification': 22, 'order_in_class': 6, 'default_file_name': 'path_hru.ini', 'database_table': 'path_hru_ini', 'is_core_file': True},
{'classification': 22, 'order_in_class': 7, 'default_file_name': 'path_water.ini', 'database_table': 'path_water_ini', 'is_core_file': True},
{'classification': 22, 'order_in_class': 8, 'default_file_name': 'hmet_hru.ini', 'database_table': 'hmet_hru_ini', 'is_core_file': True},
{'classification': 22, 'order_in_class': 9, 'default_file_name': 'hmet_water.ini', 'database_table': 'hmet_water_ini', 'is_core_file': True},
{'classification': 22, 'order_in_class': 10, 'default_file_name': 'salt_hru.ini', 'database_table': 'salt_hru_ini', 'is_core_file': True},
{'classification': 22, 'order_in_class': 11, 'default_file_name': 'salt_water.ini', 'database_table': 'salt_water_ini', 'is_core_file': True},
{'classification': 23, 'order_in_class': 1, 'default_file_name': 'soils.sol', 'database_table': 'soils_sol', 'is_core_file': True},
{'classification': 23, 'order_in_class': 2, 'default_file_name': 'nutrients.sol', 'database_table': 'nutrients_sol', 'is_core_file': True},
{'classification': 23, 'order_in_class': 3, 'default_file_name': 'soils_lte.sol', 'database_table': 'soils_lte_sol', 'is_core_file': True},
{'classification': 24, 'order_in_class': 1, 'default_file_name': 'lum.dtl', 'database_table': 'lum_dtl', 'is_core_file': True},
{'classification': 24, 'order_in_class': 2, 'default_file_name': 'res_rel.dtl', 'database_table': 'res_rel_dtl', 'is_core_file': True},
{'classification': 24, 'order_in_class': 3, 'default_file_name': 'scen_lu.dtl', 'database_table': 'scen_lu_dtl', 'is_core_file': True},
{'classification': 24, 'order_in_class': 4, 'default_file_name': 'flo_con.dtl', 'database_table': 'flo_con_dtl', 'is_core_file': True},
{'classification': 25, 'order_in_class': 1, 'default_file_name': 'ls_unit.ele', 'database_table': 'ls_unit_ele', 'is_core_file': True},
{'classification': 25, 'order_in_class': 2, 'default_file_name': 'ls_unit.def', 'database_table': 'ls_unit_def', 'is_core_file': True},
{'classification': 25, 'order_in_class': 3, 'default_file_name': 'ls_reg.ele', 'database_table': 'ls_reg_ele', 'is_core_file': False},
{'classification': 25, 'order_in_class': 4, 'default_file_name': 'ls_reg.def', 'database_table': 'ls_reg_def', 'is_core_file': False},
{'classification': 25, 'order_in_class': 5, 'default_file_name': 'ls_cal.reg', 'database_table': 'ls_cal_reg', 'is_core_file': False},
{'classification': 25, 'order_in_class': 6, 'default_file_name': 'ch_catunit.ele', 'database_table': 'ch_catunit_ele', 'is_core_file': False},
{'classification': 25, 'order_in_class': 7, 'default_file_name': 'ch_catunit.def', 'database_table': 'ch_catunit_def', 'is_core_file': False},
{'classification': 25, 'order_in_class': 8, 'default_file_name': 'ch_reg.def', 'database_table': 'ch_reg_def', 'is_core_file': False},
{'classification': 25, 'order_in_class': 9, 'default_file_name': 'aqu_catunit.ele', 'database_table': 'aqu_catunit_ele', 'is_core_file': False},
{'classification': 25, 'order_in_class': 10, 'default_file_name': 'aqu_catunit.def', 'database_table': 'aqu_catunit_def', 'is_core_file': False},
{'classification': 25, 'order_in_class': 11, 'default_file_name': 'aqu_reg.def', 'database_table': 'aqu_reg_def', 'is_core_file': False},
{'classification': 25, 'order_in_class': 12, 'default_file_name': 'res_catunit.ele', 'database_table': 'res_catunit_ele', 'is_core_file': False},
{'classification': 25, 'order_in_class': 13, 'default_file_name': 'res_catunit.def', 'database_table': 'res_catunit_def', 'is_core_file': False},
{'classification': 25, 'order_in_class': 14, 'default_file_name': 'res_reg.def', 'database_table': 'res_reg_def', 'is_core_file': False},
{'classification': 25, 'order_in_class': 15, 'default_file_name': 'rec_catunit.ele', 'database_table': 'rec_catunit_ele', 'is_core_file': False},
{'classification': 25, 'order_in_class': 16, 'default_file_name': 'rec_catunit.def', 'database_table': 'rec_catunit_def', 'is_core_file': False},
{'classification': 25, 'order_in_class': 17, 'default_file_name': 'rec_reg.def', 'database_table': 'rec_reg_def', 'is_core_file': False}
]
print_prt_objects = [
{'name': 'basin_wb', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'basin_nb', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'basin_ls', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'basin_pw', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'basin_aqu', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'basin_res', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'basin_cha', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'basin_sd_cha', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'basin_psc', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'region_wb', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'region_nb', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'region_ls', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'region_pw', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'region_aqu', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'region_res', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'region_cha', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'region_sd_cha', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'region_psc', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'lsunit_wb', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'lsunit_nb', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'lsunit_ls', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'lsunit_pw', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'hru_wb', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'hru_nb', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'hru_ls', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'hru_pw', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'hru-lte_wb', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'hru-lte_nb', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'hru-lte_ls', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'hru-lte_pw', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'channel', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'channel_sd', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'aquifer', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'reservoir', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'recall', 'daily': False, 'monthly': False, 'yearly': True, 'avann': False},
{'name': 'hyd', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'ru', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False},
{'name': 'pest', 'daily': False, 'monthly': False, 'yearly': False, 'avann': False}
]
with base.db.atomic():
if definitions.File_cio_classification.select().count() < 1:
definitions.File_cio_classification.insert_many(classifications).execute()
if definitions.File_cio.select().count() < 1:
definitions.File_cio.insert_many(file_cio).execute()
if definitions.Print_prt.select().count() < 1:
definitions.Print_prt.create(
nyskip=1,
day_start=0,
day_end=0,
yrc_start=0,
yrc_end=0,
interval=1,
csvout=False,
dbout=False,
cdfout=False,
soilout=False,
mgtout=False,
hydcon=False,
fdcout=False
)
if definitions.Print_prt_object.select().count() < 1:
definitions.Print_prt_object.insert_many(print_prt_objects).execute()
if lum.Landuse_lum.select().count() < 1:
SetupDatasetsDatabase.insert_lum()
"""if definitions.Var_range.select().count() < 1: