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?

1 reply · 2 participants

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?

2 replies · 2 participants

Pere Casafont

05/10/2018, 12:06 PM

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

1 reply · 2 participants

Evgeniy Zaharov

05/11/2018, 10:11 AM

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

2 replies · 2 participants

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?

2 replies · 2 participants

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.

2 replies · 2 participants

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.

2 replies · 2 participants

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

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

Any ideas?

4 replies · 2 participants

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:

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

2 replies · 2 participants

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.

6 replies · 2 participants

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:

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

1 reply · 2 participants

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?

10 replies · 2 participants

danielm

05/30/2018, 9:49 AM

what am I missing?

9 replies · 2 participants

danielm

05/31/2018, 2:03 PM

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]}")
                }

1 reply · 2 participants

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.

1 reply · 2 participants

danielm

05/31/2018, 2:09 PM

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

7 replies · 2 participants

danielm

06/01/2018, 7:30 AM

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

7 replies · 5 participants

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

3 replies · 2 participants

Damien

06/06/2018, 7:51 PM

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

10 replies · 2 participants

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 }

1 reply · 2 participants

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