Liquibase XML生成器 [英] Liquibase XML generator

问题描述

有没有opensource / free liquibase（ http://www.liquibase.org ）xml生成器？

Is there opensource/free liquibase (http://www.liquibase.org) xml generator?

替代Power Architect和Liquibase combo。在哪里可以创建数据库模型，然后将其转换为Liquibase XML格式或将纯sql转换为Liquibase XML？

Alternative to "Power Architect and Liquibase combo". Where can I create database model and then transform it to Liquibase XML format or transform pure sql to Liquibase XML?

推荐答案

其实你可以自己做，使用 liquibase核心类。

Actually you can do it by your own by using liquibase core classes.

使用示例：

// .. imports

// create a changelog
liquibase.changelog.DatabaseChangeLog databaseChangeLog = new liquibase.changelog.DatabaseChangeLog();

// create a changeset
liquibase.changelog.ChangeSet changeSet = new liquibase.changelog.ChangeSet("1", "prates", false, false, "", null, null, true, null, databaseChangeLog);

// create a drop table change
liquibase.change.core.DropTableChange dropTableChange = new liquibase.change.core.DropTableChange();

dropTableChange.setTableName("person");

changeSet.addChange(dropTableChange);

// add created changeset to changelog
databaseChangeLog.addChangeSet(changeSet);

// create a new serializer
XMLChangeLogSerializer xmlChangeLogSerializer = new XMLChangeLogSerializer();

String output = null;

ByteArrayOutputStream baos = new ByteArrayOutputStream();

xmlChangeLogSerializer.write(databaseChangeLog.getChangeSets(), baos);

output = baos.toString();

// print output
System.out.println(output);

这篇关于Liquibase XML生成器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！