Using Liquibase Pro

Liquibase is a development tool that allows changes to be applied to the EDB database using the Liquibase CLI and viewed on the Liquibase Hub.

Creating a Project on Liquibase Hub

Use the following steps to create a project for the target database instance on the Liquibase Hub. All data related to the target database is stored in this project.

1. Log in to the Liquibase Hub console.

2. Select the Projects menu.

3. Create a Project on the Liquibase Hub by selecting Create Project.

4. On the Create Project page, enter the name and description of the project.

5. Select Create Project.

Applying Database Changes

This section provides examples of applying database changes using Liquibase changesets including:

• Updating tables

• Rolling back changes

• Viewing database changes on Liquibase Hub

Refer to the Liquibase documentation for available change types.

The initial database objects and data for these examples are created using this sample script:

CREATE SEQUENCE sal_seq MINVALUE 1 START WITH 1 INCREMENT BY 1 NOCACHE;

CREATE TABLE tp_sales_db (
salesman_id INT4,
salesman_name VARCHAR2(30),
sales_region VARCHAR2(30),
sales_amount INT4 DEFAULT sal_seq.nextval,
deptno INT4
);

CREATE TABLE tp_department_db
(
deptno INT4 Primary Key,
dname VARCHAR(50),
location VARCHAR(100)
);
INSERT INTO tp_sales_db VALUES (100,';Person 1';,';CITY 1';,DEFAULT,10);
INSERT INTO tp_department_db VALUES (10,';Development';,';Pakistan';);

Updating Tables

1. Create a changelog file using one of the following options for creating a changelog file:

   • Create the file manually. See the following changelog file example. For detailed information on changelogs, refer to the changelog documentation from Liquibase.

     Toggle WrapCopy

     xml version="1.0" encoding="UTF-8"?>
     <databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:pro="http://www.liquibase.org/xml/ns/pro"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
     http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.2.xsd
     http://www.liquibase.org/xml/ns/pro
     http://www.liquibase.org/xml/ns/pro/liquibase-pro-4.2.xsd " changeLogId="9e43abe4-
     4a9b-4d38-a485-c68af935bc44">
     <changeSet author="kashif" id="100">
     <insert catalogName="edb"
      dbms="postgresql"
      schemaName="public"
      tableName="tp_department_db">
     <column name="deptno" value="20"/>
     <column name="dname" value="QMG"/>
     <column name="location" value="India"/>
     </insert>
     <insert catalogName="edb"
      dbms="postgresql"
      schemaName="public"
      tableName="tp_department_db">
     <column name="deptno" value="30"/>
     <column name="dname" value="CM"/>
     <column name="location" value="Pakistan"/>
     </insert>
     <update catalogName="edb"
     schemaName="public"
     tableName="tp_department_db">
     <column name="dname" value="UPDATED NAME...."/>
     <where>deptno=30</where>
     </update>
     <delete catalogName="edb"
      chemaName="public"
      tableName="tp_department_db">
     <where>deptno=10</where>
     </delete>
     <rollback>
     DELETE FROM public.tp_department_db WHERE deptno=20;
     DELETE FROM public.tp_department_db WHERE deptno=30;
     INSERT INTO public.tp_department_db (deptno, dname, location) VALUES ('10',
     'Development', 'Pakistan');
     </rollback>
     </changeSet>
     </databaseChangeLog>

   • Generate a sample file and update it with your changes. Generate the sample changelog file using this command:

     ./liquibase --changeLogFile=edb_dbchangelog.xml generateChangeLog

2. For each database change, add a changeset entry to the changelog file. For detailed information on changesets, refer to the changeset documentation from Liquibase.

3. To register the changelog with the Liquibase Hub and provide the project name, execute this command:

   ./liquibase registerChangeLog

Sample output:

4. To update the table in the target database, use this command:

   ./liquibase update

Rolling Back Changes

Roll back changes made to the table using the rollbackCount command. For example, this command uses the sample changelog file:

./liquibase rollbackCount 1

Viewing Database Changes On Liquibase Hub

To view the details of the changes made on the target database, select a ChangeLog link. For example, select dbchangelog.xml to see its details.

The diagram below shows the details for the selected changeset.

• On this page
• Creating a Project on Liquibase Hub
• Applying Database Changes