[Groovy] Flyway Groovy Migration

V1_0__Create_person_table.groovy

package db.migration;
import com.googlecode.flyway.core.api.migration.jdbc.JdbcMigration;
import java.sql.Connection;
import java.sql.PreparedStatement;

/**
 * Example of a Groovy-based migration.
 */
public class V1_0__Create_person_table implements JdbcMigration {
    public void migrate(Connection connection) throws Exception {
        def sql = """\
create table PERSON (
    ID int not null,
    NAME varchar(100) not null
);"""
        PreparedStatement statement =
                connection.prepareStatement(sql)

        try {
            statement.execute()
        } finally {
            statement.close()
        }
    }
}