send-new-release-marketing-email.md

release.swift

    Task {

      let postmark = get(dependency: \.postmark)

      let db = get(dependency: \.db)
      let admins = try await Admin.query()
        .where(.not(.equals(
          .subscriptionStatus,
          .enum(Admin.SubscriptionStatus.unpaid)
        )))
        .where(.not(.equals(
          .subscriptionStatus,
          .enum(Admin.SubscriptionStatus.pendingEmailVerification)
        )))
        .where(.not(.equals(
          .subscriptionStatus,
          .enum(Admin.SubscriptionStatus.pendingAccountDeletion)
        )))
        .orderBy(.email, .asc)
        .all(in: db)

      do {
        for chunk in admins.chunks(ofCount: 40) {
          // print(chunk.count, chunk.first?.email.rawValue)
          let emails = chunk.map(\.email.rawValue)
          try await postmark.send(template: .v2_7_0_Announce(
            to: emails,
            model: .init(),
            dryRun: false
          ))
        }
      } catch {
        print(String(reflecting: error))
      }
    }