Integration between subprojects Migrations (Runtime) and Spring Boot Autoconfigure

[jmoraleda]

We already use mybatis-spring-boot-autoconfigure and Mybatis in our project extensively and are very happy with it.

We currently use liquibase for schema migration, and are reasonably happy with it, but we are missing the flexibility of mybatis and are considering moving to Mybatis Migrations Runtime Schema Upgrade instead.

We have been unable to find any documentation on how to integrate the Migrations Runtime with Spring, including testing, in particular using Mybatis Spring Boot Autoconfigure. Can you point us in the right direction or even some examples?

We are aware of the project https://github.com/Bessonov/mybatis-migrations-spring-boot-autoconfigure and the discussion here #74 but those are three years old, so we are wondering if any work has been done since then. Thank you.

[harawata]

Hello @jmoraleda ,

Does this answer help?
https://stackoverflow.com/a/55873047

[jmoraleda]

Hello @harawata Thank you very much for your super quick response! I just tested your sample project with our database and it works beautifully. This fully answers my question. Thank you for a great project!

[jmoraleda]

Hello @harawata. Inspired by your post and the autoconfigure project mentioned above I have created the attached project that is fully operational and integrates mybatis migrations into a spring boot project. One can specify in application.yaml multiple java packages and/or resource folders in the jar/war containing the sql scripts.

It depends on our own parent pom, so you won't be able to compile it directly, but you should not have any problem with it as there are no external dependencies other than lombok, (which would be trivial for you to remove if you don't want that).

My company, Meticy LLC, is happy to open source and donate this code as is, to mybatis, to use in any way you wish, if your organization finds it, or parts of it, useful.

The only feature that in my opinion is missing that one might want to add is the ability to work with multiple data sources, but we have a single data source so I have not gone into that.

Thank you again.
Latest version of code as described at #162 (comment): mybatis-migrations-spring-boot.zip

[h3adache]

I think this would be great idea as it seems that several people are doing this work on their own. I’ll try to take a look at your solution and also touch base with @harawata

On Mon, Mar 2, 2020 at 18:47 Jorge Moraleda ***@***.***> wrote: Hello @harawata <https://github.com/harawata>. Inspired by your post and the autoconfigure project mentioned above I have created the attached project that is fully operational and integrates mybatis migrations into a spring boot project. One can specify in application.yaml multiple java packages and/or resource folders in the jar/war containing the sql scripts. It depends on our own parent pom, so you won't be able to compile it directly, but you should not have any problem with it as there are no external dependencies other than lombok, (which would be trivial for you to remove if you don't want that). My company, Meticy LLC, is happy to open source and donate this code as is, to mybatis, to use in any way you wish, if your organization finds it, or parts of it, useful. The only feature that in my opinion is missing that one might want to add is the ability to work with multiple data sources, but we have a single data source so I have not gone into that. Thank you again. mybatis-migrations-spring-boot.zip <https://github.com/mybatis/migrations/files/4278567/mybatis-migrations-spring-boot.zip> — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#162?email_source=notifications&email_token=AACOGGZHNW3ZZY7QA3Q6JETRFRARNA5CNFSM4K67NRP2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOENRN4PQ#issuecomment-593681982>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AACOGG2YCVBQ3XUO5ZULBHDRFRARNANCNFSM4K67NRPQ> .

--

[jmoraleda]

I added the feature where the changelog table is created automatically mybatis-migrations-spring-boot.zip

[Bessonov]

Hey folks, I've switched from Java to Node and therefore I'm not able to test and maintain the project mentioned by @jmoraleda in regards of time and quality. Is there any work happens @h3adache ? It would be nice to have an official integration. If you want to use my project as a base or in parts I'm very happy to grant everything.