kt-sql

#!/bin/bash

set -e

if [ $# -ne 1 ]; then
	echo
	echo "Vykona konverziu dat Katastra do SQL, ESRI Shapefile a Microstation DGN 7."
	echo "Pouzitie: `basename $0` <kataster_dir>"
	echo
	echo "Struktura adresara <kataster_dir>:"
	echo " * adresar 'vgi'             - subory VGI"
	echo " * adresar 'dbf' alebo 'fpu' - subory DBF resp. FPU+FPT"
	echo "V pripade, ze existuje adresar 'dbf' aj 'fpu', na konverziu sa pouziju data vo formate FPU."
	echo
    exit
fi


ROOT_DIR="$(readlink -e $1)"
echo;
echo "PROGRESS:0"
echo "* Vstupny adresar: $ROOT_DIR"
echo;

cd "$ROOT_DIR"
if [ `ls VGI*.zip` ]; then
echo "PROGRESS:3"
echo "Rozbalovanie suborov vo formate ZIP ..."
sleep 5
find -name '*.zip' -exec sh -c 'unzip -o -d "${1%.*}" "$1"' _ {} \;
fi  
 
vgi=`ls -d VGI* | grep -v '.zip'`
spi=`ls -d SPI* | grep -v '.zip'`
test ! -d "$vgi" && { echo "ERROR: Adresar '$ROOT_DIR/vgi' neexistuje. Koncim."; echo; exit 1; }
test ! -d "$spi" && { echo "ERROR: Adresar '$ROOT_DIR/SPI' neexistuje. Koncim."; echo; exit 1; }

echo "PROGRESS:5"
sleep 1
echo "* Cistenie vystupnych adresarov ..."
echo "PROGRESS:10"
sleep 3
echo;

# vycistenie adresarov sql
vystupne_adresare=(sql sql_p sql_g shp dgn log)

for adr in "${vystupne_adresare[@]}"; do
	rm -rf $ROOT_DIR/$adr
	mkdir -p $ROOT_DIR/$adr
done

cd "$ROOT_DIR"

# cd "$spi"
## ak existuje subor 'fpt' v adresari 'spi', pouzijeme ho na konverziu, inac pouzijeme adresar 'dbf'
#if [ `ls *.fpt` ]; then

	##
	#### FPU ###
	##
	#echo "PROGRESS:15"
      #sleep 1
	#echo "* Konverzia FPU do SQL ..."
	#for file in $(find "$spi" -iname "*.fpt"); do
		#fpuc=$(sed 's/\.fpt$/\.fpuc/I' <<< $file)
		
		#echo "* Cistenie FPU ($file) ..."
		#kt-vycisti_fuvi $file IBM852 > $fpuc || (echo "I: Opakujem cistenie s kodovanim 'CP1250'"; kt-vycisti_fuvi $file CP1250 > $fpuc)
	    
		#echo "* Konverzia FPU do SQL ($file) ..."
		#kt-import_fuvi $fpuc > $ROOT_DIR/sql_p/$(basename $file).sql
	#done;

#else

	#
	### DBF ###
	#
     echo "PROGRESS:15"
     sleep 1
	echo "* Konverzia DBF do SQL ..."
	for file in $(find "$spi" -iname "*.DBF"); do
		
		echo "* Konverzia DBF do SQL ($file) ..."
		kt-import_dbf2 $file > $ROOT_DIR/sql_p/$(basename $file).sql
	done;
#fi

echo "PROGRESS:20"
sleep 1
echo "* Spajanie SQL suborov popisnych dat ..."
find $ROOT_DIR/sql_p -type f -iname *.sql -exec cat "{}" >> sql/popisne_udaje.sql \;
echo;


#
### VGI ###
#
# KN
echo "PROGRESS:25"
sleep 1
echo "* Konverzia KN do SQL (KATUZ, KLADPAR, LINIE, POPIS, ZAPPAR, ZNACKY, ZUOB) ..."
find $vgi -iname "KN*.vgi" -exec kt-vgi2shp -f sql-copy -t -k -l -p -r -n -z -o sql_g "{}" \; &> log/vgi-kn-sql.log

echo "PROGRESS:30"
sleep 1
echo "* Konverzia KN do SHP (vsetky najdene vrstvy)..."
find $vgi -iname "KN*.vgi" -exec kt-vgi2shp -f shp -o shp "{}" \; &> log/vgi-kn-shp.log

echo "PROGRESS:35"
sleep 1
echo "* Konverzia KN do DGN (vsetky najdene vrstvy)..."
find $vgi -iname "KN*.vgi" -exec kt-vgi2shp -f dgn -o dgn "{}" \; &> log/vgi-kn-dgn.log


# UO
echo "PROGRESS:40"
sleep 1
echo "* Konverzia UO do SQL (UOV)..."
find $vgi -iname "UO*.vgi" -exec kt-vgi2shp -f sql-copy -u -o sql_g "{}" \; &> log/vgi-uo-sql.log

echo "PROGRESS:55"
sleep 1
echo "* Konverzia UO do SHP (vsetky najdene vrstvy)..."
find $vgi -iname "UO*.vgi" -exec kt-vgi2shp -f shp -o shp "{}" \; &> log/vgi-uo-shp.log

echo "PROGRESS:65"
sleep 3
echo "* Konverzia UO do DGN (vsetky najdene vrstvy)..."
find $vgi -iname "UO*.vgi" -exec kt-vgi2shp -f dgn -o dgn "{}" \; &> log/vgi-uo-dgn.log

echo "PROGRESS:75"
sleep 3
echo "* Spajanie SQL suborov grafickych dat ..."
find $ROOT_DIR/sql_g -type f -iname *.sql -exec cat "{}" >> sql/graficke_udaje.sql \;
echo;


# logy
echo "PROGRESS:90"
sleep 1
echo "* Chybove hlasenia:"
grep -vH "^INFO\|^$" $ROOT_DIR/log/*.log || true
echo;


# koniec
echo "PROGRESS:100"
echo "* Koniec konverzie"


# vim: set ts=4 sts=4 sw=4 noet: