ai.platon.pulsar.ql.h2.udfs.ArrayFunctions.kt Maven / Gradle / Ivy

Go to download
package ai.platon.pulsar.ql.h2.udfs

import ai.platon.pulsar.ql.common.annotation.UDFGroup
import ai.platon.pulsar.ql.common.annotation.UDFunction
import org.h2.value.Value
import org.h2.value.ValueArray

@UDFGroup(namespace = "ARRAY")
object ArrayFunctions {

    @UDFunction
    @JvmStatic
    fun joinToString(values: ValueArray, separator: String): String {
        return values.list.joinToString(separator) { it.string }
    }

    @UDFunction
    @JvmStatic
    fun firstNotBlank(values: ValueArray): Value? {
        return values.list.firstOrNull { it.string.isNotBlank() }
    }

    @UDFunction
    @JvmStatic
    fun firstNotEmpty(values: ValueArray): Value? {
        return values.list.firstOrNull { it.string.isNotEmpty() }
    }
}