kotlinlang #exposed

Hey, we just started using exposed in production and it is amazing. One question though, is it possible to use db lock in exposed? e.g. Mysql SELECT ... LOCK IN SHARE MODE or Mysql SELECT ... FOR UPDATE?

Pere Casafont

05/09/2018, 2:27 PM

oh I just found https://github.com/JetBrains/Exposed/issues/43, so @tapac is there any recommended way to work this around? Just a primary generated id and 2 foreign keys for now?

Pere Casafont

05/10/2018, 12:06 PM

another question, are there any plans to change the time libs from joda to java8?

Evgeniy Zaharov

05/11/2018, 10:11 AM

Hi! Does it possible to explicitly choose columns to select from DAO object?

Marcin Wisniowski

05/13/2018, 11:25 PM

Hello, I can't find how to do a comparison ignoring case, currently my code inside a

find()

Accounts.character eq character

. How do I make this case insensitive?

Marcin Wisniowski

05/14/2018, 5:51 PM

I'm using the DAO API, and I want to find objects based on something they reference, for example:

User.find { Users.city.name eq "London" }

This doesn't work, because I cannot access properties of the

city

reference this way, what's the correct way? This could be normally solved with a join, but I can't find anything on joins with the DAO API. I'm struggling to find a way that doesn't involve loading all the users from the database just to filter them in application code.

Marcin Wisniowski

05/17/2018, 12:01 AM

This might be a stupid question, but is this code ok?

User.find { Users.confirmed eq true }.sortedBy { it.loginTimestamp }.take(10)

It works, but is it efficient or does it load all users from the database? I'm not sure if the limiting and sorting is done inside the database, or in my code, it looks like it's done in my code, but I want it to happen as part of the query.

Tristan Caron

05/17/2018, 2:25 PM

Hello, I'm trying to build a query for

select count(distinct my_column) from my_table where my_other_column = true

I have started the fellowing, but I don't know I can achieve what I would like

Copy code

MyTable.select {
  MyTable.myOtherColumn.eq(true)
}.withDistinct().count()

Any ideas?

Chris

05/18/2018, 8:15 AM

Hello, I am trying to make a very simple query against an oracle database but no matter what I try I get

error occurred during batching: batch must be either executed or cleared

. Is there something I am missing. This is all I have:

Copy code

Database.connect("jdbc:oracle:thin:@localhost:1521/xe", driver = "oracle.jdbc.OracleDriver",user = "XXXX", password = "XXXX")
    transaction(java.sql.Connection.TRANSACTION_READ_COMMITTED,1){
       PaymentOption.selectAll().forEach { println(it[PaymentOption.paymentPlanCode]) }
    }

I am using Maven btw

Marcin Wisniowski

05/22/2018, 3:56 PM

Ok,

logger.removeLogger(Slf4jSqlLogger)

seems to work, but only for one transaction when put into that transaction.

Allan Wang

05/22/2018, 4:16 PM

Is there a DAO equivalent to the DSL insert ignore? Right now I have a helper function:

Copy code

fun <ID : Comparable<ID>, T : Entity<ID>> EntityClass<ID, T>.newOrUpdate(id: ID, update: T.() -> Unit): T {
    val existing = findById(id)
    return if (existing != null) existing.apply(update)
    else new(id, update)
}

But there is an unnecessary query if the entity isn't cached. This method aims to just end up with a new entity with the supplied id, regardless of whether it exists already

✅ 1

oshai

05/30/2018, 6:22 AM

Hi @tapac - we upgraded from exposed 9.0.1 to 10.0.2 and I think there is a memory leak. for example with 9.0.1 we have one instance of

org.jetbrains.exposed.sql.vendors.MysqlDialect

and with 10.0.2 we had 277725 instances when I took a memory dump. So it is either a leak or we are not using exposed as we should with the new version. Do you have an idea what can go wrong?

danielm

05/30/2018, 9:49 AM

what am I missing?

danielm

05/31/2018, 2:03 PM

Copy code

Production
                .innerJoin(Organization, { Organization.organizationId }, { Production.organizationId })
                .innerJoin(Performance, { Production.productionId }, { Performance.productionId })
                .slice(Production.name, Performance.date)
                .select { Organization.id eq organizationId }
                .orderBy(Performance.date)
                .distinct()
                .forEach {
                    println("${it[Production.name]}")
                }

danielm

05/31/2018, 2:04 PM

I want to get the distinct production names sorted by the first performance date for a given organization. But the code returns all production rows.

danielm

05/31/2018, 2:09 PM

I've also tried something like .distinctBy { Production } but here only one row is returned.

danielm

06/01/2018, 7:30 AM

Is there a reason why Exposed is (still) using joda-time?

Toby

06/01/2018, 10:20 AM

Hey guys, got a bit of an odd one here: I've got an exposed

date()

column (postgres

Date

) and I can store dates correctly in it. However, when I read from the database, it seems to create a DateTime with a one hour offset: Ie, I store

2018-04-27

in the db, it gets read as

2018-04-27T00:00:00.000+01:00

which is

2018-04-26

Damien

06/06/2018, 7:51 PM

I'm use the version 0.10.2 Yes, company is an UUIDEntity

BorzdeG

06/07/2018, 6:14 PM

Can I specify in Exposed that the query

Entity.all()

be sorted by default on the primary key? Now for each request, we have to write

Entity.all().sortedBy{ it.id }

Hamza

06/11/2018, 9:32 AM

can anyone help me set up a basic exposed datasource? I’m running with mysql on a digital ocean server

oshai

06/14/2018, 10:21 AM

I saw exposed 10.3 was released. Is there a changelog?