I would like to allow Liquibase to fully manage not only database migrations, but also the data within it.
I have a question pertaining to the usage of keys and foreign keys when using Say I have a table ‘b’ that references another table ‘a’. In insert syntax, i have to do something like this in changeSet id=‘1’:
That’s fine for initial production data. But say that tables a and b will, once run in production, have more data that ‘pollutes’ available IDs.
So say in changeSet 2, I want to add another entry into table a, and would like to also add another entry into b that references that table a. How would I know what id to use, safely?
I’m trying to avoid using sql directly.