Overview
| Panel |
|---|
Summary | Enables users to add a releaseDate to each ChangeSet for processing in a installer. | Current Version | 1.0.1 | Author | Michael Oberwasserlechner | SVN Repository | https://liquibase.jira.com/svn/CONTRIB/trunk/liquibase-releasedate/trunk Source | Attached to page | Supported Databases | Should work for all | | Liquibase Support | Supports Liquibase 2.0.x. Incompatible with Liquibase 3.0+ |
|
Purpose
I use Hibernate as OR-Mapping Framework. While developing a installer and later a in-application upgrader I wanted that the installer should only use the hibernate mapping and only the upgrader should execute the liquibase ChangeSets.
...
For other execution methods like LoggingExecutor the release date is included in a sql comment.
Example:
| Code Block |
|---|
|
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd
http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
<changeSet id="create_data_language" author="michael">
<ext:releaseDate releasedOn="2010-11-30" />
<createTable tableName="DATA_LANGUAGE" remarks="This table stores the data language definitions.">
<column name="ID" type="NUMBER(10)">
<constraints primaryKeyName="PK_DATA_LANGUAGE" primaryKey="true"/>
</column>
<column name="ISO_CODE" type="VARCHAR(10)" >
<constraints nullable="false" unique="true"/>
</column>
</createTable>
</changeSet>
</databaseChangeLog>
|
XSD:
| Code Block |
|---|
|
<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
targetNamespace="http://www.liquibase.org/xml/ns/dbchangelog-ext"
xmlns="http://www.liquibase.org/xml/ns/dbchangelog-ext"
elementFormDefault="qualified">
<xsd:element name="releaseDate">
<xsd:complexType>
<xsd:attribute name="releasedOn" type="xsd:string" use="required" />
<xsd:attribute name="commentText" type="xsd:string" />
<xsd:attribute name="parsePattern" type="xsd:string" default="yyyy-MM-dd"/>
<xsd:attribute name="formatPattern" type="xsd:string" default="MMMMM dd, yyyy" />
</xsd:complexType>
</xsd:element>
</xsd:schema>
|
I process this extension by code within a ReleaseDateChangeSetFilter, which is included in the jar. See the example below.
| Code Block |
|---|
|
Database liquiBaseDatabase = getLiquiBaseDatabase();
if (liquiBaseDatabase != null) {
try {
// create the changeSet filters
List<ChangeSetFilter> changeSetFilters = new ArrayList<ChangeSetFilter>();
InstallationStatus installationStatus = this.installationValidationService.getInstallationStatus();
// ReleaseDateChangeSetFilter - only accepts changeSets witch are released after
filter.add(new ReleaseDateChangeSetFilter(installationStatus.getFinishedOn()));
// some other filters
try {
filter.add(new ShouldRunChangeSetFilter(liquiBaseDatabase));
}
catch (DatabaseException e) {
logger.warn("Init of ShouldRunChangeSetFilter failed because of:", e);
}
filter.add(new ContextChangeSetFilter("production"));
filter.add(new DbmsChangeSetFilter(liquiBaseDatabase));
ChangeLogParameters parameters = new ChangeLogParameters(liquiBaseDatabase);
// parse the changelog file
ChangeLogParser parser = ChangeLogParserFactory.getInstance().getParser(changelogFileName, resourceAccessor);
DatabaseChangeLog databaseChangeLog = parser.parse(changelogFileName, parameters, resourceAccessor);
Iterator<ChangeSet> changeSetIterator = databaseChangeLog.getChangeSets().iterator();
while (changeSetIterator.hasNext()) {
ChangeSet changeSet = changeSetIterator.next();
boolean removeChangeSet = false;
// ### ChangeSetFilter ###
if (changeSetFilters != null) {
for (ChangeSetFilter filter : changeSetFilters) {
if (!filter.accepts(changeSet)) {
logger.debug("ChangeSetFilter {} does not accept changeset!", filter);
removeChangeSet = true;
break;
}
}// for (filters)
}
if (removeChangeSet) {
changeSetIterator.remove();
}
} //while
return databaseChangeLog;
} catch (LiquibaseException e) {
logger.error("", e);
}
}
|
Files