· 9 years ago · Nov 12, 2016, 08:36 PM
1#!/bin/bash
2# Skript: m122_Scripts/BC2SQL_fast.sh
3
4DBFILE="SIX_Bankenstamm.db"
5SRCFILE="SIX_BankenstammCH.csv"
6TABLENAME="Bankenstamm"
7
8if ! [ -r "$SRCFILE" ]
9then
10 echo "Could not read $SCRFILE. Exiting..."
11 exit 1
12fi
13
14echo "Preparing database file $DBFILE now..."
15sqlite3 "$DBFILE" "DROP TABLE IF EXISTS $TABLENAME;"
16sqlite3 "$DBFILE" "CREATE TABLE Bankenstamm (SortNr INTEGER PRIMARY KEY, BCNr INTEGER, IBAN INTEGER, PZValidierung INTEGER, BCNRIID INTEGER, Landcode TEXT, PostkontoInput TEXT, PostkontoOutput TEXT, SWIFT TEXT, emailDev TEXT, Mutationsdatum INTEGER, Hauptsitz INTEGER, BCART INTEGER, BankInstitut TEXT, SIC INTEGER, eurosic INTEGER, Sprache INTEGER, Kurzbez TEXT, Domizil TEXT, Postadresse TEXT, PLZ TEXT, Ort TEXT, Telefon TEXT, Fax TEXT, Vorwahl TEXT);"
17echo "Filling database now"
18echo ""
19
20sqlite3 "$DBFILE" -separator ';' ".import $SRCFILE $TABLENAME" 2> /dev/null
21sqlite3 -header "$DBFILE" "SELECT count(SortNr) as NrOfEntries FROM $TABLENAME"