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
INSERT INTO public."Organization" ("id", "name")
(SELECT 1, 'organization-one');
INSERT INTO public."macro_user" ("id", "username", "email", "stripe_customer_id")
VALUES ('a1111111-1111-1111-1111-111111111111', '[email protected]', '[email protected]', 'stripe_id'),
('a2222222-2222-2222-2222-222222222222', '[email protected]', '[email protected]', 'stripe_id2'),
('a3333333-3333-3333-3333-333333333333', '[email protected]', '[email protected]', 'stripe_id3'),
('a4444444-4444-4444-4444-444444444444', '[email protected]', '[email protected]', 'stripe_id4'),
('a5555555-5555-5555-5555-555555555555', '[email protected]', '[email protected]', 'stripe_id5');
INSERT INTO public."User" ("id", "email", "stripeCustomerId", "organizationId", "macro_user_id")
(SELECT 'macro|[email protected]', '[email protected]', 'stripe_id', 1, 'a1111111-1111-1111-1111-111111111111');
INSERT INTO public."User" ("id", "email", "stripeCustomerId", "organizationId", "macro_user_id")
(SELECT 'macro|[email protected]', '[email protected]', 'stripe_id2', 1, 'a2222222-2222-2222-2222-222222222222');
INSERT INTO public."User" ("id", "email", "stripeCustomerId", "organizationId", "macro_user_id")
(SELECT 'macro|[email protected]', '[email protected]', 'stripe_id3', 1, 'a3333333-3333-3333-3333-333333333333');
INSERT INTO public."User" ("id", "email", "stripeCustomerId", "macro_user_id")
(SELECT 'macro|[email protected]', '[email protected]', 'stripe_id4', 'a4444444-4444-4444-4444-444444444444');
INSERT INTO public."User" ("id", "email", "stripeCustomerId", "macro_user_id")
(SELECT 'macro|[email protected]', '[email protected]', 'stripe_id5', 'a5555555-5555-5555-5555-555555555555');
INSERT INTO public."Document" ("id", "name", "fileType", "owner", "createdAt", "updatedAt")
(SELECT 'document-one',
'test_document_name',
'pdf',
'macro|[email protected]',
'2019-10-16 00:00:00',
'2019-10-16 00:00:00');
INSERT INTO public."DocumentInstance" ("revisionName", "documentId", "createdAt", "updatedAt", "sha")
(SELECT 'test_document_name', 'document-one', '2019-10-16 00:00:00', '2019-10-16 00:00:00', 'sha');
INSERT INTO public."SharePermission" ("id", "linkShare", "linkShareAccessLevel")
(SELECT 'sp-document1', 'PUBLIC', 'view');
INSERT INTO public."Document" ("id", "name", "fileType", "owner", "createdAt", "updatedAt")
(SELECT 'document-two',
'test_document_name',
'pdf',
'macro|[email protected]',
'2019-10-16 00:00:00',
'2019-10-16 00:00:00');
INSERT INTO public."DocumentInstance" ("revisionName", "documentId", "createdAt", "updatedAt", "sha")
(SELECT 'test_document_name', 'document-two', '2019-10-16 00:00:00', '2019-10-16 00:00:00', 'sha');
-- Create macro_user records for test users
INSERT INTO public."macro_user" ("id", "username", "email", "stripe_customer_id")
VALUES ('a6666666-6666-6666-6666-666666666666', 'test-user', '[email protected]', 'stripe_test-user'),
('a7777777-7777-7777-7777-777777777777', 'user0', '[email protected]', 'stripe_user0'),
('a8888888-8888-8888-8888-888888888888', 'uia_user1', '[email protected]', 'stripe_uia_user1'),
('a9999999-9999-9999-9999-999999999999', 'uia_user2', '[email protected]', 'stripe_uia_user2'),
('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'uia_user3', '[email protected]', 'stripe_uia_user3'),
('abbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb', 'uia_user4', '[email protected]', 'stripe_uia_user4'),
('accccccc-cccc-cccc-cccc-cccccccccccc', 'uia_user5', '[email protected]', 'stripe_uia_user5')
ON CONFLICT (id) DO NOTHING;
-- Create test users needed for all entity_access tests
INSERT INTO public."User" ("id", "email", "macro_user_id")
VALUES ('macro|[email protected]', '[email protected]', 'a6666666-6666-6666-6666-666666666666'),
('macro|[email protected]', '[email protected]', 'a7777777-7777-7777-7777-777777777777'),
('macro|[email protected]', '[email protected]', 'a8888888-8888-8888-8888-888888888888'),
('macro|[email protected]', '[email protected]', 'a9999999-9999-9999-9999-999999999999'),
('macro|[email protected]', '[email protected]', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa'),
('macro|[email protected]', '[email protected]', 'abbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb'),
('macro|[email protected]', '[email protected]', 'accccccc-cccc-cccc-cccc-cccccccccccc')
ON CONFLICT (id) DO NOTHING;
-- Create single entity_access record for test_delete_user_item_access
INSERT INTO public.entity_access (entity_id, entity_type, source_id, source_type, access_level, created_at, updated_at)
VALUES ('00000000-0000-0000-0000-000000000001', 'document', 'macro|[email protected]', 'user', 'owner', NOW(), NOW());
-- Create multiple entity_access records for test_delete_user_item_access_by_item
INSERT INTO public.entity_access (entity_id, entity_type, source_id, source_type, access_level, created_at, updated_at)
VALUES ('00000000-0000-0000-0000-000000000002', 'document', 'macro|[email protected]', 'user', 'view', NOW(), NOW()),
('00000000-0000-0000-0000-000000000002', 'document', 'macro|[email protected]', 'user', 'view', NOW(), NOW()),
('00000000-0000-0000-0000-000000000002', 'document', 'macro|[email protected]', 'user', 'view', NOW(), NOW());
-- Create multiple entity_access records for test_delete_user_item_access_bulk
INSERT INTO public.entity_access (entity_id, entity_type, source_id, source_type, access_level, created_at, updated_at)
VALUES ('00000000-0000-0000-0000-000000000003', 'document', 'macro|[email protected]', 'user', 'view', NOW(), NOW()),
('00000000-0000-0000-0000-000000000003', 'document', 'macro|[email protected]', 'user', 'edit', NOW(), NOW()),
('00000000-0000-0000-0000-000000000004', 'document', 'macro|[email protected]', 'user', 'view', NOW(), NOW()),
('00000000-0000-0000-0000-000000000004', 'document', 'macro|[email protected]', 'user', 'edit', NOW(), NOW()),
('00000000-0000-0000-0000-000000000005', 'document', 'macro|[email protected]', 'user', 'view', NOW(), NOW()),
('00000000-0000-0000-0000-000000000005', 'document', 'macro|[email protected]', 'user', 'edit', NOW(), NOW());