Migrate postgres schema programmatically?

[ralberth]

I'd like to deploy OpenFGA with a Postgres database back-end and have it fully automated. Think "infrastructure as code" with Puppet, Chef, or AWS. For my use case, I'm using CDK on AWS.

Likely steps:

1. Deploy database
2. Run "openfga migrate" to create tables <-- problem
3. Start OpenFGA container
4. Create Store if it doesn't exist
5. Deploy my model to the store

I can't find a way to migrate (create db tables, etc.) programmatically. There's no API available I can see, and the SDK doesn't include anything. The OpenFGA container will fail if the tables don't exist at startup, so the migration has to precede OpenFGA startup.

Ideally, I could run the container with something like this:

docker run -p 8080:8080 ... openfga/openfga:latest run --auto-db-migrate

My current solution is to abandon the benefits of the container being built on chainguard, create a custom image with a built-in shell, and have the entrypoint run "bash -c '/openfga migrate && /openfga run'".

Other thoughts?