本文阅读量 次
1. Java 语言及生态¶
1.1 Flyway¶
- Flyway 命令行参数手册 https://documentation.red-gate.com/fd/parameters-224919673.html ⧉
- https://www.red-gate.com/hub/product-learning/flyway/customizing-database-deployments-using-flyway-callbacks-and-placeholders ⧉
flyway 支持 .conf
和 .toml
两种配置文件的格式,但不能同时支持两种
1.1.1 配置文件搜索顺序¶
{installDir}/conf/flyway.toml {installDir}/conf/flyway.user.toml {userhome}/flyway.toml {userhome}/flyway.user.toml {executionDir}/flyway.toml {executionDir}/flyway.user.toml {workingDirectory}/flyway.toml {workingDirectory}/flyway.user.toml
1.1.2 flyway.conf 示例¶
flyway.conf
flyway.driver=org.hsqldb.jdbcDriver flyway.url=jdbc:hsqldb:file:/db/flyway_sample flyway.user=SA flyway.password=mySecretPwd flyway.connectRetries=10 flyway.initSql=SET ROLE 'myuser' flyway.defaultSchema=schema1 flyway.schemas=schema1,schema2,schema3 flyway.createSchemas=true flyway.table=schema_history flyway.tablespace=my_tablespace flyway.locations=classpath:com.mycomp.migration,database/migrations,filesystem:/sql-migrations,s3:migrationsBucket,gcs:migrationsBucket flyway.sqlMigrationPrefix=Migration- flyway.undoSqlMigrationPrefix=downgrade flyway.repeatableSqlMigrationPrefix=RRR flyway.sqlMigrationSeparator=__ flyway.sqlMigrationSuffixes=.sql,.pkg,.pkb flyway.stream=true flyway.batch=true flyway.encoding=ISO-8859-1 flyway.placeholderReplacement=true flyway.placeholders.aplaceholder=value flyway.placeholders.otherplaceholder=value123 flyway.placeholderPrefix=#[ flyway.placeholderSuffix=] flyway.resolvers=com.mycomp.project.CustomResolver,com.mycomp.project.AnotherResolver flyway.skipDefaultCallResolvers=false flyway.callbacks=com.mycomp.project.CustomCallback,com.mycomp.project.AnotherCallback flyway.skipDefaultCallbacks=false flyway.target=5.1 flyway.outOfOrder=false flyway.outputQueryResults=false flyway.validateOnMigrate=true flyway.cleanOnValidationError=false flyway.mixed=false flyway.group=false flyway.cleanDisabled=false flyway.baselineOnMigrate=false flyway.installedBy=my-user flyway.errorOverrides=99999:17110:E,42001:42001:W flyway.dryRunOutput=/my/sql/dryrun-outputfile.sql flyway.lockRetryCount=10 flyway.oracle.sqlplus=true flyway.oracle.sqlplusWarn=true flyway.workingDirectory=C:/myProject flyway.jdbcProperties.myProperty=value
1.2 参考¶
- 如何下载 OpenJDK 历史版本 https://jdk.java.net/archive/ ⧉ https://www.openlogic.com/openjdk-downloads ⧉
- Eclipse JDK 版本下载 https://adoptium.net/ ⧉
- Eclipse JDK 系统支持版本 https://adoptium.net/supported-platforms/ ⧉