Issue on docs: Migrations are not running in the Axum Postgres Todo App

[albrow]

Path: /examples/axum-postgres

Following the instructions and sending a POST or GET request to the server results in the following error:

error returned from database: relation "todos" does not exist

I manually connected to the database via the psql CLI and I can see that the todos table was not created.

This is happening because the migration filename is not formatted correctly. The documentation for sqlx MigrationSource explains:

... a MigrationSource is a directory which contains the migration SQL scripts. All these scripts must be stored in files with names using the format _.sql, where is a string that can be parsed into i64 and its value is greater than zero, and is a string.

The solution is actually very simple. All you need to do is add the prefix 1_ to the filename. So rename ./migrations/schema.sql to ./migrations/1_schema.sql. After I applied this fix locally I was able to confirm that the todos table was created and everything worked as expected.