SeaQL · SteelAlloy · May 28, 2025
diff --git a/issues/2610/Cargo.toml b/issues/2610/Cargo.toml
@@ -0,0 +1,15 @@
+[package]
+name = "sea-orm-issues-2610"
+version = "0.1.0"
+edition = "2024"
+
+[lib]
+name = "migration"
+path = "src/lib.rs"
+
+[dependencies]
+async-std = { version = "1", features = ["attributes", "tokio1"] }
+sea-orm-migration = { version = "1.1.12", features = [
+  "runtime-tokio-rustls",
+  "sqlx-postgres",
+] }
diff --git a/issues/2610/src/lib.rs b/issues/2610/src/lib.rs
@@ -0,0 +1,14 @@
+pub use sea_orm_migration::prelude::*;
+
+mod m20220101_000001_init;
+
+pub struct Migrator;
+
+#[async_trait::async_trait]
+impl MigratorTrait for Migrator {
+    fn migrations() -> Vec<Box<dyn MigrationTrait>> {
+        vec![
+            Box::new(m20220101_000001_init::Migration),
+        ]
+    }
+}
diff --git a/issues/2610/src/m20220101_000001_init.rs b/issues/2610/src/m20220101_000001_init.rs
@@ -0,0 +1,31 @@
+use sea_orm_migration::prelude::*;
+
+#[derive(DeriveMigrationName)]
+pub struct Migration;
+
+#[async_trait::async_trait]
+impl MigrationTrait for Migration {
+    async fn up(&self, manager: &SchemaManager) -> Result<(), DbErr> {
+        let db = manager.get_connection();
+
+        db.execute_unprepared(
+            "--sql
+            CREATE EXTENSION IF NOT EXISTS pg_trgm",
+        )
+        .await?;
+
+        Ok(())
+    }
+
+    async fn down(&self, manager: &SchemaManager) -> Result<(), DbErr> {
+        let db = manager.get_connection();
+
+        db.execute_unprepared(
+            "--sql
+            DROP EXTENSION IF EXISTS pg_trgm",
+        )
+        .await?;
+
+        Ok(())
+    }
+}
diff --git a/issues/2610/src/main.rs b/issues/2610/src/main.rs
@@ -0,0 +1,6 @@
+use sea_orm_migration::prelude::*;
+
+#[async_std::main]
+async fn main() {
+    cli::run_cli(migration::Migrator).await;
+}