Differences
This shows you the differences between two versions of the page.
Next revision
|
Previous revision
|
automatizace:liquibase [2023/01/20 13:54] tomas created |
automatizace:liquibase [2023/01/20 14:17] (current) tomas |
| |
=== CMD === | === CMD === |
java -jar liquibase.jar --driver com.mysql.jdbc.Driver --classpath=mysql-connector-java-5.1.43-bin.jar --username=USR --password=PWD --url=jdbc://localhost/lb --changeLogFile=xmlsample/changelog.xml update ... update operace\\ | ''%%java -jar liquibase.jar --driver com.mysql.jdbc.Driver --classpath=mysql-connector-java-5.1.43-bin.jar --username=USR --password=PWD --url=jdbc://localhost/lb --changeLogFile=xmlsample/changelog.xml update%%'' ... update operace nad mysql\\ |
| ''%%java -jar liquibase.jar --driver oracle.jdbc.driver.OracleDriver --classpath=ojdbc7.jar --username=USR --password=PWD --url=jdbc:oracle:thin:@IP:1521/DB --changeLogFile=xmlsample/changelog.xml rollbackCount 1%%'' ... rollback operace o jeden krok nad Oracle databází\\ |
| |
| === ChangeSet format === |
| <code> |
| <databaseChangeLog |
| xmlns="http://www.liquibase.org/xml/ns/dbchangelog" |
| xmlns:xsi="http://www.wš.org/2001XMLSchemaInstance" |
| xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" |
| xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.wš.org/2001XMLSchemaInstance http://www.liquibase.org/xml/ns/dbchangelog-ext"> |
| <include file="db/changeset1.xml"/> |
| <include file="db/changeset1.xml"/> |
| </databaseChangeLog> |
| </code> |
| |
| <code> |
| <databaseChangeLog |
| xmlns="http://www.liquibase.org/xml/ns/dbchangelog" |
| xmlns:xsi="http://www.wš.org/2001XMLSchemaInstance" |
| xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" |
| xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.wš.org/2001XMLSchemaInstance http://www.liquibase.org/xml/ns/dbchangelog-ext"> |
| <changeSet id=0 author="tom"> |
| <createTable tableName="tabulka1"> |
| <column name="id" type="int"> |
| <constrains primaryKey="true" nullable="false" /> |
| </column> |
| </createTable> |
| </changeSet> |
| </databaseChangeLog> |
| </code> |