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")