Convert code to use dangerouslyOnDuplicateKeyUpdate

[Distractic]

Hello !
After the new release, I want to use dangerouslyOnDuplicateKeyUpdate, however, my code doesn't work like previously.

This is my old code :

private suspend fun insertOrUpdateAll(
        uuid: UUID,
        friendIds: List<UUID>,
        pending: Boolean
    ): Boolean {
        val meta = _Friend.friend
        val metaUUID = meta.uuid
        val uuid1Name = metaUUID.uuid1.name
        val uuid2Name = metaUUID.uuid2.name
        val pendingName = meta.pending.name

        val query = QueryDsl.executeTemplate(
            """
                    INSERT INTO ${meta.tableName()} ($uuid1Name, $uuid2Name, $pendingName) 
                    VALUES ${friendIds.indices.joinToString(", ") { "(/*uuid*/'', /*uuid$it*/'', /*pending*/false)" }}
                    ON CONFLICT (GREATEST($uuid1Name, $uuid2Name), LEAST($uuid1Name, $uuid2Name)) 
                    DO UPDATE SET $pendingName = /*pending*/false WHERE ("${meta.tableName()}".$pendingName = true AND /*pending*/false = false)
                    """.trimIndent()
        )
            .bind("uuid", uuid)
            .let {
                friendIds.foldIndexed(it) { index, acc, friendId ->
                    acc.bind("uuid$index", friendId)
                }
            }
            .bind("pending", pending)

        return database.runQuery(query) > 0
    }

This is my converted code :

private suspend fun insertOrUpdateAll(
        uuid: UUID,
        friendIds: List<UUID>,
        pending: Boolean
    ): Boolean {
        val meta = _Friend.friend
        val metaUUID = meta.uuid
        val uuid1Name = metaUUID.uuid1.name
        val uuid2Name = metaUUID.uuid2.name
        val metaPending = meta.pending

        val friends = friendIds.map { friend ->
            Friend(FriendId(uuid, friend), pending)
        }

        val query = QueryDsl.insert(meta)
            .dangerouslyOnDuplicateKeyUpdate("(GREATEST($uuid1Name, $uuid2Name), LEAST($uuid1Name, $uuid2Name))")
            .set {
                metaPending eq pending
            }
            .where {
                if(!pending) {
                    metaPending eq true
                }
            }
            .multiple(friends)

        return (database.runQuery(query) > 0)
    }

Some tests don't work as expected (some relation is always inserted/updated, etc.)
The problem is linked to the where declaration, but I don't know how to set it like the String version

[nakamura-to]

Hello!

The problem is linked to the where declaration, but I don't know how to set it like the String version

You can write as follows:

.where {
    metaPending eq true
    literal(false) eq pending
}

See also https://www.komapper.org/docs/reference/query/querydsl/expression/#literal.

[Distractic]

Thanks ! I will try it after