Springboot集成Liquibase笔记整理

<dependency><groupId>org.liquibase</groupId><artifactId>liquibase-core</artifactId>
</dependency>

spring:liquibase:contexts: dev,testenabled: true

@Configuration
@EnableConfigurationProperties(LiquibaseProperties.class)
public class LiquibaseConfig {@Beanpublic SpringLiquibase liquibase(DataSource dataSource, LiquibaseProperties properties) {SpringLiquibase liquibase = new SpringLiquibase();liquibase.setDataSource(dataSource);//指定changelog的位置，这里使用的一个master文件引用其他文件的方式liquibase.setChangeLog("classpath:liquibase/master.xml");liquibase.setContexts(properties.getContexts());liquibase.setDefaultSchema(properties.getDefaultSchema());liquibase.setDropFirst(properties.isDropFirst());liquibase.setShouldRun(properties.isEnabled());liquibase.setChangeLogParameters(properties.getParameters());liquibase.setRollbackFile(properties.getRollbackFile());liquibase.setShouldRun(true);return liquibase;}
}

<?xml version="1.0" encoding="utf-8"?>
<databaseChangeLogxmlns="http://www.liquibase.org/xml/ns/dbchangelog"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsd"><property name="now" value="now()" dbms="h2"/><property name="now" value="now()" dbms="mysql"/><property name="floatType" value="float4" dbms="postgresql, h2"/><property name="floatType" value="float" dbms="mysql, oracle, mssql, mariadb"/><property name="clobType" value="clob" dbms="h2"/><property name="clobType" value="clob" dbms="mysql, oracle, mssql, mariadb, postgresql"/><property name="uuidType" value="varchar(36)" dbms="h2, mysql, mariadb"/><includeAll path="liquibase/changelog/"/>
</databaseChangeLog>

<?xml version="1.0" encoding="utf-8"?>
<databaseChangeLogxmlns="http://www.liquibase.org/xml/ns/dbchangelog"xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsdhttp://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd"><property name="autoIncrement" value="true"/><changeSet author="system" id="00000000000001" context="dev"><createTable tableName="hello_date_time_wrapper"><column  name="id" type="BIGINT"><constraints primaryKey="true" primaryKeyName="hello_date_time_wrapperPK"/></column><column name="instant" type="timestamp"/><column name="local_date_time" type="timestamp"/><column name="offset_date_time" type="timestamp"/><column name="zoned_date_time" type="timestamp"/><column name="local_time" type="time"/><column name="offset_time" type="time"/><column name="local_date" type="date"/></createTable></changeSet>
</databaseChangeLog>