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.

9.0 KB
Raw Blame
INSERT INTO comms_channels (id, name, channel_type, org_id, owner_id)
VALUES ('11111111-1111-1111-1111-111111111111', 'private 1', 'private', NULL, 'user1'),
       ('22222222-2222-2222-2222-222222222222', NULL, 'direct_message', NULL, 'user3'),
       ('33333333-3333-3333-3333-333333333333', 'public channel', 'public', NULL, 'user5'),
       ('44444444-4444-4444-4444-444444444444', 'org channel', 'private', NULL, 'user1'),
       ('55555555-5555-5555-5555-555555555555', 'private 2', 'private', NULL, 'user2'),
       ('66666666-6666-6666-6666-666666666666', NULL, 'direct_message', NULL, 'user1');

INSERT INTO comms_channel_participants (channel_id, role, user_id)
VALUES ('11111111-1111-1111-1111-111111111111', 'owner', 'user1'),
       ('22222222-2222-2222-2222-222222222222', 'member', 'user4'),
       ('33333333-3333-3333-3333-333333333333', 'owner', 'user5'),
       ('44444444-4444-4444-4444-444444444444', 'owner', 'user1'),
       ('55555555-5555-5555-5555-555555555555', 'owner', 'user2'),
       ('66666666-6666-6666-6666-666666666666', 'member', 'user5');

INSERT INTO comms_messages (id, parent_entity_type, parent_entity_id, sender_id, content, created_at, thread_id)
VALUES ('0dd7bef6-a56d-4605-a22e-62245d14f6b5', 'channel', '11111111-1111-1111-1111-111111111111', 'user1', 'message 1 content',
        '2024-01-01T12:00:00Z', NULL),
       ('3f91f184-7803-44e2-9a43-7c027b23ff03', 'channel', '11111111-1111-1111-1111-111111111111', 'user2', 'message 2 content',
        '2024-01-02T12:00:00Z', NULL),
       ('04cec93f-0d53-4f10-80e7-8d56a8d8d706', 'channel', '22222222-2222-2222-2222-222222222222', 'user3', 'dm msg content',
        '2024-01-03T12:00:00Z', NULL),
       ('0a0a4e2a-af9c-4453-840c-3e9a726af571', 'channel', '33333333-3333-3333-3333-333333333333', 'user1',
        'Check out this documentation!', '2024-01-04T10:00:00Z', NULL),
       ('2196b3c1-d27b-48c2-8813-89a145869996', 'channel', '33333333-3333-3333-3333-333333333333', 'user2',
        'I found another version of that doc', '2024-01-04T11:00:00Z', NULL),
       ('f1ee8c4f-bb45-4214-8907-720489b2cb36', 'channel', '44444444-4444-4444-4444-444444444444', 'user5',
        'Here are multiple docs to review', '2024-01-05T09:00:00Z', NULL),
       ('21460017-031f-4f0c-8450-193eedfb1a49', 'channel', '55555555-5555-5555-5555-555555555555', 'user2',
        'Internal documentation draft', '2024-01-06T14:00:00Z', NULL),
       ('d4a9a649-b7f4-438d-9dd2-0868cef5ba1c', 'channel', '66666666-6666-6666-6666-666666666666', 'user5',
        'Your private document for review', '2024-01-07T15:30:00Z', NULL),
       ('85905168-b64d-492d-bad8-91761c0fd860', 'channel', '33333333-3333-3333-3333-333333333333', 'user3',
        'Starting a thread about this doc', '2024-01-08T08:00:00Z', NULL),
       ('3031a8f8-5855-4540-be67-f44b2c2dbaab', 'channel', '33333333-3333-3333-3333-333333333333', 'user4',
        'Here are my thoughts on the doc', '2024-01-08T08:30:00Z', '85905168-b64d-492d-bad8-91761c0fd860'),
       ('097c9768-e40b-4eaa-8405-dbf93e20a9e2', 'channel', '33333333-3333-3333-3333-333333333333', 'user5',
        'I revised the doc with your feedback', '2024-01-08T10:00:00Z', '85905168-b64d-492d-bad8-91761c0fd860'),
       -- extra messages referenced only by attachments
       ('482a19b8-0cbd-490e-812d-252b6f48a611', 'channel', '11111111-1111-1111-1111-111111111111', 'user1', 'Doc11 discussion',
        '2024-01-09T09:00:00Z', NULL),
       ('9ea88d0a-d88c-4d9a-8690-2b589ce9d185', 'channel', '33333333-3333-3333-3333-333333333333', 'user5', 'Doc10 follow-up',
        '2024-01-10T10:00:00Z', NULL),
       ('8efccabd-2400-42d5-82a9-5c426db165f9', 'channel', '33333333-3333-3333-3333-333333333333', 'user3',
        'Deleted message placeholder', '2024-06-12T12:00:00Z', NULL),
       ('5c3fb396-24c6-42d4-b302-20f9b3be4ffc', 'channel', '33333333-3333-3333-3333-333333333333', 'user4',
        'Thread-specific message', '2024-06-12T12:02:00Z', NULL),
       ('7c2dabd6-175a-4b16-badf-cb39787cc730', 'channel', '33333333-3333-3333-3333-333333333333', 'user5', 'User-left follow-up',
        '2024-06-12T12:03:00Z', NULL);

INSERT INTO comms_attachments (id, message_id, entity_type, entity_id, created_at)
VALUES ('905105b7-c7f4-4b03-aff6-388a07886f59', '0dd7bef6-a56d-4605-a22e-62245d14f6b5',
        'doc', 'doc1', '2024-01-01T12:01:00Z'),
       ('f70b8691-0daf-4a88-a962-95d6ef386079', '04cec93f-0d53-4f10-80e7-8d56a8d8d706',
        'doc', 'doc2', '2024-01-03T12:01:00Z'),
       ('982f976c-f2de-4a4a-a2d5-e208616ec4c1', '0a0a4e2a-af9c-4453-840c-3e9a726af571',
        'doc', 'doc3', '2024-01-04T10:01:00Z'),
       ('60226329-222b-4e65-8de2-c31d0e6da082', '2196b3c1-d27b-48c2-8813-89a145869996',
        'doc', 'doc3-v2', '2024-01-04T11:01:00Z'),
       ('5f857b01-8b06-4129-9062-4d6d1e35e96b', 'f1ee8c4f-bb45-4214-8907-720489b2cb36',
        'doc', 'doc4', '2024-01-05T09:01:00Z'),
       ('d7b28a9e-2054-429f-9953-963c1be05d0c', '21460017-031f-4f0c-8450-193eedfb1a49',
        'doc', 'doc7', '2024-01-06T14:01:00Z'),
       ('3f7f555d-7319-4069-95e9-bdf0ba2fa0ab', 'd4a9a649-b7f4-438d-9dd2-0868cef5ba1c',
        'doc', 'doc8', '2024-01-07T15:31:00Z'),
       ('1a4bfe89-735d-49b3-a8ef-3b9cb0d22068', '85905168-b64d-492d-bad8-91761c0fd860',
        'doc', 'doc9', '2024-01-08T08:01:00Z'),
       ('dd07ae5b-c3dc-43e9-bc7d-f23c94b11843', '3031a8f8-5855-4540-be67-f44b2c2dbaab',
        'doc', 'doc9', '2024-01-08T08:31:00Z'),
       ('e6fdd2af-2beb-473e-a34c-7f0babcffbcd', '097c9768-e40b-4eaa-8405-dbf93e20a9e2',
        'doc', 'doc9-revised', '2024-01-08T10:01:00Z'),
       ('b3df8e02-e61f-425c-8e08-fb240b582991', '9ea88d0a-d88c-4d9a-8690-2b589ce9d185',
        'doc', 'doc10', '2024-01-10T10:01:00Z'),
       ('18edd997-340d-4a1e-ac46-1a11386b3ff5', '482a19b8-0cbd-490e-812d-252b6f48a611',
        'doc', 'doc11', '2024-01-09T09:01:00Z'),
       ('ce563828-2d9e-43c9-a370-700d4f8c4284', '0dd7bef6-a56d-4605-a22e-62245d14f6b5',
        'image', 'image1', '2024-01-01T12:02:00Z'),
       ('43101546-4a4e-470f-b23b-60f45b200f2a', '3f91f184-7803-44e2-9a43-7c027b23ff03',
        'pdf', 'pdf1', '2024-01-02T12:02:00Z'),
       ('cdb2c8eb-fd34-401d-ad0d-5bfc74a3385b', '04cec93f-0d53-4f10-80e7-8d56a8d8d706',
        'spreadsheet', 'spreadsheet1', '2024-01-03T12:02:00Z'),
       ('7f2153f1-5996-40a4-95dc-b0b5e94f3483', '0a0a4e2a-af9c-4453-840c-3e9a726af571',
        'video', 'video1', '2024-01-04T10:02:00Z'),
       ('a501a1eb-3a49-449b-aecd-4f5ca01fae94', '8efccabd-2400-42d5-82a9-5c426db165f9',
        'doc', 'deleted_doc', '2024-06-12T12:01:00Z'),
       ('3a70e86f-d148-4131-b279-e496e1e75d6c', '5c3fb396-24c6-42d4-b302-20f9b3be4ffc',
        'doc', 'thread_doc', '2024-06-12T12:02:00Z'),
       ('3d81a9c2-5393-43fb-b323-30db6e1b17ac', '7c2dabd6-175a-4b16-badf-cb39787cc730',
        'doc', 'leftuser_doc', '2024-06-12T12:03:00Z');

-- Insert entity_mentions for document mentions (separate from direct attachments)
INSERT INTO comms_entity_mentions (source_entity_type, source_entity_id, entity_type, entity_id)
VALUES
    -- doc_mention1 is mentioned in user1's private channel (user1 should see it)
    ('message', '3f91f184-7803-44e2-9a43-7c027b23ff03', 'doc', 'doc_mention1'),
    -- doc_mention2 is mentioned in public channel (user5 should see it)
    ('message', '2196b3c1-d27b-48c2-8813-89a145869996', 'doc', 'doc_mention2'),
    -- doc_mention3 is mentioned in org channel (user1 should see it as owner)
    ('message', 'f1ee8c4f-bb45-4214-8907-720489b2cb36', 'doc', 'doc_mention3'),
    -- doc_mention4 is mentioned in a thread message (user5 should see it)
    ('message', '3031a8f8-5855-4540-be67-f44b2c2dbaab', 'doc', 'doc_mention4'),
    -- doc_mention_no_access is mentioned in private channel user2 owns (user1 should NOT see it)
    ('message', '21460017-031f-4f0c-8450-193eedfb1a49', 'doc', 'doc_mention_no_access'),
    -- doc_mention_deleted is mentioned in a deleted message (should not appear)
    ('message', '8efccabd-2400-42d5-82a9-5c426db165f9', 'doc', 'doc_mention_deleted'),
    -- user mentions (should not appear when searching for documents)
    ('message', '0dd7bef6-a56d-4605-a22e-62245d14f6b5', 'user', 'user123'),

    -- Generic entity mentions (non-message sources) for testing
    -- doc_generic1 is mentioned by document doc_source1 (anyone should see this generic reference)
    ('doc', 'doc_source1', 'doc', 'doc_generic1'),
    -- doc_generic2 is mentioned by user user_source1 (anyone should see this generic reference)
    ('user', 'user_source1', 'doc', 'doc_generic2'),
    -- doc_generic3 is mentioned by chat chat_source1 (anyone should see this generic reference)
    ('chat', 'chat_source1', 'doc', 'doc_generic3'),
    -- doc_generic4 is mentioned by project project_source1 (anyone should see this generic reference)
    ('project', 'project_source1', 'doc', 'doc_generic4');

-- Mark one message as deleted for testing
UPDATE comms_messages
SET deleted_at = '2024-06-12T13:00:00Z'
WHERE id = '8efccabd-2400-42d5-82a9-5c426db165f9';

-- Add a user who left a channel for testing
INSERT INTO comms_channel_participants (channel_id, role, user_id, left_at)
VALUES ('33333333-3333-3333-3333-333333333333', 'member', 'user7', '2024-06-01T12:00:00Z');