在liquibase中为插入查询定义变更集 [英] Define Changeset for insert query in liquibase

问题描述

我有两个表，如下所示:

I have two table as following :

CREATE TABLE StudentMaster (
  sId      SERIAL,
  StudentName VARCHAR(50)
);

CREATE TABLE StudentClassMap (
  studnetId BIGINT UNSIGNED NOT NULL,
  studentClass VARCHAR(10),
  FOREIGN KEY (studnetId) REFERENCES StudentMaster (sId)
);

这是我的插入查询.

INSERT INTO StudentMaster (studentName) values ('Jay Parikh');

INSERT INTO StudentClassMap (studnetId, studentClass)
values ((SELECT sId from StudentMaster where studentName='Jay Parikh'),
        'M.Sc. 1st Year');

我想为 liquibase 中的查询定义 ChangeSet .

对于第一个查询 ChangeSet 为:

<changeSet author="unknown" id="insert-example">
    <insert tableName="StudentMaster ">
        <column name="studentName" value="Jay Parikh"/>
    </insert>
</changeSet>

但是我不知道如何为另一个查询定义 ChangeSet .
有什么帮助吗?预先感谢.

But I don't know how to define ChangeSet for another query.
Any help ? Thanks in advance.

推荐答案

使用valueComputed属性:

Use the valueComputed attribute:

<changeSet author="unknown" id="insert-example-2">
    <insert tableName="StudentClassMap">
        <column name="studentId" valueComputed="(SELECT sId from StudentMaster where studentName='Jay Parikh')"/>
        <column name="studentClass" value="McSc. 1st Year"/>
    </insert>
</changeSet>

这篇关于在liquibase中为插入查询定义变更集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！