@Grapes([
        @Grab(group='org.firebirdsql.jdbc', module='jaybird-jdk18', version='2.2.11'),
        @GrabConfig(systemClassLoader = true),
])

def dbUser = 'someUser'
def dbPassword = 'somePassword'

// Create database
File dbFile = File.createTempFile 'tmp', '.fdb'
dbFile.delete()
dbFile.deleteOnExit()
org.firebirdsql.management.FBManager.newInstance().with {
    start()
    createDatabase dbFile.path, 'SYSDBA', 'masterkey'
    stop()
}
def dbUrl = 'jdbc:firebirdsql:localhost:' + dbFile.path

// Open connection pool
def connPool = [
        java.sql.DriverManager.getConnection(dbUrl, dbUser, dbPassword),
        java.sql.DriverManager.getConnection(dbUrl, dbUser, dbPassword),
        java.sql.DriverManager.getConnection(dbUrl, dbUser, dbPassword),
]

// Gradual closing of connections in another thread
Thread.start {
    connPool.each {
        Thread.sleep(1000)
        println 'close connection begin'
        it.close()
        println 'close connection end'
    }
}

// Shutdown database
println 'shutdown started'
try {
    org.firebirdsql.management.FBMaintenanceManager.newInstance().with {
        host = 'localhost'
        database = dbFile.path
        user = 'SYSDBA'
        password = 'masterkey'
        shutdownDatabase OPERATION_MODE_MULTI, SHUTDOWNEX_ATTACHMENTS, 20
    }
    println 'shutdown finished'
} catch (Exception e) {
    println "shutdown error: $e"
}

// Delete database
while (!dbFile.delete())
    Thread.sleep 100
println 'database removed'