启动期间未执行SQL脚本

Question

我希望在启动Spring boot应用程序时始终运行SQL脚本。我添加了这个液化酶配置：

application.yml

spring:
  datasource:
    platform: org.hibernate.dialect.PostgreSQL95Dialect
    url: jdbc:postgresql://10.10.10.10:5432/test
    driverClassName: org.postgresql.Driver
    username: root
    password: test
  liquibase:
    changeLog: 'classpath:db/changelog/db.changelog-master.yaml'
    dropFirst: false
  jpa:
    hibernate:
      ddl-auto: update
    show-sql: true
    database: postgresql

db。变更日志主机。亚马尔

databaseChangeLog:
  - include:
      file: db/changelog/changes/ch_0001/changelog.yaml

变更日志。亚马尔

databaseChangeLog:
  - include:
      file: db/changelog/changes/ch_0001/data/data.yaml

data.yaml

databaseChangeLog:
  - changeSet:
      id: 0001
      author: test
      dbms: postgres
      runAlways: true # WARNING - remove this before prod - it will run every time with clean data
      changes:
        - sqlFile:
            - relativeToChangelogFile: true
            - path: data.sql

data.sql

INSERT into tasks SELECT generate_series(1,355) AS id,
    left (md5(random()::text), 10) AS business_name,
    (select NOW() + (random() * (NOW()+'90 days' - NOW())) + '30 days') AS created_at,
    left (md5(random()::text), 10) AS meta_title,
    left (md5(random()::text), 10) AS status,
    left (md5(random()::text), 10) AS title,
    left (md5(random()::text), 10) AS task_type,
    (select NOW() + (random() * (NOW()+'90 days' - NOW())) + '30 days') AS updated_at;

数据库表应该填充测试数据，但事实并非如此。我看不到日志data.sql文件执行。

你知道问题出在哪里吗？

Answer 1

似乎您没有添加完整配置。

尝试添加这些。

spring:
  liquibase:
    change-log: classpath:db/changelog/db.changelog-master.yaml
    url: {same as spring.datasource.url}
    user: {same as spring.datasource.username}
    password: {same as spring.datasource.password}
    enabled: true

对于Postgres DBdbmd值为postgresql。不是postgres。参考-这里

更新了数据。yml

databaseChangeLog:
  - changeSet:
      id: 0001
      author: test
      dbms: postgresql
      runAlways: true # WARNING - remove this before prod - it will run every time with clean data
      changes:
        - sqlFile:
            - relativeToChangelogFile: true
            - path: data.sql