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.

3.0 KB
Raw Blame
-- This fixture creates one Document, one Chat, and one Project.
-- The timestamps are deliberately different for each item's createdAt, updatedAt,
-- and UserHistory updatedAt to test all three sorting methods independently.

-- Expected Order for CreatedAt:   Project, Chat, Document
-- Expected Order for UpdatedAt:   Chat, Document, Project
-- Expected Order for LastViewed:  Document, Project, Chat

SET session_replication_role = 'replica';

-- Base Setup
INSERT INTO public."Organization" ("id", "name", "status")
VALUES (1, 'Test Org', 'PILOT')
ON CONFLICT DO NOTHING;

INSERT INTO public."macro_user" ("id", "username", "email", "stripe_customer_id")
VALUES ('a1111111-1111-1111-1111-111111111111', '[email protected]', '[email protected]', 'stripe_id');

INSERT INTO public."User" ("id", "email", "stripeCustomerId", "organizationId", "macro_user_id")
VALUES ('macro|[email protected]', '[email protected]', 'stripe_id', 1, 'a1111111-1111-1111-1111-111111111111');

-- Item Creation with distinct timestamp orders
-- Project: Newest created, Oldest updated, Middle viewed
INSERT INTO public."Project" ("id", "name", "userId", "createdAt", "updatedAt")
VALUES ('ffffffff-ffff-ffff-ffff-ffffffffffff', 'Project Alpha', 'macro|[email protected]', '2024-01-03 10:00:00', '2024-02-01 10:00:00');

-- Chat: Middle created, Newest updated, Oldest viewed
INSERT INTO public."Chat" ("id", "userId", "name", "isPersistent", "createdAt", "updatedAt")
VALUES ('cccccccc-1111-1111-1111-111111111111', 'macro|[email protected]', 'Chat Bravo', true, '2024-01-02 10:00:00', '2024-02-03 10:00:00');

-- Document: Oldest created, Middle updated, Newest viewed
INSERT INTO public."Document" ("id", "name", "fileType", "owner", "createdAt", "updatedAt")
VALUES ('dddddddd-dddd-dddd-dddd-dddddddddddd', 'Document Charlie', 'pdf', 'macro|[email protected]', '2024-01-01 10:00:00',
        '2024-02-02 10:00:00');

-- Dependencies
INSERT INTO public."DocumentFamily" ("id", "rootDocumentId")
VALUES (1, 'dddddddd-dddd-dddd-dddd-dddddddddddd');
INSERT INTO public."DocumentInstance" ("id", "documentId", "sha")
VALUES (1, 'dddddddd-dddd-dddd-dddd-dddddddddddd', 'sha-charlie');

-- User Access
INSERT INTO public.entity_access ("entity_id", "entity_type", "source_id", "source_type", "access_level")
VALUES ('ffffffff-ffff-ffff-ffff-ffffffffffff', 'project', 'macro|[email protected]', 'user', 'owner'),
       ('cccccccc-1111-1111-1111-111111111111', 'chat', 'macro|[email protected]', 'user', 'owner'),
       ('dddddddd-dddd-dddd-dddd-dddddddddddd', 'document', 'macro|[email protected]', 'user', 'owner');

-- User History with its own distinct ordering
INSERT INTO public."UserHistory" ("userId", "itemId", "itemType", "updatedAt")
VALUES ('macro|[email protected]', 'dddddddd-dddd-dddd-dddd-dddddddddddd', 'document', '2024-03-03 10:00:00'), -- Newest viewed
       ('macro|[email protected]', 'ffffffff-ffff-ffff-ffff-ffffffffffff', 'project', '2024-03-02 10:00:00'),   -- Middle viewed
       ('macro|[email protected]', 'cccccccc-1111-1111-1111-111111111111', 'chat', '2024-03-01 10:00:00'); -- Oldest viewed

SET session_replication_role = 'origin';