Function seedDevOrganizations

server/src/dev-setup.ts:20–76

(orgDb: OrganizationDatabase)

}

async function seedDevOrganizations(orgDb: OrganizationDatabase): Promise<void> {
  const devOrgs = [
    {
      id: 'org_dev_company_001',
      name: 'Dev Company (Member)',
      is_personal: false,
      company_type: 'brand' as const,
      revenue_tier: '5m_50m' as const,
    },
    {
      id: 'org_dev_personal_001',
      name: 'Dev Personal Workspace',
      is_personal: true,
      company_type: null,
      revenue_tier: null,
    },
    {
      id: 'org_dev_builder_001',
      name: 'Acme Ad Tech',
      is_personal: false,
      company_type: 'adtech' as const,
      revenue_tier: '5m_50m' as const,
      membership_tier: 'company_standard' as const,
    },
  ];

  for (const devOrg of devOrgs) {
    try {
      const existing = await orgDb.getOrganization(devOrg.id);
      if (!existing) {
        await orgDb.createOrganization({
          workos_organization_id: devOrg.id,
          name: devOrg.name,
          is_personal: devOrg.is_personal,
          company_type: devOrg.company_type || undefined,
          revenue_tier: devOrg.revenue_tier || undefined,
          membership_tier: (devOrg as any).membership_tier || undefined,
        });
        logger.info({ orgId: devOrg.id, name: devOrg.name }, 'Created dev organization');
      } else if ((devOrg as any).membership_tier) {
        // Ensure tier and subscription status are set for paid dev orgs
        const pool = getPool();
        await pool.query(
          `UPDATE organizations SET membership_tier = $1, subscription_status = 'active'
           WHERE workos_organization_id = $2 AND (membership_tier IS DISTINCT FROM $1 OR subscription_status IS DISTINCT FROM 'active')`,
          [(devOrg as any).membership_tier, devOrg.id]
        );
      }
    } catch (error) {
      if (error instanceof Error && error.message.includes('duplicate key')) {
        logger.debug({ orgId: devOrg.id }, 'Dev organization already exists');
      } else {
        throw error;
      }
    }
  }
}