search

tlberglund / groovy-liquibase

Yet Another Groovy DSL for Liquibase
Other
85 stars 66 forks source link

Bug : load data #10

Closed ErwinvanBrandwijk closed 13 years ago

ErwinvanBrandwijk commented 13 years ago

load data gives an error:

No file opener specified for books.csv

code resourceAccessor opener = getResourceAccessor result Null

tlberglund commented 13 years ago

Should be fixed in SHA: b65dc700778907af4e9930866f29ebd19d8c518c

Used this changelog to demonstrate:

databaseChangeLog() {

  changeSet(id:'monkey', author: 'tlberglund') {
    new File('test.sql').withPrintWriter { pw ->
      pw.println "CREATE TABLE monkey (id int, mood varchar(50))"
    }
    sqlFile(path: 'test.sql')
  }

  changeSet(author: 'tlberglund', id: 'test-load-data') {
    new File('data.csv').withPrintWriter { pw ->
      pw.println "id,mood"
      pw.println "1,angry"
      pw.println "2,happy"
      pw.println "3,ambivalent"
    }

    loadData(tableName: 'monkey', file: 'data.csv') {
      column(name: 'id', type: "NUMERIC")
      column(name: 'mood', type: "STRING")
    }
  }
}
ErwinvanBrandwijk commented 13 years ago

Tested, and is working.