How to Init Databases With Quarkus

[@ferjava]

Good tips! We actually don't need Postman, plain shellscript is waaay more efficient, nice ^^

[@yaojunshi3037]

do I have to use panache or other ORM framwork? I tried to inject a datasouce manually but it showed the UnsatisfiedResolutionException..

[@SebastianDaschnerIT]

No both should work. See here: quarkus.io/guides/datasource#named-datasource-injection

[@manee427]

Thanks perfect video. do we have something like JPARepository in Quarkus that make most of queried available out of the box or we have to always use plain SQL?

[@SebastianDaschnerIT]

kzbin.info/www/bejne/pnW2fKqPnruShNU :)

[@RafaelDurelli]

Awesome vid :D

[@stefanholtker3944]

How about using liquibase with context / label for test environments testdata?

[@SebastianDaschnerIT]

Haven't really used it as such, but yes, can surely work. What was your experience with it?

[@Markosiiiiii]

Great Sebastian! I have a question. I have my query sql: " select p.* from pcr_perfil p order by( select count(ppu.id_usu_perfil) from pcr_perfil_usuario ppu where ppu.id_perfil = p.id_perfil ) asc " that's works fine in sql. Question. How to make that query from panache quarkus? Please can anyone translate it to panache query?

[@SebastianDaschnerIT]

Well, in general you can directly execute native SQL queries, i.e. you can paste that into your code (e.g. with entity manager). But it might make sense to consider rewriting this query, in JPA query language in fact.

[@chandanupadhyay-oi7vo]

Can we create only one Entity for two database ( with same attributes ) in the project

[@SebastianDaschnerIT]

Yes, that should work

[@chandanupadhyay-oi7vo]

@@SebastianDaschnerIT how can u explain... or share any github link for reference