Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
-- Fixture for testing get_messages_with_context
-- Creates a channel with 10 messages in chronological order
INSERT INTO comms_channels (id, name, channel_type, owner_id, created_at)
VALUES ('aaaaaaaa-0000-0000-0000-000000000001', 'test channel', 'public', 'macro|[email protected]', '2024-01-01T10:00:00Z');
INSERT INTO comms_messages (id, parent_entity_type, parent_entity_id, sender_id, content, created_at)
VALUES
-- 10 messages in chronological order in the same channel
('bbbbbbbb-0000-0000-0000-000000000001', 'channel', 'aaaaaaaa-0000-0000-0000-000000000001', 'macro|[email protected]', 'Message 1',
'2024-01-01T10:00:00Z'),
('bbbbbbbb-0000-0000-0000-000000000002', 'channel', 'aaaaaaaa-0000-0000-0000-000000000001', 'macro|[email protected]', 'Message 2',
'2024-01-01T10:01:00Z'),
('bbbbbbbb-0000-0000-0000-000000000003', 'channel', 'aaaaaaaa-0000-0000-0000-000000000001', 'macro|[email protected]', 'Message 3',
'2024-01-01T10:02:00Z'),
('bbbbbbbb-0000-0000-0000-000000000004', 'channel', 'aaaaaaaa-0000-0000-0000-000000000001', 'macro|[email protected]', 'Message 4',
'2024-01-01T10:03:00Z'),
('bbbbbbbb-0000-0000-0000-000000000005', 'channel', 'aaaaaaaa-0000-0000-0000-000000000001', 'macro|[email protected]', 'Message 5',
'2024-01-01T10:04:00Z'),
('bbbbbbbb-0000-0000-0000-000000000006', 'channel', 'aaaaaaaa-0000-0000-0000-000000000001', 'macro|[email protected]', 'Message 6',
'2024-01-01T10:05:00Z'),
('bbbbbbbb-0000-0000-0000-000000000007', 'channel', 'aaaaaaaa-0000-0000-0000-000000000001', 'macro|[email protected]', 'Message 7',
'2024-01-01T10:06:00Z'),
('bbbbbbbb-0000-0000-0000-000000000008', 'channel', 'aaaaaaaa-0000-0000-0000-000000000001', 'macro|[email protected]', 'Message 8',
'2024-01-01T10:07:00Z'),
('bbbbbbbb-0000-0000-0000-000000000009', 'channel', 'aaaaaaaa-0000-0000-0000-000000000001', 'macro|[email protected]', 'Message 9',
'2024-01-01T10:08:00Z'),
('bbbbbbbb-0000-0000-0000-000000000010', 'channel', 'aaaaaaaa-0000-0000-0000-000000000001', 'macro|[email protected]', 'Message 10',
'2024-01-01T10:09:00Z');