How do I handle null values in `flatZip` compositi...

# komapper

[dave08]

How do I handle null values in flatZip composition queries? Maybe there should be a flatZipNotNull?

[Toshihiro Nakamura]

When might you need flatZipNotNull? Could you show me an example of the code?

[dave08]

val q = QueryDsl.from(f)
          .where { ... }
          .firstOrNull()
          .flatZipNotNull {
              // If result of firstOrNull is null the result of q is null, otherwise run second request with a non-null value
           }

[dave08]

Otherwise, there's nothing to do with the it in flatZip other than using !! and catching the exception to return null as the result... 🙈

[Toshihiro Nakamura]

Thank you. That’s an interesting use case. I’ll think about how to address it.