gradle - 无法在gradle中使用flyway插件执行SQL文件

Question

我创建了一个简单的spring-boot Gradle项目。我希望在构建项目时通过SQL文件中的flyway插件创建数据库。以下是我的代码段。项目已成功构建，但是在mydb1数据库中未创建SQL文件中提到的表。

build.gradle文件

buildscript {
    ext {
        springBootVersion = '2.0.1.RELEASE'
    }
    repositories {
        mavenCentral()
    }
    dependencies {
        classpath("org.springframework.boot:spring-boot-gradle-plugin:${springBootVersion}")
    }
}

plugins {
    id "org.flywaydb.flyway" version "5.0.7"
}

apply plugin: 'java'
apply plugin: 'idea'
apply plugin: 'org.springframework.boot'
apply plugin: 'io.spring.dependency-management'

group = 'com.flywayex'
version = '0.0.1-SNAPSHOT'
sourceCompatibility = 1.8

repositories {
    mavenCentral()
}

dependencies {
    compile('org.springframework.boot:spring-boot-starter-web')
    runtime('com.h2database:h2')
    testCompile('org.springframework.boot:spring-boot-starter-test')
}

task createDatabase() {
    doLast {
        println 'Hello Gradle to copy'
        flyway {
            println "Flyway: "
            driver = 'org.h2.Driver'
            url = 'jdbc:h2:mem:mydb1'
            user = 'sa'
            locations = ['filesystem:db/migration']
            println "Flyway: $locations"
        }
    }
}

build.dependsOn createDatabase

V1.init1.sql文件放置在resources / db / migration下

CREATE TABLE users (
  id bigint(20) NOT NULL AUTO_INCREMENT,
  username varchar(100) NOT NULL,
  first_name varchar(50) NOT NULL,
  last_name varchar(50) DEFAULT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY UK_username (username)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

我想念什么？

Answer 1

我怀疑找不到您的迁移脚本。尝试以下任一方法:

locations "filesystem:${project.projectDir}/src/main/resources/db/migration"

要么

locations "classpath:db/migration"