# HG changeset patch
# User Christopher Springer <springer@nwoca.org>
# Date 1440156723 -3600
# Node ID e721a977726be5a2185142965c452db4ee021d14
# Parent  8aab0c2c1259c7be1d364b9b0ea90ef143bad932
Revoke ability to connect to database before attempting to drop it for task database(Drop|Create)

diff -r 8aab0c2c1259 -r e721a977726b init20.gradle
--- a/init20.gradle	Fri Aug 14 16:13:24 2015 +0100
+++ b/init20.gradle	Fri Aug 21 12:32:03 2015 +0100
@@ -298,7 +298,9 @@
                                 driverName)
                         if (dropIt) {
 							logger.info "disconnecting sessions from $databaseName"
-							sql.execute "SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = '$databaseName';"
+							sql.execute "REVOKE CONNECT ON DATABASE " + databaseName + " FROM public;"
+							sql.execute "REVOKE CONNECT ON DATABASE " + databaseName + " FROM " + gradle.environmentDatabase.jdbc.username + ";"
+							sql.execute "SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = '" + databaseName + "';"
                             logger.info "dropping $databaseName (if exists) from $adminUrl"
                             sql.execute 'DROP DATABASE IF EXISTS "' + databaseName + '";'
                         }