Method hasEmailBeenSent

server/src/db/email-db.ts:121–135

* Check if we've already sent a specific email type to a user

(data: {
    email_type: string;
    workos_user_id: string;
  })

   * Check if we've already sent a specific email type to a user
   */
  async hasEmailBeenSent(data: {
    email_type: string;
    workos_user_id: string;
  }): Promise<boolean> {
    const result = await query<{ exists: boolean }>(
      `SELECT EXISTS(
        SELECT 1 FROM email_events
        WHERE email_type = $1
          AND workos_user_id = $2
          AND sent_at IS NOT NULL
      ) as exists`,
      [data.email_type, data.workos_user_id]
    );
    return result.rows[0]?.exists || false;
  }

  /**
   * Record a click event