Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
199 views
in Technique[技术] by (71.8m points)

How perform db migration on multiple db with ebean?

I have a problem and I can't find solution on docs.

In my project I want to manage migration on two different database.

I create two db connections with code like this:

val dataSourceConfigOne = DataSourceConfig()
dataSourceConfigOne.url = ...

val configOne = DatabaseConfig()
configOne.dataSourceConfig = dataSourceConfigOne
configOne.isDefaultServer = true
configOne.name= "firstdb"

val dbONE = DatabaseFactory.create(configOne)

val dataSourceConfigTWO = DataSourceConfig()
dataSourceConfigTWO.url = ...

val configTWO = DatabaseConfig()
configTWO.dataSourceConfig = dataSourceConfigTWO
configTWO.isDefaultServer = false
configTWO.name= "seconddb"

val dbTWO = DatabaseFactory.create(configTWO)

I have different table on dbOne and on dbTwo this:

@Entity(name="table_db_one")
open class TableDBOne(....)

@DbName("db_two")
@Entity(name="table_db_two")
open class TableDBTwo(....):Model("db_two)

Now i want generate the migration for eatch database. And for this reason I wrote a simple main function like this:

val dbMigration = DbMigration.create()
dbMigration.setPlatform(Platform.POSTGRES)
dbMigration.setMigrationPath("one") // or two
dbMigration.setServer(dbOne) //or dbtwo
dbMigration.generateMigration()

The result is that all entities regardless of the database are generated in each migration. How can I split the migration for dbOne and dbTwo? thx


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...