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.

6.3 KB
Raw Blame
-- Project and CRM discussions for the attention candidate query.
-- Loads after `work_feed`, which creates user-1 and user-2.
-- (T = minute past 10:00 on 2024-06-01, UTC)
--
--   T40  discussion on company-1 (user-1's CRM team)        -> listed
--   T41  discussion on company-2 (same team, hidden)         -> not listed
--   T42  discussion on company-3 (another team)              -> not listed
--   T43  discussion on contact-1 (company-1)                 -> listed
--   T44  discussion on contact-2 (company-1, hidden contact) -> not listed
--   T45  discussion on project-1 (shared with user-1)        -> listed
--   T46  discussion on contact-3 (no company, same team)     -> listed
--   T47  discussion on contact-4 (company-2, hidden company) -> not listed

SET session_replication_role = 'replica';

INSERT INTO public.team ("id", "name", "owner_id")
VALUES ('77777777-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'Team 1', 'macro|[email protected]'),
       ('77777777-bbbb-bbbb-bbbb-bbbbbbbbbbbb', 'Team 2', 'macro|[email protected]');

INSERT INTO public.team_user ("user_id", "team_id", "team_role")
VALUES ('macro|[email protected]', '77777777-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'member'),
       ('macro|[email protected]', '77777777-bbbb-bbbb-bbbb-bbbbbbbbbbbb', 'owner');

INSERT INTO public.team_crm_settings ("team_id", "crm_enabled")
VALUES ('77777777-aaaa-aaaa-aaaa-aaaaaaaaaaaa', TRUE),
       ('77777777-bbbb-bbbb-bbbb-bbbbbbbbbbbb', TRUE);

INSERT INTO public.crm_companies ("id", "team_id", "hidden", "first_interaction", "last_interaction", "custom_name")
VALUES ('88888888-0000-0000-0000-000000000001', '77777777-aaaa-aaaa-aaaa-aaaaaaaaaaaa', FALSE, '2024-06-01 09:00:00+00', '2024-06-01 09:00:00+00', 'Company 1'),
       ('88888888-0000-0000-0000-000000000002', '77777777-aaaa-aaaa-aaaa-aaaaaaaaaaaa', TRUE, '2024-06-01 09:00:00+00', '2024-06-01 09:00:00+00', 'Company 2'),
       ('88888888-0000-0000-0000-000000000003', '77777777-bbbb-bbbb-bbbb-bbbbbbbbbbbb', FALSE, '2024-06-01 09:00:00+00', '2024-06-01 09:00:00+00', 'Company 3');

INSERT INTO public.crm_contacts ("id", "team_id", "company_id", "email", "hidden", "first_interaction", "last_interaction")
VALUES ('88888888-1111-0000-0000-000000000001', '77777777-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '88888888-0000-0000-0000-000000000001', '[email protected]', FALSE, '2024-06-01 09:00:00+00', '2024-06-01 09:00:00+00'),
       ('88888888-1111-0000-0000-000000000002', '77777777-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '88888888-0000-0000-0000-000000000001', '[email protected]', TRUE, '2024-06-01 09:00:00+00', '2024-06-01 09:00:00+00'),
       ('88888888-1111-0000-0000-000000000003', '77777777-aaaa-aaaa-aaaa-aaaaaaaaaaaa', NULL, '[email protected]', FALSE, '2024-06-01 09:00:00+00', '2024-06-01 09:00:00+00'),
       ('88888888-1111-0000-0000-000000000004', '77777777-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '88888888-0000-0000-0000-000000000002', '[email protected]', FALSE, '2024-06-01 09:00:00+00', '2024-06-01 09:00:00+00');

INSERT INTO public.initiative ("id", "name", "owner_user_id", "share_permission_id")
VALUES ('66666666-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'Project 1', 'macro|[email protected]', 'sp-project-1');

INSERT INTO public.entity_access ("entity_id", "entity_type", "source_id", "source_type", "access_level", "granted_from_project_id")
VALUES ('66666666-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'initiative', 'macro|[email protected]', 'user', 'edit', NULL);

INSERT INTO public.notification ("id", "notification_event_type", "event_item_id", "event_item_type", "service_sender", "created_at", "metadata", "sender_id", "secondary_event_item_id", "secondary_event_item_type")
VALUES
('0190b000-0000-7000-8000-000000000040', 'crm_discussion', '88888888-0000-0000-0000-000000000001', 'crm_company', 'test', '2024-06-01 10:40:00', '{}', 'macro|[email protected]', NULL, NULL),
('0190b000-0000-7000-8000-000000000041', 'crm_discussion', '88888888-0000-0000-0000-000000000002', 'crm_company', 'test', '2024-06-01 10:41:00', '{}', 'macro|[email protected]', NULL, NULL),
('0190b000-0000-7000-8000-000000000042', 'crm_discussion', '88888888-0000-0000-0000-000000000003', 'crm_company', 'test', '2024-06-01 10:42:00', '{}', 'macro|[email protected]', NULL, NULL),
('0190b000-0000-7000-8000-000000000043', 'crm_discussion', '88888888-1111-0000-0000-000000000001', 'crm_contact', 'test', '2024-06-01 10:43:00', '{}', 'macro|[email protected]', NULL, NULL),
('0190b000-0000-7000-8000-000000000044', 'crm_discussion', '88888888-1111-0000-0000-000000000002', 'crm_contact', 'test', '2024-06-01 10:44:00', '{}', 'macro|[email protected]', NULL, NULL),
('0190b000-0000-7000-8000-000000000045', 'initiative_discussion', '66666666-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'initiative', 'test', '2024-06-01 10:45:00', '{}', 'macro|[email protected]', NULL, NULL),
('0190b000-0000-7000-8000-000000000046', 'crm_discussion', '88888888-1111-0000-0000-000000000003', 'crm_contact', 'test', '2024-06-01 10:46:00', '{}', 'macro|[email protected]', NULL, NULL),
('0190b000-0000-7000-8000-000000000047', 'crm_discussion', '88888888-1111-0000-0000-000000000004', 'crm_contact', 'test', '2024-06-01 10:47:00', '{}', 'macro|[email protected]', NULL, NULL);

INSERT INTO public.user_notification ("user_id", "notification_id", "created_at", "sent", "seen_at", "deleted_at", "state", "is_important_v0")
VALUES
('macro|[email protected]', '0190b000-0000-7000-8000-000000000040', '2024-06-01 10:40:00', TRUE, NULL, NULL, 'unseen', FALSE),
('macro|[email protected]', '0190b000-0000-7000-8000-000000000041', '2024-06-01 10:41:00', TRUE, NULL, NULL, 'unseen', FALSE),
('macro|[email protected]', '0190b000-0000-7000-8000-000000000042', '2024-06-01 10:42:00', TRUE, NULL, NULL, 'unseen', FALSE),
('macro|[email protected]', '0190b000-0000-7000-8000-000000000043', '2024-06-01 10:43:00', TRUE, NULL, NULL, 'unseen', FALSE),
('macro|[email protected]', '0190b000-0000-7000-8000-000000000044', '2024-06-01 10:44:00', TRUE, NULL, NULL, 'unseen', FALSE),
('macro|[email protected]', '0190b000-0000-7000-8000-000000000045', '2024-06-01 10:45:00', TRUE, NULL, NULL, 'unseen', FALSE),
('macro|[email protected]', '0190b000-0000-7000-8000-000000000046', '2024-06-01 10:46:00', TRUE, NULL, NULL, 'unseen', FALSE),
('macro|[email protected]', '0190b000-0000-7000-8000-000000000047', '2024-06-01 10:47:00', TRUE, NULL, NULL, 'unseen', FALSE);

SET session_replication_role = 'origin';