A Groovy task that prefixes new SQL migration files with a timestamp precise to milliseconds. The following usage will add a prefix to any SQL file in a hardcoded directory that does not begin with an number and double leading underscore: $ gradle prefixNewMigrations

Prefix migrations with timestamp Groovy task

task prefixNewMigrations {

  fileTree(dir: 'dev/src/db/listhub').exclude({ isFilePrefixed(it.file) }).each { file ->
        doLast {

        	def timestamp = new Date().format('yyyyMMddHHmmssSSS', TimeZone.getTimeZone('GMT'))

        	println "Renaming $file.name to ${timestamp}__$file.name"
        	
        	file.renameTo("$file.parentFile.absolutePath$file.separator${timestamp}__$file.name")
        	
        	// Sleep for a moment to avoid prefix conflicts when renaming multiple files
        	sleep(1*1000)
        }
    }
}

def isFilePrefixed(file) {
	return (file.name ==~ '^\\d+__.*\\.sql\$')
}

Thanks for sharing this!
I had to do something similar, but I had to plug it into a maven build, so I could only use pure Groovy. You can find this Gist here: https://gist.github.com/SlevinBE/7233913

Thanks for sharing!
Here is a version for SBT
https://gist.github.com/denisovlev/6449672ea1de8d50fc4f7312a875c760