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.4 KB
Raw Blame
-- Test data for get_user_names_with_email function

-- Create test macro users
INSERT INTO macro_user (id, username, email, stripe_customer_id)
VALUES
    ('11111111-1111-1111-1111-111111111111', 'test_user_1', '[email protected]', 'cus_test1'),
    ('22222222-2222-2222-2222-222222222222', 'test_user_2', '[email protected]', 'cus_test2'),
    ('33333333-3333-3333-3333-333333333333', 'test_user_3', '[email protected]', 'cus_test3'),
    ('44444444-4444-4444-4444-444444444444', 'test_user_4', '[email protected]', 'cus_test4'),
    ('55555555-5555-5555-5555-555555555555', 'test_user_5', '[email protected]', 'cus_test5'),
    ('66666666-6666-6666-6666-666666666666', 'contact', '[email protected]', 'cus_test6');

-- Create macro user info with names
INSERT INTO macro_user_info (macro_user_id, first_name, last_name)
VALUES
    ('11111111-1111-1111-1111-111111111111', 'JohnMacroContact', 'DoeMacroContact'),
    ('22222222-2222-2222-2222-222222222222', 'JaneMacroContact', 'SmithMacroContact'),
    ('33333333-3333-3333-3333-333333333333', 'N/A', 'N/A'), -- User with N/A name to test fallback
    ('44444444-4444-4444-4444-444444444444', 'OnlyFirstMacro', 'N/A'), -- Either populated => use Macro for BOTH; last should be NULL
    ('55555555-5555-5555-5555-555555555555', 'N/A', 'OnlyLastMacro');  -- Either populated => use Macro for BOTH; first should be NULL

-- Create User (profile) entries
INSERT INTO "User" (id, email, macro_user_id, "organizationId", "hasChromeExt", "tutorialComplete", "hasOnboardingDocuments")
VALUES
    ('macro|[email protected]', '[email protected]', '11111111-1111-1111-1111-111111111111', NULL, false, false, false),
    ('macro|[email protected]', '[email protected]', '22222222-2222-2222-2222-222222222222', NULL, false, false, false),
    ('macro|[email protected]', '[email protected]', '33333333-3333-3333-3333-333333333333', NULL, false, false, false),
    ('macro|[email protected]', '[email protected]', '44444444-4444-4444-4444-444444444444', NULL, false, false, false),
    ('macro|[email protected]', '[email protected]', '55555555-5555-5555-5555-555555555555', NULL, false, false, false),
    ('macro|[email protected]', '[email protected]', '66666666-6666-6666-6666-666666666666', NULL, false, false, false);

-- Create email link for macro user 1 (for email contacts lookup)
INSERT INTO email_links (id, macro_id, fusionauth_user_id, email_address, provider, is_sync_active)
VALUES
    ('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'macro|[email protected]', 'fa_user_1', '[email protected]', 'GMAIL', true);

-- Create email contacts (including one for macro|[email protected] with name, and one not in User table)
INSERT INTO email_contacts (id, link_id, email_address, name)
VALUES
    ('cccccccc-cccc-cccc-cccc-cccccccccccc', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '[email protected]', 'BobEmailContact JohnsonEmailContact'),
    ('dddddddd-dddd-dddd-dddd-dddddddddddd', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '[email protected]', 'AliceEmailContact WilliamsEmailContact'),
    ('eeeeeeee-eeee-eeee-eeee-eeeeeeeeeeee', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '[email protected]', 'FallbackFirst FallbackLast'),
    ('ffffffff-ffff-ffff-ffff-ffffffffffff', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '[email protected]', 'FallbackFirst2 FallbackLast2');