rhkp commented on PR #2790:
URL: 
https://github.com/apache/incubator-kie-tools/pull/2790#issuecomment-2631931280

   > Hi @rhkp , while doing some testing I have found a small issue in the DB 
Migrator:
   > 
   > Let me explain:
   > 
   > A database produced by the DB Migrator looks like this:
   > 
   > 
![DataBase-DB-Migrator](https://private-user-images.githubusercontent.com/2431454/409227439-5618c25c-47f1-4584-8429-e57b72406d54.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg2MDk4MzMsIm5iZiI6MTczODYwOTUzMywicGF0aCI6Ii8yNDMxNDU0LzQwOTIyNzQzOS01NjE4YzI1Yy00N2YxLTQ1ODQtODQyOS1lNTdiNzI0MDZkNTQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI1MDIwMyUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNTAyMDNUMTkwNTMzWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9OTJmYjVlNDRmZjFhM2FkNGNkYmZmYTE4NzU2MDE0NTJlZGFkOTM5ZTBiMzEwNmZmZDM2YmIzMWYzOGI0NTgyZCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.UwBTN7WqGKG3Ja5CSyUsWCJPoFsjnND3m0EJR7vVoh4)
   > 
   > On the other hand, if we start the data index service (not using the db 
migrator) and we enable flyway for the data index, we can see a database like 
this:
   > 
   > 
![DataBase-DataIndex](https://private-user-images.githubusercontent.com/2431454/409227785-2a26bc6b-6868-4fb1-af6c-75dbefdb1733.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg2MDk4MzMsIm5iZiI6MTczODYwOTUzMywicGF0aCI6Ii8yNDMxNDU0LzQwOTIyNzc4NS0yYTI2YmM2Yi02ODY4LTRmYjEtYWY2Yy03NWRiZWZkYjE3MzMucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI1MDIwMyUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNTAyMDNUMTkwNTMzWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9ZWU4M2VmNWU1ODYxNGIxMTg3ZDBiM2YxZTdhNGYxM2I4Y2FiOTBjMjk2ZTM1ZWVmYjI4N2Q4ZDhkZGRhZTJiMiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.uywoDuCtwwm6fNjzR05Bqg4549Ij1_5tZi6Tpa0M92Y)
   > 
   > So we have a 1.5.0 and 1.5.1 files that are included by the data index 
service but not by the db migrator.
   > 
   > This is basically because the data index service has a dependency on the 
`persistence-commons` module that incorporates the missing files.
   > 
   > Your work is good! but we need to make the db migrator incorporate the 
.sql files provided by that module.
   > 
   > See here in the db migrator build structure:
   > 
   > 
![MissingSqlFiles](https://private-user-images.githubusercontent.com/2431454/409229818-194479fc-7d3e-4a9a-8be5-9e9e618f59dd.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg2MDk4MzMsIm5iZiI6MTczODYwOTUzMywicGF0aCI6Ii8yNDMxNDU0LzQwOTIyOTgxOC0xOTQ0NzlmYy03ZDNlLTRhOWEtOGJlNS05ZTllNjE4ZjU5ZGQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI1MDIwMyUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNTAyMDNUMTkwNTMzWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9MWU1ODAwZjAwOGU1ZjJhN2I0Njk1Y2FhY2E4MmQwNTg1MjIwMjRlNGRmMThlNWE2ZWFhNGQ0OTgxYmVmMmNhYyZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.e9tya7kwDTq0uK6QJaHVoLrtKCOlijKJiTWLDM_C56Y)
   > 
   > would you mind take a look ?
   
   Hi @wmedvede / @ricardozanini,
   Please note we are using maven's 
[`maven-dependency-plugin`](https://github.com/rhkp/incubator-kie-tools/blob/main/packages/kogito-db-migrator-tool/pom.xml#L69)
 to download ddl files dynamically and use them for DB migration for DI & JS . 
   
   Should not all the sql files needed by data-index and jobs-service be 
available from zip file that we download with maven-dependency-plugin? 
   
   Please advise.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to