Function getEmailPreferences

apps/sim/lib/messaging/email/unsubscribe.ts:69–87

(email: string)

 * Get user's email preferences
 */
export async function getEmailPreferences(email: string): Promise<EmailPreferences | null> {
  try {
    const result = await db
      .select({
        emailPreferences: settings.emailPreferences,
      })
      .from(user)
      .leftJoin(settings, eq(settings.userId, user.id))
      .where(eq(user.email, email))
      .limit(1)

    if (!result[0]) return null

    return (result[0].emailPreferences as EmailPreferences) || {}
  } catch (error) {
    logger.error('Error getting email preferences:', error)
    return null
  }
}

/**
 * Update user's email preferences