I think this is a dumb question but I can't find t...

# exposed

[MrPowerGamerBR]

I think this is a dumb question but I can't find the solution for this anywhere:

I want to do this in Exposed: update profiles set money = money * 0.95;, money is a bigint field on the table.

I tried doing this

Profiles.update {
                        with(SqlExpressionBuilder) {
                            it.update(Profiles.money, Profiles.money * 0.95)
                        }
                    }

However this doesn't work, because Profiles.money is a Long, so PostgreSQL doesn't allow long + double multiplication :(

[Bogdan]

bigint is an integer data type

[Bogdan]

the code generates a request, but nothing changes. If you copy this request and execute it in console h2, then everything will work fine

object Profiles : Table() {
    val money = long("money")
}

// copy TimesOp
class UnsafeTimesOp<T, S>(
    expr1: Expression<T>,
    expr2: Expression<S>,
    columnType: IColumnType
) : CustomOperator<T>("*", columnType, expr1, expr2)

fun <T, S> unsafeTimes(expr1: ExpressionWithColumnType<T>, expr2: Expression<S>): UnsafeTimesOp<T, S> =
    UnsafeTimesOp(expr1, expr2, expr1.columnType)

operator fun <T : Number, S : Number> ExpressionWithColumnType<T>.times(value: S): Expression<T> =
    unsafeTimes(this, wrap(value))


private fun test() {
    transaction {
        addLogger(StdOutSqlLogger)

        Profiles.update {
            it[money] = money * 0.95
            // or
            // it.update(money, money * 0.95)

        }

    }
}

[Bogdan]

work:

transaction {
        exec("UPDATE PROFILES SET MONEY=(PROFILES.MONEY * 0.95)")
    }

[Bogdan]

https://github.com/JetBrains/Exposed/issues