exposed-json/org.jetbrains.exposed.sql.json/Extract

Extract

class Extract<T>(val expression: Expression<*>, val path: String, val toScalar: Boolean, val jsonType: IColumnType<*>, columnType: IColumnType<T & Any>) : Function<T>

Represents an SQL function that returns extracted data from a JSON object at the specified path, either as a JSON representation or as a scalar value.

Constructors

Extract

constructor(expression: Expression<*>, vararg path: String, toScalar: Boolean, jsonType: IColumnType<*>, columnType: IColumnType<T & Any>)

Properties

columnType

open override val columnType: IColumnType<T & Any>

expression

val expression: Expression<*>

The expression from which to extract JSON subcomponents matched by path.

jsonType

val jsonType: IColumnType<*>

The column type of expression to check, if casting to JSONB is required.

path

val path: Array<out String>

Array of Strings representing JSON path/keys that match fields to be extracted.

toScalar

val toScalar: Boolean

Whether the extracted result should be a scalar or text value; if false, result will be a JSON object.

Functions

contains

fun <T> ExpressionWithColumnType<*>.contains(candidate: T, path: String? = null): Contains

Checks whether a candidate value is contained within this JSON expression.

fun ExpressionWithColumnType<*>.contains(candidate: Expression<*>, path: String? = null): Contains

Checks whether a candidate expression is contained within this JSON expression.

equals

open operator override fun equals(other: Any?): Boolean

exists

fun ExpressionWithColumnType<*>.exists(vararg path: String, optional: String? = null): Exists

Checks whether data exists within this JSON expression at the specified path.

extract

inline fun <T : Any> ExpressionWithColumnType<*>.extract(vararg path: String, toScalar: Boolean = true): Extract<T>

Returns the extracted data from a JSON object at the specified path, either as a JSON representation or as a scalar value.

hashCode

open override fun hashCode(): Int

toQueryBuilder

open override fun toQueryBuilder(queryBuilder: QueryBuilder)

toString

open override fun toString(): String