db: eliminate diesel_async_migrations

Use normal diesel_migrations instead with diesel_async's `migrations`
feature, as diesel_async_migrations hasn't been updated to recent
diesel. Requires us to switch to an atomic to manually implement the
Once behavior and run it synchronously (internally calls
tokio::task::block_in_place). Shouldn't be an issue as it's single-shot.

1 files changed, 4 insertions, 4 deletions

diff --git a/Cargo.toml b/Cargo.toml
index 9bcee3d..b7ad7dc 100644
--- a/Cargo.toml
+++ b/Cargo.toml
@@ -24,7 +24,7 @@ required-features = ["db"]
 
 [features]
 default = ["db", "games", "windows_autostart_postgres"]
-db = ["dep:diesel", "dep:diesel-async", "dep:diesel_async_migrations", "dep:tokio-postgres", "dep:deadpool-postgres"]
+db = ["dep:diesel", "dep:diesel-async", "dep:tokio-postgres", "dep:deadpool-postgres"]
 games = []
 windows_autostart_postgres = []
 
@@ -73,9 +73,9 @@ symphonia = { version = "0.5", features = ["all"] } # reminder: needed for songb
 
 poise = "0.6"
 
-diesel = { version = "2.1", features = ["chrono"], optional = true }
-diesel-async = { version = "0.4", optional = true, features = ["deadpool", "postgres"] }
-diesel_async_migrations = { version = "0.12", optional = true }
+diesel = { version = "2.3", features = ["chrono"], optional = true }
+diesel_migrations = "2.3"
+diesel-async = { version = "0.7", optional = true, features = ["deadpool", "postgres", "migrations"] }
 tokio-postgres = { version = "0.7", optional = true, features = ["with-chrono-0_4"] }
 deadpool-postgres = { version = "0.14", optional = true }