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 handler TEXT;
CREATE INDEX IF NOT EXISTS "idx-task-handler" ON durable.task(handler);
"#;

const DOWN: &str = r#"
DROP INDEX IF EXISTS durable."idx-task-handler";
ALTER TABLE durable.task DROP COLUMN IF EXISTS handler;
"#;

#[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(())
    }
}