1.1.34 • Published 4 years ago
wise-paas-scada-dbmigrate v1.1.34
Introduction
- This is a Node.js wrapper for flyway(migration cli tool).
Requirement
- If your OS is linux, we put java binary file in project by default, and program will auto apply that version.
- If your OS isn't Linux, you need to install java 8 (java 9 will cause some issues).
- Node.js: 6.X.X (LTS)
Usage
const flywayCreator = require('wise-paas-scada-dbmigrate');
const flywayBasic = flywayCreator.flywayBasic;
const flywayCustom = flywayCreator.flywayCustom;
const flywayConf = {
host: '127.0.0.1',
port: '5432',
user: '',
pw: '',
db: '',
schema: 'scada_test'
};
try {
let flywayResult = flywayBasic.info(flywayConf);
console.log(flywayResult.result);
} catch (err) {
console.error(err);
}
API description
All APIs are synchronous.
- Basic API
flywayBasic.info(flywayConf)
flywayBasic.migrate(flywayConf)
- We add "
group: true
" option by default, reason to do batch transaction, so this api has a little bit difference between nativ one.
- We add "
flywayBasic.validate(flywayConf)
flywayBasic.baseline(flywayConf)
flywayBasic.clean(flywayConf)
- Customized API
flywayCustom.baselineOnMigrate(flywayConf)
- We add addtional options by default:
group: true
: do batch transaction.baselineOnMigrate: true
: Whether to automatically call baseline when migrate is executed against a non-empty schema with no metadata table. This schema will then be baselined with the baselineVersion before executing the migrations. Only migrations above baselineVersion will then be applied.
- We add addtional options by default:
Test Case
- For empty schema, migrate v1
- For empty schema, V1,V2,V3, migrate respectively, ex. migrate V1, then create V2 file, finally run migrate V2...
- Use Migrate, For empty schema, V1,V2,V3, batch migrate, migrate these 3 sql files continuously
- Use baselineOnMigrate, For empty schema, V1,V2,V3, batch migrate, migrate these 3 sql files continuously
- transaction: one file and batch files
- For existed schema, it will baseline cureent schema and value as V1, then run migration from V2.
- Test if run on multi instance PCF is OK.
Notes
flywayBasic.clean(flywayConf)
會刪除schema,包含裡面的table,reloation等等....使用前請在三確認,建議可以再測試環境試試看。flywayCustom.baselineOnMigrate(flywayConf)
使用前請確認existed schema跟migration V1是相同的,因為Baseline後會從V2開始做migrate,詳情請參考baselineOnMigrate
參數說明。
Reference
1.1.34
4 years ago
1.1.33
4 years ago
1.1.32
5 years ago
1.1.31
5 years ago
1.1.30
5 years ago
1.1.29
5 years ago
1.1.28
5 years ago
1.1.27
5 years ago
1.1.26
5 years ago
1.1.25
5 years ago
1.1.24
5 years ago
1.1.23
5 years ago
1.1.22
5 years ago
1.1.21
5 years ago
1.1.20
5 years ago
1.1.19
5 years ago
1.1.18
5 years ago
1.1.17
5 years ago
1.1.16
5 years ago
1.1.15
6 years ago
1.1.14
6 years ago
1.1.13
6 years ago
1.1.12
6 years ago
1.1.11
6 years ago
1.1.10
6 years ago
1.1.9
6 years ago
1.1.8
6 years ago
1.1.7
6 years ago
1.1.6
6 years ago
1.1.5
6 years ago
1.1.4
6 years ago
1.1.3
6 years ago
1.1.2
6 years ago
1.1.1
6 years ago
1.1.0
6 years ago