Dropping a table from a entity ( Adding example)

[aadi58002]

Description

When trying to create a table from a entity in sea orm there are examples -> https://github.com/SeaQL/sea-orm-rocket-starter/blob/master/src/db/migrations/mod.rs

But when trying to find example on how to drop a table there seem to be none.

use sea_orm::{Schema, ConnectionTrait, EntityTrait};

pub async fn create_table<E>(db_connection: &sea_orm::DatabaseConnection, entity: E)
where E: EntityTrait{
    let backend = db_connection.get_database_backend();
    let schema = Schema::new(backend);
    let execution = db_connection.execute(backend.build(&schema.create_table_from_entity(entity)));
    match execution.await {
        Ok(_) => println!("Created {}", entity.table_name()),
        Err(e) => println!("Error: {}", e),
    }
}

pub async fn drop_table<E>(db_connection: &sea_orm::DatabaseConnection, entity: E)
where
    E: EntityTrait,
{
    println!(
        "{:?}",
        Statement::from_sql_and_values(
            db_connection.get_database_backend(),
            &format!(r#"DROP TABLE "{}""#, entity.table_name()),
            vec![],
        )
    );
    let execution = db_connection.execute(Statement::from_sql_and_values(
        db_connection.get_database_backend(),
        &format!(r#"DROP TABLE {}"#, entity.table_name()),
        vec![],
    ));
    
    match execution.await {
        Ok(_) => println!("Deleted {}", entity.table_name()),
        Err(e) => println!("Error: {}", e),
    }
}

Steps to Reproduce

Expected Behavior

Actual Behavior

Reproduces How Often

Versions

│   ├── sea-orm v0.10.6
│   │   ├── sea-orm-macros v0.10.6 (proc-macro)
│   │   ├── sea-query v0.27.2
│   │   │   ├── sea-query-derive v0.2.0 (proc-macro)
│   │   ├── sea-query-binder v0.2.2
│   │   │   ├── sea-query v0.27.2 (*)
│   │   ├── sea-strum v0.23.0
│   │   │   └── sea-strum_macros v0.23.0 (proc-macro)

Additional Information

[billy1624]

Hey @aadi58002, check this https://www.sea-ql.org/SeaORM/docs/migration/writing-migration/#schema-mutation-methods