Say you want to set up a Liquibase changelog to insert some data, but you don't know the IDs of some entity, and you can express it as a query. With Liquibase's computed column attribute, you can embed subqueries directly into seed data:
Mind the parentheses! Liquibase converts a loadData change into an INSERT INTO ... VALUES (...) statement, so your subqueries need to be tucked in and cozy.
Your changelog should look something like this:
And that's it! Let me know if this is useful to you! Liquibase's documentation is pretty rough in parts, and it took me a little bit to figure out how to assemble these pieces into a solution to my problem.
The link has been copied!
You’ve successfully subscribed to Jordan Thevenow-Harrison
Welcome back! You’ve successfully signed in.
Great! You’ve successfully signed up.
Success! Your email is updated.
Your link has expired
Success! Check your email for magic link to sign-in.