Migrations

[mareq]

I am trying to get the migrations working - the ideal result would be the app upon starting to check if the database exists (and if not, then create it) and then run all the migrations on it automatically before starting to accept inputs.

I have created migrations directory with an SQL script named 0000_init.sql with just some CREATE TABLE. I then try to use it:

let postgres = PgPool::connect(postgres_uri.as_str()).await.unwrap();
let migrator = Migrator::new(Path::new("./migrations")).await.unwrap();
migrator.run(postgres).await.unwrap();

The table _sqlx_migrations gets created, but it is empty and the unwraps above fail with VersionMissing(0) error. It looks like there is a problem with that table being empty, so I tried to insert something to it:

INSERT INTO _sqlx_migrations VALUES (0, 'Lorem ipsum', now(), TRUE, decode('deadbeef', 'base64'), 42);

The checksum is obviously wrong and I now get VersionMismatch(0) error.

I have a hard time finding some good working example or documentation for this. I tried to look also at the tests, but there dos not seem to be much there neither (there seems to be some postgres docker container there, but migrations do not seem to connect to the database at all).

Can someone please point me to some docs or even better to a working code example?

[mareq]

So, to answer my own question, it turned out to be pretty stupid problem on my side: I figured out all the structure of the migration scripts required by the Migrator apart of simple fact that the numbering has to start at 1 (as opposed to at 0).

I have submitted #1054 to add the documentation about this.