Error in down migration: `Specify some SQL code to execute` about surrealdb-migrations

[Odonno]

Hi Stephan

This error seems to happen when your migration file is empty, see https://github.com/surrealdb/surrealdb/blob/main/lib/src/err/mod.rs#L78

Can you share a reproducible example so I can see what is wrong.

If your .surql file is indeed empty, you can safely remove it and the error should go away.

[unidesigner]

Hi David

The migration are not empty, so there must be another reason. Here is the folder with the files.

term2.tar.gz

With the following code

$ surrealdb-migrations apply --address ws://localhost:8000 --ns test --db term2 --username root --password root 
Executing migration AddPost...
Schema files successfully executed!
Migration files successfully executed!
$ surrealdb-migrations apply --down 0 --address ws://localhost:8000 --ns test --db term2 --username root --password root 
Error: Specify some SQL code to execute

using

surrealdb-migrations 0.9.10
surreal: 1.0.0-beta.9+20230402.5eafebd for linux on x86_64

Thanks for help!

[Odonno]

Ok, this is my mistake. BTW, thanks for sharing this reproducible example!

When applying revert (on rollback migrations), I parse the schemas and events statements to detect the difference between them in order to correctly rollback to the previous database schema. However, parsing empty string (without any statement) fails miserably. When you have a migration project without event, it then fails for this reason.

I am now releasing the v0.9.11 which will fix this error.

Thank you for reporting this error.

[unidesigner]

This works now! Thanks a lot for the quick response, fix and this useful tool. I hope you will continue developing it.