Used to fix the field renames in QGEP project (prefix in views)

qgep_project_prefix.sh

#!/usr/bin/env bash

REACH_START=9358
REACH_END=12307

WS_START=12308
WS_END=14472

echo "a"

gsed -i -r "${REACH_START},${REACH_END} s/\bslope_per_mill\b/_slope_per_mill/g" qgep_en.qgs
#git add qgep_en.qgs && git commit -m "reach slope per mill"

X=(function_hierarchic connection_type function_hydraulic jetting_interval pipe_length usage_current usage_planned)
for x in "${X[@]}"; do
  gsed -i  -r "${REACH_START},${REACH_END} s@\b${x}\b@ch_${x}@g" qgep_en.qgs
  #git add qgep_en.qgs && git commit -m "reach ${x} => ch_${x}"
done

echo "b"

git add qgep_en.qgs && git commit -m "prefix for reach"

X=(accessibility contract_section financing gross_costs inspection_interval location_name records renovation_necessity replacement_value rv_base_year rv_construction_type status structure_condition subsidies year_of_construction year_of_replacement fk_owner fk_operator)
for x in "${X[@]}"; do
  gsed -i  -r "${WS_START},${WS_END} s@\b${x}\b@ws_${x}@g" qgep_en.qgs
  #git add qgep_en.qgs && git commit -m "channel ${x} => ws_${x}"
done

echo "c"

X=(brand cover_shape diameter fastening level cover_material positional_accuracy sludge_bucket venting remark renovation_demand)
for x in "${X[@]}"; do
  y=$(gsed 's/cover_//' <<< ${x})
  gsed -i  -r "${WS_START},${WS_END} s@\b${x}\b@co_${y}@g" qgep_en.qgs
  #git add qgep_en.qgs && git commit -m "ws ${x} => co_${y}"
done

echo "d"

X=(manhole_function material surface_inflow manhole_orientation)
for x in "${X[@]}"; do
  y=$(gsed 's/manhole_//' <<< ${x})
  gsed -i  -r "${WS_START},${WS_END} s@\b${x}\b@ma_${y}@g" qgep_en.qgs
  #git add qgep_en.qgs && git commit -m "ws ${x} => ma_${y}"
done

echo "e"

gsed -i  -r "${WS_START},${WS_END} s@\bchannel_usage_current\b@_channel_usage_current@g" qgep_en.qgs
gsed -i  -r "${WS_START},${WS_END} s@\bchannel_function_hierarchic\b@_channel_function_hierarchic@g" qgep_en.qgs
#git add qgep_en.qgs && git commit -m "ws channel_.... => _channel_...."

echo "f"

X=(bypass special_structure_function stormwater_tank_arrangement)
for x in "${X[@]}"; do
  y=$(gsed 's/special_structure_//' <<< ${x})
  gsed -i  -r "${WS_START},${WS_END} s@\b${x}\b@ss_${y}@g" qgep_en.qgs
  #git add qgep_en.qgs && git commit -m "ws ${x} => ss_${y}"
done

echo "g"

X=(highwater_level relevance terrain_level waterlevel_hydraulic)
for x in "${X[@]}"; do
  gsed -i  -r "${WS_START},${WS_END} s@\b${x}\b@dp_${x}@g" qgep_en.qgs
  #git add qgep_en.qgs && git commit -m "ws ${x} => dp_${x}"
done

echo "h"

X=(absorption_capacity defects distance_to_aquifer effective_area emergency_spillway kind labeling seepage_utilization vehicle_access watertightness)
for x in "${X[@]}"; do
  gsed -i  -r "${WS_START},${WS_END} s@\b${x}\b@ii_${x}@g" qgep_en.qgs
  #git add qgep_en.qgs && git commit -m "ws ${x} => ii_${x}"
done

echo "i"

gsed -i  -r "${WS_START},${WS_END} s@\bbackflow_level\b@wn_backflow_level@g"  qgep_en.qgs
gsed -i  -r "${WS_START},${WS_END} s@\bbottom_level\b@wn_bottom_level@g"  qgep_en.qgs


git add qgep_en.qgs && git commit -m "prefix for ws"