ktorm-support-mysql/org.ktorm.support.mysql/MatchAgainstExpression

MatchAgainstExpression

data class MatchAgainstExpression(val matchColumns: List<ColumnExpression<*>>, val searchString: String, val searchModifier: SearchModifier? = null, val sqlType: SqlType<Boolean> = BooleanSqlType, val isLeafNode: Boolean = false, val extraProperties: Map<String, Any> = emptyMap()) : ScalarExpression<Boolean> (source)

Match against expression, represents an match ... against ... operation in MySQL. See https://dev.mysql.com/doc/refman/5.5/en/insert-on-duplicate.html

Constructors

MatchAgainstExpression

constructor(matchColumns: List<ColumnExpression<*>>, searchString: String, searchModifier: SearchModifier? = null, sqlType: SqlType<Boolean> = BooleanSqlType, isLeafNode: Boolean = false, extraProperties: Map<String, Any> = emptyMap())

Properties

extraProperties

open override val extraProperties: Map<String, Any>

open override val isLeafNode: Boolean = false

val matchColumns: List<ColumnExpression<*>>

columns to be searched.

val searchModifier: SearchModifier? = null

optional modifier that indicates what type of search to perform.

val searchString: String

the search string.

open override val sqlType: SqlType<Boolean>

Functions

open override fun aliased(label: String?): ColumnDeclaringExpression<Boolean>

open override fun asExpression(): ScalarExpression<Boolean>

fun <T : Any> ColumnDeclaring<T>.ifNull(right: T?): FunctionExpression<T>

fun <T : Any> ColumnDeclaring<T>.ifNull(right: ColumnDeclaring<T>): FunctionExpression<T>

MySQL ifnull function, translated to ifnull(left, right).

fun ColumnDeclaring<String>.replace(oldValue: String, newValue: String): FunctionExpression<String>

MySQL replace function, translated to replace(str, oldValue, newValue).

fun ColumnDeclaring<String>.toLowerCase(): FunctionExpression<String>

MySQL lower function, translated to lower(str).

fun ColumnDeclaring<String>.toUpperCase(): FunctionExpression<String>

MySQL upper function, translated to upper(str).

open override fun wrapArgument(argument: Boolean?): ArgumentExpression<Boolean>