fresh-cognicity-database

fresh-cognicity-database.sh

#!/usr/bin/env bash

# assumes https://github.com/smart-facility/cognicity-schema and https://github.com/smart-facility/cognicity-reports
# both checked out using default directory names (matching trailing part of url)

createdb -U postgres -h $DB_HOST -E utf8 cognicity
cd cognicity-schema
psql -U postgres -h $DB_HOST -d cognicity -f schema.sql
cd sample_data/infrastructure
find . -name '*.sql' -exec psql -U postgres -h $DB_HOST -d cognicity -f {} ';'
cd ../municipal_boundaries
find . -name '*.sql' -exec psql -U postgres -h $DB_HOST -d cognicity -f {} ';'
cd ../../../cognicity-reports
find . -name 'update_schema_*.sql' -exec psql -U postgres -h $DB_HOST -d cognicity -f {} ';'