How can I manually run migrations?

[MiguelSOliveira]

I'm using a system where I do an account restore where I overwrite the "app.db" file with another file. I would like to not have to close the app in order for the migrations to be re-run.

For example, I may overwrite a file with the schemaVersion of 6 with another with a schemaVersion of 3 and I would like for the migrations to run without the user closing the app.

Can I run them on demand?

[davidmartos96]

Migrations are run when the schema version of the database file in the device differs from the one that is passed when the db is opened. In the case of moor is through the getter in the AppDatabase file.
You could create a constructor for the database that receives a specific version. Then you can simply close and reopen the database to trigger the migrations

[MiguelSOliveira]

I think the problem might be in the way I'm reopening the database?

[davidmartos96]

Is possible that the instance of the database used there is the old one.
You can try printing the hashCode of the db after replacing and where it fails.

[davidmartos96]

I'd recommend restarting the app if possible with your requirements.
Or carefully handle the database instance after it has been recreated with get_it or with provider

[MiguelSOliveira]

You were totally right David, it was indeed the wrong hashCode, I'm now using getIt.

Sorry for the time it took for me to notice it, really appreciate your help man.

[davidmartos96]

No worries. Glad you got it working! ;)