#! /bin/sh -e
# AUTHOR: Samuel Muoz Hidalgo
# CONTACT: samuel.mh@gmail.com
# DESCRIPTION: Automatic database creation
# LAST REVISION: 17-May-2009

DATABASE='ic_db1'

#Used for connections
SUPERUSER='postgres'

#Radius configuration
RADIUS_USER='raduser1'
RADIUS_PASSWORD='radpass1'
RADIUS_PRIVILEGES="
--  Read credentials
GRANT SELECT ON USERS TO $RADIUS_USER;
-- The server can write to the accounting table.
GRANT ALL on CONNECTED_USERS TO $RADIUS_USER;"

#simpleSAMLphp configuration
SSP_USER='sspuser1'
SSP_PASSWORD='ssppass1'
SSP_PRIVILEGES="
-- The server can update to the accounting table.
GRANT UPDATE on CONNECTED_USERS TO $SSP_USER;"


#COMMANDS
COMMAND="psql -U $SUPERUSER  -d $DATABASE"


#CREATE DATABASE & TABLES
psql -U $SUPERUSER -c "create database $DATABASE"
$COMMAND -f schema.sql


#USERS
$COMMAND -c "CREATE USER $RADIUS_USER WITH NOCREATEDB NOCREATEUSER ENCRYPTED PASSWORD '$RADIUS_PASSWORD';"
$COMMAND -c "$RADIUS_PRIVILEGES"
$COMMAND -c "CREATE USER $SSP_USER WITH NOCREATEDB NOCREATEUSER ENCRYPTED PASSWORD '$SSP_PASSWORD';"
$COMMAND -c "$SSP_PRIVILEGES"

#INSERTING DATA
$COMMAND -c "INSERT INTO USERS (name, cleartext_password) VALUES ('samu','clavesamu');"
$COMMAND -c "INSERT INTO USERS (name, cleartext_password) VALUES ('enrique','claveenrique');"
$COMMAND -c "INSERT INTO USERS (name, cleartext_password) VALUES ('user','claveuser');"
