Function seedDevMemberships

server/src/dev-setup.ts:245–274

()

}

async function seedDevMemberships(): Promise<void> {
  const pool = getPool();
  const memberships = [
    // Admin user in their default org
    { userId: 'user_dev_admin_001', orgId: 'org_dev_company_001', membershipId: 'mem_dev_admin_001', email: 'admin@test.local', firstName: 'Admin', lastName: 'Tester', role: 'owner' },
    // Admin user in IPG hierarchy org
    { userId: 'user_dev_admin_001', orgId: 'org_dev_ipg_um', membershipId: 'mem_dev_admin_ipg', email: 'admin@test.local', firstName: 'Admin', lastName: 'Tester', role: 'owner' },
    // Member user
    { userId: 'user_dev_member_001', orgId: 'org_dev_company_001', membershipId: 'mem_dev_member_001', email: 'member@test.local', firstName: 'Member', lastName: 'User', role: 'member' },
    // Builder user (paid tier org)
    { userId: 'user_dev_builder_001', orgId: 'org_dev_builder_001', membershipId: 'mem_dev_builder_001', email: 'builder@test.local', firstName: 'Builder', lastName: 'Member', role: 'owner' },
    // Extra team members for the builder org (to show team dynamics)
    { userId: 'user_dev_learner_001', orgId: 'org_dev_builder_001', membershipId: 'mem_dev_learner1_builder', email: 'learner1@test.local', firstName: 'Learner', lastName: 'One', role: 'member' },
    { userId: 'user_dev_learner_002', orgId: 'org_dev_builder_001', membershipId: 'mem_dev_learner2_builder', email: 'learner2@test.local', firstName: 'Learner', lastName: 'Two', role: 'member' },
  ];

  for (const m of memberships) {
    try {
      await pool.query(
        `INSERT INTO organization_memberships (workos_user_id, workos_organization_id, workos_membership_id, email, first_name, last_name, role, seat_type)
         VALUES ($1, $2, $3, $4, $5, $6, $7, 'contributor')
         ON CONFLICT (workos_user_id, workos_organization_id) DO NOTHING`,
        [m.userId, m.orgId, m.membershipId, m.email, m.firstName, m.lastName, m.role]
      );
    } catch (error) {
      logger.debug({ userId: m.userId, orgId: m.orgId }, 'Dev membership seed skipped');
    }
  }
  logger.info('Seeded dev organization memberships');
}