#!/bin/sh

# First test. Create and destroy the database.

createdb gnucomo_test

if psql gnucomo_test -q <../src/database/create.sql
then
   psql gnucomo_test -c 'select statuscode from status'
   result=$?
   psql gnucomo_test -f ../src/database/destroy.sql -q
else
   echo Can not create test database
   result=1
fi

dropdb gnucomo_test
exit $result