path: root/py/air-quality/convert-csv-2-sqlite.sh

#!/bin/bash 

# Convert CSV to SQLite

# check for input file, abort if it is missing
if [ ! -f export.csv ]; then
    echo "export.csv not found!"
    exit 1
fi

# check for sqlite3 database, if it exists, 
# delete it so we can make a new one
if [ -f airq.db ]; then
    rm airq.db
fi


sqlite3 airq.db <<EOF

.mode csv
.import export.csv air
SELECT * FROM air;
.exit

EOF