Re: CustomSqlChange/CustomTaskChange exmples?

> The correct javadoc link is http://www.liquibase.org/api/index.html
> (http://www.liquibase.org/api/liquibase/change/custom/CustomTaskChange.h
> tml for the class directly) which has some info in it.
>
> If what you are trying to do is not a simple SQL statement,
> CustomTaskChange is the way to go.
>
> Nathan
>
>
> -----Original Message-----
> From: David C. Hicks [mailto:dhicks@...]
> Sent: Tuesday, June 23, 2009 5:10 PM
> To: liquibase-user@...
> Subject: Re: [Liquibase-user] CustomSqlChange/CustomTaskChange exmples?
>
> Mostly, I was curious about what I should (or shouldn't) do with all the
> extra methods that the interface gives me. I'm actually working on a
> CustomTaskChange. I need to do some very specific data manipulation for
> one of my updates. I figured this would be easier than trying to write a
> bunch of SQL. So, it's old-school JDBC.
>
>
>
> Voxland, Nathan wrote:
>  
>> Thanks for pointing that out.   Here is an example CustomSqlChange
>> class, is there anything in particular you are wondering?:
>>
>> public class ExampleCustomSqlChange implements CustomSqlChange,
>> CustomSqlRollback {
>>
>>     private String tableName;
>>     private String columnName;
>>     private String newValue;
>>
>>     @SuppressWarnings({"UnusedDeclaration", "FieldCanBeLocal"})
>>     private ResourceAccessor resourceAccessor;
>>
>>
>>     public String getTableName() {
>>         return tableName;
>>     }
>>
>>     public void setTableName(String tableName) {
>>         this.tableName = tableName;
>>     }
>>
>>     public String getColumnName() {
>>         return columnName;
>>     }
>>
>>     public void setColumnName(String columnName) {
>>         this.columnName = columnName;
>>     }
>>
>>     public String getNewValue() {
>>         return newValue;
>>     }
>>
>>     public void setNewValue(String newValue) {
>>         this.newValue = newValue;
>>     }
>>
>>     public SqlStatement[] generateStatements(Database database) {
>>         return new SqlStatement[]{
>>                 new RawSqlStatement("update "+tableName+" set
>> "+columnName+" = "+newValue)
>>         };
>>     }
>>
>>     public SqlStatement[] generateRollbackStatements(Database
>>    
> database)
>  
>> throws UnsupportedChangeException, RollbackImpossibleException {
>>         return new SqlStatement[]{
>>                 new RawSqlStatement("update "+tableName+" set
>> "+columnName+" = null")
>>         };
>>     }
>>
>>     public String getConfirmationMessage() {
>>         return "Custom class updated "+tableName+"."+columnName;
>>     }
>>
>>     public void setUp() throws SetupException {
>>     }
>>
>>     public void setFileOpener(ResourceAccessor resourceAccessor) {
>>         this.resourceAccessor = resourceAccessor;
>>     }
>>
>>     public ValidationErrors validate(Database database) {
>>         return new ValidationErrors();
>>     }
>>    
>> }
>>
>> -----Original Message-----
>> From: David C. Hicks [mailto:dhicks@...]
>> Sent: Tuesday, June 23, 2009 2:54 PM
>> To: Liquibase Users
>> Subject: [Liquibase-user] CustomSqlChange/CustomTaskChange exmples?
>>
>> The online docs have links, but they go to blank pages.  Can anyone
>> point me to an example of a custom change class of any kind?
>> Thanks!
>> Dave
>>
>>
>>
>>    
> ------------------------------------------------------------------------
>  
>> ------
>> _______________________________________________
>> Liquibase-user mailing list
>> Liquibase-user@...
>> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>>
>>
>>    
> ------------------------------------------------------------------------
> ------
>  
>> _______________________________________________
>> Liquibase-user mailing list
>> Liquibase-user@...
>> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>>  
>>    
>
> ------------------------------------------------------------------------
> ------
> _______________________________________________
> Liquibase-user mailing list
> Liquibase-user@...
> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Liquibase-user mailing list
> Liquibase-user@...
> https://lists.sourceforge.net/lists/listinfo/liquibase-user
>