problem description
I feel that there is so little information about Liquibase, basically about how to update it directly to the database. I don"t know how to implement its SQL Output mode. I just mentioned it on the official website, but I couldn"t find out where to set it for a long time.
the environmental background of the problems and what methods you have tried
it is now possible to update the database content directly through the gradle plug-in liquibase-gradle-plugin, but the goal is to generate a new sql file with its statements.
related codes
/ / Please paste the code text below (do not replace the code with pictures)
build.gradle
liquibase {
activities {
dev {
changeLogFile "${rootProject.projectDir}/db/liquibase/changelog-master.yaml"
url "jdbc:MySQL://localhost:3306/windcoder?characterEncoding=utf8&useSSL=false"
driver "com.mysql.jdbc.Driver"
username "windcoder"
password "root"
outputFile "${rootProject.projectDir}/db/test.sql"
}
runList = "dev" //
}
}
changelog-master.yaml
databaseChangeLog:
- changeSet:
id: 1
author: windcoder
changes:
- sqlFile:
encoding: utf8
path: db/mysql/test1.sql
test1.sql
INSERT INTO `sys_role` ( `name`, `remark`,display_order,created_date,last_modified_date,created_by, last_modified_by) VALUES ("", "",1,now(),now(),2,2);
what result do you expect? What is the error message actually seen?
expects to generate test.sql files, now executing gradle update
can only save directly to the database.