sea-orm icon indicating copy to clipboard operation
sea-orm copied to clipboard

`#[sea_orm(indexed, unique)]` doesn't create unique index

Open haruki-nikaidou opened this issue 6 months ago • 0 comments

Description

#[sea_orm(indexed, unique)] doesn't create unique index

Reproducible Example

#[derive(Clone, Debug, PartialEq, DeriveEntityModel)]
#[sea_orm(table_name = "user_email_account")]
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: i32,
    #[sea_orm(indexed, unique)]
    pub email: String,
    #[sea_orm(column_type = "Text")]
    pub password: String,
    #[sea_orm(indexed)]
    pub user_id: Uuid,
}

#[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]
pub enum Relation {}

impl ActiveModelBehavior for ActiveModel {}

#[cfg(test)]
mod tests {
    use super::{Entity, Column};
    use sea_orm::sea_query::*;
    use sea_orm::{DbBackend, EntityName, Schema};

    #[test]
    fn test_schema() {
        let schema = Schema::new(DbBackend::Postgres);
        let create_index = schema.create_index_from_entity(Entity);
        let idx_email = Index::create()
            .name("idx-user_email_account-email")
            .table(Entity.table_ref())
            .col(Column::Email)
            .unique()
            .to_owned();
        assert_eq!(
            DbBackend::Postgres.build(&idx_email),
            DbBackend::Postgres.build(&create_index[0]),
        );
    }
}

Expected Behavior

assertion successful

Actual Behavior

assertion left == right failed left: Statement { sql: "CREATE UNIQUE INDEX \"idx-user_email_account-email\" ON \"amco_auth\".\"user_email_account\" (\"email\")", values: None, db_backend: Postgres } right: Statement { sql: "CREATE INDEX \"idx-user_email_account-email\" ON \"user_email_account\" (\"email\")", values: None, db_backend: Postgres }

Reproduces How Often

Always

Versions

├── sea-orm v1.1.7
│   ├── sea-orm-macros v1.1.7 (proc-macro)
│   │   ├── sea-bae v0.2.1 (proc-macro)
│   ├── sea-query v0.32.3
│   ├── sea-query-binder v0.7.0
│   │   ├── sea-query v0.32.3 (*)
├── sea-orm v1.1.7 (*)

haruki-nikaidou avatar Apr 05 '25 12:04 haruki-nikaidou