6

Can you give me an example of a groovy changeset using the modifyDataType method?

I tried this:

databaseChangeLog = {
  changeSet(author: "user", id: "5-1") {
        modifyDataType(tableName: "test", columnName: "description4", newDataType: "int(11)")
    }
}

But modifyDataType is not recognized. I also tried modifyColumn, but I get the same result.

The underlying question is: What kind of tags does the dsl support, and how are they used?

Rob Hruska
  • 118,520
  • 32
  • 167
  • 192
Hugo
  • 2,139
  • 4
  • 22
  • 30
  • Since the plugin is still under development (currently version 0.2.1), the documentation probably isn't as complete as it will be once the plugin reaches v1.0. I would have thought it would have supported any [liquibase refactoring](http://www.liquibase.org/manual/home), but given your experience, apparently not? You can always try [opening a JIRA issue](http://jira.grails.org/secure/Dashboard.jspa) to see if it can get added to the documentation. – Rob Hruska Jun 02 '11 at 22:13
  • Also, FWIW, changing the name of a domain property and running `dbm-gorm-diff file.groovy` creates changesets with `dropColumn` and `addColumn` instead of using modify. Perhaps column renaming/modifying is on the roadmap. You can probably write your own custom changeset to migrate the data in the short term. – Rob Hruska Jun 02 '11 at 22:20
  • Although the plugin is only at v0.2.1 it's very stable and is effectively a 1.0 release candidate. There are a couple of open issues I'd like to fix before an official 1.0 and of course it needs more documentation, but otherwise it's basically feature-complete. – Burt Beckwith Jun 02 '11 at 23:25
  • @Burt - Agreed that it's stable (I didn't really intend to imply that it wasn't). I've been using it for some time now and have been very happy with it. Thanks for your development on it. – Rob Hruska Jun 03 '11 at 12:57

2 Answers2

10

All Liquibase refactorings should work - the Groovy DSL mirrors the Liquibase XML. I didn't have a test for modifyDataType but added it to my test script and it worked fine - see https://github.com/grails-plugins/grails-database-migration/blob/master/testapp/price.changelog.groovy

It'd be useful to figure out what's wrong if you could show some information about how it fails.

Burt Beckwith
  • 75,342
  • 5
  • 143
  • 156
  • Master is now the Grails 3 plugin, and apparently the test app was moved (I didn't work on the Grails 3 update). But the older plugin is in the "1.x" branch, and the referenced file is [here](https://github.com/grails-plugins/grails-database-migration/blob/1.x/testapp/price.changelog.groovy) – Burt Beckwith Oct 26 '15 at 20:24
3

It will work like this:

databaseChangeLog = {

  changeSet(author: "test (generated)", id: "1422541392309-2") {
    comment { 'Rename tabTitle to tabName' }
    renameColumn(tableName: "user", oldColumnName: "tab_title", newColumnName: "tab_name", columnDataType: "varchar(255)")
  }
}
Michael
  • 32,527
  • 49
  • 210
  • 370