Function create_bakery_table

tests/partial_model_nested/local/model/schema.rs:12–53

(db: &DbConn)

}

pub async fn create_bakery_table(db: &DbConn) -> Result<ExecResult, DbErr> {
    let stmt = Table::create()
        .table(bakery::Entity)
        .col(
            ColumnDef::new(bakery::Column::Id)
                .integer()
                .not_null()
                .auto_increment()
                .primary_key(),
        )
        .col(ColumnDef::new(bakery::Column::Name).string().not_null())
        .col(
            ColumnDef::new(bakery::Column::ProfitMargin)
                .double()
                .not_null(),
        )
        .col(
            ColumnDef::new(bakery::Column::ManagerId)
                .integer()
                .not_null(),
        )
        .col(
            ColumnDef::new(bakery::Column::CashierId)
                .integer()
                .not_null(),
        )
        .foreign_key(
            ForeignKey::create()
                .name("fk-bakery-manager_id")
                .from(bakery::Entity, bakery::Column::ManagerId)
                .to(worker::Entity, worker::Column::Id),
        )
        .foreign_key(
            ForeignKey::create()
                .name("fk-bakery-cashier_id")
                .from(bakery::Entity, bakery::Column::CashierId)
                .to(worker::Entity, worker::Column::Id),
        )
        .to_owned();

    create_table(db, &stmt, bakery::Entity).await
}

pub async fn create_worker_table(db: &DbConn) -> Result<ExecResult, DbErr> {
    let stmt = Table::create()