create_database.sh

#!/bin/sh

DB=sensorhub.db

#
# This is only for development
# Do not create this file in Production !!!!!!
#
if [ -f /home/norbert/entw/sensorhub/this_is_in_development ]; then
  echo ".schema" | sqlite3 /var/database/$DB > create_DB.sql
fi

if [ -e $DB ]; then
  rm $DB
fi  

cat create_DB.sql | sqlite3 $DB

if [ -e populate_DB.sql ]; then
  cat populate_DB.sql | sqlite3 $DB 
  echo  "Database: $DB filled with data from populate_DB.sql"
fi