com.github.frtu.persistence.r2dbc.query.PostgresJsonbQueryBuilder.kt Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of lib-r2dbc Show documentation
There is a newer version: 2.0.7
package com.github.frtu.persistence.r2dbc.query

import org.slf4j.Logger
import org.slf4j.LoggerFactory
import org.springframework.data.domain.Pageable
import org.springframework.data.relational.core.query.Criteria
import org.springframework.data.relational.core.query.Query

/**
 * Implementation for {@link IPostgresJsonbQueryBuilder}
 *
 * @author Frédéric TU
 * @since 1.1.1
 */
class PostgresJsonbQueryBuilder(
    private val deniedKeys: Set = setOf(),
    private val allowedKeys: Set = setOf(),
    private val idColumnName: String = "id",
    private val jsonbColumnName: String = "data"
) : IPostgresJsonbQueryBuilder {
    private val logger: Logger = LoggerFactory.getLogger(PostgresJsonbQueryBuilder::class.java)

    override fun  id(id: T): Query = Query.query(Criteria.where(idColumnName).`is`(id))
        .apply { logger.trace("""{"query_type":"id", "${idColumnName}":"${id}"""") }

    override fun query(criteriaMap: Map, pageable: Pageable?): Query {
        val criteria = criteria(criteriaMap)
        return query(criteria, pageable)
    }

    override fun query(criteriaMap: Map, offset: Long?, limit: Int?): Query {
        val criteria = criteria(criteriaMap)
        return query(criteria, offset, limit)
    }

    override fun query(criteria: Criteria, pageable: Pageable?): Query {
        var query = Query.query(criteria)
        if (pageable != null && pageable.isPaged) {
            logger.trace("""{"offset":${pageable.offset}, "limit":${pageable.pageSize}, "sort":"${pageable.sort}"}""")
            query = query.with(pageable)
        }
        return query
    }

    override fun query(criteria: Criteria, offset: Long?, limit: Int?): Query {
        var query = Query.query(criteria)
        logger.trace("""{"offset":${offset}, "limit":${limit}}""")
        offset?.let { query = query.offset(offset) }
        limit?.let { query = query.limit(limit) }
        return query
    }

    override fun criteria(criteriaMap: Map): Criteria {
        val criteriaIterator = criteriaMap
            // skip empty key or value
            .filter { it.key != null && it.value != null }
            .filter { allowedKeys.isEmpty() || allowedKeys.contains(it.key) }
            .filter { deniedKeys.isEmpty() || !deniedKeys.contains(it.key) }
            .map { Criteria.where("${jsonbColumnName}->>'${it.key}'").`is`(it.value!!) }
            .asSequence().iterator()

        // Build fluent CriteriaDefinition
        var criteria: Criteria? = null
        if (criteriaIterator.hasNext()) {
            criteria = criteriaIterator.next()
            while (criteriaIterator.hasNext()) {
                criteria = criteria?.and(criteriaIterator.next())
            }
            logger.debug("""{"query_type":"criteria", criteria":"${criteria}"""")
        }
        return criteria ?: Criteria.empty()
    }
}