Use UUID and load data

Liquibase uses Universally Unique Identifiers (UUID)s to define tables so they are more easily searchable.

How to use UUID and load data

1

Define a table

For example, this changelog creates two tables: project and project_objectives. It then uses the loadData Change Type to load data into the project_objectives table:

<?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:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
  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-latest.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd
        http://www.liquibase.org/xml/ns/pro
        http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd">
  <changeSet id="1" author="mike">
    <createTable tableName="project">
      <column name="id" type="uuid">
        <constraints primaryKey="true" nullable="false"/>
      </column>
    </createTable>
  </changeSet>
  <changeSet id="2" author="mike">
    <createTable tableName="project_objectives">
      <column name="objectives_id" type="uuid">
        <constraints nullable="false"/>
      </column>
      <column name="project_id" type="uuid">
        <constraints nullable="false"/>
      </column>
    </createTable>
    <addPrimaryKey columnNames="project_id, objectives_id" tableName="project_objectives"/>
  </changeSet>
  <changeSet id="2-data" author="mike" context="test">
    <loadData
				file="test-data/project_objectives.csv"
				separator=";"
				tableName="project_objectives">
      <column name="objectives_id" type="uuid"/>
      <column name="project_id" type="uuid"/>
    </loadData>
  </changeSet>
</databaseChangeLog>
2

Add a CSV for Liquibase to insert

Add a CSV for Liquibase to insert with the same name as the loadData file above. In this exmple, it is project_objectives.csv in the test-data folder:

CSV to insert
objectives_id;project_id			
8d1208fc-f401-496c-9cb8-483fef121234;ea5bc0ab-6ccf-4791-a048-694a5be1d309
8d1208fc-f401-496c-9cb8-483fef121234;1a8aebee-2061-4220-99ce-ddaf2b22d23f
cce54793-00b8-4830-8f3c-e4cb97b8fb70;1bc59ddb-8d4d-41d0-9c9a-34e837de5678
234c2416-e7f2-47bf-afdc-03645b3a98ab;1bc59ddb-8d4d-41d0-9c9a-34e837de5678
234c2416-e7f2-47bf-afdc-03645b3a98ab;1482cc79-fd01-42e4-b5a1-a7f0db546d00
12349c78-454a-4167-9a1e-8e853a4cf2f5;072e217f-76b3-4cae-b3bd-f7c71a8e0003
1234bf02-0ffa-4b52-b22f-a10e76e31cb5;98f275cd-934d-42cd-91e4-fa0acd7dc5eb
e6b920b7-4ac4-4b62-aea7-36f75e3ad610;dddd728e-fd2c-4a1c-8a10-ffd84ed1603c
ef8614c9-f4d7-4b56-9aaa-088cbe9f7e71;dddd728e-fd2c-4a1c-8a10-ffd84ed1603c
678abcde-898a-4cd9-8aae-99a1943b2ebf;dddd728e-fd2c-4a1c-8a10-ffd84ed1603c
3

Run liquibase update to create the table and insert the data.

Use UUID and load data - Liquibase