Creating a new table

[alper]

I want to create a new table, so I threw together a Model. Now what do I do?

I can't find any examples of how to create the database table from this nor where to put the code.

[alper]

The (very helpful) Axum example has this:

pub async fn create_post_table(db: &DbConn) -> Result<ExecResult, DbErr> {
    let stmt = sea_query::Table::create()
        .table(super::post::Entity)
        .if_not_exists()
        .col(
            ColumnDef::new(super::post::Column::Id)
                .integer()
                .not_null()
                .auto_increment()
                .primary_key(),
        )
        .col(

But that seem like I'm repeating myself if I already have the model definition.

[alper]

The only way around it to move forward quickly that I see is to create the table in Postgres manually and then derive the the model from there using sea-orm-cli generate (which as far as I can see does not do much more than that?).

[alper]

I could piece this together:

    let backend = conn.get_database_backend();
    let schema = Schema::new(backend);
    let table_create_statement = schema.create_table_from_entity(FoursquareGmapsMappings);
    let table_create_result = conn.execute(backend.build(&table_create_statement)).await;

    println!("Table create result: {:?}", table_create_result.unwrap());

[billy1624]

Yep, this is the way of doing it. Before we have migration (#335) in place

[alper]

I think this could maybe also be updated in the Axum example?

[billy1624]

Good idea!