`sqitch upgrade` should create schema if not exists

[lorddaedra]

We should add ability to create sqitch schema without first deploy. Because of sometimes we do not need real first deploy, we would like to "fake" it (mark some migration as deployed without actual changes). But it's not possible to do without sqitch schema with several tables.

docker rm -f third && docker run --name third \
 -e POSTGRES_USER=third \
 -e POSTGRES_PASSWORD=third \
 -e POSTGRES_DB=third \
 -p 5433:5432 \
 -d postgres:15

sqitch upgrade --target db:pg://third:third@localhost:5433/third
Upgrading registry db:pg://third@localhost:5433/third to version 1.1
Upgrading the Sqitch registry from 0 to 1.1
  * From 0 to 1.0
psql:/usr/local/Cellar/sqitch/1.5.0/lib/perl5/App/Sqitch/Engine/Upgrade/pg-1.0.sql:10: ERROR:  schema "sqitch" does not exist
LINE 1: CREATE TABLE "sqitch".releases (
                     ^
"/usr/local/bin/psql" unexpectedly returned exit value 3

[theory]

I've often thought an init command that just creates the registry would be handy, but never needed it and no one has asked — until now. At any rate, You can get the same result by using --log-only to deploy a single change, then revert it and truncate the events table. Something like this:

❯ sqitch deploy --log-only db:pg:try @ROOT
Deploying changes through first-change to db:pg:try
  + first-change .. ok

❯ sqitch revert --log-only db:pg:try -y
Reverting all changes from db:pg:try
  - first-change .. ok

~/Downloads/tmp 
❯ psql try -c 'TRUNCATE sqitch.events'
TRUNCATE TABLE

[lorddaedra]

Thank you for mention --log-only!

I thought that this functionality was not yet implemented in Sqitch and so I started trying to look for workarounds. (Make an empty sqitch schema and manually add changes there via SQL. Another idea was to make SQL migration idempotent via IF NOT EXISTS)

So I will use --log-only 👍🏻