Skip to content

armgit / macro

Public Imported from GitHub
0

Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.

15.2 KB
Raw Blame
//! The one catalog every stage's tests run against.

use models_databases::{ColumnId, DatabaseId, OptionId, TableId, ViewId};
use uuid::Uuid;

use crate::catalog::{
    Catalog, Column, ColumnKind, EntityKind, SelectOption, Table, TableSource, people_table,
};

pub const CRM: DatabaseId = DatabaseId::from_uuid(Uuid::from_u128(0xdb0));
pub const SALES: DatabaseId = DatabaseId::from_uuid(Uuid::from_u128(0xdb1));
pub const MACRO: DatabaseId = DatabaseId::from_uuid(Uuid::from_u128(0xdb2));
pub const DEALS: TableId = TableId::from_uuid(Uuid::from_u128(0xd0));
pub const PEOPLE: TableId = TableId::from_uuid(Uuid::from_u128(0xd1));
pub const SALES_DEALS: TableId = TableId::from_uuid(Uuid::from_u128(0xd2));
pub const NAME: Uuid = Uuid::from_u128(0x01);
pub const AMOUNT: Uuid = Uuid::from_u128(0x02);
pub const STAGE: Uuid = Uuid::from_u128(0x03);
pub const CLOSED_AT: Uuid = Uuid::from_u128(0x04);
pub const OWNER: Uuid = Uuid::from_u128(0x05);
pub const TAGS: Uuid = Uuid::from_u128(0x06);
pub const DONE: Uuid = Uuid::from_u128(0x07);
pub const WEBSITE: Uuid = Uuid::from_u128(0x08);
pub const LEAD: OptionId = OptionId::from_uuid(Uuid::from_u128(0x31));
pub const WON: OptionId = OptionId::from_uuid(Uuid::from_u128(0x30));
pub const VIP: OptionId = OptionId::from_uuid(Uuid::from_u128(0x32));
pub const TASKS: TableId = TableId::from_uuid(Uuid::from_u128(0xd3));
pub const TITLE: Uuid = Uuid::from_u128(0x11);
pub const PRIORITY: Uuid = Uuid::from_u128(0x12);
pub const ASSIGNEES: Uuid = Uuid::from_u128(0x13);
pub const DEAL: Uuid = Uuid::from_u128(0x14);
pub const HIGH: OptionId = OptionId::from_uuid(Uuid::from_u128(0x41));
pub const LOW: OptionId = OptionId::from_uuid(Uuid::from_u128(0x42));

/// `crm.deals` with one column of every kind, `crm.people` (sharing the
/// `name` definition with `crm.deals`), a second `deals` table in another
/// database so bare names can be ambiguous, `macro.tasks` with people
/// assigned and a deal linked, and the platform `macro.people`.
pub fn catalog() -> Catalog {
    Catalog {
        scope: None,
        tables: vec![
            Table {
                id: DEALS,
                database_id: CRM,
                database: "crm".into(),
                name: "deals".into(),
                columns: vec![
                    Column {
                        id: NAME,
                        placement: ColumnId::from_uuid(NAME),
                        name: "name".into(),
                        kind: ColumnKind::Text,
                        formula: None,
                    },
                    Column {
                        id: AMOUNT,
                        placement: ColumnId::from_uuid(AMOUNT),
                        name: "amount".into(),
                        kind: ColumnKind::Number,
                        formula: None,
                    },
                    Column {
                        id: STAGE,
                        placement: ColumnId::from_uuid(STAGE),
                        name: "stage".into(),
                        kind: ColumnKind::Select {
                            multi: false,
                            options: vec![
                                SelectOption {
                                    id: LEAD,
                                    label: "Lead".into(),
                                },
                                SelectOption {
                                    id: WON,
                                    label: "Won".into(),
                                },
                            ],
                        },
                        formula: None,
                    },
                    Column {
                        id: CLOSED_AT,
                        placement: ColumnId::from_uuid(CLOSED_AT),
                        name: "closed at".into(),
                        kind: ColumnKind::Date,
                        formula: None,
                    },
                    Column {
                        id: OWNER,
                        placement: ColumnId::from_uuid(OWNER),
                        name: "owner".into(),
                        kind: ColumnKind::Entity {
                            multi: false,
                            target: EntityKind::User,
                        },
                        formula: None,
                    },
                    Column {
                        id: TAGS,
                        placement: ColumnId::from_uuid(TAGS),
                        name: "tags".into(),
                        kind: ColumnKind::Select {
                            multi: true,
                            options: vec![SelectOption {
                                id: VIP,
                                label: "vip".into(),
                            }],
                        },
                        formula: None,
                    },
                    Column {
                        id: DONE,
                        placement: ColumnId::from_uuid(DONE),
                        name: "done".into(),
                        kind: ColumnKind::Boolean,
                        formula: None,
                    },
                    Column {
                        id: WEBSITE,
                        placement: ColumnId::from_uuid(WEBSITE),
                        name: "website".into(),
                        kind: ColumnKind::Link,
                        formula: None,
                    },
                ],
                source: TableSource::Database,
            },
            Table {
                id: PEOPLE,
                database_id: CRM,
                database: "crm".into(),
                name: "people".into(),
                columns: vec![Column {
                    id: NAME,
                    placement: ColumnId::from_uuid(NAME),
                    name: "name".into(),
                    kind: ColumnKind::Text,
                    formula: None,
                }],
                source: TableSource::Database,
            },
            Table {
                id: SALES_DEALS,
                database_id: SALES,
                database: "sales".into(),
                name: "deals".into(),
                columns: vec![],
                source: TableSource::Database,
            },
            Table {
                id: TASKS,
                database_id: MACRO,
                database: "macro".into(),
                name: "tasks".into(),
                columns: vec![
                    Column {
                        id: TITLE,
                        placement: ColumnId::from_uuid(TITLE),
                        name: "title".into(),
                        kind: ColumnKind::Text,
                        formula: None,
                    },
                    Column {
                        id: PRIORITY,
                        placement: ColumnId::from_uuid(PRIORITY),
                        name: "priority".into(),
                        kind: ColumnKind::Select {
                            multi: false,
                            options: vec![
                                SelectOption {
                                    id: HIGH,
                                    label: "High".into(),
                                },
                                SelectOption {
                                    id: LOW,
                                    label: "Low".into(),
                                },
                            ],
                        },
                        formula: None,
                    },
                    Column {
                        id: ASSIGNEES,
                        placement: ColumnId::from_uuid(ASSIGNEES),
                        name: "assignees".into(),
                        kind: ColumnKind::Entity {
                            multi: true,
                            target: EntityKind::User,
                        },
                        formula: None,
                    },
                    Column {
                        id: DEAL,
                        placement: ColumnId::from_uuid(DEAL),
                        name: "deal".into(),
                        kind: ColumnKind::Entity {
                            multi: false,
                            target: EntityKind::Row,
                        },
                        formula: None,
                    },
                ],
                source: TableSource::Database,
            },
            people_table(),
        ],
    }
}

pub const WORK: DatabaseId = DatabaseId::from_uuid(Uuid::from_u128(0xdb3));
pub const ISSUES: TableId = TableId::from_uuid(Uuid::from_u128(0xd4));
pub const SUMMARY: Uuid = Uuid::from_u128(0x51);
pub const SUMMARY_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x61));
pub const POINTS: Uuid = Uuid::from_u128(0x52);
pub const POINTS_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x62));
pub const STATUS: Uuid = Uuid::from_u128(0x53);
pub const STATUS_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x63));
pub const DUE: Uuid = Uuid::from_u128(0x54);
pub const DUE_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x64));
pub const BLOCKED: Uuid = Uuid::from_u128(0x55);
pub const BLOCKED_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x65));
pub const LABELS: Uuid = Uuid::from_u128(0x56);
pub const LABELS_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x66));
pub const ASSIGNEE: Uuid = Uuid::from_u128(0x57);
pub const ASSIGNEE_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x67));
pub const REVIEWERS: Uuid = Uuid::from_u128(0x58);
pub const REVIEWERS_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x68));
pub const SPEC: Uuid = Uuid::from_u128(0x59);
pub const SPEC_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x69));
pub const PARENT: Uuid = Uuid::from_u128(0x5a);
pub const PARENT_PLACEMENT: ColumnId = ColumnId::from_uuid(Uuid::from_u128(0x6a));
pub const TODO: OptionId = OptionId::from_uuid(Uuid::from_u128(0x71));
pub const DOING: OptionId = OptionId::from_uuid(Uuid::from_u128(0x72));
pub const WONT_DO: OptionId = OptionId::from_uuid(Uuid::from_u128(0x73));
pub const BUG: OptionId = OptionId::from_uuid(Uuid::from_u128(0x74));
pub const FEATURE: OptionId = OptionId::from_uuid(Uuid::from_u128(0x75));

/// `work.issues`, the table views are tested on: one column of every kind,
/// each placed under an id of its own, so a view (which names placements)
/// and a query (which names definitions) can be told apart.
pub fn issues_catalog() -> Catalog {
    Catalog {
        scope: None,
        tables: vec![Table {
            id: ISSUES,
            database_id: WORK,
            database: "work".into(),
            name: "issues".into(),
            columns: vec![
                Column {
                    id: SUMMARY,
                    placement: SUMMARY_PLACEMENT,
                    name: "summary".into(),
                    kind: ColumnKind::Text,
                    formula: None,
                },
                Column {
                    id: POINTS,
                    placement: POINTS_PLACEMENT,
                    name: "points".into(),
                    kind: ColumnKind::Number,
                    formula: None,
                },
                Column {
                    id: STATUS,
                    placement: STATUS_PLACEMENT,
                    name: "status".into(),
                    kind: ColumnKind::Select {
                        multi: false,
                        options: vec![
                            SelectOption {
                                id: TODO,
                                label: "Todo".into(),
                            },
                            SelectOption {
                                id: DOING,
                                label: "Doing".into(),
                            },
                            SelectOption {
                                id: WONT_DO,
                                label: "Won't do".into(),
                            },
                        ],
                    },
                    formula: None,
                },
                Column {
                    id: DUE,
                    placement: DUE_PLACEMENT,
                    name: "due date".into(),
                    kind: ColumnKind::Date,
                    formula: None,
                },
                Column {
                    id: BLOCKED,
                    placement: BLOCKED_PLACEMENT,
                    name: "blocked".into(),
                    kind: ColumnKind::Boolean,
                    formula: None,
                },
                Column {
                    id: LABELS,
                    placement: LABELS_PLACEMENT,
                    name: "labels".into(),
                    kind: ColumnKind::Select {
                        multi: true,
                        options: vec![
                            SelectOption {
                                id: BUG,
                                label: "bug".into(),
                            },
                            SelectOption {
                                id: FEATURE,
                                label: "feature".into(),
                            },
                        ],
                    },
                    formula: None,
                },
                Column {
                    id: ASSIGNEE,
                    placement: ASSIGNEE_PLACEMENT,
                    name: "assignee".into(),
                    kind: ColumnKind::Entity {
                        multi: false,
                        target: EntityKind::User,
                    },
                    formula: None,
                },
                Column {
                    id: REVIEWERS,
                    placement: REVIEWERS_PLACEMENT,
                    name: "reviewers".into(),
                    kind: ColumnKind::Entity {
                        multi: true,
                        target: EntityKind::User,
                    },
                    formula: None,
                },
                Column {
                    id: SPEC,
                    placement: SPEC_PLACEMENT,
                    name: "\"spec\" link".into(),
                    kind: ColumnKind::Link,
                    formula: None,
                },
                Column {
                    id: PARENT,
                    placement: PARENT_PLACEMENT,
                    name: "parent".into(),
                    kind: ColumnKind::Entity {
                        multi: false,
                        target: EntityKind::Row,
                    },
                    formula: None,
                },
            ],
            source: TableSource::Database,
        }],
    }
}

pub const ISSUES_VIEW: ViewId = ViewId::from_uuid(Uuid::from_u128(0x7e1));

/// A view of `work.issues`.
pub fn issues_view(
    query: models_databases::views::ViewQuery,
    layout: models_databases::views::ViewLayout,
) -> models_databases::views::DatabaseView {
    use chrono::{TimeZone, Utc};
    models_databases::views::DatabaseView {
        id: ISSUES_VIEW,
        database_id: WORK,
        table_id: ISSUES,
        name: "Open work".into(),
        position: "80".parse().unwrap(),
        query,
        layout,
        created_at: Utc.with_ymd_and_hms(2026, 9, 1, 0, 0, 0).unwrap(),
        updated_at: Utc.with_ymd_and_hms(2026, 9, 1, 0, 0, 0).unwrap(),
    }
}