durable-db 0.11.3

Database migrations and schema for the durable workflow engine
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

use sea_orm_migration::prelude::*;

#[derive(DeriveMigrationName)]
pub struct Migration;

const UP: &str = r#"
ALTER TABLE durable.task ADD COLUMN IF NOT EXISTS recovery_count INT NOT NULL DEFAULT 0;
ALTER TABLE durable.task ADD COLUMN IF NOT EXISTS max_recovery_attempts INT NOT NULL DEFAULT 100;
"#;

const DOWN: &str = r#"
ALTER TABLE durable.task DROP COLUMN IF EXISTS max_recovery_attempts;
ALTER TABLE durable.task DROP COLUMN IF EXISTS recovery_count;
"#;

#[async_trait::async_trait]
impl MigrationTrait for Migration {
    async fn up(&self, manager: &SchemaManager) -> Result<(), DbErr> {
        manager.get_connection().execute_unprepared(UP).await?;
        Ok(())
    }

    async fn down(&self, manager: &SchemaManager) -> Result<(), DbErr> {
        manager.get_connection().execute_unprepared(DOWN).await?;
        Ok(())
    }
}