Method getHostedBrandByDomain

server/src/db/brand-db.ts:227–233

* Get hosted brand by domain

(domain: string)

   * Get hosted brand by domain
   */
  async getHostedBrandByDomain(domain: string): Promise<HostedBrand | null> {
    const result = await query<HostedBrand>(
      `SELECT ${HOSTED_BRAND_COLUMNS} FROM brands WHERE domain = $1`,
      [domain.toLowerCase()]
    );
    return result.rows[0] ? this.deserializeHostedBrand(result.rows[0]) : null;
  }

  /**
   * List hosted brands by organization