@andrew-farries could not we run pgroll baseline as part of start and migrate when run against non-empty schema?

@andrew-farries could not we run pgroll baseline as part of start and migrate when run against non-empty schema?

We could automatically run the baseline, but we'd have to prompt the user for a baseline version name as the baseline command does. The user may also want to populate and test the placeholder baseline migration before they proceed with applying any other migrations.

It feels more like this is a scenario where the user should be in control of the baseline rather than making it happen automatically.

Having it happen after a prompt sounds good to me!

Yes, absolutely. We could make the user aware, and give them the option to add a version name. I think it would still be an improvement if we let the baseline process start and once that's complete, prompted with complete, a bit more hand-holding at that stage too.

The CTA to run pgroll baseline more is more obvious in 808912d.

Not sure about prompting the user directly in migrate/start. Currently, the only commands that will wait for user input are:

• create
• baseline

migrate is going to be run in automated workflows, so I don't think it should block on user input. We would need a flag to abort if a baseline is needed instead of prompting but maybe just the call to run baseline in the output is enough here without adding more flags to the migrate command?

The CTA to run pgroll baseline more is more obvious in 808912d.

Not sure about prompting the user directly in migrate/start. Currently, the only commands that will wait for user input are:

• create
• baseline

migrate is going to be run in automated workflows, so I don't think it should block on user input. We would need a flag to abort if a baseline is needed instead of prompting but maybe just the call to run baseline in the output is enough here without adding more flags to the migrate command?

Good point, we would not want to break CI/CD processes of our users. I am okay with "Run pgroll baseline first" in the output.