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?
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?
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
@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.