Method updateHostedBrand

server/src/db/brand-db.ts:260–296

* Update a hosted brand

(id: string, input: UpdateHostedBrandInput)

   * Update a hosted brand
   */
  async updateHostedBrand(id: string, input: UpdateHostedBrandInput): Promise<HostedBrand | null> {
    const updates: string[] = ['updated_at = NOW()'];
    const values: unknown[] = [];
    let paramIndex = 1;

    // Alias brands columns to match HostedBrand interface
    if (input.brand_json !== undefined) {
      updates.push(`brand_manifest = $${paramIndex++}`);
      values.push(JSON.stringify(input.brand_json));
    }
    if (input.domain_verified !== undefined) {
      updates.push(`domain_verified = $${paramIndex++}`);
      values.push(input.domain_verified);
    }
    if (input.verification_token !== undefined) {
      updates.push(`verification_token = $${paramIndex++}`);
      values.push(input.verification_token);
    }
    if (input.is_public !== undefined) {
      updates.push(`is_public = $${paramIndex++}`);
      values.push(input.is_public);
    }
    if (input.workos_organization_id !== undefined) {
      updates.push(`workos_organization_id = $${paramIndex++}`);
      values.push(input.workos_organization_id);
    }

    values.push(id);
    const result = await query<HostedBrand>(
      `UPDATE brands SET ${updates.join(', ')} WHERE id = $${paramIndex}
       RETURNING id, workos_organization_id, created_by_user_id, created_by_email,
         domain AS brand_domain, brand_manifest AS brand_json,
         domain_verified, verification_token, is_public, created_at, updated_at`,
      values
    );
    return result.rows[0] ? this.deserializeHostedBrand(result.rows[0]) : null;
  }

  /**
   * Relinquish a hosted brand back to the discovered/community pool.