def write(self): table = db.Rout_unit_rtu order_by = db.Rout_unit_rtu.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")) file.write(utils.string_pad("define")) file.write(utils.string_pad("dlr")) file.write(utils.string_pad("topo")) file.write(utils.string_pad("field")) 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)) file.write(utils.string_pad(row.name)) file.write(utils.key_name_pad(row.dlr)) file.write(utils.key_name_pad(row.topo)) file.write(utils.key_name_pad(row.field)) file.write("\n")
def write(self): table = db.Delratio_del order_by = db.Delratio_del.id if table.select().count() > 0: with open(self.file_name, 'w') as file: file.write(self.get_meta_line()) cols = [ col(table.name, direction="left"), col(table.om), col(table.pest), col(table.path), col(table.hmet), col(table.salt) ] self.write_headers(file, cols) file.write("\n") for row in table.select().order_by(order_by): file.write(utils.string_pad(row.name, direction="left")) file.write(utils.key_name_pad(row.om)) file.write(utils.key_name_pad(row.pest)) file.write(utils.key_name_pad(row.path)) file.write(utils.key_name_pad(row.hmet)) file.write(utils.key_name_pad(row.salt)) file.write("\n")
def write(self): table = db.Reservoir_res order_by = db.Reservoir_res.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.string_pad("init")) file.write(utils.string_pad("hyd")) file.write(utils.string_pad("rel")) file.write(utils.string_pad("sed")) file.write(utils.string_pad("nut")) file.write("\n") for row in table.select().order_by(order_by): file.write(utils.int_pad(row.id)) file.write(utils.string_pad(row.name, direction="left")) file.write( utils.key_name_pad(row.init, default_pad=utils.DEFAULT_STR_PAD)) file.write( utils.key_name_pad(row.hyd, default_pad=utils.DEFAULT_STR_PAD)) file.write( utils.key_name_pad(row.rel, default_pad=utils.DEFAULT_STR_PAD)) file.write( utils.key_name_pad(row.sed, default_pad=utils.DEFAULT_STR_PAD)) file.write( utils.key_name_pad(row.nut, default_pad=utils.DEFAULT_STR_PAD)) file.write("\n")
def write(self): table = db.Graze_ops order_by = db.Graze_ops.id if table.select().count() > 0: with open(self.file_name, 'w') as file: file.write(self.get_meta_line()) cols = [col(table.name, direction="left"), col(table.fert), col(table.bm_eat), col(table.bm_tramp), col(table.man_amt), col(table.grz_bm_min), col(table.description, is_desc=True)] self.write_headers(file, cols) file.write("\n") for row in table.select().order_by(order_by): file.write(utils.string_pad(row.name, direction="left")) file.write(utils.key_name_pad(row.fert)) file.write(utils.num_pad(row.bm_eat)) file.write(utils.num_pad(row.bm_tramp)) file.write(utils.num_pad(row.man_amt)) file.write(utils.num_pad(row.grz_bm_min)) utils.write_desc_string(file, row.description) file.write("\n")
def write(self): table = db.Path_hru_ini order_by = db.Path_hru_ini.id if table.select().count() > 0: with open(self.file_name, 'w') as file: file.write(self.get_meta_line()) for row in table.select().order_by(order_by): file.write( utils.string_pad("name", direction="left", default_pad=25)) file.write(utils.num_pad("plant")) file.write(utils.num_pad("soil")) file.write("\n") file.write( utils.string_pad(row.name, direction="left", default_pad=25)) file.write("\n") for item in row.path_hrus: file.write( utils.string_pad("", text_if_null="", default_pad=1)) file.write( utils.key_name_pad(item.name, default_pad=22)) file.write(utils.num_pad(item.plant)) file.write(utils.num_pad(item.soil)) file.write("\n")
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(self): table = db.Hru_data_hru order_by = db.Hru_data_hru.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.string_pad("topo")) file.write(utils.string_pad("hydro")) file.write(utils.string_pad("soil")) file.write(utils.string_pad("lu_mgt")) file.write(utils.string_pad("soil_plant_init")) file.write(utils.string_pad("surf_stor")) file.write(utils.string_pad("snow")) file.write(utils.string_pad("field")) file.write("\n") for row in table.select().order_by(order_by): file.write(utils.int_pad(row.id)) file.write(utils.string_pad(row.name, direction="left")) file.write(utils.key_name_pad(row.topo)) file.write(utils.key_name_pad(row.hydro)) file.write(utils.key_name_pad(row.soil)) file.write(utils.key_name_pad(row.lu_mgt)) file.write(utils.key_name_pad(row.soil_plant_init)) file.write(utils.key_name_pad(row.surf_stor)) file.write(utils.key_name_pad(row.snow)) file.write(utils.string_pad(row.field)) file.write("\n")
def write(self): table = db.Exco_exc order_by = db.Exco_exc.id valid_recs = Recall_dat.select(Recall_dat.recall_rec_id).join( Recall_rec).where((Recall_rec.rec_typ == 4) & (Recall_dat.flo != 0)) valid_ids = [r.recall_rec_id for r in valid_recs] recall_recs = Recall_rec.select().where(Recall_rec.id.in_(valid_ids)) #recall_recs = Recall_rec.select(Recall_rec, Recall_dat).join(Recall_dat).where((Recall_rec.rec_typ == 4) & (Recall_dat.flo != 0)) if recall_recs.count() > 0: with open(self.file_name, 'w') as file: file.write(self.get_meta_line()) cols = [ col(table.name, direction="left"), col(table.om), col(table.pest), col(table.path), col(table.hmet), col(table.salt) ] self.write_headers(file, cols) file.write("\n") """for row in table.select().order_by(order_by): file.write(utils.string_pad(row.name, direction="left")) file.write(utils.key_name_pad(row.om)) file.write(utils.key_name_pad(row.pest)) file.write(utils.key_name_pad(row.path)) file.write(utils.key_name_pad(row.hmet)) file.write(utils.key_name_pad(row.salt)) file.write("\n")""" for row in recall_recs: file.write(utils.string_pad(row.name, direction="left")) file.write(utils.string_pad(row.name)) file.write(utils.key_name_pad(None)) file.write(utils.key_name_pad(None)) file.write(utils.key_name_pad(None)) file.write(utils.key_name_pad(None)) 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")
def write(self): table = db.Exco_exc order_by = db.Exco_exc.id recall_recs = Recall_rec.select().where(Recall_rec.rec_typ == 4) if table.select().count() > 0 or recall_recs.count() > 0: with open(self.file_name, 'w') as file: file.write(self.get_meta_line()) cols = [ col(table.name, direction="left"), col(table.om), col(table.pest), col(table.path), col(table.hmet), col(table.salt) ] self.write_headers(file, cols) file.write("\n") for row in table.select().order_by(order_by): file.write(utils.string_pad(row.name, direction="left")) file.write(utils.key_name_pad(row.om)) file.write(utils.key_name_pad(row.pest)) file.write(utils.key_name_pad(row.path)) file.write(utils.key_name_pad(row.hmet)) file.write(utils.key_name_pad(row.salt)) file.write("\n") for row in recall_recs: file.write(utils.string_pad(row.name, direction="left")) file.write(utils.string_pad(row.name)) file.write(utils.key_name_pad(None)) file.write(utils.key_name_pad(None)) file.write(utils.key_name_pad(None)) file.write(utils.key_name_pad(None)) file.write("\n")
def write(self): table = db.Pest_water_ini order_by = db.Pest_water_ini.id if table.select().count() > 0: with open(self.file_name, 'w') as file: file.write(self.get_meta_line()) for row in table.select().order_by(order_by): file.write( utils.string_pad("name", direction="left", default_pad=25)) file.write(utils.num_pad("water_sol")) file.write(utils.num_pad("water_sor")) file.write(utils.num_pad("benthic_sol")) file.write(utils.num_pad("benthic_sor")) file.write("\n") file.write( utils.string_pad(row.name, direction="left", default_pad=25)) file.write("\n") for item in row.pest_waters: file.write( utils.string_pad("", text_if_null="", default_pad=1)) file.write( utils.key_name_pad(item.name, default_pad=22)) file.write(utils.num_pad(item.water_sol)) file.write(utils.num_pad(item.water_sor)) file.write(utils.num_pad(item.benthic_sol)) file.write(utils.num_pad(item.benthic_sor)) file.write("\n")
def write(self): table = db.Landuse_lum order_by = db.Landuse_lum.id if table.select().count() > 0: with open(self.file_name, 'w') as file: file.write(self.get_meta_line()) cols = [ col(table.name, padding_override=20, direction="left"), col(table.cal_group), col(table.plnt_com), col(table.mgt), col(table.cn2), col(table.cons_prac), col(table.urban), col(table.urb_ro), col(table.ov_mann), col(table.tile), col(table.sep), col(table.vfs), col(table.grww), col(table.bmp) ] self.write_headers(file, cols) file.write("\n") for row in table.select().order_by(order_by): file.write( utils.string_pad(row.name, direction="left", default_pad=20)) file.write(utils.string_pad(row.cal_group)) file.write(utils.key_name_pad(row.plnt_com)) file.write(utils.key_name_pad(row.mgt)) file.write(utils.key_name_pad(row.cn2)) file.write(utils.key_name_pad(row.cons_prac)) file.write(utils.key_name_pad(row.urban)) file.write(utils.string_pad(row.urb_ro)) file.write(utils.key_name_pad(row.ov_mann)) file.write(utils.key_name_pad(row.tile)) file.write(utils.key_name_pad(row.sep)) file.write(utils.key_name_pad(row.vfs)) file.write(utils.key_name_pad(row.grww)) file.write(utils.key_name_pad(row.bmp)) file.write("\n")
def write(self): table = db.Management_sch op_table = db.Management_sch_op mgts = table.select().order_by(table.id) ops = op_table.select().order_by(op_table.order, op_table.hu_sch, op_table.mon, op_table.day) query = prefetch(mgts, ops) if mgts.count() > 0: with open(self.file_name, 'w') as file: self.write_meta_line(file) header_cols = [ col(table.name, direction="left", padding_override=25), col("numb_ops", not_in_db=True, padding_override=utils.DEFAULT_INT_PAD), col("numb_auto", not_in_db=True, padding_override=9), col(op_table.op_typ), col(op_table.mon), col(op_table.day), col(op_table.hu_sch), col(op_table.op_data1), col(op_table.op_data2), col(op_table.op_data3) ] self.write_headers(file, header_cols) total_pad = 46 file.write("\n") for row in query: row_cols = [ col(row.name, direction="left", padding_override=25), col(len(row.operations)), col(len(row.auto_ops), padding_override=9) ] self.write_row(file, row_cols) file.write("\n") special_tables = [ 'pl_hv_summer1', 'pl_hv_summer2', 'pl_hv_winter1' ] for aop in row.auto_ops: file.write(utils.string_pad(" ", default_pad=total_pad)) file.write(utils.key_name_pad(aop.d_table)) if aop.d_table.name in special_tables: file.write( utils.string_pad(aop.plant1, default_pad=5)) if aop.d_table.name == special_tables[1]: file.write( utils.string_pad(aop.plant2, default_pad=5)) file.write("\n") skip_op = 'skip' for op in row.operations: op_row_cols = [ col(" ", padding_override=total_pad), col(op.op_typ), col(op.mon if op.op_typ != skip_op else 0), col(op.day if op.op_typ != skip_op else 0), col(op.hu_sch if op.op_typ != skip_op else 0), col(op.op_data1), col(op.op_data2), col(op.op_data3) ] self.write_row(file, op_row_cols) file.write("\n")