I'm using the Komapper ORM and I can't seem to find a way to configure unique columns on a field via annotations. Can anyone with experience please help me with this? Thanks.

HI, is there any example of how to use HikariPool with komapper or any other ConnectionPool?

Hello everyone. Komapper v1.2.0 is out! https://github.com/komapper/komapper/releases/tag/v1.2.0 Try the following new features: - user-defined data types - data type conversion See documentation: https://www.komapper.org/docs/reference/data-type/

Hello everyone. Komapper v1.3.0 has been released. https://github.com/komapper/komapper/releases/tag/v1.3.0 Embedded Value is now supported. For example, you can write your entity class as follows:

data class Money(val amount: BigDecimal, val currency: String)

@KomapperEntity
data Employee(@KomapperId val id: Int, @KomapperEmbedded val: salary: Money)

Please try it out!

QueryDsl.from(decks).where(declaration).orderBy(decks.id.asc()).limit(pageSize)
            .leftJoin(deckWords) { decks.id eq deckWords.deck }
            .leftJoin(deckTags) { decks.id eq deckTags.deck }
            .include(decks, deckWords, deckTags)

the issue here is that it also limits joined tables. is it possible to add subqueries with the dsl to circumvent this?

Hello everyone. Komapper v1.4.0 is out! https://github.com/komapper/komapper/releases/tag/v1.4.0

Hi, everyone. I have added a compatibility matrix to the README. https://github.com/komapper/komapper#compatibility-matrix

How do I drop all connections from my R2dbc client?

io.r2dbc.postgresql.ExceptionFactory$PostgresqlNonTransientResourceException: [53300] sorry, too many clients already]

Hi, why mysql-r2dbc isn’t on the list with supported dialects? (here https://www.komapper.org/docs/reference/dialect/). Is this module production ready?

Hi! Is there support for having different Meta objects for multiple database connections? It doesn't really make sense to put tables that are in db 1 into a db 2 Meta object and vise-versa...

If we have a column that's supposed to be a

@KomapperUpdatedAt

but it's recorded as an Int (unix time stamp), can komapper handle that? Maybe kotlinx.datetime's Instant?

A bit unexpected... if a

@KomapperAutoIncrement

is set to a value,

insert

ignores it and generates a value --- which on one hand avoids using a nullable id field... but might be confusing to some.

Is there any way to set a default value at the db level for a field?

So far, komapper seems very nice! (I started using it a new microservice...) I'm still wondering about a few seeming inconsistencies... like the

single()

being called on the Query, whereas

toList()

is called on the flowQuery... also the presence of the lamba form of runQuery and flowQuery is a bit puzzling... it even only has an empty receiver object...

In `update()`s

set { }

shouldn't it be

o.fieldName setTo "one"

instead of

eq

? Since

eq

is already used for

when { }

... in Kotlin, there's also a difference between

=

and

==

...

Or

set

Also, is there any form of update that returns the record updated (and what if it wasn't updated for some reason)?

I know there's

andThen()

, but would that translate to a

RETURN

in postgres, or make a seperate request?

Also, does

andThen

only run the next query if the first one succeeds? Would there be a place for an

onError(query)

extension to Query?

Hi, everyone. Komapper v1.5.0 is out! Please give it a try. https://github.com/komapper/komapper/releases/tag/v1.5.0

@Toshihiro Nakamura You should maybe put these version updates in #feed too here and there... that way it'll publicise this great library.

This kdoc is wrong:

/**
 * Builds a query that returns the single element.
 * When the query is executed, it throws [NoSuchElementException] for empty query result and [IllegalStateException]
 * for query result that contains more than one element.
 *
 * @param T the element type of [List]
 * @return the query
 */
fun <T> ListQuery<T>.single(): Query<T> = collect { it.single() }

It's an

java.lang.IllegalArgumentException: Flow has more than one element

not

IllegalStateException

Oh... the coroutines docs are also wrong:

/**
 * The terminal operator that awaits for one and only one value to be emitted.
 * Throws [NoSuchElementException] for empty flow and [IllegalStateException] for flow
 * that contains more than one element.
 */
public suspend fun <T> Flow<T>.single(): T {
    var result: Any? = NULL
    collect { value ->
        require(result === NULL) { "Flow has more than one element" }
        result = value
    }

Which is what is being used by that function...

require

throws an

IllegalArgumentException

Do I really need to use

KomapperColumnOverride

for embedded fields? Or can I just annotate the embedded class with a regular

KomapperColumn

?

Is there a way to use Json fields in komapper (right now I need them in Mysql...)?

I really only need to save to it for now.

Oh boy! I just noticed there's not one mention of how to create indexes/unique indexes and foreign keys with komapper's schema creator...! Is this possible?

Only for primary indexes there's

@KomapperId

and composite primary indexes

@KomapperEmbeddedId

...