medium-c51d4ee96a6e-s1.groovy

import liquibase.statement.core.UpdateStatement

databaseChangeLog = {

    // Some other changeSets

    changeSet(author: "Shashank (generated)", id: "1381499382647-13") {
        addColumn(tableName: "ufile") {
            column(name: "file_group", type: "varchar(255)") {
                constraints(nullable: "false")
            }
        }
    }

    changeSet(author: 'Shashank Agrawal', id: 'file-uploader-10112013-1')  {
        grailsChange {
            change {
                def statements = []

                // Example 1: Updating file_group column with some value based on where clause
                statements << new UpdateStatement('my_database_name', 'ufile')
                        .addNewColumnValue('file_group', "customerLogo")
                        .setWhereClause(" id < 8")

                statements << new UpdateStatement('my_database_name', 'ufile')
                        .addNewColumnValue('file_group', "blogLogo")
                        .setWhereClause(" id in (13,14)")

                statements << new UpdateStatement('my_database_name', 'ufile')
                        .addNewColumnValue('type', "LOCAL")

                statements << new UpdateStatement('my_database_name', 'ufile')
                        .addNewColumnValue('date_created', new Date())

                sqlStatements(statements)   // Executing all statements at once

                confirm 'Initializing default value'    // Optional method call to display message

            }
        }
    }

}