springBoot生成SQL文件-基于Liquibase实现

1
liquibase {
2
  activities {
3
    main {
4
      changeLogFile 'src/main/db/main.groovy'
5
      url project.ext.mainUrl
6
      username project.ext.mainUsername
7
      password project.ext.mainPassword
8
    }
9
    security {
10
      changeLogFile 'src/main/db/security.groovy'
11
      url project.ext.securityUrl
12
      username project.ext.securityUsername
13
      password project.ext.securityPassword
14
    }
15
    diffMain {
16
      changeLogFile 'src/main/db/main.groovy'
17
      url project.ext.mainUrl
18
      username project.ext.mainUsername
19
      password project.ext.mainPassword
20
      difftypes 'data'
21
    }
22
  }
23
  runList = project.ext.runList
24
}

1
apply plugin: 'org.liquibase.gradle'
2

3
dependencies {
4
    liquibaseRuntime 'org.liquibase:liquibase-core:3.6.2'
5
    liquibaseRuntime 'org.liquibase:liquibase-groovy-dsl:2.0.1'
6
    liquibaseRuntime 'mysql:mysql-connector-java:5.1.34'
7
}
8

9
def buildTimestamp() {
10
  def date = new Date()
11
  def formattedDate = date.format('yyyyMMddHHmmss')
12
  return formattedDate
13
}
14

15
task diffDBSQL(){
16
  doFirst{
17
    File propsFile = new File("${rootProject.projectDir}/qycms-core/common/src/main/resources/application.properties")
18
        Properties properties = new Properties()
19
        properties.load(new FileInputStream(propsFile))
20

21
    def changeLogOutPutFileURL = "${rootProject.projectDir}/db/liquibase/changelog/changelog-diff-master-"+ buildTimestamp()+".yaml"
22
      def outputFileURL = "${rootProject.projectDir}/db/liquibase/diffSQL-"+buildTimestamp()+".sql"
23
      def referenceDriverURL =  "${properties.contains('parim.datasource.referenceDriver-class-name')}" == true ? "${properties.contains('parim.datasource.referenceDriver-class-name')}" : "${properties.get('spring.datasource.driver-class-name')}"
24

25
      liquibase {
26
          activities {
27
              diff {
28
                  driver "${properties.get('spring.datasource.driver-class-name')}"
29
                  url "${properties.get('spring.datasource.url')}"
30
                  username "${properties.get('spring.datasource.username')}"
31
                  password "${properties.get('spring.datasource.password')}"
32

33
                  referenceDriver "${referenceDriverURL}"
34
                  referenceUrl "${properties.get('qy.datasource.referenceUrl')}"
35
                  referenceUsername  "${properties.get('qy.datasource.referenceUsername')}"
36
                  referencePassword  "${properties.get('qy.datasource.referencePassword')}"
37

38
                  changeLogFile "${changeLogOutPutFileURL}"
39
                  outputFile "${outputFileURL}"
40
              }
41
              runList = "diff" // 这里代表选择哪一个配置 可用参数代替
42
          }
43
      }
44
  }
45

46
  doLast{
47
    diffChangeLog.execute()
48
    updateSQL.execute()
49
  }
50
}

1
buildscript {
2
    repositories {
3
        mavenCentral()
4
    }
5
    dependencies {
6
        classpath 'org.springframework.boot:spring-boot-gradle-plugin:2.0.3.RELEASE'
7
    }
8
}
9

10
plugins {
11
    id 'java'
12
    id 'idea'
13
    id 'io.franzbecker.gradle-lombok' version '1.14'
14
    id 'org.liquibase.gradle' version '2.0.1'
15
}
16

17
apply plugin: 'org.springframework.boot'
18
apply plugin: 'io.spring.dependency-management'
19

20
group 'de.bobek'
21
version '1.0-SNAPSHOT'
22

23
sourceCompatibility = 1.8
24
targetCompatibility = 1.8
25

26
repositories {
27
    mavenCentral()
28
}
29

30
dependencies {
31
    compile 'org.springframework.boot:spring-boot-starter-web'
32
    compile 'org.springframework.boot:spring-boot-starter-data-jpa'
33
    compile 'org.liquibase:liquibase-core'
34
    compile 'com.h2database:h2'
35
    liquibaseRuntime 'org.liquibase:liquibase-core:3.6.2'
36
    liquibaseRuntime 'org.liquibase.ext:liquibase-hibernate5:3.6'
37
    liquibaseRuntime 'mysql:mysql-connector-java:5.1.46'
38
    liquibaseRuntime 'org.springframework.boot:spring-boot:2.0.1.RELEASE'
39
    liquibaseRuntime 'org.springframework:spring-orm:5.0.5.RELEASE'
40
    liquibaseRuntime sourceSets.main.output
41
}
42

43
diff.dependsOn compileJava
44
diffChangeLog.dependsOn compileJava
45

46
liquibase {
47
    activities {
48
        main {
49
            driver 'com.mysql.jdbc.Driver'
50
            url 'jdbc:mysql://127.0.0.1:3306/my_database'
51
            username 'root'
52
            password ''
53
            changeLogFile 'src/main/resources/db/changelog/changelog-master.xml'
54
            referenceUrl 'hibernate:spring:de.bobek' +
55
                    '?dialect=org.hibernate.dialect.MySQL5Dialect' +
56
                    '&hibernate.physical_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy' +
57
                    '&hibernate.implicit_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringImplicitNamingStrategy'
58
        }
59
    }
60
}