CODEWITHSUNDEEP
liquibase
Aml
Aml

Reputation: 341

When creating a column using liquibase, how do I specify a value for that column based on an existing column?

I have an existing mysql table with two columns a and b.

I now want to add a column c to that table.

c should be nullable, should have a default value of NULL, except in those rows where column b has the value 10. Where b has the value 10, c should have a value X.

I understand that it is fairly simple to do this using SQL, but I want to do this using liquibase, since liquibase is what we use for our schema migrations.

Upvotes: 31

Views: 93629

Answers (3)

Minnow
Minnow

Reputation: 515

If you are adding column then

<changeSet author="your-name" id="your-id"> 
    <addColumn tableName="person" >
        <column name="is_active" type="varchar2(1)" defaultValue="Y" />  
    </addColumn>  
</changeSet>

add-column

if column is already added, and then you need to set default value

<changeSet author="your-name" id="your-id">
    <addDefaultValue columnDataType="varchar2(1)" columnName="is_active" defaultValue="Y" tableName="person"/>  
</changeSet>

add-default-value

Upvotes: 6

rodrigocprates
rodrigocprates

Reputation: 566

I think the best solution without using plain sql is following:

You can choose to use both changes within a changeset, but a good practice is to separate each one by a separated changeset for liquibase transaction/rollback purposes.

Upvotes: 6

Walter Traspadini
Walter Traspadini

Reputation: 869

Have you already tried something like this?

<addColumn tableName="SGW_PRODOTTI_INFO_ATTRIBUTE">
    <column name="AlternativeListPrice" type="double" defaultValue="0.0">
    <constraints nullable="true"/>
    </column>
</addColumn>

Upvotes: 56

Related Questions