Liquibase双向关系更改日志顺序

Question

在现有项目中实现liquibase时，我遇到了一个问题。所以我们有两个实体：

公司：

@Entity
@Table(name = "company")
@EqualsAndHashCode(of = {}, callSuper = true)
@Setter
@AllArgsConstructor
@NoArgsConstructor
public class Company extends AbstractAccount {
private String organizationName;
private String mail;
private Set<Stock> stocks;
private Stock currentStock;
@Column(name = "organization_name", unique = true)
public String getOrganizationName() {
return organizationName;
}
@Email
@Column(name = "mail", unique = true)
public String getMail() {
return mail;
}
@Cascade({CascadeType.REMOVE, CascadeType.SAVE_UPDATE})
@OneToMany(mappedBy = "company", fetch = FetchType.LAZY)
public Set<Stock> getStocks() {
return stocks;
}
@OneToOne
@JoinColumn(name = "current_stock_id", referencedColumnName = "id")
public Stock getCurrentStock() {
return currentStock;
} 
}

库存：

@Entity
@Table(name = "stock")
@EqualsAndHashCode(of = {}, callSuper = true)
@Setter
@AllArgsConstructor
@NoArgsConstructor
public class Stock extends AbstractEntity {
private String name;
private Company company;
private Double fare;
@Column(name = "panel")
public Double getFare() {
return fare;
}
@NotBlank(message = "Название акции не может быть пустым.")
@Column(name = "name")
public String getName() {
return name;
}
@Cascade({CascadeType.SAVE_UPDATE})
@ManyToOne(fetch = FetchType.LAZY)
public Company getCompany() {
return company;
}
}

还有我的利口酒变更日志。

公司：

<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.8.xsd">
<changeSet id="1" author="Maxim Grankin">
<createTable tableName="company">
<column name="id" type="bigint" autoIncrement="true">
<constraints primaryKey="true" nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet id="2" author="Maxim Grankin">
<addColumn tableName="company">
<column name="organizationName" type="varchar(255)">
<constraints unique="true"/>
</column>
<column name="mail" type="varchar(255)">
<constraints unique="true"/>
</column>
<column name="current_stock_id" type="bigint"/>
</addColumn>
<addForeignKeyConstraint baseTableName="company" baseColumnNames="current_stock_id"
constraintName="fkoi5aq2bm82091ubh15kfj29m1"
referencedTableName="stock"
referencedColumnNames="id"/>
</changeSet>

库存：

<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.8.xsd">
<changeSet id="1" author="Maxim Grankin">
<createTable tableName="stock">
<column name="id" type="bigint" autoIncrement="true">
<constraints primaryKey="true" nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet id="2" author="Maxim Grankin">
<addColumn tableName="stock">
<column name="name" type="varchar(255)"/>
<column name="panel" type="double precision"/>
<column name="company_id" type="bigint"/>
</addColumn>
<addForeignKeyConstraint baseTableName="stock" baseColumnNames="company_id"
constraintName="fk9r297vk0rghnrccw09x0qybfj"
referencedTableName="company"
referencedColumnNames="id"/>
</changeSet>

和主：

<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-3.8.xsd
http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
<include file="data/changelogs/stock/stock/db.changelog.stock.xml"/>
<include file="data/changelogs/company/db.changelog.company.xml"/>

我有一个例外：

Caused by: org.postgresql.util.PSQLException: ERROR: relation "public.company" does not exist

我知道liquibase试图创建股票，然后添加company_id作为外键，尽管还没有公司表。我有很多双向关系，而这只是其中的一部分。

问题：如何组织liquibasechangeLogs以在一个构建中创建所有表及其之间的关系？我应该创造一些像"；db.changelogs.relationships"；我将在哪里设置外键？

UPD：关闭。使用liquibase 的maven插件生成您的changeLogs

Answer 1

根据我对问题的评论创建答案：

看起来您正在手动编写更改日志xml。如果您将更改日志安排为首先创建表和FK，那么就可以了。

• 创建表1、表2、表3
• 设置表1和表2、表2和表3之间的关系

更好的选择是使用liquibase插件(用于您的maven/gradle(来生成这样的更改日志。Liquibase将首先生成表的更改日志，然后生成FK，这样您就不必担心这一点。

将这些作为参考：

• https://github.com/gtiwari333/spring-boot-web-application-sample/blob/master/main-app/main-orm/pom.xml
• https://github.com/gtiwari333/spring-boot-web-application-sample/tree/master/main-app/main-orm/src/main/resources/liquibase/changelog

Answer 2

包含顺序需要在主更改日志文件中切换。执行db.changelog.stock.xml文件时尚未创建公司表。