CODEWITHSUNDEEP
sqloracle-databaseliquibasechangelog
Raghav Vaidhyanathan
Raghav Vaidhyanathan

Reputation: 905

executing a common sql file using liquibase

I have a situation to handle, i have my liquibase structured as per the best practices recommended. I have the change log xml structured as given below 

Master XML 
  -->Release XML 
     -->Feature XML 
        -->changelog XML

In our application group, we run updateSQL to generate the consolidated sql file and get the changes executed through our DBA group.

However, the real problem I have is to execute a common set of sql statements during every iteration. Like 

ALTER SESSION SET CURRENT_SCHEMA=APPLNSCHEMA

as the DBA executes the changes as SYSTEM but the target schema is APPLNSCHEMA.

How to include such common repeating statements in Liquibase changelog.

Upvotes: 0

Views: 4945

Answers (3)

Sander_V
Sander_V

Reputation: 21

You could make a changeSet with the attribute 'runAlways' set to true and include the SQL.

Upvotes: 1

Nathan Voxland
Nathan Voxland

Reputation: 15783

You would be able to write an extension (http://liquibase.org/extensions) that injects it in. If you need to do it per changeLog, it may work best to extend XMLChangeLogParser to automatically create and add a new changeSet that runs the needed SQL.

Upvotes: 1

SteveDonie
SteveDonie

Reputation: 9016

As far as I know, there isn't a way to have Liquibase itself do this. I suggest that you wrap Liquibase with your favorite scripting language such that you run a command "generateSQLforThoseCrazyDBAs" that runs Liquibase and then prepends the SQL you need to the output created by Liquibase.

Upvotes: -1

Related Questions