appstruct-schema 0.2.0

Database schema contracts and deterministic SQL snapshots for AppStruct
Documentation
use super::{ColumnSchema, DatabaseType, ForeignKeySchema, TableSchema};
use appstruct_ir::{AppIr, GeneratedValueIr, OnDeleteIr};

const FILES: &str = "_appstruct_files";

pub(super) fn tables() -> Vec<TableSchema> {
    vec![TableSchema {
        id: "appstruct::file::files".to_owned(),
        name: FILES.to_owned(),
        columns: vec![
            column("id", DatabaseType::Uuid, false, true, false),
            column("object_key", DatabaseType::Text, false, false, true),
            column("original_name", DatabaseType::Text, false, false, false),
            column("content_type", DatabaseType::Text, false, false, false),
            column("size", DatabaseType::Bigint, false, false, false),
            column("checksum", DatabaseType::Text, false, false, false),
            column("tenant_id", DatabaseType::Uuid, true, false, false),
            column("created_at", DatabaseType::Datetime, false, false, false),
            ColumnSchema {
                default: Some("[]".to_owned()),
                ..column("reference_owners", DatabaseType::Json, false, false, false)
            },
            ColumnSchema {
                generated: Some(GeneratedValueIr::Now),
                ..column(
                    "unreferenced_at",
                    DatabaseType::Datetime,
                    true,
                    false,
                    false,
                )
            },
            ColumnSchema {
                default: Some("false".to_owned()),
                ..column("deleting", DatabaseType::Boolean, false, false, false)
            },
        ],
    }]
}

pub(super) fn foreign_keys(ir: &AppIr) -> Vec<ForeignKeySchema> {
    if !ir.tenant.enabled {
        return Vec::new();
    }
    vec![ForeignKeySchema {
        id: "appstruct::file::file_tenant".to_owned(),
        source_table: FILES.to_owned(),
        source_columns: vec!["tenant_id".to_owned()],
        target_table: "_appstruct_tenant_organizations".to_owned(),
        target_columns: vec!["id".to_owned()],
        unique: false,
        on_delete: OnDeleteIr::SetNull,
    }]
}

fn column(
    name: &str,
    data_type: DatabaseType,
    nullable: bool,
    primary_key: bool,
    unique: bool,
) -> ColumnSchema {
    ColumnSchema {
        id: format!("appstruct::file::files.{name}"),
        name: name.to_owned(),
        data_type,
        nullable,
        primary_key,
        unique,
        default: None,
        generated: None,
    }
}