dbf2sqlite.sh

dbf2sqlite.sh

#!/bin/bash

# DESCRIPTION="Using other scripts, that piece of code imports DBF file into sqlite3 databases.
# It's necesary that the data directory was in the same directory than this script"

# usage() {
#     echo -e "\n`basename $0` $sqlitedatabase $data"
#     echo
#     echo $DESCRIPTION
#     echo
#     exit -1
# }

#sqlitedatabase='/home/nes/cartolab/fonsagua/data_Coray/_DB/fonsagua.sqlite3'
#sqlitedatabase='/home/nes/cartolab/fonsagua/data_Marcovia/_DB/fonsagua.sqlite3'

#cd 'datacoray'
#cd 'datamarcovia'

sqlitedatabase=$1
dirdata=$2

cd $dirdata

for i in `ls *dbf`; do
    echo $i
    ../dbf2csv.py $i;
done

for i in `ls *csv`; do
    echo $i
    ../csv2sql.py $i `echo $i | cut  -f1 -d '.'`.sql `echo $i | cut  -f1 -d '.'`;
done

for i in `ls *sql`; do
    echo $i
    sqlite3 $sqlitedatabase < $i;
done

cd ..