kotlinlang #komapper

It seems like there's also no way to make an entity without an id... the problem comes up in many-to-many linker tables... they only have two foreign keys, but no primary id key.

dave08

12/26/2022, 10:31 AM

Is this planned? https://kotlinlang.slack.com/archives/C03JF82SDHA/p1671020954788009?thread_ts=1670948761.293189&cid=C03JF82SDHA ... the way it is now in our code isn't too nice, it would have been nice to support more than just the first param, but if that's what you think is the clearest way to express this, then it's certainly better than nothing!

dave08

12/26/2022, 2:10 PM

Can a field in an Entity be private?

Toshihiro Nakamura

12/29/2022, 3:03 AM

Hi, everyone. We have confirmed that Komapper works with Kotlin 1.8.0 and have updated the compatibility matrix. https://github.com/komapper/komapper#compatibility-matrix

dave08

01/02/2023, 12:28 PM

@Toshihiro Nakamura Are you putting out a new release with the recent changes soon?

dave08

01/03/2023, 5:01 PM

I think the

EntityStore

would have been better if they were generated and defined ONCE and not just when trying to retrieve data... one can easily make a mistake and use the wrong thing as the one and the many... when declaring the entities and relations, we tend to check the db structures and make sure the relations are right, from then on, the querying should only give the RIGHT options for the situation...

dave08

01/03/2023, 5:03 PM

Also, it would be nice to have support for mapping to DTOs using annotations (not the entities themselves)... maybe that's an opportunity to rethink EntityStore for this too...

Toshihiro Nakamura

01/07/2023, 3:48 AM

Hi, everyone. Komapper v1.6.0 is out! This version includes feedback from our users. Thank you for your cooperation. Please give it a try. https://github.com/komapper/komapper/releases/tag/v1.6.0

dave08

01/10/2023, 11:32 AM

Hi @Toshihiro Nakamura! Is there any way to SAVE to a json field in mysql using komapper? (I don't really need to read from it for now...)

dave08

01/10/2023, 11:37 AM

Will it work if I just use a

String

field?

dave08

01/10/2023, 11:46 AM

In the R2dbc driver it says that json is supported using

String

... does that mean that it's also supported by Komapper?

dave08

01/10/2023, 11:47 AM

https://github.com/mirromutth/r2dbc-mysql#data-type-mapping

dave08

01/11/2023, 1:12 PM

It seems like not all kinds of subqueries are supported... so my only choice is using templates in that case?

dave08

01/11/2023, 1:13 PM

It would have still been nice to have some kind of mixture... using some kind of template together with already generated Meta objects for mapping results or binding fields...

dave08

01/11/2023, 1:14 PM

That way part of the run time errors can be avoided.

dave08

01/12/2023, 2:23 PM

Boy @Toshihiro Nakamura, it's not so pleasant working with r2dbc CLOBs... on one hand, I need a Mysql LongText field, on the other it would have been MUCH easier to work with it as a Kotlin String...

dave08

01/12/2023, 2:24 PM

And anyways, it might break my jdbc to r2dbc adapter, since jdbc return java.sql.clob and r2dbc returns something else...

dave08

01/12/2023, 2:26 PM

It would have been great if

@KomapperColumn

would receive an extra parameter that allows to hard code the db type w/o inducing it from the field type...

dave08

01/12/2023, 2:39 PM

Even java.sql.Clob is just an interface... so for unit testing, I'd have to selectively use the h2 or mysql implementation, depending on which I want to run tests against, and I'd need to instanciate it to create fake data... for that, you need a connection and other things...!

dave08

01/12/2023, 2:41 PM

It would be MUCH nicer if all this could somehow be abstracted unless the user REALLY needs to deal with very large data stored in such a field -- in my case, I just need more than 255 characters, but NOT that much to have to go through the extra boilerplate code needed for Clob...

dave08

01/12/2023, 4:45 PM

I ended up writing my own data type that gets the clob as a string... but what about having a data type that depends on an annotation instead of a new class? Say:

@KomapperEntity
data class FooEntity(@KomapperType(ClobStringType::class) val sometext: String)

01/13/2023, 2:58 PM

What exactly is

returnGeneratedKeys

from the options here

onDuplicateKeyUpdate().multiple().options

supposed to do? The query still returns a single Long value. Essentially I'm trying to bulk insert and retrieve all IDs with postgresql

Toshihiro Nakamura

01/15/2023, 4:40 AM

Hi, everyone. Komapper v1.6.1 is out. We support MariaDB R2DBC and MySQL R2DBC from this version. Please give it a try. https://github.com/komapper/komapper/releases/tag/v1.6.1

01/15/2023, 4:59 AM

Hi, I haven't been able to find anything on this but how would I set up relations? Like I wanna have a

Guild

object that has a

MarkovConfig

dave08

01/15/2023, 1:41 PM

It might also be nice to generate a list or set of all of the contents of each Meta object in the Meta object. Often one would like to just create or drop all the tables in tests, and manually managing such a list is a bit error prone and extra boilerplate.

dave08

01/15/2023, 1:41 PM

Maybe like

Meta.all

Meta.allEntities

dave08

01/17/2023, 11:27 AM

Is there any way to use an existing Jasync connection to start a R2dbc komapper connection? We have a service we want to gradually migrate to Komapper and we don't want to have an extra connection pool open to the databases...

Title

dave08

01/17/2023, 11:27 AM

Toshihiro Nakamura

01/17/2023, 11:52 AM

Try to wrap your existing connection with ConnectionFactory:

val connectionFactory = object : ConnectionFactory {
    override fun create(): Publisher<out Connection> {
        // return existing connection
    }

    override fun getMetadata(): ConnectionFactoryMetadata {
        // ...
    }
}
val db = R2dbcDatabase(connectionFactory, H2R2dbcDialect())

dave08

01/17/2023, 11:54 AM

How do I do this with a JASync connection? (I'm really not too familiar with r2dbc api, and the docs are almost inexistant...)

Toshihiro Nakamura

01/17/2023, 12:04 PM

I am not familiar with JASync; doesn’t JASync Connection provide io.r2dbc.spi.Connection? You can convert io.r2dbc.spi.Connection to Publisher<out Connection> as followings:

flowOf(connection).asPublisher()

dave08

01/17/2023, 12:05 PM

https://github.com/jasync-sql/jasync-sql/wiki/Configuring-and-Managing-Connections

It has it's own connection object w/o r2dbc

View count: 4