def write(self): table = db.Ls_unit_ele order_by = db.Ls_unit_ele.id if table.select().count() > 0: with open(self.file_name, 'w') as file: file.write(self.get_meta_line()) file.write(utils.int_pad("id")) file.write(utils.string_pad("name", direction="left")) file.write(utils.code_pad("obj_typ")) file.write(utils.int_pad("obj_typ_no")) file.write(utils.num_pad("bsn_frac")) file.write(utils.num_pad("sub_frac")) file.write(utils.num_pad("reg_frac")) file.write("\n") i = 1 for row in table.select().order_by(order_by): file.write(utils.int_pad(i)) i += 1 file.write(utils.string_pad(row.name, direction="left")) file.write(utils.code_pad(row.obj_typ)) file.write(utils.int_pad(row.obj_typ_no, default_pad=10)) file.write( utils.exp_pad(row.bsn_frac, use_non_zero_min=True)) file.write(utils.num_pad(row.sub_frac)) file.write(utils.num_pad(row.reg_frac)) file.write("\n")
def write(self): table = connect.Aquifer_con order_by = table.id if table.select().count() > 0: with open(self.file_name, 'w') as file: file.write(self.get_meta_line()) file.write(utils.int_pad("id")) file.write(utils.string_pad("name", direction="left")) file.write(utils.code_pad("obj_typ")) file.write(utils.int_pad("obj_typ_no", default_pad=10)) file.write(utils.num_pad("bsn_frac")) file.write(utils.num_pad("sub_frac")) file.write(utils.num_pad("reg_frac")) file.write("\n") tot_area = connect.Rout_unit_con.select( fn.Sum(connect.Rout_unit_con.area)).scalar() i = 1 for row in table.select().order_by(order_by): file.write(utils.int_pad(i)) file.write(utils.string_pad(row.name, direction="left")) file.write(utils.code_pad("aqu")) file.write(utils.int_pad(i, default_pad=10)) file.write( utils.num_pad(row.area / tot_area, use_non_zero_min=True)) file.write(utils.num_pad(0)) file.write(utils.num_pad(0)) file.write("\n") i += 1
def write(self): table = connect.Rout_unit_ele order_by = connect.Rout_unit_ele.id if table.select().count() > 0: with open(self.file_name, 'w') as file: file.write(self.get_meta_line()) file.write(utils.int_pad("id")) file.write(utils.string_pad("name", direction="left")) file.write(utils.code_pad("obj_typ")) file.write(utils.int_pad("obj_id")) file.write(utils.num_pad("frac")) file.write(utils.string_pad("dlr")) file.write("\n") i = 1 for row in table.select().order_by(order_by): file.write(utils.int_pad(i)) i += 1 file.write(utils.string_pad(row.name, direction="left")) file.write(utils.code_pad(row.obj_typ)) file.write(utils.int_pad(row.obj_id)) file.write(utils.exp_pad(row.frac)) file.write(utils.key_name_pad(row.dlr, text_if_null="0")) file.write("\n")
def write_row(file, con, index, con_to_index, con_outs): file.write(utils.int_pad(index)) file.write(utils.string_pad(con.name, direction="left")) file.write(utils.int_pad(con.gis_id)) file.write(utils.num_pad(con.area, use_non_zero_min=True)) file.write(utils.num_pad(con.lat)) file.write(utils.num_pad(con.lon)) file.write(utils.num_pad(con.elev)) file.write(utils.int_pad(con_to_index)) file.write(utils.string_pad("null" if con.wst is None else con.wst.name)) file.write(utils.int_pad(con.cst_id)) file.write(utils.int_pad(con.ovfl)) file.write(utils.int_pad(con.rule)) file.write(utils.int_pad(con_outs.count())) for out in con_outs: obj_id = out.obj_id elem_table = table_mapper.obj_typs.get(out.obj_typ, None) if elem_table is not None: obj_id = elem_table.select().where( elem_table.id <= out.obj_id).count() file.write(utils.code_pad(out.obj_typ)) file.write(utils.int_pad(obj_id)) file.write(utils.code_pad(out.hyd_typ)) file.write(utils.num_pad(out.frac)) file.write("\n")
def write_header(file, elem_name, has_con_out): file.write(utils.int_pad("id")) file.write(utils.string_pad("name", direction="left")) file.write(utils.int_pad("gis_id")) file.write(utils.num_pad("area")) file.write(utils.num_pad("lat")) file.write(utils.num_pad("lon")) file.write(utils.num_pad("elev")) file.write(utils.int_pad(elem_name)) file.write(utils.string_pad("wst")) file.write(utils.int_pad("cst")) file.write(utils.int_pad("ovfl")) file.write(utils.int_pad("rule")) file.write(utils.int_pad("out_tot")) if has_con_out: file.write(utils.code_pad("obj_typ")) file.write(utils.int_pad("obj_id")) file.write(utils.code_pad("hyd_typ")) file.write(utils.num_pad("frac")) file.write("\n")
def write(self): table = db.Plant_ini order_by = db.Plant_ini.id if table.select().count() > 0: with open(self.file_name, 'w') as file: file.write(self.get_meta_line()) file.write(utils.string_pad("pcom_name", direction="left")) file.write(utils.int_pad("plt_cnt")) file.write(utils.int_pad("rot_yr_ini")) file.write( utils.string_pad("plt_name", default_pad=utils.DEFAULT_KEY_PAD)) file.write(utils.code_pad("lc_status")) file.write(utils.num_pad("lai_init")) file.write(utils.num_pad("bm_init")) file.write(utils.num_pad("phu_init")) file.write(utils.num_pad("plnt_pop")) file.write(utils.num_pad("yrs_init")) file.write(utils.num_pad("rsd_init")) file.write("\n") for row in table.select().order_by(order_by): file.write(utils.string_pad(row.name, direction="left")) file.write(utils.int_pad(row.plants.count())) file.write(utils.int_pad(row.rot_yr_ini)) file.write("\n") for plant in row.plants: file.write(utils.string_pad("", text_if_null="")) file.write( utils.string_pad( "", text_if_null="", default_pad=utils.DEFAULT_INT_PAD)) file.write(utils.key_name_pad(plant.plnt_name)) utils.write_bool_yn(file, plant.lc_status) file.write(utils.num_pad(plant.lai_init)) file.write(utils.num_pad(plant.bm_init)) file.write(utils.num_pad(plant.phu_init)) file.write(utils.num_pad(plant.plnt_pop)) file.write(utils.num_pad(plant.yrs_init)) file.write(utils.num_pad(plant.rsd_init)) file.write("\n")