Database scripts altered to support drop

[hcoop/domtool2.git] / src / plugins / domtool-postgres

#!/bin/sh -e

case $1 in
	adduser)
		USERNAME=$2

		sudo -u postgres psql -c "CREATE USER $USERNAME" template1
		sudo -u postgres psql -c "ALTER TABLESPACE user_$USERNAME OWNER TO $USERNAME"
	;;

	createdb)
		USERNAME=$2
		DBNAME_BASE=$3
		DBNAME="${USERNAME}_${DBNAME_BASE}"

		sudo -u postgres createdb -O $USERNAME -D user_$USERNAME $DBNAME
	;;

	dropdb)
		USERNAME=$2
		DBNAME_BASE=$3
		DBNAME="${USERNAME}_${DBNAME_BASE}"

		sudo -u postgres dropdb $DBNAME
	;;

	*)
		echo "Usage: domtool-postgres [adduser <user> | createdb <user> <db> | dropdb <user> <db>]"
	;;
esac