Liquibase updateSQL

#1

Hi All,

Our project uses liquibase, but for deployment to UAT we dont directly run liquibase to DB. We actually run liquibase updateSQL and then run the scripts generated. How do I get the flowable db scripts as part of liquibase updateSQL?

#2

Hey @sukalpo,

Have you looked at the flowable-sql repository? It has some scripts that you could run to have the SQL generated for you.

Cheers,
Filip

#3

@filiphr Thanks for the reply. I havent looked at the repository but I looked at the application boot up logs and found the sql that was executed. I am getting the sql from there

2019-04-16 19:53:24 [restartedMain] INFO  o.f.i.e.impl.db.IdmDbSchemaManager - performing create on identity with resource org/flowable/idm/db/create/flowable.h2.create.identity.sql

2019-04-16 19:53:24 [restartedMain] INFO o.f.idm.engine.impl.IdmEngineImpl - IdmEngine default created
2019-04-16 19:53:24 [restartedMain] INFO o.f.c.e.i.db.CommonDbSchemaManager - performing create on common with resource org/flowable/common/db/create/flowable.h2.create.common.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.i.s.i.d.IdentityLinkDbSchemaManager - performing create on identitylink with resource org/flowable/identitylink/service/db/create/flowable.h2.create.identitylink.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.i.s.i.d.IdentityLinkDbSchemaManager - performing create on identitylink.history with resource org/flowable/identitylink/service/db/create/flowable.h2.create.identitylink.history.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.e.s.i.d.EntityLinkDbSchemaManager - performing create on entitylink with resource org/flowable/entitylink/service/db/create/flowable.h2.create.entitylink.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.e.s.i.d.EntityLinkDbSchemaManager - performing create on entitylink.history with resource org/flowable/entitylink/service/db/create/flowable.h2.create.entitylink.history.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.t.s.impl.db.TaskDbSchemaManager - performing create on task with resource org/flowable/task/service/db/create/flowable.h2.create.task.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.t.s.impl.db.TaskDbSchemaManager - performing create on task.history with resource org/flowable/task/service/db/create/flowable.h2.create.task.history.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.v.s.i.db.VariableDbSchemaManager - performing create on variable with resource org/flowable/variable/service/db/create/flowable.h2.create.variable.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.v.s.i.db.VariableDbSchemaManager - performing create on variable.history with resource org/flowable/variable/service/db/create/flowable.h2.create.variable.history.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.j.s.impl.db.JobDbSchemaManager - performing create on job with resource org/flowable/job/service/db/create/flowable.h2.create.job.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.e.impl.db.ProcessDbSchemaManager - performing create on engine with resource org/flowable/db/create/flowable.h2.create.engine.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.e.impl.db.ProcessDbSchemaManager - performing create on history with resource org/flowable/db/create/flowable.h2.create.history.sql

I was more eager to see if there is any property that spits out these sql when we have liquibase configured and we set the goal of liquibase as updateSQL.