medium-c51d4ee96a6e-s2.groovy

import liquibase.statement.core.InsertStatement


databaseChangeLog = {

    changeSet(author: "Shashank Agrawal", id: "my-custom-unique-id-for-each-changeSet-11212013-1") {
        grailsChange {
            change {
                def statements = []

                // Iterating through each row in table.
                sql.eachRow('select * from old_table_name') {

                    def insertStatement = new InsertStatement("my_database_name", "new_table_name")
                            .addColumnValue("id", it.id)
                            .addColumnValue("version", 0)
                            .addColumnValue("date_created", it.date_created)
                            .addColumnValue("last_updated", new Date())
                            .addColumnValue("some_other_field", it.id)
                            .addColumnValue("user_id", 0)

                    statements.add(insertStatement)

                }

                sqlStatements(statements)   // Executing every statement at one shot

                confirm 'Adding records to new table' // Optional line. Just for message.
            }
        }
    }
}