Variable passing question

General Discussion
1

Hi. i am looking at liquibase to be used for loading/refresh test data into oracle database.

the scenario, i need to delete all the data related to specific user from tables before being able to reinsert it again. Deletion is generic for all users but it’s definitely using different ids. so i will have something like the following for each changeset

        <value=“0s1d25e2we1s2”/>

                        ...

how can I pass variable to the include file? or is there any suggestions? My intention with these, i can delete only data related to user1 instead of for all users

Thanks a lot for the help.
Andrew

2

I think changelog parameters are what you are looking for: http://www.liquibase.org/manual/changelog_parameters

Do they work for you?

Nathan

3

Thanks for the reply Nathan.
I got around it by creating SQL Proc for all deletion and it’s working well.

Thanks a lot