centaurus 0.17.4

A utility library for various use cases.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

use sea_orm_migration::{prelude::*, schema::*};

use crate::db::migrations::m3_user::User;

#[derive(DeriveMigrationName)]
pub struct Migration;

const OIDC_SUBJECT_INDEX_NAME: &str = "user.user_oidc_subject";

#[async_trait::async_trait]
impl MigrationTrait for Migration {
  async fn up(&self, manager: &SchemaManager) -> Result<(), DbErr> {
    manager
      .alter_table(
        Table::alter()
          .table(User::Table)
          .add_column(string_null(User::OidcSubject))
          .to_owned(),
      )
      .await?;

    manager
      .create_index(
        Index::create()
          .if_not_exists()
          .name(OIDC_SUBJECT_INDEX_NAME)
          .table(User::Table)
          .col(User::OidcSubject)
          .unique()
          .to_owned(),
      )
      .await
  }

  async fn down(&self, manager: &SchemaManager) -> Result<(), DbErr> {
    manager
      .drop_index(Index::drop().name(OIDC_SUBJECT_INDEX_NAME).to_owned())
      .await?;

    manager
      .alter_table(
        Table::alter()
          .table(User::Table)
          .drop_column(User::OidcSubject)
          .to_owned(),
      )
      .await
  }
}